TableSaw tutorial

      Introduction to TableSaw

      Working with Columns

      Perform Arithmetic operations on a column

      Selections: Filter the information

      where: filter the elements that matches given criteria

      Selection.with : Select specific rows

      Selection.selectNRowsAtRandom : Select n random rows

      Selection.withRange: Select rows in given range

      Selection.withoutRange: Select elements that are not in given range

      Perform Arithmetic Operations between columns

      min: Find minimum value in a column

      max: Find maximum value in a column

      count: Count number of elements that satisfy given predicate

      countUnique: Count unique elements in a column

      Standard Deviation of a column

      Table

      Create table from csv file

      Get structure or metadata of a table

      Get the shape of a table

      Get number of rows and columns in a table

      Get first n rows of a table

      Get last n rows of a table

      Print all the rows in console

      Print total table in minimized way

      Get all the columns of a table

      Remove specific columns from a table

      Retain specific columns of a table

      Remove columns with missing values

      Add columns to a table

      Column names are case insensitive

      Table: Get column by name

      Table: Get column by index

      Table: Get columns of desired type

      Get all the columns of specific type

      dropRowsWithMissingValues: Drop rows with missing values

      Drop rows that satisfy the condition

      Print table row wise

      Select n random rows from a table

      Add rows from other table

      Print table contents using for-each loop

      Sort the elements of a table

      Sort elements of table in both ascending and descending order

      Filtering the elements of a table

      Combining filters into complex queries

      Select specific column from a table

      Selecting columns in a query statement

      Get summary of table

      Selecting columns in a query statement

Previous                                                    Next                                                    Home