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

Befejezett Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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!

Kódolás Adatfeldolgozás Excel Python

Projektazonosító: #17361475

A projektről

48 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

Odaítélve:

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 Továbbiak

£40 GBP 1 napon belül
(30 értékelés)
4.9

48 szabadúszó tett átlagosan 126£ összegű árajánlatot erre a munkára

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 Továbbiak

£250 GBP 3 napon belül
(654 vélemény)
8.6
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 Továbbiak

£150 GBP 1 napon belül
(214 vélemény)
8.1
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 Továbbiak

£133 GBP 5 napon belül
(95 vélemény)
6.4
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 Továbbiak

£150 GBP 3 napon belül
(86 vélemény)
6.0
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 napon belül
(38 vélemény)
5.6
novepi

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 Továbbiak

£100 GBP 1 napon belül
(19 vélemény)
5.0
lntrx

Hello, I don't know R but I know python well. I can write a script and that reads from file and create desired file for you. Believe me I did harder jobs. I can send the script and tell every line

£120 GBP 2 napon belül
(8 vélemény)
3.9
ThomThio

Familiar working with panel conversion data in Python. Relevant Skills and Experience Python, Excel, VBA, data cleaning and massaging Proposed Milestones £31 GBP - Commencement £80 GBP - Completion Additional Servic Továbbiak

£111 GBP 1 napon belül
(1 Visszajelzés)
3.8
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 Továbbiak

£250 GBP 2 napon belül
(4 vélemény)
3.8
cranius

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. Továbbiak

£29 GBP 1 napon belül
(11 vélemény)
3.8
Nabhanpv

Hi, I can complete your project. I'll be using python pandas to load in the excel files into a dataframe object and give column name to the year column and conserve rest of the column's names. Relevant Skills and Expe Továbbiak

£30 GBP 1 napon belül
(18 vélemény)
3.6
todool

Requirements for the project: Source excel files Relevant Skills and Experience I am an experienced Python programmer so like you said this is not too complicated. Proposed Milestones £28 GBP - A CSV file conform you Továbbiak

£28 GBP 3 napon belül
(7 vélemény)
3.5
kujin2018

hi i can do this using python or r studio. for example, in case of python, i can use pandas library. it is powerful. or r studio supports good packages for data processing. Relevant Skills and Experience python, r stu Továbbiak

£150 GBP 3 napon belül
(4 vélemény)
4.0
sinhprous

I have experience in processing data using Python (Pandas framework). Pandas is very efficient in manipulating excel data. Yes I will share you the script with comments, and support you to execute the code. I think I Továbbiak

£83 GBP 3 napon belül
(10 vélemény)
3.6
ngc604

I'd be happy to put together a python script that does this for you. In my experience tablib handles reading & writing excel or csv files really well & then it's just a matter of some formatting. Relevant Skills and E Továbbiak

£75 GBP 2 napon belül
(1 Visszajelzés)
2.7
eviong

I'm most comfortable coding in SAS, would be fastest. But if you do not have SAS, I can do python and R too so u can use in the future. 1. Code to import all the sheets 2. Try to do a loop for all the sheets to create Továbbiak

£100 GBP 1 napon belül
(7 vélemény)
2.7
nikolaistrimban

I will use pandas and Anaconda environment to do write this script. I work as a data scientist and do similar things all the time Relevant Skills and Experience As a data scientist and python developer, I crack simila Továbbiak

£77 GBP 3 napon belül
(3 vélemény)
1.7
rouabahabde

Hi, I am a full-stack developer with a Master's degree in IT and more than four years of experience in Python and JavaScript. Relevant Skills and Experience I am skilled in the following technologies: C, C++, Python ( Továbbiak

£100 GBP 3 napon belül
(1 Visszajelzés)
0.6
swappitweb

We are a web developing and designing company with various other facilities such as web content and digital marketing related to all types of specialisations. Additional considerations and implementations are assisted Továbbiak

£100 GBP 2 napon belül
(0 vélemény)
0.0
SEOexpert1121

Hello,. hope you are doing great.!! My name is Abdur Rahman, I have read your project description very carefully however it was not that long. :) I always maintain long term relation with my clients Relevant Skills an Továbbiak

£150 GBP 3 napon belül
(0 vélemény)
0.0