My DataFrame:
Trying...
Nope...
Still nope...
AND YET...
Any idea why I can't filter this dataframe by a list using isin?
I'm expecting it to return one or more rows where the Chord Notes column equals the list ['C','E','G']
-
2Don't make us retype code from an image. Please post all code, input, output, and error messages as plain text.John Gordon– John Gordon2023-03-24 01:31:19 +00:00Commented Mar 24, 2023 at 1:31
-
1reason being that column contains a actual list objectsAnurag Dabas– Anurag Dabas2023-03-24 01:33:28 +00:00Commented Mar 24, 2023 at 1:33
-
You need to put the list ['C', 'E', 'G'] inside a list, like [['C', 'E', 'G']]Lucas Moura Gomes– Lucas Moura Gomes2023-03-24 01:34:17 +00:00Commented Mar 24, 2023 at 1:34
-
Anurag, so how would you solve?Sir Roland Baggybottom IV– Sir Roland Baggybottom IV2023-03-24 01:35:18 +00:00Commented Mar 24, 2023 at 1:35
-
Thank you lucas, your answer was correct as wellSir Roland Baggybottom IV– Sir Roland Baggybottom IV2023-03-24 01:45:59 +00:00Commented Mar 24, 2023 at 1:45
Add a comment
|
1 Answer
you can still use isin() but since the values under 'Chord Notes' are actual list object so you have to pass that list object i.e ['C','E','G'] in isin() method
output = full_chords[full_chords['Chord Notes'].isin([['C','E','G']])]
Or with map() (kind of loop under the hood):
output = full_chords[full_chords['Chord Notes'].map(lambda x:x==['C','E','G'])]
Or
Other way around is to typecast that column to string(not recommended but still an option tho):
output = full_chords[full_chords['Chord Notes'].astype(str).eq("['C','E','G']")]
1 Comment
Sir Roland Baggybottom IV
Thank you, this worked perfectly and the logic makes sense.
