我使用python脚本生成.csv文件,方法是使用utf8编码编写pandas DataFrame to_csv。consumptionExpenditure.csv"), encoding = 'utf8', index = False)
接下来,我通过Load Data Local Infile上传到Amazon RDS MySQL
我必须将数据写入excel,并在每次迭代后向excel追加一行: writer = pandas.ExcelWriter('test.xlsx', engine='openpyxl')reader = pandas.read_excel('test.xlsx') l = len(readerwriter.sheets = dict((ws.title, ws) for w