Sedang Disiapkan

Quick combination of ~350 identically-formatted .xls files

I have around 350 .xls files that are identically-formatted. They are monthly measures of state and local financial bond prices from the 1970s to 2012. They each have around 1000 rows and 30 columns.

I need them all combined into the same .csv file. (I prefer .csv to .xls.) They each have a header row, but I only need one header row in the combined document.

I will pay $30 USD for someone to do this for me, and if you are skilled, I predict that this will take very little time. I would prefer that it be done in R or Python, but Visual Basic is OK as well. And I request that you send me your code when you finish, so that I can learn from it. (Note that if the code scrapes the entire sheet, and you then manually remove the extra header rows, that's fine with me -- the code doesn't need to be elegant, I just want to see it.)

I need it back in 6-8 hours (TODAY).

I am attaching three of the spreadsheets as an example.

Kemahiran: Python, Visual Basic

Lihat lebih lanjut: xls files combination, xls header, xls, bond, xls visual basic, little python, formatted, example visual basic, python remove file, Basic python, remove header files, xls code, quick note, xls remove, quick pay, header 1000, csv prices, hours python, finish python code, csv python, quick around, visual basic python, visual basic csv, send scrapes, quick today

Tentang Majikan:
( 3 ulasan ) Berkeley, United States

ID Projek: #1543626

Dianugerahkan kepada:

bkspace

Please check the PM, 3 questions attached.

$30 USD dalam sehari
(1 Ulasan)
1.2

6 pekerja bebas membida secara purata $30 untuk pekerjaan ini

intellisense1

Respected madam, i am ready to do this project for you. Kindly accept my bid. Thanks

$30 USD dalam 0 hari
(29 Ulasan)
6.1
northwolves

Ready to [url removed, login to view] PMB please.

$30 USD dalam 0 hari
(27 Ulasan)
4.5
dasf

I have previous experience in manipulating excel files in Python.

$30 USD dalam 0 hari
(10 Ulasan)
4.3
Teloquence

Excel expert at your service. Check your inbox for details.

$30 USD dalam 0 hari
(9 Ulasan)
3.6
PG89

Hi, Please Check PMB

$30 USD dalam 0 hari
(0 Ulasan)
0.0