如何使用python从列值中删除额外的字符

import pandas as pd

data = {
    'column1': ['abc123', 'def456', 'ghi789'],
    'column2': ['123-abc', '456-def', '789-ghi']
}

df = pd.DataFrame(data)
print(df)

  column1  column2
0  abc123  123-abc
1  def456  456-def
2  ghi789  789-ghi

df['column1'] = df['column1'].str.replace(r'[a-zA-Z]', '', regex=True)
print(df)

  column1  column2
0     123  123-abc
1     456  456-def
2     789  789-ghi

df['column2'] = df['column2'].str.replace(r'\D', '', regex=True)
print(df)

  column1 column2
0     123     123
1     456     456
2     789     789

df['column1'] = df['column1'].str.strip()
print(df)

# 删除前缀 'abc'
df['column1'] = df['column1'].str.lstrip('abc')
print(df)

# 删除后缀 '789'
df['column1'] = df['column1'].str.rstrip('789')
print(df)

df['column2'] = df['column2'].str[:3] + df['column2'].str[4:]
print(df)

  column1 column2
0     123    123bc
1     456    456ef
2     789    789hi

df['column1'] = df['column1'].str.replace(r'[a-zA-Z]', '', regex=True).str.strip()
df['column2'] = df['column2'].str.replace(r'\D', '', regex=True).str.strip()
print(df)

  column1 column2
0     123     123
1     456     456
2     789     789