Project-2-Google-Play-store-data-analysis.-

Different Apps Rating, Reviews, Size, Installs., Type, Price, Content Rating,, Genre's analysis.

Total number of App contain astrology

df1['App'].unique()

array(['Photo Editor & Candy Camera & Grid & ScrapBook', 'Coloring book moana', 'U Launcher Lite – FREE Live Cool Themes, Hide Apps', ..., 'Parkinson Exercices FR', 'The SCP Foundation DB fr nn5n', 'iHoroscope - 2018 Daily Horoscope & Astrology'], dtype=object)

Number of app contain astrology = 3

Average rating of Apps = 4.193338315362443

Number of unique categories = 34

Category getting highest average rating

Highest average rating based category = Category

1.9 19.000000 EVENTS 4.435556 EDUCATION 4.389032 ART_AND_DESIGN 4.358065 BOOKS_AND_REFERENCE 4.346067 PERSONALIZATION 4.335987 PARENTING 4.300000 GAME 4.286326 BEAUTY 4.278571 HEALTH_AND_FITNESS 4.277104 SHOPPING 4.259664 SOCIAL 4.255598 WEATHER 4.244000 SPORTS 4.223511 PRODUCTIVITY 4.211396 HOUSE_AND_HOME 4.197368 FAMILY 4.192272 PHOTOGRAPHY 4.192114 AUTO_AND_VEHICLES 4.190411 MEDICAL 4.189143 LIBRARIES_AND_DEMO 4.178462 FOOD_AND_DRINK 4.166972 COMMUNICATION 4.158537 COMICS 4.155172 NEWS_AND_MAGAZINES 4.132189 FINANCE 4.131889 ENTERTAINMENT 4.126174 BUSINESS 4.121452 TRAVEL_AND_LOCAL 4.109292 LIFESTYLE 4.094904 VIDEO_PLAYERS 4.063750 MAPS_AND_NAVIGATION 4.051613 TOOLS 4.047411 DATING 3.970769

Total number of Apps have 5 star rating

Number of apps have 5 star 274

Average reviews = 444112

number of free apps = 10039

number of free apps = 800

App has maximum reviews = Facebook

Display Top 5 Apps having highest review Facebook

1. Facebook

2. Facebook

3. WhatsApp Messenger

4. WhatsApp Messenger

5. WhatsApp Messenger

averge rating of free and paid Apps = 4.186203 and 4.266615

Top 5 Apps having maximum installation

1. Subway Surfers

2. Facebook

3. Messenger – Text and Video Chat for Free

4. Google Drive

5. Google Drive

Top 5 Apps having maximum "Rating"

1. February 11, 2018

2. Entertainment

3. Sports