Sep-12-2019, 04:18 PM
Instead of dropping the rows, you need to filter the dataframe instead, something like this:
import pandas as pd small_df=pd.DataFrame(columns=['1','2','3','4','5','dist','unique']) small_df = small_df.append([{ "1": 100, "2": "Test", "3": "Test" }, { "1": "Test", "2": 100, "3": "Test" }, { "1": "Test", "2": "Test", "3": "Test" }], ignore_index=True) small_df small_df = small_df[(small_df['1'] == 100) | (small_df['2'] == 100) | (small_df['3'] == 100) | (small_df['4'] == 100)] small_df