Find Jobs
Hire Freelancers

Write a Python script to merge spreadsheets

$10-30 USD

Completed
Posted almost 6 years ago

$10-30 USD

Paid on delivery
I have three different spreadsheets and I want to merge the data into one spreadsheet. I imagine .CSV would be the best format to use, that is fine. The first spreadsheet has (among others), Country and cost in One currency. The second sheet has the number of sales, and country The third sheet has cost in a different currency an two letter country code. I want to merge all countries together, so the third sheet will need to lookup with perhaps pycountry, then merge all countries together. After merging create a new column called "total" and add currency 1 to currency 2 and put the result as currency 3. I will upload examples of the spreadsheets
Project ID: 17258794

About the project

19 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, can help you, since I am good in python, especially pandas ([login to view URL]).
$25 USD in 3 days
5.0 (9 reviews)
4.2
4.2
19 freelancers are bidding on average $22 USD for this job
User Avatar
Hello DataPower Team, Previously i have worked on 2 projects for you. I have checked the files and i can achieve this merging directly using Excel VBA script . I have 5 years experience in Excel VBA programming and can complete task within time with 100% accuracy.I am very responsible towards our clients. I know my client needs and importance. Skills : Excel, Macros,VBA,Web scraping,Web Search, Data entry, Copy typing, Transcription works,Wordpress,Megneto,Woocommerce,Shopify,Prestashop etc With Regards, Bhaskar.
$20 USD in 1 day
4.9 (241 reviews)
6.9
6.9
User Avatar
Hello sir, I read your project description and details about sample spreadsheets. I think I am right person for this job. I can merge these tables in to one for all. I am exprienced at using python language please check my reviews. I have finished all of the jobs those awarded to me. I’d like to help you. I am looking forward to hear from you soon. Best regards.
$35 USD in 1 day
5.0 (37 reviews)
5.4
5.4
User Avatar
Hi I am an expert programmer and proficient in python as this is part of my daily job. Please go through my profile and reviews so that you can be confident about me. Hope to chat with you soon Thanks Sajid Khan
$20 USD in 1 day
5.0 (41 reviews)
5.0
5.0
User Avatar
sure, I would be able to close it in about 2 days. iam a python specialist
$50 USD in 2 days
4.5 (33 reviews)
4.8
4.8
User Avatar
We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, SIMULINK, PSPICE, NS2, NS3 based IEEE papers. We can give remote support in Wintel, ADS, Unix, Storage, Backup, Network, Security tracks. Have experience in Active Directory, DNS, DHCP, FTP, IIS, SharePoint, CRM, SQL, WDS, ADRMS,ADFS,ADLDS, SCCM, Citrix Xenserver, Citrix XenApp, CRM,CRM Outlook connector IFD, Linux, Apache, My SQL, Postfix, VM Ware, Vcenter, VCO, VOIP (3CX)WHM, cPanel, H-Sphere, Hosting Controller, Plesk, DirectAdmin based web hosting support. We work in PHP, JAVA, ASP, DOT NET, Prestashop, Magento, woo commerce, OSCommerce, WordPress, Joomla, Web Hosting Panels Programming, LAMP, Android java development, Backend Server APIs, Android, Java, C/C++, Linux, PHP, MySQL, AJAX, JavaScript, C#, Visual Basic, PHP, MS SQL, My SQL, PHOTOSHOP, CSS, Bootstrap, HTML, JQUERY, JAVA, SCRIPT. We specialize in business, technical, academic, commercial, fiction, and Blog Writing, Dissertations, Academic papers, eBooks, Fiction, Sci-Fi thriller, Technical content, Articles, Web content, and blogs
$10 USD in 3 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Please don't hesitate to ask me if you are interesting and provide me full details on what you need me to do. Thanks. Best regards, Vasily A.
$20 USD in 2 days
5.0 (4 reviews)
2.9
2.9
User Avatar
I would be the best person for this work, I have a good knowledge with data mining, so can do this job
$25 USD in 1 day
5.0 (3 reviews)
2.8
2.8
User Avatar
Hai this is Gajendran, I’m having good experience in Data entry work. Based on your project description I will update all the details and provide you the best data, will complete this task within time limits. I’m interested in your project, kindly give an opportunity to do the same. Thanks in advance.
$30 USD in 1 day
5.0 (8 reviews)
2.0
2.0
User Avatar
Hello, I have been working in these fields and have done many projects. given an opportunity I would like to work for your project. I assure quality in my work and good responsiveness from my side. Thank you
$32 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked in Infosys for 2 years and have a training in Python from Infosys Mysore campus the worlds largest corporate university
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Is a sample python script If you can cost two hour end the work ,have more course and l i b s in web
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm new freelancer but i have 3 year professional experience in product company and i also did this type work. believe me I'll complete your requirement. Thanks,
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete the task within 1 days, simple to use , my expectation will be 25$ for this project, Looking forward working with you. Best Regard
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HONG KONG
Hong Kong, Hong Kong
5.0
197
Payment method verified
Member since Apr 21, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.