Mapping country name to multiple-region designation

Solution 1:

Here's a way I believe. Unfortunately I wasn't able to get the different sized lists into the Dataframe so you'd just have to do a query on the contents of Region to determine if "ROW" and "EU" are present.

countries = ['ITALY', 'UNITED STATES', 'CHINA', 'FRANCE', 'BRAZIL']

regions = [['ROW, EU'], ['UNITED STATES'], ['ROW, ASIA'], ['ROW, EU'], ['ROW']]

region_map = dict(zip(countries, regions))

df = pd.DataFrame(data={'COUNTRY': countries})

df['REGION'] = ""

for country in region_map:
    df.loc[df['COUNTRY'] == country, 'REGION'] = region_map[country]

print(df)

         COUNTRY         REGION
0          ITALY        ROW, EU
1  UNITED STATES  UNITED STATES
2          CHINA      ROW, ASIA
3         FRANCE        ROW, EU
4         BRAZIL            ROW