From the course: Data Analysis with Python and Pandas

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Solution: Time deltas

Solution: Time deltas

From the course: Data Analysis with Python and Pandas

Start my 1-month free trial Buy for my team

Solution: Time deltas

“

- [Instructor] Alright, everybody. Our solution code is up on the right. Let's go ahead and dive into the notebook. Alright, and so we started with this table here, and the first thing that we wanted to do was add three weeks to our "time_to_last_date" column. So we're calling the "assign" method on our "transactions" data frame, creating a column called "time_to_last_date". We're just going to overwrite the existing "time_ to_last_date" column, and we're going to specify "pd.to_timedelta". We want to add three weeks. We could also do 21 days here as well. Either way, you'll get the same solution. And we're just going to add this "timedelta" to our existing "time_to_last_date" column, which is going to return the column that has 21 more day s than it did before. For the second piece, and of course, we can always break this out into multiple steps, but we're using our lambda trick here. So we want to create a column based off of this updated "time_to_last_date" column. So we want to…

Contents