24  str

24.1 提取某列的数字生成新列

import pandas as pd

# 创建一个示例DataFrame
data = {'text': ['apple 123 orange', 'banana 456 pineapple', 'grapes 789 mango']}
df = pd.DataFrame(data)

df

	text
0	apple 123 orange
1	banana 456 pineapple
2	grapes 789 mango

# 使用正则表达式提取数字
df['numbers'] = df['text'].str.extract('(\d+)')

df

	text	numbers
0	apple 123 orange	123
1	banana 456 pineapple	456
2	grapes 789 mango	789