A STARTING POINT, MADE FOR YOU
The reporting analyst
toolbox.
Join exports, reshape tables and prepare grouped summaries for a report.
INSIDE THE TOOLBOX
Starter collection9 useful places to start.
Files stay in this browser. Check join keys and output counts before interpreting combined data.
Join two CSV tables
Match rows across two tables using a shared identifier.
Combine CSV tables
Append two tables with matching headings or align a union of their columns.
CSV grouped summary
Summarise a numeric column separately for each category.
CSV wide to long
Turn measurement columns into variable/value rows.
CSV long to wide
Turn identifier/variable/value records into a wider table.
CSV category frequency table
Count exact categories and compare their shares of a selected column.
CSV percentage of total
Append each numeric value’s share of its column total.
CSV running total
Append a cumulative numeric total in the table’s current order.
CSV crosstab
Cross-tabulate categories with counts, sums or averages.
SMALL TASKS. LESS FRICTION.A few things you
A few things you
can tick off.
- Join two exports by an exact identifier
- Reshape a wide table into long records
- Summarise numeric values by category