Loading a CSV into a table

You've done a great job so far at inserting data into tables! You're now going to learn how to load the contents of a CSV file into a table.

We have used the csv module to set up a csv_reader object, which is just an iterator that can access the lines in a given CSV file - in this case, a census CSV file. You can use this object in a for loop to access lines in the CSV file one by one. For example, consider the following code:

for row in csv_reader:
    print(row)

The first few lines of the output are:

['Illinois', 'M', '0', '89600', '95012'] ['Illinois', 'M', '1', '88445', '91829'] ['Illinois', 'M', '2', '88729', '89547']

Here ['Illinois', 'M', '0', '89600', '95012'] is the row, corresponding to the column names 'state' , 'sex', 'age', 'pop2000 ', and 'pop2008'. 'Illinois' can be accessed with row[0], 'M' with row[1], and so on. You can create a dictionary containing this information where the keys are the column names and the values are the entries in each line. Then, by appending this dictionary to a list, you can combine it with an insert statement to load it all into a table!

Set up a CSV Reader object. This code has already been written for you,
Initialize values_list to be an empty list.
Within the for loop:
- Create the data dictionary by filling in the values for each of the keys from the current row of the CSV file. The values are contained in row.
- Append the data dictionary to values_list

Take Hint (-15 XP)

Exercise

Loading a CSV into a table

Instructions 1/2