Q$1.[20$ Points$]$

Use only the 'usabilityRating' column for this question. This column contains usability ratings for datasets, including metrics such as 'columnDescriptionScore', 'overImageScore', 'fileDescriptionScore', and others. If a metric is missing for a dataset, it means that the metric is not listed for that dataset.

To complete the task, follow these steps:

Use extractall method to extract the score metrics for each dataset from the 'usabilityRating' column.

Create a DataFrame that provides the following information:

Rows:

Each row should represent a score metric.

The rows should be sorted in descending order based on the 'ValueCount' column.

Columns:

The DataFrame should have two columns:

"ValueCount": List the number of datasets without any missing values for each score metric.

"Average": Calculate the average of the values using all the non$-$missing values for each score metric.

index:

Use the name of the metrics to form the row labels.

$[27]$ ## An example of usabilityRating

Kaggle.usabilityRating $100$

$[27]"\{\text{'}$score$\text{'}$: $0\mathrm{.}7647059,$ 'columnDescriptionScore': $0,$ 'coverImageScore': $1,$ 'fileDescriptionScore': $0\mathrm{.}5,$

'fileFormatScore': $1,$ 'licenseScore': $1,$ 'overviewScore': $1,$ 'publicKernelScore': $1,$ 'subtitleScore': $1,$

'tagscore': $1\}"$