I have below code
<code>import pandas as pd
import numpy as np
df = pd.DataFrame({
'CUSTOMER_name': ['abc', 'def', 'abc', 'def', 'abc', 'fff'],
'DATE': ['NaT', 'NaT', '2010-04-15 19:09:08', '2011-01-25 15:29:37', '2010-04-10 12:29:02', 'NaT']})
df.DATE = pd.to_datetime(df.DATE)
df['New'] = np.where(df['DATE'] == np.datetime64('NaT'), 1, 0)
</code>
<code>import pandas as pd
import numpy as np
df = pd.DataFrame({
'CUSTOMER_name': ['abc', 'def', 'abc', 'def', 'abc', 'fff'],
'DATE': ['NaT', 'NaT', '2010-04-15 19:09:08', '2011-01-25 15:29:37', '2010-04-10 12:29:02', 'NaT']})
df.DATE = pd.to_datetime(df.DATE)
df['New'] = np.where(df['DATE'] == np.datetime64('NaT'), 1, 0)
</code>
import pandas as pd
import numpy as np
df = pd.DataFrame({
'CUSTOMER_name': ['abc', 'def', 'abc', 'def', 'abc', 'fff'],
'DATE': ['NaT', 'NaT', '2010-04-15 19:09:08', '2011-01-25 15:29:37', '2010-04-10 12:29:02', 'NaT']})
df.DATE = pd.to_datetime(df.DATE)
df['New'] = np.where(df['DATE'] == np.datetime64('NaT'), 1, 0)
However I am getting all value of df['New'] as 0, whereas I expected to get 1 where DATE == NaT
How can I correct above code?