IP - CSV | DATA ANALYSIS PROJECT

 

IP - CSV

DATA ANALYSIS PROJECT

 

RollNo,Name,English,Math,IP
101,Aarav,78,85,92
102,Diya,88,79,95
103,Rohan,67,91,89
104,Ananya,92,87,96
105,Vivaan,75,80,84

 

import pandas as pd

# Reading CSV file

df = pd.read_csv("student_marks.csv")

 

# Display complete data

print("Student Data:")

print(df)

 

# Add Total column

df["Total"] = df["English"] + df["Math"] + df["IP"]

 

# Add Percentage column

df["Percentage"] = df["Total"] / 3

print("\nUpdated Data:")

print(df)

 

# Highest scorer

df = df.sort_values(by="Total", ascending=False)

print("\nTopper Details:")

print(df.iloc[0])

 

# Subject-wise average

print("\nAverage Marks:")

print(df[["English", "Math", "IP"]].mean())

print("\nDataFrame Properties:")

 print("Shape of DataFrame:", df.shape)

print("Column Names:", df.columns)

print("Index Labels:", df.index)

print("Size of DataFrame:", df.size)

print("Data Types:\n", df.dtypes)