filter rows pandas with condition code example
Example 1: new dataframe based on certain row conditions
filterinfDataframe = dfObj[(dfObj['Sale'] > 30) & (dfObj['Sale'] < 33) ]
Example 2: slice dataframe pandas based on condition
# To slice pandas dataframe by condition
frioMurteira = data.loc[(data["POM"] == "Murteira") & (data["TMP"] > 7.2), ["DTM","TMP"]]
Example 3: filter df by column value
# does year equals to 2002?
# is_2002 is a boolean variable with True or False in it
>is_2002 = gapminder['year']==2002
>print(is_2002.head())
0 False
1 False
2 False
3 False
4 False