import pandas as pd
# 读取CSV文件
def load_data(file_path):
data = pd.read_csv(file_path)
return data
if __name__ == "__main__":
file_path = "sales_data.csv"
sales_data = load_data(file_path)
print(sales_data.head())
]]>
from sqlalchemy import create_engine
# 连接数据库
def save_to_db(data, db_url):
engine = create_engine(db_url)
data.to_sql('sales', con=engine, if_exists='replace', index=False)
if __name__ == "__main__":
db_url = "mysql+pymysql://user:password@localhost/sales_db"
save_to_db(sales_data, db_url)
]]>
from flask import Flask, jsonify
app = Flask(__name__)
@app.route('/data')
def get_data():
# 假设这里是从数据库获取数据
data = {"sales": [100, 200, 300]}
return jsonify(data)
if __name__ == "__main__":
app.run(debug=True)
]]>