Autism RSV Geo Gif (Part 3)

import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
import geopandas
import warnings

warnings.filterwarnings("ignore")

countries= pd.read_csv('cleaned_countries.csv')
languages = pd.read_csv('rsv_languages.csv')

countries.head()

countries['chinees'].nlargest(5)

languages.head()

countries_gdf = geopandas.read_file('countries.geo.json')

countries_gdf.head()

countries_geo = countries.merge(countries_gdf, how='left', left_on='code', right_on='id')
countries_geo.drop(columns=['id', 'name'], inplace=True)
countries_geo.head()

#lets try to combine the countries and languages on a small subset
test = languages[languages['date']>'2020-01-01']

test.head()

test.shape

test.set_index('date', inplace=True)