A dataframe has a row which has None in 'GROUP ID' column:
>>> df_temp = df_ccl_2.loc[(df_ccl_2['COUNTERPARTY ID'] == 'DRV_800929_LE') & (df_ccl_2['OWN ENTITY ID'] == 'BERHAD'), ['GROUP ID','COUNTERPARTY ID','OWN ENTITY ID']]
>>> df_temp
GROUP ID COUNTERPARTY ID OWN ENTITY ID
33894 None DRV_800929_LE BERHAD
>>> df_temp.iloc[0,0] == None
True
however, when I tried to select this row with condition: df_ccl_2['GROUP ID'] == None, it retuns empty dataframe:
>>> df_temp = df_ccl_2.loc[(df_ccl_2['GROUP ID'] == None) & (df_ccl_2['COUNTERPARTY ID'] == 'DRV_800929_LE') & (df_ccl_2['OWN ENTITY ID'] == 'BERHAD'), ['GROUP ID','COUNTERPARTY ID','OWN ENTITY ID']]
>>> df_temp
Empty DataFrame
Columns: [GROUP ID, COUNTERPARTY ID, OWN ENTITY ID]
Index: []
Anyone knows what is going on?