pandas将某列复制到另一个表_在pandas中按名称将列移到表的前面

我们可以使用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')))

cols

Out[27]:

['Mid', 'Net', 'Upper', 'Lower', 'Zsore']

In [28]:

# use ix to reorder

df = df.ix[:, cols]

df

Out[28]:

Mid Net Upper Lower Zsore

Answer_option

More_than_once_a_day 2 0% 0.22% -0.12% 65

Once_a_day 3 0% 0.32% -0.19% 45

Several_times_a_week 4 2% 2.45% 1.10% 78

Once_a_week 6 1% 1.63% -0.40% 65

另一种方法是引用列并在前面重新插入它：In [39]:

mid = df['Mid']

df.drop(labels=['Mid'], axis=1,inplace = True)

df.insert(0, 'Mid', mid)

df

Out[39]:

Mid Net Upper Lower Zsore

Answer_option

More_than_once_a_day 2 0% 0.22% -0.12% 65

Once_a_day 3 0% 0.32% -0.19% 45

Several_times_a_week 4 2% 2.45% 1.10% 78

Once_a_week 6 1% 1.63% -0.40% 65

您还可以使用loc来获得与ix相同的结果，从^{}开始，熊猫的未来版本将不推荐使用ix：df = df.loc[:, cols]