擅长:python、mysql、java
<p>你应该试试这个</p>
<pre><code>import numpy as np
#in case columns are in String Format
df = df.astype({'DateAndTime': np.datetime64, 'Finished':np.bool})
# 7AM : 7PM Shift
shift_1 = df[df.DateAndTime.apply(lambda t: (t.hour in range(7, 19)) or (t.hour==19 and (t.second+t.minute==0)))]
# 7PM : 7AM Shift
shift_2 = df[df.DateAndTime.apply(lambda t: not ((t.hour in range(7, 19)) or (t.hour==19 and (t.second+t.minute==0))))]
shift_1_TruedCount = shift_1.Finished.to_list().count(True)
shift_2_TruedCount = shift_2.Finished.to_list().count(True)
print(shift_1_TruedCount, shift_2_TruedCount)
</code></pre>