Answer the following questions on the movies dataset. The dataset is available MS teams

under the Files$->$ Class Material$->$labsheets$->$labsheet$7$ folder.

Notes

$1-$ To be able to read excel files you have to install xlrd package on pycharm.

$2-$ In some questions you may need to search for new methods that are not covered in

the lab slides.

Task$1$:

$1-$ Find The median and standard deviation of the Reviews by Users.

$2-$ Find The minimum number of Facebook likes $-$ Movie for actor$1$ for each language

$3-$ List All Mexico movies that have Spanish language.

$4-$ List the names of Director and the Country for the 'Green Zone $\text{'}$ movie.

$5-$ Find the number of movies for each Actor $2$

$6-$ Find the year where the maximum number of movies released

$7-$ Find the average IMDB score and total budget for movies for the

'Comedy$|$Drama$|$Romanceas$$ movies

$8-$ Find the percentage of movies that have a name with one word.

$9-$ List all Comedy$/$Family movies

$10-$ Remove the 'Facebook Likes $-$ Actor $1\text{'}$ and 'Facebook Likes $-$ Actor $2$'columns $($check the

drop method$)$

$11-$ Set the Budget value for the movies with missing budget to the average of the movies

budget and the IMDB score for the movies with missing score to the value of the

maximum IMDB score in the table.

$12-$ Add new column to the dataframe labeled 'Reviews' that have the sum of 'Reviews by

Users' and 'Reviews by Crtiics' columns.

$13-$ Rename the column 'IMDB Score' to 'Norm$10\_$IMDB' with all data divided by $10$

$14-$ Write the modified dataframe to an excel file named $$movies$\_$updated.xls$.$ The updates

in questions $10,11,12$ and $13$ should be reflected on the saved file.