How to convert a numeric column in pandas to a string with comma separators?

python pandas formatting series
Kay picture Kay · Nov 13, 2016 · Viewed 15.6k times · Source

I want to convert a column that has values like 1234567.89 to 1,234,567.89. Can someone help me with this.

Answer

Diego Mora Cespedes picture Diego Mora Cespedes · Nov 13, 2016

You can format your column by doing this:

df['new_column_name'] = df['column_name'].map('{:,.2f}'.format)

But keep in mind that the new column will contain strings, not floats.

Related questions

Pandas: Setting no. of max rows

I have a problem viewing the following DataFrame: n = 100 foo = DataFrame(index=range(n)) foo['floats'] = np.random.randn(n) foo The problem is that it does not print all rows per default in ipython notebook, but I have to …

Read More
Pandas python .describe() formatting/output

I am trying to get the .describe() function to output in a reformatted way. Here is the csv data (testProp.csv) 'name','prop' A,1 A,2 B, 4 A, 3 B, 5 B, 2 when I type in the following: from pandas import * data = read_…

Read More
Can you format pandas integers for display, like `pd.options.display.float_format` for floats?

I've seen this and this on formatting floating-point numbers for display in pandas, but I'm interested in doing the same thing for integers. Right now, I have: pd.options.display.float_format = '{:,.2f}'.format That works on the …

Read More