how to round the numbers of a dataframe column python code example

Example 1: 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 2: pandas groupby mean round

data.mean().round(0)  # Rounds mean to nearest integer, e.g. 1.95 = 2 and 1.05 = 1