一站式网上办事大厅

import requests

import pandas as pd

from pptx import Presentation

# 获取数据

url = "http://ywtb.gov/api/data"

response = requests.get(url)

data = response.json()

# 数据处理

df = pd.DataFrame(data)

ranked_data = df.sort_values(by='processing_time', ascending=True)

# 创建PPT

prs = Presentation()

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

shapes = slide.shapes

title_shape = shapes.title

title_shape.text = "一网通办平台事项排名"

实习系统

tb = shapes.add_table(rows=len(ranked_data)+1, cols=3).table

tb.cell(0, 0).text = "序号"

tb.cell(0, 1).text = "事项名称"

tb.cell(0, 2).text = "处理时长"

for i, row in ranked_data.iterrows():

tb.cell(i+1, 0).text = str(i+1)

tb.cell(i+1, 1).text = row['item_name']

tb.cell(i+1, 2).text = str(row['processing_time'])

prs.save("ranked_items.pptx")

]]>