Python Pandas 索引与列相互转化

import pandas as pd

data = pd.read_excel(r'销售数据.xlsx')
print(data)

运行结果：

import pandas as pd

data = pd.read_excel(r'销售数据.xlsx')
print(data)
data.set_index('销售员', inplace=True)
print(data)

结果：

import pandas as pd

data = pd.read_excel(r'销售数据.xlsx')
print(data)
data.set_index('销售员', inplace=True)
print(data)
data['销售员'] = data.index
print(data)

结果：