Published at LXer:
GNU AWK is a great tool for working with tables of data, and by using AWK arrays, you can quickly do column sums (and other calculations) based on unique values in another column. Pivot tables in AWK are a bit trickier. In this article I do a slow walk through the code for a simple pivot table.
Read More...