Data Analysis with Excel

  Statistics on Covid19 cases in a few regions in Saudia Arabia Data source :  King Abdullah Petroleum Studies and Research Center (KAPSARC) ,  Retrieved on 9-Sep-2020.   Objective : Get a glimpse of the Covid19 virus spread in KSA and visualize the curves of the total cases, active cases, recoveries, and mortalities. In the following, let us focus on a few regions in KSA, e.g., Riyadh, Mekka, Medinah, and Eastern.  KSA as a whole The cumulative number of cases in KSA are given in the following plot: The numbers 0,1,2,..., 13 in Red in the figure above are the dates at which special events took place, f or  example, Umrah suspension, curfew, and lockdowns. See the table below for details.   Let's see the summary statistics on the daily cases, recoveries, and mortalities in KSA as a whole.  

Statistics on Covid19 cases in a few cities in Saudia Arabia Data source : King Abdullah Petroleum Studies and Research Center (KAPSARC) ,  Retrieved on 7-Sep-2020.   Objective : Get a glimpse of the Covid19 virus spread in KSA and visualize the curves of the total cases, active cases, recoveries, and mortalities. The steps followed in making this report are: 1. Data collection and cleaning  2. Data exploration and filtering by City with Pandas' DataFrame 3. Visualizing the data with Matplotlib  In the following, let us focus on a few big cities in KSA, e.g., Riyadh, Jeddah, Mekka, Medinah, and Dammam. Before diving into the different results let us see the event data on the first registered case, curfew, and lockdown.  Riyadh Let's start with summary statistics on the daily cases, recoveries, and mortalities.   The cumulative number of cases in Riyad are given in the following plot: Jeddah The summary statistics of Jeddah daily cases are as follo...