import pandas as pd
# 读取CSV文件
data = pd.read_csv('data.csv')
# 清洗数据,例如删除缺失值
clean_data = data.dropna()
]]>
from sqlalchemy import create_engine
# 创建数据库引擎
engine = create_engine('postgresql://username:password@localhost:5432/mydatabase')
# 查询数据
query = "SELECT * FROM my_table"
data_from_db = pd.read_sql(query, engine)
]]>