网站的日志数据记录了所有Web对服务器的访问活动,本节通过Python第三方库解析网站日志,利用pandas对网站日志数据进行预处理,并用可视化技术,对于网站日志数据进行分析。
1
数据来源
import numpy as npimport pandas as pdimport matplotlib.pyplot as pltimport apache_log_parser # 首先通过 pip install apache_log_parser 安装库%matplotlib inline
fformat = '%V %h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\" %T' # 创建解析器p = apache_log_parser.make_parser(fformat)
sample_string = 'koldunov.net 85.26.235.202 - - [16/Mar/2013:00:19:43 +0400] "GET /?p=364 HTTP/1.0" 200 65237 "http://koldunov.net/?p=364" "Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.64 Safari/537.11" 0'data = p(sample_string) #解析后的数据为字典结构data
datas = open(r'H:\python数据分析\数据\apache_access_log').readlines() #逐行读取log数据log_list = [] # 逐行读取并解析为字典for line in datas:data = p(line)data['time_received'] = data['time_received'][1:12]+' '+data['time_received'][13:21]+' '+data['ti