Đã Đóng

R script to merge & clean-up tabular data from 13 governmental reports #medicines

pmprb.R collects tables with the lists of Patented Drug Products from 13 annual reports of the Patented Medicine Prices Review Board.

The task is to reorganise this information into a single dataframe.

The main challenge is that the tables for years 2004 & 2012 are extracted from a pdf format (only available), while others - from html tables. Therefore the 13 tables to be merged are not of identical format when read into R.

All tables, however, contain consistent/similarly-structured information, even though some years have more information (additional columns) than others.

The merged dataframe should contain only 7 columns:

[url removed, login to view]

Company

DIN

[url removed, login to view] (data only available until 2009)

ATC (data only available until 2009)

Status

[url removed, login to view]

Resulting dataframe must then be merged with [url removed, login to view] by.x = “[url removed, login to view]”, by.y = “DrugName”. This is the final product.

The final deliverable must be an R script returning the dataframe described in the paragraph above.

Please first submit your budget & the timeframe/delivery time for the project. I shall then get back to you shortly to inform you if your bid is accepted or not.

Thank you!

Kĩ năng: Xử lí dữ liệu, Ngôn ngữ lập trình R

Xem nhiều hơn: rbind multiple files in r, flextable r, r merge multiple data frames by column, readbulk r, read multiple csv files in r using for loop, how to merge multiple csv files into one in r, merge multiple text files in r, import multiple csv files into r, script historical quotes finance data, clean parts data base, php script merge pdf, vbs script merge text file, source script merge text files, application pull tabular data websites, php script merge pdf withanother pdf

Về Bên Thuê:
( 8 nhận xét ) Frankfurt, Germany

ID dự án: #15983376

21 freelancer đang chào giá trung bình €43 cho công việc này

suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Thêm

€75 EUR trong 3 ngày
(46 Nhận xét)
6.1
TetyanaS

Hello! I am Tanya from Ukraine.
 I have done more than 50 works in R for another clients (UpWork and Freelancer). 
I've got 9 courses of Data science specialization at Coursera (Data Science Tools, R programming Thêm

€38 EUR trong 3 ngày
(23 Nhận xét)
4.9
prajwalbhatt

I am Prajwal Bhatt, a final year undergraduate student at IIT Roorkee. I am a creative, flexible and focused individual who is passionate about Data Science, Natural Language Processing and the entire Analytics space. Thêm

€30 EUR trong 1 ngày
(26 Nhận xét)
4.9
€80 EUR trong 2 ngày
(17 Nhận xét)
4.5
blakehamm

With 2+ years in data cleaning and piloting of successful r projects, I am an ideal candidate to complete this project. I will display exemplary quality while satisfying all of your project needs. Skills that pertai Thêm

€70 EUR trong 2 ngày
(5 Nhận xét)
3.3
manutejsharma

Hi. I have been using R since past 3 years and I have implemented many bioinformatics models using it. Coincidentally, I have been pruning drug-related data. I am sure that I can help you with your project. Kindly le Thêm

€34 EUR trong 1 ngày
(2 Nhận xét)
2.6
altunlueng

Hello, I'm a data scientist for 3 years of experience. I often use R and python for my work. I can finish your task in 2 days with the table you demanded and a r script. Sincerely

€133 EUR trong 2 ngày
(1 Nhận xét)
2.2
Corskeagh

I have extensive experience in R programming, data cleaning and collating "messy" data from multiple sources.

€34 EUR trong 2 ngày
(1 Nhận xét)
1.3
€23 EUR trong 1 ngày
(0 Nhận xét)
0.0
oscarlucca

Hi, I just have written an R script to merge data frames. Having a common column of data among different data frames is a must to merge them. I'm working on pdf's info extraction. Looking forward to hearing from Thêm

€50 EUR trong 5 ngày
(0 Nhận xét)
0.0
pavanarava438

Hi, I have overall 6+ years of experience and mainly into Predictive Modelling. To build a Statistical/Predictive Model, we used to spend almost 80% of time only on data slicing and dicing. Worked on many projects whi Thêm

€24 EUR trong 2 ngày
(0 Nhận xét)
0.0
HALcat1974

Dear Sir, I have more than 15 years of experience as bioinformatician. Your project looks, a priori, easy. One of my major problems is to merge and structure information from different databases (global system biolo Thêm

€23 EUR trong 10 ngày
(0 Nhận xét)
0.0
apacherai

A proposal has not yet been provided

€34 EUR trong 1 ngày
(0 Nhận xét)
0.0
sravyaD

A proposal has not yet been provided

€34 EUR trong 5 ngày
(0 Nhận xét)
0.0
snaciri81

A proposal has not yet been provided

€55 EUR trong 5 ngày
(0 Nhận xét)
0.0
€23 EUR trong 1 ngày
(0 Nhận xét)
0.0
misavasiljevic

I have written master thesis about R programming language and data preprocessing. I think I can do what you asked for.

€29 EUR trong 2 ngày
(0 Nhận xét)
0.0
ykakde

I am ready to work for your project. I have worked on many applications based on R programming language. I am not expert in text mining but I will definitely complete your work within 5 days. I am only saying what I Thêm

€24 EUR trong 5 ngày
(0 Nhận xét)
0.0
sahemo

I am familiar with a package which reads tables from pdfs and htmls. I have also done some data extraction with tabula package earlier.

€34 EUR trong 2 ngày
(0 Nhận xét)
0.0
Rizwan494

hi, please share more details so that i can review & start your project easily. i can do it easily Looking forward

€23 EUR trong 1 ngày
(0 Nhận xét)
0.0