import pandas as pd

# 創(chuàng)建示例數(shù)據(jù)
data = {'Name': ['Alice Smith', 'Bob Johnson', 'Charlie Brown'],
        'Email': ['alice@example.com', 'bob@test.org', 'charlie@demo.net']}
df = pd.DataFrame(data)

# 使用str訪問器
df['Name_Upper'] = df['Name'].str.upper()
print("大寫姓名:\n", df['Name_Upper'])

# 創(chuàng)建示例數(shù)據(jù)
s = pd.Series(['a', 'b', 'c'])

# 簡單連接
result = s.str.cat(sep=',')
print("\n簡單連接結果:", result)

# 與另一Series連接
s2 = pd.Series(['1', '2', '3'])
result = s.str.cat(s2, sep='-')
print("\nSeries間連接:\n", result)

# 連接DataFrame中的多列
df['Name_Email'] = df['Name'].str.cat(df['Email'], sep=' <')
print("\n連接兩列結果:\n", df['Name_Email'])

# 分割姓名
split_names = df['Name'].str.split(' ')
print("\n分割姓名:\n", split_names)

# 獲取分割后的第一部分
first_names = df['Name'].str.split(' ').str[0]
print("\n名字部分:\n", first_names)

# 擴展分割結果為多列
df[['First_Name', 'Last_Name']] = df['Name'].str.split(' ', expand=True)
print("\n擴展分割結果:\n", df[['First_Name', 'Last_Name']])

# 替換域名
df['New_Email'] = df['Email'].str.replace(r'\.\w+$', '.com', regex=True)
print("\n替換域名后:\n", df['New_Email'])

# 使用正則表達式替換
df['Initials'] = df['Name'].str.replace(r'(\w)\w*\s(\w)\w*', r'\1\2', regex=True)
print("\n姓名首字母:\n", df['Initials'])

# 從Email中提取用戶名和域名
extracted = df['Email'].str.extract(r'(?P<Username>\w+)@(?P<Domain>\w+)\.\w+')
print("\n提取結果:\n", extracted)

# 提取名字中的元音字母
vowels = df['Name'].str.extractall(r'([aeiouAEIOU])')
print("\n元音字母:\n", vowels)

# 重復字符串
repeated = df['First_Name'].str.repeat(2)
print("\n重復名字:\n", repeated)

# 按不同次數(shù)重復
repeated = df['First_Name'].str.repeat([1, 2, 3])
print("\n按次數(shù)重復:\n", repeated)

# 計算字符串長度
df['Name_Length'] = df['Name'].str.len()
print("\n姓名長度:\n", df['Name_Length'])

# 檢查是否包含特定字符串
contains_bob = df['Name'].str.contains('Bob')
print("\n包含Bob:\n", contains_bob)

# 檢查是否以特定字符串開始/結束
starts_with_a = df['Name'].str.startswith('A')
print("\n以A開頭:\n", starts_with_a)

# 字符串填充
padded = df['First_Name'].str.pad(width=10, side='right', fillchar='_')
print("\n填充結果:\n", padded)

# 去除空白
df['Name'] = [' Alice ', 'Bob ', ' Charlie']
df['Name_Clean'] = df['Name'].str.strip()
print("\n去除空白后:\n", df['Name_Clean'])

# 使用apply進行復雜處理
def extract_vowels(name):
    return ''.join([c for c in name if c.lower() in 'aeiou'])

df['Vowels'] = df['Name'].apply(extract_vowels)
print("\n提取元音:\n", df['Vowels'])

# 向量化字符串操作
df['Name_Lower'] = df['Name'].str.lower()
df['Name_Title'] = df['Name'].str.title()
print("\n大小寫轉換:\n", df[['Name_Lower', 'Name_Title']])

# 比較向量化操作和循環(huán)的性能
import timeit

# 向量化操作
def vectorized():
    return df['Name'].str.upper()

# 循環(huán)操作
def loop():
    return [name.upper() for name in df['Name']]

print("\n向量化操作時間:", timeit.timeit(vectorized, number=1000))
print("循環(huán)操作時間:", timeit.timeit(loop, number=1000))