import pandas as pd
df = pd.DataFrame({'ID':(1,2,3),'Name':('Ring','Nick','Victor')})
df.to_excel('E:/pandas玩转excel_数据分析/课程01/output.xlsx')
print('Done!')
将ID这列 设置 为索引
import pandas as pd df = pd.DataFrame({'ID':(1,2,3),'Name':('Ring','Nick','Victor')}) df = df.set_index('ID') # print(df) df.to_excel('E:/pandas玩转excel_数据分析/课程01/output.xlsx') print('Done!')