Search Results

Each record is in the database multiple times. Possible causes: import is run multiple times there is a bug in import which inserts multiple rows for each line in the csv. The data needs to be del …

Assume error comes at if (len(lis) == 2): (there are two "len" in the program). The problem is here lis = row["name"].split, because it is not calling the split function. It is declaring lis a functi …

The pset requires a table names students (plural). That is how the distro database is configured. It looks like this program is looking for a table named student singular, based on this INSERT INTO st …

Since program uses the sqlite3 python interface (not the CS50 SQL interface), any changes to the database need to be committed in order to persist. From the python sqlite interface doc: commit() …

Maybe a typo? == is not the set operator, it is the relational operator. This row['middle'] == "" evaluates to False; it does not change the value of row['middle'].

This db.execute("INSERT INTO students VALUES (?, ?, ?, ?, ?)", vals) will give an error when the students table has the schema from the distro students.db. The distro students table has 6 columns, thi …

The CASE is the fourth column in the select, so it needs a , after birth. That will fix the syntax error. It may not, however, give you the result you are looking for :) The number of columns returned …

This with open("characters.csv", "r") is a problem. Why take an argument and not use it? Don't hard code the file name.

executemany is included in the python sqlite3 library, but not in the cs50 SQL library. One option would be to iterate over the dict and insert one row at a time.