擅长:python、mysql、java
<pre><code> df.groupby(['member_id','event_path']).agg({'event_time':'min','event_duration':'sum'}).reset_index()
</code></pre>
<p>输出:</p>
<pre><code> member_id event_path event_time \
0 2333678 youtube.com/watch?v=w5ZIb05NO58 2016-12-27 04:17:16
1 5611206 youtube.com/watch?v=6YM5UhnElcE 2016-12-30 17:16:27
2 5611206 youtube.com/watch?v=qZrQWA5IsKA 2016-12-30 17:16:01
event_duration
0 69
1 30
2 47
</code></pre>