CrossTabTest.java

package tech.tablesaw.aggregate;

import static org.junit.jupiter.api.Assertions.assertEquals;
import static org.junit.jupiter.api.Assertions.assertTrue;

import org.junit.jupiter.api.Test;
import tech.tablesaw.api.BooleanColumn;
import tech.tablesaw.api.IntColumn;
import tech.tablesaw.api.Row;
import tech.tablesaw.api.Table;

public class CrossTabTest {

  @Test
  public void testCounts1() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    Table counts = CrossTab.counts(bush, "who");
    Table pcts = CrossTab.percents(bush, "who");
    double sum = counts.numberColumn("Count").sum();
    for (int row = 0; row < pcts.rowCount(); row++) {
      assertEquals(counts.intColumn("Count").get(row) / sum, pcts.doubleColumn(1).get(row), 0.01);
    }
  }

  @Test
  public void testCounts2() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    Table counts = CrossTab.counts(bush, "date");
    Table pcts = CrossTab.percents(bush, "date");
    double sum = counts.numberColumn("Count").sum();
    for (int row = 0; row < pcts.rowCount(); row++) {
      assertEquals(counts.intColumn("Count").get(row) / sum, pcts.doubleColumn(1).get(row), 0.01);
    }
  }

  @Test
  public void testCounts3() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    IntColumn month = bush.dateColumn("date").monthValue();
    month.setName("month");
    BooleanColumn seventyPlus =
        BooleanColumn.create(
            "70", bush.numberColumn("approval").isGreaterThanOrEqualTo(70), bush.rowCount());
    seventyPlus.setName("seventyPlus");
    bush.addColumns(month, seventyPlus);

    Table counts = bush.xTabCounts("month", "seventyPlus");
    for (Row row : counts) {
      assertEquals(
          counts.intColumn("total").get(row.getRowNumber()),
          row.getInt("true") + row.getInt("false"),
          0.01);
    }
    assertTrue(counts.numberColumn("[labels]").isMissing(counts.rowCount() - 1));
  }

  @Test
  public void testColumnPercents() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    bush.addColumns(bush.dateColumn("date").year());
    Table xtab = CrossTab.columnPercents(bush, "who", "date year");
    assertEquals(6, xtab.columnCount());
    assertEquals(1.0, xtab.doubleColumn(1).getDouble(xtab.rowCount() - 1), 0.00001);
  }

  @Test
  public void testRowPercents() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    bush.addColumns(bush.dateColumn("date").year());
    Table xtab = CrossTab.rowPercents(bush, "who", "date year");
    assertEquals(1.0, xtab.doubleColumn(xtab.columnCount() - 1).getDouble(0), 0.00001);
  }

  @Test
  public void testTablePercents() throws Exception {
    Table bush = Table.read().csv("../data/bush.csv");
    bush.addColumns(bush.dateColumn("date").year());
    Table xtab = CrossTab.tablePercents(bush, "who", "date year");
    assertEquals(
        1.0, xtab.doubleColumn(xtab.columnCount() - 1).getDouble(xtab.rowCount() - 1), 0.00001);
  }
}