Suljettu

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!

Taidot: tietojenkäsittely, R-ohjelmointikieli

Näytä lisää: 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, vbs script merge text files, drupal tabular data, script retrive yahoo finance data csv, script read yahoo financial data, script php clean html

Tietoa työnantajasta:
( 8 arvostelua ) Frankfurt, Germany

Projektin tunnus: #15983376

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

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 Lisää

€75 EUR 3 päivässä
(46 arvostelua)
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 Lisää

€38 EUR 3 päivässä
(23 arvostelua)
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. Lisää

€30 EUR 1 päivässä
(26 arvostelua)
4.9
€80 EUR 2 päivässä
(17 arvostelua)
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 Lisää

€70 EUR 2 päivässä
(5 arvostelua)
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 Lisää

€34 EUR 1 päivässä
(2 arvostelua)
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 2 päivässä
(1 arvostelu)
2.2
Corskeagh

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

€34 EUR 2 päivässä
(1 arvostelu)
1.3
€23 EUR 1 päivässä
(0 arvostelua)
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 Lisää

€50 EUR 5 päivässä
(0 arvostelua)
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 Lisää

€24 EUR 2 päivässä
(0 arvostelua)
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 Lisää

€23 EUR 10 päivässä
(0 arvostelua)
0.0
apacherai

A proposal has not yet been provided

€34 EUR 1 päivässä
(0 arvostelua)
0.0
sravyaD

A proposal has not yet been provided

€34 EUR 5 päivässä
(0 arvostelua)
0.0
snaciri81

A proposal has not yet been provided

€55 EUR 5 päivässä
(0 arvostelua)
0.0
€23 EUR 1 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
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 Lisää

€24 EUR 5 päivässä
(0 arvostelua)
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 2 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0