import pandas as pd

# 創(chuàng)建示例DataFrame
df = pd.DataFrame({
    'A': [1, 2, 3],
    'B': ['a', 'b', 'c'],
    'C': [1.1, 2.2, 3.3]
})

# 選擇單列
col_a = df['A']  # 或 df.A

# 選擇多列
subset = df[['A', 'C']]

# 篩選A列大于1的行
filtered = df[df['A'] > 1]

# 多條件篩選
filtered = df[(df['A'] > 1) & (df['C'] < 3)]

# 添加簡(jiǎn)單計(jì)算列
df['D'] = df['A'] * 2

# 添加基于條件的列
df['E'] = ['high' if x > 1 else 'low' for x in df['A']]

# 使用apply函數(shù)
df['F'] = df['B'].apply(lambda x: x.upper())

# 填充缺失值
df_filled = df.fillna(0)  # 用0填充
df_filled = df.fillna(df.mean())  # 用均值填充

# 刪除包含缺失值的行
df_dropped = df.dropna()

# 字符串轉(zhuǎn)數(shù)值
df['A'] = pd.to_numeric(df['A'], errors='coerce')

# 字符串轉(zhuǎn)日期
df['date_col'] = pd.to_datetime(df['date_str'])

# 分類數(shù)據(jù)轉(zhuǎn)換
df['category_col'] = df['text_col'].astype('category')

from sklearn.preprocessing import MinMaxScaler, StandardScaler

# 歸一化 (0-1范圍)
scaler = MinMaxScaler()
df[['A', 'C']] = scaler.fit_transform(df[['A', 'C']])

# 標(biāo)準(zhǔn)化 (均值為0，方差為1)
scaler = StandardScaler()
df[['A', 'C']] = scaler.fit_transform(df[['A', 'C']])

# 等寬分箱
df['A_binned'] = pd.cut(df['A'], bins=3, labels=['low', 'medium', 'high'])

# 等頻分箱
df['A_qcut'] = pd.qcut(df['A'], q=3, labels=['Q1', 'Q2', 'Q3'])

# 標(biāo)簽編碼
from sklearn.preprocessing import LabelEncoder
le = LabelEncoder()
df['B_encoded'] = le.fit_transform(df['B'])

# 獨(dú)熱編碼
df_encoded = pd.get_dummies(df, columns=['B'])

# 創(chuàng)建透 視表
pivot_df = df.pivot_table(index='A', columns='B', values='C', aggfunc='mean')

# 將寬格式轉(zhuǎn)換為長(zhǎng)格式
id_vars = ['A']  # 保持不變的列
value_vars = ['C']  # 要熔化的列
melted_df = pd.melt(df, id_vars=id_vars, value_vars=value_vars)

# 堆疊（將多列轉(zhuǎn)換為行）
stacked_df = df.set_index('A').stack().reset_index()

# 解堆疊（將行轉(zhuǎn)換為多列）
unstacked_df = stacked_df.set_index(['A', 'level_1']).unstack().reset_index()

# 創(chuàng)建第二個(gè)DataFrame
df2 = pd.DataFrame({
    'A': [1, 2, 4],
    'G': ['x', 'y', 'z']
})

# 內(nèi)連接
merged_inner = pd.merge(df, df2, on='A', how='inner')

# 左連接
merged_left = pd.merge(df, df2, on='A', how='left')

# 基于索引的連接
left = df.set_index('A')
right = df2.set_index('A')
joined = left.join(right, how='inner')

# 垂直拼接
concatenated = pd.concat([df, df2], axis=0, ignore_index=True)

# 水平拼接
concatenated = pd.concat([df, df2], axis=1)

# 基本分組聚合
grouped = df.groupby('B').agg({
    'A': 'sum',
    'C': ['mean', 'std']
})

# 多級(jí)分組
multi_grouped = df.groupby(['B', pd.cut(df['A'], bins=2)]).size()

# 創(chuàng)建時(shí)間索引
df['date'] = pd.date_range('2023-01-01', periods=3)
df = df.set_index('date')

# 重采樣
monthly_data = df.resample('M').mean()

# 滾動(dòng)窗口計(jì)算
df['rolling_mean'] = df['C'].rolling(window=2).mean()

# 加載數(shù)據(jù)
sales = pd.read_csv('sales_data.csv')

# 1. 轉(zhuǎn)換日期列
sales['order_date'] = pd.to_datetime(sales['order_date'])

# 2. 提取年月日信息
sales['year'] = sales['order_date'].dt.year
sales['month'] = sales['order_date'].dt.month
sales['day'] = sales['order_date'].dt.day

# 3. 創(chuàng)建價(jià)格區(qū)間列
bins = [0, 50, 100, 200, float('inf')]
labels = ['0-50', '51-100', '101-200', '200+']
sales['price_range'] = pd.cut(sales['price'], bins=bins, labels=labels)

# 4. 計(jì)算每個(gè)客戶的總消費(fèi)
customer_spending = sales.groupby('customer_id')['amount'].sum().reset_index()
customer_spending.rename(columns={'amount': 'total_spending'}, inplace=True)

# 5. 合并回原數(shù)據(jù)集
sales = pd.merge(sales, customer_spending, on='customer_id', how='left')