pandas decimal code example

Example 1: pandas decimal places

# (1) Round to specific decimal places – Single DataFrame column
df['DataFrame column'].round(decimals=number of decimal places needed)

# (2) Round up – Single DataFrame column
df['DataFrame column'].apply(np.ceil)

# (3) Round down – Single DataFrame column
df['DataFrame column'].apply(np.floor)

# (4) Round to specific decimals places – Entire DataFrame
df.round(decimals=number of decimal places needed)

Example 2: pandas format float decimal places

pd.options.display.float_format = '{:,.2f}'.format

Example 3: pandas round column

#Option 1
In [661]: df.round({'Y': 2, 'X': 2})
Out[661]:
       Y     X  id WP_NER
0  35.97 -2.73   1  WP_01
1  35.59 -2.90   2  WP_02
2  35.33 -3.39   3  WP_03
3  35.39 -3.93   4  WP_04
4  35.58 -3.94   5  WP_05
5  35.52 -3.41   6  WP_06
6  35.76 -3.08   7  WP_07

#Option 2
In [662]: cols = ['Y', 'X']
In [663]: df[cols] = df[cols].round(2)

Example 4: pandas dataframe print decimal places

pd.set_option('precision', 4)
print(df.to_latex(index=False))