COVID-19 Data Visualization Python Project Class 12

# Python Project for Class 12 Informatics Practices (065), Python MySQL program containing bar graph, line chart, scatter chart

Note: If you found something wrong or unable to execute the program kindly mention in comment box provided below the article.

#cbsepython.in
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

def Fun():
    print(":)")
    print("#1. For checking the data.")
    print("#2. Reading complete file without index.")
    print("===================")
    print("Topic - Data Visualization")
    print(" ")
    print("#3. Line Chart")
    print("    Press 1 to print the data for Confirmed cases as per Districts.")
    print("    Press 2 to print the data for Recovered cases as per Districts.")
    print("    Press 3 to print the data for Death cases as per Districts.")
    print("    Press 4 to print the data for Active cases as per Districts.")
    print("    Press 5 to print All data.")
    print(" ")
    print("#4. Bar Graph")
    print("    Press 1 to print the data for Confirmed cases as per Districts.")
    print("    Press 2 to print the data for Recovered cases as per Districts.")
    print("    Press 3 to print the data for Death cases as per Districts.")
    print("    Press 4 to print the data for Active cases as per Districts.")
    print("    Press 5 to print the data in form of stack bar chart")
    print("    Press 6 to print the data in form of multi bar chart")
    print(" ")
    print("#5. Scatter Chart")
    print(" ")
    print("#6. For Exit")
    print("===============")


def Read_CSV():
    print("The Data")
    df=pd.read_csv('D:\\Covid_data_kerala.csv')
    print(df)

def No_Index():
    print("Reading the file without index")
    df=pd.read_csv('D:\\Covid_data_kerala.csv', index_col=0)
    print(df)


#FOR LINE CHART:)

def line_plot():
    df=pd.read_csv('D:\\Covid_data_kerala.csv')
    df['Districts'] = ['EKM','PTA','KTM','TSR','KKD','MPM','KLM','PKD','ALP','KNR','TVM','IDK','WYD','KGD']
    District=df["Districts"]
    Confirmed=df["Confirmed"]
    Recovered=df["Recovered"]
    Deaths=df["Deaths"]
    Active=df["Active"]
    plt.xlabel("Districts")

    
    YC = int(input("Enter the number representing your preferred line chart from the above choices: "))
    
    if YC == 1:
        plt.ylabel("Confirmed Cases")
        plt.title("Districts Wise Confirmed Cases")
        plt.plot(District, Confirmed, color='b')
        plt.show()
    elif YC == 2:
        plt.ylabel("Recovered Cases")
        plt.title("Districts Wise Recovered Cases")
        plt.plot(District, Recovered, color='g')
        plt.show()
    elif YC == 3:
        plt.ylabel("Death Cases")
        plt.title("Districts Wise Death Cases")
        plt.plot(District, Deaths, color='r')
        plt.show()
    elif YC == 4:
        plt.ylabel("Active Cases")
        plt.title("Districts Wise Active Cases")
        plt.plot(District, Active, color='c')
        plt.show()
    elif YC == 5:
        plt.ylabel("Number of cases")
        plt.plot(District, Confirmed, color='b', label = "Districts Wise Confirmed Cases")
        plt.plot(District, Recovered, color='g', label = "Districts Wise Recovered Cases")
        plt.plot(District, Deaths, color='r', label = "Districts Wise Death Cases")
        plt.plot(District, Active, color='c', label = "Districts Wise Active Cases")
        plt.legend()
        plt.show()
    else:
        print("Enter valid input")
        

#FOR BAR GRAPH:)

