<jupyter_start><jupyter_text>Analyzing Mexico's COVID-19 Data in Python ![covid image](https://cdn11.bigcommerce.com/s-ey7tq/images/stencil/1280x1280/products/3421/18792/mexico-flag__84644.1575325491.jpg?c=2)  _Mexico flag_  Data Source  The COVID-19 pandemic is an ongoing pandemic caused by the virus SARS-CoV-2. It became a declared pandemic in March of 2020 by the World Health Organization. This data is from the [European Centre for Disease Prevention and Control]('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 Bucket<jupyter_code>df = pandas.read_excel('s3://cassidy-ia241-2021spring/COVID-19-geographic-disbtribution-worldwide-2020-12-14(1).xls')<jupyter_output><empty_output><jupyter_text>Mexico's Data<jupyter_code>df['case_to_pop_ratio']=df['cases']/df['popData2019']*100000000
mexico_data = df.loc[ df['countriesAndTerritories']=='Mexico' ]

mexico_data[:10]<jupyter_output><empty_output><jupyter_text>_This table shows 10 rows of data for Mexico and at the end (scroll to the right) you will see the ratio per day of cases to population._  Ratio of Cases to Total Population<jupyter_code>mexico_data.plot.scatter(x='cases',y='popData2019',c='case_to_pop_ratio')<jupyter_output><empty_output><jupyter_text>_This scatter plot shows the cases to population ratio._  Total Cases Over Time<jupyter_code>mexico_data.plot.line(x='month',y='cases')<jupyter_output><empty_output><jupyter_text>_This scatter plot shows the cases over the months from January to December._  Total Deaths Over Time<jupyter_code>mexico_data.plot.line(x='month',y='deaths')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.11362351611079706, 'fraction_numerical': 0.0497456189937818, 'mean_word_length': 7.9393939393939394, 'pattern_counts': {'":': 0, '<': 25, '<?xml version=': 0, '>': 25, 'https://': 2, 'lorem ipsum': 0, 'www.': 1, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 1, 'word_list_counts': {'cursed_substrings.json': 1, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '6', 'dir': 'jupyter-structured-clean-dedup', 'id': '650686', 'license': 'MIT', 'n_tokens_mistral': 689, 'n_tokens_neox': 611, 'n_words': 124, 'path': 'IA 241 Final Project.ipynb', 'repo_name': 'Lilcasscass/IA241', 'size': '1769'}