‘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.
No comments:
Post a Comment