-5

I want to just keep the rows whose last column is either positive or zero or NaN.

Prabhakar
  • 1,138
  • 2
  • 14
  • 30
Shan-E-Zehra Lashari
  • 53
  • 1
  • 8
  • I would recommend checking this post out: https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples – Brian Feb 04 '18 at 03:28

1 Answers1

1

Not really sure what you are going for given the lack of information. But you could use .loc to create and indicator column. Then you would be able to filter on the indicator column for the desired rows.

df.loc[df['Column'] > 0, 'Indicator'] = 'Positive'
df.loc[df['Column'] = 0, 'Indicator'] = 'Zero'
df.loc[df['Column'].isnull(), 'Indicator'] = 'NaN'
Brian
  • 2,163
  • 1
  • 14
  • 26