The Where statement is used in SQL to apply filter conditions to filter rows based on certain criteria. The equivalent in pandas is condition-based logical subsetting.

Suppose we want to find out the rows where active_status ==1. This can be done in the two tools in the following manner.