public void KeepRows()
{
MutableDataTable dt = GetTable();
dt.KeepRows(row => row["last"] == "Jones");
AnalyzeTests.AssertEquals(
@"first,last
Fred,Jones
", dt);
}
// removes rows with empty data
public static string CleanByRows(string filename, params string[] ignorecolumns)
{
MutableDataTable dt = DataAccess.DataTable.New.ReadCsv(filename);
var xx = dt.ColumnNames
.Select((_, i) => { return(ignorecolumns.Contains(_) ? (int?)i : null); })
.Where(cv => cv != null);
dt.KeepRows((_) =>
{
return(_.Values.Select((__, j) => __ != "" || xx.Contains(j)).All(g => g));
});
return(dt.SaveToString());
}
public void KeepRowsThrowsOnNull()
{
MutableDataTable dt = GetTable();
Assert.Throws <ArgumentNullException>(() => dt.KeepRows(null));
}