pandas - Convert bool object to bool primitive in a column

Question

The df has a column named isInDST which is a bool object type.

df.isInDST

0          True
1          True
2          True
3          True
4          True
5          True
6          True
7          True
8          True
9          True
...         ...  
849350    False
849351    False
849352    False
849353    False
849354    False
849355    False
849356    False
849357    False
849358    False
849359    False
Name: isInDST, Length: 849360, dtype: object

This isInDST column was created from a map function:

df['isInDST'] = pd.DatetimeIndex(df['time']).tz_localize('UTC').tz_convert('Australia/Victoria').map(lambda x : bool(x.dst().total_seconds()!=0))

I think my question is how to edit the map function to make isInDST become a bool primitive type rather than object?

`df['isInDST'] = pd.to_timedelta(df['time']) !=0`? – Quang Hoang Apr 07 '21 at 23:50 — Quang Hoang, Apr 07 '21 at 23:50
or just `df['isInDST'] = df['isInDST'].astype(bool)`. – Quang Hoang Apr 07 '21 at 23:51 — Quang Hoang, Apr 07 '21 at 23:51

BENY · Accepted Answer · 2021-04-08T00:23:10.820

0

Just fix your problem

df['isInDST'] = df['isInDST'].astype('bool')

Update

df['isInDST'] = pd.DatetimeIndex(df['time']).tz_localize('UTC').tz_convert('Australia/Victoria').map(lambda x : x.dst().total_seconds()!=0)

edited Apr 08 '21 at 00:23

answered Apr 07 '21 at 23:51

BENY

317,841
20
164
234

Can we edit the map function to achieve this? – alextc Apr 08 '21 at 00:21
@alextc remove the bool ~ – BENY Apr 08 '21 at 00:23
This still generated the bool object. – alextc Apr 08 '21 at 00:40
@alextc without seeing the the data the easy fix will be `df['isInDST'] = df['isInDST'].astype('bool') ` – BENY Apr 08 '21 at 00:41
I am happy to accept it. However further to this post are you able to help with another question? https://stackoverflow.com/questions/66995959/pandas-how-to-improve-performance-on-a-lambda-function-on-a-massive-dataframe – alextc Apr 08 '21 at 00:54

pandas - Convert bool object to bool primitive in a column

1 Answers1