Get the Synonyms found at a given Drug Link

Run the full sequence that scrapes, parses, and stores the NCI Drug Dictionary found at CancerGov.org and any correlates to the NCI Thesaurus in a Postgres Database.

get_drug_link_synonym(
  conn,
  drug_link,
  response,
  sleep_time = 5,
  expiration_days = 30,
  verbose = TRUE,
  render_sql = TRUE
)

Arguments

conn	Postgres connection object.
response	(Optional) The response returned when the url supplied as the drug_link is parsed. If not provided, a new response is received. This is an option to reduce repetitive scrapes of the same URL if multiple sections of the same page are being parsed.
sleep_time	Time in seconds for the system to sleep before each scrape with read_html.
verbose	When reading from a slow connection, this prints some output on every iteration so you know its working.

Drug Detail Links

The links to Drug Pages are scraped from the Data Dictionary URL over the maximum page number and are saved to a Drug Link Table in the cancergov schema. The URLs in the Drug Link Table are then scraped for any HTML Tables of synonyms and the results are written to a Drug Link Synonym Table. The links to active clinical trials and NCIt mappings are also derived and stored in their respective tables.

See also

render query,appendTable try_catch_error_as_null read_xml,xml_find_all,xml_replace html_nodes,html_table bind,mutate,filter_all separate_rows