python 保存列表

import pickle

# 假设有一个列表
my_list = [1, 2, 3, 4, 5]

# 保存列表到文件
with open('my_list.pkl', 'wb') as file:
    pickle.dump(my_list, file)

# 从文件中读取列表
with open('my_list.pkl', 'rb') as file:
    loaded_list = pickle.load(file)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import json

# 假设有一个列表
my_list = [1, 2, 3, 4, 5]

# 保存列表到JSON文件
with open('my_list.json', 'w') as file:
    json.dump(my_list, file)

# 从JSON文件中读取列表
with open('my_list.json', 'r') as file:
    loaded_list = json.load(file)

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

import csv

# 假设有一个列表
my_list = [1, 2, 3, 4, 5]

# 保存列表到CSV文件
with open('my_list.csv', 'w', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(my_list)

# 从CSV文件中读取列表
with open('my_list.csv', 'r') as file:
    reader = csv.reader(file)
    loaded_list = next(reader)

print(loaded_list)  # 输出: ['1', '2', '3', '4', '5']

import sqlite3

# 创建数据库连接
conn = sqlite3.connect('my_database.db')
cursor = conn.cursor()

# 创建表
cursor.execute('CREATE TABLE IF NOT EXISTS my_list (id INTEGER PRIMARY KEY, value INTEGER)')

# 假设有一个列表
my_list = [1, 2, 3, 4, 5]

# 插入数据
for item in my_list:
    cursor.execute('INSERT INTO my_list (value) VALUES (?)', (item,))

# 提交事务
conn.commit()

# 查询数据
cursor.execute('SELECT * FROM my_list')
loaded_list = [row[1] for row in cursor.fetchall()]

print(loaded_list)  # 输出: [1, 2, 3, 4, 5]

# 关闭连接
conn.close()