我有一個(gè) sqlite3 數(shù)據(jù)庫(kù)列表,并希望能夠通過(guò)循環(huán)將每個(gè)數(shù)據(jù)庫(kù)讀入單獨(dú)的 Pandas 數(shù)據(jù)幀,但到目前為止我的方法沒(méi)有填充數(shù)據(jù)幀。我想這與處理復(fù)制而不是參考有關(guān),但找不到一個(gè)很好的方法來(lái)工作。import sqlite3import pandas as pddb_1 = 'db1.db'db_2 = 'db2.db'df_1 = pd.DataFrame()df_2 = pd.DataFrame()db_df_name = [(db_1, df_1, 'df_raw'), (db_2, df_2, 'df_processed')]for (db, df, name) in db_df_name:with sqlite3.connect(db, detect_types=sqlite3.PARSE_DECLTYPES) as connection: df = pd.read_sql_query("select * from messages;", connection) print(f'Database {name} processed')
添加回答
舉報(bào)
0/150
提交
取消