CSV Comparison Exercises

These exercises require the files restaurants2017.csv and restaurants2018.csv.

Find New/Missing Rows

Open the two restaurant files and print out:

Each row in the first file where information on that ZIP code is only in restaurants2017.csv
Each row in the second file where information on that ZIP code is only in restaurants2018.csv

Copy Reviews

For ZIP codes where the restaurant and owner are the same between restaurants2017.csv and restaurants2018.csv, copy the review column (if any) to restaurants2018.csv.

Order The Rows

Reorder the rows in restaurants2018.csv by their ZIP code.