将某列移到首列或尾列

移到尾列

借助新DataFrame

import pandas as pd
import numpy as np
cols = ['A','B','C','D','E','date','G','H','F','I']
df = pd.DataFrame([np.arange(len(cols))],
                  columns=cols)
df_last = df.loc[:,df.columns!='date']
df_last['date']=df['date']

使用已有顺序列表

import pandas as pd
import numpy as np
cols = ['A','B','C','D','E','date','G','H','F','I']
df = pd.DataFrame([np.arange(len(cols))],
                  columns=cols)
df=df[['A','B','C','D','E','G','H','F','I','date']]
df

移动首列

import pandas as pd
import numpy as np
cols = ['A','B','C','D','E','date','G','H','F','I']
df = pd.DataFrame([np.arange(len(cols))],
                  columns=cols)
df_mid=df.loc[:,df.columns!='date']
df_first=pd.DataFrame(df['date'])
for item in df_mid.columns: 
    df_first[item]=df.loc[:,item]
df_first

批量移动到首列

import pandas as pd
import numpy as np
cols = ['A','B','C','D','E','G','H','F','I','date1','date2']
df = pd.DataFrame([np.arange(len(cols))],
                  columns=cols)
# 要放到首列的多个列名
add_columns = ['date1','date2']
# 正式要用的列名列表，初始值与all_columns的值相同
columns_list = ['date1','date2']
for item in df.columns:
    if item not in add_columns:
        columns_list.append(item)
df = df[columns_list]
df