擅长:python、mysql、java
<p>很难看,但可能有用</p>
<p>具有此数据帧:</p>
<pre><code> timeStarted_timeWhenPuzzlesShowScreen
0 10:06:43
1 113507
</code></pre>
<p>如果您运行:</p>
<pre><code>pd.to_datetime(data['timeStarted_timeWhenPuzzlesShowScreen'], \
format='%H:%M:%S',errors='coerce').fillna \
(pd.to_datetime(data['timeStarted_timeWhenPuzzlesShowScreen'], \
format='%H%M%S',errors='coerce'))
</code></pre>
<p>您得到的行为datetimes64:</p>
<pre><code>0 1900-01-01 10:06:43
1 1900-01-01 11:35:07
Name: timeStarted_timeWhenPuzzlesShowScreen, dtype: datetime64[ns]
</code></pre>