Biến danh sách khách hàng thành tiến độ nhìn thấy được.

import pandas as pd
df = pd.read_csv("khach_hang.csv")
print(df.head())

print(df.shape)
print(df.columns.tolist())
print(df.dtypes)

target = df[df["Zip Code"] == "10001"]
print(target.sort_values("Tên mẫu"))

leads = df[(df["Zip Code"] == "10001") & (df["Trạng thái liên hệ"] != "Đã liên hệ")]
print(leads.head(50))

import sqlite3
db = sqlite3.connect("cong_trinh.db")
db.execute("CREATE TABLE IF NOT EXISTS KhachHang (id INTEGER PRIMARY KEY, ten TEXT, sdt TEXT)")
db.commit()

db.execute("CREATE TABLE IF NOT EXISTS DuAn (id INTEGER PRIMARY KEY, ten TEXT, khach_hang_id INTEGER)")
db.commit()

db.execute("INSERT INTO KhachHang (ten, sdt) VALUES (?, ?)", ("Nguyen Van A", "0900000000"))
      db.commit()
      for row in db.execute("SELECT * FROM KhachHang"):
        print(row)

db.execute("UPDATE KhachHang SET sdt = ? WHERE id = ?", ("0911111111", 1))
db.execute("DELETE FROM KhachHang WHERE id = ?", (99,))
db.commit()