Build a Python Function: Save Dataframe to Excel in certain format / design (Pandas)
€30-250 EUR
Dibayar semasa penghantaran
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!
ID Projek: #26819257
Tentang projek
Dianugerahkan kepada:
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
11 pekerja bebas membida secara purata €137 untuk pekerjaan ini
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 n Lagi
Hi, I can develop the function for you today. Send me a msg and we can start right away. Thank You
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
* 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 Lagi
hello sir I am a python expert i can do this job message me so I can help you right now Regards Sharad
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.
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.
Hi, I have worked on automating excel formulas using python pandas and numpy. let me know about the project delivery.