Re-arranging columns

- Change order of columns
- Columns order : 0, 1, 2, ..., n
In [6]:
import pandas as pd

df = pd.read_csv('amazon_fires.csv', encoding = "ISO-8859-1")

new_column_name = { 'ano' : 'year' ,  'mes': 'month', 'estado': 'state',
                   'numero': 'fire_numbers','encontro': 'date'}
                                    
             
df.rename(columns= new_column_name , inplace=True)    

df.head()
Out[6]:
year month state fire_numbers date
0 1998 Janeiro Acre 0 Fires 1/1/1998
1 1999 Janeiro Acre 0 Fires 1/1/1999
2 2000 Janeiro Acre 0 Fires 1/1/2000
3 2001 Janeiro Acre 0 Fires 1/1/2001
4 2002 Janeiro Acre 0 Fires 1/1/2002
In [7]:
# new order: date, month, year 

new_column_order = [4,1,0,2,3,]

df = df[df.columns[new_column_order]]

df.head()
Out[7]:
date month year state fire_numbers
0 1/1/1998 Janeiro 1998 Acre 0 Fires
1 1/1/1999 Janeiro 1999 Acre 0 Fires
2 1/1/2000 Janeiro 2000 Acre 0 Fires
3 1/1/2001 Janeiro 2001 Acre 0 Fires
4 1/1/2002 Janeiro 2002 Acre 0 Fires