Suoritettu

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!

Taidot: Koodaus, tietojenkäsittely, Excel, Python

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Erfurt, Germany

Projektin tunnus: #17361475

Myönnetty käyttäjälle:

TetyanaS

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 Lisää

£40 GBP 1 päivässä
(24 Arvostelua)
4.8

61 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

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 Lisää

£250 GBP 3 päivässä
(275 arvostelua)
7.6
widadsaghir1993

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 Lisää

£150 GBP 3 päivässä
(65 arvostelua)
6.5
zekovicm

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 Lisää

£150 GBP 1 päivässä
(85 arvostelua)
6.8
£150 GBP 1 päivässä
(57 arvostelua)
6.2
qprotex

' 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] Lisää

£222 GBP 1 päivässä
(17 arvostelua)
5.8
£555 GBP 3 päivässä
(13 arvostelua)
5.8
£250 GBP 3 päivässä
(7 arvostelua)
5.3
TechnoGuruu

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 Lisää

£133 GBP 5 päivässä
(34 arvostelua)
5.0
archanaoswal

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 Lisää

£150 GBP 3 päivässä
(57 arvostelua)
5.4
MoAbd

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 Lisää

£111 GBP 2 päivässä
(31 arvostelua)
5.1
kamruzzaman36

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, Lisää

£48 GBP 3 päivässä
(31 arvostelua)
4.9
davidngo817

I am interested in your project. I have extensive experience in Python and R. Relevant Skills and Experience Python, R, Data analysis Proposed Milestones £150 GBP - 1

£150 GBP 3 päivässä
(7 arvostelua)
4.9
dinhfreedom

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 Lisää

£150 GBP 3 päivässä
(22 arvostelua)
5.3
aki003iitr

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 Lisää

£111 GBP 3 päivässä
(20 arvostelua)
5.1
mohamedadel4

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 Lisää

£50 GBP 1 päivässä
(10 arvostelua)
4.9
sszelag

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 Lisää

£100 GBP 3 päivässä
(2 arvostelua)
4.1
alexanderrubtsov

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 Lisää

£40 GBP 1 päivässä
(12 arvostelua)
4.2
DarkKnight2206

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 2 päivässä
(20 arvostelua)
4.7
RushService

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 Lisää

£130 GBP 3 päivässä
(13 arvostelua)
4.5
healthmonkey

Hey, I will help you transform your Excel data into a workable Panel Data Set. For the sake of simplicity I would recommend Python as it is superior to R in data manipulation. Relevant Skills and Experience I am a Da Lisää

£250 GBP 2 päivässä
(3 arvostelua)
3.7