Absolute value for column in Python

Question

How could I convert the values of column 'count' to absolute value?

A summary of my dataframe this:

             datetime   count
0   2011-01-20 00:00:00 14.565996
1   2011-01-20 01:00:00 10.204177
2   2011-01-20 02:00:00 -1.261569
3   2011-01-20 03:00:00 1.938322
4   2011-01-20 04:00:00 1.938322
5   2011-01-20 05:00:00 -5.963259
6   2011-01-20 06:00:00 73.711525

score 86 · Accepted Answer · answered Mar 16 '15 at 12:50

86

Use pandas.DataFrame.abs().

import pandas as pd

df = pd.DataFrame(data={'count':[1, -1, 2, -2, 3, -3]})

df['count'] = df['count'].abs()

print(df)
   count
#0      1
#1      1
#2      2
#3      2
#4      3
#5      3

answered Mar 16 '15 at 12:50

Ffisegydd

47,839
14
137
116

what if I want to maintain the datetime as my first column? – Mwspencer Apr 02 '18 at 15:37
4

@Mwspencer just make a new column: `df['abs'] = df['count'].abs()` – Tiffany G. Wilson Apr 16 '18 at 17:05
Get `SettingWithCopyWarning` – cpage Mar 25 '22 at 14:10

Absolute value for column in Python

1 Answers1

Linked

Related