movie id movies industry release_year

101 K.G.F: Chapter 2 Bollywood 2022

102 Doctor Strange in the Multiverse of Madness Hollywood 2022
103 Thor: The Dark World Hollywood 2013
104 Thor: Ragnarok Hollywood 2017
105 Thor: Love and Thunder Hollywood 2022
106 Sholay Bollywood 1975
107 Dilwale Dulhania Le Jayenge Bollywood 1995
108 3 Idiots Bollywood 2009
109 Kabhi Khushi Kabhie Gham Bollywood 2001
110 Bajirao Mastani Bollywood 2015
111 The Shawshank Redemption Hollywood 1994
112 Inception Hollywood 2010
113 Interstellar Hollywood 2014
115 The Pursuit of Happyness Hollywood 2006
116 Gladiator Hollywood 2000
117 Titanic Hollywood 1997
118 It's a Wonderful Life Hollywood 1946
119 Avatar Hollywood 2009
120 The Godfather Hollywood 1972
121 The Dark Knight Hollywood 2008
122 Schindler's List Hollywood 1993
123 Jurassic Park Hollywood 1993
124 Parasite Hollywood 2019
125 Avengers: Endgame Hollywood 2019
126 Avengers: Infinity War Hollywood 2018
127 Pather Panchali Bollywood 1955
128 Taare Zameen Par Bollywood 2007
129 Munna Bhai M.B.B.S. Bollywood 2003
130 PK Bollywood 2014
131 Sanju Bollywood 2018
132 Pushpa: The Rise - Part 1 Bollywood 2021
133 RRR Bollywood 2022
134 Baahubali: The Beginning Bollywood 2015
135 The Kashmir Files Bollywood 2022
136 Bajrangi Bhaijaan Bollywood 2015
137 Captain America: The First Avenger Hollywood 2011
138 Captain America: The Winter Soldier Hollywood 2014
139 Race 3 Bollywood 2018
140 Shershaah Bollywood 2021
imdb_rating studio language_id budget
8.4 Hombale Films 3 1
7 Marvel Studios 5 200
6.8 Marvel Studios 5 165
7.9 Marvel Studios 5 180
6.8 Marvel Studios 5 250
8.1 United Producers 1 Not Available
8 Yash Raj Films 1 400
8.4 Vinod Chopra Films 1 550
7.4 Dharma Productions 1 390
7.2 Not Available 1 1.4
9.3 Castle Rock Entertainment 5 25
8.8 Warner Bros. Pictures 5 Not Available
8.6 Warner Bros. Pictures 5 165
8 Columbia Pictures 5 55
8.5 Universal Pictures 5 103
7.9 Paramount Pictures 5 200
8.6 Liberty Films 5 3.18
7.8 20Th Century Fox 5 237
9.2 Paramount Pictures 5 7.2
9 Syncopy 5 185
9 Universal Pictures 5 22
8.2 Universal Pictures 5 63
8.5 Not Available 5 15.5
8.4 Marvel Studios 5 400
8.4 Marvel Studios 5 400
8.3 Government Of West Bengal 7 70
8.3 Not Available 1 120
8.1 Vinod Chopra Productions 1 100
8.1 Vinod Chopra Films 1 850
NULL Vinod Chopra Films 1 1
7.6 Mythri Movie Makers 2 2
8 Dvv Entertainment 2 5.5
8 Arka Media Works 2 1.8
8.3 Zee Studios 1 250
8.1 Salman Khan Films 1 900
6.9 Marvel Studios 5 216.7
7.8 Marvel Studios 5 177
1.9 Salman Khan Films 1 1.8
8.4 Dharma Productions 1 500

Total Movies
Total Bollywood movies
Total bollywood revenue INR
Avg bollywood revenue inr
% revenue from bollywood
 revenue unit currency budget(mil) revenue (mil) budget INR
