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

Ολοκληρωμένο Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

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!

Coding Επεξεργασία Δεδομένων Excel Python

Ταυτότητα Εργασίας: #17361475

Σχετικά με την εργασία

50 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

Ανατέθηκε στον:

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 Περισσότερα

£40 GBP σε 1 μέρα
(30 Αξιολογήσεις)
4.9

50 freelancers κάνουν προσφορές κατά μέσο όρο £122 για αυτή τη δουλειά

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 Περισσότερα

£250 GBP σε 3 μέρες
(605 Αξιολογήσεις)
8.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 Περισσότερα

£150 GBP σε 1 μέρα
(213 Αξιολογήσεις)
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 Περισσότερα

£133 GBP σε 5 μέρες
(94 Αξιολογήσεις)
6.5
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 Περισσότερα

£150 GBP σε 3 μέρες
(86 Αξιολογήσεις)
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 μέρες
(38 Αξιολογήσεις)
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 Περισσότερα

£100 GBP σε 1 μέρα
(19 Αξιολογήσεις)
5.0
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 Περισσότερα

£40 GBP σε 1 μέρα
(14 Αξιολογήσεις)
4.4
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 μέρες
(8 Αξιολογήσεις)
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 Περισσότερα

£111 GBP σε 1 μέρα
(1 Κριτική)
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 Περισσότερα

£250 GBP σε 2 μέρες
(4 Αξιολογήσεις)
3.9
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. Περισσότερα

£29 GBP σε 1 μέρα
(11 Αξιολογήσεις)
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 Περισσότερα

£30 GBP σε 1 μέρα
(18 Αξιολογήσεις)
3.6
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 Περισσότερα

£150 GBP σε 3 μέρες
(4 Αξιολογήσεις)
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 Περισσότερα

£83 GBP σε 3 μέρες
(10 Αξιολογήσεις)
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 Περισσότερα

£28 GBP σε 3 μέρες
(7 Αξιολογήσεις)
3.5
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 Περισσότερα

£75 GBP σε 2 μέρες
(1 Κριτική)
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 Περισσότερα

£100 GBP σε 1 μέρα
(7 Αξιολογήσεις)
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 Περισσότερα

£77 GBP σε 3 μέρες
(3 Αξιολογήσεις)
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 ( Περισσότερα

£100 GBP σε 3 μέρες
(1 Κριτική)
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 Περισσότερα

£100 GBP σε 2 μέρες
(0 Αξιολογήσεις)
0.0