import sqlite3con = sqlite3.connect(":memory:")columns = ["Nom", "Age", "Taille"]columns_str = '"' + '","'.join(columns) + '"'con.execute(f"CREATE TABLE people ({columns_str})")data = [ ('Karl', 11, 185)]stmt = f"INSERT INTO people ({columns_str}) VALUES (?, ?, ?)"con.executemany(stmt, data)另外，可能不要打電話給你的桌子master——稍后會變得非?；靵y。L像和 之類的名字list2也沒有幫助。明確命名變量，按照它們的含義或包含的內容命名。未來的你會感謝你的。也許更干凈一點：import sqlite3con = sqlite3.connect(":memory:")columns = ("Nom", "Age", "Taille")con.execute("CREATE TABLE people (%s, %s, %s)" % columns)data = [ ('Karl', 11, 185)]stmt = f"INSERT INTO people (%s, %s, %s) VALUES (?, ?, ?)" % columnscon.executemany(stmt, data)
1 回答
米琪卡哇伊
TA貢獻1998條經驗 獲得超6個贊
這是一種方法：
import re
...
def normalize(data):
#converting all letters to lowercase
lowercase_lines=[x.lower() for x in data]
# strip out all non-word or tab or space characters
stripped_lines = [re.sub(r"[^\w \t]+", "", x) for x in lowercase_lines]
print(stripped_lines)
return stripped_lines
添加回答
舉報
0/150
提交
取消