CMIS 325

awk 2
Paste the awk command in addition to the answer.

Name:____________________________________


Using the cars_file.txt:
Show the awk command and the answer:

 sum of prices, sum of mileage


 average price, average mileage, average age


 min and max price, age, mileage


 number of novas


 number of cars per make


Use the japan file:
 sum and average of the numeric fields


Use the alice file:
 the longest line

 the 5 most frequent words (use tr to delete nonletters and space and
to lowercase all letters first)



Make a piplein that does a frequency count of the letters of
its input.  I.e. count the number of times each letter is in the input.
Hint: tr, sed, and awk
What are the 5 most frequently used letters of the alice file:







IGNORE:
*Make the fields comma delimted
*Capitalize the make and model (i.e. first letter only)
*Change plym to plymouth
*Make the file Y2K compliant by making the years 19xx.