Python
import sqlite3
import pandas as pd
Python
conn = sqlite3.connect('mydb.db')
Python
conn.execute("""CREATE TABLE IF NOT EXISTS PRODUCTS (
ID INT,
NAME TEXT,
SUPPLIER_ID INT,
CUSTOMER_ID INT,
UNIT TEXT,
PRICE REAL

    );""")
<sqlite3.Cursor object at 0x45e2b68>
Python
conn.execute("""INSERT INTO PRODUCTS VALUES
(1, 'CHAIS', 1, 1, '10 BOXES*20 BAGS', 18),
(2, 'CHANG', 1, 2, '24-12 OZ BOTTLES', 19),
(3, 'ANISEED SYRUP', 1, 2, '12-550 ML BOTTLES', 10),
(4, 'CHEF ANTON SEASONING', 2, 2, 48- 6 OZ JARS', 22),
(5, 'CHEF ANTON MIX', 2, 2, '36 BOXES', 21.35)
;""")
line 1, in <module>
    conn.execute("""INSERT INTO PRODUCTS VALUES
sqlite3.OperationalError: near "OZ": syntax error
Python
conn.commit()
Python
data = pd.read_sql_query("""SELECT * FROM PRODUCTS;""", conn)
data
Python
data = pd.read_sql_query("""SELECT COUNT(ID)  FROM PRODUCTS;""", conn)
data
Python
data = pd.read_sql_query("""SELECT AVG(PRICE) FROM PRODUCTS;""", conn)
data
Python
data = pd.read_sql_query("""SELECT SUM(PRICE) FROM PRODUCTS;""", conn)
data