Analyzing Data Using Python: Filtering Data in Pandas
“Not all data is useful. Luckily there are some powerful filtering operations avAIlable in pandas. The course begins with a detAIled look at how loc and iloc can be used to access specific data from a DataFrame. You ll move on to filter data using the classic pandas lookup syntax and the pandas filter and query methods. You ll illustrate how the filter function accepts wildcards as well as regular expressions and use various methods such as the .isin method to filter data.
Furthermore you ll filter data using either two pAIrs of square brackets – in which case the resulting subset is itself a DataFrame – or a single pAIr of square brackets in which case the returned data takes the form of a Series. You ll drop rows and columns from a pandas DataFrame and see how rows can be filtered out of a DataFrame. Lastly you ll identify a possible gotcha that arises when you drop rows in-place but neglect to reset the index labels in your object.”