google play store的app数据分析

google play store app数据源 提取码: 38jk

google play store的app数据分析

1. 加载数据

• 加载数据分析使用的库
• 加载数据前，先用文本编辑器简单浏览一下数据
• 加载好数据之后，第一步先分别使用shape、head、count、describe和info方法看下数据

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

# 加载文件 
# 这次只分析'App', 'Category', 'Rating', 'Reviews', 'Size', 'Installs', 'Type'
df = pd.read_csv('./googleplaystore.csv', usecols=(0, 1, 2, 3, 4, 5, 6))

# 简单浏览下数据
print(df.head())
# 查看行列数量
print(df.shape)
# 查看各个列的非空数量
print(df.count())

# 使用describe和info方法看下数据的大概分布
print(df.describe())
print(df.info())

                                           App        Category  Rating  \
0     Photo Editor & Candy Camera & Grid & ScrapBook  ART_AND_DESIGN     4.1   
1                                Coloring book moana  ART_AND_DESIGN     3.9   
2  U Launcher Lite – FREE Live Cool Themes, Hide ...  ART_AND_DESIGN     4.7   
3                              Sketch - Draw & Paint  ART_AND_DESIGN     4.5   
4              Pixel Draw - Number Art Coloring Book  ART_AND_DESIGN     4.3   

  Reviews  Size     Installs  Type  
0     159   19M      10,000+  Free  
1     967   14M     500,000+  Free  
2   87510  8.7M   5,000,000+  Free  
3  215644   25M  50,000,000+  Free  
4     967  2.8M     100,000+  Free  
(10841, 7)
App         10841
Category    10841
Rating       9367
Reviews     10841
Size        10841
Installs    10841
Type        10840
dtype: int64
            Rating
count  9367.000000
mean      4.193338
std       0.537431
min       1.000000
25%       4.000000
50%       4.300000
75%       4.500000
max      19.000000
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 10841 entries, 0 to 10840
Data columns (total 7 columns):
App         10841 non-null object
Category    10841 non-null object
Rating      9367 non-null float64
Reviews     10841 non-null object
Size        10841 non-null object
Installs    10841 non-null object
Type        10840 non-null object
dtypes: float64(1), object(6)
memory usage: 592.9+ KB
None

• 从上面的运行结果得出
• 数据一共有10841行
• Rating和Type数据有缺失
• Rating有一个19的异常值
• Size的‘M’和‘k’和Installs的‘+’都需要处理，方便进一步计算

2. 数据清洗 # App

• 查看有没有重复值

print(df['App'].unique().size)

9660

• 有重复值，先不着急删除，为了不把其他列的异常值留下，先处理数值异常的列

3. 数据清洗 # Categoery

print(df['Category'].value_counts(dropna=False))
print(df[df['Category'] == '1.9'])

FAMILY                 1972
GAME                   1144
TOOLS                   843
MEDICAL                 463
BUSINESS                460
PRODUCTIVITY            424
PERSONALIZATION         392
COMMUNICATION           387
SPORTS                  384
LIFESTYLE               382
FINANCE                 366
HEALTH_AND_FITNESS      341
PHOTOGRAPHY             335
SOCIAL                  295
NEWS_AND_MAGAZINES      283
SHOPPING                260
TRAVEL_AND_LOCAL        258
DATING                  234
BOOKS_AND_REFERENCE     231
VIDEO_PLAYERS           175
EDUCATION               156
ENTERTAINMENT           149
MAPS_AND_NAVIGATION     137
FOOD_AND_DRINK          127
HOUSE_AND_HOME           88
AUTO_AND_VEHICLES        85
LIBRARIES_AND_DEMO       85
WEATHER                  82
ART_AND_DESIGN           65
EVENTS                   64
COMICS                   60
PARENTING                60
BEAUTY                   53
1.9                       1
Name: Category, dtype: int64
                                           App Category  Rating Reviews  \
10472  Life Made WI-Fi Touchscreen Photo Frame      1.9    19.0    3.0M   

         Size Installs Type  
10472  1,000+     Free    0  

• 有一条异常值，观察发现应该是Category值缺失，所以这里删除这条数据

df.drop(index=10472, inplace=True)

4. 数据清洗 # Rating

print(df['Rating'].value_counts(dropna=False))

NaN     1474
4.4     1109
4.3     1076
4.5     1038
4.2      952
4.6      823
4.1      708
4.0      568
4.7      499
3.9      386
3.8      303
5.0      274
3.7      239
4.8      234
3.6      174
3.5      163
3.4      128
3.3      102
4.9       87
3.0       83
3.1       69
3.2       64
2.9       45
2.8       42
2.6       25
2.7       25
2.5       21
2.3       20
2.4       19
1.0       16
2.2       14
1.9       13
2.0       12
1.8        8
1.7        8
2.1        8
1.6        4
1.5        3
1.4        3
1.2        1
Name: Rating, dtype: int64

• 一共有1474条NaN值，用平均值来填充

df['Rating'].fillna(value=df['Rating'].mean(), inplace=True)

5. 数据清洗 # Reviews

print(df['Rating'].value_counts(dropna=False))
print(df['Reviews'].str.isnumeric().sum())

4.193338     1474
4.400000     1109
4.300000     1076
4.500000     1038
4.200000      952
4.600000      823
4.100000      708
4.000000      568
4.700000      499
3.900000      386
3.800000      303
5.000000      274
3.700000      239
4.800000      234
3.600000      174
3.500000      163
3.400000      128
3.300000      102
4.900000       87
3.000000       83
3.100000       69
3.200000       64
2.900000       45
2.800000       42
2.700000       25
2.600000       25
2.500000       21
2.300000       20
2.400000       19
1.000000       16
2.200000       14
1.900000       13
2.000000       12
2.100000        8
1.800000        8
1.700000        8
1.600000        4
1.400000        3
1.500000        3
1.200000        1
Name: Ratin