Trying filter function

[Duck]

Hello everyone,

When i try to use the filter function on my data_set like this:

songs %>% 
  filter(name == "RAP DEVIL", artists == "Machine Gun Kelly")

The output is just like this:

# A tibble: 0 × 18
# … with 18 variables: acousticness <dbl>, artists <chr>, danceability <dbl>, duration_ms <dbl>, energy <dbl>, explicit <dbl>,
#   instrumentalness <dbl>, key <dbl>, liveness <dbl>, loudness <dbl>, mode <dbl>, name <chr>, popularity <dbl>,
#   speechiness <dbl>, tempo <dbl>, valence <dbl>, year <dbl>, cluster <int>
# ℹ Use `colnames()` to see all variable names

can anybody help me what i did wrong. Thanks

[scottyd22]

Are you able to share the songs dataset? It's hard to troubleshoot without it.

[Duck]

Sure! Here is the data set

songs

[fcas80]

I see the first artist is ['Carl Woitschach']

Try

filter(name == "RapDevil", artists == "['Machine Gun Kelly']")

[Duck]

Thank you so much! I really thought that I should not include the ['..'] hahaha my mistake.

[scottyd22]

It looks like this would work.

filter(name == 'RAP DEVIL', str_detect(artists, 'Machine Gun Kelly'))

[Duck]

It also worked thanks so much!