This is the column of a dataframe that I have (values are str):

This is how I want the record to go to the database:

How can I do this? Thanks in advance!

CodePudding user response：

df["Values"] = df["Values"].apply(lambda x: "{:,.2f}".format(float(x)))

Output:

     Values
0  7,257.57
1  6,942.09
2  5,780.01

To get values in the format 7.257,56. You can make good use of the replace function:

df["Values"] = df["Values"].apply(lambda x: "{:,.2f}".format(float(x)).replace(".", ",").replace(",", ".", 1))

Output:

     Values
0  7.257,57
1  6.942,09
2  5.780,01