Week 7

How to generate shows.db from Favorite TV Shows - Form Responses 1.csv

  1. Log into ide.cs50.io using your GitHub account.

  2. In your terminal window, type

    wget https://cdn.cs50.net/2020/fall/lectures/7/src7.zip

    followed by Enter in order to download a Zip file of lecture’s source code into your IDE.

  3. In your terminal window, type

    unzip src7.zip

    followed by Enter to unzip (i.e., decompress) that Zip file.

  4. In your terminal window, type

    cd src7/favorites/

    followed by Enter in order to “change directory” into src2/favorites/.

  5. And then:

    • To generate the lecture’s first version of shows.db, execute sqlite3 shows.db, followed by .mode csv and then .import "Favorite TV Shows - Form Responses 1.csv".
    • To generate the lecture’s second version of shows.db, execute python favorites8.py.