search

caiwang / board2ihost

0 stars 0 forks source link

[CLOSED] 频次-时长交叉分析2: 频次-时长权重分布图 #22

Open caiwang opened 9 years ago

caiwang commented 9 years ago

Issue by unissoft-bj Saturday Jan 24, 2015 at 11:11 GMT Originally opened as https://github.com/caiwang/ihostsrc/issues/22

echo "select tbldura.mac,if(tbldura.durabyh<=3600,tbldura.durabyh,'1h+') as dura,tblfreq.freq, tbldura.timebyweek,tbldura.sender,tbldura.netid from z_weekdurabyh as tbldura INNER JOIN z_weekfreq as tblfreq on tbldura.mac=tblfreq.mac and tbldura.sender=tblfreq.sender and tbldura.netid=tblfreq.netid where (tbldura.durabyh='100' or tbldura.durabyh='200' or tbldura.durabyh>3600) and tbldura.netid='ihost-xx';" | mysql -uroot -p0ffs4t? wlsp > weekmac-dura-freq-2.txt

caiwang commented 9 years ago

Comment by unissoft-bj Saturday Jan 24, 2015 at 11:14 GMT

频次-时长组合在总时长上的权重

image

caiwang commented 9 years ago

Comment by unissoft-bj Saturday Jan 24, 2015 at 11:15 GMT

频次-时长组合在总次数上的权重

image

caiwang commented 9 years ago

Comment by unissoft-bj Saturday Jan 24, 2015 at 11:19 GMT

直方图（分层-汇总）

dura=100 image

dura=200 image

dura=1h+ image

汇总 image

caiwang commented 9 years ago

Comment by unissoft-bj Saturday Jan 24, 2015 at 11:20 GMT

直方图(反向)

image

caiwang commented 9 years ago

Comment by unissoft-bj Sunday Jan 25, 2015 at 10:35 GMT

散点图

系列为停留时间second，横坐标是出现的频次，纵坐标是该频次的人次 image