Download the kindle$\_$data$-$v$2.$csv dataset from CATS.

Question $1-(70$ points$)$

a$)$ Filter the dataset by taking the rows in which number of 'reviews' are greater than $1$ and less then $201.$ Then save it$.$

In this new dataset, create a column named 'Popularity'. Popularity will contain the information about number of reviews and if the book is bestseller, editorspick or a Goodreads choice. To calculate popularity points, use the formula below:

Popularity $=$ reviews $+$ reviewsisEditorsPick $+$ reviews$*$isGoodReadsChoice

Hint: To do it$,$ you should convert the True$/$False statements into numerical ones. Remember, this true false values mean something, they are not nominal type of categories like blue, green, purple etc. So you should check out other converting functions.

b$)$ Show the count, mean, std$,$ min, $25\%,50\%,75\%,$ max of the Popularity column.

c$)$ Since you find out the mean in 'Popularity', create a loop to count the books which has a greater popularity rate than mean.

Question $2-(30$ points$)$

Create a correlation matrix to find the relationship between stars, reviews, price, Popularity, isBestSeller, isEditorsPick, isGoodReadsChoice columns.