python excel

 1 import pandas as pd
 2 
 3 def test():
 4     my_data = {
 5         "ID":[1,2,3],
 6         "Name":["tom","egon","alex"]
 7     }
 8     data_frame = pd.DataFrame(my_data)
 9     my_excel = data_frame.to_excel("my_excel.xlsx")  #默认索引
10     print("Done!")
11 
12 def test01():
13     my_data = {
14         "ID":[1,2,3],
15         "Name":["tom","egon","alex"]
16     }
17     data_frame = pd.DataFrame(my_data)
18     new_data = data_frame.set_index("ID")  #我们指定索引 。
19     print(new_data)
20     # my_excel = data_frame.to_excel("my_excel.xlsx")
21     print("Done!")
22 
23 
24 
25 
26 
27 
28 
29 if __name__ == '__main__':
30         # test()
31         test01()
利用python 中的pandas 中的 DataFrame对象存到excel 中