用python进行简单的处理和绘图分析-上网用户群体分析

某个网站/服务器上，请求链接的用户信息。资料集中有电脑类型、浏览器链接等。用python进行简单的处理和绘图分析。

资料集链接

# INPUT uses python 3.6 
import json
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np

path = 'usagov_bitly_data2012-03-16-1331923249.txt'
records = [json.loads(line) for line in open(path)]
frame = pd.DataFrame(records)
results = pd.Series([x.split()[0] for x in frame.a.dropna()])
# print(results[:5])
cframe = frame[frame.a.notnull()]

operating_systems = np.where(cframe['a'].str.contains('Windows'),
                             'Windows','Not Windows')

by_tz_os = cframe.groupby(['tz',operating_systems])
agg_counts = by_tz_os.size().unstack().fillna(0)

indexer = agg_counts.sum(1).argsort()

count_subset = agg_counts.take(indexer)[-10:]


normed_subset = count_subset.div(count_subset.sum(1),axis = 0)
normed_subset.plot(kind='barh',stacked = True)
plt.show()

# OUT 
                     Not Windows  Windows
tz                                       
America/Sao_Paulo           13.0     20.0
Europe/Madrid               16.0     19.0
Pacific/Honolulu             0.0     36.0
Asia/Tokyo                   2.0     35.0
Europe/London               43.0     31.0
America/Denver             132.0     59.0
America/Los_Angeles        130.0    252.0
America/Chicago            115.0    285.0
                           245.0    276.0
America/New_York           339.0    912.0

operating_char.png

2018.7.16

学习笔记《用python进行数据分析》,非原创，仅作学习存档用途。 在草稿箱放太久有点忘了。