原DataFrame数据df的列顺序为['aa','bb','cc','dd'],如下所示:
import pandas as pd
from pandas import DataFrame
import numpy as np
df = DataFrame(np.arange(12).reshape((3,4)),index=['a','b','c'],columns=['aa','bb','cc','dd'],dtype=str)
df
Out:
aa bb cc dd
a 0 1 2 3
b 4 5 6 7
c 8 9 10 11
现将第一列和第四列进行调换,令df1=df[['cc','aa','dd','bb']],则df1就是调换列顺序后的df,如下所示:
df.columns
Out: Index(['aa', 'bb', 'cc', 'dd'], dtype='object')
df1 = df[['cc','aa','dd','bb']]
df1
Out:
cc aa dd bb
a 2 0 3 1
b 6 4 7 5
c 10 8 11 9