擅长:python、mysql、java
<p>试试这个,<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.to_datetime.html" rel="nofollow noreferrer">to_datetime</a>和<code>errors=coerce</code>将解析无效的日期&;设置为<code>NaT</code></p>
<pre><code>df['month'] = pd.to_datetime(df['date'], format="%d/%m/%Y", errors='coerce').dt.month
print(df['month'])
</code></pre>
<p>产出</p>
<pre><code> id date name month
0 1 1/1/2020 A 1.0
1 2 2/1/2020 B 1.0
2 3 2/1/2020 None 1.0
3 Total 3 Entries 2 Entries NaN
</code></pre>