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

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

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

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

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

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 More

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 More

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 More

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

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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 ( More

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 More

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 More