python交换两列的位置_如何更改 pandas dataframe 中两列的位置

如何更改 pandas dataframe 中两列的位置：

把其中的某列移到第一列的位置。

原来的 df 是：

df = pd.read_csv('I:/Papers/consumer/codeandpaper/TmallData/result01.csv')

Net Upper Lower Mid Zsore

Answer option

More than once a day 0% 0.22% -0.12% 2 65

Once a day 0% 0.32% -0.19% 3 45

Several times a week 2% 2.45% 1.10% 4 78

Once a week 1% 1.63% -0.40% 6 65

要将 Mid 这一列移动到第一列?

Mid Upper Lower Net Zsore

Answer option

More than once a day 2 0.22% -0.12% 0% 65

Once a day 3 0.32% -0.19% 0% 45

Several times a week 4 2.45% 1.10% 2% 78

Once a week 6 1.63% -0.40% 1% 65

解决办法：(使用 ix )

法一：

In [27]:

# get a list of columns

cols = list(df)

# move the column to head of list using index, pop and insert

cols.insert(0, cols.pop(cols.index('Mid')))