import sqlite3 as sl

connection = sl.connect('LOYO.db')

with connection: connection.execute(""" CREATE TABLE LOYO_GROUP ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, major TEXT, age INTEGER, spirit_animal TEXT ); """)

statement = 'INSERT INTO LOYO_GROUP (id, name, major, age, spirit_animal) values(?, ?, ?, ?, ?)' data = [ (1, 'Gerry', 'Data Analytics', 21, 'Elephant'), (2, 'Pat', 'Data Analytics', 20, 'Penguin'), (3, 'Logan', 'Data Analytics', 20, 'Rabbit'), (4, 'Riley', 'Data Analytics', 20, 'Tree Frog') ]

with connection: connection.executemany(statement, data)

with connection: data = connection.execute("SELECT * FROM LOYO_GROUP WHERE spirit_animal = 'Tree Frog'") for row in data: print(row)

import pandas as pd sql_df = pd.read_sql(''' SELECT * FROM LOYO_GROUP ''', connection) sql_df