How to solve pandas dataframe column is not recognizing its value

Question

I am using Kaggle Spotify 1921-2020 (data.csv) dataset which contain a column 'artists' which is of object datatype, I tried to perform conditional extraction on the data-frame spotify[spotify['artists'] == 'Dennis Day'] it outputs no row it happens no matter what value I put in. I tried to change its data type to str spotify.artists.apply(str) but still, nothing happened and its datatype is still showing as object

What I did till now

# previously the value was like
0                                       ['Dennis Day']
1    ['Sergei Rachmaninoff', 'James Levine', 'Berli...


# I remove the square braces
spotify['artists'] = spotify['artists'].apply(lambda x : x[1:-1])

0                                         'Dennis Day'
1    'Sergei Rachmaninoff', 'James Levine', 'Berlin...

# since it was giving no output for any value I checked this
for i in songs.artists.head(10):
    print(f'{i} is present {i in songs.artists}')

# and see what I get

'Dennis Day' is present False
'Sergei Rachmaninoff', 'James Levine', 'Berliner Philharmoniker' is present False
'John McCormack' is present False

# don't get confused if somewhere it is written songs and instead of spotify they are same.

I tried to change Kaggle notebook to jupyterlab but it's same all around so what should I do now

It seems to me that the single ticks are included in the string. — Kris, Jun 10 '20 at 05:51
Have a look at https://stackoverflow.com/questions/49393053/using-in-operator-with-pandas-series — Kris, Jun 10 '20 at 06:57
Does this answer your question? [Using in operator with Pandas series](https://stackoverflow.com/questions/49393053/using-in-operator-with-pandas-series) — Kris, Jun 10 '20 at 06:57
Yeah it helped me to understand why it's giving me an error but I am still not able to do conditional extraction on that dataframe @Kris — Darkstar Dream, Jun 10 '20 at 07:47

score 0 · Accepted Answer · answered Jun 10 '20 at 06:57

0

For the conditional extraction on the data-frame, try using .loc:

spotify.loc[spotify['artists'] == 'Dennis Day']

answered Jun 10 '20 at 06:57

Victor Correra

28
1
5

How to solve pandas dataframe column is not recognizing its value

1 Answers1