数据清洗的方法
发布网友
发布时间：2022-04-24 06:26
共2个回答
懂视网
时间：2022-04-11 05:53
ip: 199.30.25.88
time: 10/Nov/2016:00:01:03 +0800
traffic: 62
文章： article/11325
视频： video/3235
（2）第二阶段：根据提取出来的信息做精细化操作
ip--->城市 city（IP）
date--> time:2016-11-10 00:01:03
day: 10
traffic:62
type:article/video
id:11325
（3）hive数据库表结构:
create table data( ip string, time string , day string, traffic bigint,
type string, id string )
由于对MapReduce不熟练就先使用了用java清洗，MapReduce清洗的方法将会在以后发出来。
对数据进行清洗：
package mapreduceShiYan;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.UnsupportedEncodingException;
import java.io.Writer;
public class Data {
public static void main(String[] args) throws FileNotFoundException, UnsupportedEncodingException {
FileReader read = new FileReader("result.txt");
BufferedReader br = new BufferedReader(read);
Writer writer = null;
File outFile = new File("result2.txt");
writer = new OutputStreamWriter(new FileOutputStream(outFile),"utf-8");
BufferedWriter bw = new BufferedWriter(writer);
String row;
String[] data=new String[6];
int hang=1;
try {
while((row = br.readLine())!=null){
data=change(row);
data=chage(data);
for(int i=0;i<data.length;i++) {
System.out.print(data[i]+" ");
}
System.out.println();
row=data[0]+","+data[1]+","+data[2]+","+data[3]+","+data[4]+","+data[5];
bw.write(row + "
");
//i++;
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
private static String[] chage(String[] data) {
/*
* for(int i=0;i<data.length;i++) { data[] }
*/
data[0]=data[0];
char[] str=data[1].toCharArray();
String[] time=new String[7];
int j=0;
int k=0;
for(int i=0;i<str.length;i++) {
if(str[i]==‘/‘||str[i]==‘:‘||str[i]==32) {
time[k]=data[1].substring(j,i);
j=i+1;
k++;
}
}
time[k]=data[1].substring(j, data[1].length());
switch(time[1]) { case "Jan":time[1]="01";break; case
"Feb":time[1]="02";break; case "Mar":time[1]="03";break; case
"Apr":time[1]="04";break; case "May":time[1]="05";break; case
"Jun":time[1]="06";break; case "Jul":time[1]="07";break; case
"Aug":time[1]="08";break; case "Sep":time[1]="09";break; case
"Oct":time[1]="10";break; case "Nov":time[1]="11";break; case
"Dec":time[1]="12";break; }
data[1]=time[2]+"-"+time[1]+"-"+time[0]+" "+time[3]+":"+time[4]+":"+time[5];
data[3]=data[3].substring(0, data[3].length()-1);
return data;
}
private static String [] change(String row) {
char [] str1=row.toCharArray();
String [] data =new String [6];
int j=0;
int k=0;
for(int i=0;i<str1.length;i++) {
if(str1[i]==‘,‘) {
data[k]=row.substring(j, i);
j=i+1;
k++;
}
}
data[k]=row.substring(j, str1.length);
return data;
}
}
通过JDBC上传到hive:
package mapreduceShiYan;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.apache.hadoop.io.Text;
import org.apache.log4j.Logger;
public class Data1 {
private static String driverName = "org.apache.hive.jdbc.HiveDriver";
private static String url = "jdbc:hive2://192.168.137.67:10000/hive";//远程连接虚拟机，则填写虚拟机ip，如果在虚拟机中则是localhost
private static String user = "hive";//hive—site.xml中配置的用户名
private static String password = "password";//hive—site.xml中配置的密码
private static String sql;
//private static ResultSet res;
private static final Logger log = Logger.getLogger(Text.class);
public static void main(String[] args) {
try {
Class.forName(driverName);
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement();
sql = "load data local inpath ‘/home/hadoop/result2.txt‘ overwrite into table data";//虚拟机中的本地文件
System.out.println("Running:" + sql);
boolean f=stmt.execute(sql);
System.out.println( sql);
System.out.println("result:" + f);
conn.close();
conn = null;
} catch (ClassNotFoundException e) {
e.printStackTrace();
log.error(driverName + " not found!", e);
System.exit(1);
} catch (SQLException e) {
e.printStackTrace();
log.error("Connection error!", e);
System.exit(1);
}
}
}
本人在折腾了一天后遇到的一些问题：
1. java.lang.ClassNotFoundException: org.apachehive.jdbc.HiveDriver
不论是在虚拟机还是windows中进行操作，千万别忘记导入需要的包。解决方法：导入hive文件目录下lib文件夹中的hive开头所有包（可能只需要几个，但是本人为了课上节省时间导入了全部的hive开头的包）
2.java.net.ConnectException: Connection refused 这是由于远程hive集群没有启动hiveserver2导致的。 要切换到/usr/local/hive 然后运行 ./bin/hive --service hiveserver2 成功后运行netstat -tunlp |grep 10000查看端口情况，若有则启动成功。 3.User: hadoop is not allowed to impersonate hive修改hadoop 配置文件 etc/hadoop/core-site.xml,加入如下配置项
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
hadoop.proxyuser.root.hosts配置项名称中root部分为报错User:* 中的用户名部分
我的报错是hadoop,所有我改成：
<property> <name>hadoop.proxyuser.hadoop.hosts</name> <value>*</value> </property> <property> <name>hadoop.proxyuser.hadoop.groups</name> <value>*</value> </property>hive Permission denied: user=root, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x
4.
解决办法
hdfs dfs命令对文件夹下的文件赋予权限
hadoop dfs -chmod -R 777 /warehouse/tablespace/managed/hive/datacenter.db（报错的路径）
5.操作hive 报错FAILED:HiveException java.lang.RuntimeException:Unable to instantiate org.ap.......
很多错误会导致这个，本人的原因在1、所有数据库的所有表的所有权限赋给hive用户中的连接密码和hive-site.xml中的密码不一致
2、hive-site.xml中的localhost改成127.0.0.1
6.hive 1.2.1版本不支持hadoop过高的版本，本人的是3.2.0
文件：
106.39.41.166,2016-11-10 00:01:02,10,54,video,8701
113.140.11.123,2016-11-10 00:01:02,10,54,video,5915
125.122.216.102,2016-11-10 00:01:02,10,54,video,9819
116.231.219.242,2016-11-10 00:01:02,10,54,video,6335
61.136.143.62,2016-11-10 00:01:02,10,54,video,7629
39.186.247.142,2016-11-10 00:01:02,10,2957,video,3237
59.42.206.247,2016-11-10 00:01:02,10,54,video,7053
39.186.247.142,2016-11-10 00:01:02,10,66,video,3237
61.135.172.68,2016-11-10 00:01:02,10,67,video,3510
45.115.145.45,2016-11-10 00:01:02,10,67,video,13265
61.149.133.159,2016-11-10 00:01:02,10,54,video,13182
180.160.212.7,2016-11-10 00:01:02,10,54,video,2665
125.90.48.103,2016-11-10 00:01:02,10,54,video,7311
106.187.95.195,2016-11-10 00:01:02,10,54,video,5685
39.186.247.142,2016-11-10 00:01:02,10,317,video,3237
220.191.6.44,2016-11-10 00:01:02,10,72,video,1101
39.186.247.142,2016-11-10 00:01:02,10,4860,video,3237
61.142.10.231,2016-11-10 00:01:02,10,67,video,12551
27.17.35.94,2016-11-10 00:01:02,10,54,video,1412
120.198.231.154,2016-11-10 00:01:03,10,54,video,9817
113.93.90.94,2016-11-10 00:01:03,10,54,video,7475
114.249.93.42,2016-11-10 00:01:03,10,67,video,3221
171.8.152.203,2016-11-10 00:01:03,10,54,video,5914
199.30.25.88,2016-11-10 00:01:03,10,271,article,11325
199.30.25.88,2016-11-10 00:01:03,10,62,article,11325
39.186.247.142,2016-11-10 00:01:03,10,2311,video,3237
222.168.40.31,2016-11-10 00:01:03,10,54,video,2452
39.186.247.142,2016-11-10 00:01:03,10,307,video,3237
58.241.76.18,2016-11-10 00:01:03,10,2957,video,3235
49.81.162.183,2016-11-10 00:01:03,10,141,video,1816
125.94.93.221,2016-11-10 00:01:03,10,54,video,4441
101.200.101.201,2016-11-10 00:01:03,10,4468,article,4779
39.186.247.142,2016-11-10 00:01:03,10,951,video,3237
101.200.101.21,2016-11-10 00:01:03,10,524288,video,10506
58.241.76.18,2016-11-10 00:01:03,10,66,video,3235
101.200.101.21,2016-11-10 00:01:03,10,524288,video,10506
67.82..254,2016-11-10 00:01:03,10,54,video,2875
39.186.247.142,2016-11-10 00:01:03,10,72,video,3237
117.100.106.26,2016-11-10 00:01:03,10,54,video,4908
113.91.162.210,2016-11-10 00:01:03,10,54,video,10506
58.241.76.18,2016-11-10 00:01:03,10,951,video,3235
58.241.76.18,2016-11-10 00:01:03,10,5234,video,3235
139.211.44.77,2016-11-10 00:01:03,10,54,video,4848
39.186.247.142,2016-11-10 00:01:03,10,7227,video,3237
111.172.46.191,2016-11-10 00:01:04,10,67,video,3069
60.21.206.184,2016-11-10 00:01:04,10,67,video,6228
39.186.247.142,2016-11-10 00:01:04,10,4496,video,3237
39.186.247.142,2016-11-10 00:01:04,10,317,video,3237
112..61.203,2016-11-10 00:01:04,10,54,video,12532
222.171.107.65,2016-11-10 00:01:04,10,54,video,6837
183.60.162.108,2016-11-10 00:01:04,10,54,video,13168
171.214.155.3,2016-11-10 00:01:04,10,67,video,7558
39.186.247.142,2016-11-10 00:01:04,10,1092,video,3237
14.219.24.67,2016-11-10 00:01:04,10,54,video,773
115.195.60.166,2016-11-10 00:01:04,10,54,video,2769
175.20.94.66,2016-11-10 00:01:04,10,54,video,12299
101.81.42.203,2016-11-10 00:01:04,10,54,video,4017
60.191.47.90,2016-11-10 00:01:04,10,54,video,36
114.249.202.36,2016-11-10 00:01:04,10,54,video,13330
120.198.231.150,2016-11-10 00:01:04,10,54,video,774
58.241.76.18,2016-11-10 00:01:04,10,95,video,3235
115.193.172.253,2016-11-10 00:01:04,10,67,video,2858
183.128.1.83,2016-11-10 00:01:04,10,67,video,12299
118.250.42.145,2016-11-10 00:01:04,10,67,video,11307
175.10.104.158,2016-11-10 00:01:04,10,54,video,3217
110.53.175.199,2016-11-10 00:01:04,10,54,video,8469
106.37.127.231,2016-11-10 00:01:04,10,2195,video,8199
171.216.125.79,2016-11-10 00:01:04,10,54,video,5219
115.193.172.253,2016-11-10 00:01:04,10,65,video,2858
106.37.127.231,2016-11-10 00:01:04,10,349,video,8199
182.100.18.242,2016-11-10 00:01:05,10,54,video,95
125.122.198.123,2016-11-10 00:01:05,10,54,video,107
199.30.25.88,2016-11-10 00:01:05,10,5994,article,11325
115.193.172.253,2016-11-10 00:01:05,10,2961,video,3078
119.122.183.,2016-11-10 00:01:05,10,7226,video,3244
140.207.97.98,2016-11-10 00:01:05,10,68,video,10936
183.128.1.83,2016-11-10 00:01:05,10,67,video,953
106.37.127.231,2016-11-10 00:01:05,10,1355,video,8199
116.23.248.47,2016-11-10 00:01:05,10,54,video,1034
111.112.84.51,2016-11-10 00:01:05,10,54,video,6843
115.193.172.253,2016-11-10 00:01:05,10,362,video,3078
106.37.127.231,2016-11-10 00:01:05,10,72,video,8199
117.135.159.4,2016-11-10 00:01:05,10,68,video,353
117.173.0.113,2016-11-10 00:01:05,10,2956,video,8135
211.162.33.107,2016-11-10 00:01:05,10,54,video,9815
106.37.127.231,2016-11-10 00:01:05,10,74,video,8199
116.23.155.253,2016-11-10 00:01:05,10,54,video,9661
106.37.127.231,2016-11-10 00:01:05,10,66,video,8199
115.193.172.253,2016-11-10 00:01:05,10,945,video,3078
112.65.57.88,2016-11-10 00:01:05,10,54,video,9593
117.173.0.113,2016-11-10 00:01:05,10,348,video,8135
58.20.14.170,2016-11-10 00:01:05,10,67,video,5682
113.139.190.95,2016-11-10 00:01:05,10,67,video,9832
119.122.183.,2016-11-10 00:01:05,10,7226,video,3244
125.122.2.73,2016-11-10 00:01:05,10,54,video,243
106.37.127.231,2016-11-10 00:01:05,10,306,video,8199
117.173.0.113,2016-11-10 00:01:05,10,66,video,8135
115.193.172.253,2016-11-10 00:01:05,10,2345,video,3078
14.145.74.175,2016-11-10 00:01:05,10,72,video,678
115.193.172.253,2016-11-10 00:01:05,10,221,video,3078
115.193.172.253,2016-11-10 00:01:05,10,4042,video,3078
106.37.127.231,2016-11-10 00:01:05,10,3427,video,8199
122.206.190.75,2016-11-10 00:01:05,10,54,video,7707
115.193.172.253,2016-11-10 00:01:05,10,66,video,3078
110.65.101.188,2016-11-10 00:01:05,10,54,video,11786
58.20.14.170,2016-11-10 00:01:05,10,17,video,5682
1.194.187.2,2016-11-10 00:01:05,10,54,video,2212
119.124.1.57,2016-11-10 00:01:05,10,54,video,4320
106.37.127.231,2016-11-10 00:01:05,10,3280,video,8199
58.20.14.170,2016-11-10 00:01:05,10,2957,video,5683
223.72..88,2016-11-10 00:01:05,10,67,video,2139
117.173.0.113,2016-11-10 00:01:05,10,1161,video,8135
115.193.172.253,2016-11-10 00:01:06,10,1801,video,3078
122.234.60.39,2016-11-10 00:01:06,10,6398,video,8837
117.173.0.113,2016-11-10 00:01:06,10,4882,video,8135
115.193.172.253,2016-11-10 00:01:06,10,362,video,3078
106.37.127.231,2016-11-10 00:01:06,10,302,video,8199
117.173.0.113,2016-11-10 00:01:06,10,16776,video,8135
115.193.172.253,2016-11-10 00:01:06,10,72,video,3078
14.154.180.16,2016-11-10 00:01:06,10,54,video,9886
49.4.156.97,2016-11-10 00:01:06,10,54,video,5914
101.81.50.177,2016-11-10 00:01:06,10,54,video,828
223.104.25.65,2016-11-10 00:01:06,10,54,video,9101
58.20.14.170,2016-11-10 00:01:06,10,347,video,5683
117.173.0.113,2016-11-10 00:01:06,10,305,video,8135
116.22.196.231,2016-11-10 00:01:06,10,54,video,6711
58.20.14.170,2016-11-10 00:01:06,10,66,video,5683
101.200.101.13,2016-11-10 00:01:06,10,524288,video,11938
106.37.127.231,2016-11-10 00:01:06,10,12,video,8199
115.193.172.253,2016-11-10 00:01:06,10,395,video,3078
101.200.101.9,2016-11-10 00:01:06,10,524288,video,6139
58.20.14.170,2016-11-10 00:01:06,10,1201,video,5683
120.27.173.217,2016-11-10 00:01:06,10,4468,article,1167
220.191.6.44,2016-11-10 00:01:06,10,6323,video,1101
117.173.0.113,2016-11-10 00:01:06,10,72,video,8135
101.200.101.13,2016-11-10 00:01:06,10,524288,video,11938
112.5.237.224,2016-11-10 00:01:06,10,54,video,12478
106.37.127.231,2016-11-10 00:01:06,10,72,video,8199
115.193.172.253,2016-11-10 00:01:06,10,4496,video,3078
117.1.191.130,2016-11-10 00:01:06,10,54,video,6556
49.81.162.183,2016-11-10 00:01:06,10,67,video,1816
115.183.25.238,2016-11-10 00:01:06,10,54,video,5139
124..76.206,2016-11-10 00:01:06,10,54,video,3475
120.198.231.152,2016-11-10 00:01:06,10,54,video,8652
180.102.115.191,2016-11-10 00:01:06,10,54,video,10077
117.173.0.113,2016-11-10 00:01:06,10,2614,video,8135
223.93.140.242,2016-11-10 00:01:07,10,67,video,2147
115.193.172.253,2016-11-10 00:01:07,10,301,video,3078
113.105.128.252,2016-11-10 00:01:07,10,54,video,1671
117.173.0.113,2016-11-10 00:01:07,10,6784,video,8135
42.243.125.117,2016-11-10 00:01:07,10,54,video,88
117.173.0.113,2016-11-10 00:01:07,10,572,video,8135
106.37.127.231,2016-11-10 00:01:07,10,12,video,8199
112.87.108.52,2016-11-10 00:01:07,10,54,video,8671
120.85.202.68,2016-11-10 00:01:07,10,54,video,3096
115.193.172.253,2016-11-10 00:01:07,10,65,video,3078
117.173.0.113,2016-11-10 00:01:07,10,72,video,8135
115.193.172.253,2016-11-10 00:01:07,10,72,video,3078
218.75.34.250,2016-11-10 00:01:07,10,54,video,9103
115.193.172.253,2016-11-10 00:01:07,10,65,video,3078
58.20.14.170,2016-11-10 00:01:07,10,5485,video,5683
175.9.181.138,2016-11-10 00:01:07,10,67,video,2877
58.20.14.170,2016-11-10 00:01:07,10,72,video,5683
58.20.14.170,2016-11-10 00:01:08,10,3561,video,5683
114.42.37.247,2016-11-10 00:01:08,10,54,video,92
14.145.74.175,2016-11-10 00:01:08,10,72,video,678
36.46.203.138,2016-11-10 00:01:08,10,54,video,2633
58.20.14.170,2016-11-10 00:01:08,10,2230,video,5683
101.200.101.207,2016-11-10 00:01:08,10,4468,article,11325
58.20.14.170,2016-11-10 00:01:08,10,2195,video,5683
58.20.14.170,2016-11-10 00:01:08,10,3388,video,5683
124.225.62.61,2016-11-10 00:01:08,10,54,video,9704
117.173.0.113,2016-11-10 00:01:08,10,6784,video,8135
121.33.168.58,2016-11-10 00:01:08,10,67,video,1803
58.20.14.170,2016-11-10 00:01:08,10,324,video,5683
222.70.27.27,2016-11-10 00:01:08,10,67,video,4877
58.20.14.170,2016-11-10 00:01:08,10,347,video,5683
58.20.14.170,2016-11-10 00:01:08,10,348,video,5683
106.37.127.231,2016-11-10 00:01:08,10,72,video,8199
111.201.78.80,2016-11-10 00:01:08,10,54,video,2544
119.139.136.103,2016-11-10 00:01:08,10,54,video,4831
61.51.82.242,2016-11-10 00:01:09,10,67,video,8792
120.85.77.238,2016-11-10 00:01:09,10,54,video,7624
113.200.27.28,2016-11-10 00:01:09,10,54,video,2427
61.242.42.35,2016-11-10 00:01:09,10,54,video,4736
211.97.105.190,2016-11-10 00:01:09,10,141,video,13003
49.52.99.46,2016-11-10 00:01:09,10,54,video,2168
106.120.213.44,2016-11-10 00:01:09,10,54,video,7533
121.35.180.159,2016-11-10 00:01:09,10,54,video,9808
119.131.106.128,2016-11-10 00:01:09,10,54,video,8378
180.170.100.94,2016-11-10 00:01:09,10,67,video,1412
59.42.128.119,2016-11-10 00:01:09,10,54,video,5539
218.106.145.12,2016-11-10 00:01:09,10,67,video,9447
183.166.10.212,2016-11-10 00:01:09,10,54,video,5867
121.69.41.98,2016-11-10 00:01:09,10,54,video,2710
211.157.1.39,2016-11-10 00:01:09,10,54,video,1667
115.198.204.33,2016-11-10 00:01:10,10,54,video,2929
180.156.241.168,2016-11-10 00:01:10,10,54,video,3208
39.182..209,2016-11-10 00:01:10,10,54,video,3221
218.76.42.130,2016-11-10 00:01:10,10,54,video,11561
183.157.162.62,2016-11-10 00:01:10,10,54,video,9319
218.17.207.61,2016-11-10 00:01:10,10,54,video,8711
122.233.75.87,2016-11-10 00:01:10,10,54,video,5475
101.200.101.204,2016-11-10 00:01:10,10,4468,article,11325
183.39.154.199,2016-11-10 00:01:10,10,141,video,13097
122.96.31.8,2016-11-10 00:01:10,10,54,video,13097
182.150.161.68,2016-11-10 00:01:10,10,54,video,3725
117.174.26.224,2016-11-10 00:01:10,10,54,video,4525
59.172.176.158,2016-11-10 00:01:10,10,67,video,4030
221.221.55.197,2016-11-10 00:01:11,10,54,video,3734
39.186.247.142,2016-11-10 00:01:11,10,72,video,3237
140.207.223.1,2016-11-10 00:01:11,10,54,video,13192
120.52.92.2,2016-11-10 00:01:11,10,67,video,12342
219.73.46.243,2016-11-10 00:01:11,10,54,video,4547
115.193.172.253,2016-11-10 00:01:11,10,65,video,3078
183.39.154.199,2016-11-10 00:01:11,10,67,video,13097
27.38.115.174,2016-11-10 00:01:11,10,54,video,4519
183.14.120.94,2016-11-10 00:01:11,10,54,video,12344
183.63.102.133,2016-11-10 00:01:11,10,54,video,5139
106.185.43.251,2016-11-10 00:01:11,10,54,video,11950
27.47.233.232,2016-11-10 00:01:11,10,54,video,8
110.52.221.73,2016-11-10 00:01:11,10,54,video,2212
112..61.162,2016-11-10 00:01:11,10,54,video,2872
222.210.3.220,2016-11-10 00:01:11,10,54,video,5986
121.33.48.151,2016-11-10 00:01:11,10,54,video,4932
36.110.49.98,2016-11-10 00:01:11,10,54,video,4188
183.17.254.1,2016-11-10 00:01:12,10,54,video,371
113.66.21.10,2016-11-10 00:01:12,10,54,video,11447
119.122.183.,2016-11-10 00:01:12,10,72,video,3244
1.84.205.195,2016-11-10 00:01:12,10,54,video,1412
222.74.205.119,2016-11-10 00:01:12,10,54,video,2316
122.234.60.39,2016-11-10 00:01:12,10,54,video,11549
113.204.170.2,2016-11-10 00:01:12,10,67,video,2163
220.181.38.111,2016-11-10 00:01:12,10,54,video,3735
218.6.242.42,2016-11-10 00:01:12,10,54,video,10694
123.117.40.2,2016-11-10 00:01:12,10,54,video,13311
183.17.235.181,2016-11-10 00:01:13,10,54,video,12466
118.26.11.9,2016-11-10 00:01:13,10,68,video,10688
112.192.207.41,2016-11-10 00:01:13,10,54,video,12302
58.20.14.170,2016-11-10 00:01:13,10,72,video,5683
125.124.158.86,2016-11-10 00:01:13,10,67,video,2863
116.3.7.232,2016-11-10 00:01:13,10,54,video,9028
116.231.194.12,2016-11-10 00:01:13,10,72,video,2469
139.196.128.78,2016-11-10 00:01:13,10,524288,video,9478
125.120.150.55,2016-11-10 00:01:13,10,67,video,9902
122.225.227.162,2016-11-10 00:01:13,10,54,video,10683
119.131.143.179,2016-11-10 00:01:13,10,141,video,2401
58.250.245.239,2016-11-10 00:01:13,10,54,video,10750
117.151.49.48,2016-11-10 00:01:13,10,54,video,3399
58.20.14.170,2016-11-10 00:01:13,10,17,video,5683
112.86.38.76,2016-11-10 00:01:13,10,54,video,2926
113.140.11.123,2016-11-10 00:01:13,10,54,video,1803
140.205.253.132,2016-11-10 00:01:13,10,524288,video,7557
58.243.193.233,2016-11-10 00:01:14,10,54,video,68
182.84.104.185,2016-11-10 00:01:14,10,54,video,5170
113.65.125.190,2016-11-10 00:01:14,10,54,video,8602
118.207.107.228,2016-11-10 00:01:14,10,67,video,4962
183.17.254.1,2016-11-10 00:01:14,10,6637,video,371
223.104.11.225,2016-11-10 00:01:14,10,54,video,8
183.6.25.202,2016-11-10 00:01:14,10,54,video,13044
124.78.41.245,2016-11-10 00:01:14,10,54,video,13010
210.30.193.153,2016-11-10 00:01:14,10,67,video,3521
218.18.125.103,2016-11-10 00:01:14,10,54,video,12344
59.63.249.151,2016-11-10 00:01:14,10,54,video,633
119.225.142.2,2016-11-10 00:01:14,10,54,video,4345
139.196.128.67,2016-11-10 00:01:14,10,524288,video,13109
125.94.93.221,2016-11-10 00:01:14,10,72,video,4441
113.66.254.162,2016-11-10 00:01:14,10,54,video,5915
120.41.28.17,2016-11-10 00:01:14,10,67,video,13277
1.192.25.84,2016-11-10 00:01:14,10,54,video,5551
119.136.147.91,2016-11-10 00:01:14,10,54,video,7740
113.120.48.150,2016-11-10 00:01:14,10,67,video,2869
116.236.162.66,2016-11-10 00:01:14,10,54,video,8880
139.196.128.67,2016-11-10 00:01:14,10,524288,video,13109
124.200.190.34,2016-11-10 00:01:15,10,54,video,9025
223.93.140.242,2016-11-10 00:01:15,10,67,video,9905
36.33.5.19,2016-11-10 00:01:15,10,54,video,12504
223.20.138.152,2016-11-10 00:01:15,10,54,video,1818
115.192.1.58,2016-11-10 00:01:15,10,54,video,9904
124.200.190.34,2016-11-10 00:01:15,10,67,video,9022
59.47.8.126,2016-11-10 00:01:15,10,54,video,4526
163.125.235.161,2016-11-10 00:01:15,10,54,video,11257
60.22.87.125,2016-11-10 00:01:15,10,72,video,1336
116.231.133.23,2016-11-10 00:01:15,10,67,video,11822
116.19.167.208,2016-11-10 00:01:15,10,54,video,7550
124.200.190.34,2016-11-10 00:01:15,10,67,video,9025
120.198.231.151,2016-11-10 00:01:15,10,54,video,2544
101.81.225.61,2016-11-10 00:01:15,10,54,video,12479
60.191.99.129,2016-11-10 00:01:15,10,54,video,6000
113.119.8.170,2016-11-10 00:01:15,10,54,video,11820
219.82.203.225,2016-11-10 00:01:15,10,54,video,2183
183.39.154.199,2016-11-10 00:01:15,10,67,video,13097
58.213.93.130,2016-11-10 00:01:15,10,67,video,775
183.39.154.199,2016-11-10 00:01:15,10,6195,video,13097
116.231.194.12,2016-11-10 00:01:15,10,54,video,2469
120.198.231.154,2016-11-10 00:01:15,10,54,video,902
120.193.5.12,2016-11-10 00:01:15,10,54,video,11620
14.106.225.10,2016-11-10 00:01:16,10,54,video,7623
106..87.107,2016-11-10 00:01:16,10,54,video,2523
113.71.152.167,2016-11-10 00:01:16,10,54,video,2492
112.86.205.25,2016-11-10 00:01:16,10,54,video,2499
49.4.161.46,2016-11-10 00:01:16,10,54,video,12396
218.88.46.108,2016-11-10 00:01:16,10,54,video,12576
122.191.204.232,2016-11-10 00:01:16,10,54,video,6074
183.39.154.199,2016-11-10 00:01:16,10,2959,video,13098
58.22.61.92,2016-11-10 00:01:16,10,54,video,3727
183.39.154.199,2016-11-10 00:01:16,10,348,video,13098
183.63.97.232,2016-11-10 00:01:16,10,54,video,7557
39.179.202.119,2016-11-10 00:01:16,10,67,video,1546
14.23.9.50,2016-11-10 00:01:16,10,54,video,5118
221.221.148.132,2016-11-10 00:01:16,10,1041,video,13153
128.250.0.113,2016-11-10 00:01:16,10,68,video,6584
110.179.148.54,2016-11-10 00:01:16,10,54,video,11698
183.39.154.199,2016-11-10 00:01:16,10,2027,video,13098
221.221.148.132,2016-11-10 00:01:16,10,3991,video,13153
58.60.6.23,2016-11-10 00:01:16,10,54,video,2257
210.30.100.2,2016-11-10 00:01:16,10,68,video,11551
183.39.154.199,2016-11-10 00:01:16,10,72,video,13098
111.0.200.141,2016-11-10 00:01:16,10,67,video,3400
183.228.49.158,2016-11-10 00:01:16,10,54,video,9633
183.39.154.199,2016-11-10 00:01:16,10,74,video,13098
221.221.148.132,2016-11-10 00:01:16,10,2700,video,13153
183.60.175.193,2016-11-10 00:01:16,10,54,video,1805
183.39.154.199,2016-11-10 00:01:16,10,348,video,13098
119.131.143.179,2016-11-10 00:01:16,10,67,video,2401
113.118.96.208,2016-11-10 00:01:16,10,54,video,9022
221.130.253.135,2016-11-10 00:01:16,10,67,video,12302
183.39.154.199,2016-11-10 00:01:17,10,2804,video,13098
119.131.143.179,2016-11-10 00:01:17,10,9035,video,2401
183.39.154.199,2016-11-10 00:01:17,10,324,video,13098
183.39.154.199,2016-11-10 00:01:17,10,185,video,13098
118.249.208.191,2016-11-10 00:01:17,10,85,video,12831
183.39.154.199,2016-11-10 00:01:17,10,106,video,13098
117.32.216.53,2016-11-10 00:01:17,10,54,video,3326
183.39.154.199,2016-11-10 00:01:17,10,6195,video,13098
183.39.154.199,2016-11-10 00:01:17,10,4941,video,13098
119.131.143.179,2016-11-10 00:01:17,10,2959,video,2402
183.16.11.146,2016-11-10 00:01:17,10,54,video,7226
183.24.141.90,2016-11-10 00:01:17,10,54,video,7214
183.39.154.199,2016-11-10 00:01:17,10,72,video,13098
119.131.143.179,2016-11-10 00:01:17,10,354,video,2402
118.249.208.191,2016-11-10 00:01:17,10,85,video,12831
183.39.154.199,2016-11-10 00:01:17,10,66,video,13098
119.131.143.179,2016-11-10 00:01:17,10,1422,video,2402
115.60.82.2,2016-11-10 00:01:17,10,54,video,12572
101.40.215.190,2016-11-10 00:01:17,10,54,video,4906
114.91.111.210,2016-11-10 00:01:18,10,54,video,696
119.131.143.179,2016-11-10 00:01:18,10,17707,video,2402
183.39.154.199,2016-11-10 00:01:18,10,4947,video,13098
101.227.12.253,2016-11-10 00:01:18,10,54,video,56
223.74.37.85,2016-11-10 00:01:18,10,54,video,5694
61.148.244.107,2016-11-10 00:01:18,10,54,video,4825
125.119.38.58,2016-11-10 00:01:18,10,54,video,12560
119.131.143.179,2016-11-10 00:01:18,10,2635,video,2402
119.131.143.179,2016-11-10 00:01:18,10,4471,video,2402
119.131.143.179,2016-11-10 00:01:18,10,66,video,2402
58.20.14.170,2016-11-10 00:01:18,10,17,video,5683
119.131.143.179,2016-11-10 00:01:18,10,354,video,2402
111.137.134.93,2016-11-10 00:01:18,10,7233,video,2752
58.242.129.249,2016-11-10 00:01:18,10,54,video,7228
58.250.176.134,2016-11-10 00:01:18,10,54,video,9214
119.131.143.179,2016-11-10 00:01:18,10,72,video,2402
119.131.143.179,2016-11-10 00:01:18,10,4373,video,2402
1.203.177.243,2016-11-10 00:01:18,10,6050,video,7361
119.131.143.179,2016-11-10 00:01:18,10,1081,video,2402
183.39.54.240,2016-11-10 00:01:18,10,54,video,13263
119.131.143.179,2016-11-10 00:01:19,10,329,video,2402
59.53.31.168,2016-11-10 00:01:19,10,54,video,9495
36.33.5.19,2016-11-10 00:01:19,10,6833,video,12504
119.131.143.179,2016-11-10 00:01:19,10,390,video,2402
1.203.177.243,2016-11-10 00:01:19,10,72,video,7361
60.186.195.123,2016-11-10 00:01:19,10,54,video,3653
115.156.237.9,2016-11-10 00:01:19,10,67,video,8746
125.120.150.55,2016-11-10 00:01:19,10,54,video,2450
106.37.179.179,2016-11-10 00:01:19,10,54,video,1430
123.112.21.116,2016-11-10 00:01:19,10,54,video,4441
221.221.148.132,2016-11-10 00:01:19,10,72,video,13153
122.71.75.1,2016-11-10 00:01:19,10,141,video,3354
119.131.143.179,2016-11-10 00:01:19,10,9035,video,2402
221.221.148.132,2016-11-10 00:01:19,10,319,video,13153
106.38.51.208,2016-11-10 00:01:19,10,54,video,3720
221.221.148.132,2016-11-10 00:01:19,10,3991,video,13153
71.17.103.212,2016-11-10 00:01:19,10,67,video,7075
183.228.51.173,2016-11-10 00:01:19,10,54,video,12484
42.236.157.243,2016-11-10 00:01:19,10,54,video,10694
124.133.245.246,2016-11-10 00:01:19,10,67,video,10681
125.77.188.210,2016-11-10 00:01:19,10,54,video,9356
110.184.220.157,2016-11-10 00:01:19,10,54,video,10427
139.196.128.65,2016-11-10 00:01:19,10,524288,video,7974
221.221.148.132,2016-11-10 00:01:19,10,6287,video,13153
119.131.143.179,2016-11-10 00:01:19,10,72,video,2402
120.1.177.245,2016-11-10 00:01:20,10,67,video,3723
183.39.154.199,2016-11-10 00:01:20,10,6195,video,13098
120.52.94.104,2016-11-10 00:01:20,10,54,video,8217
221.221.148.132,2016-11-10 00:01:20,10,349,video,13153
117..227.188,2016-11-10 00:01:20,10,66,video,1336
121.35.185.119,2016-11-10 00:01:20,10,68,video,6161
61.173.68.158,2016-11-10 00:01:20,10,54,video,12534
221.221.148.132,2016-11-10 00:01:20,10,2256,video,13153
125.91.244.214,2016-11-10 00:01:20,10,54,video,1416
117.35.88.30,2016-11-10 00:01:20,10,54,video,5926
14.23.136.224,2016-11-10 00:01:20,10,67,video,2316
117..227.188,2016-11-10 00:01:20,10,1416,video,1336
221.221.148.132,2016-11-10 00:01:20,10,72,video,13153
117..227.188,2016-11-10 00:01:20,10,4192,video,1336
124.65.98.198,2016-11-10 00:01:20,10,54,video,9887
219.157.250.14,2016-11-10 00:01:20,10,54,video,1328
221.221.148.132,2016-11-10 00:01:20,10,74,video,13153
117..227.188,2016-11-10 00:01:20,10,72,video,1336
61.190.33.6,2016-11-10 00:01:20,10,67,video,2858
117..227.188,2016-11-10 00:01:20,10,4418,video,1336
117..227.188,2016-11-10 00:01:20,10,678,video,1336
101.95.153.34,2016-11-10 00:01:20,10,54,video,1716
112.93.198.226,2016-11-10 00:01:20,10,54,video,3520
125.118.5.247,2016-11-10 00:01:20,10,54,video,1990
117..227.188,2016-11-10 00:01:20,10,2263,video,1336
1.194.144.222,2016-11-10 00:01:20,10,54,video,35
114.249.202.36,2016-11-10 00:01:20,10,67,video,12505
122.71.75.1,2016-11-10 00:01:21,10,67,video,3354
117..227.188,2016-11-10 00:01:21,10,328,video,1336
116.19.167.230,2016-11-10 00:01:21,10,54,video,2004
110.184.67.238,2016-11-10 00:01:21,10,54,video,5539
223.80.97.99,2016-11-10 00:01:21,10,67,video,5553
122.71.75.1,2016-11-10 00:01:21,10,7766,video,3354
117..227.188,2016-11-10 00:01:21,10,2227,video,1336
125.88.24.35,2016-11-10 00:01:21,10,54,video,1901
112.115.177.220,2016-11-10 00:01:21,10,54,video,4285
117..227.188,2016-11-10 00:01:21,10,306,video,1336
222.240.165.84,2016-11-10 00:01:21,10,54,video,3520
222.131.22.52,2016-11-10 00:01:21,10,67,video,27
122.234.60.39,2016-11-10 00:01:21,10,8443,video,8837
124.205.212.177,2016-11-10 00:01:21,10,54,video,10505
122.71.75.1,2016-11-10 00:01:21,10,2958,video,3369
210.12.48.132,2016-11-10 00:01:21,10,54,video,11822
61.183.118.241,2016-11-10 00:01:21,10,54,video,7682
117..227.188,2016-11-10 00:01:21,10,313,video,1336
183.128.108.110,2016-11-10 00:01:21,10,54,video,1778
218.18.157.66,2016-11-10 00:01:21,10,297,video,3659
121.207.180.238,2016-11-10 00:01:21,10,54,video,2685
14.23.183.93,2016-11-10 00:01:21,10,54,video,25
122.71.75.1,2016-11-10 00:01:21,10,358,video,3369
122.71.75.1,2016-11-10 00:01:21,10,66,video,3369
59.46.181.226,2016-11-10 00:01:21,10,54,video,2469
49.74.38.249,2016-11-10 00:01:21,10,141,video,634
115.220.63.20,2016-11-10 00:01:21,10,54,video,4375
124.90.145.106,2016-11-10 00:01:21,10,54,video,5691
122.71.75.1,2016-11-10 00:01:21,10,1214,video,3369
117..227.188,2016-11-10 00:01:21,10,6665,video,1336
122.71.75.1,2016-11-10 00:01:22,10,2345,video,3369
58.217.139.123,2016-11-10 00:01:22,10,54,video,12701
218.18.157.66,2016-11-10 00:01:22,10,2345,video,3659
221.234.230.60,2016-11-10 00:01:22,10,54,video,9088
122.71.75.1,2016-11-10 00:01:22,10,358,video,3369
122.71.75.1,2016-11-10 00:01:22,10,4004,video,3369
117..227.188,2016-11-10 00:01:22,10,72,video,1336
218.18.157.66,2016-11-10 00:01:22,10,297,video,3659
36.57.168.12,2016-11-10 00:01:22,10,54,video,7557
117.172.25.86,2016-11-10 00:01:22,10,54,video,6694
125.90.50.60,2016-11-10 00:01:22,10,54,video,3151
122.71.75.1,2016-11-10 00:01:22,10,2535,video,3369
117.100.121.159,2016-11-10 00:01:22,10,54,video,6711
114.249.199.177,2016-11-10 00:01:22,10,54,video,11551
218.18.157.66,2016-11-10 00:01:22,10,308,video,3659
122.71.75.1,2016-11-10 00:01:22,10,1650,video,3369
121.33.51.254,2016-11-10 00:01:22,10,54,video,6512
182.100.20.75,2016-11-10 00:01:22,10,54,video,3244
122.71.75.1,2016-11-10 00:01:22,10,328,video,3369
27.41.88.229,2016-11-10 00:01:22,10,54,video,2911
123.118.216.81,2016-11-10 00:01:22,10,54,video,21
1.203.177.243,2016-11-10 00:01:22,10,6050,video,7361
122.71.75.1,2016-11-10 00:01:22,10,72,video,3369
218.18.157.66,2016-11-10 00:01:22,10,448,video,3659
122.71.75.1,2016-11-10 00:01:23,10,742,video,3369
117.169.140.25,2016-11-10 00:01:23,10,54,video,1412
122.71.75.1,2016-11-10 00:01:23,10,4481,video,3369
218.18.157.66,2016-11-10 00:01:23,10,1884,video,3659
122.71.75.1,2016-11-10 00:01:23,10,7766,video,3369
210.21.221.18,2016-11-10 00:01:23,10,54,video,11736
117.100.231.8,2016-11-10 00:01:23,10,190,video,4017
108.61.180.213,2016-11-10 00:01:23,10,54,video,6841
114.141.190.122,2016-11-10 00:01:23,10,67,video,13160
36.57.145.114,2016-11-10 00:01:23,10,54,video,13271
120.86.130.234,2016-11-10 00:01:23,10,54,video,8175
210.41.96.62,2016-11-10 00:01:23,10,54,video,3604
218.18.157.66,2016-11-10 00:01:23,10,395,video,3659
27.154.86.14,2016-11-10 00:01:23,10,54,video,7863
117.100.231.8,2016-11-10 00:01:23,10,3168,video,4017
113.65.160.153,2016-11-10 00:01:23,10,54,video,3370
123.150.205.98,2016-11-10 00:01:23,10,68,video,1758
122.71.75.1,2016-11-10 00:01:23,10,72,video,3369
106.120.124.49,2016-11-10 00:01:23,10,54,video,3471
36.110.17.19,2016-11-10 00:01:24,10,54,video,13160
61.51.82.242,2016-11-10 00:01:24,10,67,video,6606
120.198.231.151,2016-11-10 00:01:24,10,54,video,13315
125.90.50.156,2016-11-10 00:01:24,10,54,video,2147
222.72.45.34,2016-11-10 00:01:24,10,54,video,11425
180.102.214.19,2016-11-10 00:01:24,10,54,video,7743
171.13.241.97,2016-11-10 00:01:24,10,54074,video,5534
171.13.241.97,2016-11-10 00:01:24,10,3212,video,5534
58.63.21.177,2016-11-10 00:01:24,10,67,video,9332
118.249.208.191,2016-11-10 00:01:24,10,54,video,12831
171.13.241.97,2016-11-10 00:01:24,10,2950,video,5534
112..10.8,2016-11-10 00:01:24,10,54,video,3521
119.130.104.156,2016-11-10 00:01:24,10,54,video,5677
110.185.16.31,2016-11-10 00:01:24,10,54,video,8652
171.13.241.97,2016-11-10 00:01:24,10,205544,video,5534
182.201.172.107,2016-11-10 00:01:24,10,54,video,13249
180.161.236.98,2016-11-10 00:01:24,10,54,video,156
183.48.71.10,2016-11-10 00:01:24,10,54,video,10400
58.250.247.130,2016-11-10 00:01:24,10,67,video,2872
59.40.133.15,2016-11-10 00:01:24,10,54,video,12501
110.90.61.111,2016-11-10 00:01:24,10,54,video,179
119.145.15.156,2016-11-10 00:01:25,10,54,video,11050
183.54.198.81,2016-11-10 00:01:25,10,54,video,1625
116.22.115.108,2016-11-10 00:01:25,10,54,video,3301
27.46.6.191,2016-11-10 00:01:25,10,54,video,1681
125.92.121.122,2016-11-10 00:01:25,10,54,video,13339
222.92.141.18,2016-11-10 00:01:25,10,54,video,116
118.112.58.228,2016-11-10 00:01:25,10,54,video,8491
218.109.108.228,2016-11-10 00:01:25,10,54,video,9669
182.18.117.210,2016-11-10 00:01:25,10,54,video,8515
111.161.148.23,2016-11-10 00:01:25,10,54,video,9566
183.240.20.42,2016-11-10 00:01:26,10,54,video,525
58.44.240.162,2016-11-10 00:01:26,10,54,video,12815
60.186.5.,2016-11-10 00:01:26,10,54,video,11551
222.129.145.85,2016-11-10 00:01:26,10,54,video,10324
183.207.178.205,2016-11-10 00:01:26,10,54,video,7409
101.224.111.144,2016-11-10 00:01:26,10,54,video,3085
111.198.233.158,2016-11-10 00:01:26,10,54,video,2633
119.131.106.128,2016-11-10 00:01:26,10,67,video,8485
123.53.190.91,2016-11-10 00:01:26,10,54,video,11316
123.157.208.18,2016-11-10 00:01:26,10,67,video,12622
175.152.2.169,2016-11-10 00:01:26,10,141,video,24
45.32.34.196,2016-11-10 00:01:26,10,67,video,6687
171.120.24.254,2016-11-10 00:01:26,10,54,video,2520
171.8.148.158,2016-11-10 00:01:26,10,54,video,8299
202.107.210.51,2016-11-10 00:01:26,10,68,video,1904
58.250.198.7,2016-11-10 00:01:26,10,54,video,6701
118.207.116.20,2016-11-10 00:01:26,10,54,video,3002
222.79.80.123,2016-11-10 00:01:27,10,54,video,4415
182.242.227.199,2016-11-10 00:01:27,10,67,video,1628
42.48.158.135,2016-11-10 00:01:27,10,54,video,703
125.120.150.55,2016-11-10 00:01:27,10,67,video,8286
59.46.175.212,2016-11-10 00:01:27,10,54,video,12680
222.137.65.229,2016-11-10 00:01:27,10,54,video,7544
210.12.145.219,2016-11-10 00:01:27,10,54,video,16
222.128.172.20,2016-11-10 00:01:27,10,54,video,10061
117..227.188,2016-11-10 00:01:27,10,6665,video,1336
210.30.58.22,2016-11-10 00:01:27,10,54,video,8152
119.130.185.151,2016-11-10 00:01:27,10,54,video,57
124.65.98.198,2016-11-10 00:01:27,10,54,video,5987
61.142.10.231,2016-11-10 00:01:27,10,54,video,12482
14.153.236.58,2016-11-10 00:01:27,10,320,video,66
14.153.236.58,2016-11-10 00:01:27,10,4166,video,66
223.93.140.242,2016-11-10 00:01:28,10,67,video,9813
14.153.236.58,2016-11-10 00:01:28,10,66,video,66
27.38.44.210,2016-11-10 00:01:28,10,54,video,816
14.153.236.58,2016-11-10 00:01:28,10,10732,video,66
222.80.96.74,2016-11-10 00:01:28,10,54,video,1326
220.181.38.110,2016-11-10 00:01:28,10,54,video,12886
14.153.236.58,2016-11-10 00:01:28,10,2612,video,66
61.183.118.245,2016-11-10 00:01:28,10,54,video,2752
14.153.236.58,2016-11-10 00:01:28,10,914,video,66
125.90.50.87,2016-11-10 00:01:28,10,54,video,9579
117.41.234.99,2016-11-10 00:01:28,10,67,video,1091
120.198.231.151,2016-11-10 00:01:28,10,342,video,54
120.198.231.151,2016-11-10 00:01:28,10,66,video,54
14.153.236.58,2016-11-10 00:01:28,10,72,video,66
120.198.231.151,2016-11-10 00:01:28,10,2959,video,54
120.198.231.150,2016-11-10 00:01:28,10,54,video,10692
42.236.157.243,2016-11-10 00:01:28,10,67,video,10694
14.153.236.58,2016-11-10 00:01:28,10,74,video,66
140.205.253.145,2016-11-10 00:01:28,10,524288,video,5609
14.153.236.58,2016-11-10 00:01:28,10,179,video,66
219.243.215.194,2016-11-10 00:01:28,10,54,video,774
120.198.231.151,2016-11-10 00:01:28,10,1052,video,54
120.196.62.207,2016-11-10 00:01:28,10,54,video,6510
14.153.236.58,2016-11-10 00:01:29,10,320,video,66
175.152.2.169,2016-11-10 00:01:29,10,67,video,24
115.192.161.60,2016-11-10 00:01:29,10,54,video,127
112..60.228,2016-11-10 00:01:29,10,54,video,5433
113.107.163.197,2016-11-10 00:01:29,10,54,video,2808
122.71.75.1,2016-11-10 00:01:29,10,7766,video,3369
58.241.76.18,2016-11-10 00:01:29,10,2635,video,1802
175.152.2.169,2016-11-10 00:01:29,10,5,video,24
120.198.231.151,2016-11-10 00:01:29,10,342,video,54
110.88.48.16,2016-11-10 00:01:29,10,54,video,1762
123.157.217.162,2016-11-10 00:01:29,10,67,video,4417
117.41.234.99,2016-11-10 00:01:29,10,67,video,1202
60.191.78.148,2016-11-10 00:01:29,10,67,video,5478
120.198.231.151,2016-11-10 00:01:29,10,4849,video,54
42.248.114.145,2016-11-10 00:01:29,10,54,video,4242
175.152.2.169,2016-11-10 00:01:29,10,8182,video,24
80.78.215.116,2016-11-10 00:01:29,10,67,video,9905
125.120.150.55,2016-11-10 00:01:29,10,67,video,8286
111.37.29.165,2016-11-10 00:01:29,10,67,video,8413
14.153.236.58,2016-11-10 00:01:29,10,6777,video,66
101.200.101.21,2016-11-10 00:01:29,10,524288,video,10506
58.241.76.18,2016-11-10 00:01:29,10,95,video,1802
218.245.66.245,2016-11-10 00:01:29,10,54,video,10674
120.196.62.207,2016-11-10 00:01:29,10,67,video,4525
113.120.49.46,2016-11-10 00:01:30,10,54,video,6206
182.242.227.199,2016-11-10 00:01:30,10,54,video,1626
120.198.231.151,2016-11-10 00:01:30,10,1921,video,54
101.200.101.21,2016-11-10 00:01:30,10,524288,video,10506
114.251.179.129,2016-11-10 00:01:30,10,54,video,10450
113.132.11.88,2016-11-10 00:01:30,10,54,video,56
115.171.143.119,2016-11-10 00:01:30,10,54,video,4713
115.199.179.156,2016-11-10 00:01:30,10,54,video,7099
120.52.92.3,2016-11-10 00:01:30,10,141,video,11288
220.181.38.112,2016-11-10 00:01:30,10,54,video,2475
183.5.244.42,2016-11-10 00:01:30,10,54,video,2474
59.172.176.229,2016-11-10 00:01:30,10,54,video,1328
218.205.169.193,2016-11-10 00:01:30,10,54,video,7950
59.172.142.93,2016-11-10 00:01:30,10,54,video,7704
219.143.13.59,2016-11-10 00:01:30,10,67,video,9547
14.153.236.58,2016-11-10 00:01:30,10,72,video,66
39.176.195.5,2016-11-10 00:01:31,10,54,video,2687
122.224.33.106,2016-11-10 00:01:31,10,54,video,1455
61.141.142.19,2016-11-10 00:01:31,10,54,video,2882
116.233..239,2016-11-10 00:01:31,10,54,video,4708
1.85.61.18,2016-11-10 00:01:31,10,54,video,6578
58.209.20.172,2016-11-10 00:01:31,10,54,video,2174
112.80.186.13,2016-11-10 00:01:31,10,54,video,3345
120.210.1.251,2016-11-10 00:01:31,10,54,video,11224
119.131.143.179,2016-11-10 00:01:31,10,9035,video,2402
219.150.53.96,2016-11-10 00:01:31,10,54,video,1709
114.248.224.214,2016-11-10 00:01:31,10,67,video,1308
117.166.15.72,2016-11-10 00:01:31,10,54,video,4323
114.248.224.214,2016-11-10 00:01:31,10,6690,video,1308
110.80.26.230,2016-11-10 00:01:31,10,54,video,12481
58.62.103.176,2016-11-10 00:01:32,10,67,video,29
222.212.194.52,2016-11-10 00:01:32,10,54,video,5615
182.18.111.38,2016-11-10 00:01:32,10,54,video,4451
114.249.93.42,2016-11-10 00:01:32,10,54,video,11950
113.246.94.4,2016-11-10 00:01:32,10,54,video,773
119.145.72.168,2016-11-10 00:01:32,10,54,video,6209
114.248.224.214,2016-11-10 00:01:32,10,2958,video,1309
113.87.230.207,2016-11-10 00:01:32,10,67,video,9802
117.100.231.8,2016-11-10 00:01:32,10,141,video,4017
118.207.116.20,2016-11-10 00:01:32,10,72,video,3002
222.168.40.123,2016-11-10 00:01:32,10,67,video,12883
49.74.38.249,2016-11-10 00:01:32,10,67,video,634
211.80.86.94,2016-11-10 00:01:32,10,67,video,5288
220.240.226.90,2016-11-10 00:01:32,10,54,video,2634
114.248.224.214,2016-11-10 00:01:32,10,339,video,1309
123.234.233.109,2016-11-10 00:01:32,10,67,video,11225
221.221.202.248,2016-11-10 00:01:32,10,54,video,3345
113.109.214.12,2016-11-10 00:01:32,10,54,video,10802
27.38.0.184,2016-11-10 00:01:32,10,54,video,7198
114.248.224.214,2016-11-10 00:01:32,10,1246,video,1309
124.127.79.228,2016-11-10 00:01:32,10,54,video,9819
101.40.175.228,2016-11-10 00:01:32,10,54,video,12905
116.243.183.21,2016-11-10 00:01:32,10,54,video,9970
220.198.208.176,2016-11-10 00:01:32,10,54,video,27
114.248.224.214,2016-11-10 00:01:33,10,1955,video,1309
114.248.224.214,2016-11-10 00:01:33,10,519,video,1309
111.172.46.191,2016-11-10 00:01:33,10,54,video,1708
222.173.219.54,2016-11-10 00:01:33,10,54,video,5941
114.248.224.214,2016-11-10 00:01:33,10,339,video,1309
114.248.224.214,2016-11-10 00:01:33,10,306,video,1309
139.196.128.78,2016-11-10 00:01:33,10,524288,video,9478
39.179.202.119,2016-11-10 00:01:33,10,54,video,2159
58.250.198.10,2016-11-10 00:01:33,10,54,video,6712
221.221.223.134,2016-11-10 00:01:33,10,54,video,371
42.243.70.197,2016-11-10 00:01:33,10,54,video,4188
114.248.224.214,2016-11-10 00:01:33,10,323,video,1309
58.33.184.252,2016-11-10 00:01:33,10,67,video,4247
113.132.11.206,2016-11-10 00:01:33,10,54,video,11823
218.65.215.17,2016-11-10 00:01:33,10,54,video,11041
114.248.224.214,2016-11-10 00:01:33,10,2700,video,1309
114.248.224.214,2016-11-10 00:01:33,10,3421,video,1309
114.248.224.214,2016-11-10 00:01:33,10,66,video,1309
140.207.223.190,2016-11-10 00:01:33,10,54,video,3665
114.248.224.214,2016-11-10 00:01:33,10,3421,video,1309
183.4.176.116,2016-11-10 00:01:33,10,54,video,2427
114.248.224.214,2016-11-10 00:01:33,10,72,video,1309
122.224.33.97,2016-11-10 00:01:33,10,54,video,3016
123.149.32.122,2016-11-10 00:01:33,10,54,video,35
211.83.242.122,2016-11-10 00:01:33,10,54,video,4451
106.5.219.134,2016-11-10 00:01:33,10,54,video,7479
182.100.26.109,2016-11-10 00:01:33,10,54,video,11709
114.248.224.214,2016-11-10 00:01:33,10,6690,video,1309
101.40.175.228,2016-11-10 00:01:34,10,67,video,11716
61.51.82.242,2016-11-10 00:01:34,10,54,video,3262
121.69.23.250,2016-11-10 00:01:34,10,54,video,12495
218.88.29.153,2016-11-10 00:01:34,10,54,video,1446
117.41.234.99,2016-11-10 00:01:34,10,54,video,1092
113.57.24.53,2016-11-10 00:01:34,10,54,video,2523
60.191.99.129,2016-11-10 00:01:34,10,54,video,3520
115.156.142.179,2016-11-10 00:01:34,10,54,video,12280
223.21.111.79,2016-11-10 00:01:34,10,54,video,11714
111.132.18.241,2016-11-10 00:01:34,10,54,video,3473
71.17.103.212,2016-11-10 00:01:34,10,67,video,7075
14.23.188.111,2016-11-10 00:01:34,10,54,video,2418
125.88.24.91,2016-11-10 00:01:34,10,54,video,1501
115.193.172.253,2016-11-10 00:01:34,10,72,video,3078
112.12.192.150,2016-11-10 00:01:34,10,54,video,1861
113.91.162.210,2016-11-10 00:01:34,10,67,video,1809
14.23.136.224,2016-11-10 00:01:34,10,54,video,2316
125.122.26.81,2016-11-10 00:01:35,10,54,video,3225
183.240.20.251,2016-11-10 00:01:35,10,54,video,3225
117.136.39.218,2016-11-10 00:01:35,10,54,video,1414
121.35.2.128,2016-11-10 00:01:35,10,54,video,12580
222.76.251.186,2016-11-10 00:01:35,10,54,video,11725
140.205.253.137,2016-11-10 00:01:35,10,524288,video,13181
14.28.139.202,2016-11-10 00:01:35,10,54,video,7727
171.37.141.121,2016-11-10 00:01:35,10,54,video,12163
180.173.242.43,2016-11-10 00:01:35,10,54,video,6046
223.20.63.251,2016-11-10 00:01:35,10,54,video,3246
27.42.25.21,2016-11-10 00:01:35,10,67,video,9888
113.87.161.137,2016-11-10 00:01:35,10,141,video,8006
183.66.87.224,2016-11-10 00:01:35,10,54,video,12133
220.168.79.1,2016-11-10 00:01:35,10,54,video,13038
175.10.206.212,2016-11-10 00:01:35,10,54,video,3956
118.207.116.20,2016-11-10 00:01:35,10,72,video,3002
112.10.27.228,2016-11-10 00:01:35,10,828,article,3669
112.10.27.228,2016-11-10 00:01:35,10,549,article,3669
112.10.27.228,2016-11-10 00:01:35,10,16756,article,3669
111.196.209.12,2016-11-10 00:01:35,10,54,video,11443
112.10.27.228,2016-11-10 00:01:35,10,498,article,3669
112.10.27.228,2016-11-10 00:01:35,10,12541,article,3669
171.8.199.118,2016-11-10 00:01:35,10,68,video,3738
112.10.27.228,2016-11-10 00:01:35,10,9800,article,3669
120.52.94.106,2016-11-10 00:01:36,10,54,video,678
112.10.27.228,2016-11-10 00:01:36,10,628,article,3669
112.10.27.228,2016-11-10 00:01:36,10,591,article,3669
112.10.27.228,2016-11-10 00:01:36,10,2951,article,3669
112.10.27.228,2016-11-10 00:01:36,10,270967,article,3669
117.100.231.8,2016-11-10 00:01:36,10,67,video,4017
182.138.128.41,2016-11-10 00:01:36,10,330,video,11239
182.138.128.41,2016-11-10 00:01:36,10,32,video,11239
182.138.128.41,2016-11-10 00:01:36,10,66,video,11239
101.200.101.21,2016-11-10 00:01:36,10,524288,video,10506
182.138.128.41,2016-11-10 00:01:36,10,2959,video,11239
112..60.41,2016-11-10 00:01:36,10,54,video,4366
117.100.231.8,2016-11-10 00:01:36,10,7269,video,4017
112.10.27.228,2016-11-10 00:01:36,10,4468,article,3669
112.10.27.228,2016-11-10 00:01:36,10,2023,article,3669
182.138.128.41,2016-11-10 00:01:36,10,72,video,11239
114.242.167.68,2016-11-10 00:01:36,10,6511,video,4451
221.237.87.40,2016-11-10 00:01:36,10,54,video,8809
112.10.27.228,2016-11-10 00:01:36,10,106,article,3669
1.85.61.37,2016-11-10 00:01:36,10,54,video,7212
112.10.27.228,2016-11-10 00:01:36,10,5102,article,3669
182.139.108.80,2016-11-10 00:01:36,10,54,video,1459
101.200.101.31,2016-11-10 00:01:36,10,524288,video,8175
182.138.128.41,2016-11-10 00:01:36,10,113,video,11239
114.248.224.214,2016-11-10 00:01:36,10,72,video,1309
182.138.128.41,2016-11-10 00:01:36,10,2614,video,11239
112.10.27.228,2016-11-10 00:01:36,10,0,article,3669
182.138.128.41,2016-11-10 00:01:36,10,330,video,11239
182.138.128.41,2016-11-10 00:01:36,10,3,video,11239
113.119.10.98,2016-11-10 00:01:36,10,67,video,6224
58.249.67.242,2016-11-10 00:01:37,10,54,video,11014
182.138.128.41,2016-11-10 00:01:37,10,303,video,11239
182.138.128.41,2016-11-10 00:01:37,10,318,video,11239
120.41.120.245,2016-11-10 00:01:37,10,54,video,5984
58.217.165.114,2016-11-10 00:01:37,10,54,video,10692
117.100.231.8,2016-11-10 00:01:37,10,2957,video,4018
182.138.128.41,2016-11-10 00:01:37,10,1541,video,11239
121.69.23.250,2016-11-10 00:01:37,10,67,video,12495
182.138.128.41,2016-11-10 00:01:37,10,74,video,11239
123.151.12.154,2016-11-10 00:01:37,10,3493,video,5865
182.138.128.41,2016-11-10 00:01:37,10,72,video,11239
39.159.109.210,2016-11-10 00:01:37,10,54,video,6203
222.73.202.154,2016-11-10 00:01:37,10,68,video,12678
61.152.132.230,2016-11-10 00:01:37,10,54,video,95
182.138.128.41,2016-11-10 00:01:37,10,6207,video,11239
116.235.102.120,2016-11-10 00:01:37,10,54,video,99
58.246.74.211,2016-11-10 00:01:37,10,67,video,11731
222.65.226.176,2016-11-10 00:01:37,10,54,video,10511
123.151.12.154,2016-11-10 00:01:37,10,2957,video,5866
218.106.145.12,2016-11-10 00:01:37,10,54,video,9447
110.65.101.188,2016-11-10 00:01:37,10,67,video,6721
117.100.231.8,2016-11-10 00:01:37,10,357,video,4018
116.237.53.200,2016-11-10 00:01:37,10,54,video,4161
27.41.69.240,2016-11-10 00:01:38,10,67,video,11610
58.217.165.114,2016-11-10 00:01:38,10,67,video,10690
71.17.103.212,2016-11-10 00:01:38,10,67,video,7075
117.100.231.8,2016-11-10 00:01:38,10,66,video,4018
117.100.231.8,2016-11-10 00:01:38,10,951,video,4018
49.77.220.79,2016-11-10 00:01:38,10,54,video,1102
117.100.231.8,2016-11-10 00:01:38,10,5363,video,4018
58.63.21.177,2016-11-10 00:01:38,10,54,video,10314
117.100.231.8,2016-11-10 00:01:38,10,4,video,4018
120.198.231.152,2016-11-10 00:01:38,10,54,video,1803
117.100.231.8,2016-11-10 00:01:38,10,5155,video,4018
117.100.231.8,2016-11-10 00:01:38,10,2286,video,4018
71.17.103.212,2016-11-10 00:01:38,10,6260,video,7075
121.207.222.221,2016-11-10 00:01:38,10,54,video,9328
39.187.166.65,2016-11-10 00:01:38,10,54,video,3632
117.100.231.8,2016-11-10 00:01:38,10,2536,video,4018
171.216.69.80,2016-11-10 00:01:38,10,54,video,8714
123.119.218.242,2016-11-10 00:01:38,10,54,video,13013
223.81.137.65,2016-11-10 00:01:38,10,54,video,7303
117.100.231.8,2016-11-10 00:01:38,10,357,video,4018
192.240.123.193,2016-11-10 00:01:38,10,67,video,12881
117.100.231.8,2016-11-10 00:01:38,10,72,video,4018
116.24.24.10,2016-11-10 00:01:38,10,54,video,2910
117.100.231.8,2016-11-10 00:01:38,10,1092,video,4018
114.248.224.214,2016-11-10 00:01:39,10,4022,video,1309
113.143.158.241,2016-11-10 00:01:39,10,141,video,4299
36.5.155.118,2016-11-10 00:01:39,10,54,video,4251
114.248.224.214,2016-11-10 00:01:39,10,13241,video,1309
117.100.231.8,2016-11-10 00:01:39,10,321,video,4018
39.186.247.142,2016-11-10 00:01:39,10,7227,video,3237
119.123.177.2,2016-11-10 00:01:39,10,54,video,20
110.80.187.200,2016-11-10 00:01:39,10,54,video,8356
114.24.40.251,2016-11-10 00:01:39,10,54,video,1059
14.127.27.212,2016-11-10 00:01:39,10,54,video,10686
113.87.161.137,2016-11-10 00:01:39,10,67,video,8006
49.72.238.254,2016-11-10 00:01:39,10,54,video,26
115.231.148.38,2016-11-10 00:01:39,10,54,video,55
106.39.200.44,2016-11-10 00:01:39,10,54,video,9579
222.178.202.108,2016-11-10 00:01:39,10,54,video,2861
115.174.68.92,2016-11-10 00:01:39,10,54,video,9809
183.204.48.118,2016-11-10 00:01:39,10,54,video,8212
119.130.229.205,2016-11-10 00:01:39,10,54,video,4761
59.41.95.198,2016-11-10 00:01:39,10,54,video,9023
101.38.157.182,2016-11-10 00:01:39,10,67,video,2163
221.226.97.31,20
热心网友
时间：2022-04-11 03:01
清洗数据有三个方法，分别是分箱法、聚类法、回归法。
1、分箱法
是一个经常使用到方法，所谓的分箱法，就是将需要处理的数据根据一定的规则放进箱子里，然后进行测试每一个箱子里的数据，并根据数据中的各个箱子的实际情况进行采取方法处理数据。
2、回归法
回归法就是利用了函数的数据进行绘制图像，然后对图像进行光滑处理。回归法有两种，一种是单线性回归，一种是多线性回归。单线性回归就是找出两个属性的最佳直线，能够从一个属性预测另一个属性。多线性回归就是找到很多个属性，从而将数据拟合到一个*面，这样就能够消除噪声。
3、聚类法
聚类法的工作流程是比较简单的，但是操作起来确实复杂的，所谓聚类法就是将抽象的对象进行集合分组，成为不同的集合，找到在集合意外的孤点，这些孤点就是噪声。这样就能够直接发现噪点，然后进行清除即可。
扩展资料：
数据清洗从名字上也看的出就是把“脏”的“洗掉”，指发现并纠正数据文件中可识别的错误的最后一道程序，包括检查数据一致性，处理无效值和缺失值等。
因为数据仓库中的数据是面向某一主题的数据的集合，这些数据从多个业务系统中抽取而来而且包含历史数据，这样就避免不了有的数据是错误数据、有的数据相互之间有冲突，这些错误的或有冲突的数据显然是我们不想要的，称为“脏数据”。
我们要按照一定的规则把“脏数据”“洗掉”，这就是数据清洗。而数据清洗的任务是过滤那些不符合要求的数据，将过滤的结果交给业务主管部门，确认是否过滤掉还是由业务单位修正之后再进行抽取。
不符合要求的数据主要是有不完整的数据、错误的数据、重复的数据三大类。数据清洗是与问卷审核不同，录入后的数据清理一般是由计算机而不是人工完成 。
参考资料来源：百度百科-数据清洗
