学生信息管理系统

import sqlite3

# 连接到SQLite数据库

conn = sqlite3.connect('student_management.db')

cursor = conn.cursor()

# 创建表

cursor.execute('''CREATE TABLE IF NOT EXISTS activities (

id INTEGER PRIMARY KEY,

activity TEXT,

date DATE,

duration INTEGER)''')

# 插入数据

cursor.execute("INSERT INTO activities (activity, date, duration) VALUES (?, ?, ?)",

('Coding', '2023-09-10', 120))

# 提交事务

conn.commit()

conn.close()

]]>

import pandas as pd

import sqlite3

# 连接到数据库

conn = sqlite3.connect('student_management.db')

df = pd.read_sql_query("SELECT * from activities", conn)

# 分析数据

activity_counts = df['activity'].value_counts()

print(activity_counts)

# 关闭连接

conn.close()

]]>