从Pandas DataFrame的一列中提取2个特殊字符之间的子字符串 [英] Extract sub-string between 2 special characters from one column of Pandas DataFrame

问题描述

我有一个像这样的Python Pandas DataFrame:

I have a Python Pandas DataFrame like this:

Name  
Jim, Mr. Jones
Sara, Miss. Baker
Leila, Mrs. Jacob
Ramu, Master. Kuttan 

我只想从名称"列中提取名称标题，然后将其复制到名为标题"的新列中.输出DataFrame看起来像这样:

I would like to extract only name title from Name column and copy it into a new column named Title. Output DataFrame looks like this:

Name                    Title
Jim, Mr. Jones          Mr
Sara, Miss. Baker       Miss
Leila, Mrs. Jacob       Mrs
Ramu, Master. Kuttan    Master

我正在尝试使用正则表达式找到解决方案，但找不到合适的结果.

I am trying to find a solution with regex but failed to find a proper result.

推荐答案

In [157]: df['Title'] = df.Name.str.extract(r',\s*([^\.]*)\s*\.', expand=False)

In [158]: df
Out[158]:
                   Name   Title
0        Jim, Mr. Jones      Mr
1     Sara, Miss. Baker    Miss
2     Leila, Mrs. Jacob     Mrs
3  Ramu, Master. Kuttan  Master

或

In [163]: df['Title'] = df.Name.str.split(r'\s*,\s*|\s*\.\s*').str[1]

In [164]: df
Out[164]:
                   Name   Title
0        Jim, Mr. Jones      Mr
1     Sara, Miss. Baker    Miss
2     Leila, Mrs. Jacob     Mrs
3  Ramu, Master. Kuttan  Master

这篇关于从Pandas DataFrame的一列中提取2个特殊字符之间的子字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！