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——稍后會(huì)變得非?；靵y。L像和 之類的名字list2也沒(méi)有幫助。明確命名變量，按照它們的含義或包含的內(nèi)容命名。未來(lái)的你會(huì)感謝你的。也許更干凈一點(diǎn)：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貢獻(xiàn)1998條經(jīng)驗(yàn) 獲得超6個(gè)贊
這是一種方法：
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
添加回答
舉報(bào)
0/150
提交
取消