我已將資料放入 SQLite3 資料庫，現在我正在嘗試撰寫一個小腳本來訪問給定日期所需的資料。我得到了 SELECT 陳述句來處理日期范圍，但我似乎無法添加另一個條件來微調搜索。
db columns id, date, driverid, drivername, pickupStop, pickupPkg, delStop, delPkg
到目前為止我所得到的：
import pandas as pd
import sqlite3
sql_data = 'driverperformance.sqlite'
conn = sqlite3.connect(sql_data)
cur = conn.cursor()
date_start = "2021-12-04"
date_end = "2021-12-10"
df = pd.read_sql_query("SELECT DISTINCT drivername FROM DriverPerf WHERE date BETWEEN :dstart and :dend", params={"dstart": date_start, "dend": date_end}, con=conn)
drivers = df.values.tolist()
for d in drivers:
driverDF = pd.read_sql_query("SELECT * FROM DriverPerf WHERE drivername = :driver AND date BETWEEN :dstart and :dend", params={"driver": d, "dstart": date_start, "dend": date_end}, con=conn)
我嘗試了幾個不同版本的“WHERE drivername”部分，但似乎總是失敗。
謝謝！
uj5u.com熱心網友回復：
如果我沒記錯的話，drivers將是一個串列串列。你有沒有嘗試過
.... params={"driver": d[0] ....
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/402284.html