我有一个 pandas 数据框列,其中包含如下所示的字符串:
Column A
text moretext 251 St. Louis Apt.54
123 Orange Drive
sometext somemoretext 171 Poplar street
textnew 11th street
77 yorkshire avenue
我想删除数值之前的文本,即我希望输出如下所示:
Column A
251 St. Louis Apt.54
123 Orange Drive
171 Poplar street
11th street
77 yorkshire avenue
请您参考如下方法:
让我们使用正则表达式和提取:
df['Column A'] = df['Column A'].str.extract(r'(\d+.+$)')
输出:
0 251 St. Louis Apt.54
1 123 Orange Drive
2 171 Poplar street
3 11th street
4 77 yorkshire avenue
Name: Column A, dtype: object
正则表达式状态获取一组以任意长度的数字开头的字符,一直持续到行尾。
