Difference between revisions of "Cdomin12 Week 4"
Jump to navigation
Jump to search
(→Turn on File Extension: add) |
(→File Download and Decompress: access) |
||
| Line 18: | Line 18: | ||
*open the file in T: drive | *open the file in T: drive | ||
*right click on file --> 7- zip --> extract files | *right click on file --> 7- zip --> extract files | ||
| + | |||
| + | ===Microsoft Access File Upload=== | ||
| + | *open up Microsoft Access | ||
| + | *open blank desktop database and save file as nameFDAdatabase | ||
| + | *click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close | ||
| + | *Repeat this process until all 10 files are uploaded to access | ||
==Results== | ==Results== | ||
Revision as of 18:46, 24 September 2019
Contents
- 1 Certificate
- 2 Purpose
- 3 Methods
- 4 Results
- 4.1 1.What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
- 4.2 2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
- 4.3 3. In what forms and dosages can the drug product named BENADRYL be administered?
- 4.4 4. Which drug products have a name ending in ESTROL?
- 4.5 5.Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)
- 4.6 6. Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)
- 4.7 7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
- 4.8 8.Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
- 4.9 9.Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
- 5 Scientific Conclusion
- 6 Datas and Files
- 7 Acknowledgments
- 8 References
Certificate
Purpose
Methods
Turn on File Extension
- search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay
Setting Download Options for Chrome
- Open Chrome
- Go to settings --> show advanced settings ==> downloads --> change to T:drive --> okay
File Download and Decompress
- download file from insert website
- open the file in T: drive
- right click on file --> 7- zip --> extract files
Microsoft Access File Upload
- open up Microsoft Access
- open blank desktop database and save file as nameFDAdatabase
- click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
- Repeat this process until all 10 files are uploaded to access
Results
1.What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
3. In what forms and dosages can the drug product named BENADRYL be administered?
4. Which drug products have a name ending in ESTROL?
5.Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)
6. Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)
7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
8.Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
9.Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)
Scientific Conclusion
Datas and Files
Acknowledgments
- I worked with
- "Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
Cdomin12 (talk) 11:55, 24 September 2019 (PDT)
References
- LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
- United States Food and Drug Administration(FDA). (2019). FDA. Retrieved September 25, 2019, from https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files
