Find Jobs
Hire Freelancers

Build a Python Function: Save Dataframe to Excel in certain format / design (Pandas)

€30-250 EUR

Completed
Posted over 3 years ago

€30-250 EUR

Paid on delivery
Hi there, we would like to hire a freelancer to create a certain function. The function receives a dataframe with up to 4000 rows, a path to a preformatted excel file (see: "Design" file attached), a target path where the result should be saved, a filename, and a sheet name. The expected result: the unformatted data of the dataframe (simply read in "[login to view URL]" as dataframe) should be saved in exactly the same design as the "Design" file. The "Design" Excel file is located on a path which is given as a string. It is important that filtering is activated and the rows look exactly the same. So, the created .xlsx file within the targetPath should look exactly the same as "Industrie [login to view URL]" (see attached). Also the sheet name should be named as given in "sheetname" within the function. The name of the file should be as given in the "filename" parameter. def to_excel(input : [login to view URL], inputDesignPath: str, targetPath: str, filename: str, sheetname : str): --> ....to_excel()... Completion until tomorrow would be highly appreciated. Please carefully test your results: use the input file and design file and compare the results with the also uploaded "Industrie [login to view URL]" file. Filtering should work, also when you try out a dummy Input with hundreds of entries. Everything should look exactly the same as in the "Industrie [login to view URL]" file. Also, the index numbers from the dataframe input (27, 28, 29) shouldn't be included. Best Regards & Thanks in advance!
Project ID: 26819257

About the project

11 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello. How are you? i am expert in python excel fields i will use for your projext just pandas, openpyxl or xlswriter if you agree let's open chat and talk more
€100 EUR in 1 day
5.0 (13 reviews)
5.3
5.3
11 freelancers are bidding on average €137 EUR for this job
User Avatar
Hi there. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional python developer, I ensure for a perfect ongoing project. You will never be disappointed in me for sure. Looking forward to meeting you on chat. Good luck. Thank you.
€250 EUR in 1 day
5.0 (13 reviews)
5.8
5.8
User Avatar
thanks for your project posting in advance. This is a senior python programmer, I am good at python pandas dataframe and excel import/export. I have developed many projects with excel and can show you the demos. I'd like to discuss the details via chat. Regards. Vadim
€100 EUR in 1 day
5.0 (23 reviews)
5.8
5.8
User Avatar
Hi, I can develop the function for you today. Send me a msg and we can start right away. Thank You
€225 EUR in 1 day
4.5 (19 reviews)
5.2
5.2
User Avatar
Hi, there. I am a data scientist with 5+ years of hands-on experience in Python. Carefully checked your requirements, I think I am capable of doing this job. Hope to have a chance to discuss. Best regards, Sgadou
€150 EUR in 1 day
4.9 (10 reviews)
4.8
4.8
User Avatar
* We will deliver the project by tomorrow" Hi, We have team of ACM-ICPC Finalists and Competitive Programmers and have stronghold in Python, Java, Computer Vision, NLP and Optimization algorithms. We can guarantee you the project completion after discussing details about the project. If you are interested, Shall We discuss details about the project? About Us: Competition Expert on Kaggle Competition Expert on Codeforces ACM-ICPC Regional Rank - 32 Winner of more than 10 Programming & Data Science based contests. We have started working on freelancer recently but we are already providing our services to our clients based in USA, UK, India, UAE, KSA. We assure you a 100% quality work, Please feel free to connect on private chat. Regards, BellaMenteInc
€100 EUR in 1 day
4.7 (28 reviews)
4.6
4.6
User Avatar
hello sir I am a python expert i can do this job message me so I can help you right now Regards Sharad
€30 EUR in 2 days
5.0 (17 reviews)
4.3
4.3
User Avatar
I have understood your project and I have good knowledge of python. I can do the needful work same as you want. I can start working on it immediately.
€50 EUR in 1 day
4.0 (3 reviews)
2.7
2.7
User Avatar
Hi, I am Chaithanya. I have been completed MBA in Finance also I have 4 years of experience in MIS reporter. Could you please provide me the work.
€140 EUR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have worked on automating excel formulas using python pandas and numpy. let me know about the project delivery.
€167 EUR in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Munich, Germany
5.0
1
Payment method verified
Member since Aug 3, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.