Entering edit mode
11.5 years ago
2011101101
▴
110
Thank you for your attention first.I have a file,there are some columns in the file.I need to be calculated in accordance with column.There is an example:
motif WSB-1 WSB-2 SM-1 SM-2 PH-1 PH-2 MY-1 MY-2 total
ATCGAGACTGGGATTTGTCACTCC 62 98 76 64 141 286 124 169 1020
GAACCGGGACTAATGGGCTGACCC 12 26 6 7 36 107 42 32 268
TATTAGTTTACAGAGGGAGTA 10 26 13 10 49 39 46 26 219
ATAGCCACCCAGTTACGTTGTGAC 8 24 8 5 26 71 33 31 206
I need the column of WSB-1 Divided by(/)100,WSB-2/200,SM-1/300,SM-2/400,PH-1/500,PH-2/600,MY-1/700,MY-2/800.
The result should be this
motif WSB-1 WSB-2 SM-1 SM-2 PH-1 PH-2 MY-1 MY-2 total
ATCGAGACTGGGATTTGTCACTCC 0.620 0.490 0.253 0.160 0.282 0.477 0.177 0.211 1020
GAACCGGGACTAATGGGCTGACCC 0.120 0.130 0.020 0.018 0.072 0.178 0.060 0.040 268
TATTAGTTTACAGAGGGAGTA 0.100 0.130 0.043 0.025 0.098 0.065 0.066 0.033 219
ATAGCCACCCAGTTACGTTGTGAC 0.080 0.120 0.027 0.013 0.052 0.118 0.047 0.039 206