PROJECT ON
“ANALYSIS OF COVID-1 9 IMPACT ON INDIA USING DATA
VISUALISATION”’
SUBMITTED TO:- SUBMITTED BY:-
MR.MAHENDRA KU. SAHU ARATHI.T
(Dept. Of informatics practices) ROLL NO:
CLASS: 12TH
SIDDHARTHA PUBLIC SCHOOL, KUMELSINGHA
BARGARH (768111)
SESSION-( ---- )
ACKNOWLEDGEMENT
I am greatly indebted to my guide “Mr. Mahendra Kumar Sahu” for his invaluable guidance during the
course of the Project. It was his unfailing pushing and constant inspiration that this work could take the
present shape. He always gave useful suggestions and also helped me when the work was not moving ahead
at times.
Turning aspirations into realities is easier when people are supportive of your efforts. Among such persons
are my parents to whom I am deeply indebted for the positive feedback regarding contribution to my work
and for their unfailing steps and ungrudging help at every step in this project.
Name: Arathi T
Roll no:
CERTIFICATE
This is to certify that ARATHI.T of class XII has successfully completed her project under the
guidance of subject Mr. Mahendra Kumar Sahu from SIDDHARTHA PUBLIC SCHOOL
in partial fulfillment of Informatics Practices practical examination conducted by CBSE for
session 2022-23.
Internal Examiner Principal
External Examiner
INDEX
1.Introduction to python 05-06
2.Hardware and software required 06-07
3.Introduction to project 07-08
4.Most affected states in India 08-10
5.Least affected states in India 10-13
6.Death each age due to covid-19 13-15
7.Death of each age group in male and 15-18
female
8.conclusion 18-19
9.Bibliography 19-20
INTRODUCTION TO PYTHON
Python is an interpreted, object-oriented, highlevel programming language with
dynamic semantics. Its high-level built in data structures, combined with dynamic typing and
dynamic binding, make it very attractive for Rapid Application Development, as well as for
use as a scripting or glue language to connect existing components together. Python's simple,
easy to learn syntax emphasizes readability and therefore reduces the cost of program
maintenance. Python supports modules and packages, which encourages program modularity
and code reuse. The Python interpreter and the extensive standard library are available in
source or binary form without charge for all major platforms, and can be freely distributed
HISTORY OF PYTHON:
Python is a widely used general-purpose, high-level programming language. It was
initially designed by Guido van Rossum in 1991 and developed by Python Software
Foundation. It was mainly developed for emphasis on code readability, and its syntax allows
programmers to express concepts in fewer lines of code.
HARDWARE AND SOFTWARE REQUIREMENTS
1.OPERATING SYSTEM : Windows 10 and above
2. PROCESSOR: PENTIUM(ANY) OR AMD
ATHALON(3800+- 4200+ DUALCORE)
3. MOTHERBOARD: 1.845 OR 915,995 FOR PENTIUM 0R MSI
K9MM-V VIAK8M800+8237R PLUS CHIPSET FOR
AMD ATHALON
4. RAM : 512MB+
5. Hard disk : SATA 40 GB OR ABOVE
6. CD/DVD r/w multi drive combo: (If back up required)
8. MONITOR
9.KEYBOARD AND MOUSE
INTRODUCTION TO PROJECT
❑ What is Covid-19?
❖ Coronavirus disease 2019 (COVID-19) is a contagious disease caused by severe acute respiratory
syndrome coronavirus 2 (SARS-CoV-2). The first case was identified in Wuhan, China, in December
2019. It has since spread worldwide, leading to a huge number of deathrate.
❖ Most people infected with the COVID-19 virus will experience mild to moderate respiratory illness
and recover without requiring special treatment. Older people, and those with underlying medical
problems like cardiovascular disease, diabetes, chronic respiratory disease, and cancer are more
likely to develop serious illness. A new strain of coronavirus is discovered in Britain. It is said to
mutate faster than the older variant.
Covid-19 in India
❖ The first case of COVID-19 in India, which originated from China, was reported on 30 January
2020. India currently has the largest number of confirmed cases in Asia and has the second-highest
number of confirmed cases in the world after the United States. On 24 March, the prime minister
ordered a nationwide lockdown for 21 days, affecting the entire 1.3 billion population of India. On
14 April, India extended the nationwide lockdown till 3 May which was followed by two week
extensions. From 1 June, the government started "unlocking" the country (barring "containment
zones") in three unlock phases.
MOST AFFECTED STATES IN INDIA FROM COVID-19
Five most affected states in India are:-
▪ Maharashtra
▪ Karnataka
▪ Andhra Pradesh
▪ Tamil Nadu
▪ Kerala.
A B C
CASES RECOVERED DIED
MAHARASHTRA 1913382 1806298 49129
KARNATAKA 914488 888917 12044
ANDRA PRADESH 880430 869478 7091
TAMIL NADU 812142 790965 12048
KERALA 732084 664951 2930
PROGRAM
import matplotlip . pyplot as plt
import numpy as np
import pandas as pd
a=pd.read_(svc/storage/emulated/0/Download/covidip.csv)
X=np . linspace(1,61,5)
Plt.xticks(x+6/2,[‘maharashta’,’Karnataka’,Andra Pradesh’,’Tamil nadu’,’kerala’])
Plt.bar(x,a[‘cases’],width=3,c=‘b’,label=‘cases’)
Plt.bar(x+3,a[‘recovered’],width=3,c=‘g’,label=‘recover’)
Plt.bar(x+6,a[‘died’],width=3,c=‘r’,’label’= ‘death’)
Plt . title(‘most affected states due to covid19’)
Plt . legend
Plt . x label(‘states’)
Plt . Y label(‘number’)
Plt . Show( )
OUTPUT
LEAST AFFECTED STATES FROM COVID-19 IN INDIA
Five worst affected states in India are:-
▪ Mizoram
▪ Sikkim,
▪ Nagaland
▪ Meghalaya
▪ Arunachal Pradesh
A B C
. CASES RECOVERED DIED
Mizoram 4178 4036 8
Sikkim 5684 5142 125
Nagaland 11845 11544 77
Meghalaya 13396 12940 135
Arunachal 16678 16454 56
pradesh
PROGRAM
import matplotlip . pyplot as plt
import numpy as np
import pandas as pd
a=pd.read_(svc/storage/emulated/0/Download/covidip.csv)
X=np . linspace(1,61,5)
Plt.xticks(x+6/2,[‘mizoram’,’sikkim’,’nagaland’, ’meghalaya’,’arunachal pradesh’])
Plt.bar(x,a[‘cases’],width=3,c=‘b’,label=‘cases’)
Plt.bar(x+3,a[‘recovered’],width=3,c=‘g’,label=‘recover’)
Plt.bar(x+6,a[‘died’],width=3,c=‘r’,’label’=‘death’)
Plt . title(‘most affected states due to covid19’)
Plt . legend
Plt . x label(‘states’)
Plt . Y label(‘number’)
Plt . Show( )
OUTPUT
DEATHS IN EACH AGE GROUP DUE TO COVID-19
• Deaths caused in each age groups is shown below through a line graph.
A B
01 X Y
02 0-10 0.5
03 11-20 0.7
04 21-30 2.6
05 31-40 6.1
06 41-50 13.4
07 51-60 25.13
08 61-70 28.6
09 71-80 17
10 >90 0.5
PROGRAM
import matplotlib.pyplot as plt
Import pandas as pd
A=pd.read_(svc/storage/emulated/0/Download/covidip.csv)
Plt.plot (a[‘x’],a[‘y’],marker=‘*’,marker edge color=‘r’)
Plt.title(‘% of death in each age group’)
Plt.xlabel(‘ages’)
Plt.ylabel(‘percent’)
OUTPUT
Deaths in each age group in male and female due to Covid-19
A B
01 FEMALE MALE
02 109 180
03 195 202
04 529 926
05 952 2484
06 2308 5230
07 4548 9683
08 4947 11142
09 2766 6788
10 857 2141
20 104 197
PROGRAM
import matplotlip . pyplot as plt
import numpy as np
import pandas as pd
a=pd.read_(svc/storage/emulated/0/Download/covidip.csv)
X=np . linspace(1,81,10)
Plt.xticks(x+3/2,[‘0-10 ’,’11-20’, ’21-30’, ’31-40’, ’41-50’, ’51-60’, ’61-70’, ’71-80’, ‘>90’)
Plt.bar(x,a[‘female’],width=3,c=‘g’ label=‘female’)
Plt.bar(x+3,a[‘male’],width=3,c=‘g’,label=‘recover’)
Plt.bar(x+6,a[‘died’],width=3,c=‘b’,’label’= ‘male’)
Plt . title(‘no. of deaths’)
Plt . legend
Plt . x label(‘age’)
Plt . Y label(‘number’)
Plt . Show( )
CONCLUSION
It was a wonderful learning experience for me while working on this project. This project took me
through various phases of project development and gave me real insight into the world of data visualisation
as we are able to easily analyse the data using bar and line graphs . The joy of work and the thrill involved
while tackling various problems and challenges gave me a feel of developers industry.
I enjoyed each and every bit of efforts I had put into this project.
BIBLIOGRAPHY
• www.google.com
• www.slideshare.net
• www.academia.com
• www.Wikipedia.com
• www.statista.com
• Informatics practise NCERT Book
• School notes
