擅长:python、mysql、java
<p>可能需要将间隔拆分为间隔\u开始和间隔\u结束,并检查它们是否相等:</p>
<pre><code>df['Interval_start'] = df['Interval'].map(lambda s: s.split('-')[0])
df['Interval_end'] = df['Interval'].map(lambda s: s.split('-')[1])
df.query("Interval_start != Interval_end")
UNIT EXITSn_hourly Interval Interval_start Interval_end
1867 R081 104 00:00:00-04:00:00 00:00:00 04:00:00
1869 R081 129 04:00:00-08:00:00 04:00:00 08:00:00
1870 R081 521 08:00:00-12:00:00 08:00:00 12:00:00
1871 R081 1048 12:00:00-16:00:00 12:00:00 16:00:00
2838 R032 38 00:00:00-04:00:00 00:00:00 04:00:00
2840 R032 89 04:00:00-08:00:00 04:00:00 08:00:00
2841 R032 470 08:00:00-12:00:00 08:00:00 12:00:00
</code></pre>