Hi
I have a table that consists of feature name and next a value, this table has let say 10 pairs of such structure
clmn1 vclmn1 clmn2 cvlm2.....
The names of features cross clmn are most similar and I want to create one column that has the average of this feature.
How can I do that? See below for real table.
Best
feature1 value1 feature 2 value2 feature3 value 3
G | 0.028376840766409117 | GCU_all | 0.03446338446971087 | GCU_all | 0.033955402957853265 |
GCU_all | 0.02379769967138934 | G | 0.027192279055596735 | CC | 0.02651697744467474 |
CCC | 0.021008378958015772 | CUG_all | 0.02400199692934546 | GC_all | 0.021687192253840304 |
GCU | 0.020358964518361722 | CCC | 0.022955476956032617 | CUG_all | 0.021144721745195216 |
CC | 0.020223023513518124 | GCU | 0.021766174475012612 | AGC | 0.02063919111659529 |
UG | 0.019059676615830412 | CC | 0.021142856380222508 | G | 0.02058337091887663 |
CUG_all | 0.015546539449747376 | GC_all | 0.0198817797381321 | GCU | 0.020476340840891782 |
CCA_all | 0.01467682312714269 | UG_all | 0.017030740492753438 | CU_all | 0.019699995017637084 |
GC | 0.014619026725077866 | CU_all | 0.01613401258341085 | GC | 0.01915897790070109 |
GC_all | 0.01456683188121688 | AGC_all | 0.01571225294525691 | AGC_all | 0.018669437267961664 |
C | 0.014503782553185074 | UA | 0.012996796046395698 | CCC | 0.01778693426167488 |
CUA | 0.014027201928700661 | CUG | 0.012255865695757096 | UG_all | 0.017170858836885627 |
UG_all | 0.013679208191501813 | UG | 0.012241317172263733 | C | 0.014764686679316186 |
CC_all | 0.01238052009224333 | C | 0.011926456169974897 | AA | 0.01336241146131345 |
AGC_all | 0.012286794188367534 | AGC | 0.01179164986932113 | UGA_all | 0.013224180758943493 |
CCU | 0.011451227196339064 | GCA_all | 0.011603110454518561 | UGC_all | 0.013076908776167073 |
CU_all | 0.011397928515809008 | GA_all | 0.011259434458546824 | UG | 0.012801468439130437 |
CUA_all | 0.011267145439019632 | GC | 0.0111539985260386 | GCA_all | 0.012801365649454222 |
CCC_all | 0.01059381432497164 | CUA | 0.011127257259377021 | CCA_all | 0.01264645514234708 |
CUG | 0.010512036781460399 | UGA_all | 0.010805040849033887 | CCU | 0.012563989379188456 |
AGC | 0.010276197148965771 | CCC_all | 0.010110321211036277 | AAA | 0.011858297246299387 |
GA_all | 0.010119338368865805 | CCA_all | 0.010104511873366695 | GA_all | 0.011711204125454566 |
UGA_all | 0.009806515804207105 | G_all | 0.009915540598936401 | G_all | 0.01161524465874697 |
CCA | 0.009677331516789622 | CUA_all | 0.00942239495204733 | CAG | 0.010043313732038817 |
UCC | 0.009634090208426427 | A | 0.0 | CUG | 0.009893573679403245 |
GA | 0.009612006992500088 | AA | 0.0 | UA | 0.009798842698537813 |
GCA_all | 0.009290832503512036 | AAA | 0.0 | U_all | 0.00961454163951303 |
UA | 0.009246761198976272 | AAA_all | 0.0 | GGG | 0.00953827813672592 |
A | 0.0 | AAC | 0.0 | CCC_all | 0.009402898170359775 |
AA | 0.0 | AAC_all | 0.0 | AG | 0.009284557824013495 |
AAA | 0.0 | AAG | 0.0 | UGC | 0.00924801286380772 |
AAA_all | 0.0 | AAG_all | 0.0 | GG | 0.009148338615572849 |
AAC | 0.0 | AAU | 0.0 | A | 0.0 |
AAC_all | 0.0 | AAU_all | 0.0 | AAA_all | 0.0 |
AAG | 0.0 | AA_all | 0.0 | AAC | 0.0 |
AAG_all | 0.0 | AC | 0.0 | AAC_all | 0.0 |
AAU | 0.0 | ACA | 0.0 | AAG | 0.0 |
AAU_all | 0.0 | ACA_all | 0.0 | AAG_all | 0.0 |
AA_all | 0.0 | ACC | 0.0 | AAU | 0.0 |
AC | 0.0 | ACC_all | 0.0 | AAU_all | 0.0 |
ACA | 0.0 | ACG | 0.0 | AA_all | 0.0 |
ACA_all | 0.0 | ACG_all | 0.0 | AC | 0.0 |
ACC | 0.0 | ACU | 0.0 | ACA | 0.0 |
ACC_all | 0.0 | ACU_all | 0.0 | ACA_all | 0.0 |
ACG | 0.0 | AC_all | 0.0 | ACC | 0.0 |
ACG_all | 0.0 | AG | 0.0 | ACC_all | 0.0 |
ACU | 0.0 | AGA | 0.0 | ACG | 0.0 |
ACU_all | 0.0 | AGA_all | 0.0 | ACG_all | 0.0 |
AC_all | 0.0 | AGG | 0.0 | ACU | 0.0 |
AG | 0.0 | AGG_all | 0.0 | ACU_all | 0.0 |