I have a Python script that partially works to load in three spreadsheet files and merge them together based on country and save them as a new spreadsheet file. At the moment it displays each country multiple times but what I want it to do is merge all the countries together. For example
germany, 1, germany, 7
germany, 2, germany, 5
germany, 3, germany 4
I want to display the sum of each column and merge the same country rows and remove superfluous columns
so it might end up like
germany, 6, 16
i.e. Only one row for germany, the second country column removed and the other two column values for germany added up.
Sample Data will be given to appropriate candidates
21 freelancers are bidding on average $71 for this job
Hi there! I have experience using python plus all of the scipy modules including pandas. If you want we can try some examples or tests before hiring... Good luck!
Hello sir, Just contact with me and I will fix it. I am a computer science student and python programmer. I have done similar works before. I can complete this within shortest time. Thank you
I can do this task within some hours. I do data wrangling in a daily basis with Python and R at workplace (I am a Bioinformatics Postdoc with several publications).