BRAIN INTERNATIONAL
SCHOOL
SESSION 2023-24
SUBMITTED BY : Manpreet Kaur Vedi
ROLL NO. :
CERTIFICATE
The project work titled “Diet Management”, submitted by
Manpreet Kaur Vedi & Gurpreet Kaur Bhatia, students of
Class XII Brain International School is completed under my
supervision. Proper care and utmost sincerity have been taken in
the completion of the project. I certify that the project is up to
the expectations and guidelines issued by CBSE.
Principal’s Signature Teacher’s Signature
ACKNOWLEDGEMENT
I hereby express our sincere thanks to our respected computer
teacher who gave us valuable suggestions, guidance and
assistance in successful completion of this project.
Manpreet Kaur Vedi
Gurpreet Kaur Bhatia
INDEX
[Link]. TOPIC Teacher’s
Signature
1. INTRODUCTION
2. CSV FILE STRUCTURE
3. CODING OF PROJECT
4. OUTPUT OF PROJECT
5. BIBLIOGRAPHY
INTRODUCTION
Details about the project topic with the name of
the modules created
CSV STRUCTURE
CSV Name :
CSV Screenshots:
CODING OF THE PROJECT
import pandas as pd
import [Link] as plt
df=pd.read_csv("[Link]")
print(df)
print("-----------------------------------------------------------------------------")
for a in range(0,7):
print("MENU")
print("[Link] A FILE")
print("[Link] ANALYSIS")
print("[Link] STATISTICS")
print("[Link]")
print("[Link]")
print("[Link] VISUALISATION")
ch=int(input("Enter choice(1/2/3/4/5/6): "))
if ch==1:
print("--------------------------Reading a file--------------------------")
print(df)
elif ch==2:
print("--------------------------Dataframe Analysis Menu--------------------------")
print("[Link] AGE")
print("[Link] AGE")
print("[Link] HEIGHT")
print("[Link] HEIGHT")
print("[Link] WEIGHT")
print("[Link] WEIGHT")
for b in range(0,6):
ch1=float(input("Enter choice(2.1/2.2/2.3/2.4/2.5/2.6): "))
if ch1==2.1:
print("---------------Maximum Age---------------")
print([Link]({"Age":['max']}))
elif ch1==2.2:
print("---------------Minimum Age---------------")
print([Link]({"Age":['min']}))
elif ch1==2.3:
print("---------------Maximum Height---------------")
print([Link]({"Height":['max']}))
elif ch1==2.4:
print("---------------Minimum Height---------------")
print([Link]({"Height":['min']}))
elif ch1==2.5:
print("---------------Maximum Weight---------------")
print([Link]({"Weight(in kg)":['max']}))
else:
print("---------------Minimum Weight---------------")
print([Link]({"Weight(in kg)":['min']}))
elif ch==3:
print("--------------------------Dataframe Statistics Menu--------------------------")
print("[Link] TOP 10 RECORDS")
print("[Link] BOTTOM 10 RECORDS")
print("[Link] DATATYPE")
print("[Link] SIZE")
print("[Link] ALL ROWS AND COLUMNS")
print("[Link] TRANSPOSE INDEX")
for c in range(0,6):
ch3=float(input("Enter choice(3.1/3.2/3.3/3.4/3.5/3.6): "))
if ch3==3.1:
print("---------------Top 10 Records---------------")
print([Link](10))
elif ch3==3.2:
print("---------------Bottom 10 Records---------------")
print([Link](10))
elif ch3==3.3:
print("---------------Datatype---------------")
print([Link])
elif ch3==3.4:
print("---------------Size---------------")
print([Link])
elif ch3==3.5:
print("---------------All Rows and Columns---------------")
print(df)
else:
print("---------------Transpose Index---------------")
print(df.T)
elif ch==4:
print("--------------------------Column Menu--------------------------")
print("[Link] A NEW COLUMN")
print("[Link] A COLUMN")
for d in range(0,2):
ch4=float(input("Enter choice(4.1/4.2): "))
if ch4==4.1:
name=str(input("Name of new column:"))
values=str(input("Enter values:"))
[Link][:,name]=values
print(df)
print("---------------Column Added---------------")
else:
del df['Blood Grp.']
print(df)
print("---------------Column Deleted---------------")
elif ch==5:
print("--------------------------Row Menu--------------------------")
print("[Link] A NEW ROW")
print("[Link] A ROW")
for e in range(0,2):
ch5=float(input("Enter choice(5.1/5.2): "))
if ch5==5.1:
[Link][20,:]=[20,'Akash',39,'M','5.7 feet',95,'Veg',9911369146,'Weight loss','A+']
print(df)
print("---------------Row Added---------------")
else:
df=[Link](20)
print(df)
print("---------------Row Deleted---------------")
else:
print("--------------------------Data Visualization Menu--------------------------")
print("[Link] CHART")
print("[Link] GRAPH")
print("[Link]")
for f in range(0,3):
ch6=float(input("Enter choice(6.1/6.2/6.3): "))
if ch6==6.1:
OUTPUT
BIBLIOGRAPHY
