CSV Reader

# CSV Reader - Manual data se
data = [
    ["Naam", "Umar", "Shahar", "Score", "Grade"],
    ["Rahul",  "20", "Mumbai",  "85", "B"],
    ["Priya",  "22", "Delhi",   "92", "A"],
    ["Amit",   "19", "Pune",    "78", "C"],
    ["Sneha",  "21", "Chennai", "88", "B"],
    ["Ravi",   "23", "Bangalore","95", "A+"],
]

headers = data[0]
rows    = data[1:]

print("=== CSV Reader ===")
print(f"Total records: {len(rows)}")
print()

# Table print karo
col_width = 12
print(" | ".join(f"{h:{col_width}}" for h in headers))
print("-" * (col_width * len(headers) + 3 * (len(headers)-1)))
for row in rows:
    print(" | ".join(f"{c:{col_width}}" for c in row))

# Statistics
scores = [int(r[3]) for r in rows]
print(f"\n=== Statistics ===")
print(f"  Total students : {len(rows)}")
print(f"  Average score  : {sum(scores)/len(scores):.1f}")
print(f"  Highest score  : {max(scores)}")
print(f"  Lowest score   : {min(scores)}")

# Filter - 90+ scorers
print("\n90+ scorers:")
for r in rows:
    if int(r[3]) >= 90:
        print(f"  {r[0]} - {r[3]} ({r[4]})")

# Search by city
city = input("\nKis shahar ke students dekhen: ")
found = [r for r in rows if r[2].lower() == city.lower()]
print(f"\n{city} ke students: {len(found)}")
for r in found:
    print(f"  {r[0]} - Score: {r[3]}")