擅长:python、mysql、java
<p>只需检查两种格式中的哪一种,并用该格式应用<code>pandas.to_datetime</code></p>
<pre><code>df = pd.DataFrame({'date': ['2000-01-12', '2015-01-23', '20.12.2015',
'31.12.2009']})
print(df)
date
0 2000-01-12
1 2015-01-23
2 20.12.2015
3 31.12.2009
def date_formator(date):
if '-' in date:
return pd.to_datetime(date, format = '%Y-%m-%d')
else:
return pd.to_datetime(date, format = '%d.%m.%Y')
df.date.apply(date_formator)
0 2000-01-12
1 2015-01-23
2 2015-12-20
3 2009-12-31
Name: date, dtype: datetime64[ns]
</code></pre>