def bar_plot():
    df = pd.read_csv('Covid_data_kerala.csv')
    df['Districts'] = ['EKM','PTA','KTM','TSR','KKD','MPM','KLM','PKD','ALP','KNR','TVM','IDK','WYD','KGD']
    District = df["Districts"]
    Confirmed = df["Confirmed"]
    Recovered = df["Recovered"]
    Deaths = df["Deaths"]
    Active = df["Active"]
    plt.xlabel("Districts")


    YC = int(input("Enter the number representing your preferred bar graph from the above choices:"))
    
    if YC == 1:
        plt.ylabel("Confirmed Cases")
        plt.title("Districts Wise Confirmed Cases")
        plt.bar(District, Confirmed, color='b', width = 0.5)
        plt.show()
    elif YC == 2:
        plt.ylabel("Recovered Cases")
        plt.title("Districts Wise Recovered Cases")
        plt.bar(District, Recovered, color='g', width = 0.5)
        plt.show()
    elif YC == 3:
        plt.ylabel("Death Cases")
        plt.title("Districts Wise Death Cases")
        plt.bar(District, Deaths, color='r', width = 0.5)
        plt.show()
    elif YC == 4:
        plt.ylabel("Active Cases")
        plt.title("Districts Wise Active Cases")
        plt.bar(District, Active, color='c', width = 0.5)
        plt.show()
    elif YC == 5:
        plt.bar(District, Confirmed, color='b', width = 0.5, label = "Districts Wise Confirmed Cases")
        plt.bar(District, Recovered, color='g', width = 0.5, label = "Districts Wise Recovered Cases")
        plt.bar(District, Deaths, color='r', width = 0.5, label = "Districts Wise Death Cases")
        plt.bar(District, Active, color='c',width = 0.5, label = "Districts Wise Active Cases")
        plt.legend()
        plt.show()
    elif YC == 6:
        D=np.arange(len(District))
        width=0.25
        plt.bar(D,Confirmed, width, color='b', label = "Districts Wise Confirmed Cases")
        plt.bar(D+0.25, Recovered, width, color='g', label = "Districts Wise Recovered Cases")
        plt.bar(D+0.50, Deaths, width, color='r', label = "Districts Wise Death Cases")
        plt.bar(D+0.75, Active ,width, color='c', label = "Districts Wise Active Cases")
        plt.legend()
        plt.show()
    else:
        print("Enter valid input")
        
def scatter_chart():
    df=pd.read_csv('Covid_data_kerala.csv')
    df['Districts'] = ['EKM','PTA','KTM','TSR','KKD','MPM','KLM','PKD','ALP','KNR','TVM','IDK','WYD','KGD']
    District = df["Districts"]
    Confirmed = df["Confirmed"]
    Recovered = df["Recovered"]
    Deaths = df["Deaths"]
    Active = df["Active"]
    
    SC=plt.gca()
    SC=plt.scatter(District, Confirmed, color="b", label="Districts Wise Confirmed Cases")
    SC=plt.scatter(District, Recovered, color="g", label="Districts Wise Recovered Cases")
    SC=plt.scatter(District, Deaths, color="r", label="Districts Wise Death Cases")
    SC=plt.scatter(District, Active, color="c", label="Districts Wise Active Cases")
    
    plt.xlabel("District")
    plt.title("Complete Scatter Chart")
    plt.legend()
    plt.show()
    
Fun()
YC = int(input("Enter Your Choice: "))

while YC == 1 or 2 or 3 or 4 or 5 or 6:

    if YC == 1:
        Read_CSV()
        break
    elif YC == 2:
        No_Index()
        break
    elif YC == 3:
        line_plot()
        break
    elif YC == 4:
        bar_plot()
        break
    elif YC == 5:
        scatter_chart()
        break
    elif YC == 6:
        print("Thank You for using...")
        break
    else:
        print("Enter valid input")
        break

Output:

=== RESTART: C:\Users\ATC\AppData\Local\Programs\Python\Python38-32\COVID.PY 
#1. For checking the data.
#2. Reading complete file without index.
===================
Topic - Data Visualization

#3. Line Chart
Press 1 to print the data for Confirmed cases as per Districts.
Press 2 to print the data for Recovered cases as per Districts.
Press 3 to print the data for Death cases as per Districts.
Press 4 to print the data for Active cases as per Districts.
Press 5 to print All data.

#4. Bar Graph
Press 1 to print the data for Confirmed cases as per Districts.
Press 2 to print the data for Recovered cases as per Districts.
Press 3 to print the data for Death cases as per Districts.
Press 4 to print the data for Active cases as per Districts.
Press 5 to print the data in form of stack bar chart
Press 6 to print the data in form of multi bar chart

#5. Scatter Chart

#6. For Exit
===============
Enter Your Choice: