Question: Ingest and manipulate the data using pandas dataframes. Your program should include a function which takes a filename as argument, reads a dataframe in World

Ingest and manipulate the data using pandas dataframes. Your program should
include a function which takes a filename as argument, reads a dataframe in World-
bank format and returns two dataframes: one with years as columns and one with
countries as columns. Do not forget to clean the transposed dataframe.
Explore the statistical properties of a few indicators, that are of interest to you, and
cross-compare between individual countries (you do not have to do all the countries,
just a select few will do) and produce appropriate summary statistics. You can also
use aggregated data for regions and other categories. You are expected to use the
.describe() method to explore your data and two other statistical methods.
Explore and understand any correlations (or lack of) between indicators (e.g. popu-
lation growth and energy consumption). Does this vary between country, have any
correlations or trends changed with time?
You are expected to use your initiative and tell a story with the data. You should
use appropriate visualisation (hint: time series could be useful) and provide a text
narrative to communicate and explain your findings. Details of the implementation
and the coding do not belong in such a report. Your boss wants to see results and
interpretation. What are the key findings?
You will be assessed on the overall quality of the report, good use of visualisation
tools and good use of the methods and tools available for dataframes. See mark
scheme for details. Good reports often combine information from graphs to draw
conclusions or follow up on insights/questions from one graph with another graph.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

This question is complete and asks you to ingest and manipulate data using pandas dataframes extract and analyze statistical properties of specific in... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!