Devam Ediyor

Python code to open an MS Excel file (xslx), transpose the data, and write it to a CSV.

I have a formatted excel document that i want to analyze in Python, but I need the formatting to be different. The worksheet has extra blank cells around the top and left sides, and the data are arranged as columns instead of rows. So for this project, I just need Python code that will:

1) Open an excel document (XSLX)

2) Read the data table from the worksheet

3) Transpose the data (make the rows into columns and columns into rows)

4) Write out the data table to a CSV file.

Beceriler: Python

Daha fazlasını görün: python excel transpose, transpose csv file python, transpose excel file python, open-table, transpose, python excel, python data, excel python, Excel Formatting, python read, code project python, table csv, data table excel, excel file columns, write file excel, excel data table, csv table, analyze csv file, read write data, open table, write excel code, csv file code, analyze file python, excel file transpose, project excel formatting

İşveren Hakkında:
( 25 değerlendirme ) Vienna, United States

Proje NO: #4387295

Seçilen:

suriyant

I can do it.

1 gün içinde 110$ USD
(2 Değerlendirme)
2.3

3 freelancer bu iş için ortalamada 103$ teklif veriyor

pbq

experienced python developer

1 gün içinde 100$ USD
(4 Değerlendirme)
4.0
neilmiller

I can do this project no problem

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0