text_html_output_1.png
import matplotlib.pyplot as plt

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import seaborn as sns

import plotly as py
import matplotlib.pyplot as plt
import seaborn as sns
import plotly.express as px
pd.set_option('display.max_rows', None)

covid = pd.read_csv('/kaggle/input/covid19-in-india/covid_19_india.csv')

plt.xticks(rotation=45)
plt.xticks(rotation=90)
plt.xticks(rotation=45)

plt.figure(figsize=(23,10))
plt.bar(covid.Date, covid.Confirmed,label="Confirmed")
plt.bar(covid.Date, covid.Cured,label="Cured")
plt.bar(covid.Date, covid.Deaths,label="Deaths")
plt.xlabel('Date')
plt.xticks(rotation=90)
plt.ylabel("Count")
plt.legend(frameon=True, fontsize=12)
plt.title('Confrimed vs Cured vs Deaths',fontsize=30)
plt.show()

f, ax = plt.subplots(figsize=(23,10))
ax=sns.scatterplot(x="Date", y="Confirmed", data=covid,
             color="black",label = "Confirm")
ax=sns.scatterplot(x="Date", y="Cured", data=covid,
             color="red",label = "Cured")
ax=sns.scatterplot(x="Date", y="Deaths", data=covid,
             color="blue",label = "Deaths")

plt.xticks(rotation=90)
plt.plot(covid.Date, covid.Confirmed,zorder=1,color="black")
plt.plot(covid.Date, covid.Cured,zorder=1,color="red")
plt.plot(covid.Date, covid.Deaths,zorder=1,color="blue")

covidage = pd.read_csv('/kaggle/input/covid19-in-india/AgeGroupDetails.csv')
covidage

covidpivot = pd.pivot_table(covid, ['Cured', 'Confirmed', 'Deaths'], 'State/UnionTerritory', aggfunc=sum)
covidpivot

covidstatest = pd.read_csv('/kaggle/input/covid19-in-india/StatewiseTestingDetails.csv')

covidstatestpivot = pd.pivot_table(covidstatest, ['TotalSamples', 'Negative', 'Positive'], 'State', aggfunc=sum)
covidstatestpivot1 = covidstatestpivot.reset_index('State')

covidtest = pd.read_csv('/kaggle/input/covid19-in-india/ICMRTestingLabs.csv')

covidhosp = pd.read_csv('/kaggle/input/covid19-in-india/HospitalBedsIndia.csv')
covidhosp1 = covidhosp.drop([1, 36], axis=0)

covidindi = pd.read_csv('/kaggle/input/covid19-in-india/IndividualDetails.csv')
covidindi.tail()
covidindi['current_status'].unique()