to_datetime() conversion in Data Analysis Python - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to convert the 'date' column to datetime format.

Data Analysis Python

df['date'] = pd.[1](df['date'])

Drag options to blanks, or click blank then click option'

Ato_numeric

Bto_string

Cto_list

Dto_datetime

Attempts:

3 left

💡 Hint

Common Mistakes

Using to_string() instead of to_datetime()

Trying to convert with to_numeric() which is for numbers

The pd.to_datetime() function converts a column to datetime format.

2fill in blank

medium

Complete the code to convert the 'date' column with a specific format 'YYYY-MM-DD'.

Data Analysis Python

df['date'] = pd.to_datetime(df['date'], format=[1])

Drag options to blanks, or click blank then click option'

A'%d/%m/%Y'

B'%Y-%m-%d'

C'%m-%d-%Y'

D'%Y/%m/%d'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong order like day before month

Using slashes instead of dashes

The format string '%Y-%m-%d' matches dates like '2023-06-15'.

3fill in blank

hard

Fix the error in the code to convert 'date' column to datetime, allowing errors to become NaT.

Data Analysis Python

df['date'] = pd.to_datetime(df['date'], errors=[1])

Drag options to blanks, or click blank then click option'

A'fail'

B'ignore'

C'coerce'

D'raise'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'raise' which stops on errors

Using 'ignore' which leaves original data unchanged

The errors='coerce' option converts invalid parsing to NaT (missing datetime).

4fill in blank

hard

Fill both blanks to convert 'date' column to datetime and set dayfirst to True.

Data Analysis Python

df['date'] = pd.to_datetime(df['date'], [1]=[2])

Drag options to blanks, or click blank then click option'

Adayfirst

BTrue

CFalse

Dformat

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'format' instead of 'dayfirst'

Setting dayfirst to False when day comes first

Setting dayfirst=True tells pandas to interpret the day before the month.

5fill in blank

hard

Fill all three blanks to convert 'date' column to datetime with format '%d-%m-%Y', coerce errors, and set utc to True.

Data Analysis Python

df['date'] = pd.to_datetime(df['date'], format=[1], errors=[2], utc=[3])

Drag options to blanks, or click blank then click option'

A'%Y/%m/%d'

B'coerce'

CTrue

D'%d-%m-%Y'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong format string

Not setting errors='coerce' causing exceptions

Forgetting to set utc=True when needed

This code converts dates with day-month-year format, replaces errors with NaT, and sets timezone to UTC.