Removing Text from Columns Values

In [3]:
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)  

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

df = df[df.columns[new_column_order]]

df.head()
Out[3]:
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
In [4]:
df['fire_numbers'] = df['fire_numbers'].str.strip("Fires")

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