Exercise

Load Data from a list into the Table

Using the multiple insert pattern, in this exercise, you will load the data from values_list into the table.

Instructions

100 XP

Import insert from sqlalchemy.
Build an insert statement for the census table.
Execute the statement stmt along with values_list. You will need to pass them both as arguments to connection.execute().
Print the rowcount attribute of results.

Take Hint (-30 XP)