Find Jobs
Hire Freelancers

Combine excel files using Python

$30-250 AUD

Annullato
Pubblicato più di 6 anni fa

$30-250 AUD

Pagato al completamento
I would like two (related) python scripts to be created: 1. Combine multiple excel files into a single file 2. Add the contents of an additional file onto the bottom of an existing combined file 1. Combine files: a. Script should take multiple files in a target folder b. In each file, look for worksheets with a target name (“Stock” in the examples) – and ignore all other worksheets c. Take the data in the target worksheets in each file and combine all the rows together into a single file. d. When doing this: i. Two extra columns should be inserted into the Combined file: ii. Column A should have the full file name which the row of data came from iii. Column B should have the file name which the row of data came from, but excluding the file extension (e.g. excluding “.xls”) e. When the files are combined together, the data should be matched with the correct column heading – i.e. data in the “Store B” data in each original file should be stored under the “Store B” column in the Combined file, even if the Store B column moves around in the original files (as it does in the example files) f. Where a column is present in one file (like Store E) but not in the others, it should still be added to the master g. Likewise, where a column is absent in one of the original files – the column should be left blank h. The cell formatting should be merged with that of the example “Combined” file i. The output should be saved as “Combined Complete” 2. Add the contents of an additional file onto the bottom of an existing combined file a. A second version of this script would allow a single target file to be added to the bottom of an already combined file Scripts should be able to run using Python 2.7 from Sublime and Jupyter notebooks – please advise which modules need installing
Rif. progetto: 15143642

Info sul progetto

