Analyzing Data Using Python: Filtering Data in Pandas
Python 3.8
| Intermediate
- 10 Videos | 1h 26m 11s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courselook up data using different techniquesapply the loc and iloc functions to access specific rows and columnsfilter data using the loc, iloc, at, and iat functionsfilter data using the loc, iloc, at, and iat functions
-
perform conditional filtering using the query functionparse and manipulate datetime valuesselect and drop specific columnsapply regular expressions and other advanced techniques to select and drop columnssummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 10sUP NEXT
-
2.Performing Data Lookup Operations11m 38s
-
3.Leveraging the loc and iloc Functions10m 6s
-
4.Using the loc, iloc, at, and iat Functions to Filter Data11m 54s
-
5.Filtering Data Using Wildcards and Boolean Predicates11m 2s
-
6.Using the Query Function to Filter Data9m 15s
-
7.Manipulating Data Using Datetime Values5m 50s
-
8.Selecting and Dropping Columns11m 3s
-
9.Applying Advanced Techniques to Select and Drop Columns10m 59s
-
10.Course Summary2m 16s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.