dt accessor for datetime properties in Pandas - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of the dt accessor in pandas?

The dt accessor allows you to access datetime properties and methods of pandas Series with datetime values, making it easy to extract parts like year, month, day, and more.

beginner

How do you extract the year from a pandas Series of datetime values?

Use series.dt.year to get the year part of each datetime in the Series.

intermediate

Which dt property would you use to get the day of the week as an integer (Monday=0)?

Use series.dt.dayofweek to get the day of the week as an integer where Monday is 0 and Sunday is 6.

beginner

True or False: You can use dt accessor to convert datetime Series to strings.

True. Use series.dt.strftime() to format datetime as strings with the dt accessor.

beginner

What will series.dt.hour return when applied to a datetime Series?

It returns the hour part (0 to 23) of each datetime value in the Series.

Which pandas dt property gives the month number from a datetime Series?

A series.dt.month

B series.dt.day

C series.dt.year

D series.dt.hour

The dt.month property extracts the month number (1 to 12) from each datetime value.

What does series.dt.dayofyear return?

A Day of the year (1 to 365 or 366)

B Day of the week as an integer

C Day of the month

D Week number of the year

dt.dayofyear returns the day number within the year, starting at 1.

If you want to get the weekday name like 'Monday' from a datetime Series, which dt method do you use?

A series.dt.weekday

B series.dt.day_name()

C series.dt.dayofweek

D series.dt.weekday_name

Use series.dt.day_name() to get the weekday name as a string.

Which of these is NOT a valid dt property in pandas?

A series.dt.minute

B series.dt.second

C series.dt.month_name()

D series.dt.hour_of_day

dt.hour_of_day is not a valid property. Use dt.hour instead.

What type of pandas object must you have to use the dt accessor?

A Series with string values

B DataFrame with any dtype

C Series with datetime64 dtype

D List of datetime objects

The dt accessor works only on Series with datetime64 dtype.

Explain how to extract the year, month, and day from a pandas datetime Series using the dt accessor.

Think about the properties that give parts of a date.

Describe how you would find the weekday name and the hour of the day from a datetime Series in pandas.

One returns a string name, the other returns a number.