Difference between revisions of "Malverso Week 6"

From LMU BioDB 2015
Jump to: navigation, search
(how I found column titles for #1)
(got rid of first line in application.txt)
Line 5: Line 5:
 
*I logged onto PuTTy and also brought up my public folder on the web browser at the web address my.cs.lmu.edu/~malverso/
 
*I logged onto PuTTy and also brought up my public folder on the web browser at the web address my.cs.lmu.edu/~malverso/
 
*I downloaded and unzipped my files through the command line, using the curl and unzip commands.  
 
*I downloaded and unzipped my files through the command line, using the curl and unzip commands.  
 +
*I put the untouched file onto my public web page so I could visually see my progress.
  
 
===#1===
 
===#1===
 +
====application.txt====
 
*I viewed the application.txt file using the more command to see the column titles, which are:
 
*I viewed the application.txt file using the more command to see the column titles, which are:
 
  ApplNo ApplType SponsorApplicant MostRecentLabelAvailableFlag CurrentPatentFlag ActionType
 
  ApplNo ApplType SponsorApplicant MostRecentLabelAvailableFlag CurrentPatentFlag ActionType
 +
*The first thing I needed to do was get rid of the top line, so I used the sed command "1D"
  
 +
====Product.txt====
 
*I viewed the Product.txt file using the more command to see the column titles, which are:
 
*I viewed the Product.txt file using the more command to see the column titles, which are:
 
  ApplNo ProductNo Form Dosage ProductMktStatus TECode ReferenceDrug drugname activeingred  
 
  ApplNo ProductNo Form Dosage ProductMktStatus TECode ReferenceDrug drugname activeingred  
  
 
{{Template:Malverso}}
 
{{Template:Malverso}}

Revision as of 23:19, 14 October 2015

FDA Drug Database

Direct Download/Unzipping Commands

  • I logged onto PuTTy and also brought up my public folder on the web browser at the web address my.cs.lmu.edu/~malverso/
  • I downloaded and unzipped my files through the command line, using the curl and unzip commands.
  • I put the untouched file onto my public web page so I could visually see my progress.

#1

application.txt

  • I viewed the application.txt file using the more command to see the column titles, which are:
ApplNo	ApplType	SponsorApplicant	MostRecentLabelAvailableFlag	CurrentPatentFlag	ActionType
  • The first thing I needed to do was get rid of the top line, so I used the sed command "1D"

Product.txt

  • I viewed the Product.txt file using the more command to see the column titles, which are:
ApplNo	ProductNo	Form	Dosage	ProductMktStatus	TECode	ReferenceDrug	drugname	activeingred 


Team Page

Heavy Metal HaterZ

Assignments

Individual Journal Entries

Shared Journal Entries