擅长:python、mysql、java
<p>IIUC,我想你想要这个:</p>
<pre><code> df['timestamp'] = pd.to_datetime(df['Date'] + ' ' + df['Interval'])
df['IntervalMap'] = df['timestamp'].dt.hour.mul(4) + df['timestamp'].dt.minute.floordiv(15) + 1
</code></pre>
<p>输出:</p>
<pre><code> Date Interval timestamp IntervalMap
0 2013-08-01 14:00:00 2013-08-01 14:00:00 57
1 2013-08-01 14:15:00 2013-08-01 14:15:00 58
2 2013-08-01 14:30:00 2013-08-01 14:30:00 59
3 2013-08-01 14:45:00 2013-08-01 14:45:00 60
4 2013-08-01 15:00:00 2013-08-01 15:00:00 61
</code></pre>