Problem $2$: Movie Data Analysis $($ hw$0\_$p$2.$py$)$

In this homework, you are asked to write a program for answering the following questions

based on IMDB Movie data $($IMDB$-$Movie$-$Data.csv$).$ You are required to write a function for

answering each question. You may want to use Python's File reading, List, Dictionary, and

Functions. You cannot use any packages. The output format of each question is free.

Find all actors who collaborate with Johnny Depp in direct and indirect ways

Example:

$(7)$

A collaborates with B

B collaborates with C and D

All actors directly and indirectly

C collaborates with $E$ and $F$

collaborating with A include:

D collaborates with A and G

$B,C,D,E,F,G,H$

G collaborates with H

below are the sample csv file

Rank,Title,Genre,Director,Actors,Year,Runtime $($Minutes$),$Rating,Votes,Revenue $($Millions$),$Metascore

$55,$The Dark Knight,Action$|$Crime$|$Drama$,$Christopher Nolan,Christian Bale$|$ Heath Ledger$|$ Aaron Eckhart$|$Michael Caine,$2008,152,9,1791916,533\mathrm{.}32,82$

$81$

FAQ

After the Actors in the second question data are segmented, if their names are not exactly the same, they will be regarded as different actors.

The sixth question of the second question is changed to print out all the actors in the largest GAP YEAR

For the second question, if there are multiple actors tied for the same ranking $,$ all actors tied for the same ranking need to be listed as the answer.

If revenue in the second question is blank, the movie will be omitted.

The second question in the second question, the algorithm with the highest average income can have multiple calculation methods. Please also explain how it is defined in the code.