Merging and transforming excel data into panel data format with python or R

The original data set is an excel file with information about 117 countries over time (1970-2013) and 40 variables per country and year. Each country's information is within one tab of the excel spreadsheet, ordered by year and then columns for each variable. I need this in one large table in panel data format (column 1: country; column 2: year; column 3...: variables). In Python or R (or whichever computer software you like to do) this should be relatively quick and easy to do. A screenshot shows the original excel file (tabs=countries), and another screenshot the desired panel data format. NO HAND CODING OR MANUAL COPY PASTING. I will need to see the code you used.

Please describe in your bid how you would go about the task (which software; a little bit about your coding approach), and confirm that you will share the (commented) script with me for replication. Please if you plan to copy paste don't bid because I can do that myself - I want to automate it and avoid human error. I work in R but I have colleagues working in Python as well. I don't care about the exact software. Thanks!

Skills: Coding, Data Processing, Excel, Python

See more: excel macro format phone numbers, excel sheet marketing research survey data entry, converting excel label format, csv format yahoo finance data, copy excel spreadsheet format, excel dont format automatically comma separated data, excel vba format data series, excel format input work data staff months, extract data excel real time python, python web data excel, create excel format automatic update data, freelance python r data minng, how a freelancer in python programming can earn in a month, i need a programmer in python, writing to a file in python, Hadoop,Big data,Python,R,SQL, python econometric data R, GIS OR Python OR Data analyst OR GPS OR R

About the Employer:
( 1 review ) Erfurt, Germany

Project ID: #17361475

Awarded to:


I've got 9 courses of Data science specialization and 5 courses of Python specialization at Coursera ( for example: R programming, Regression models, Machine learning and Developing data products) . Relevant Skills an More

£40 GBP in 1 day
(27 Reviews)

58 freelancers are bidding on average £123 for this job


Hello Sir, I have reviewed your job details and I am sure i can deliver you the job with you satisfaction. Relevant Skills and Experience Please go through my profile i have deliver more than 360 projects with 100% c More

£250 GBP in 3 days
(313 Reviews)

Hi there, I can merge this data with either Python or R,whatever you feeling more comfortable . Relevant Skills and Experience Check out my profile, portfolio, and former clients feedback - that'll let you know everyt More

£150 GBP in 1 day
(109 Reviews)

Hello sir. AS a math and python/R developer, I'm glad to see your project. Please check my profile if you give me your project, i will send perfect script with comments. Relevant Skills and Experience As you can see i More

£150 GBP in 3 days
(85 Reviews)
£150 GBP in 1 day
(81 Reviews)

' Relevant Skills and Experience ' Proposed Milestones £222 GBP - Milestone Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] More

£222 GBP in 1 day
(17 Reviews)

Commented codes will be provided in R. An algorithmic approach will be used to identify relevant information and then tabulate it since it is not in a tabular format and has blanks Relevant Skills and Experience I am More

£111 GBP in 3 days
(35 Reviews)

As you want to merge all these tabs in one large tab having first column of country, second as year and rest all data. I will do the same for you. I will use Excel VBA macro. Relevant Skills and Experience Excel, VBA More

£133 GBP in 5 days
(55 Reviews)

I can use Excel VBA code to achieve the data transformation. I will also make sure that the code is well commented before I share it with you Relevant Skills and Experience I have excellent command on Excel VBA and I More

£150 GBP in 3 days
(76 Reviews)

change data in excel file from multiple tabs to one huge dataset with multiple columns Relevant Skills and Experience I can do it using python and pandas library , this is a super easy task for me I am a data scient More

£111 GBP in 2 days
(33 Reviews)
£555 GBP in 3 days
(15 Reviews)

Hi, I am very happy to put my bid on your project. I know you want to merge all information of every country and every years as one tab of spreadsheet by python. Relevant Skills and Experience Data Mining, Data Proces More

£150 GBP in 3 days
(30 Reviews)
£250 GBP in 3 days
(10 Reviews)

I am very much interested in your project.I will do this copy paste work [login to view URL] you will hire me I will complete it 100% accurately.I am waiting for your message. Thank You Relevant Skills and Experience Coding, More

£48 GBP in 3 days
(38 Reviews)

Hello sir, I can write the script for joining the excel file tabs in the format you desired right now also i do not mind if you want to have the script code i used. I can start immediately,Thanks Relevant Skills and E More

£50 GBP in 1 day
(10 Reviews)

Hello! I am a python developer. I looked at your project and it seems interesting. I have all necessary skills required for this project. Ping me to discuss in detail.

£125 GBP in 2 days
(24 Reviews)

As I understand, what is needed is to stack several sheets into one big sheet. If you like I may do it with Python, but as the source is in Excel I would propose to use Excel VBA macro instead. Relevant Skills and Exp More

£40 GBP in 1 day
(13 Reviews)

Feel fee to contact me for Merging and transforming excel data into panel [login to view URL] me message to discuss further more details . Relevant Skills and Experience Coding, Data Processing, Excel, Python Proposed Milest More

£130 GBP in 3 days
(19 Reviews)

Hi, i'm interested in this job and my first choice would be to implement this in JS using [login to view URL] however if you need this to be written in python I can do that as well. Relevant Skills and More

£100 GBP in 3 days
(2 Reviews)

Hi, The task is quite clear, supported with the images attached, so no questions. I'll use py2 branch, if you prefer instead py3 branch please let me know. It'll be ready within a few hours, thanks. Relevant Skills a More

£100 GBP in 1 day
(7 Reviews)

Hi there, I can develop this as an Excel macro and deliver to you on the same day. Can you please send me sample so I can demonstrate? I will provide you the code also. I am at your disposal to discuss on chat. More

£29 GBP in 1 day
(11 Reviews)