Skip to content
New Workbook
Sign up
World Internet Usage
0

Analysis Report On:

How Much of the World Has Access to the Internet?

This report was curated to aid the firm's principal with her presentation on the state of internet access in the world..

💾 The data

Tables compiled by the research team (source):
internet
  • "Entity" - The name of the country, region, or group.
  • "Code" - Unique id for the country (null for other entities).
  • "Year" - Year from 1990 to 2019.
  • "Internet_usage" - The share of the entity's population who have used the internet in the last three months.
people
  • "Entity" - The name of the country, region, or group.
  • "Code" - Unique id for the country (null for other entities).
  • "Year" - Year from 1990 to 2020.
  • "Users" - The number of people who have used the internet in the last three months for that country, region, or group.
broadband
  • "Entity" - The name of the country, region, or group.
  • "Code" - Unique id for the country (null for other entities).
  • "Year" - Year from 1998 to 2020.
  • "Broadband_Subscriptions" - The number of fixed subscriptions to high-speed internet at downstream speeds >= 256 kbit/s for that country, region, or group.

Acknowledgments: Max Roser, Hannah Ritchie, and Esteban Ortiz-Ospina (2015) - "Internet." OurWorldInData.org.

Principal's questions

  1. What are the top 5 countries with the highest internet use (by population share)? (Invalid URL)
  2. How many people had internet access in those countries in 2019? (Invalid URL)
  3. What are the top 5 countries with the highest internet use for each of the following regions: 'Africa Eastern and Southern', 'Africa Western and Central', 'Latin America & Caribbean', 'East Asia & Pacific', 'South Asia', 'North America', 'European Union'? (Invalid URL)
  4. Create a visualization for those five regions' internet usage over time. (Invalid URL)
  5. What are the 5 countries with the most internet users? (Invalid URL)
  6. What is the correlation between internet usage (population share) and broadband subscriptions for 2019? (Invalid URL)
  7. Summary (Invalid URL)

Importing modules

import pandas as pd
import numpy as np
import plotly.graph_objs as go
import plotly.offline as po
po.init_notebook_mode(connected=True)

Loading and assessing broadband table

# Read the broadband table
broadband = pd.read_csv('data/broadband.csv')

# table preview
broadband.head()
# Checking for null values across variables
broadband.isnull().sum()
# Counting observations with zero (0) broadband subscription
(broadband.Broadband_Subscriptions == 0).sum()
# Preview observations with no broadband subscription
broadband[broadband.Broadband_Subscriptions == 0]
# Counting unique broadband entity
len(broadband.Entity.unique())
# Counting unique broadband code
len(broadband.Code.unique())
# Counting unique broadband year
len(broadband.Year.unique())
# Checking general info including data type
broadband.info()

Loading and assessing internet table

‌
‌
‌