I have data frame blue. blue contains 8 columns. I want to take the last two columns, rek and dak, and see how many times each combination of outputs appears there.
for example, when I use the code
Ref_aa Alt_aa * C 1 E 1 G 1 L 3 Q 1 .. Y H 26 N 14 S 10 X 66 Y 6
When I use the code
qw_altref = qw.to_frame() qw_altref
I get it in a data frame format. How can I change the data frame so it looks more like this?
rek dak count a g 21 a f 7
the count column would be how many combinations of each rek and dak there would be
Source: Python Questions