<jupyter_start><jupyter_text>Visualizing COVID-19 Data in Egypt as of December, 2020  What is COVID-19? According to the [Center for Disease Control and Prevention](https://www.cdc.gov/coronavirus/2019-ncov/faq.htmlBasics), COVID-19 is a new coronavirus not previously seen in humans, spread primarily through respiratory droplets, with the lesser possibilities of being spread by airborne transmission and contact with contaminated surfaces. Effects range from none/mild to severe illness and possibily death, varrying in most cases but more dangerous among the elderly and immunosuppressed.  Data Source The 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
df = pandas.read_excel('s3://peters-ia241-2021-spring/COVID-19-geographic-disbtribution-worldwide-2020-12-14 (2).xls')<jupyter_output><empty_output><jupyter_text>An Overview of Egypt's Data<jupyter_code>egy_data = df.loc[df['countriesAndTerritories'] == 'Egypt']
egy_data[:10] #the top 10 rows<jupyter_output><empty_output><jupyter_text>At this point in time, Egypt was averaging cases in the 400s-per-day, while suffering deaths from COVID-19 cases between 18-23 each day.  COVID-19 Cases and Deaths by Month<jupyter_code>egy_data.plot.scatter(x='cases',y='deaths',c='month')<jupyter_output><empty_output><jupyter_text>Here we can see the rising total number of cases and deaths from COVID-19 through the year 2020 in Egypt.  Number of COVID-19 cases in Egypt as of December, 2020<jupyter_code>egy_data['cases'].sum()
print('As of December, 2020, the total number of COVID-19 cases, in egypt was {}. This number includes those who had active cases, those who had recovered, and those who had died.'.format(egy_data['cases'].sum()))<jupyter_output>As of December, 2020, the total number of COVID-19 cases, in egypt was 121575. This number includes those who had active cases, those who had recovered, and those who had died.<jupyter_text>Deaths in Egypt from COVID-19 as of December, 2020<jupyter_code>egy_data['deaths'].sum()
print('As of December 2020, the total number of deaths resulting from COVID-19 cases in Egypt is {}.'.format(egy_data['deaths'].sum()))<jupyter_output>As of December 2020, the total number of deaths resulting from COVID-19 cases in Egypt is 6920.<jupyter_text>Ratio of Recoveries from COVID-19 to Deaths from COVID-19 in Egypt as of December, 2020<jupyter_code>print('As of December 2020, the ratio of recoveries to deaths from COVID-19 cases in Egypt is {}:1. This means that for about every 18th person recovering from their COVID-19 illness in Egypt, one person dies from theirs.'.format(egy_data['cases'].sum()/egy_data['deaths'].sum()))<jupyter_output>As of December 2020, the ratio of recoveries to deaths from COVID-19 cases in Egypt is 17.56864161849711:1. This means that for about every 18th person recovering from their COVID-19 illness in Egypt, one person dies from theirs.<jupyter_text>Comparison of Cases and Deaths from COVID-19 in Egypt<jupyter_code>egy_data.plot.bar(x='deaths',y='cases')<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.09102244389027432, 'fraction_numerical': 0.046758104738154616, 'mean_word_length': 6.021881838074398, 'pattern_counts': {'":': 0, '<': 26, '<?xml version=': 0, '>': 26, 'https://': 2, 'lorem ipsum': 0, 'www.': 2, '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': '153294', 'license': 'MIT', 'n_tokens_mistral': 1078, 'n_tokens_neox': 944, 'n_words': 355, 'path': 'Final Project.ipynb', 'repo_name': 'peter3kr/IA241', 'size': '3208'}