比方说,我在excel中导出了我的文件
报表导出
ln[] = writer = pd.ExcelWriter("df2018.xlsx")
writer = pd.ExcelWriter("df2018.xlsx", index = false)
df2018.to_excel(writer)
writer.save()
out[] =
row0 (blank) kanwil jan 2018 feb 2018 janfeb 2018
row1 0 sunarto 45878 545458 5454878
row2 1 hartanto 123456 545454 4444549
row3 2 pemabuk 9547 787896 4579798
DFIS 2018(if数据帧)
我的预期:
^{pr2}$我要删除第一列
我试过了
在优秀作家(“df2018.xlsx”,index=false)
但它不起作用
如果我想在导出csv或excel时删除第一列,我应该怎么做
事实上,我从下面的数据框(df2018)中获取信息:
<class 'pandas.core.frame.DataFrame'>
Int64Index: 154 entries, 2 to 155
Data columns (total 5 columns):
Kanwil 149 non-null object
Cabang 137 non-null object
Income Januari 2018 151 non-null object
Income Febuari 2018 151 non-null object
Income Jan-Feb 2018 151 non-null object
dtypes: object(5)
memory usage: 4.2+ KB
None
试着喜欢这些参考熊猫Excel writer:
https://pbpython.com/improve-pandas-excel-output.htmlhttps://xlsxwriter.readthedocs.io/working_with_pandas.html
我相信您需要在^{} 中指定参数
index=False
:相关问题 更多 >
编程相关推荐