Introduction

The Bollywood movies dataset, stored in a CSV file named "movies.csv," encapsulates a wealth of information about various Hindi films. This dataset is a result of scraping data from IMDb, the renowned online movie database.

Each entry in the dataset provides details about a Bollywood movie, including its title, release year, duration, ratings, number of raters, a brief summary, and the total votes it has received. In this exploration, we will delve into the significance of each column, unraveling the cinematic landscape of these films.

Columns and Subtitles:

Film Name:

Represents the title of the Bollywood movie.This column serves as a key identifier for each entry, providing a quick reference to the film.

Year:

Denotes the release year of the movie.The year of release is crucial in understanding the historical context and timeline of Bollywood cinema.

Duration:

Specifies the length of the movie in hours and minutes.Duration is an essential aspect for viewers, influencing their decision to engage with the film based on available time.

Ratings:

Indicates the IMDb rating given to the movie.Ratings reflect the critical and audience reception, providing insights into the overall quality and appeal of the film.

Number of Raters:

Represents the quantity of individuals who have rated the movie on IMDb.The number of raters is a measure of the film's popularity and the extent of its reach among the audience.

Summary:

Offers a concise overview of the movie's plot or theme.The summary provides a glimpse into the narrative, offering potential viewers a preview of the storyline.

Votes:

Displays the total count of votes received by the movie on IMDb.The votes signify the level of engagement and interaction from the audience, reflecting the film's impact.

Exploration:

The dataset presents a fascinating opportunity to explore the dynamics of Bollywood cinema, unveiling trends in ratings, popularity, and the evolving nature of film themes. Analyzing the interplay between ratings, number of raters, and votes can offer valuable insights into audience preferences and the success of these movies in the digital era.

As we embark on this cinematic journey through the dataset, we'll uncover patterns, outliers, and intriguing correlations that shed light on the diverse landscape of Bollywood movies in recent years.

Tables

Movies

@kaggle.anoopjohny_the_imdb_bollywood_movies_dataset.movies

966.08 KB
4350 rows
7 columns


CREATE TABLE movies (
  "film_name" VARCHAR,
  "year" VARCHAR,
  "duration" VARCHAR,
  "ratings" VARCHAR,
  "number_of_rators" VARCHAR,
  "summary" VARCHAR,
  "votes" VARCHAR
);