pip install pandas

import pandas as pd

# 讀取CSV文件
df = pd.read_csv('pokemon.csv')

# 顯示前五行數(shù)據(jù)
print(df.head())

# 計(jì)算某列的平均值
print("Average of column:", df['Speed'].mean())

# 數(shù)據(jù)篩選
filtered_df = df[df['Speed'] > 10]

# 將更改后的DataFrame保存到新的CSV文件
filtered_df.to_csv('filtered_example.csv', index=False)

pip install openpyxl

from openpyxl import load_workbook

# 加載一個(gè)現(xiàn)有的工作簿
wb = load_workbook('example.xlsx')

# 獲取活動(dòng)的工作表
sheet = wb.active

# 讀取A1單元格的值
print(sheet['A1'].value)

# 修改B2單元格的值
sheet['B2'] = 42

# 保存工作簿
wb.save('modified_example.xlsx')

import csv

# 打開(kāi)CSV文件
with open('example.csv', mode='r', encoding='utf-8') as file:
    reader = csv.reader(file)
    
    # 遍歷每一行
    for row in reader:
        print(row)

# 寫(xiě)入CSV文件
with open('output.csv', mode='w', encoding='utf-8', newline='') as file:
    writer = csv.writer(file)
    writer.writerow(['Name', 'Age', 'City'])
    writer.writerow(['Alice', '24', 'New York'])

pip install xlrd xlwt

import xlrd

# 打開(kāi)工作簿
wb = xlrd.open_workbook('catering_sale.xls')

# 通過(guò)索引獲取工作表
sheet = wb.sheet_by_index(0)

# 讀取A1單元格的值
print(sheet.cell_value(0, 0))

# 獲取行數(shù)和列數(shù)
print(sheet.nrows, sheet.ncols)