存储

文件存储

data = [
    {"name": "张三", "age": 18},
    {"name": "李四", "age": 20},
    {"name": "王五", "age": 22},
]

# 写csv文件
import csv 
fieldnames = data[0].keys()
with open("data.csv", mode='w', newline='', encoding='utf-8') as csvfile:
    # 创建DictWriter对象
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
 
    # 写入表头
    writer.writeheader()
 
    # 写入数据
    for row in data:
        writer.writerow(row)

# 将字典列表转换为DataFrame
import pandas as pd
df = pd.DataFrame(data)
 
# 指定CSV文件的文件名
filename = "output2.csv"
 
# 将DataFrame写入CSV文件
df.to_csv(filename, index=False, encoding='utf-8-sig')


# 写json
import json
with open("data.json", "w") as f:
    json.dump(data, f, indent=4,ensure_ascii=False)

# 写excel

import openpyxl
wb = openpyxl.Workbook()
ws = wb.active
# 写入表头
ws.append(["name", "age"])
 
# 写入数据
for item in data:
    ws.append([item["name"], item["age"]])
 
# 保存工作簿到文件
wb.save("output.xlsx")

db存储

data = [
    {"name": "张三", "age": 18},
    {"name": "李四", "age": 20},
    {"name": "王五", "age": 22},
]
import pymysql  

db = pymysql.connect(host='localhost',user='root', password='123456', port=3306)  
cursor = db.cursor()
sql = 'INSERT INTO students(name, age) values( %s, %s)'
for data_item in data: 
    try:
        cursor.execute(sql, (data_item["name"], data_item["age"]))
        db.commit()
    except:
        db.rollback()
db.close()