擅长:python、mysql、java
<p>下面是一个涉及temp列的解决方案,并从<a href="https://stackoverflow.com/questions/17841149/pandas-groupby-how-to-get-a-union-of-strings">this answer</a>中获得了键操作的灵感:</p>
<pre><code># create a temp column with the character we want from each string
dframe['Temp'] = dframe['GEOSTRING'].apply(lambda x: x[4])
# groupby ID and then concatenate using a sneaky call to .sum()
dframe.groupby('IDactivity')['Temp'].sum().tolist()
</code></pre>
<p>结果:</p>
^{pr2}$