问如何在Excel上将不同的数据集组织成相同的布局/顺序(使用熊猫)

EN

import pandas as pd
import numpy as np

# Create an example of your problem
root = 'River'
suffix = list('123')
cols_1 = [root + '_' + each_suffix for each_suffix in suffix]
cols_2 = [root + '_' + each_suffix for each_suffix in suffix[::]]
data = np.arange(9).reshape(3,3)
df_1 = pd.DataFrame(columns=cols_1, data=data)
df_2 = pd.DataFrame(columns=cols_2, data=data)

df_1
[out]   River_1  River_2  River_3
0        0        1        2
1        3        4        5
2        6        7        8

df_2
[out]   River_3  River_2  River_1
0        0        1        2
1        3        4        5
2        6        7        8

col_list = df_1.columns.to_list() # Get a list of column names use .sort() to sort in place or

sorted_col_list = sorted(col_list, reverse=False) # Use reverse True to invert the order

def rearrange_df_cols(df, target_order):
    df = df[target_order]
    print(df)
    return df

rearrange_df_cols(df_1, sorted_col_list)
[out]   River_1  River_2  River_3
0        0        1        2
1        3        4        5
2        6        7        8


rearrange_df_cols(df_2, sorted_col_list)
[out]   River_1  River_2  River_3
0        2        1        0
1        5        4        3
2        8        7        6