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

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 and Experience Examples of my projects in R (I want to use R): [login to view URL] [login to view URL] [login to view URL] Proposed Milestones £40 GBP - The project I prefer to use R. I think create many DataFrames and the merge these DataFrames.

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% client satisfaction. Proposed Milestones £250 GBP - Merging and transforming excel data into panel data format with python or R

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 everything about me. Proposed Milestones £150 GBP - / Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

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 macro Proposed Milestones £150 GBP - Automation of the file I will provide the code to you so that you can use that in future also. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such automation projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Peter

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 well versed with such kind of data transformation Proposed Milestones £150 GBP - Completion of work I have completed complex projects in Excel before. For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana

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 and Experience python,automation Proposed Milestones £100 GBP - Final delivery

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 Services Offered £35 GBP - Visualization of data

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 Data Scientist and Statistical Programmer with a background in quantitative finance. Data manipulation is a large part of my work and I merged data sitting in different Excel tabs already. Proposed Milestones £250 GBP - Milestone I will provide the code used for the manipulation, this code is readable and most importantly reproducible. I do speak German fluently - so we could speak German as well to make communication easier. See my reviews to see my past work and to get an impression how I work with my clients.

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. Thanks for the attention.

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 Experience I'll then use universal slicing to add the year column to every row. Each of the sheet's tab will be processed in a loop and added to the end of the yet processed table resulting in a single table. Proposed Milestones £30 GBP - Project payment

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 your specification which you can in put in every excel version. Python program. The program will be written in Python 3.

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 studio, data science Proposed Milestones £150 GBP - completion

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 can do the work within one day.

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 Experience I have 8 years of professional python experience, most of that time was spent building tooling to support researchers. Proposed Milestones £75 GBP - Delivery of appropriately formatted excel file & python script.

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 a new column that is filled up with the name of sheet like Alabama 3. Check if all columns are same of each sheet 4. Append all sheets to get a table I'm a new freelancer but do give me a chance! I will do my best (:

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 similar problems every day, it won't be a problem for me to implement this thing Proposed Milestones £77 GBP - Complete work

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 (Flask, Flask RESTful, Django, DRF) NodeJS, ExpressJS, Angular, ElectronJS PostgreSQL, MySQL, SQLite, MongoDB Proposed Milestones £125 GBP - milestone How would I approach this problem? I would first read the data and save it to data-structures (lists, tuples or dictionaries) then generate a new file with the desired structure. If this is a repetitive case I could develop a small web page using Flask framework (Python) where you upload the file, it then changes it to the desired format and shows it in the page with the possibility to download it as an excel. I am certain that you will be very pleased with my professional work and you can check my recent reviews for more details. Kindly yours.

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 concerning the requirement of the work. We specialise in content writing and its types such as academic and blog writing for UK, US, Australia, Singapore and other countries. Our diverse functions in various fields include: 1. Website Designing 2. Website Development 3. SEO & Digital Marketing 4. Android Application Development 5. iOS Application Development 6. Content Writing Our assured services *Punctual Work *24/7 Availability *Plagiarism Free Work *Free suport and assistance *Uncompromised Quality

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 and Experience Coding, Data Processing, Excel, Python Proposed Milestones £150 GBP - project milestones