import pandas as pd df = pd.read_csv('/path/to/sample.csv') df_reorder = df[['A', 'B', 'C', 'D', 'E']] # rearrange column here #you may need to use zip(*[['A', 'B', 'C', 'D', 'E']]) df_reorder.to_csv('/path/to/sample_reorder.csv', index=False)