topic Re: How to remove rows from a dataset based on condition? in Developer

How to remove rows from a dataset based on condition?

Anonymous — Wed, 23 Feb 2022 08:36:40 GMT

I've ran the following Python script in the Query Editor but it does not change the dataset.

# 'dataset' holds the input data for this script if dataset.iloc[5,2] == 1: dataset.drop(4)

I want the code to delete row 4 if row 5's value column is equal to 1. Any idea if there's a problem with my code? Here is a snippet of the data

lbendlin — Sun, 27 Feb 2022 01:15:14 GMT

# 'dataset' holds the input data for this script if dataset.iloc[5,2] == 1: dataset = dataset.drop(4)

Anonymous — Mon, 28 Feb 2022 08:15:20 GMT

Tried this but I only got the following output. Any idea why?

lbendlin — Mon, 28 Feb 2022 12:13:16 GMT

You need to click on the Table hyperlink.