Dataset: Bollywood Box Office (2017-2020)

About this Dataset

Bollywood Box Office (2017-2020)

This is small data set which contains information about box office collection of movie , release date, director , producers , actors etc.

Acknowledgements

Data is scraped from bollywoodmdb.com

Inspiration

Which is the good month to release a movie?
Who is the most earning producer in Bollywood?

cover image : pixabay

Tables

Bollywoodboxoffice Raw

@kaggle.sugandhkhobragade_bollywood_box_office_20172020.bollywoodboxoffice_raw

50.28 KB
130 rows
15 columns


CREATE TABLE bollywoodboxoffice_raw (
  "movie_name" VARCHAR,
  "movie_url" VARCHAR,
  "movie_opening" VARCHAR,
  "movie_weekend" VARCHAR,
  "movie_firstweek" VARCHAR,
  "movie_total" VARCHAR,
  "movie_total_worldwide" VARCHAR,
  "movie_genre" VARCHAR,
  "movie_movierelease" VARCHAR,
  "movie_director" VARCHAR,
  "movie_director_url" VARCHAR,
  "movie_banner" VARCHAR,
  "movie_producer" VARCHAR,
  "movie_stars" VARCHAR,
  "movie_details" VARCHAR
);

Bollywood Box Clean

@kaggle.sugandhkhobragade_bollywood_box_office_20172020.bollywood_box_clean

43.86 KB
130 rows
17 columns


CREATE TABLE bollywood_box_clean (
  "movie_name" VARCHAR,
  "movie_opening" DOUBLE,
  "movie_weekend" DOUBLE,
  "movie_firstweek" DOUBLE,
  "movie_total" DOUBLE,
  "movie_total_worldwide" DOUBLE,
  "movie_genre" VARCHAR,
  "movie_director" VARCHAR,
  "release_date" VARCHAR,
  "release_day" BIGINT,
  "release_month" VARCHAR,
  "release_year" BIGINT,
  "runtime" BIGINT,
  "producer" VARCHAR,
  "banner" VARCHAR,
  "actors" VARCHAR,
  "movie_details" VARCHAR
);