How to use pycountry_convert to create a new column in a DataFrame that lists the continent that the country is in?

user_18626521 0
Viewed 216

I have a DataFrame as follows

df = pd.DataFrame({'Country':['Italy', 'Spain', 'China']})

I wish to create a new column called 'Continent'.

I also know of pycountry_convert, that outputs a continent code. eg this:

country_code = pc.country_name_to_country_alpha2("Germany", cn_name_format="default")
print(country_code)
continent_name = pc.country_alpha2_to_continent_code(country_code)
print(continent_name)

How can I use this code to update the new column of 'Continent'?

pandas python
1 Answers

Use lambda function:

f = lambda x: pc.country_name_to_country_alpha2(x, cn_name_format="default")
df['new'] = df['Country'].apply(f)

Or list comprehension:

df['new'] = [pc.country_name_to_country_alpha2(x, cn_name_format="default") 
                                                                    for x in df['Country']]
user_29010020
Related