import requests

import pandas as pd

from sqlalchemy import create_engine

# 创建数据库连接

engine = create_engine('mysql+pymysql://username:password@localhost/university_research')

# 示例：抓取数据并存入数据库

def fetch_and_store_data(url):

response = requests.get(url)

data = response.json() # 假设返回的是JSON格式

df = pd.DataFrame(data)

df.to_sql('research_info', con=engine, if_exists='append', index=False)

url = "https://example.com/api/research-data"

fetch_and_store_data(url)

]]>

import matplotlib.pyplot as plt

# 查询不同领域的研究产出

query = "SELECT field, COUNT(*) AS count FROM research_info GROUP BY field;"

df = pd.read_sql(query, con=engine)

# 绘制柱状图

df.plot(kind='bar', x='field', y='count')

单点登录系统作用

plt.show()

]]>