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)
(4, 'Riley', 'Data Analytics', 20, 'Tree Frog')
import pandas as pd
sql_df = pd.read_sql('''
SELECT *
FROM LOYO_GROUP
''', connection)
sql_df