NumberFiltersTest.java

package tech.tablesaw.columns.numbers;

import static java.lang.Double.NaN;
import static org.junit.jupiter.api.Assertions.assertArrayEquals;
import static org.junit.jupiter.api.Assertions.assertEquals;

import org.junit.jupiter.api.Test;
import tech.tablesaw.api.DoubleColumn;
import tech.tablesaw.api.FloatColumn;
import tech.tablesaw.api.IntColumn;
import tech.tablesaw.api.Table;
import tech.tablesaw.io.csv.CsvReadOptions;
import tech.tablesaw.selection.Selection;

public class NumberFiltersTest {

  @Test
  public void testIsEqualTo() {
    double[] values = {4, 1, 1, 2, 2};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isEqualTo(1.0);
    assertEquals(1, selection.get(0));
    assertEquals(2, selection.get(1));
    assertEquals(2, selection.size());
  }

  @Test
  public void testIsNotEqualTo() {
    double[] values = {4, 1, 1, 2, 2};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isNotEqualTo(1.0);
    assertEquals(0, selection.get(0));
    assertEquals(3, selection.get(1));
    assertEquals(4, selection.get(2));
    assertEquals(3, selection.size());
  }

  @Test
  public void testIsZero() {
    double[] values = {4, 0, -1};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isZero();
    assertEquals(1, selection.get(0));
    assertEquals(1, selection.size());
  }

  @Test
  public void testIsPositive() {
    double[] values = {4, 0, -1};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isPositive();
    assertEquals(0, selection.get(0));
    assertEquals(1, selection.size());
  }

  @Test
  public void asIntArray() {
    int[] values = {4, 1, 1, 2, 2, 5, 7};
    IntColumn int1 = IntColumn.create("ints", values);
    assertArrayEquals(values, int1.asIntArray());
  }

  @Test
  public void asFloatArray() {
    float[] values = {4, 1, 1, 2, 2, 5, 7};
    FloatColumn c1 = FloatColumn.create("f", values);
    assertArrayEquals(values, c1.asFloatArray());
  }

  @Test
  public void asDoubleArray() {
    double[] values = {4, 1, 1, 2, 2, 5, 7};
    DoubleColumn c1 = DoubleColumn.create("f", values);
    assertArrayEquals(values, c1.asDoubleArray());
  }

  @Test
  public void testIsNegative() {
    double[] values = {4, 0, -0.00001};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isNegative();
    assertEquals(2, selection.get(0));
    assertEquals(1, selection.size());
  }

  @Test
  public void testIsNonNegative() {
    double[] values = {4, 0, -0.00001};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isNonNegative();
    assertEquals(0, selection.get(0));
    assertEquals(1, selection.get(1));
    assertEquals(2, selection.size());
  }

  @Test
  public void testIsGreaterThanOrEqualTo() {
    double[] values = {4, 0, -0.00001};
    double[] otherValues = {4, -1.3, 0.00001, NaN};

    DoubleColumn doubles = DoubleColumn.create("doubles", values);

    Selection selection = doubles.isGreaterThanOrEqualTo(0.0);
    assertEquals(0, selection.get(0));
    assertEquals(1, selection.get(1));
    assertEquals(2, selection.size());

    DoubleColumn others = DoubleColumn.create("others", otherValues);

    Selection selection1 = doubles.isGreaterThanOrEqualTo(others);
    assertEquals(0, selection1.get(0));
    assertEquals(1, selection1.get(1));
    assertEquals(2, selection1.size());
  }

  @Test
  public void testIsLessThanOrEqualTo() {
    double[] values = {4, 0, -0.00001};
    double[] otherValues = {4, -1.3, 0.00001, NaN};

    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isLessThanOrEqualTo(0.0);
    assertEquals(1, selection.get(0));
    assertEquals(2, selection.get(1));
    assertEquals(2, selection.size());

    DoubleColumn others = DoubleColumn.create("others", otherValues);
    Selection selection1 = doubles.isLessThanOrEqualTo(others);
    assertEquals(0, selection1.get(0));
    assertEquals(2, selection1.get(1));
    assertEquals(2, selection1.size());
  }

  @Test
  public void testIsLessThan() {
    double[] values = {4, 0, -0.00001, 5.0};
    double[] values2 = {4, 11, -3.00001, 5.1};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    DoubleColumn doubles2 = DoubleColumn.create("doubles2", values2);
    Selection selection = doubles.isLessThan(doubles2);
    assertEquals(1, selection.get(0));
    assertEquals(3, selection.get(1));
    assertEquals(2, selection.size());
  }

  @Test
  public void testIsGreaterThan() {

    double[] values = {4, 0, -0.00001, 5.0};
    double[] otherValues = {4, -1.3, 0.00001, NaN};

    DoubleColumn doubles = DoubleColumn.create("doubles", values);

    Selection selection = doubles.isGreaterThan(0);
    assertEquals(0, selection.get(0));
    assertEquals(3, selection.get(1));
    assertEquals(2, selection.size());

    DoubleColumn others = DoubleColumn.create("others", otherValues);

    Selection selection1 = doubles.isGreaterThan(others);
    assertEquals(1, selection1.get(0));
    assertEquals(1, selection1.size());
  }

  @Test
  public void testIsEqualTo1() {
    double[] values = {4, 0, -0.00001, 5.0, 4.44443};
    double[] values2 = {4, 11, -3.00001, 5.1, 4.44443};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    DoubleColumn doubles2 = DoubleColumn.create("doubles2", values2);
    Selection selection = doubles.isEqualTo(doubles2);
    assertEquals(0, selection.get(0));
    assertEquals(4, selection.get(1));
    assertEquals(2, selection.size());
  }

  @Test
  public void testIsNotEqualTo1() {
    double[] values = {4, 0, -0.00001, 5.0, 4.44443};
    double[] values2 = {4, 11, -3.00001, 5.1, 4.44443};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    DoubleColumn doubles2 = DoubleColumn.create("doubles2", values2);
    Selection selection = doubles.isNotEqualTo(doubles2);
    assertEquals(1, selection.get(0));
    assertEquals(2, selection.get(1));
    assertEquals(3, selection.get(2));
    assertEquals(3, selection.size());

    Selection selection1 = doubles.isNotEqualTo(doubles2);
    assertEquals(1, selection1.get(0));
    assertEquals(2, selection1.get(1));
    assertEquals(3, selection1.get(2));
    assertEquals(3, selection1.size());
  }

  @Test
  public void testIsMissing() {
    double[] values = {4, 1, NaN, 2, 2};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isMissing();
    assertEquals(2, selection.get(0));
    assertEquals(1, selection.size());
  }

  @Test
  public void testIsNotMissing() {
    double[] values = {4, 1, NaN, 2, 2};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    Selection selection = doubles.isNotMissing();
    assertEquals(0, selection.get(0));
    assertEquals(1, selection.get(1));
    assertEquals(4, selection.size());
  }

  @Test
  public void testNotIn() {
    double[] values = {4, 1, NaN, 2, 2};
    DoubleColumn doubles = DoubleColumn.create("doubles", values);
    double[] comparison = {1, 2};
    Selection selection = doubles.isNotIn(comparison);
    assertEquals(0, selection.get(0));
    assertEquals(2, selection.get(1));
    assertEquals(2, selection.size());
  }

  @Test
  public void testIsBetweenInclusive() throws Exception {
    Table bush = Table.read().csv(CsvReadOptions.builder("../data/bush.csv"));
    Table result = bush.where(bush.numberColumn("approval").isBetweenInclusive(0, 49));
    assertEquals(10, result.rowCount());
  }
}