擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.split.html" rel="nofollow noreferrer">^{<cd1>}</a>,然后从结果列表中提取第二项。你知道吗</p>
<pre><code>In [37]: df['Name'].head()
Out[37]:
0 Braund, Mr. Owen Harris
1 Cumings, Mrs. John Bradley (Florence Briggs Th...
2 Heikkinen, Miss. Laina
3 Futrelle, Mrs. Jacques Heath (Lily May Peel)
4 Allen, Mr. William Henry
Name: Name, dtype: object
</code></pre>
<p>这里的一个观察结果是,名字遵循以下格式:<em>姓</em>,<em>称呼</em><em>名</em>。我们将在空格上拆分,并使用<code>df.apply</code>从拆分列表中提取<em>称呼语</em>:</p>
<pre><code>In [38]: df['Title'] = df['Name'].str.split(' ').apply(lambda x: x[1])
In [39]: df['Title'].head()
Out[39]:
0 Mr.
1 Mrs.
2 Miss.
3 Mrs.
4 Mr.
Name: Title, dtype: object
</code></pre>