擅长:python、mysql、java
<p>看来你已经很接近了。以下几点对我有用:</p>
<pre><code>import pandas as pd
data = ['Class II: R : 20180920','Class II: O : 20181119','Class II: D1: 20170601','Class O: D1: 20190219']
df = pd.DataFrame({"incident_history":data})
def extract_dt(dt_str):
out_str = dt_str[dt_str.rfind(":")+1:].strip()
return pd.to_datetime(out_str, format="%Y%m%d")
df['incident_history_reformed'] = df["incident_history"].apply(extract_dt)
</code></pre>
<p>其中<code>incident_history_reformed</code>将具有datetime64[ns]类型,从而为pandas提供的所有datetime功能打开了大门。在</p>