Report on the Apps in the Google Play Store
Introduction
This report provides an analysis of the apps available on the Google Play Store based on a dataset containing 10,841 entries. The dataset includes various attributes such as app name, category, rating, reviews, size, installs, type, price, content rating, genres, last updated date, current version, and Android version. The analysis focuses on several key aspects, including data cleaning, distribution of apps across categories, app ratings, pricing strategies, user engagement, content ratings, and trends over time.
Data Cleaning
Handling Missing Values and Anomalies
The dataset initially contained missing values and anomalies, particularly in the 'Rating' column, where the maximum rating was 19, which is outside the typical range of 1.0 to 5.0. The following steps were taken to clean the data:
- Imputing Missing Values: Missing values in the columns 'Rating', 'Type', 'Content Rating', 'Current Ver', and 'Android Ver' were imputed.
- Correcting Rating Values: Anomalies in the 'Rating' column were corrected to ensure all ratings fall within the range of 1.0 to 5.0.
After cleaning, the dataset was ready for further analysis.
Distribution of Apps Across Categories
The distribution of apps across different categories is as follows:
App Ratings Analysis
Distribution of App Ratings
Percentage of Apps in Each Rating Bracket
- Rating 1-2: 0.73%
- Rating 2-3: 3.22%
- Rating 3-4: 23.41%
- Rating 4-5: 72.64%
Pricing Strategies
Number of Free vs. Paid Apps
| Type | Count |
|---|---|
| Free | 10039 |
| Paid | 800 |
Content Ratings
Distribution of Apps Based on Content Rating
Conclusion
The analysis of the Google Play Store apps dataset reveals several key insights:
- Data Cleaning: Missing values and anomalies were addressed to ensure data quality.
- App Distribution: The 'FAMILY' category has the highest number of apps, followed by 'GAME' and 'TOOLS'.
- App Ratings: Most apps have ratings between 4.0 and 5.0, with a significant percentage of apps rated between 4.0 and 4.5.
- Pricing Strategies: The majority of apps are free, and there is no linear correlation between app price and ratings.
- User Engagement: The average number of reviews per app is high, but there is no linear relationship between installs and reviews.
- Content Ratings: Apps with a 'Teen' content rating are more popular and receive higher user ratings.
- Trends Over Time: App ratings and installs have generally increased over the years, indicating growth in the app market.
These insights provide a comprehensive understanding of the app landscape on the Google Play Store, highlighting trends, user engagement, and the impact of content ratings on app popularity and user satisfaction.