1. numpy科学计算基础库

1.1 numpy读取数据

CSV:Comma-Separated Value,逗号分隔值文件
显示：表格状态
源文件：换行和逗号分隔行列的格式化文本,每一行的数据表示一条记录。

由于csv便于展示,读取和写入,所以很多地方也是用csv的格式存储和传输中小型的数据,为了方便教学,我们会经常操作csv格式的文件,但是操作数据库中的数据也是很容易的实现的。

np.loadtxt(fname,dtype=np.float,delimiter=None,skiprows=0,usecols=None,unpack=False)

np.loadtxt(US_video_data_ numbers_path,delimiter=\",\",dtype=int,unpack=1)

注意其中添加delimiter和dtype以及unpack的效果
delimiter:指定边界符号是什么，不指定会导致每行数据为一个整体的字符串而报错
dtype:默认情况下对于较大的数据会将其变为科学计数的方式
那么unpack的效果呢？
upack:默认是Flase(0)，默认情况下，有多少条数据，就会有多少行
为True（1）的情况下，每一列的数据会组成一行，原始数据有多少列，加载出来的数据就会有多少行，相当于转置的效果

1.2 numpy中的转置

转置是一种变换，对于numpy中的数组来说，就是在对角线方向交换数据，目的也是为了更方便的去处理数据。

# coding=utf-8
import numpy as np

t = np.array([[0,1,2,3,4,5],[6,7,8,9,10,11],[12,13,1,15,16,17]])
print(t)

print(t.swapaxes(1,0))
print(t.transpose())
print(t.T)

运行结果：

1.3 numpy索引和切片

对于刚刚加载出来的数据，我如果只想选择其中的某一列(行)我们应该怎么做呢？

# coding=utf-8
import numpy as np

a = np.array([[0,1,2,3],[4,5,6,7],[8,9,10,11]])
#取一行
print(a[1])
#取多行
print(a[1:3])
#取一列
print(a[:,2])
#取多列
print(a[:,2:4])

运行结果：

1.4 numpy中数值的修改

# coding=utf-8
import numpy as np

t = np.array([[0,1,2,3,4,5],[6,7,8,9,10,11],[12,13,14,15,16,17],[18,19,20,21,22,23]])
print(t)
print(t[:,2:4])
t[:,2:4] = 0
print(t)

运行结果：

1.5 numpy中布尔索引

# coding=utf-8
import numpy as np

t = np.arange(24).reshape((4,6))
print(t)
print(t<10)
t[t<10] = 0
print(t)

运行结果：

1.6 numpy中三元运算符

# coding=utf-8
import numpy as np

t = np.arange(24).reshape((4,6))
print(t)
print(np.where(t<10,0,10))

运行结果：

1.7 numpy中的nan和inf

nan(NAN,Nan):not a number表示不是一个数字

什么时候numpy中会出现nan：
当我们读取本地的文件为float的时候，如果有缺失，就会出现nan
当做了一个不合适的计算的时候(比如无穷大(inf)减去无穷大)

inf(-inf,inf):infinity,inf表示正无穷，-inf表示负无穷

什么时候回出现inf包括（-inf，+inf）
比如一个数字除以0，（python中直接会报错，numpy中是一个inf或者-inf）

# coding=utf-8
import numpy as np

#两个nan是不相等的
print(np.nan == np.nan)
print(np.nan != np.nan)
#以上的特性，判断数组中nan的个数
t = np.array([1.,2.,np.nan])
print(np.count_nonzero(t!=t))
#由于np.nan != np.nan为True，那么如何判断一个数字是否为nan呢？
#通过np.isnan(a)来判断，返回bool类型，比如希望把nan替换为0
t[np.isnan(t)]=0
print(t)
#nan和任何值计算都为nan

运行结果：

# coding=utf-8
import numpy as np

def fill_ndarray(t1):
    for i in range(t1.shape[1]):  # 遍历每一列
        temp_col = t1[:, i]  # 当前的一列
        nan_num = np.count_nonzero(temp_col != temp_col)
        if nan_num != 0:  # 不为0，说明当前这一列中有nan
            temp_not_nan_col = temp_col[temp_col == temp_col]  # 当前一列不为nan的array

            # 选中当前为nan的位置，把值赋值为不为nan的均值
            temp_col[np.isnan(temp_col)] = temp_not_nan_col.mean()
    return t1

if __name__ == '__main__':
    t1 = np.arange(24).reshape((4, 6)).astype("float")
    t1[1, 2:] = np.nan
    print(t1)
    t1 = fill_ndarray(t1)
    print(t1)

运行结果：

1.8 numpy中常用统计函数

求和：t.sum(axis=None)
均值：t.mean(a,axis=None) 受离群点的影响较大
中值：np.median(t,axis=None)
最大值：t.max(axis=None)
最小值：t.min(axis=None)
极值：np.ptp(t,axis=None) 即最大值和最小值只差
标准差：t.std(axis=None)

标准差是一组数据平均值分散程度的一种度量。一个较大的标准差，代表大部分数值和其平均值之间差异较大；一个较小的标准差，代表这些数值较接*均值
反映出数据的波动稳定情况，越大表示波动越大，约不稳定。

缺失值填充均值：

# coding=utf-8
import numpy as np

def fill_ndarray(t1):
    for i in range(t1.shape[1]):  #遍历每一列
        temp_col = t1[:,i]  #当前的一列
        nan_num = np.count_nonzero(temp_col!=temp_col)
        if nan_num !=0: #不为0，说明当前这一列中有nan
            temp_not_nan_col = temp_col[temp_col==temp_col] #当前一列不为nan的array

            # 选中当前为nan的位置，把值赋值为不为nan的均值
            temp_col[np.isnan(temp_col)] = temp_not_nan_col.mean()
    return t1

if __name__ == '__main__':
    t1 = np.arange(24).reshape((4, 6)).astype("float")
    t1[1, 2:] = np.nan
    print(t1)
    t1 = fill_ndarray(t1)
    print(t1)

运行结果：

1.9 numpy生成随机数

1.10 实例运用

假设我们现在有一个英国和美国各自youtube1000多个视频的点击，喜欢，不喜欢，评论数量(["views","likes","dislikes","comment_total"])的csv,运用刚刚所学习的只是,我们尝试来对其进行操作。

准备数据：

7426393,78240,13548,705
494203,2651,1309,0
142819,13119,151,1141
1580028,65729,1529,3598
40592,5019,57,490
317696,9449,135,464
479291,23935,638,1941
10532409,384841,7547,23849
65453,2761,33,223
751743,42272,358,3250
1121715,65988,591,51025
199102,14916,324,1098
1024398,61352,967,4097
483360,16251,245,1588
601419,19564,658,2510
185541,12172,114,827
814262,66290,3557,5546
169898,5470,362,490
1691734,39633,1775,5191
917746,25455,731,1073
40884,1126,15,131
125196,5388,46,418
162818,9523,416,1079
1936216,74528,1059,6552
22668,62,0,27
1701667,53795,8517,36290
35536,2094,40,415
189389,15787,104,2479
369541,7658,469,1887
4659935,17509,2542,2157
153427,8915,91,1080
109101,4209,109,462
4615562,104889,2180,11355
379393,14093,323,1338
274358,9213,476,838
218536,10659,432,1424
2524251,17100,676,5311
463425,26446,8020,12806
3263,108,2,7
182142,4041,820,3267
82601,5311,67,1662
136677,490,206,1841
214126,9278,139,349
807265,26518,522,5996
141937,9886,130,1224
58169,1906,73,198
315091,19533,204,3172
503585,41072,362,3399
498126,6298,112,789
330727,18020,112,1017
324532,6060,72,252
141356,9465,55,956
162018,2566,72,0
703750,2921,2196,1042
246389,15307,247,1842
331993,14276,626,1927
265337,3986,197,252
1560006,190937,793,19925
452338,6684,298,587
121447,1302,102,512
119670,3821,73,377
12393,761,6,45
230701,11767,184,1519
1023353,22255,264,3209
228731,9743,292,1119
127097,1068,61,260
157166,19869,77,2027
1617120,83410,1014,7114
61781,2543,58,267
1152639,45401,4310,5708
273962,3105,129,594
3576396,155585,6168,6702
412117,16287,748,2254
39245,2376,103,479
27794,1690,34,174
185984,6155,129,320
688485,6543,509,350
50058,3299,14,241
76714,5830,47,337
355492,4811,363,1478
506525,13349,463,1492
496166,8235,450,1098
352276,13098,508,1297
1769256,8048,2123,3359
659654,3964,712,278
1006825,57541,570,3333
787961,17140,1054,5521
236805,4631,67,201
43179,196,14,183
94048,5982,67,699
991790,47532,626,2006
5042942,183473,16578,19443
1683617,15347,690,887
77753,805,82,636
1598,0,0,0
266862,5496,74,300
13721029,468496,6596,20989
47756,393,157,144
1307367,19733,984,3029
538100,15693,234,1962
76410,2193,17,156
166386,6301,67,502
14268,80,5,9
59288,839,102,179
1811958,133815,5380,23181
163175,3337,111,447
5951,63,8,73
387841,12097,458,1771
2384126,50006,1918,6584
699671,49246,995,4863
36297533,1431489,28044,100632
413246,17086,338,1587
2594,100,2,17
1244984,29748,2639,4112
104920,268,60,6
67151,264,18,33
406279,20499,516,6361
131005,859,867,532
25343,167,17,42
952919,17703,3207,0
288535,4772,159,397
97368,335,11,56
614608,49441,1986,3970
463276,19286,393,2304
299228,16290,155,901
241329,12247,203,1013
3970592,154729,1972,7476
61565,1039,14,471
738448,8415,199,949
1884820,55235,1132,3279
1834397,45754,1406,10764
1101502,4117,993,2358
108797,3677,107,732
626419,20553,1033,2138
3026138,76495,2880,6414
2217,14,1,7
104056,16458,32,1263
1851397,24773,2844,2242
3994782,291371,11625,24235
204310,19566,57,1727
737567,10261,802,1232
713480,24229,673,2204
2450950,176104,1017,6257
57819,682,29,147
599742,29851,299,453
1655312,23960,455,2777
220053,6740,853,1455
657439,24309,390,1783
836133,19314,1206,0
59384,209,12,19
74896,2606,93,240
384624,21301,353,1559
79826,3740,52,375
189372,7070,112,288
319276,4939,3627,0
185604,8689,202,492
538884,4610,1276,3651
659862,43887,593,342
338544,16458,217,2527
445180,5189,313,502
288843,8899,55,544
900916,75199,254,7395
60191,972,76,312
149811,5737,87,1439
291531,7401,251,585
87063,2203,18,351
1055582,39081,842,4809
803941,27542,553,2512
85630,521,35,99
1868689,31842,1395,2798
56949,1129,19,111
467118,1474,385,310
828608,2935,599,2113
181598,3370,41,199
364765,9537,1270,1629
64273,3756,32,843
1368378,38304,581,2762
62161,1709,20,125
181645,2399,374,1300
129516,5166,221,339
503997,15015,1147,1319
118932,5296,51,255
854299,26749,548,2233
105687,4819,35,354
2214471,85209,4165,18085
4690194,505334,13072,83992
10139,113,0,18
81262,6822,120,431
1997363,69424,5278,16930
70042,5632,33,307
104581,3763,106,254
54723,2317,51,197
255648,5970,112,178
17521230,437405,25272,72329
167243,8387,147,453
126475,937,40,46
311056,4939,318,471
740296,16644,789,1424
149777,6768,92,793
278555,12005,165,330
1796205,26393,464,2278
5457215,349832,17471,52478
1109739,11238,1809,3626
7920718,81587,14433,1460
2083895,128378,1136,8733
193416,7410,212,472
1398012,35862,619,6241
3654631,30830,6099,16709
1568532,174682,2162,19186
153181,9241,134,907
504620,29196,457,2233
1341911,33110,1035,4709
197058,14771,224,1257
380211,11550,1284,1778
27927,169,3,85
1637505,76339,936,6052
743189,28799,609,1980
1805172,72614,1714,4056
1461311,35310,1062,6077
1152533,25561,1142,4237
1668188,88156,5892,7369
1091878,49488,537,3881
558740,4842,259,1083
11475270,398493,8158,24861
585991,26814,778,2165
257201,10096,227,1362
81675,3085,42,308
46864,1893,47,159
482329,11797,178,575
705475,34493,549,3180
9749,153,4,10
772128,21776,813,2839
8940,72,10,49
482637,28975,336,2423
57168,1305,17,176
111776,4848,68,311
292538,16890,322,1834
746904,12073,755,1562
304490,10867,171,385
207071,2021,1977,0
87061,220,43,115
579530,17842,277,1852
214481,12908,125,937
1247121,68785,1092,4582
205103,10944,471,1206
86229,1870,97,759
53745,483,57,206
413020,18223,404,1671
743630,48909,471,3746
209260,6056,420,573
393968,10053,596,1191
115702,4367,111,479
2511096,90132,1319,7936
429138,18013,343,3900
947706,25968,741,1139
1759154,54336,8854,37011
187511,4086,842,3372
1180879,47863,1640,4295
250268,11351,457,1270
4959620,18534,2722,2450
162622,9173,94,951
496246,25067,236,3634
410405,14670,344,1407
4830992,107671,2276,11743
62029,1985,76,216
792162,3186,2354,929
481646,26919,8151,13162
41152,2278,44,470
71912,2013,17,165
892442,27573,554,6161
2817039,18480,723,5724
55602,2433,84,453
141012,498,208,1951
85814,5415,68,1723
2055,62,24,0
169383,2615,73,0
376653,21238,220,3538
144652,5837,46,455
179765,2642,25,466
352810,4634,238,331
158779,10142,60,1003
541685,6617,117,901
348472,18536,115,1070
352123,6769,81,283
372944,15547,646,2081
205695,16389,111,2554
152653,1454,116,661
45841,2548,115,504
461896,6740,299,572
125476,3931,75,382
25787,968,36,294
1603599,193810,804,20195
91179,3302,153,1285
2072539,90345,4722,15645
564123,33312,488,4152
29598,84,2,8
252320,12479,202,1635
150257,10184,137,1107
264903,11033,304,1231
168560,20643,81,2100
130228,1083,62,271
1681417,85016,1038,7196
274309,16266,266,1965
63686,2599,58,275
1228122,47166,4719,6048
89695,509,22,205
33577,1850,35,207
15300,860,6,52
145607,7767,86,766
274503,3106,129,613
34939,1803,14,318
1043993,58481,587,3393
197356,6356,142,357
54815,4499,129,640
46272,210,14,188
3635565,156317,6214,6770
694324,6563,509,369
50742,3328,15,249
78823,5922,48,345
289823,5729,82,310
516399,13503,467,1529
1774499,8057,2128,3396
230912,3601,89,1320
667703,3996,722,280
808962,17616,1060,5678
78873,807,84,647
15076956,485775,6885,20825
1622,0,0,0
1703223,15421,693,905
5292941,187245,17327,19816
170284,6342,67,503
362037,4853,365,1497
1013541,47911,633,2015
47999,396,157,150
354557,13162,508,1306
1361619,20381,1020,3113
583429,16338,246,2142
246424,4720,68,203
84550,2289,17,143
30048,1586,50,237
114203,270,62,8
111620,379,11,62
1849540,135168,5430,23408
180554,3458,113,459
6014,63,8,73
396083,12221,463,1772
723980,50162,1000,4923
38678096,1458937,28784,102238
3006,101,2,21
426248,17361,345,1613
80647,475,23,106
414089,20838,521,6595
67706,265,18,33
628024,49972,2011,4049
131734,860,871,536
25469,167,17,43
1256061,29934,2662,4152
472426,19479,394,2327
195079,3410,102,355
753656,10411,822,1235
775743,8659,208,969
243245,12305,204,1022
4230773,294499,11811,24462
4045505,156186,1996,7562
958504,17762,3218,0
1854629,46052,1412,10828
1102459,4117,993,2395
1984548,25975,2916,2345
111083,3738,109,739
3251331,79631,2984,6576
69958,1145,15,507
2315,14,2,7
105701,16596,32,1268
303575,16427,156,918
212719,19876,58,1732
823000,25570,758,2288
2473585,177014,1018,6290
324360,4975,3652,0
637361,20701,1048,2151
60016,696,29,147
197531,7176,117,291
220483,6752,853,1454
865377,19381,1208,0
671475,44185,596,341
60283,217,12,20
75664,2619,93,239
89514,538,37,103
80953,3767,53,376
547462,4645,1279,3682
337686,10121,65,618
188572,8765,204,493
342639,16582,218,2550
681308,24556,399,1815
455309,5288,321,516
605425,29993,301,470
1976278,32733,1435,2866
914602,75684,256,7438
72491,1806,26,133
60628,976,76,315
392014,21510,354,1567
3619251,47568,993,4017
612932,26114,210,1387
754452,74303,947,10379
1920241,20272,4006,7615
145342,1820,53,273
5853747,361416,22019,54666
960528,42543,773,3130
2587155,144158,1480,9933
1936912,42199,835,7351
168197,7101,210,241
8260919,84514,15178,2049
2888266,222480,3287,23533
161886,10258,338,1274
126204,5106,133,530
4257099,33616,6881,18323
846828,9316,650,1943
317578,2054,227,684
43486,397,15,170
667161,48052,1015,2956
73989,2933,234,617
195172,11516,399,1166
181052,6496,101,375
327108,10093,354,609
68893,5739,27,337
52740,2604,58,303
85461,4119,76,392
516978,14114,1718,2228
1493954,35531,1135,5316
11519,1504,27,282
1191937,39376,903,2643
982779,43482,616,3084
234703,16203,288,1406
1703542,31919,1348,5067
1546392,36722,1111,6460
2452799,104512,7805,7083
672570,41032,658,2014
443122,13782,439,1673
544680,25543,585,3016
1754958,79446,1038,6290
1985492,78513,1878,3926
943549,40803,672,3650
61718,2313,74,192
128860,5439,95,986
231936,21825,456,2173
1379048,55263,694,4383
69553,1472,19,213
117028,743,112,386
80713,3874,30,222
32362,451,7,38
197066,10700,184,1032
91778,3364,49,346
648233,28645,845,2352
12207070,411667,8567,21046
567552,12802,193,634
184640,5624,208,2395
406193,12576,213,471
20029,561,15,231
14179,139,31,78
896104,23663,911,3139
139757,299,63,210
98028,1993,102,836
3165318,10554,446,1616
971730,56421,597,4095
19416,1343,18,94
243032,12388,521,1334
1465456,75278,1188,4244
650836,19201,309,2088
772453,12351,774,1291
483559,20263,450,1883
223187,2176,2122,0
11902,159,4,42
236768,6535,495,647
13859,174,2,31
431406,10378,628,1025
8566,137,57,0
3012146,103676,1534,7761
490200,19610,386,3079
27424,430,15,363
971221,26433,748,1055
32163,64,68,228
1424598,54074,1848,4710
170521,9417,98,979
121547,4567,119,469
1791737,54656,9107,37482
30521,192,3,21
5287237,19796,2919,2275
554361,26838,262,3918
139502,311,5,222
39427,772,42,747
829736,3322,2391,999
999045,29142,616,6399
302662,12474,540,1384
431283,15079,351,1294
3101168,19954,773,6239
72611,139,12,79
5026861,110385,2363,12171
146716,400,458,1018
3666560,103510,5470,17971
88398,5540,68,1377
191453,4124,870,2821
143075,501,209,1727
518301,5845,290,413
422285,22594,249,3845
297912,5103,46,754
155529,6153,47,503
219942,17085,116,2668
574492,6854,128,1001
168294,1534,121,686
169567,10607,63,1109
4423,14,1,1
66561,2076,81,219
1003029,46851,816,5110
361668,19005,122,1128
44193,2398,48,504
379570,7277,88,336
17141,922,8,59
79278,2137,19,173
389343,16145,648,1686
64799,2682,92,511
49251,2667,117,547
176691,2678,76,0
1643721,196876,817,20294
37515,267,1,26
472673,6807,302,536
164418,8455,95,697
282517,13476,235,1461
301846,12304,332,1094
156890,10461,143,1203
1176315,24871,324,3580
178178,21441,87,2160
38815,1843,65,217
133633,1091,62,263
11479,114,3,18
294516,17027,285,1634
44064,2090,19,381
65950,2666,60,275
1738774,86544,1065,7331
1310057,49175,5122,5204
4480,10,1,1
11405,52,0,20
208351,6607,151,393
1079036,59445,604,3476
36422,1957,35,174
54597,203,4,52
3712190,157379,6294,6800
51566,3384,15,210
700959,6594,518,372
80831,6012,49,349
24469,214,5,8
79750,810,84,654
91901,521,22,182
1781035,8065,2134,3406
307070,5903,88,298
18744,1830,46,264
61930,4848,137,699
3922,164,1,12
528181,13681,471,1552
48324,212,14,192
682183,4031,727,306
829812,18104,1076,5788
17103567,510961,7471,21543
1652,0,0,0
5551822,191391,18105,20256
94145,2453,19,150
173097,6393,67,507
3375,110,2,24
48285,398,157,151
1429624,21306,1092,3202
368227,4926,373,1526
357451,13246,509,1302
259280,4836,69,205
640152,17172,263,2225
41959549,1502097,30036,104931
1020005,48113,635,1759
2278,40,1,3
193657,3562,120,520
1887621,136668,5483,23636
6069,64,9,67
402852,12353,468,1793
121465,410,12,78
198240,528,31,113
753796,51505,1018,5055
441996,17730,349,1624
485863,19840,397,2357
119431,274,62,8
68354,267,18,30
132372,863,877,495
812393,8917,216,1003
25668,167,17,43
51715,833,99,341
422907,21220,530,6711
4127885,157808,2031,7615
42486342,678389,13995,48429
642541,50546,2044,4125
3522790,83190,3130,6646
1266653,30128,2676,4163
4536443,298899,12046,24881
963827,17819,3230,0
226723,20366,59,1768
976036,27556,861,2401
615689,1204,435,1551
2165527,49772,4466,15358
716411,15802,982,6102
78516,6505,94,1016
75409,5368,81,894
320373,2498,144,0
4079439,198515,11430,21504
539931,40930,1249,3228
105776,3264,77,189
1680538,79873,810,20224
284569,11054,279,1279
5288444,537629,3059,59951
64237,358,139,910
1313821,96778,1555,9813
1132513,41112,269,1966
1538720,33110,1071,5084
4787872,59904,1247,3796
2471353,115101,1149,8206
169217,8851,124,648
514063,18922,1042,2429
86630,3891,96,511
180251,1967,70,290
564037,23233,447,2126
169622,14262,111,1022
85682,3891,65,357
254186,8442,366,309
712039,3202,143,582
188855,6463,419,671
238222,9559,169,991
62755,2466,71,329
1169747,35829,469,4710
136882,1582,39,116
81579,147,122,146
122743,8270,278,1987
70063,3058,77,404
69804,1896,88,325
23891,1832,26,408
2137698,22501,4440,6835
288594,6333,1612,1049
887511,36074,286,1734
1155429,48014,916,2990
454395,49935,168,3935
999134,11121,784,2211
3733990,247808,3871,24296
656697,22667,419,3212
301382,8188,63,261
436552,2755,334,836
322612,6528,1718,1400
1173233,64032,1667,3646
149030,5641,160,583
2845369,152485,1645,8941
5997233,366396,22885,39626
140396,9704,45,440
2161849,45013,917,7757
91494,3254,55,349
50627,482,17,188
323012,13860,520,2221
565953,31732,583,4296
590971,26539,585,3046
99052,4562,87,414
362703,30824,140,5376
4488542,34620,7120,12812
8443106,86006,15504,2381
208059,12670,173,1688
296175,14899,555,1540
225614,7364,128,461
87647,9892,81,676
2858059,48221,2123,7710
46374,6607,31,436
1390420,52421,822,2744
248677,16864,310,1488
1023116,52624,1196,2581
572673,15239,1848,2378
367150,11030,354,651
1584492,36839,1191,4421
3056926,116450,8996,7885
126230,1048,6,76
221250,11998,500,1481
68546,2501,79,223
2035314,36284,1486,4335
245888,7145,150,1309
87405,3301,271,508
702730,30460,762,3693
520296,15272,521,1868
718596,38537,1639,3602
1596463,37556,1143,6731
1118547,44534,736,3150
12910204,422882,8965,21513
1825263,81517,1065,4470
153017,898,153,452
211143,6046,227,1886
59716,3195,15,228
1553350,58276,788,4556
133423,244,489,416
76931,1561,19,175
2119829,82502,1996,4192
151954,316,63,272
36485,292,23,44
721980,86391,443,4578
602815,13357,203,510
679429,29583,872,2118
524890,14483,250,558
91018,4247,32,241
1199747,63190,694,3519
961630,24565,961,2753
3306407,11439,488,1748
47379,245,4,30
68015,11626,30,634
16565,1836,46,327
69631,1987,328,757
14850,146,35,81
446098,10480,638,1090
22138,592,19,242
12283,160,4,50
262755,13063,539,1255
237646,2348,2269,0
113560,7870,37,569
27722,803,25,145
519840,21284,485,1597
142197,9670,111,509
253051,6820,536,585
162673,471,511,1287
21831,1439,21,104
79305,150,14,78
99523,2001,102,838
30846,453,17,435
3304517,111608,1664,8363
536636,20794,419,3367
42830,799,44,802
1666770,58947,1989,5079
174960,9612,103,997
11194,149,65,0
847391,3371,2409,1026
986531,26725,759,1124
21964,185,2,37
593380,27948,283,3416
1084891,30372,660,5581
58927,360,3,35
670146,7035,336,510
3908505,110579,5810,19255
502408,27548,8341,10614
5521935,20493,3057,2473
1811695,54889,9218,37639
209125,16838,410,2123
34699,68,68,179
369291,19276,125,874
5189738,112564,2447,12560
90031,5621,68,1409
228946,17504,120,2399
193761,4142,874,2821
461958,23579,262,3626
596413,6997,138,1078
3228546,20684,806,6524
83352,2208,20,144
140601,313,6,184
179839,1599,121,584
513419,37319,284,2575
466862,8145,74,1094
162308,6351,47,521
5271,24,2,3
399859,16526,654,1774
70544,2845,96,554
1495741,61167,1245,6120
37838,118,4,8
18149,955,8,45
51287,2714,120,430
398188,7578,88,369
183702,8817,98,727
183893,2749,76,0
978732,2696,78,725
1676941,199329,827,20462
483878,6864,306,440
327306,12975,343,1188
161741,10624,146,1261
303834,14133,258,1551
184723,21972,89,1911
49664,2208,20,303
13281,130,3,19
1392850,51383,5449,5436
136608,1105,62,276
1792986,88029,1090,7328
6945,16,1,1
11637,54,0,19
216646,6779,156,430
38261,2007,37,173
41576,1923,69,219
317307,5983,89,290
1112617,60270,612,3580
4874,172,1,0
54889,203,4,101
3797928,158760,6374,6843
82372,6095,49,350
52158,3413,16,209
706428,6634,523,377
25634,229,5,8
93106,525,22,184
80080,811,84,656
20442,1870,48,258
66845,5118,142,656
535746,13789,477,1555
923240,2158,842,2324
3308603,61904,6165,19373
410554,34871,312,3111
169101,9519,203,1442
1214081,22986,1435,8195
46997,162,24,8
1367471,69538,869,11670
883631,8847,833,1123
630265,33841,457,2182
1913354,129734,4309,15167
428136,14200,604,2336
10944543,333469,22685,31858
697385,3302,351,0
923053,51919,1789,3947
1715858,96449,1271,8973
124327,3231,205,393
16673,109,55,330
192888,5026,139,318
31927,2094,27,115
36381,353,19,97
37960,1555,40,138
794308,36054,693,4680
49149,2132,47,352
3635,94,8,27
309703,11458,285,1361
83906,422,188,1149
1968298,86210,910,21538
673896,3294,247,393
184411,11559,475,1415
1570154,48976,338,2222
430729,20603,230,3756
8092992,654224,4749,73710
888653,13329,4296,2607
142510,9380,134,1424
33720,2275,44,479
1101130,4655,201,558
146365,7248,131,1210
1733462,108812,1883,10698
668168,21169,1443,2311
351831,11515,288,1193
3150013,131964,1511,9155
116241,507,11,108
104553,4390,110,597
203117,10895,460,2545
99106,4353,78,362
5762348,68932,1424,4043
189473,2015,73,146
92135,165,143,197
76164,2838,83,285
56633,601,3,83
93114,1070,5,81
175751,1877,42,140
674344,26025,547,2342
81668,2095,103,378
31913,2573,14,560
20878,266,4,115
1275732,37493,503,3601
446859,10441,93,355
286064,8837,406,315
228082,7111,548,742
1880966,37113,1235,4211
116817,411,11,106
2237809,23183,4577,6973
174973,4720,100,542
1040702,41671,320,1708
558988,56447,203,4159
5743857,108710,2180,5849
47906,358,58,438
195256,9450,142,671
4272766,259500,4137,19035
174169,11308,54,498
1088162,12106,868,1789
78907,3688,151,667
1560453,74601,1996,3552
1213659,49375,937,3003
6444,7,26,17
559269,3332,411,635
717397,23899,442,3329
722622,35817,730,4923
2142939,75357,1695,8481
42929,6640,17,752
362609,7037,1853,1573
163136,5999,171,491
2333091,46798,954,5702
332897,16174,613,1378
256804,7821,141,366
135115,12921,125,805
394413,15785,590,2065
6108995,369960,23206,38850
3037043,157871,1779,9107
2331,101,0,34
170208,1305,8,85
648074,28201,626,3133
547781,30162,1175,3414
23907,601,14,63
108987,4855,97,374
432274,32792,160,4534
4633097,35110,7231,12823
64637,165,25,20
1725988,58874,967,2894
1326308,60048,1488,2269
2963359,48973,2173,7835
397928,11689,378,345
261318,17396,318,1276
51725,485,17,176
291155,7519,163,1398
126103,15922,53,809
1640351,38241,1160,6931
107323,4757,35,560
68071,639,13,223
194946,21601,369,2833
53659,258,4,32
614701,16028,1911,1660
3501122,123552,9635,8211
1644818,37538,1218,4278
245466,12719,537,1506
718952,18342,668,2121
868727,35003,944,3751
96935,3537,291,589
2259132,38692,1573,4566
110540,726,38,49
757894,85209,341,4491
967027,44203,2429,4214
656551,16655,278,489
1261476,47347,798,3205
181885,1037,189,344
235698,6319,235,1990
152657,273,526,329
1726466,60570,875,4609
13686030,432761,9366,21853
251940,14092,215,1817
83980,2119,351,620
630442,13712,207,503
69148,3526,16,229
168663,474,8,51
75040,2655,81,150
51836,271,5,32
1436828,69432,702,3635
1771265,109489,3629,20727
711888,30520,903,2137
2227312,85406,2060,4287
3447187,12241,535,1743
130634,8583,40,646
385794,20110,476,1232
1016803,25296,998,2705
97159,4454,33,248
83103,1612,21,140
158271,320,63,139
19549,342,19,47
31832,843,26,128
17813,1946,46,336
454792,10554,644,1001
14954,146,35,82
279648,13618,561,1175
256920,2511,2427,0
12484,160,4,36
549701,21979,505,1567
23399,1509,23,108
1929955,63428,2173,5218
100132,2005,102,707
574712,21584,440,3446
32868,467,18,350
3570409,117856,1786,8467
44415,807,47,708
12874,168,69,0
180101,9815,105,995
30998,197,2,17
2141594,74966,1640,5891
635321,28975,306,3480
81765,163,14,83
1003018,26958,766,1039
3342091,21362,826,6283
512715,27850,8421,10694
802484,7945,372,482
72015,407,3,41
4140581,115696,6029,15531
1156241,31173,684,5492
63613,662,20,215
141077,313,6,185
605846,20424,343,2042
855071,3385,2410,952
81473,1567,80,306
168447,6496,48,433
91748,5671,68,1395
5344092,114278,2547,12399
35876,68,68,183
76475,2966,100,375
195210,4152,878,2807
617634,7179,148,946
375746,19518,126,789
993070,2755,81,745
187464,1647,124,597
84959,2236,20,144
237390,17826,127,2379
552088,38959,305,2532
526878,9084,86,1142
191731,2828,77,0
6003,25,2,3
410542,16886,656,1746
18873,977,8,45
1637737,260973,7112,30291
1096173,2829,1123,2891
417737,7266,654,940
2278284,138867,7075,11177
786180,19277,1208,3325
1266615,11559,1233,1073
704347,48975,539,3704
4008285,68586,7088,18631
85423,2984,87,504
65906,1662,79,702
66350,2311,72,190
1826346,82531,1335,12968
71253,791,38,166
1436119,26322,1637,7029
69018,284,88,47
1131274,51599,846,2744
15906476,415015,29656,31425
1002047,4241,337,545
818523,3466,443,0
41057,2505,41,114
1285658,60836,2296,3942
2119461,111692,1616,7842
24604,98,8,73
970110,39891,1087,3914
84599,422,7,50
249984,6464,176,321
4045,60,2,13
321319,11727,334,914
27261,162,68,434
596689,24700,357,4613
1867066,54223,389,1996
115658,4699,120,448
1213185,16816,5552,2636
2109838,89454,972,17024
208478,10812,238,1549
10024916,718746,5925,129295
238734,794,156,654
1455468,5633,252,695
55530,4186,41,760
749633,22523,1666,2550
408663,12463,388,1423
2082055,117075,2092,11432
174176,8168,150,1298
64175,9952,23,942
3556291,142845,1698,7679
41216,380,13,202
740221,27888,603,2140
245955,7394,572,626
41860,1867,42,144
11287,156,43,48
89671,443,212,1259
110621,1243,7,83
128014,537,11,103
121754,428,11,98
537024,12269,102,344
63996,451,5,34
273138,13901,653,1632
159483,7010,471,2436
1356350,38935,519,3713
2059052,39608,1328,4516
251949,5931,131,495
197295,1989,45,153
106937,4630,86,326
6732107,78732,1625,4562
178179,10352,184,1331
84097,3048,86,297
2307502,23661,4651,7508
626024,60537,222,3494
1145233,44955,338,1807
8306967,132375,2987,5825
306432,9181,424,332
63026,643,3,81
191541,2030,73,142
200973,12480,60,463
6959,7,26,15
77356,1030,39,96
157482,14411,138,840
4719710,268422,4355,19587
56967,2539,47,196
1274795,50759,967,3130
176598,6306,178,508
1112947,12288,881,1733
87546,2223,110,380
2026,293,2,46
1848865,83254,2229,3681
390932,7406,1882,1059
794777,38085,803,4038
639015,3677,480,663
437070,16924,643,2226
193076,1445,9,117
50473,376,59,441
2291405,78074,1776,8720
362788,17129,657,1411
753615,24686,454,3424
161495,18226,73,907
2425974,47999,983,5907
690445,29545,668,2325
207592,9866,144,596
104945,4279,212,760
297168,8600,166,390
3192268,162406,1918,9412
2107590,65772,1164,3043
478859,33924,180,4660
249649,24401,470,2639
1030571,22581,924,1933
421861,12214,403,340
89079,833,15,295
65257,178,25,21
37934,2479,46,536
316788,7762,176,1184
158833,6709,41,580
6195810,372698,23509,39002
1606071,65930,1728,2555
4744487,35529,7328,13000
30016,0,0,5
3034617,49460,2208,7851
174072,306,593,354
117390,5116,102,385
647635,16702,1983,1661
2744,110,0,24
1681905,38789,1175,6025
272650,17850,330,1308
52149,486,17,179
109216,665,6,62
951880,93104,403,3896
265566,13331,650,1093
3908556,130876,10145,8631
994793,38503,1095,4208
269710,14871,223,1352
252480,6510,249,2039
1186569,49541,3122,3943
1692234,38123,1245,4421
2422323,40267,1631,4766
209998,1204,227,366
348985,25754,267,2383
1353041,49055,840,3295
140678,9064,43,174
516012,23749,610,1191
123721,765,40,55
14268704,440252,9691,22709
76413,3777,19,274
94481,2268,378,641
863376,19817,330,494
1893150,62777,937,4728
389554,17904,182,817
1764566,76720,810,3885
649648,13965,211,529
238056,594,10,54
103619,3710,304,608
80101,2803,87,152
1887547,113726,3802,21940
34054,689,143,556
3573095,13117,570,1964
18921,2060,47,263
739380,31247,933,2196
2297767,87281,2101,4406
22807,363,21,42
104314,4690,34,214
1063469,25933,1035,2754
163494,332,64,124
88756,1662,22,146
15055,148,35,84
23938,611,19,260
296391,14200,584,1101
57920,303,5,33
572561,22530,517,1566
12550,160,5,38
244780,18129,130,2412
601477,22180,456,3547
24680,1570,24,95
2631028,84144,1975,6565
81444,3075,104,376
166374,475,515,753
2127628,66578,2286,5394
13926,173,74,0
34646,871,26,133
34169,473,18,364
3817132,124327,1899,8723
459829,10606,649,1018
41339,203,2,16
283161,2756,2668,0
665284,29719,321,3603
115959,1151,34,403
1019216,27185,772,913
666975,22108,393,2162
4371133,120224,6256,16017
83321,165,14,91
521239,28094,8481,10767
1208539,31730,717,5625
936934,8801,410,465
186806,10071,106,1017
173937,6617,50,439
93587,5748,68,1421
36590,69,68,194
5520173,116310,2655,12591
87183,444,3,45
192689,1689,126,628
381003,19719,127,809
630383,7245,149,957
584148,40300,327,2546
2156199,165137,2741,12872
20565649,1477400,46419,501083
4470140,436577,14015,44482
39957,243,68,115
189480,433,54,374
897188,66377,758,3147
150138,1031,594,0
259524,8520,204,892
14810,48,89,29
521816,8418,777,1041
312940,34360,282,2698
1137938,2928,1170,2994
441539,2855,303,207
133975,1456,92,955
866903,20155,1336,3554
103981,3250,101,363
2372757,141478,7633,11593
1046256,4331,350,551
1389767,12413,1323,1144
72169,1697,95,714
11162,81,5,26
14592,181,31,71
770773,51500,585,3760
98793,1028,51,220
4167511,70130,7297,19103
54489,566,30,43
32284,134,10,91
1583985,28117,1754,7542
1917979,85520,1401,13253
1456100,60349,1018,3252
19496639,464077,33969,34684
839473,3497,465,0
74851,298,99,75
106831,537,9,63
1518921,65519,2543,4123
696564,6750,298,1007
279609,5875,230,1435
2258594,116424,1703,8218
1022750,40957,1146,4086
242455,804,165,683
78417,2580,84,201
289562,7308,197,339
212211,3996,229,1134
640425,25613,388,4776
30851,176,70,381
45878,1915,49,148
1273718,17446,5777,2742
64946,4632,55,847
2019673,56451,410,2069
325921,11841,340,928
1671764,5823,259,734
134527,973,18,131
229795,11344,248,1181
2166127,90576,985,17373
184486,8511,154,1335
120171,4821,121,465
432877,12894,414,1461
240137,12298,554,2044
775666,22997,1719,2658
44830,391,15,208
44769,2636,45,120
111194,4753,86,340
3758620,147598,1788,7908
87316,3121,90,300
69415,10673,28,967
2682383,5868,1124,1088
2309878,121433,2210,11722
182338,7399,544,2567
764433,28628,611,2183
90855,447,218,1287
12061,163,44,43
207643,2054,47,164
255786,7520,582,616
584775,13064,110,363
116055,1298,7,88
132098,547,12,107
201056,20539,129,2309
123752,430,11,103
297151,14891,704,1352
287017,6382,143,518
66890,470,5,42
13088725,152522,3728,6546
186925,10704,189,1382
1396686,39600,530,3784
815100,16704,2650,2221
2123895,40479,1362,4661
7205566,83018,1694,4758
241868,120,33,68
653088,61992,235,3549
212393,10018,144,596
216293,13050,63,483
181824,6416,180,510
207382,1522,11,123
65363,660,3,84
192465,2035,73,142
7076,7,26,17
61760,2659,51,222
166760,15047,144,757
821174,38797,831,4163
315054,9284,432,352
90003,2265,112,381
668418,3787,496,699
2309,323,2,62
2023068,87493,2352,3852
409434,7606,1886,1033
2348649,23861,4687,7602
1128296,12387,889,1786
4990025,273904,4489,19878
50833,377,60,446
2355458,79208,1803,8886
456727,17396,662,2273
773318,25113,460,2856
177799,18991,76,817
382932,17755,694,1453
713595,30267,689,2306
2457564,48412,1001,5911
1303319,51271,983,3175
120886,5223,107,389
2454699,70774,1329,3224
3280098,164955,2003,9557
111887,4525,220,777
232176,8955,65,739
100431,994,17,479
501481,34453,191,4710
1263070,25846,1156,2102
289948,26177,580,2792
432116,12438,415,354
336237,9224,183,401
391886,27344,281,2448
39242,2549,50,546
65590,185,25,23
330142,7888,181,1207
1722773,68058,1811,2687
4804702,35719,7384,13126
129872,4304,256,306
6232518,373822,23701,39139
30569,0,0,7
187130,329,640,382
1076924,96984,441,4114
277370,18001,332,1316
1706050,39128,1187,6046
132561,802,45,63
14584270,443686,9837,23040
273266,13511,672,1106
2897,111,0,27
52297,487,17,181
68172,2574,46,1554
665175,17027,2025,1695
4207937,135747,10549,8919
110762,682,6,67
1288857,51183,3343,4085
1077745,40698,1186,4358
1725401,38563,1262,4655
281272,15369,227,1392
2515073,41055,1649,4891
261706,6619,256,2076
144101,9213,43,185
3630632,13356,576,2017
1009116,21739,361,522
233065,1310,267,393
1401126,49939,863,3359
601281,25610,688,1308
37565,719,159,569
101864,2369,395,672
2073282,81943,926,4026
2349189,88828,2138,4511
79307,3866,19,228
291948,687,10,70
370459,18295,208,604
2023559,64554,990,4823
1950758,115649,3861,22506
106165,3775,309,615
81787,2841,88,154
659697,14127,215,527
752806,31620,937,2243
19430,2098,48,282
25122,371,23,44
107466,4795,35,216
92736,1677,23,152
165869,338,64,128
1086895,26232,1048,2811
15110,148,35,86
24287,616,19,263
3909063,126631,1938,8850
59537,316,5,39
307150,14532,595,1148
583057,22779,529,1600
40316,955,33,147
2897548,88352,2139,6898
25335,1593,25,97
12596,161,5,40
2218529,67635,2334,5479
614220,22436,461,3610
249669,18306,132,2428
166754,475,515,799
14482,179,76,0
1043228,27537,778,918
35078,480,18,368
462950,10627,649,1038
49020,205,2,19
4625554,239109,4764,18552
4635501,486941,4425,52345
625564,15697,333,728
518667,67734,584,3729
421035,674,150,639
2334998,107660,1522,3911
1096866,3080,202,406
396270,1690,1571,0
6565409,506059,17172,49378
108607,2612,101,349
72949,376,128,176
30424471,1762154,63962,582505
334449,28110,208,1662
28770,1265,18,33
40279,90,205,61
7300,31,15,48
433796,11759,325,1265
535497,4107,207,2050
513994,3160,359,223
101991,3798,20,276
1155526,2960,1182,1990
571327,8965,822,929
181833,1749,131,1192
54660,1744,30,133
896828,20598,1377,2958
115053,3442,114,381
2403392,142706,7749,11482
113359,1180,61,268
1445091,12846,1357,1147
86479,1630,207,0
808723,52869,600,199
62052,621,31,47
37509,766,28,161
275103,1385,77,924
37129,162,14,90
29890,3493,64,1209
119257,620,15,59
1710691,29579,1848,7783
4271785,71113,7431,18958
844316,6995,329,1038
2001345,88385,1457,11496
1062091,4370,353,471
22787997,502550,37534,36467
13146,92,6,30
16405,191,37,74
74575,1703,109,710
76653,303,104,72
308977,6028,240,1166
50122,462,30,123
1703268,67588,1123,3373
69911,4839,61,891
1697775,68596,2716,4298
52571,1481,89,217
2365244,119814,1738,8259
1057885,41614,1169,4008
846964,3499,467,0
239976,11634,251,1207
663057,26140,404,4840
31643,178,71,393
226165,292,74,105
1285313,17588,5802,2748
322949,7949,210,361
341006,134,36,72
28810,880,47,172
2125368,57481,419,2083
216981,4027,236,870
204819,6128,80,195
243641,804,168,663
1873381,5925,272,739
248787,12683,566,2096
446594,13138,424,1379
83737,2734,87,204
193333,8807,157,1137
144176,1015,18,100
2206513,91417,1002,17577
793296,23330,1761,2695
46267,399,15,173
11807,6,0,3
328471,11909,345,932
2517566,124875,2318,12000
190535,7674,561,2688
47859,1957,52,148
2725727,6135,1173,1114
12241,164,44,40
3932117,150973,1861,7990
7671071,87309,1774,4988
133926,552,12,100
620288,13768,111,369
91572,448,221,1024
118997,1326,7,81
785534,29246,624,2218
68323,481,5,40
123686,4915,124,453
124783,433,11,98
72510,11074,29,924
314005,15492,736,1318
215640,2105,47,169
18049506,170704,4453,7137
222861,21781,141,2412
192937,10880,192,1376
1432644,40113,539,3919
303550,6567,145,560
264265,7636,588,642
47144,2747,46,127
321702,9354,436,317
2162234,41029,1384,4737
114628,4858,87,358
675747,3818,501,654
89908,3194,92,300
173696,15462,148,742
66770,664,3,78
837476,39221,841,4158
677750,63205,247,3616
7105,7,26,9
2172912,90920,2464,3956
63069,2725,53,162
91934,2295,112,309
229930,13548,68,458
139724,4427,259,310
396776,18156,716,1487
2530,343,2,57
3494642,167254,2053,9637
2379689,24008,4725,7665
5269506,279221,4628,20095
2431612,80519,1845,9098
188774,19494,76,807
425684,7817,1893,989
469986,17748,676,2303
1143644,12573,894,1794
51110,378,60,433
2821217,75477,1511,3302
338639,11874,93,833
732455,30759,702,2332
1330370,51789,1002,3166
2484262,48767,1003,5905
810957,25731,474,2905
185996,6512,184,508
515000,34725,195,4722
117199,4674,225,539
5094573,35901,7435,13233
105364,1110,20,520
215703,10145,147,587
6487891,374650,23914,39143
1363182,27099,1231,2167
390318,10029,202,382
326693,27486,652,2870
216615,1568,12,111
429424,28623,291,2208
40253,2603,53,539
441208,12597,420,343
4586837,140252,10905,9075
1871223,70586,1892,2677
66379,199,25,17
1188144,99962,468,4196
1880716,39506,1296,4879
196051,341,678,401
31022,0,0,5
2698525,42006,1676,4896
652319,26543,755,1370
1194873,24125,417,565
73070,2741,47,1570
2405051,86541,1032,3995
123110,5293,109,388
2987,112,0,21
1140752,42201,1238,4564
3748847,13529,593,2043
52452,487,17,164
680886,17339,2054,1641
1804386,39600,1196,6153
1467301,50624,883,3411
111721,689,6,66
280740,13672,680,1096
2052315,117171,3916,22817
387545,826,10,64
85702,4143,20,242
1378839,52778,3534,4153
427661,19658,234,602
291348,15749,233,1330
269360,6721,258,2141
2196661,66128,1039,4482
287938,18190,341,1316
249817,1423,309,388
139713,823,47,57
14960281,446880,9969,23381
248683,9224,232,1101
86012,363,21,54
146530,9308,44,158
169667,349,64,116
83476,2890,89,139
108375,3818,310,620
45295,756,188,641
1134302,26432,1060,2803
19856,2132,48,260
2455839,90328,2160,4528
27551,379,23,41
788466,31945,945,2274
107927,2435,412,641
109222,4840,35,212
626223,22962,532,1559
99228,1699,23,135

GB_video_data_numbers.csv

4394029,320053,5931,46245
7860119,185853,26679,0
5845909,576597,39774,170708
2642103,24975,4542,12829
1168130,96666,568,6666
1311445,34507,544,3040
666169,9985,297,1071
1728614,74062,2180,15297
1338533,69687,678,5643
1056891,29943,878,4046
859289,34485,726,1914
452477,28050,405,2745
258781,8085,303,726
274358,9215,477,838
473691,14740,415,1696
514972,18936,641,3817
282858,14870,300,1398
1582683,65749,1531,3598
479951,23945,640,1941
2693468,7941,302,1432
815608,66420,3578,5550
382525,1521,270,1168
703750,2921,2196,1042
255967,21817,293,2017
96872,3498,482,439
743947,6126,352,2438
10535242,384920,7550,23855
483360,16258,245,1588
3298456,65730,4360,9504
321297,15424,280,3317
752844,42290,359,3250
602127,19575,658,2510
136643,6218,127,524
244433,9143,6826,4838
917643,25456,731,1073
796896,39791,1252,3868
2932,71,3,15
224532,490,772,597
246389,15314,247,1842
165647,3712,142,524
162818,9531,416,1079
163656,19183,137,2154
220661,2070,449,352
142039,9889,130,1224
807779,26521,522,5996
1936893,74587,1060,6558
279903,4389,138,338
262875,1069,183,0
185541,12179,115,827
27794,1692,34,174
315347,19538,204,3172
46622,345,47,149
668027,3553,1629,889
1026622,61409,967,4097
1862110,38823,1999,6229
148998,2123,101,435
182676,3752,165,1163
379817,14096,323,1338
103807,119,23,67
44621,4165,121,537
48688,141,226,256
141532,9467,55,956
7740,70,1,7
16059,139,9,12
4618045,104899,2180,11355
4661584,17517,2543,2157
320880,3858,104,675
94123,520,34,96
134994,13901,69,1087
135280,2032,17,368
229235,9746,292,1119
14577,160,19,51
14706,1619,33,201
543283,33686,931,14935
39338,2377,103,484
62884,6003,72,364
196016,5080,56,434
2526119,17110,677,5311
43199,3263,7,294
1157495,15333,990,4641
42734,0,0,0
16653,83,10,27
416462,20164,297,2597
470206,942,137,582
2604761,28651,2256,6878
332176,14279,626,1927
7189818,26771,3925,123
330895,18023,112,1017
230701,11767,184,1519
358661,3498,24056,6420
101248,4679,93,331
498183,6300,112,789
1462030,74679,1502,3881
4774911,32276,12757,4103
2433292,123805,1069,9275
295156,10918,149,781
165849,3391,297,374
322896,8516,470,663
1617247,83419,1014,7114
185928,6156,129,320
265833,3995,197,256
28038,845,41,344
91229,270,62,211
188162,1990,266,192
157437,19869,78,2027
329459,1158,188,439
1153128,45408,4311,5708
1769252,8048,2123,3359
381229,11618,452,1663
260164,2405,121,259
1275489,2678,494,895
9025,53,1,16
13892,327,29,86
216040,9301,140,349
2036428,41039,2671,15607
50155,251,27,146
659749,3964,712,278
1007014,57545,570,3333
7410,48,2,0
158816,206,67,153
2330211,4893,938,381
1002,8,0,3
622951,13260,493,1751
92783,6491,54,339
352284,13099,508,1297
8692,340,16,36
788310,17141,1054,5521
113400,1049,20,297
163404,3337,111,447
352119,12880,195,517
119124,742,48,404
7009,45,0,9
92656,895,22,143
53712,203,4,25
763632,51890,194,4852
5044462,183483,16582,19443
2874,104,0,15
1307902,19734,984,3029
19431,87,2,10
229636,7897,47,781
171000,454,85,290
1812471,133824,5380,23176
11830,200,3,22
1851893,24779,2844,2242
4801,28,0,8
55214,258,5,99
116337,17,10,2
387873,12099,458,1771
406327,20499,516,6361
108653,3606,109,699
77640,2223,221,390
173773,9188,166,876
1106140,38670,1576,1470
952945,17703,3207,0
277903,13343,212,6348
700036,49257,995,4863
2384595,50009,1918,6584
1712,15,0,4
13794,40,49,0
834567,20322,876,862
443606,4231,68,246
1493731,23472,3490,5872
13728070,468636,6597,20989
4850078,146460,8649,4896
108839,3677,107,732
614717,49443,1986,3970
1244953,29748,2639,4112
1862718,21516,1960,2108
2114219,77679,1874,4529
11533,51,7,29
109422,200,14,0
349856,4403,140,335
447037,25068,710,1299
226012,9353,156,1282
3998451,291383,11624,24246
82199,1194,51,194
41962,1445,50,268
36323498,1431683,28049,100661
25652,73,11,62
7563,344,1,21
845694,64515,625,4325
316616,10084,104,331
3027926,76505,2880,6414
463409,19286,393,2304
4761358,50802,1128,8606
376381,8909,170,334
30851,261,65,49
13752002,46101,4898,0
433708,24188,712,2383
2465146,179085,1567,11973
836472,19314,1206,0
599780,29851,299,453
106186,4695,193,396
626600,20553,1033,2138
384682,21302,353,1559
2451184,176110,1017,6257
480279,26662,241,557
189414,7070,112,288
103666,196,67,80
74494,2218,37,159
1110865,11255,1817,3631
235562,1801,78,96
1798895,26425,465,2278
12200526,258842,44339,0
5457497,349857,17479,52483
3654879,30836,6101,16713
1398322,35880,619,6246
1568852,174771,2166,19191
558820,4847,259,1083
761705,32608,1562,6864
6997601,626155,46445,190979
504827,29220,457,2233
580441,2520,533,977
2084309,128402,1136,8733
909358,14539,672,1353
1119034,12843,560,1367
3087549,93812,3067,19758
380266,11558,1286,1783
83219,157,190,406
1673317,40496,678,3915
393968,10053,596,1191
990274,22897,639,2430
86119,1835,18,230
1668188,88182,5893,7373
705475,34506,549,3180
515740,37881,538,8313
367178,5296,199,2422
751902,22556,870,4638
1341911,33111,1035,4709
413029,18228,404,1671
1637683,76343,936,6052
87153,220,43,115
1130469,39886,876,2347
378178,25046,1112,2510
292585,16909,325,1845
41452,485,244,318
2741837,72782,7146,18239
586091,26816,778,2165
2995809,9467,371,1709
712467,33015,863,4018
159643,4389,651,603
1805185,72625,1714,4056
71109,4127,50,299
1091878,49500,538,3886
53673,1208,45,118
396448,1557,292,1368
50518,1237,30,118
11475555,398514,8158,24861
772128,21783,813,2839
310527,23994,373,2224
232505,498,793,642
22004,38,15,6
55614,2433,84,453
111776,4857,68,311
240156,7977,189,798
17777,15,0,6
478747,54551,306,3702
19105,154,20,20
13459,223,2,23
579532,17845,277,1852
65650,403,57,175
829793,6501,386,2582
429138,18017,343,3900
91333,6871,183,705
1461358,35312,1062,6077
22490,1939,15,156
93030,6162,81,564
229037,4137,157,587
3506621,67469,4459,8750
285838,31544,422,3563
35101,172,5,47
205103,10947,471,1206
971177,19477,1157,8125
1180879,47871,1640,4295
564175,33359,489,4152
61085,3797,9,362
213321,12990,138,1403
222206,21395,150,2298
675609,3571,1640,920
947706,25968,741,1139
111295,122,25,74
892442,27575,554,6161
219849,3905,181,1329
310292,4598,155,371
214484,12908,125,937
2511218,90146,1320,7936
116342,569,37,121
496275,25070,236,3634
86268,6084,48,686
81215,3716,228,494
40606,4296,11,605
267179,1071,184,0
376653,21239,220,3538
45843,2548,115,504
25912,1602,22,114
165684,15485,77,1180
12588,1330,4,119
70220,6395,80,388
1247138,68793,1092,4582
51223,0,0,0
59907,152,248,286
158781,10142,60,1003
410406,14671,344,1407
1918194,39488,2017,6311
179786,2642,25,466
19880,112,3,28
304490,10871,171,385
618587,35336,1143,16645
329508,3915,105,697
274315,16268,266,1965
4959620,18534,2723,2450
4830992,107674,2276,11743
150257,10185,137,1107
264911,11034,304,1231
1170059,15377,996,4695
54816,4499,129,640
364857,3521,24218,6501
2817086,18485,723,5728
9396,76,2,13
482681,949,138,598
151736,2153,102,444
24701,119,11,54
372944,15547,646,2081
56016,351,12,20
2711006,29072,2279,7081
19753,112,5,10
348472,18538,115,1070
7198312,26768,3932,147
252323,12482,202,1635
17270,1749,39,213
122462,5058,107,355
1490599,75508,1519,3978
352810,4636,239,331
541705,6617,117,901
5107032,33851,13164,4404
204553,5164,57,447
307749,11202,150,800
2555997,126897,1115,9470
426636,20387,304,2612
1681417,85017,1038,7196
197356,6357,142,357
170608,3442,303,381
28456,849,41,357
91906,270,62,219
168561,20645,81,2100
329907,1158,190,434
1043993,58482,588,3389
1228127,47168,4719,6048
16296,361,32,85
1297769,2727,514,934
1774499,8057,2128,3396
200970,2034,271,199
11811,401,17,50
415382,12329,469,1746
10892,60,1,26
2064406,41329,2694,15667
273256,2408,121,263
50537,251,27,150
667703,3996,722,280
137388,974,76,691
9354,53,2,0
326281,8616,472,680
168512,224,72,182
2333602,4894,940,445
1097,9,0,7
645414,13560,495,1792
103175,6708,68,345
122620,756,49,445
358204,13019,196,521
943682,59232,236,5468
808962,17617,1060,5684
180554,3458,113,459
8075,55,0,6
96468,914,23,159
54261,203,4,30
80647,475,23,106
2953,105,0,21
19468,87,2,14
5292941,187251,17328,19816
231371,7945,47,786
1361619,20383,1020,3113
1849541,135169,5430,23408
1984548,25976,2917,2345
15093,210,3,26
5266,29,0,13
456328,4309,69,264
58026,274,5,105
396083,12221,463,1772
122194,22,12,5
414089,20839,521,6595
110816,3644,110,719
79080,2248,225,395
177155,9287,166,881
1139838,39393,1607,1519
174184,462,86,303
723981,50162,1000,4923
920080,21350,907,909
1749,15,0,9
14682,44,50,0
5127806,149929,8827,4964
496221,7571,521,1215
1824481,135734,1086,16234
544518,11937,1186,2333
1456039,54715,374,4067
1009649,9582,917,2779
1921063,20278,4008,7615
224878,5144,1135,999
1202045,34089,604,1055
6570611,746023,6687,102758
667937,48069,1015,2956
3622082,47583,994,4017
755108,74326,947,10379
921642,22071,1030,9138
755399,8424,767,866
847140,9325,650,1943
134887,549,242,485
2889867,222514,3288,23539
1578630,63141,1198,8810
960930,42549,775,3130
15731493,321403,57528,0
5854127,361422,22023,54671
1262710,42471,2547,8880
1937598,42203,836,7351
146749,400,458,1018
4257519,33617,6882,18323
42993,2010,59,189
329649,13226,337,2726
283060,5432,191,477
168353,7105,210,241
69042,5742,27,337
47369,2137,41,201
198260,1170,1325,1106
118491,2130,96,505
149552,6076,218,521
37460,2789,38,250
239956,15696,228,1915
55165,3312,118,467
7706359,659184,50584,199406
320296,6445,346,1247
677009,3097,755,1405
1276245,17804,912,1662
92947,4578,580,735
2587501,144171,1481,9933
3970421,107888,3861,22556
21421,166,28,92
219193,7936,165,1008
517133,14122,1718,2237
54377,3602,73,660
8418,20,94,59
166176,2921,49,404
172189,980,10,125
1268813,13834,670,1251
83356,608,32,70
186264,7703,544,1421
1360621,85965,1959,14243
195726,19447,34,1449
131335,11843,65,937
71187,390,5,27
64584,6610,52,391
129102,2432,295,1314
545072,25553,585,3016
1879131,43783,737,4341
139837,299,63,210
1704887,31922,1348,5073
625573,42524,653,9323
170124,2614,68,369
22975,22,1,40
2453843,104520,7808,7083
431464,10379,628,1025
30563,192,3,21
52532,1340,5,131
205267,8686,118,1976
868054,24364,976,4644
495762,6520,252,2910
181104,6500,101,375
86623,1924,48,213
944026,40807,672,3650
78103,387,30,29
2782871,203997,1054,16847
3572241,86493,9501,22016
185529,9801,297,1009
686662,35138,321,4762
483683,20265,450,1888
15681,57,0,9
1494086,35533,1135,5328
927303,38322,1099,3667
21083,1115,18,156
1755094,79451,1038,6290
496221,7571,521,1215
1824481,135734,1086,16234
544518,11937,1186,2333
1456039,54715,374,4067
1009649,9582,917,2779
1921063,20278,4008,7615
224878,5144,1135,999
1202045,34089,604,1055
6570611,746023,6687,102758
667937,48069,1015,2956
3622082,47583,994,4017
755108,74326,947,10379
921642,22071,1030,9138
755399,8424,767,866
847140,9325,650,1943
134887,549,242,485
2889867,222514,3288,23539
1578630,63141,1198,8810
960930,42549,775,3130
15731493,321403,57528,0
5854127,361422,22023,54671
1262710,42471,2547,8880
1937598,42203,836,7351
146749,400,458,1018
4257519,33617,6882,18323
42993,2010,59,189
329649,13226,337,2726
283060,5432,191,477
168353,7105,210,241
69042,5742,27,337
47369,2137,41,201
198260,1170,1325,1106
118491,2130,96,505
149552,6076,218,521
37460,2789,38,250
239956,15696,228,1915
55165,3312,118,467
7706359,659184,50584,199406
320296,6445,346,1247
677009,3097,755,1405
1276245,17804,912,1662
92947,4578,580,735
2587501,144171,1481,9933
3970421,107888,3861,22556
21421,166,28,92
219193,7936,165,1008
517133,14122,1718,2237
54377,3602,73,660
8418,20,94,59
166176,2921,49,404
172189,980,10,125
1268813,13834,670,1251
83356,608,32,70
186264,7703,544,1421
1360621,85965,1959,14243
195726,19447,34,1449
131335,11843,65,937
71187,390,5,27
64584,6610,52,391
129102,2432,295,1314
545072,25553,585,3016
1879131,43783,737,4341
139837,299,63,210
1704887,31922,1348,5073
625573,42524,653,9323
170124,2614,68,369
22975,22,1,40
2453843,104520,7808,7083
431464,10379,628,1025
30563,192,3,21
52532,1340,5,131
205267,8686,118,1976
868054,24364,976,4644
495762,6520,252,2910
181104,6500,101,375
86623,1924,48,213
944026,40807,672,3650
78103,387,30,29
2782871,203997,1054,16847
3572241,86493,9501,22016
185529,9801,297,1009
686662,35138,321,4762
483683,20265,450,1888
15681,57,0,9
1494086,35533,1135,5328
927303,38322,1099,3667
21083,1115,18,156
1755094,79451,1038,6290
165983,7999,124,759
1271855,43039,986,1955
444082,40292,530,4308
180370,14836,247,3052
25122,205,29,66
1297760,5693,1625,3561
213820,5137,743,766
648273,28646,845,2352
3165464,10556,446,1616
96381,3045,458,419
18335,269,4,62
1985761,78518,1879,3926
75427,1558,63,186
1379413,55269,694,4383
46955,1685,262,648
27429,430,15,363
48562,2268,36,137
896164,23663,911,3139
124487,4471,307,617
342410,25617,387,2360
12208330,411682,8567,21046
41169,178,6,79
43981,7258,37,1537
282915,8924,209,942
654311,65224,392,4188
1004055,46870,817,5114
104166,152,39,36
650931,19203,309,2088
1546536,36722,1111,6460
77810,4298,16,419
490309,19610,386,3079
263630,4451,169,666
1072349,20846,1260,8703
3689337,69240,4547,9039
78220,2053,41,121
1424830,54077,1848,4710
46574,1530,36,251
234972,501,798,684
247504,14354,156,1554
287672,24003,168,2502
12954,0,0,0
32056,1051,27,153
151594,1214,65,239
88235,4752,62,395
95900,6507,67,726
971242,26435,748,1055
999412,29142,616,6399
118315,131,27,72
3012697,103685,1534,7761
240887,4015,196,1307
554486,26842,262,3918
36740,2649,23,206
17577,1654,12,160
188410,546,14,0
69071,148,5,33
64817,2682,92,511
267907,1072,184,0
406343,12581,213,471
186965,16782,81,1249
422306,22594,249,3845
33997,180,10,67
1465819,75284,1188,4244
32489,3979,12,258
76023,6729,84,441
56311,0,0,0
298016,5118,46,754
1968008,40143,2033,4709
49254,2668,117,547
169585,10610,63,1109
132165,638,48,140
682207,3589,1652,954
686381,36812,1322,15557
294571,17028,285,1634
5287771,19798,2919,2275
335308,3947,105,661
18744,1830,46,264
301893,12305,332,1094
5027180,110390,2363,12177
51785,4965,13,679
156899,10461,143,1203
1178955,15427,1003,4730
3101709,19954,773,6239
65718,159,258,278
154746,2186,102,467
368018,3531,24306,6466
61933,4848,137,699
4906976,2473,1582,36
216713,5329,60,471
389363,16146,648,1686
489523,954,139,602
34255,149,11,85
361683,19006,122,1128
282594,13479,235,1461
518533,5847,290,413
574541,6854,129,982
1516624,76278,1541,3989
143859,5489,126,361
2813499,29658,2316,7275
2751415,131470,1174,9680
5952,209,14,29
109331,2870,101,537
5502137,35892,13695,4523
2223,261,0,31
437796,20699,312,2277
201901,10034,148,591
119730,5533,73,693
140494,391,7,27
28768,850,41,274
208370,6608,151,393
10851,1023,8,111
59706,365,12,45
1738837,86547,1065,7331
585176,3334,1342,6369
4085560,198696,11446,21514
290939,6341,1613,1053
436361,7828,854,1188
616112,1207,436,1551
2167963,49804,4472,15358
1302666,22810,3615,5460
408822,3964,1156,1227
1040038,12692,978,2083
209816,2672,204,256
3542861,323439,5411,21570
713391,3204,143,582
374344,42116,229,6046
122900,8278,278,1987
238746,9567,169,991
347928,16829,527,2111
208156,12671,173,1688
2333182,155627,1463,18215
1681290,79888,810,20228
2473453,115156,1149,8206
251986,11494,163,1768
346500,9275,1606,1653
2137663,50615,1001,1655
2206069,66696,557,5332
171110,14306,111,1028
514723,18926,1044,2429
322790,6531,1718,1406
308063,950,547,947
64374,359,139,910
1173691,64045,1667,3646
132079,3440,142,244
656980,22667,419,3212
2138396,22501,4440,6835
1429515,232107,626,26197
1170082,35833,469,4710
693376,58213,729,8910
87663,9897,81,676
11494007,956288,10369,125246
1133919,41128,269,1966
91673,3258,55,349
1314571,96802,1556,9813
564319,23238,447,2126
1538991,33124,1071,5084
222677,15266,314,1019
745209,53345,378,3828
566224,31738,583,4296
454734,49951,168,3935
323077,13862,520,2221
45382,1268,7,146
254289,8443,366,309
15616,26,129,92
1257169,75023,882,11988
39638,246,2,25
35272,299,43,366
4789657,59921,1247,3796
79717,2793,96,298
296325,14903,555,1540
362844,30831,140,5376
293148,1315,1597,1094
999381,11123,784,2211
840615,9275,820,850
138512,5910,778,930
3735099,247833,3871,24307
162699,471,511,1287
1943149,71749,1593,9973
86655,3896,96,511
130074,4776,73,374
140404,9708,45,440
33686,200,33,133
97595,4829,200,648
1155840,48018,916,2990
142282,9672,111,509
384135,7137,240,645
12924,944,7,77
18082737,359392,64933,0
68044,11632,30,634
591039,26543,585,3046
112174,499,5,41
88087,4447,96,800
141997,2399,111,568
113565,7870,37,569
2162054,45015,917,7757
5997736,366401,22885,39626
99739,683,35,78
4489199,34622,7120,12812
395376,7594,428,1053
142583,2577,334,1398
47399,245,4,30
107072,335,6,34
63124,1481,6,148
14327,500,3,43
630887,8478,164,587
152008,316,63,272
172466,6592,234,590
257919,8634,179,1079
79920,5028,72,630
187405,2912,98,417
219423,3294,56,495
2846092,152496,1645,8941
50981,3376,42,330
8002631,672775,52253,128771
707295,3286,808,1274
200657,15624,96,1260
446140,10480,638,1090
27935,1361,22,206
1463155,90329,2104,14662
69693,1987,328,757
703033,30469,762,3693
146782,637,52,65
2036524,36292,1486,4335
3058570,116464,8998,7885
225692,7364,128,467
190020,2761,82,415
2047674,45956,823,3534
105494,2272,52,303
650478,43748,678,9616
507320,42844,553,4567
59733,3195,15,228
82625,15128,64,2344
232764,9435,138,2092
179986,1016,13,141
916980,25042,1009,4799
146236,188,50,95
197056,15810,265,3230
529834,6842,266,3055
1119164,44538,736,3150
213446,8965,146,829
287267,17652,277,2029
762446,37871,340,3578
4047407,93363,10688,19783
2970992,212293,1089,17391
519986,21285,485,1597
286237,14805,159,1294
1584633,36839,1191,4421
1825387,81519,1065,4470
1072359,41380,1225,3903
1355374,44935,1047,2096
1423205,6017,1724,2817
255271,5630,797,653
248158,11312,378,1169
51357,7892,44,1633
24817,22,1,101
217417,20907,35,1584
16405,0,0,0
3306664,11439,488,1748
123746,1238,99,91
12912064,422911,8965,21513
679543,29584,872,2118
152026,4878,350,695
68332,2777,41,193
1553895,58282,788,4556
2120100,82510,1997,4192
804340,73825,461,4530
35011,1262,62,421
66685,5936,21,311
83119,1695,66,235
365116,26710,392,2476
961827,24567,961,2753
100016,6696,78,679
67156,182,7,94
1496784,61212,1247,6124
305803,9581,216,995
105350,2208,48,125
100118,3156,466,429
26481,215,29,81
205498,12930,209,2479
30846,453,17,435
59135,1604,36,183
403747,1586,298,767
292661,4704,187,632
103179,169,5,81
95741,4749,20,487
1596548,37556,1144,6731
94842,5011,69,438
536693,20794,419,3367
43252,7930,20,826
20931,302,4,79
18089,1157,13,124
265660,14984,164,1378
52941,1719,38,319
1136677,21584,1318,8985
209132,1608,83,250
1667035,58956,1989,5079
355558,26495,181,2266
3794392,70200,4587,9142
235474,501,799,724
250559,4073,200,1361
1085106,30373,660,5581
986576,26725,759,1124
48585,235,14,116
3304860,111619,1664,8363
26054,1607,44,145
232082,632,22,0
556461,27542,295,2967
593522,27950,283,3416
70553,2846,96,554
123000,132,27,96
18614,146,10,17
40511,2814,26,259
1243,4,1,0
2557131,105292,4152,21600
5189928,249525,188836,101387
888666,13331,4298,2607
10944706,333571,22694,31875
1367572,69585,869,11670
958557,4449,1946,8408
124361,3239,206,393
428150,14225,606,2341
794350,36062,694,4684
184418,11561,475,1415
866712,13740,1420,2204
883661,8850,833,1123
2301798,111571,2980,6153
1913379,129744,4313,15172
697423,3303,351,0
3308652,61918,6168,19388
22200,258,20,66
142517,9381,134,1429
430772,20614,230,3756
494594,1757,222,1573
923246,2159,843,2324
630274,33856,457,2187
1715898,96479,1271,8973
300654,5195,592,942
722288,6019,2162,1957
78909,3690,151,667
1611838,26492,4288,6514
402819,4174,407,462
1318301,14943,1079,1724
643106,52876,365,6094
203117,10897,460,2545
649911,25885,908,3164
351832,11518,288,1193
1101135,4655,201,558
34240,1898,25,166
4175780,361052,6677,23243
63612,5203,250,2322
569448,12799,2209,1899
48720,713,9,67
2554293,164754,1597,18934
1968311,86214,910,21538
292896,12609,207,1940
104520,2039,23,260
37261,803,61,238
83906,422,189,1149
2373665,277868,1006,24267
3150095,131981,1512,9159
668186,21171,1443,2311
225785,6143,127,537
2856877,62776,1268,1500
382515,1132,659,1094
47906,358,58,438
174974,4721,100,542
2497096,72029,621,5921
135116,12924,125,809
385798,20113,476,1232
195492,4244,182,289
362611,7037,1853,1573
36900,2091,74,452
126103,15926,53,809
722624,35824,730,4923
1560465,74611,1997,3552
46311,288,8,22
1570276,48988,338,2222
31651,1532,24,126
852121,65212,911,6799
717404,23900,442,3329
2237810,23184,4577,6973
13501685,1013883,11581,157635
1733474,108832,1883,10698
1275738,37495,503,3601
885969,9772,849,730
674348,26026,547,2342
207054,19325,176,1870
871707,59110,427,4096
558989,56452,203,4159
394417,15786,590,2065
251942,14093,215,1817
332898,16175,614,1378
95229,3135,108,318
175751,1877,42,140
286065,8837,406,315
1380990,79919,966,12703
32853,734,7,78
174170,11310,54,498
432275,32794,160,4534
1880966,37115,1235,4211
1088163,12106,868,1789
139123,617,7,37
104556,4391,110,597
138958,1227,15,107
168664,474,8,51
164771,6633,853,1041
4272775,259507,4137,19035
216512,12440,142,574
397771,1332,1630,1099
2142941,75361,1696,8481
3395,180,0,7
59450,398,63,158
1213663,49377,937,3003
106825,4806,106,785
107323,4761,35,560
408785,7205,244,526
285667,9023,184,888
130634,8583,40,646
19707391,381919,69465,0
735378,9978,179,709
153943,2616,114,518
648076,28204,626,3133
157761,7910,280,863
51836,271,5,32
36948,63,2,0
2333102,46801,954,5702
16376,26,131,93
6109026,369963,23207,38850
436715,8099,447,1094
4633101,35111,7231,12823
220338,3158,108,336
83980,2119,351,620
36595,208,34,117
58686,3683,45,387
251788,3553,64,346
184224,6830,243,451
110540,726,38,49
310826,21111,155,1693
34972,2008,19,83
89617,5362,76,668
731197,3447,835,1199
454794,10554,644,1001
145407,2615,355,1251
8347038,687381,54352,130106
3037052,157883,1779,9107
72981,10156,32,890
256804,7823,141,366
32639,1471,23,216
52752,2410,37,201
213404,833,68,53
1513874,92549,2175,14951
868741,35004,945,3755
116960,17372,78,2583
118637,2486,60,136
67327,1513,6,112
2259149,38699,1573,4566
266816,10184,189,828
662501,44331,685,6640
3501124,123557,9636,8211
2156550,47051,849,3314
251472,9892,145,2160
158271,320,63,139
207227,2918,84,344
207999,16425,273,2529
3331,373,3,55
943474,25418,1031,4786
323710,18879,303,1618
314127,15315,178,1029
804842,39315,352,3744
86098,6848,30,275
1261482,47349,798,3205
4484393,98828,11533,20901
69148,3526,16,229
3122153,218697,1141,17755
549702,21980,505,1567
1771274,109494,3629,20727
56164,8211,55,1421
182568,1032,13,119
1434594,46448,1080,2004
1232902,44449,1357,4118
298514,12411,436,1001
1644821,37539,1218,4278
171358,5130,376,561
14598,1432,6,140
291410,6117,832,600
168645,205,56,3
533397,43681,569,3593
87279,3197,49,179
1521364,6246,1804,2885
123053,2293,55,110
252615,22516,48,1643
25211,22,1,0
1726470,60575,875,4609
125255,1247,100,68
13686054,432783,9367,21853
15598,141,0,29
711888,30520,903,2137
927856,79631,505,3930
2141691,74997,1641,5891
77053,2007,50,236
3447192,12246,535,1743
382354,27393,395,1988
88447,1774,67,176
1640353,38242,1160,6931
2227312,85408,2060,4287
345495,10170,230,872
3411,61,0,11
1016805,25299,998,2705
428075,28530,189,2291
238220,504,807,658
217735,13284,218,2483
102334,3245,471,407
100731,5210,71,302
703133,28349,659,3316
436907,7696,346,629
50478,1149,260,533
3316413,179081,3978,30850
4443002,151423,9287,31293
56551,1073,354,761
1304884,7306,1249,5175
973059,78245,1831,12621
417741,7268,655,940
1431367,41867,1817,3875
6987691,279751,271351,85949
8795,202,60,69
786180,19278,1208,3328
547337,31942,655,3183
1213185,16818,5553,2636
15906520,415114,29669,31425
2278284,138872,7077,11177
1826347,82533,1336,12968
396308,15974,594,2890
86898,764,74,170
16506,448,30,53
5551,103,114,53
1266616,11561,1233,1073
488750,5814,209,1224
818526,3466,443,0
970111,39892,1088,3914
2583811,119607,3847,4893
596689,24701,357,4613
4008289,68589,7090,18636
152090,1429,37,84
1131278,51617,847,2744
1096173,2829,1124,2891
422209,6278,868,1229
279650,11294,195,1225
88402,616,242,397
21973,42,90,65
2119463,111703,1617,7842
516614,4888,558,428
854361,60258,471,6764
273138,13902,653,1632
890996,7244,2783,1583
56967,2541,47,196
1805157,28561,4766,4995
104488,6778,501,3069
408663,12463,388,1423
879197,34415,1185,3837
1514361,16325,1138,1964
178179,10352,184,1331
357897,11347,311,3867
307285,2597,113,157
1455471,5633,252,695
104945,4279,212,760
4485662,377360,7406,18987
189062,723,120,69
299462,6992,166,489
70889,253,1,15
46266,1900,31,133
45303,2415,98,530
748105,15750,2544,2154
312833,13234,214,1643
26002,503,72,175
782543,14647,1489,0
348985,25763,267,2387
2109838,89462,972,17024
749633,22525,1666,2550
161495,18227,73,907
3111683,303621,1257,25994
2699490,170737,1658,15830
157482,14411,138,840
251950,5933,131,495
3556295,142856,1698,7679
243329,4835,216,281
417647,1229,674,982
516012,23754,610,1191
390932,7406,1882,1059
3297192,71169,1412,1681
2686196,75577,658,4981
1848866,83261,2229,3681
1867067,54231,389,1996
44921,880,72,263
753615,24686,454,3424
974932,70591,1035,7140
740222,27889,603,2140
934171,62221,447,3356
2307502,23662,4652,7508
2082064,117087,2093,11438
794778,38086,804,4038
6104,74,0,5
269710,14871,223,1352
63122,89,2,0
15035822,1056548,12656,161642
115658,4699,120,448
626024,60539,222,3494
1356350,38938,519,3713
50473,376,59,441
362788,17129,657,1411
437070,16927,643,2226
89671,443,212,1259
49107,315,10,18
196102,4195,140,526
112509,3525,120,262
1459882,83321,1017,13144
321565,16772,185,559
200973,12480,60,463
4069,214,0,6
74158,461,98,167
186262,7257,906,959
478859,33925,180,4660
919912,10138,872,776
1112947,12288,881,1733
2059052,39610,1328,4516
306432,9181,424,332
4719714,268428,4356,19587
197295,1989,45,153
12396,39,0,5
120675,5164,114,857
2291406,78078,1776,8720
140678,9064,43,174
16752,26,131,69
1274795,50759,967,3130
153118,1344,15,118
458189,1347,1640,1129
166374,475,515,753
4471,23,0,2
158834,6712,41,580
238057,594,10,54
832765,11049,191,853
456311,8339,460,1119
437333,7274,248,524
154997,673,9,36
51737,862,10,78
690445,29547,668,2286
174807,2959,120,578
102322,5653,78,547
2425974,47999,983,5907
5619,237,1,22
192089,7006,245,456
65192,3938,52,200
276105,3623,66,354
445518,27190,262,1749
38720,218,34,131
203736,3684,52,192
4744488,35529,7328,13000
137441,18498,82,2213
107756,12140,47,807
94481,2268,378,641
6195810,372700,23509,39002
754790,3615,862,1264
146466,2621,360,1263
276034,13739,449,1039
3192269,162414,1918,9412
1555218,94238,2226,12202
8665083,700870,56487,134318
994795,38506,1095,4208
215449,2973,86,351
282005,1028,84,60
123721,766,40,55
8795,119,3,13
673243,44892,689,6739
297168,8603,166,390
214806,16803,284,2588
57920,303,5,33
264265,10187,151,1747
43650,2344,23,90
131490,2717,68,176
7195,11,0,2
70403,1536,7,120
348812,19836,311,1650
848558,40760,370,3902
3908558,130883,10147,8631
2422328,40269,1631,4766
163494,332,64,124
4801175,103058,12067,21660
2243743,47968,872,3543
36250,1566,23,182
355704,16412,198,1085
4108,421,4,45
966001,25724,1046,4802
1353041,49056,840,3295
26232,1968,14,133
184273,1043,14,107
76413,3777,19,274
284397,23482,56,1674
344944,13305,477,1083
459829,10606,649,1018
106586,3605,54,210
1887547,113729,3803,21940
3245570,223798,1184,18159
572561,22532,517,1566
108087,7804,39,285
1325192,46180,1416,4241
1476142,47281,1115,2080
324599,6496,859,635
191060,5387,408,563
1595643,6453,1859,2927
1692235,38125,1245,4421
1017138,83346,544,4069
2631028,84169,1975,6570
549720,44225,575,3578
109254,4296,75,239
2364524,350518,2301,38696
2156199,165263,2742,12872
99061,10935,66,569
20565649,1478119,46477,501435
478974,4858,1537,1555
113312,663,2059,936
391903,971,75,153
2012877,46829,1475,5161
1461691,22521,1309,1853
425398,12705,302,465
1525824,124315,445,28875
769883,20793,405,3065
56807,1037,877,510
1319154,42524,1225,4875
187003,5571,282,2332
227795,3588,724,1553
31919,3065,54,242
304781,15511,2159,2161
644242,5823,422,2986
68627,868,228,390
223455,9485,50,480
178675,627,1012,526
990106,33409,837,7726
63764,11682,89,1973
141058,2067,790,1823
312940,34381,282,2698
741687,41763,2409,9999
10869,167,2,30
105017,7451,73,644
128415,1576,63,125
104645,4101,80,279
3549055,185883,4266,32236
44193,2668,80,178
79301,306,197,112
17445,197,17,99
223592,7906,183,1349
8961,30,88,0
4763854,159547,9879,32772
1622730,8312,1457,5682
30899,1124,102,245
1093377,83465,2077,9997
1382327,12277,2365,1977
521816,8422,777,1041
25453,104,52,55
866903,20155,1336,3554
103590,876,82,197
1587575,44221,2057,4065
9155,278,22,57
7611822,288996,293883,93201
695844,36905,803,3488
344758,1593,66,254
455624,17129,678,3020
1273718,17446,5777,2742
32867,59,119,92
241868,120,33,68
44906,5138,78,464
696564,6750,298,1007
2372757,141479,7634,11593
19496639,464107,33974,34684
216743,1706,47,115
1389767,12413,1323,1144
219669,7131,103,337
1917979,85528,1401,13253
839473,3497,465,0
22413,1686,21,14
1022750,40957,1146,4086
3031,34,2,4
140681,2296,186,472
134239,846,309,569
2755100,124274,4068,5135
640425,25614,388,4776
69131,244,15,123
1456100,60356,1018,3252
471036,6911,943,1316
1137938,2928,1170,2994
115951,7163,568,3282
4167511,70131,7297,19103
2328,22,0,2
372931,11678,321,3955
1032913,8083,3008,1724
2258595,116427,1703,8218
318102,12145,220,1331
160225,2408,36,262
1002805,63946,480,7116
566996,5111,585,474
297151,14891,704,1352
240137,12298,554,2044
432877,12894,414,1461
2088810,29100,4783,5131
1614047,17164,1161,2083
186925,10704,189,1382
1671764,5823,259,734
61760,2659,51,222
95834,298,2,18
4603977,384101,7517,19305
190342,729,124,77
201056,20539,129,2309
111887,4525,220,777
3987580,26021,8719,0
340605,7360,174,506
391886,27347,281,2448
3514910,314218,1373,26807
2166127,90577,985,17373
320336,13466,221,1662
287017,6382,143,518
2759027,173077,1687,15945
72899,97,2,7
177799,18993,76,817
3758620,147601,1788,7908
601281,25610,688,1308
280951,5327,246,300
431648,1258,676,1010
47593,2493,98,546
2791685,77533,684,5246
166760,15048,144,757
775666,22997,1719,2658
409434,7606,1886,1033
3518322,74470,1478,1751
51043,2013,31,149
2019673,56452,410,2069
47803,911,75,280
2309878,121436,2210,11722
1040485,73342,1087,7302
773318,25113,460,2856
10249,261,3,27
821174,38800,831,4163
2023068,87498,2353,3852
764433,28630,611,2183
6438,76,0,13
959832,63408,462,3439
653088,61993,235,3554
50833,377,60,446
120171,4821,121,465
207643,2054,47,164
281272,15369,227,1392
382932,17756,694,1453
456727,17396,662,2273
90855,447,218,1287
209796,4398,146,567
49973,326,10,25
62054,933,10,97
200676,11690,328,461
126781,3853,136,281
1521371,85745,1045,10315
216293,13050,63,483
445225,7327,248,534
2348649,23861,4687,7608
79900,492,115,206
4363,226,0,13
2123895,40479,1362,4665
934381,10270,878,791
160545,1423,18,143
501481,34455,191,4710
370459,18297,208,604
195919,7488,930,977
12621,39,0,9
222677,4123,29,564
232176,8959,65,739
17019,26,131,78
1128296,12387,889,1786
315054,9284,432,352
144101,9213,43,185
2355458,79210,1803,8886
468130,1355,1642,1140
4990025,273916,4489,19878
166754,475,515,799
291948,687,10,71
4651,24,0,2
168793,699,9,44
130027,5383,117,917
68099,4052,53,208
923704,11708,200,936
713595,30269,689,2306
472460,8544,466,1135
2689,25,3,2
194613,3195,127,616
196113,8841,198,709
1303319,51274,983,3175
2457564,48412,1001,5911
511287,30026,324,1970
101864,2369,395,672
110725,5796,81,574
132561,802,45,64
40238,221,36,137
35945,2282,17,144
4804702,35719,7384,13127
131778,13029,65,857
153037,19121,88,2286
6232518,373824,23701,39144
146963,2626,364,1292
331980,1184,100,68
3280098,164959,2003,9557
1077745,40701,1186,4364
8808424,706104,57280,135649
795384,3717,898,1291
1574802,94941,2247,12442
206053,3715,53,194
9633,137,4,20
59537,316,5,40
50537,2624,26,100
1135047,43384,1902,10376
480140,16659,538,2121
1311031,43066,1618,8155
111973,5723,172,722
1512907,138252,4489,19821
414950,22413,448,1851
71480,5560,849,1672
864289,156831,738,14834
703228,45898,988,5124
334449,28136,208,1669
4635501,487060,4426,52345
625564,15712,333,728
206616,2170,899,1728
571105,9667,1405,705
174910,885,60,1607
242913,10385,325,1002
723864,34482,338,1605
630742,70815,930,6887
619567,36956,952,5381
34895,385,114,91
413743,13772,130,1534
518667,67782,585,3729
966197,61822,929,61179
4625554,239185,4769,18552
366192,19345,235,1000
616086,5988,364,2626
1096866,3080,202,406
302836,1286,4117,1608
1293052,49289,1660,4226
1403982,47930,1575,3840
223223,9518,816,1625
48652,367,22,38
145412,2409,2772,1335
106757,3529,152,380
565494,14734,420,518
672492,5990,2160,2192
580916,1657,73,494
125721,374,62,405
342604,7838,429,3383
1453523,121165,1773,15975
30424471,1762428,63990,582624
57495,813,27,93
2712929,55016,1986,6196
209228,7829,237,762
2737,5,4,9
59848,1577,160,0
30721,2013,45,152
361789,8193,359,400
43655,216,20,309
291775,16330,170,3207
1977954,141440,572,25637
16001,685,21,91
6462,9,1,8
268536,4091,911,1795
1002967,23521,497,3366
363089,9525,727,2521
306600,13553,155,1039
1626151,48674,1359,5407
2334998,107706,1525,3911
80180,4224,78,536
5665,27,6,21
42781,1313,163,262
78449,967,255,332
339150,12233,89,632
117006,15226,147,2315
75303,2024,92,533
217619,784,1337,755
380783,13750,195,2498
90525,2265,70,231
159619,2267,869,2024
54660,1744,30,133
21086,97,10,71
82157,6987,100,549
442890,0,0,194
66513,2412,218,981
25100,406,22,53
37294,287,23,126
1243109,38280,1014,8793
16568,22,3,40
433796,11766,326,1265
16512,11,0,0
74482,4536,25,379
167923,5022,103,314
891116,46191,2838,10754
299418,14124,65,1474
1402952,35060,2185,5242
36085,131,71,76
164812,6948,81,1165
104297,3857,130,472
56625,1093,133,220
59662,3624,99,207
259100,8452,215,1459
55408,21,1,12
8413,23,2,10
3669748,190177,4359,27132
27512,828,13,157
1444656,50919,1239,3060
1681166,8432,1491,5031
5005454,166469,10127,33916
83692,312,218,116
116646,56,9,16
1637373,14157,2849,1888
1217865,89347,2205,10401
108762,891,85,158
1292047,2038,71,1461
11844,37,99,0
571327,8966,822,929
83417,288,20,159
896828,20598,1377,2958
390669,1805,72,302
341006,134,36,72
769005,39433,863,2852
7990090,293800,304135,94266
488446,17853,698,3139
1285313,17588,5802,2748
844361,6996,329,1038
26829,135,2,20
2403392,142708,7749,11482
22787997,502597,37538,36467
228041,7311,107,338
1445091,12846,1357,1147
2001345,88388,1457,11496
22895,1688,21,14
250066,1823,50,119
3170,34,2,3
1057885,41614,1169,4008
37093,61,119,75
165899,999,338,573
146597,2335,194,484
2891328,127796,4219,5371
663057,26141,404,4840
583550,8033,1041,954
344752,12587,235,1358
846964,3499,467,0
4271785,71114,7431,18958
2735,25,0,2
1150895,8900,3174,1798
385096,12006,326,4061
4112187,26609,8982,0
1703268,67601,1123,3373
122191,7384,593,3143
314005,15492,736,1318
1161121,67930,522,7469
108829,320,2,19
248787,12683,566,2096
446594,13138,424,1379
192937,10880,192,1376
63069,2725,53,162
395563,7615,184,498
18293,294,7,28
2218837,29355,4868,5214
117199,4674,225,539
222861,21781,141,2412
4699392,388954,7586,19412
191166,730,125,75
1689730,17709,1171,2035
429424,28624,291,2208
168337,2453,36,245
49418,2561,98,346
326073,13654,222,1716
2206513,91418,1002,17577
3864917,322474,1450,27422
188774,19494,76,807
303550,6567,145,560
652319,26543,755,1370
173696,15463,148,742
439139,1277,679,1041
319412,5750,272,289
3932117,150979,1861,7990
80333,106,2,9
2860774,78841,690,5333
2822860,175347,1710,16202
793296,23330,1761,2695
53740,2078,31,146
2125368,57482,419,2083
2517566,124876,2318,12000
837476,39223,841,4158
2172912,90925,2464,3963
1091561,75196,1139,7456
6668,77,1,17
425684,7817,1893,989
1561336,87097,1065,10525
677750,63206,247,3616
785534,29247,624,2218
979551,64289,465,3450
51110,378,60,433
215640,2105,47,169
396776,18156,716,1487
219221,4532,152,553
91572,448,221,1024
469986,17749,676,2303
50664,331,11,17
291348,15749,233,1330
72124,1018,13,93
2379689,24008,4727,7665
483496,1369,1645,1115
4672,234,0,0
142463,4231,148,279
2162240,41032,1384,4737
515000,34727,195,4722

US_video_data_numbers.csv

案例1：

import numpy as np
from matplotlib import  pyplot as plt

us_file_path = "./US_video_data_numbers.csv"
uk_file_path = "./GB_video_data_numbers.csv"

# t1 = np.loadtxt(us_file_path,delimiter=",",dtype="int",unpack=True)
t_us = np.loadtxt(us_file_path,delimiter=",",dtype="int")

#取评论的数据
t_us_comments = t_us[:,-1]

#选择比5000小的数据
t_us_comments = t_us_comments[t_us_comments<=5000]

print(t_us_comments.max(),t_us_comments.min())

d = 50

bin_nums = (t_us_comments.max()-t_us_comments.min())//d

#绘图
plt.figure(figsize=(20,8),dpi=80)

plt.hist(t_us_comments,bin_nums)

plt.show()

运行结果：

案例2：

import numpy as np
from matplotlib import  pyplot as plt

us_file_path = "./US_video_data_numbers.csv"
uk_file_path = "./GB_video_data_numbers.csv"

# t1 = np.loadtxt(us_file_path,delimiter=",",dtype="int",unpack=True)
t_uk = np.loadtxt(uk_file_path,delimiter=",",dtype="int")

#选择喜欢书比50万小的数据
t_uk = t_uk[t_uk[:,1]<=500000]

t_uk_comment = t_uk[:,-1]
t_uk_like = t_uk[:,1]

plt.figure(figsize=(20,8),dpi=80)
plt.scatter(t_uk_like,t_uk_comment)

plt.show()

运行结果：