Skip to content

dropNa not working #637

Description

@jaycoolslm

I am importing an excel file which contains an undefined field:

// read the excel file
  let df = (await dfd.readExcel(local_xcel)) as DataFrame;
  if (test) {
    df = df.head(testAmount);
  }
  console.log("Initial Dataframe");
  df.iloc({ rows: ["15:18"] }).print();

  console.log(df.shape);

  let df_drop = df.dropNa({ axis: 1 });
  df_drop
    .iloc({ rows: ["15:18"] })
    .isNa()
    .print();
  console.log(df_drop.shape);

this code is not removing the undefined row, even though it is identifying it as undefined when using the .isNa() mask

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions