# pip install pandas
import pandas as pd
data = {"姓名": ["丁丁","小美","大雄"],
"年齡": [25, 22, 28],
"分數": [85, 92, 78]}
df = pd.DataFrame(data)
print(df)
print(df.describe()) # 統計摘要
print(df["分數"]) # 選取單欄
print(df[df["分數"] > 80]) # 篩選
print(df.sort_values("分數", ascending=False)) # 排序# CSV
df = pd.read_csv("data.csv", encoding="utf-8")
df.to_csv("output.csv", index=False, encoding="utf-8-sig")
# Excel
df = pd.read_excel("data.xlsx")
df.to_excel("output.xlsx", index=False)
# 資料處理
df["新欄位"] = df["分數"] * 1.1
df.dropna(inplace=True) # 刪除空值# pip install matplotlib
import matplotlib.pyplot as plt
months = ["1月","2月","3月","4月","5月","6月"]
revenue = [12000, 15000, 11000, 18000, 22000, 25000]
plt.figure(figsize=(10, 5))
plt.plot(months, revenue, marker='o', linewidth=2)
plt.title("上半年營收趨勢")
plt.grid(True, alpha=0.3)
plt.savefig("revenue.png", dpi=150)import pandas as pd; import numpy as np
dates = pd.date_range("2026-01-01", periods=100, freq="B")
np.random.seed(42)
price = 500
prices = []
for _ in range(100):
price *= (1 + np.random.normal(0.0005, 0.015))
prices.append(round(price, 2))
df = pd.DataFrame({"日期": dates, "收盤價": prices})
df["5日均線"] = df["收盤價"].rolling(5).mean()
df["20日均線"] = df["收盤價"].rolling(20).mean()
print(f"最高: {df['收盤價'].max()}, 最低: {df['收盤價'].min()}")