如何使用pandas dataframe操作列表？

pip install pandas

import pandas as pd

df = pd.DataFrame()

data = [1, 2, 3, 4, 5]
df['Column Name'] = data

data1 = [1, 2, 3, 4, 5]
data2 = ['a', 'b', 'c', 'd', 'e']
data3 = [True, False, True, False, True]

data = {'Column 1': data1, 'Column 2': data2, 'Column 3': data3}
df = pd.DataFrame(data)

# 筛选数据
filtered_df = df[df['Column 1'] > 3]

# 排序
sorted_df = df.sort_values(by='Column 1')

# 计算统计信息
mean_value = df['Column 1'].mean()

df.to_csv('filename.csv', index=False)  # 保存为CSV文件
df.to_excel('filename.xlsx', index=False)  # 保存为Excel文件