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