一站式网上办事大厅

import requests

def fetch_ranking_data(url):

response = requests.get(url)

if response.status_code == 200:

return response.json()

else:

print("Failed to fetch data")

return None

import pandas as pd

def parse_data(raw_data):

df = pd.DataFrame(raw_data['ranking'])

return df[['University', 'Score', 'Rank']]

选排课系统

from pptx import Presentation

from pptx.util import Inches

import matplotlib.pyplot as plt

def create_presentation(df):

prs = Presentation()

slide = prs.slides.add_slide(prs.slide_layouts[5])

plt.figure(figsize=(6, 4))

plt.bar(df['University'], df['Score'])

plt.title('University Rankings')

plt.xticks(rotation=90)

plt.tight_layout()

plt.savefig('rankings.png')

slide.shapes.add_picture('rankings.png', Inches(1), Inches(1), width=Inches(5), height=Inches(3))

prs.save('rankings.pptx')