How to convert date format string to bool True and others to False?

manpreet Best Answer 2 years ago

b.com/tag/import">import pandas
b.com/tag/import">import numpy
df=pandas.DataFrame({'col1':['a','b','c','b'],'col2':['N','2018-03-12 15:35',numpy.NaN,'2017-06-12 15:35'],'col3':['c','b','b','b']})
print(df)

Output of above script is:

  col1              col2 col3
0    a                 N    c
1    b  2018-03-12 15:35    b
2    c               NaN    b
3    b  2017-06-12 15:35    b

As to column col2,I want to convert all yyyy-mm-dd hh:mm format string to bool True,others to False,keep Na value as same.
The expect result as below:

  col1              col2 col3
0    a             False    c
1    b              True    b
2    c               NaN    b
3    b              True    b

How to do it? Thanks in advance!

manpreet 2 years ago

Create 2 masks - first convert to_datetimes with errors='coerce' and test Series.notna and also test this column:

mcom/tag/1">1 = pd.to_datetime(df['col2'], errors='coerce').notna()
m2 = df['col2'].notna()

Then pass it to numpy.select - but is necessary convert NaN to None:

df['col2'] = np.select([mcom/tag/1">1, m2], [True, False], None)
print(df)
0    a  False    c
com/tag/1">1    b   True    b
2    c   None    b
3    b   True    b

Or use DataFrame.loc:

df.loc[m2, 'col2'] = mcom/tag/1">1
print(df)
  colcom/tag/1">1   col2 col3
0    a  False    c
com/tag/1">1    b   True    b
2    c    NaN    b
3    b   True    b