From the course: Data Analysis with Python and Pandas
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Solution: apply() and where()
From the course: Data Analysis with Python and Pandas
Solution: apply() and where()
- [Instructor] All right, so our solution code is up on the right. Let's go ahead and dive into the notebook. All right, so we have our oil seers here, and we want to define a function. Let's call this buy bool. Even though it's not outputting a true Boolean value, it's a semi Boolean, right? We're you're either outputting wait or buy. And this is going to take in a price and a limit. And so if our price is less than our limit, we're going to return buy. Otherwise, we'll return wait. And so we have our function defined. Now we can go ahead apply this to our series. So oil series dot apply buy bool. And now we need to specify our args. So args equal. And then we need to specify our oil series dot quantile. So oil series dot quantile. we want to pass in .9 for the 90th percentile. And there we go. So if our price is less than our limit, we have a series that says buy. Otherwise, we have a series that says wait. And just to check what our quantile is here, let's go ahead and return this.…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Series basics10m
-
(Locked)
pandas data types and type conversion6m 46s
-
(Locked)
Challenge: Data types and type conversion2m 23s
-
(Locked)
Solution: Data types and type conversion3m 5s
-
(Locked)
The series index and custom indices7m 6s
-
(Locked)
The .iloc accessor4m 33s
-
(Locked)
The .loc accessor7m 3s
-
(Locked)
Duplicate index values and resetting the index6m 33s
-
(Locked)
Challenge: Accessing data and resetting the index2m 1s
-
(Locked)
Solution: Accessing data and resetting the index2m 39s
-
(Locked)
Filtering series and logical tests8m 19s
-
(Locked)
Sorting series3m 45s
-
(Locked)
Challenge: Sorting and filtering series57s
-
(Locked)
Solution: Sorting and filtering series3m 24s
-
(Locked)
Numeric series operations6m 31s
-
(Locked)
Text series operations7m 4s
-
(Locked)
Challenge: Series operations1m 36s
-
(Locked)
Solution: Series operations3m 53s
-
(Locked)
Numerical series aggregation5m 43s
-
(Locked)
Categorical series aggregation3m 32s
-
(Locked)
Challenge: Series aggregation50s
-
(Locked)
Solution: Series aggregation4m 20s
-
(Locked)
Missing data representation in pandas4m 29s
-
(Locked)
Identifying missing data2m 15s
-
(Locked)
Fixing missing data9m 27s
-
(Locked)
Challenge: Missing data45s
-
(Locked)
Solution: Missing data1m 35s
-
(Locked)
Applying custom functions to series4m 6s
-
(Locked)
pandas where() vs. NumPy where()6m 3s
-
(Locked)
Challenge: apply() and where()1m 9s
-
(Locked)
Solution: apply() and where()4m 37s
-
(Locked)
Key takeaways1m 24s
-
(Locked)
-
-
-
-
-
-
-
-