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:
NAS.FPG (data only available until 2009)
ATC (data only available until 2009)
Resulting dataframe must then be merged with Products.txt by.x = “Brand.name”, 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.
Hours to be determined
Less than 1 month< 1 monthProject LengthDuration
I am looking for freelancers with the lowest rates