Dataframe - round up to N decimal places

Asked Jul 20 '21 at 20:10

Active Jul 20 '21 at 20:10

Viewed 31 times

i have a pandas dataframe which has floating values:

columnA
1.234567
8.901234

i want to round each of these values up to 2 decimal places.

i.e.

columnA
1.24
8.91

i've checked a handful of answers but using 'round' won't round up and using 'ceil' rounds to whole numbers.

any ideas how to accomplish this?

asked Jul 20 '21 at 20:10

rhs

1

Can scale up and then divide down: `df['columnA'] = np.ceil(df['columnA'] * 100) / 100` – Henry Ecker Jul 20 '21 at 20:13
Or with `df['columnA'] = df['columnA'].apply(my_ceil, precision=2)` from the linked duplicate. – Henry Ecker Jul 20 '21 at 20:15
Do you need to worry about negative numbers? – Mark Ransom Jul 20 '21 at 20:18
no, shouldn't have any negatives – rhs Jul 20 '21 at 20:25
yep, those are what i was looking for. thanks @HenryEcker and stack bot! – rhs Jul 20 '21 at 20:41

0 Answers0