熊猫不能写到表格上。

Question

dftcr_hv_tv_tth5.to_excel('C:\Users\alemthottg\Desktop\KiTTEN-TAQ\PlyCluster\tcr_hv_tv_tth5.xlsx',sheet_name='NewSheet',encoding='utf-8')

我收到的错误信息。

文件""，第3行dftcr_hv_tv_tth5.to_excel('C:\Users\alemthottg\Desktop\KiTTEN-TAQ\PlyCluster\tcr_hv_tv_tth5.xlsx'，sheet_name='NewSheet'，编码=‘utf-8’)^ SyntaxError：(unicode错误)‘unicode’编解码器无法解码位置2-3:截断\UXXXXXXXX转义字节

Answer 1

我认为您需要首先创建一个ExcelWriter。

# create an ExcelWriter
writer = pd.ExcelWriter(r'C:\Users\alemthottg\Desktop\KiTTEN-TAQ\PlyCluster\tcr_hv_tv_tth5.xlsx', engine='xlsxwriter')
dftcr_hv_tv_tth5.to_excel(writer, sheet_name='NewSheet', encoding='utf-8', index=False)
writer.save()