Create data from csv

1. Import the sqlite and csv modules

   import csv
   import sqlite3
   

2. Point to the Library Database

   conn = sqlite3.connect("library.db")
   cursor = conn.cursor()
   

3. Read the csv file and insert the records into the database:

   with open("books.csv", encoding="utf-8") as f:
       reader = csv.reader(f, delimiter=",")
       cursor.executemany("INSERT INTO books VALUES (?,?,?,?,?)", reader)
   

4. Save data to database:

   conn.commit()