Hi, we are very happy to have you among the candidates for the position of tutor! [Practicum by Yandex](https://practicum.yandex.com/) is an online educational platform. We help people who want to change their lives and jumpstart new careers in tech. Our team includes dozens of specialists from various fields, all working together to produce quality educational content. For our online **course** **Data Analyst** [practicum.yandex.com/data-analyst](https://practicum.yandex.com/data-analyst/) and **Data Scientist** [practicum.yandex.com/data-scientist](https://practicum.yandex.com/data-scientist/) we are looking for the experienced Data Analysts / Data Scientists. In order to be objective and to make sure that the scope of your knowledge and skills corresponds to the requirements of this job, we invite you to take a test. This is a test task for data analysis and data science specialists with experience of working with Python. Some tasks are easy, while others are a bit more difficult. If they seem a little too simple for an IT company like Yandex, don't go looking for the catch. The main objective of our course is to prepare beginners for work; keep this in mind. After you have completed the test task, we'll get in touch with you to discuss the results of this stage of the selection process. **Task 1. Working with data** [movie_metadata.csv](https://s3-us-west-2.amazonaws.com/secure.notion-static.com/fb728421-b488-45ef-9d84-61f73a1f57e5/movie_metadata.csv) To complete this task, use the data set in the attached file. Indicate the answer to each of the following steps and time to complete the entire task. 1.1. Download the data set `movie_metadata.csv`, which contains data about films from IMDb (Internet Movie Database). 1.2. The `duration` column contains data on the film length. How many missing values are there in this column? 1.3. Replace the missing values in the `duration` column with the median value for this column. 1.4. What is the average film length? Give the answer as a floating-point figure rounded to two decimal places. 1.5. How many films between 90 minutes and two hours long were released in 2008? 1.6. The `budget` column contains the film's budget. What is the median budget for all the films listed? Give the answer as an integer.