Monday 6 April 2020

TableSaw: Remove columns with missing values

‘table.removeColumnsWithMissingValues’ method remove the columns with missing values.

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, 7, 8, 9 };
        String[] firstNames = { "Hari", null, null, null, "Harini", "Lahari", "Rama", "Lakshman", "Sandya" };
        String[] lastNames = { "Krishna", "Gurram", "Maj", "Dev", "Gurram", "Ram", "Sen", "Grandi", "Neelam" };

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

        System.out.println(table.print());

        table.removeColumnsWithMissingValues();

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

    }
}

Output
Employee Ids  |  FirstName  |  LastName  |
-------------------------------------------
            1  |       Hari  |   Krishna  |
            2  |             |    Gurram  |
            3  |             |       Maj  |
            4  |             |       Dev  |
            5  |     Harini  |    Gurram  |
            6  |     Lahari  |       Ram  |
            7  |       Rama  |       Sen  |
            8  |   Lakshman  |    Grandi  |
            9  |     Sandya  |    Neelam  |


 Employee Ids  |  LastName  |
-----------------------------
            1  |   Krishna  |
            2  |    Gurram  |
            3  |       Maj  |
            4  |       Dev  |
            5  |    Gurram  |
            6  |       Ram  |
            7  |       Sen  |
            8  |    Grandi  |
            9  |    Neelam  |

As you see in the above example, Column FirstName has missing values for the rows 2, 3, and 4. When I call the method ‘removeColumnsWithMissingValues’ it removes the column FirstName.




Previous                                                    Next                                                    Home

No comments:

Post a Comment