擅长:python、mysql、java
<pre><code>from collections import defaultdict
d = defaultdict(int)
for i, f, *r in df.values:
for v in r:
d[(v, 'filings')] += f
d[(v, 'frequency')] += 1
pd.Series(d).unstack().rename_axis('reqs').reset_index()
reqs filings frequency
0 NaN 7 2
1 Black 11 3
2 Blue 9 3
3 Brown 10 3
4 Green 11 3
5 Orange 4 1
6 Red 9 3
7 Violet 3 1
8 White 9 3
9 Yellow 7 2
</code></pre>