Effect of Covid-19 in Egypt: an Instant Insight
Figure 1: Covid-19 confirmed and death cases distribution
Figure 2: month wise total figures
| Top 5 days of highest covid cases | ||
|---|---|---|
| Egypt | ||
| date | new_cases | new_deaths |
| 2020-06-19 | 1774 | 79 |
| 2020-06-15 | 1691 | 97 |
| 2020-06-13 | 1677 | 62 |
| 2020-06-26 | 1625 | 87 |
| 2020-06-14 | 1618 | 91 |
| Source:https://github.com/joachim-gassen/tidycovid19 | ||
Among the middle east countries, the effect of Covid-19 in Egypt is highlighted. It is an African nation, mainly famous for its Pyramids, Sphinx and Deserts. It is an important international tourist destination too. Data on new-cases, new-deaths and new-recoveries from beginning of the calendar year 2020 to 13th September 2021 are considered for analytics. Three different colours are used for visualization of data. Two graphs, one density plot and other one histogram are created for easy understanding. In the 1st plot, only two vital variables considered, viz. Number of New Infection cases and New Fatal cases. Hovering over the graph with the cursor, user can find the figure for the related month with date, all related information viz., new-cases, new-deaths. The graph as a whole provides the instant understanding of the status over the period.
The 2nd plot 2 is a histogram showing month wise total figures related to new-infection, new-deaths, new-recoveries. Three radio buttons provided at the bottom of the graph, showing different colours related to the three variables under watch. While putting the cursor on any button, that particular variable becomes prominent in the graph, with other two variables being in faint colour, rendering the viewer with clear understanding. The user had the freedom of choice to see the trends of a single variable also. Here the tool tip facility also provided to reveal the figures for the variables.
The revelation from the graphs shows that fatal cases are moderately low. The highest figure 1774 was recorded in June 2020. One noticeable point is that fatal case per day never exceeded 100 (highest figure is 97 on 15 June 2020). After vaccines were made available from March 2021, the figure was high in May ’21 with 1757 deaths, which gradually fell down to 205 in August ’21. New infection cases were also not very high. In June 2020, the highest figure was 43326 which fell down to 4259 in September 2020. From 16473 in Feb 2021, new infection cases rose to 35098 in May 2021. The figure fell to as low as 2980 in July and slightly rose to 4128 in August ’21. Covid management in Egypt was more or less commendable.
| Rank | country | New_cases | death_rate | death_rank | population | total_vaccinations | population_rank | Vax_Percentage |
|---|---|---|---|---|---|---|---|---|
| 1 | Iran | 4960744 | 2.160 | 6 | 83992953.00 | 27057253 | 2 | 16.107 |
| 2 | Iraq | 1881213 | 1.104 | 15 | 40222503.00 | 3368843 | 4 | 4.188 |
| 3 | Israel | 1061488 | 0.664 | 17 | 9216900.00 | 13618759 | 11 | 73.879 |
| 4 | Morocco | 856049 | 1.465 | 8 | 36910558.00 | NA | 5 | NA |
| 5 | Jordan | 796259 | 1.306 | 13 | 10203140.00 | NA | 9 | NA |
| 6 | UAE | 717374 | 0.284 | 20 | 9890400.00 | 18095160 | 10 | 91.478 |
| 7 | Tunisia | 662752 | 3.535 | 4 | 11818618.00 | 5683733 | 8 | 24.046 |
| 8 | Lebanon | 601226 | 1.339 | 11 | 6825442.00 | 2435581 | 13 | 17.842 |
| 9 | Saudi Arabia | 543318 | 1.567 | 7 | 34813867.00 | 36837337 | 6 | 52.906 |
| 10 | Kuwait | 409736 | 0.590 | 18 | 4270563.00 | NA | 16 | NA |
| 11 | PSE | 339816 | 1.081 | 16 | 4803269.00 | 1340889 | 15 | 13.958 |
| 12 | Libya | 307471 | 1.370 | 9 | 6871287.00 | NA | 12 | NA |
| 13 | Oman | 302239 | 1.344 | 10 | 5106622.00 | 3752420 | 14 | 36.741 |
| 14 | Egypt | 288162 | 5.805 | 3 | 102334403.00 | 10769834 | 1 | 5.613 |
| 15 | Bahrain | 272453 | 0.509 | 19 | 1701583.00 | 2485464 | 18 | 73.034 |
| 16 | Qatar | 232571 | 0.259 | 21 | 2881060.00 | NA | 17 | NA |
| 17 | Algeria | 195574 | 2.679 | 5 | 43851043.00 | NA | 3 | NA |
| 18 | Malta | 36123 | 1.218 | 14 | 525285.00 | 796333 | 19 | 75.800 |
| 19 | Syria | 27779 | 7.225 | 2 | 2807.00 | 403254 | 20 | 1.152 |
| 20 | Djibouti | 11747 | 1.337 | 12 | 1343.27 | NA | 21 | NA |
| 21 | Yemen | 7829 | 18.764 | 1 | 29825968.00 | NA | 7 | NA |
Figure 3: vaccination coverage
Figure 4: Death Cases Month Wise
Vaccine, the Real Solution for Covid-19- Is the pace Right in Egypt?
It is of importance for something that is as relevant as it deserves.
With knowledge and experience to deal with Covid-19, the solution that we have now with us, to protect human lives is the Vaccine. Although the protective habits like use of mask, sanitization and maintaining physical distance etc. are still important and statutorily should be maintained, but the global focus is now on inoculation. The horizontal bar chart shows the inoculation status of Egypt since March 2021 to 13 September 2021. The graph shows month wise vaccination percentage, with provision of showing the exact figure by putting the cursor on the bar (tool tip figure). The percentage figure was abysmally low (0.08%) in March ’21 and then rose to 4.271% in August ’21. September ’21 till 13th, the figure (5.613%) is very encouraging.
The revelations are very important. The trend is not much different from other nations, where the vaccine hesitation was a major concern to raise the tempo. Here also it caught the speed gradually but always on increasing note. But the difference that is visible with other major middle east nations like, UAE, Malta, Israel, Bahrain, Saudi Arabia, Oman etc. is the percentage of inoculation. In Egypt it is far less than 10% of population being inoculated till date, whereas the figure for UAE is as high as more than 91% (see the table data). The total population of Egypt is more than 10 times of UAE, is also a point to be noted. However, the reasons for low pace of vaccination could be due to:
- Socio-Economic heterogeneity
- Low fatality rate
- Less concentration of population
- Disciplined attitude among people to thwart the spread by following statutory norms etc.
To authenticate the fact that, the more is the vaccination, the less will be fatality rate, see above 2 bar plots 3 and 4. The graph reveals that post May2-021, fatal cases are on a steady decline while vaccination figures are on the rise as shown in 3.
References
Wickham et al., (2019). Welcome to the tidyverse. Journal of Open Source Software, 4(43), 1686, https://doi.org/10.21105/joss.01686
Joachim Gassen (2021). tidycovid19: Download, Tidy and Visualize Covid-19 Related Data. R package version 0.0.0.9000.
Achim Zeileis and Gabor Grothendieck (2005). zoo: S3 Infrastructure for Regular and Irregular Time Series. Journal of Statistical Software, 14(6), 1-27. doi:10.18637/jss.v014.i06
C. Sievert. Interactive Web-Based Data Visualization with R, plotly, and shiny. Chapman and Hall/CRC Florida, 2020.
Thomas Lin Pedersen (2021). ggforce: Accelerating ‘ggplot2’. R package version 0.3.3. https://CRAN.R-project.org/package=ggforce
Thomas Lin Pedersen (2020). patchwork: The Composer of Plots. R package version 1.1.1. https://CRAN.R-project.org/package=patchwork
Claus O. Wilke (2020). ggtext: Improved Text Rendering Support for ‘ggplot2’. R package version 0.1.1. https://CRAN.R-project.org/package=ggtext
Ramnath Vaidyanathan, Kent Russell and Gareth Watts (2016). sparkline: ‘jQuery’ Sparkline ‘htmlwidget’. R package version 2.0. https://CRAN.R-project.org/package=sparkline
Yihui Xie, Joe Cheng and Xianying Tan (2021). DT: A Wrapper of the JavaScript Library ‘DataTables’. R package version 0.18. https://CRAN.R-project.org/package=DT
Dominic Comtois (2021). summarytools: Tools to Quickly and Neatly Summarize Data. R package version 1.0.0. https://CRAN.R-project.org/package=summarytools
Joshua Kunst (2020). highcharter: A Wrapper for the ‘Highcharts’ Library. R package version 0.8.2. https://CRAN.R-project.org/package=highcharter
Hao Zhu (2021). kableExtra: Construct Complex Table with ‘kable’ and Pipe Syntax. R package version 1.3.4. https://CRAN.R-project.org/package=kableExtra
Garrett Grolemund, Hadley Wickham (2011). Dates and Times Made Easy with lubridate. Journal of Statistical Software, 40(3), 1-25. URL https://www.jstatsoft.org/v40/i03/.