Descriptive Analysis of Movies
Saurabh Khanna
Updated: October 18, 2024
## [1] "The size of the file is 1.9549 GB"1 Loading data
Variables in data:
## [1] "Imdb Id" "Localized Title"
## [3] "Cast" "Genres"
## [5] "Runtimes" "Countries"
## [7] "Country Codes" "Language Codes"
## [9] "Color Info" "Aspect Ratio"
## [11] "Sound Mix" "Certificates"
## [13] "Original Air Date" "Rating"
## [15] "Votes" "Cover Url"
## [17] "Plot Outline" "Languages"
## [19] "Title" "Year"
## [21] "Kind" "Original Title"
## [23] "Director" "Producer"
## [25] "Cinematographer" "Akas"
## [27] "Production Companies" "Distributors"
## [29] "Plot" "Composer"
## [31] "Editor" "Assistant Director"
## [33] "Music Department" "Miscellaneous Crew"
## [35] "Special Effects" "Other Companies"
## [37] "Writer" "Production Design"
## [39] "Camera and Electrical Department" "Set Decoration"
## [41] "Costume Designer" "Costume Department"
## [43] "Art Direction" "Art Department"
## [45] "Box Office" "Videos"
## [47] "Thanks" "Synopsis"
## [49] "Editorial Department" "Animation Department"
## [51] "Sound Crew" "Make Up"
## [53] "Production Manager" "Stunt Performer"
## [55] "Transportation Department" "Visual Effects"
## [57] "Location Management" "Casting Director"
## [59] "Casting Department" "Script Department"
## [61] "Top 250 Rank" "Special Effects Companies"
## [63] "Production Status" "Production Status Updated"## Rows: 10
## Columns: 64
## $ imdb_id <chr> "tt13124930", "tt8289486", "tt0083770…
## $ localized_title <chr> "Michael Cacoyannis, le réveil grec",…
## $ cast <chr> "[<Person id:0002187[http] name:_Gior…
## $ genres <chr> "['Documentary']", "['Crime', 'Myster…
## $ runtimes <chr> "['75']", "['60']", "['85']", NA, NA,…
## $ countries <chr> "['France']", "['United States']", "[…
## $ country_codes <chr> "['fr']", "['us']", "['es']", "['us']…
## $ language_codes <chr> "['fr']", "['en']", "['es']", "['en']…
## $ color_info <chr> "['Color']", "['Color']", "['Color']"…
## $ aspect_ratio <chr> NA, "16:9 HD", "1.37 : 1", NA, NA, NA…
## $ sound_mix <chr> NA, "['Dolby Digital::(RCA Sound Reco…
## $ certificates <chr> "['France:Tous publics']", NA, "['Spa…
## $ original_air_date <chr> "06 Mar 2019 (France)", "18 Mar 2018 …
## $ rating <dbl> NA, NA, 3.9, NA, NA, 7.4, NA, 6.1, 6.…
## $ votes <dbl> NA, NA, 261, NA, NA, 47, NA, 197, 104…
## $ cover_url <chr> "https://m.media-amazon.com/images/M/…
## $ plot_outline <chr> "A documentary devoted to the first f…
## $ languages <chr> "['French']", "['English']", "['Spani…
## $ title <chr> "Michael Cacoyannis, le réveil grec",…
## $ year <dbl> 2019, 2018, 1982, NA, NA, 2023, 1963,…
## $ kind <chr> "movie", "movie", "movie", NA, NA, "m…
## $ original_title <chr> "Michael Cacoyannis, le réveil grec",…
## $ director <chr> "[<Person id:11912309[http] name:_Mar…
## $ producer <chr> "[<Person id:2718347[http] name:_Phil…
## $ cinematographer <chr> "[<Person id:11912311[http] name:_Lou…
## $ akas <chr> NA, NA, NA, NA, NA, NA, "['Palos kont…
## $ production_companies <chr> "[<Company id:0821265[http] name:_Les…
## $ distributors <chr> "[<Company id:0212809[http] name:_Tam…
## $ plot <chr> "[\"This documentary retraces the ear…
## $ composer <chr> NA, "[<Person id:6825014[http] name:_…
## $ editor <chr> NA, "[<Person id:6825011[http] name:_…
## $ assistant_director <chr> NA, NA, "[<Person id:0895936[http] na…
## $ music_department <chr> NA, NA, NA, NA, NA, NA, NA, "[<Person…
## $ miscellaneous_crew <chr> NA, NA, "[<Person id:0974222[http] na…
## $ special_effects <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Co…
## $ other_companies <chr> NA, NA, NA, "[<Company id:0758278[htt…
## $ writer <chr> "[<Person id:11912309[http] name:_Mar…
## $ production_design <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ camera_and_electrical_department <chr> NA, NA, NA, "[<Person id:9161024[http…
## $ set_decoration <chr> NA, NA, "[<Person id:0181511[http] na…
## $ costume_designer <chr> NA, NA, NA, "[<Person id:11847145[htt…
## $ costume_department <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ art_direction <chr> NA, NA, NA, NA, NA, NA, NA, "[<Person…
## $ art_department <chr> NA, NA, NA, NA, NA, "[<Person id:1374…
## $ box_office <chr> "{'Budget': 'EUR65,000 (estimated)'}"…
## $ videos <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ thanks <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ synopsis <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ editorial_department <chr> NA, NA, NA, NA, NA, NA, NA, "[<Person…
## $ animation_department <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ sound_crew <chr> NA, NA, NA, NA, NA, "[<Person id:4695…
## $ make_up <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ production_manager <chr> NA, NA, "[<Person id:0757815[http] na…
## $ stunt_performer <chr> NA, NA, "[<Person id:1162886[http] na…
## $ transportation_department <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ visual_effects <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ location_management <chr> NA, NA, NA, "[<Person id:13861351[htt…
## $ casting_director <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ casting_department <chr> NA, NA, NA, NA, NA, NA, NA, NA, "[<Pe…
## $ script_department <chr> NA, NA, "[<Person id:0019098[http] na…
## $ top_250_rank <dbl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ special_effects_companies <chr> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA
## $ production_status <chr> NA, NA, NA, "post production", "scrip…
## $ production_status_updated <chr> NA, NA, NA, "30 Apr 2024", "23 Apr 20…| Name | df |
| Number of rows | 687100 |
| Number of columns | 64 |
| _______________________ | |
| Column type frequency: | |
| character | 60 |
| numeric | 4 |
| ________________________ | |
| Group variables | None |
Variable type: character
| skim_variable | n_missing | complete_rate | min | max | empty | n_unique | whitespace |
|---|---|---|---|---|---|---|---|
| imdb_id | 0 | 1.00 | 9 | 10 | 0 | 687100 | 0 |
| localized_title | 2 | 1.00 | 1 | 242 | 0 | 607061 | 0 |
| cast | 145044 | 0.79 | 37 | 72524 | 0 | 529433 | 0 |
| genres | 76411 | 0.89 | 7 | 129 | 0 | 7534 | 0 |
| runtimes | 259785 | 0.62 | 5 | 9 | 0 | 520 | 0 |
| countries | 14576 | 0.98 | 8 | 901 | 0 | 14329 | 0 |
| country_codes | 14576 | 0.98 | 6 | 434 | 0 | 14329 | 0 |
| language_codes | 86059 | 0.87 | 6 | 314 | 0 | 11328 | 0 |
| color_info | 95539 | 0.86 | 9 | 206 | 0 | 1155 | 0 |
| aspect_ratio | 492790 | 0.28 | 2 | 201 | 0 | 2282 | 0 |
| sound_mix | 477427 | 0.31 | 7 | 975 | 0 | 5600 | 0 |
| certificates | 483814 | 0.30 | 11 | 3318 | 0 | 75788 | 0 |
| original_air_date | 303614 | 0.56 | 9 | 44 | 0 | 179639 | 0 |
| cover_url | 235358 | 0.66 | 100 | 429 | 0 | 451513 | 0 |
| plot_outline | 458415 | 0.33 | 4 | 9733 | 0 | 228277 | 0 |
| languages | 86059 | 0.87 | 6 | 628 | 0 | 11328 | 0 |
| title | 2 | 1.00 | 1 | 242 | 0 | 606767 | 0 |
| kind | 102763 | 0.85 | 1 | 59 | 0 | 520 | 0 |
| original_title | 103224 | 0.85 | 1 | 242 | 0 | 526056 | 0 |
| director | 73701 | 0.89 | 36 | 4191 | 0 | 249802 | 0 |
| producer | 198331 | 0.71 | 37 | 530791 | 0 | 361103 | 0 |
| cinematographer | 250756 | 0.64 | 37 | 2300 | 0 | 162416 | 0 |
| akas | 213323 | 0.69 | 5 | 691 | 0 | 462219 | 0 |
| production_companies | 173028 | 0.75 | 37 | 5195 | 0 | 278520 | 0 |
| distributors | 373687 | 0.46 | 38 | 12962 | 0 | 165588 | 0 |
| plot | 296082 | 0.57 | 7 | 25561 | 0 | 389814 | 0 |
| composer | 375134 | 0.45 | 37 | 2208 | 0 | 121363 | 0 |
| editor | 306890 | 0.55 | 37 | 3335 | 0 | 165665 | 0 |
| assistant_director | 496808 | 0.28 | 38 | 4150 | 0 | 144479 | 0 |
| music_department | 544506 | 0.21 | 37 | 15237 | 0 | 107469 | 0 |
| miscellaneous_crew | 491454 | 0.28 | 38 | 31998 | 0 | 167464 | 0 |
| special_effects | 616379 | 0.10 | 38 | 10866 | 0 | 44358 | 0 |
| other_companies | 575320 | 0.16 | 38 | 12743 | 0 | 74617 | 0 |
| writer | 166431 | 0.76 | 36 | 5812 | 0 | 368673 | 0 |
| production_design | 571062 | 0.17 | 38 | 961 | 0 | 44595 | 0 |
| camera_and_electrical_department | 464130 | 0.32 | 37 | 24633 | 0 | 193426 | 0 |
| set_decoration | 629206 | 0.08 | 38 | 1472 | 0 | 28203 | 0 |
| costume_designer | 574759 | 0.16 | 37 | 838 | 0 | 43304 | 0 |
| costume_department | 594436 | 0.13 | 38 | 8865 | 0 | 72102 | 0 |
| art_direction | 574947 | 0.16 | 38 | 1140 | 0 | 51120 | 0 |
| art_department | 565247 | 0.18 | 38 | 21308 | 0 | 102862 | 0 |
| box_office | 560352 | 0.18 | 28 | 163 | 0 | 26930 | 0 |
| videos | 608546 | 0.11 | 61 | 130 | 0 | 78552 | 0 |
| thanks | 630876 | 0.08 | 37 | 60151 | 0 | 51614 | 0 |
| synopsis | 659075 | 0.04 | 7 | 64420 | 0 | 28022 | 0 |
| editorial_department | 539477 | 0.21 | 37 | 4712 | 0 | 108050 | 0 |
| animation_department | 667865 | 0.03 | 37 | 35374 | 0 | 16476 | 0 |
| sound_crew | 408246 | 0.41 | 38 | 4884 | 0 | 205246 | 0 |
| make_up | 534017 | 0.22 | 38 | 9220 | 0 | 110111 | 0 |
| production_manager | 525795 | 0.23 | 37 | 2099 | 0 | 117675 | 0 |
| stunt_performer | 614975 | 0.10 | 39 | 15776 | 0 | 51634 | 0 |
| transportation_department | 651661 | 0.05 | 38 | 7731 | 0 | 30887 | 0 |
| visual_effects | 600986 | 0.13 | 37 | 130529 | 0 | 65276 | 0 |
| location_management | 634027 | 0.08 | 38 | 6770 | 0 | 43790 | 0 |
| casting_director | 618513 | 0.10 | 37 | 580 | 0 | 27940 | 0 |
| casting_department | 640821 | 0.07 | 38 | 7220 | 0 | 36393 | 0 |
| script_department | 586239 | 0.15 | 38 | 1579 | 0 | 49569 | 0 |
| special_effects_companies | 670972 | 0.02 | 38 | 2026 | 0 | 9787 | 0 |
| production_status | 578842 | 0.16 | 5 | 19 | 0 | 14 | 0 |
| production_status_updated | 578842 | 0.16 | 11 | 11 | 0 | 4439 | 0 |
Variable type: numeric
| skim_variable | n_missing | complete_rate | mean | sd | p0 | p25 | p50 | p75 | p100 | hist |
|---|---|---|---|---|---|---|---|---|---|---|
| rating | 383361 | 0.44 | 6.18 | 1.38 | 1 | 5.30 | 6.3 | 7.10 | 10 | ▁▂▇▇▁ |
| votes | 383361 | 0.44 | 3614.19 | 35755.55 | 5 | 19.00 | 61.0 | 313.00 | 2830894 | ▇▁▁▁▁ |
| year | 103386 | 0.85 | 1992.58 | 30.09 | 1894 | 1975.00 | 2005.0 | 2016.00 | 2031 | ▁▁▂▃▇ |
| top_250_rank | 686848 | 0.00 | 125.65 | 72.29 | 1 | 63.75 | 126.0 | 188.25 | 250 | ▇▇▇▇▇ |
2 Time
3 Space
3.1 Total films
Including all countries of production
Considering primary country of production
3.2 Humans per film
4 Runtimes
5 Genres
6 Languages
Bollywood v Regional Languages (India):
In 2023: