import requests, json, pandas as pd
API_FEES = "https://api.univ.edu/v1/fees"
def fetch_fees():
resp = requests.get(API_FEES)
return resp.json().get("fees", [])
def analyze_fees(fees):
df = pd.DataFrame(fees)
report = {
"total_students": len(df),
"paid_count": len(df[df["status"] == "Paid"]),
"arrears_count": len(df[df["status"] == "Arrears"]),
"total_arrears": df[df["status"] == "Arrears"]["amount"].sum()
}
return report
fees_report = analyze_fees(fetch_fees())
print(json.dumps(fees_report))