33 proposte
Progetto a distanza
Attivo 7 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
33 freelance hanno fatto un'offerta media di $166 AUD
Avatar dell'utente
Hello sir I am interested in this job and can start the work immediately. I have handled so many excel files with python. I am confident with this job. Regards, Zhang Relevant Skills and Experience I have 7 years experiences of python and pandas would be useful in this job. Proposed Milestones $222 AUD - completion of the project.
$222 AUD in 3 giorni
4,9 (125 valutazioni)
7,6
7,6
Avatar dell'utente
I can create such Python 2.7 scripts using pyexcel. All I need to start is few more samples from you. Relevant Skills and Experience I have worked on similar (merge Excel files) projects before so I know what do you want. Proposed Milestones $200 AUD - Python script to merge Excel files
$200 AUD in 2 giorni
4,9 (401 valutazioni)
7,7
7,7
Avatar dell'utente
Hi,alwynjohnson! I can create python script, that will pull data from excel, manipulate it and save to one file. I'll use pandas library for this. I can provide both .py file and Jupyter notebook . Relevant Skills and Experience More then 7 years of data science experience,hundreds of similliar scripts Proposed Milestones $242 AUD - Full done Regards, Vlad
$242 AUD in 2 giorni
5,0 (19 valutazioni)
7,4
7,4
Avatar dell'utente
Greetings sir, i am an expert freelancer for this job. I can do your project Combine excel files using Pytho with your 100% expect ion. Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Python. Proposed Milestones $180 AUD - one Combine excel files using Python done
$180 AUD in 3 giorni
4,9 (97 valutazioni)
7,0
7,0
Avatar dell'utente
I will provide a RUBY script for you. Ruby is faster than python for such tasks. I will provide a script which will merge with the necessary criteria. Relevant Skills and Experience I've did a lot of jobs of data entry already, what means that I can work well with XLS files. I am skilled in building fast filter algorithms so the bot will be very fast operating. Proposed Milestones $97 AUD - Project Goal Please provide further instructions so I can start the work!
$97 AUD in 2 giorni
5,0 (27 valutazioni)
6,0
6,0
Avatar dell'utente
Hi, I would like to help you with your Python project. You can rely on me. I am an experienced developer. Looking forward to hear from you. Best regards, Oleg Relevant Skills and Experience I am skilled at Python. Proposed Milestones $244 AUD - Python script Thank you for reading this letter.
$244 AUD in 3 giorni
5,0 (32 valutazioni)
6,0
6,0
Avatar dell'utente
A proposal has not yet been provided
$166 AUD in 4 giorni
5,0 (42 valutazioni)
6,0
6,0
Avatar dell'utente
Hello, Greetings! With a proven track record of successful achievements, I am pleased to present my application for your consideration as a Freelancer. Relevant Skills and Experience Please have a look at my profile and portfolio to get an idea about our capabilities and some previous work on freelancer. Proposed Milestones $100 AUD - This bid is approx. I’ll give you exact budget and price once discussing in details with you. Many Thanks & Regards, Rishi A.
$100 AUD in 2 giorni
5,0 (55 valutazioni)
5,5
5,5
Avatar dell'utente
Hi I am Master of Computer Science and have 7 years of research and writing experience. I have worked on PhD level thesis projects, published papers in peer reviewed journals Relevant Skills and Experience I have very good programming skills, in python, java, R and C languages. Proposed Milestones $250 AUD - a
$250 AUD in 3 giorni
4,1 (28 valutazioni)
6,0
6,0
Avatar dell'utente
Hello, I'm Python developer and I'm perfect for your task. I do stuff like this :) Check my reviews and you will see that. Contact me now and let's talk.
$263 AUD in 5 giorni
5,0 (19 valutazioni)
5,1
5,1
Avatar dell'utente
Hi: I can create a Python script for this using pandas module. I will read the files using pandas and then merge these datasets. Relevant Skills and Experience I am an expert in Excel and Python for web scrapping and automation. I always take my projects to completion and have ~100% completion rate, ~5-star feedback on projects and >30% rehire rate. Proposed Milestones $150 AUD - Payment to be done only after 100% project completion Is there any formatting to be done in the final Excel?
$60 AUD in 3 giorni
5,0 (5 valutazioni)
4,9
4,9
Avatar dell'utente
Nice to see you, alwynjohnson. do you need two (related) python scripts to be created: 1 ?.I can help you We have skills: Python I will completed on time, Do this project by the best way and fast way, make you feel happy when working with us If you want a good and fast service, please text me via inbox Relevant Skills and Experience Python Proposed Milestones $20 USD - for starting project We can Discuss custom Milestones
$165 AUD in 1 giorno
5,0 (10 valutazioni)
4,5
4,5
Avatar dell'utente
Hi I'm specialized in Python. There are a few python libraries for excel. Regards, harupy
$50 AUD in 2 giorni
5,0 (43 valutazioni)
4,3
4,3
Avatar dell'utente
Hi, I am an undergraduate with years of experience in programming. I have made many applications in Python 2.7 for excel file manipulation using libraries such as openpyxl(for xlsx) and xlwr,xlrd(for xls files). I also have made GUIs for convenience of the programs. With my knowledge and experience I am sure that I can complete this task covering all the requirements needed.
$35 AUD in 1 giorno
4,9 (7 valutazioni)
4,0
4,0
Avatar dell'utente
missing some files.. also I would like to take this project and do my best for you by using python 2.7 and anaconda 2 would be the best to run the scripts in Jupiter notebooks. Relevant Skills and Experience Python Proposed Milestones $155 AUD - final payment
$155 AUD in 5 giorni
5,0 (2 valutazioni)
3,9
3,9
Avatar dell'utente
Two variants: First - openpyxl library for Excel parsing Second - pandas for dataframes. Both of this variants will work, but second will be a bit more stable and error-prone. Cost is same. Relevant Skills and Experience Excel parsing by Python, Pandas Proposed Milestones $150 AUD - Two scripts for Python 2.7 and ready-made file examples. None.
$150 AUD in 3 giorni
5,0 (1 valutazione)
4,1
4,1
Avatar dell'utente
I have been working with python for quite some time now. I think this is a good fit for me as I have already done some work on reading and writing excel files. Relevant Skills and Experience Python Proposed Milestones $200 AUD - Full project delivery In the description you mentioned example files but I can only see one file.
$200 AUD in 3 giorni
5,0 (4 valutazioni)
3,4
3,4
Avatar dell'utente
Deliver 2 python scripts in 3days at $250AUD cost. (Assuming the combination only involves copying of cell values) Milestones: 1. $150 AUD: script that combines excel files from specified target folder 2. $100 AUD: script that appends a target excel file to an existing combined file
$250 AUD in 3 giorni
5,0 (4 valutazioni)
3,4
3,4
Avatar dell'utente
Hi my name is Enrique. I have wide experience in Python specially 4 previous projects formatting Excel files using Python. My last project was pretty similar to your project and I would like to participate on it.
$242 AUD in 3 giorni
4,5 (11 valutazioni)
3,9
3,9
Avatar dell'utente
I can combine the Excel data into a Combined file in Python. I am comfortable coding in Python and have done many projects with Python/Django. I am currently in Rayleigh,USA. Relevant Skills and Experience Python, APIs Proposed Milestones $30 AUD - After creatinf the combined file $25 AUD - After adding the second file to the Combined file
$55 AUD in 2 giorni
5,0 (2 valutazioni)
3,2
3,2

Info sul cliente

Bandiera: AUSTRALIA
Surry Hills, Australia
0,0
0
Metodo di pagamento verificato
Membro dal ott 4, 2014

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.