the column describe if a study is recruiting volunteer to Enroll in the study.
Check the categorical data to make sure all the data has the same form for the same category.

Example:
if the study is recruiting the column will show 'Recruiting'
but sometime it might show for example 'Taking volunteer'

so the goal is to make sure all the categorical data representation has the same form

The column show: what is the procedure the study will apply on the volunteer. the main objective is to make the convert the data in the column in from unique values into categories.

example:
those are some unique values in the data set:

'Drug: REGN10933+REGN10987 combination therapy|Drug: Placebo'
'Drug: Aprotinin'
'Biological: convalescent plasma'
'Biological: COVI-VAC|Other: Placebo'

objective is to make them look like this

'Drug'
'Drug'
'Biological'
'Biological'

you have to cut off a part of the string after the ":"

hey

the location column show the full address

convert it to show only the country name

Main objective of the issue is to handle missing values and to choose the suitable attributes for the project

main goal is to create column that contain the study type for each column

the column should contain these values:

Prevention, Treatment, Test, Vaccine, Other