Hi all, I have an issue that I can’t figure out how to solve it:
I have a df that stores two columns that look like this:
df.scores1 = [[1,2,2,3,5,6,1,2,9,2,1,6,4,2]] df.normalized_len = [[0,0,0.1,0.1,0.2,0.3,0.4,0.5,0.5,0.6,0.7,0,8,0.9,1]]
And this goes on for many rows, all of them having the same length.
What I am trying to do is get the mean values of
df.scores1 that have the same value of
df.normalized_len, so the result should look like this:
df.mean_val_norm = [[1.5,2.5,5,6,1,5.5,2,1,6,4,2]]
Any help is welcome!
Thanks a lot,