Task $1$ Data Cleaning $[13$ marks$]$:

You are required to clean the dataset using any tool you prefer $($Excel$,$ Python, R etc$)$ subject to the

following conditions:

$$ Each data record must, at minimum, contain the fieldslisted below.

Field Name Required

Object ID X

Department X

Object Name X

Title X

Culture X

Artist Nationality X

Object Begin Date X

Object End Date X

Medium X

Credit Line X

Country X

$$ Anyfieldthatisnotexplicitly listedabovecanbeconsideredirrelevantin thiscontext and can

be removed

$$ Anyfield listed above thatisdesignated as "Required"mustcontainavaliddatavalue.

$$ The field named "ObjectID" represents a unique identifier.

$$ For any given field, the data values stored within it must be represented consistently

$$ All data values must make logical sense and correspond to actual possible values