Merging and transforming excel data into panel data format with python or R
£20-250 GBP
Πληρώθηκε κατά την παράδοση
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!
Ταυτότητα Εργασίας: #17361475
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
50 freelancers κάνουν προσφορές κατά μέσο όρο £122 για αυτή τη δουλειά
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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.
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 Περισσότερα
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 Περισσότερα
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
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 Περισσότερα
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 Περισσότερα
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. Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 ( Περισσότερα
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 Περισσότερα