You will need the below DataFrames to answer the following questions. country_map_df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/AnalyseProject/country_code_map.csv', index_col='Country Code') population_df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 20RA
icon
Related questions
Question

You will need the below DataFrames to answer the following questions.

country_map_df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/AnalyseProject/country_code_map.csv', index_col='Country Code')
population_df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/AnalyseProject/world_population.csv', index_col='Country Code')
meta_df = pd.read_csv('https://raw.githubusercontent.com/Explore-AI/Public-Data/master/AnalyseProject/metadata.csv', index_col='Country Code')

DataFrame specifications:

The DataFrames provide information about the population of the world for various years. Some things to note:

  • All DataFrames have a Country Code as an index, which is a three-letter code referring to a country.
  • The country_map_df data maps the Country Code to a Country Name.
  • The population_df data contains information on the population for a given country between the years 1960 and 2017.
  • The meta_df data contains meta-information about each country, including its geographical region, its income group, and a comment on the country as a whole.

Question 

Write a function that will return a list of countries for a specified region and income group. If the specified region and income group do not return a country, return None as the value.

Function specifications

Argument(s):

  • region (string) →→ the region you want to query.
  • income_group (string) →→ the income group you want to query.

Return:

  • countries (list) →→ return a list of countries that match the search criteria or None if no countries are found.

Expected output

find_countries_by_region_and_income('South Asia','High income')==None find_countries_by_region_and_income('Europe & Central Asia','Low income')==['Tajikistan'] find_countries_by_region_and_income('Sub-Saharan Africa','Upper middle income')==['Botswana','Gabon','Equatorial Guinea','Mauritius','Namibia','South Africa']

Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Elements of Tables
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning