In this case, I want to get the objects that contain a certain value stored in their "value" property list.
import pandas as pd
mydataset = [{"name": "test", "values": ["3", "7", "2"]}, {"name": "test2", "values": ["4", "1", "7"]}]
myvar = pd.DataFrame.from_records(mydataset)
print(myvar[myvar["values"].isin(["3"])])
This code returns an empty data frame.
If I initialize the dataframe with a single object it works. How can I filter them when the list is a property value?