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()