i have a csv file that contains two columns,here is it below,goes all the way down.
i want to be able to import the file which i did,but the problem is that i want to count the k and record how many times it occurs,for instance 106 appeared just once,61 once and so on like that,after which i will record it in the next column as sum(k)
Expand|Select|Wrap|Line Numbers
- p(ki) k sum(k) p(ki2)
- 0.117909 106 1 0.00209205
- 0.067853 61 1 0.00209205
- 0.048943 44 1 0.00209205
- 0.047831 43 3 0.006276151
- 0.047831 43
- 0.047831 43
- 0.046719 42 2
- 0.046719 42
- 0.045606 41 1
- 0.044494 40
- 0.043382 39
- 0.038932 35
- 0.038932 35
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.03782 34
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.036707 33
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.035595 32
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.034483 31
- 0.03337 30
- 0.03337 30
- 0.03337 30
- 0.03337 30
- 0.03337 30
- 0.03337 30
- 0.03337 30
- 0.025584 23
- 0.017798 16
- 0.015573 14
- 0.014461 13
- 0.013348 12
- 0.012236 11
- 0.012236 11
- 0.012236 11
- 0.012236 11
- 0.012236 11
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.011123 10
- 0.010011 9
- 0.008899 8
- 0.008899 8
- 0.008899 8
- 0.008899 8
- 0.007786 7
- 0.007786 7
- 0.007786 7
- 0.007786 7
- 0.007786 7
- 0.006674 6
- 0.006674 6
- 0.006674 6
- 0.006674 6
- 0.006674 6
- 0.005562 5
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.004449 4
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.003337 3
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.002225 2
- 0.001112 1 140 0.292887029
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1
- 0.001112 1