how to change the values in column to positive and roundoff to single decimal point using pandas

Question

    strain   Standardforce   stress    percentage
1   10.400000   24400.0   2.750646    -20.800000
2   10.400000   24200.0   2.728100    -20.800000
3   10.400000   24100.0   2.716826     23.800000
4   10.400000   23900.0   2.694280     20.800000

to

    strain   Standardforce   stress    percentage
1   10.400000   24400.0     2.750646        20.8
2   10.400000   24200.0     2.728100        20.8
3   10.400000   24100.0     2.716826        23.8
4   10.400000   23900.0     2.694280        20.8

`df['percentage'] = df.percentage.abs().round(1)` – yatu Dec 23 '19 at 11:53 — yatu, Dec 23 '19 at 11:53

score 0 · Answer 1 · answered Dec 23 '19 at 11:54

You can do this way using round function inside abs:

>>> df.percentage = df.percentage.apply(lambda x: abs(round(x, 2)))
>>> df
   strain  Standardforce    stress  percentage
1    10.4        24400.0  2.750646        20.8
2    10.4        24200.0  2.728100        20.8
3    10.4        24100.0  2.716826        23.8
4    10.4        23900.0  2.694280        20.8

how to change the values in column to positive and roundoff to single decimal point using pandas

1 Answers1