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

Lengkap Disiarkan 3 tahun lepas Dibayar semasa penghantaran
Lengkap 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!

Python Excel Kejuruteraan Perisian Pemprosesan Data

ID Projek: #26819257

Tentang projek

11 cadangan Projek jarak jauh Aktif 3 tahun lepas

Dianugerahkan kepada:

EkoLike

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 dalam sehari
(13 Ulasan)
5.3

11 pekerja bebas membida secara purata €137 untuk pekerjaan ini

darrel131191

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

€250 EUR dalam sehari
(13 Ulasan)
5.8
Igorter

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 li Lagi

€100 EUR dalam sehari
(23 Ulasan)
5.8
privatecaptain

Hi, I can develop the function for you today. Send me a msg and we can start right away. Thank You

€225 EUR dalam sehari
(19 Ulasan)
5.2
sgadou

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 dalam sehari
(10 Ulasan)
4.8
BellaMenteInc

* 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

€100 EUR dalam sehari
(28 Ulasan)
4.6
haeckerzz

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 dalam 2 hari
(17 Ulasan)
4.3
sonatyres

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 dalam sehari
(3 Ulasan)
2.7
chaitanya818

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 dalam 7 hari
(0 Ulasan)
0.0
balasubramanya26

Hi, I have worked on automating excel formulas using python pandas and numpy. let me know about the project delivery.

€167 EUR dalam 2 hari
(0 Ulasan)
0.0