12.5 Billions INR 1000 12500 1000
954.8 Millions USD 200 954.8 16000
644.8 Millions USD 165 644.8 13200
854 Millions USD 180 854 14400
670 Millions USD 250 670 20000
Not Available Not Available Not Available Not Available Not Available Not Available
2000 Millions INR 400 2000 400
4000 Millions INR 550 4000 550
1360 Millions INR 390 1360 390
3.5 Billions INR 1400 3500 1400
73.3 Millions USD 25 73.3 2000
Not Available Not Available Not Available Not Available Not Available Not Available
701.8 Millions USD 165 701.8 13200
307.1 Millions USD 55 307.1 4400
460.5 Millions USD 103 460.5 8240
2202 Millions USD 200 2202 16000
3.3 Millions USD 3.18 3.3 254.4
2847 Millions USD 237 2847 18960
291 Millions USD 7.2 291 576
1006 Millions USD 185 1006 14800
322.2 Millions USD 22 322.2 1760
1046 Millions USD 63 1046 5040
263.1 Millions USD 15.5 263.1 1240
2798 Millions USD 400 2798 32000
2048 Millions USD 400 2048 32000
100 Millions INR 70 100 70
1350 Millions INR 120 1350 120
410 Millions INR 100 410 100
8540 Millions INR 850 8540 850
5.9 Billions INR 1000 5900 1000
3.6 Billions INR 2000 3600 2000
12 Billions INR 5500 12000 5500
6.5 Billions INR 1800 6500 1800
3409 Millions INR 250 3409 250
11690 Millions INR 900 11690 900
370.6 Millions USD 216.7 370.6 17336
714.4 Millions USD 177 714.4 14160
3.1 Billions INR 1800 3100 1800
950 Millions INR 500 950 500

Total Budget INR

₹ 264,196.40
39
18
80909
4494.9
5%
 revenue INR budget USD revenue USD
12500 12.5 156.25
76384 200 954.8
51584 165 644.8
68320 180 854
53600 250 670
Not Available Not AvailableNot Available
2000 5 25
4000 6.875 50
1360 4.875 17
3500 17.5 43.75
5864 25 73.3
Not Available Not AvailableNot Available
56144 165 701.8
24568 55 307.1
36840 103 460.5
176160 200 2202
264 3.18 3.3
227760 237 2847
23280 7.2 291
80480 185 1006
25776 22 322.2
83680 63 1046
21048 15.5 263.1
223840 400 2798
163840 400 2048
100 0.875 1.25
1350 1.5 16.875
410 1.25 5.125
8540 10.625 106.75
5900 12.5 73.75
3600 25 45
12000 68.75 150
6500 22.5 81.25
3409 3.125 42.6125
11690 11.25 146.125
29648 216.7 370.6
57152 177 714.4
3100 22.5 38.75
950 6.25 11.875

Total Revenue INR

