python program update (quick update) (5 stars)

Completed Posted 1 year ago Paid on delivery
Completed

Have a program; can give you the source and just need a slight update?

The program is below; it counts the number of data rows in excel files in the folder passed

CURRENT OUTPUT

python3 [login to view URL] /Users/myfolder/

[login to view URL]

/Users/ej/pandas-output/[login to view URL]

[login to view URL]: 6 records.

[login to view URL]

/Users/ej/pandas-output/[login to view URL]

[login to view URL]: 165 records.

[login to view URL]

/Users/ej/pandas-output/[login to view URL]

[login to view URL]: 139 records.

DESIRED OUTPUT

python3 [login to view URL] /Users/myfolder/

/Users/ej/pandas-output/b1trt.xlsx....................................6 records.

/Users/ej/pandas-output/example.xlsx..........................165 records.

/Users/ej/pandas-output/example_croped.xlsx.............139 records.

is there a way you can see my desktop sand fix it ? CODE IS BELOW

let me know your thoughts and any questions

While this is hourly; there is a max of $12 that I can pay, as being a cancer patient is tuff and been out of work. Hourly will give you more $ as there is less money taken between us from freelancer

There is hope you can give your “best” price; unemployed, and have cancer with bills backing up, $12 possible? Glowing paragraph of feedback 5 stars

My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project:

SINCERELY WOULD BE NICE TO MEET YOU PLEASE

ANY THOUGHTS ? Please note project is due in two hours as this projects deadline, as this is needed if we can get some done - then we can talk about next steps and 5 stars and another job also. If this is a good one and we are "successful"; would need a couple others setup, but will handle one at a time? Can you do this for something reasonable in a couple hours? thoughts ?

HERE IS THE CODE TO MODIFY

import sys

import os

[login to view URL]("/Library/Frameworks/[login to view URL]")

import pandas as pd

def main():

if len([login to view URL]) < 2:

print("Please provide directory")

[login to view URL](0)

if not [login to view URL]([login to view URL][1]):

print("Please provide existing directory")

[login to view URL](0)

for filename in [login to view URL]([login to view URL][1]):

if [login to view URL]('.xlsx'):

print(filename)

file_path = [login to view URL]([login to view URL][1], filename)

print(file_path)

df = pd.read_excel(file_path)

#df = pd.read_excel(filename, engine='xlsxwriter')

print(filename + ": " + str(len([login to view URL])) + " records.")

if __name__ == '__main__':

Python Pandas

Project ID: #34757943

About the project

18 proposals Remote project Active 1 year ago

Awarded to:

maherserag

Hi there, I can fix this in a few minutes, contact me to do it now..................................

$7 USD / hour
(3 Reviews)
2.7

18 freelancers are bidding on average $9/hour for this job

abhishekkarna007

Hi. I am an experienced Python developer with over 5 years of experience. I understood the requirements and understand your situation as well. I can fix this for 12$ within an hour. Let's connect and get this done asap More

$12 USD / hour
(7 Reviews)
3.6
eslamafify

Hello Hope everything is well with you.I read your job description and I'm able to do it with good quality of work,I did such projects before. Let's discuss more details.

$15 USD / hour
(5 Reviews)
2.4
Khelifa90

Hello, i have good experience working with python, contact me to discuss more project details, thanks

$5 USD / hour
(6 Reviews)
2.2
stairovic940

I think that your script is scraping bot. I am very familiar with Python scraping. Please contact me for our project. I will update your script perfeclty.

$8 USD / hour
(1 Review)
1.5
vladyslavpiddub9

Hi, Erich B. I checked your post with title "python program update (quick update) (5 stars) ". I am familiar to Pandas and Python. I want to discuss your project in detail. please contact me Feel free to contact me More

$15 USD / hour
(1 Review)
1.0
jahanzaibkhan97

Dear Client, I can complete this task in a few minutes. Can you connect me to your laptop and run it for me once. I will make the amendments right away Looking forward to working with you

$3 USD / hour
(1 Review)
0.8
slimeone

Hi, there. I will write a Python script or one typical simple task. I have 8 years of professional experience with Python and an MS in Information Technology. I have a strong experience with pandas, numpy, lxml, bs4, More

$30 USD / hour
(0 Reviews)
0.0
rukshanlancer

Hi There, I am professional python developer with skills including Python and Pandas. Please send a message to discuss more about this project. Thanks

$15 USD / hour
(0 Reviews)
0.0
fstab

I am a highly experienced Python developer and have had to do this many times. For $10, I can send you a revision that will work on first execution right now.

$10 USD / hour
(0 Reviews)
0.0
puneethgp18

Hey buddy, Really sad it hear about the cancer, I hope you doing well, I have really good experience in pandas since I am using it for past 3 years as data analyst at tiger analytics and data engineer at latent view an More

$3 USD / hour
(1 Review)
0.2
hassaanahmad813

i am a python developer so let's try to solve it as i think the desired output is achievable. Your thoughts are welcome.

$2 USD / hour
(0 Reviews)
0.0
DanielVelezV

Hey, i can help you easily with this problem. im a Python, C# Java, Javascript programmer, i've dealt twith this types lf problems before.

$7 USD / hour
(0 Reviews)
0.0