桌子：
fk_case_id page_number page_content
-----------------------------------------------
467 1 Hello
467 2 Good morning
468 1 No need to add
我的 Python 代碼：
mycursor.execute(
f"select page_number,page_content,fk_case_id from mt_page_file_contents ORDER BY fk_case_id")
myresult = mycursor.fetchall()
prev_case_id = ""
matchstring = ""
for x in myresult:
page_number = x[0]
text = x[1]
print(text)
有沒有辦法通過加入兩行來獲得“你好早上好”？
uj5u.com熱心網友回復：
當然，您將如何加入任何其他字串集。SQLite 結果集沒有什么特別之處。
mycursor.execute(
"select page_number,page_content,fk_case_id from mt_page_file_contents ORDER BY fk_case_id")
myresult = mycursor.fetchall()
prev_case_id = ""
matchstring = ""
greeting = []
for x in myresult:
page_number = x[0]
greeting.append( x[1] )
print(' '.join(greeting))
uj5u.com熱心網友回復：
您可以使用pandas根據您的查詢結果進行過濾
>>> import pandas as pd
>>> # Create your db connection, let's say it is conn
>>> df = pd.read_sql_query("select page_number,page_content,fk_case_id from mt_page_file_contents;", conn)
>>> # Now filter with fk_case_id
>>> for case_id in df.fk_case_id.unique():
output = " ".join(df[df.fk_casr_id == case_id].page_content.values)
print(case_id, output)
如果您只查找特定的 fk_case_id，那么您可以最初在資料幀本身中將它們過濾掉。
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/359846.html