Exploratory Data Analysis using Numpy and Pandas.
You have been hired by a rookie movie producer to help him decide what type of movies to produce and which actors to cast. You have to back your recommendations based on thorough analysis of the data he shared with you which has the list of 3000 movies and the corresponding details.
Further, to answer the following questions:
- Which movie made the highest profit? Who were its producer and director? Identify the actors in that film.
- This data has information about movies made in different languages. Which language has the highest average ROI (return on investment)?
- Find out the unique genres of movies in this dataset.
- Make a table of all the producers and directors of each movie. Find the top 3 producers who have produced movies with the highest average RoI?
- Which actor has acted in the most number of movies? Deep dive into the movies, genres and profits corresponding to this actor.
- Top 3 directors prefer which actors the most?