<jupyter_start><jupyter_text>lab13 - Analyzing COVID data in Python This data is from [The European CDC](https://www.ecdc.europa.eu/en/publications-data/download-todays-data-geographic-distribution-covid-19-cases-worldwide )<jupyter_code>%matplotlib inline
import pandas<jupyter_output><empty_output><jupyter_text>Import data from S3<jupyter_code>df = pandas.read_excel('s3://ia241spring2022bush/covid_data.xls')
df[:10]<jupyter_output><empty_output><jupyter_text>Sum of Monthly Case Numbers<jupyter_code>sum_death_by_date = df.groupby('month').sum()['cases']
sum_death_by_date.plot()<jupyter_output><empty_output><jupyter_text>Top 10 Countries by COVID deaths<jupyter_code>sum_death_by_country = df.groupby('countriesAndTerritories').sum()['deaths']
sum_death_by_country.nlargest(10).plot.bar()<jupyter_output><empty_output><jupyter_text>Unique Countries and Territories<jupyter_code>pandas.unique(df['countriesAndTerritories'])<jupyter_output><empty_output><jupyter_text>United States Data<jupyter_code>usa_data = df.loc[df['countriesAndTerritories'] == 'United_States_of_America']
usa_data[:10]<jupyter_output><empty_output><jupyter_text>Relating US case data and deaths<jupyter_code>usa_data.plot.scatter(x='cases',y='deaths', c='month')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.13296616837136113, 'fraction_numerical': 0.016522423288749016, 'mean_word_length': 13.133333333333333, 'pattern_counts': {'":': 0, '<': 29, '<?xml version=': 0, '>': 29, 'https://': 1, 'lorem ipsum': 0, 'www.': 1, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '7', 'dir': 'jupyter-structured-clean-dedup', 'id': '281313', 'license': 'MIT', 'n_tokens_mistral': 503, 'n_tokens_neox': 477, 'n_words': 49, 'path': 'Lab13.ipynb', 'repo_name': 'bushjd/ia241-github-1', 'size': '1271'}