In this exercise, you'll redo the data gathering phase of the UNData Exploration project by using APIs instead of downloading csv files.
You'll make use of the World Bank Indicators API. Note that this API does not require an API key. Before attempting the exercise, it would be a good idea to skim through the Documentation page and to check out the Basic Call Structure article.
-
Use the API to get all available data for the GDP per capita, PPP (constant 2021 international $) indicator. Hint: this indicator has code "NY.GDP.PCAP.PP.KD". Adjust the query parameters so that you can retrieve all available rows. Convert the results to a DataFrame.
-
Now, use the API to get all available data for Life expectancy at birth, total (years). This indicator has code "SP.DYN.LE00.IN". Again, convert the results to a DataFrame.
-
Merge the two results DataFrames together. You may want to rename or drop columns prior to merging.
-
You can also get more information about the available countries (region, capital city, income level classification, etc.) by using the Country API. Use this API to pull in all available data. Merge this with your other datasets. Use this to now remove the rows that correspond to regions and not countries.
Bonus Questions: After doing a basic request to get all records, you can attempt these exercises to get additional practice using query parameters.
-
Adjust your request so that it returns data just for the United States.
-
Adjust your request so that it returns data just for the United States for the year 2021.
-
Adjust your request so that it returns data just for the United States for the years 2000 through 2021.
-
Adjust your request so that it returns data for the United States and Canada for the years 2000 through 2021.
-
If you haven't already done so and you would like to get some additional practice using loops, use the page parameter in order to pull all records. Do not change the value of the per_page parameter. You will likely need to utilize a loop of some kind in order to pull all records.
-
The endpoint "http://api.worldbank.org/v2/indicator" will return information about all available indicators. See Indicator API Queries. Use this endpoint to find the code for the "Public Expenditure on Education (% GDP)" indicator.