我在努力推动我的excel.xlsm表格文件数据到sql php myadmin
这是我的代码,我创建了一个模块,在数据库sql和excel.xlsm表格数据库作为xlsm中的列名称与数据库sql中的列名称不同
下面是我的简单代码from sqlalchemy import create_engine
import pandas as pd
import os
import MySQLdb
engine = create_engine(‘mysql+mysqldb://root:@localhost/myDB?
charset=utf8mb4&binary_prefix=true’, echo=False)
mydir = (os.getcwd()).replace(‘\’, ‘/’) + ‘/’
all_data = pd.read_excel(r” + mydir + ‘Governance_Tracker – Copy –
Copy.xlsm’
,header = 1).drop([‘#’], axis=1)
all_data.replace(‘\n’,”, regex=True)
df = all_data.where((pd.notnull(all_data)), None)
print(df)
for i in range(len(df)):
data_dict ={}
data_dict[‘site_name’] = df[‘Site Name’][i]
data_dict[‘region’] = df[‘Region’][i]
data_dict[‘site_type’] = df[‘Site Type’][i]
data_dict[‘site_code’] = df[‘SiteCode’][i]
data_dict[‘tac_name’] = df[‘TAC Name’][i]
data_dict[‘dt_readinesss&#
Original: https://blog.csdn.net/weixin_30873333/article/details/113295483
Author: lyw67103
Title: mysql出现1048_MySQLdb_异常操作错误:(1048,“……不能为空”)
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/753100/
转载文章受原作者版权保护。转载请注明原作者出处!