Date arithmetic (Timedelta) in Data Analysis Python - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Timedelta in data analysis?

A Timedelta represents a duration or difference between two dates or times. It helps us calculate how much time has passed or will pass.

beginner

How do you add 5 days to a date using Timedelta in Python?

You create a Timedelta of 5 days and add it to the date. For example: <br>new_date = old_date + pd.Timedelta(days=5)

beginner

What happens when you subtract one date from another in pandas?

You get a Timedelta object that shows the difference in time between the two dates, like how many days or seconds apart they are.

beginner

How can Timedelta help in real life? Give an example.

Timedelta can help calculate delivery times, like how many days until a package arrives, or how long a project took by subtracting start and end dates.

intermediate

What units can Timedelta represent?

Timedelta can represent days, hours, minutes, seconds, milliseconds, microseconds, and nanoseconds.

What does pd.Timedelta(days=3) represent?

A A duration of 3 days

B A date 3 days ago

C The current date plus 3 days

D A time of 3 hours

pd.Timedelta(days=3) creates a duration of exactly 3 days, not a specific date or time.

If you subtract two dates in pandas, what type of object do you get?

A Datetime object

B Integer

C Timedelta object

D String

Subtracting two dates returns a Timedelta object representing the time difference.

How would you add 2 hours to a pandas Timestamp?

A timestamp + pd.Timedelta(hours=2)

B timestamp + 2

C timestamp + pd.Timedelta(days=2)

D timestamp + '2 hours'

You add a Timedelta with hours=2 to the timestamp to increase it by 2 hours.

Which of these is NOT a valid Timedelta unit?

A weeks

B months

C days

D seconds

Timedelta does not support months because months vary in length.

What will be the result of pd.Timestamp('2024-01-10') - pd.Timestamp('2024-01-01')?

A 1 day

B 10 days

C 0 days

D 9 days

The difference between Jan 10 and Jan 1 is 9 days.

Explain how you can use Timedelta to find the number of days between two dates.

Think about subtracting dates and checking the days in the result.

Describe how to add 3 hours and 30 minutes to a pandas Timestamp using Timedelta.

Use pd.Timedelta with hours and minutes parameters.