TableSaw: Combining filters into complex queries

TableSaw provides many clauses like ‘and’, ‘or’, ‘isEven’ etc., to form complex queries.

Example

Table resultedTable = table.where(stringColumn.startsWith("C").and(stringColumn.endsWith("u")));

App.java

package com.sample.app;

import tech.tablesaw.api.IntColumn;
import tech.tablesaw.api.StringColumn;
import tech.tablesaw.api.Table;

public class App {

    public static void main(String args[]) {
        int[] empIds = { 1, 2, 3, 4, 5, 6 };
        String[] firstNames = { "Hari", "Ram", "Sowmya", "Chamu", "Swethank", "Chamu" };
        String[] lastNames = { "Krishna", "Gurram", "Maj", "Maj", "Baji", "Gurram" };

        Table table = Table.create().addColumns(IntColumn.create("Employee Id", empIds))
                .addColumns(StringColumn.create("FirstName", firstNames))
                .addColumns(StringColumn.create("LastName", lastNames));
        
        StringColumn stringColumn = table.stringColumn("FirstName");

        Table resultedTable = table.where(stringColumn.startsWith("C").and(stringColumn.endsWith("u")));
                

        System.out.println(table.print());
        System.out.println("\n" + resultedTable.print());

    }
}

Output

Employee Id  |  FirstName  |  LastName  |

------------------------------------------

           1  |       Hari  |   Krishna  |

           2  |        Ram  |    Gurram  |

           3  |     Sowmya  |       Maj  |

           4  |      Chamu  |       Maj  |

           5  |   Swethank  |      Baji  |

           6  |      Chamu  |    Gurram  |

 Employee Id  |  FirstName  |  LastName  |

------------------------------------------

           4  |      Chamu  |       Maj  |

           6  |      Chamu  |    Gurram  |

Previous                                                    Next                                                    Home