How can I select a list of countries from a dataset

Questions
1

I have a dataset with a list of all countries in the world and some other attributes from 1945 to 1990, I want to extract only these countries (please see below) from the dataset from 1970 upwards. I tried the code but it doesn’t work. Do you have any suggestions?

Query[Select[#year >=
1970&& #country == {"Ethiopia", "Venezuela", "Canada",
"Finland", "Brazil", "China", "Greece", "Italy",
"Netherlands", "Norway", "Kenya", "Sweden"} &]]@dataset11
2

This part of your expression,

#country == {"Ethiopia", "Venezuela", "Canada","Finland", "Brazil", "China", "Greece", "Italy","Netherlands", "Norway", "Kenya", "Sweden"}

will cause the query to look for a value in the country column that is literally that list. You might want to try MemberQ instead.

3

Thanks, Eric. MemberQ only tests the list and returns a True/False output, what I’m trying to do is extract from the dataset any row that contains the stated countries.

4
Open in Wolfram Cloud ↗
5

Ohhhh I understand now. It worked! Thanks a lot.