₹ 1,567,141.00 ₹ 3,302.46 ₹ 19,589.26
movie_id budget revenue unit currency
101 1 12.5 Billions INR
102 200 954.8 Millions USD
103 165 644.8 Millions USD
104 180 854 Millions USD
105 250 670 Millions USD
107 400 2000 Millions INR
108 550 4000 Millions INR
109 390 1360 Millions INR
110 1.4 3.5 Billions INR
111 25 73.3 Millions USD
113 165 701.8 Millions USD
114 205 365.3 Millions USD
115 55 307.1 Millions USD
116 103 460.5 Millions USD
117 200 2202 Millions USD
118 3.18 3.3 Millions USD
119 237 2847 Millions USD
120 7.2 291 Millions USD
121 185 1006 Millions USD
122 22 322.2 Millions USD
123 63 1046 Millions USD
124 15.5 263.1 Millions USD
125 400 2798 Millions USD
126 400 2048 Millions USD
127 70 100 Millions INR
128 120 1350 Millions INR
129 100 410 Millions INR
130 850 8540 Millions INR
131 1 5.9 Billions INR
132 2 3.6 Billions INR
133 5.5 12 Billions INR
134 1.8 6.5 Billions INR
135 250 3409 Millions INR
136 900 11690 Millions INR
137 216.7 370.6 Millions USD
138 177 714.4 Millions USD
139 1.8 3.1 Billions INR
140 500 950 Millions INR
406 30 350 Millions INR
412 160 836.8 Millions USD
actor_id name birth_year
50 Yash 1986
51 Sanjay Dutt 1959
52 Benedict Cumberbatch 1976
53 Elizabeth Olsen 1989
54 Chris Hemsworth 1983
55 Natalie Portman 1981
56 Tom Hiddleston 1981
57 Amitabh Bachchan 1942
58 Jaya Bachchan 1948
59 Shah Rukh Khan 1965
60 Kajol 1974
61 Aamir Khan 1965
62 R. Madhavan 1970
63 Sharman Joshi 1979
64 Hrithik Roshan 1974
65 Ranveer Singh 1985
66 Deepika Padukone 1986
67 Tim Robbins 1958
68 Morgan Freeman 1937
69 Leonardo DiCaprio 1974
70 Ken Watanabe 1959
71 Matthew McConaughey 1969
72 Anne Hathaway 1982
73 John David Washington 1984
74 Robert Pattinson 1986
75 Will Smith 1968
76 Thandiwe Newton 1972
77 Russell Crowe 1964
78 Joaquin Phoenix 1974
79 Kate Winslet 1975
80 James Stewart 1908
81 Donna Reed 1921
82 Sam Worthington 1976
83 Zoe Saldana 1978
84 Marlon Brando 1924
85 Al Pacino 1940
86 Christian Bale 1974
87 Heath Ledger 1979
88 Liam Neeson 1952
89 Ben Kingsley 1943
90 Sam Neill 1947
91 Laura Dern 1967
92 Song Kang-ho 1967
93 Lee Sun-kyun 1975
94 Robert Downey Jr. 1965
95 Chris Evans 1981
150 Kanu Banerjee 1905
151 Karuna Banerjee 1919
152 Darsheel Safary 1997
153 Sunil Dutt 1929
154 Anushka Sharma 1988
155 Ranbir Kapoor 1982
156 Allu Arjun 1982
157 Fahadh Faasil 1982
158 N. T. Rama Rao Jr. 1983
159 Ram Charan 1985
160 Prabhas 1979
161 Rana Daggubati 1984
162 Mithun Chakraborty 1950
163 Anupam Kher 1955
164 Salman Khan 1965
165 Nawazuddin Siddiqui 1967
166 Tommy Lee Jones 1946
167 Sebastian Stan 1982
168 Anil Kapoor 1956
169 Sidharth Malhotra 1985
170 Kiara Advani 1991
movie_id actor_id
101 50
101 51
102 52
102 53
103 54
103 55
103 56
104 54
104 56
105 54
105 55
106 57
106 58
107 59
107 60
108 61
108 62
108 63
109 59
109 57
109 64
110 65
110 66
111 67
111 68
112 69
112 70
113 71
113 72
114 73
114 74
115 75
115 76
116 77
116 78
117 69
117 79
118 80
118 81
119 82
119 83
120 84
120 85
121 86
121 87
122 88
122 89
123 90
123 91
124 92
124 93
125 94
125 95
125 54
126 94
126 95
126 54
127 150
127 151
128 61
128 152
129 51
129 153
130 61
130 154
131 155
131 154
132 156
132 157
133 158
133 159
134 160
134 161
135 162
135 163
136 164
136 165
137 95
137 166
138 95
138 167
139 164
139 168
140 169
140 170
language_id name
1 Hindi
2 Telugu
3 Kannada
4 Tamil
5 English
6 French
7 Bengali
8 Gujarati
key metrics marvel consolidated P & L Target Target- Actuals
Revenue $ 9,054.60 $ 8,000.00 $ 1,054.60
Budget $ 1,988.70 $ 2,000.00 $ 11.30
Profit/Loss $ 7,065.90 $ 5,500.00 $ 1,565.90
Profit/Loss % 355% 275% 80%
Total hollywood revenue $ 18,577.90
Market Share % 49% 55% -6%
Target-Actuals%
12%
1%
22%
23%
0%
-13%
mean 7.9474
median 8.1
mode 8.4