Using openFDA package, I have this code:
# devtools::install_github("ropenhealth/openfda")
library("openfda")
drugs = fda_query("/drug/event.json") %>%
fda_api_key("MY_KEY") %>%
fda_count("patient.drug.medicinalproduct.exact") %>%
fda_exec()
So, I get a list of drugs with a count for each line (fda_count). I'd like to add to the data.frame "drugs" also a column with the corresponding company name to the drug. How can I add the data from "patient.drug.openfda.manufacturer_name.exact" as third column?