Grouping and Averaging in Table
Dear Rs I have a single table with three columns in the following form: 1 100 150 1 45 32 1 99 100 2 150 33 2 22 87 2 71 31 .... .... 1000 64 32 1 100 150 1 45 32 1 99 100 2 22 89 2 31 44 2 88 11 .... .... 1200 64 32 1 100 150 1 45 32 1 99 100 2 150 33 2 22 87 2 71 31 ... ... 1100 31 34 Totally 1000+1200+1100 rows. Now, I need to group by first column and average then second and third column to get a table as follows as follows: 1 Avg. of all second col. values whose first col value is 1 Avg. of all third col. values whose first col value is 1 2 Avg. of all second col. values whose first col value is 2 Avg. of all third col. values whose first col value is 2 .. .. 1200 Avg. of all second col. values whose first col value is 1200 Avg. of all third col. values whose first col value is 1200 Right now, I have a dirty implementation with a lot of "for" loops and "if" conditions. However, I am looking for some built in functions and lib. to make the code faster and easier. Thanks Prasanna