dillinger | The last Markdown editor | Editor library

I have two data frames -

One data frame has a column with a list of music artists (one artist per row). There are 10K rows. This data has demographics (Country, Age) for every artist.

There is also another data frame with a column of artists and their songs. - 32,000 rows of this data

I am not able to match the artist from the first dataframe to the second because in the second have Snoop Dogg and other artists with it. I have tried running a few codes using grepl, created a vector based on the first data frame column of artists to match to the Artist column in the second data frame but it runs "out of memory". I have also unnested the data but it gives me a big error saying the following:

Error: Must subset columns with a valid subscript vector. x Subscript has the wrong type data.frame< X : integer index : integer artist : character gender : character age : integer type : character country : character city_1 : character district_1: character city_2 : character district_2: character city_3 : character district_3: character >. ℹ It must be numeric or character. Run `rlang::last_error()

The desired output is the following:

A few codes I have tried -

df3 <- cbind(df3, yes = grepl(paste(art_v, collapse = "|"), df3$art))

Error in grepl(paste(art_v, collapse = "|"), df3$art) : invalid regular expression, reason 'Out of memory'

Would really appreciate some help!

i haven't tried python for this yet. All my codes are in R, but if you have suggestion on how to do this in python, open to it for sure!

I'm trying to figure out how to reach and display nested arrays in an external JSON-file.
In the example below "color" is an array with exactly two different colors. In real I would like this number to shift between one and more colors, but to get an output I have used exactly two colors.

Right now: If one searches for example "bl" the program will return all names that start with "bl", but only colors with index 0. Never index 1.

Wanted result: The user should be able to search for colors, regardless of where in the "color"-array the color is.

I have searched here on SO and elsewhere, but I haven't been able to transfer that info to my own project. The closest to a solution I've come was with restructuring. This way I could get the color of index 0 and the second color as an object when I console.log it. When I tried with for-loop, I only got the index of 0 even when I changed the 0 to I.

My JSON: