Pandas 玩 Excel 1. 创建excel表格

跟着刘铁锰老师学Python玩Excel

import pandas as pd
df = pd.DataFrame({"ID":['1', '2', '3'],"Name":['Tim','Victor','Nick']}) # 两个列表数量必须相同
df = df.set_index('ID') # 设置ID为索引列
print(df)
df.to_excel('D:\WorkSpeace\Temp\Pandas Excel\example.xlsx')