how to change column locatio pandas code example
Example 1: pandas reorder columns by name
#old df columns
df.columns
Index(['A', 'B', 'C', 'D'],dtype='***')
#new column format that we want to rearange
new_col = ['D','C','B','A'] #list of column name in order that we want
df = df[new_col]
df.columns
Index(['D', 'C', 'B', 'A'],dtype='***')
#new column order
Example 2: rearange DataFrame swap columsn and rows
df_t = df.T
print(df_t)
# 0 1 2
# name Alice Bob Charlie
# age 24 42 18
# state NY CA CA
# point 64 92 70