我现在创建了一个包含大量非结构化数据的数据库。我的数据库通过excel表获取数据,但excel表中包含一些我不想在数据库中包含的空行(EE77、KK12)。到目前为止,程序将停止空白行开始(EE77),但我想要FF888 88和GG121的数据。
这是我的代码:from src.server.connectToDB import get_sql_conn
import pandas as pd
if __name__ == '__main__':
cursor = get_sql_conn().cursor()
excelFile = pd.ExcelFile('C:\\Users\\dw\\Source\Repos\\analyse\\data\\Test-nordpool.xlsx')
a = ["A1", "A2"]
for i in a:
df = excelFile.parse(i)
for key, rows in df.items():
print("# Kolonne: ", "\n")
columnInsertSql = "INSERT INTO datasets (Hour, BlockBuyNet, BlockSell, RejectedBlockBuy, RejectedBlockSell, NetImports) VALUES("
rowCounter = 1
for key, column in rows.items():
columnInsertSql += str(column)
if rowCounter != len(list(rows.items())):
columnInsertSql += ", "
rowCounter += 1
columnInsertSql += ")"
cursor.execute(columnInsertSql)
print("SQL: " + columnInsertSql)
cursor.commit()
结果
^{pr2}$