how to round the values of a column in pandas code example
Example 1: pandas decimal places
df['DataFrame column'].round(decimals=number of decimal places needed)
df['DataFrame column'].apply(np.ceil)
df['DataFrame column'].apply(np.floor)
df.round(decimals=number of decimal places needed)
Example 2: pandas round column
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
In [662]: cols = ['Y', 'X']
In [663]: df[cols] = df[cols].round(2)