6. Drawing Line and bar chart using matplotlib.

 
   
 
 #6.Write a Program to Create data frame from excel sheet and perform simple operations
 
 #--------------------------------------
 
import csv

filename = "student_data.csv"
content = [
    ["Name", "Subject", "Marks"],
    ["Aryan", "Maths", 85],
    ["Isha", "Maths", 92],
    ["Rohan", "Maths", 45],
    ["Sana", "Maths", 78]
]

with open(filename, "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerows(content)
 
def process_data(file):
    data = []
    try:
        with open(file, mode='r', encoding='utf-8') as f: 
            reader = csv.DictReader(f)
            for row in reader: 
                row['Marks'] = int(row['Marks'])
                data.append(row)
        
        print("--- Loaded Data ---")
        for entry in data:
            print(entry)
 
         
        total_marks = sum(item['Marks'] for item in data)
        average = total_marks / len(data)
        print(f"\nAverage Marks: {average}")
 
        top_student = max(data, key=lambda x: x['Marks'])
        print(f"Top Student: {top_student['Name']} with {top_student['Marks']} marks")

        
        high_scorers = [item['Name'] for item in data if item['Marks'] > 80]
        print(f"Students scoring > 80: {', '.join(high_scorers)}")

    except FileNotFoundError:
        print("Error: File not found.")

process_data(filename)