Difference between revisions of "Blitvak Week 6"
From LMU BioDB 2015
(some more information added to first section) |
(another edit for first section) |
||
| Line 4: | Line 4: | ||
*Looking over the [[Week 6| Week 6 Assignment Page]], I found that <code>curl -O http://www.fda.gov/downloads/Drugs/InformationOnDrugs/UCM054599.zip</code> can be used, while I am in the ''/nfs/home/blitvak'' directory, to place a .zip containing the data files directly into my personal folder. I found that <code>unzip UCM054599.zip</code> unzips the files into the personal folder. | *Looking over the [[Week 6| Week 6 Assignment Page]], I found that <code>curl -O http://www.fda.gov/downloads/Drugs/InformationOnDrugs/UCM054599.zip</code> can be used, while I am in the ''/nfs/home/blitvak'' directory, to place a .zip containing the data files directly into my personal folder. I found that <code>unzip UCM054599.zip</code> unzips the files into the personal folder. | ||
*I also downloaded and installed pgAdmin III from [http://www.pgadmin.org/ http://www.pgadmin.org/] | *I also downloaded and installed pgAdmin III from [http://www.pgadmin.org/ http://www.pgadmin.org/] | ||
| − | + | *I spent some time reviewing [[PostgreSQL Tutorial | the PostgreSQL Tutorial]] | |
| − | + | *I booted up PuTTy and unzipped the files into my home folder | |
| − | + | *I opened up and reviewed the ''application.txt'' and ''Product.txt'' files using <code>more <filename.txt></code>; I found that the data column labels for ''application.txt'' are: | |
| + | ApplNo ApplType SponsorApplicant MostRecentLabelAvailableFlag CurrentPatentFlag ActionType Chemical_Type Ther_Potential Orphan_Code | ||
| + | For ''Product.txt'', the column labels were: | ||
Revision as of 07:02, 11 October 2015
Individual Journal Assignment Week 6
Downloading and Decompressing Data Files, Other Assignment Preparation
- Looking over the Week 6 Assignment Page, I found that
curl -O http://www.fda.gov/downloads/Drugs/InformationOnDrugs/UCM054599.zipcan be used, while I am in the /nfs/home/blitvak directory, to place a .zip containing the data files directly into my personal folder. I found thatunzip UCM054599.zipunzips the files into the personal folder. - I also downloaded and installed pgAdmin III from http://www.pgadmin.org/
- I spent some time reviewing the PostgreSQL Tutorial
- I booted up PuTTy and unzipped the files into my home folder
- I opened up and reviewed the application.txt and Product.txt files using
more <filename.txt>; I found that the data column labels for application.txt are:
ApplNo ApplType SponsorApplicant MostRecentLabelAvailableFlag CurrentPatentFlag ActionType Chemical_Type Ther_Potential Orphan_Code
For Product.txt, the column labels were:
