pythonpandasstringdataframe

Applying uppercase to a column in pandas dataframe

I'm having trouble applying upper case to a column in my DataFrame.

dataframe is df.

1/2 ID is the column head that need to apply UPPERCASE.

The problem is that the values are made up of three letters and three numbers. For example rrr123 is one of the values.

df['1/2 ID'] = map(str.upper, df['1/2 ID'])

I got an error:

TypeError: descriptor 'upper' requires a 'str' object but received a 'unicode' error.

How can I apply upper case to the first three letters in the column of the DataFrame df?

Solution

  • This should work:

    df['1/2 ID'] = map(lambda x: str(x).upper(), df['1/2 ID'])

    and should you want all the columns names to be in uppercase format:

    df.columns = map(lambda x: str(x).upper(), df.columns)