Checking column types
Take a look at the UFO dataset's column types using the .info()
method. Two columns jump out for transformation: the seconds
column, which is a numeric column but is being read in as object
, and the date
column, which can be transformed into the datetime
type. That will make our feature engineering efforts easier later on.
This exercise is part of the course
Preprocessing for Machine Learning in Python
Exercise instructions
- Call the
.info()
method on theufo
dataset. - Convert the type of the
seconds
column to thefloat
data type. - Convert the type of the
date
column to thedatetime
data type. - Call
.info()
onufo
again to see if the changes worked.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Print the DataFrame info
print(ufo.____)
# Change the type of seconds to float
ufo["seconds"] = ____
# Change the date column to type datetime
ufo["date"] = ____
# Check the column types
print(ufo.____)