I am trying to extract the country name from one of the data frame columns. The data frame looks like below image link:
[Data Frame image](https://i.stack.imgur.com/ZiHwx.png)
Data frame: 
Department of Atmospheric Science, Yunnan University, Kunming, China
I have something similar to the above text in each row of the affiliation column.

I want to extract country names from the Affiliation column and keep them in a new column for each row.
I am new to Python and have tried below code, but it didn't work and returned nothing.

```
Cntr = []
for country in pycountry.countries:
    if country.name in authors.Affiliation:
        Cntr.append(country.name)

```