Python Upper function

import pandas as pd
df = pd.DataFrame([{"email": "[e-mail]"}])
is_upper = lambda x: x.upper() if isinstance(x, str) else x
df = df.applymap(trim_strings)
a = df.to_dict("records")

The response I get :

[{'email': '[e-mail]'}]

The response I expected :

[{'email': '[e-mail]'}]

What can be the issue here?

Answer

To get the expected output, consider try this:

df['email'] = df['email'].str.upper()

Your df:

    email
0   [e-mail]

to get the dictionary:

foo_dict = df.to_dict()
foo_dict 

{'email': {0: '[e-mail]'}}

Block Code:

import pandas as pd
df = pd.DataFrame([{"email": "[e-mail]"}])
df['email'] = df['email'].str.upper()
foo_dict = df.to_dict()