1. Learn
    2. /
  2. Courses
    3. /
  3. Anomaly Detection in Python

Exercise

Working with DateTime columns

pandas loads datetime columns as an object data type by default. Having text dates aren't much use for time series analysis, so you must be able to convert those columns into a datetime datatype. This data type allows you to work more flexibly with pandas dates and extract useful features from them.

Another stocks dataset, this time for Apple, has been loaded as apple.

Instructions

100 XP
  • Convert the Date column of apple to a datetime column.
  • Extract the day of the week and store it in a new column called day_of_week.
  • Extract the month number and store it in a new column called month.
  • Extract the day of the month and store it in a new column called day_of_month.