擅长:python、mysql、java
<pre><code>df = pd.DataFrame(np.transpose([[' 8 Feb 2016 10:31', ' 8 Feb 2016 12:31', ' 8 Feb 2016 17:31'],
[' 10 Feb 2016 10:31', ' 11 Feb 2016 12:31', ' 13 Feb 2016 12:31']]), columns=['Start','Stop'])
print(df)
Start Stop
0 8 Feb 2016 10:31 10 Feb 2016 10:31
1 8 Feb 2016 12:31 11 Feb 2016 12:31
2 8 Feb 2016 17:31 13 Feb 2016 12:31
</code></pre>
<p>您需要将它们转换成<code>dtype</code>的<code>datetime</code>,因为它们当前是<code>object</code>(使用<code>df.dtypes</code>来检查这一点)</p>
<p>您可以显式执行:</p>
<pre><code>df.Start = pd.to_datetime(df.Start)
df.Stop = pd.to_datetime(df.Stop)
</code></pre>
<p>或使用应用程序:</p>
<pre><code>df = df.apply(lambda x: pd.to_datetime(x))
</code></pre>
<p>现在不同的是:</p>
<pre><code>df['Total Time'] = df.Stop - df.Start
print(df)
Start Stop Total Time
0 2016-02-08 10:31:00 2016-02-10 10:31:00 2 days 00:00:00
1 2016-02-08 12:31:00 2016-02-11 12:31:00 3 days 00:00:00
2 2016-02-08 17:31:00 2016-02-13 12:31:00 4 days 19:00:00
</code></pre>