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...

Install Python and its libraries for Windows users: 1. Install Python latest stable version from the following (click here  official website ). For example, you can use the x86-64 executable installer 2. Install all useful libraries (incl. scipy, pandas, numpy) in a single command:        a. Open your command prompt by typing 'cmd' on your Windows home screen      b. Copy and paste the following command line in your 'Command Prompt' and press enter.      python - m pip install -- user numpy scipy matplotlib ipython jupyter pandas sympy nose   3. As a text editor to type in your programs, you can install Notepad++ from (click here  its official website ). 4. To configure Notepad++ with Python you can watch the short Youtube video You are ready to GO!