I have a large data set that is unequal in every way so to get things done i have to apply condition on the element of the specific columns. E.g
1 1 2341 1 2341 1 1801 2 3451 2 674...8 1 4538 1 6788 2 4788 2 3458 2 345...31 21 45631 22 45231 22 34531 23 67031 23 56731 23 456
what i want the programme to do is that check the value in column 1 if it equals 1 the check the value in column 2 if it equals 1 then take the mean of all the values in column 3 corresponding to column 2. similarly i want it to repeat for all the values in column 2 for 1st then all the other numbers in column 1 till last number in this case which is 31.
Best Answer