upper() function in pandas python – Convert the column to uppercase

In this tutorial we will be using upper() function in pandas, to  convert the character column of the python pandas dataframe to uppercase.

  • If the input string is in any case (upper, lower or title) , upper() function in pandas converts the string to upper case.

Lets look it with an Example

 

Create dataframe:

## create dataframe

import pandas as pd
d = {'Quarters' : ['quarter1','quarter2','quarter3','quarter4'],
     'Description' : ['First Quarter of the year', 'second quarter of the year', 'Third  Quarter of the year', 'FOURTH QUARTER OF THE YEAR']}
df=pd.DataFrame(d)
print df

resultant dataframe will be

Convert the character column of the python Dataframe to uppercase 1

 

# upper function in python to convert the character column to uppercase 

df['upper_desc'] = map(lambda x: x.upper(), df['Description'])
print df

upper() function in pandas converts any case to the uppercase and stores it in the upper_desc column of the dataframe, so the output will be

Convert the character column of the python Dataframe to uppercase 2

 

previous Convert the character column of the python Dataframe to uppercase                                                                                                           next Convert the character column of the python Dataframe to uppercase