Python Pandas

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 + ")")
Back