Guest User

Untitled

a guest
Jul 17th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. df = pd.DataFrame({'b':[False,True,False,True,False]})
  2.  
  3. # changes all False values to NaN
  4. df.loc[~df['b'], 'b'] = np.nan
  5.  
  6. print(df.to_dict())
  7. # {'b': {0: nan, 1: 1.0, 2: nan, 3: 1.0, 4: nan}}
  8.  
  9. In[200]:
  10. df = pd.DataFrame({'b':[False,True,False,True,False]})
  11. df['b'] = df['b'].astype(np.object)
  12. # changes all False values to NaN
  13. df.loc[df['b']==False, 'b'] = np.nan
  14. df
  15.  
  16. Out[200]:
  17. b
  18. 0 NaN
  19. 1 True
  20. 2 NaN
  21. 3 True
  22. 4 NaN
  23.  
  24. KeyError: '[-1 -2 -1 -2 -1] not in index'
  25.  
  26. print(type(df['b'].iloc[0]))
  27. print(type(df['b'].iloc[1]))
  28. <class 'float'>
  29. <class 'bool'>
Add Comment
Please, Sign In to add comment