How to remove rows from a dataset based on condition?

[Anonymous]

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 · Accepted solution]

# 'dataset' holds the input data for this script

if dataset.iloc[5,2] == 1:
    dataset = dataset.drop(4)

[Anonymous]

Hi @lbendlin 

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

[lbendlin]

You need to click on the Table hyperlink.