0
1vat.loc[(vat['Sum of VAT'].isin([np.nan, 0])) &
2        (vat['Comment'] == 'Transactions 0DKK') &
3        (vat['Memo (Main)'] != '- None -'), 'Comment'] = 'Travel bill'
4vat[vat["Comment"] == "Travel bill"]

I have a problem with line 3. It seems not to be working properly when I'm trying to exclude a value in a certain column. The output from the data frame is too large and it's incorrect. are there any other alternatives than using !=, I don't understand why it doesn't work? If I were to use == then it works correctly but not when using !=, please help.

Henry Ecker
  • 34,399
  • 18
  • 41
  • 57
Darko86
  • 65
  • 1
  • 4

1 Answers1

0

After many tests, I think that line 3 works after testing different codes like:

(vat['Memo (Main)'].isin(['- None -'] ) == False), 'Comment'] = 'Travel bill'

OR:

(~vat['Memo (Main)'].isin(['- None -'])), 'Comment'] = 'Travel bill'

I have to backtrack and see why the data frame is not giving me the expected output.

Darko86
  • 65
  • 1
  • 4