# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3.6.9 64-bit
#     language: python
#     name: python36964bitf8533a4c57ce4aff9d3b14fa5b76fef6
# ---

import pandas as pd
#------------------------Read in data ---------------------------
#-----------------Cumulative and density data --------
df1 = pd.read_csv('./../data/external/global_data.csv')
df2 = pd.read_csv('./../data/external/data.csv')


df1.head()

df2.head()

#-------- Drop unwanted columns -- 
df2 = df2.drop('rank',axis=1)
df1 = df1.drop(['Slug','CountryCode'],axis=1)
df2 = df2.rename(columns={'name': 'Country'})

df_joined = df1.join(df2.set_index('Country'), on='Country')

df_joined.head()

StarcoderdataJupyterScriptsDedupFiltered