Film genre stats

-
Today I analysed a dataset on films. This dataset is procured from kaggle. In this dataset they have given movies from 1995 to 2018. By seeing below  line  📈  from 1995 to 2018 overall movies are increased rapidly. Here we can also see that few years movies releases decreases compared to previous years. 

Here, we can see that movies release in different genres. Mostly Drama, Comedy, Documentary genre movies released. Because these types of movies may probably like all age groups. But by seeing gross chart we can observe that most of the money came from Adventure and Action movies. By seeing this why they didn't make and release more action and adventure movies!? But reason is that these Action and Adventure movies can cast very high to make movies like these. For these movies they've to go more different locations and shoot movies. It's costs and budget very high. Even though they make movies like these they have take more time compared to other movies. 

Here we can see that mostly Adventure movies get more money then followed by Action and Drama. Because these type of movies likes all age groups of people. 







Comments

Post a Comment

Popular posts from this blog

SQL Queries

-
 Hello guys! Today, I practiced SQL Queries in  SQLZoo . SELECT population FROM world WHERE name = 'Germany' SELECT name, population FROM world WHERE name IN ('Sweden', 'Norway','Denmark') SELECT name, area FROM world WHERE area BETWEEN 200000 AND 250000; SELECT name FROM world WHERE population >= 200000000 SELECT name,(population/1000000) as population FROM world WHERE continent='South America' SELECT name,population FROM world WHERE name IN('France', 'Germany', 'Italy') SELECT name FROM world WHERE name LIKE 'United%' SELECT name, population, area FROM world WHERE area>3000000 AND population>250000000
Read more

SQL Queries

-
Image
use sql_store; Select * from customers; insert into customers values (default,'Janani','P',null,null,'RVS','MPL','AP',default); insert into customers values (default,'Lalitha','V',null,null,'MPL','MPL','AP',570), (default,'Vyshu','V',null,null,'Kadapa','Kadapa','AP',670), (default,'Sandhya','G',null,null,'GVP','MPL','AP',590); select * from products; insert into products values (default,'Appliances-Fans',30,5.30), (default,'Appliances-Kettles',35,4.63);
Read more

SQL Queries

-
Hello guys! Today, I practiced SQL Queries in  SQLZoo SELECT SUM(population) FROM world SELECT DISTINCT(continent) FROM world SELECT SUM(gdp) FROM world WHERE continent='Africa' SELECT COUNT(name) FROM world WHERE area>=1000000 SELECT SUM(population) FROM world WHERE name IN('Estonia', 'Latvia', 'Lithuania') SELECT continent,COUNT(name) FROM world GROUP BY continent SELECT continent,COUNT(name) FROM world WHERE population>=10000000 GROUP BY continent SELECT continent FROM world GROUP BY continent HAVING SUM(population)>=100000000
Read more