Skip to content
January 21, 2026

Class 12th IP(065) practical -6

Class 12th IP (065)

Practical 6

SOLUTION  :- 

import pandas as pd
import matplotlib.pyplot as plt

# Creating DataFrame
Product = pd.DataFrame({
    'Pname': ['50-50', 'Krack-Jack', 'Kitkat', 'Dariy Milk', 'Maggie'],
    'Brand': ['Britania', 'Parle', 'Nestle', 'Cadbury', 'Nestle'],
    'Price': [10, 10, 20, 60, 55],
    'Qty': [5, 5, 3, 2, 5]
})

print(Product)
while True:
    print("\n*** MENU ***")
    print("1. Show all Data")
    print("2. Add New Row")
    print("3. Add Amount Column")
    print("4. Create CSV File")
    print("5. Create Bar Graph")
    print("6. Exit")

    ch = int(input("Enter your choice: "))

    if ch == 1:
        print(Product)

    elif ch == 2:
        Product.loc[5]=['Hide&Seek', 'Parle', 20, 3]
        #Product.loc[len(Product)] = ['Hide&Seek', 'Parle', 20, 3]
        print("New row added successfully")

    elif ch == 3:
        Product['Amount'] = Product['Price'] * Product['Qty']
        print(Product)

    elif ch == 4:
        Product.to_csv("Data.csv", index=False)
        print("CSV file created successfully")

    elif ch == 5:
        plt.bar(Product['Pname'], Product['Amount'])
        plt.title("Product Amount Report")
        plt.xlabel("Product Name")
        plt.ylabel("Amount")
        plt.show()

    elif ch == 6:
        break

    else:
        print("Invalid Choice")

SOLUTION

Create Database

CREATE DATABASE B1_2026;
USE B1_2026;

Create Table Hospital

CREATE TABLE Hospital (
    No INT PRIMARY KEY,
    Name VARCHAR(50),
    Age INT,
    Department VARCHAR(50),
    Datofadm DATE,
    Charges INT,
    Sex VARCHAR(1)
);

Insert 8 Records

INSERT INTO Hospital VALUES
(1,'Sandeep',65,'Surgery','1998-02-23',300,'M'),
(2,'Ravina',24,'Orthopedic','1998-01-20',200,'F'),
(3,'Karan',45,'Orthopedic','1998-02-19',200,'M'),
(4,'Tarun',12,'Surgery','1998-01-01',300,'M'),
(5,'Zubin',36,'ENT','1998-02-12',250,'M'),
(6,'Ketaki',16,'ENT','1998-02-24',300,'F'),
(7,'Ankita',29,'Cardiology','1998-02-20',800,'F'),
(8,'Zareen',45,'Gynecology','1998-02-22',300,'F');

4. SQL Queries

a) Display records in ascending order of Age

SELECT * FROM Hospital
ORDER BY Age ASC;

b) Display Name, Department, Sex, Datofadm where Sex = ‘M’ and Department = ‘ENT’

SELECT Name, Department, Sex, Datofadm
FROM Hospital
WHERE Sex = 'M' AND Department = 'ENT';

c) Display Maximum, Minimum and Sum of Charges

SELECT 
MAX(Charges) AS Maximum,
MIN(Charges) AS Minimum,
SUM(Charges) AS Total
FROM Hospital;

d) Delete record for Ankita

DELETE FROM Hospital
WHERE Name = 'Ankita';

e) Change Department to Cardiology for No = 3

UPDATE Hospital
SET Department = 'Cardiology'
WHERE No = 3;

Blog Insights