Tag Archives: cross table

Create new tables with subsets of your data using the Pivot table in LibreOffice

Just accidentally discovered this nifty feature in Calc of Libreoffice allowing to quickly create sub-sets of your data by double clicking on the row or column totals in a Pivot table.

Posted in LibreOffice / OpenOffice | Tagged , , , , | Leave a comment

Cross tables in R, some ways to do it faster

In R to create a contingency table of the counts of the combination of two variables, I would normally resort to table(). But how fast is it? A question that becomes more relevant when working on large tables and when … Continue reading

Posted in Data handling, R computing environment | Tagged , , , , , , , , | 2 Comments

GRASS GIS: creating cross products of multiple raster map layers

I am looking at vegetation distribution in east Africa, using a map we have developed based on historical vegetation maps from the region, and I wanted to know the surface area per vegetation type per country. In ‘spreadsheet terms’, I … Continue reading

Posted in Data handling, GIS, GIS software, GRASS GIS | Tagged , | 4 Comments