WikiSysop: Created page with "

Extra fun with US zip codes

If you are 100% done with everything, you can have fun with the following exercise involving [https://en.wikipedia.org/wiki/ZIP_Code US zip codes]. This is mostly for people with previous Unix experience.

You will find the following file:

 /home/projects/22126_NGS/exercises/unix/ZIP_CODES.csv.gz

No need to copy it or unzip it. You can view it with '''zcat''' or '''zless'''. csv stands for comma-separated val..."

2024-03-19T15:23:55Z

Created page with " <H2>Extra fun with US zip codes</H2> <p>If you are 100% done with everything, you can have fun with the following exercise involving [https://en.wikipedia.org/wiki/ZIP_Code US zip codes]. This is mostly for people with previous Unix experience. </p> You will find the following file: <pre> /home/projects/22126_NGS/exercises/unix/ZIP_CODES.csv.gz </pre> No need to copy it or unzip it. You can view it with '''zcat''' or '''zless'''. csv stands for comma-separated val..."

New page

<H2>Extra fun with US zip codes</H2>

<p>If you are 100% done with everything, you can have fun with the following exercise involving [https://en.wikipedia.org/wiki/ZIP_Code US zip codes]. This is mostly for people with previous Unix experience. </p>

You will find the following file:

<pre>
/home/projects/22126_NGS/exercises/unix/ZIP_CODES.csv.gz
</pre>

No need to copy it or unzip it. You can view it with '''zcat''' or '''zless'''.

csv stands for comma-separated values i.e. column1,column2,...

Some very useful commands:
<OL>
<LI> [https://www.geeksforgeeks.org/cat-command-in-linux-with-examples/ cat] or in our case '''zcat'''
<LI> [https://www.geeksforgeeks.org/head-command-linux-examples/ head]
<LI> [https://www.geeksforgeeks.org/tail-command-linux-examples/ tail]
<LI> [https://www.geeksforgeeks.org/awk-command-unixlinux-examples/ awk]
<LI> [https://www.geeksforgeeks.org/sed-command-in-linux-unix-with-examples/ sed]
<LI> [https://www.geeksforgeeks.org/sort-command-linuxunix-examples/ sort]
<LI> [https://www.geeksforgeeks.org/uniq-command-in-linux-with-examples/ uniq]
<LI> [https://www.geeksforgeeks.org/wc-command-linux-examples/ wc]
<LI> [https://www.geeksforgeeks.org/grep-command-in-unixlinux/ grep]
</OL>

For csv files, to get the first column, I recommend either:
<pre>
zcat /home/projects/22126_NGS/exercises/unix/ZIP_CODES.csv.gz | cut -d , -f 1
</pre>

<pre>
zcat /home/projects/22126_NGS/exercises/unix/ZIP_CODES.csv.gz | awk 'BEGIN{FS=","}{put code here}'
</pre>

'''Q1:''' How many zip codes are in New York State ( STATE = NY)

'''Q2:''' Among the zip codes in New York State from Q1, what are the top 3 cities with the most ZIP codes assigned to them?

'''Q3:''' Among the zip codes in New York State from Q1, how many cities have a single ZIP code assigned to them?

'''Q4:''' Among the zip codes in New York State from Q1, count how many cities have 1 ZIP code assigned to them, how many have 2 ZIP codes, how many have 3 ZIP codes, .... etc

'''Q5:''' How many zip codes are below the famous [http://en.wikipedia.org/wiki/Mason%E2%80%93Dixon_Line Mason-Dixon Line] (Latitude < 39.4)

'''Q6:''' For each different US state, list the city with the most zip codes assigned to it.

'''Q7:''' How many cities in the file begin with the letter 'M' ?

Please find the answers [[Zip_codes_answers|here]]

'''Congratulations you finished the exercise!'''

Zip codes - Revision history

WikiSysop: Created page with "

Extra fun with US zip codes