擅长:python、mysql、java
<p>首先通过<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isnull.html" rel="nofollow noreferrer">^{<cd1>}</a>找到麻烦行的并集。这意味着如果一行的2<code>datetime</code>转换中的<em>任一</em>失败,那么该行将给出<code>False</code>;否则<code>True</code></p>
<pre><code>df['col1'] = pd.to_datetime(df['col1'], errors='coerce')
df['col2'] = pd.to_datetime(df['col2'], errors='coerce')
error_bool = df['col1'].isnull() | df['col2'].isnull()
</code></pre>
<p>然后使用布尔索引:</p>
<pre><code>main = df[~error_bool].copy()
errors = df[error_bool].copy()
</code></pre>
<p>我使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.copy.html" rel="nofollow noreferrer">^{<cd5>}</a>来保证新的数据帧不再引用包含所有行的原始数据帧</p>