- pandas创建Excel文件
import pandas as pd
new_file = pd.DataFrame({"id":[1,2,3],
"Name":["Tim","John","Phoebe"]})
# new_file.index
new_file = new_file.set_index("id")
new_file.to_excel("./new_file.xlsx") # 创建excel的方法
new_file
| Name | |
|---|---|
| id | |
| 1 | Tim |
| 2 | John |
| 3 | Phoebe |