1. Create a pandas DataFrame containing Name, Class, and Marks of five students. Display the DataFrame and calculate the average marks.
import pandas as pd
data = {
"Name": ["Alex", "Bina", "Chirag", "Divya", "Esha"],
"Class": [10, 10, 10, 10, 10],
"Marks": [85, 92, 78, 88, 95],
}
df = pd.DataFrame(data)
print(df)
average_marks = df["Marks"].mean()
print( " Average Marks is " , average_marks)
2. Using pandas, create a CSV file with student records and write a program to read the file and display the highest and lowest marks.
import pandas as pd
data = {
"Name": ["Alex", "Bina", "Chirag", "Divya", "Esha"],
"Class": [10, 10, 10, 10, 10],
"Marks": [98, 92, 78, 88, 95],
}
df_initial = pd.DataFrame(data)
csv_filename = "student_records.csv"
df_initial.to_csv(csv_filename, index=False)
print("CSV file 'student_records.csv' successfully created.\n")
df = pd.read_csv(csv_filename)
highest_marks = df["Marks"].max()
lowest_marks = df["Marks"].min()
top_student = df[df["Marks"] == highest_marks]["Name"].values[0]
lowest_student = df[df["Marks"] == lowest_marks]["Name"].values[0]
print("--- Student Records ---")
print(df)
print("\n--- Summary Statistics ---")
print("Highest Marks:", highest_marks, "(" + top_student + ")")
print("Lowest Marks:", lowest_marks, "(" + lowest_student + ")")