Skip to content

Instantly share code, notes, and snippets.

@ottomata

ottomata/20110917-27 Banner Impressions by country

Created September 28, 2012 19:17
Show Gist options
  • Save ottomata/3801633 to your computer and use it in GitHub Desktop.
Save ottomata/3801633 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
20110917-27 Banner Impressions by country
# dse hadoop fs -cat /user/otto/banner0/country_count-20110917-27.1/part* | sort
A1 111410
A2 18534
AD 112675
AE 69376
AF 2587
AG 876
AI 61
AL 24873
AM 38047
AN 294272
AO 4634
AP 32952
AR 351653
AS 2998
AT 20234858
AU 799292
AW 134653
AX 1717
AZ 93794
BA 60834
BB 2146
BD 49190
BE 21522453
BF 424
BG 199236
BH 13128
BI 56
BJ 10815
BM 1476
BN 3273
BO 10765
BR 787514
BS 3799
BT 986
BW 1488
BY 129449
BZ 1538
CA 1843282
CD 1101
CF 631
CG 80
CH 21904803
CI 1986
CK 30
CL 217980
CM 7150
CN 467268
CO 146607
CR 25656
CU 10044
CV 427
CY 30066
CZ 11401436
DE 204078696
DJ 256
DK 11824250
DM 1702
DO 31705
DZ 19977
EC 39535
EE 3492907
EG 112566
ER 21
ES 64887851
ET 1629
EU 3435018
FI 577152
FJ 1518
FK 81
FM 18
FO 2956
FR 115311324
GA 282
GB 3583683
GD 1026
GE 84971
GF 33691
GG 794
GH 6287
GI 975
GL 287
GM 174
GN 34
GP 136646
GQ 96
GR 278604
GT 22643
GU 1383
GY 1334
HK 304430
HN 6937
HR 158456
HT 883
HU 9577275
ID 258751
IE 256308
IL 591203
IM 6089
IN 1477978
IQ 12819
IR 192062
IS 35993
IT 1700242
JE 4557
JM 15373
JO 18059
JP 2459024
KE 11903
KG 13044
KH 4836
KI 19
KM 2
KN 782
KP 3
KR 342007
KW 24332
KY 679
KZ 73494
LA 8917
LB 26851
LC 6158
LI 101932
LK 32688
LR 100
LS 181
LT 126923
LU 1367217
LV 113316
LY 9616
MA 38958
MC 29677
MD 62170
ME 25143
MG 2760
MH 6
MK 50808
ML 1494
MM 3831
MN 8423
MO 10217
MP 208
MQ 111353
MR 200
MS 4
MT 16499
MU 14689
MV 2232
MW 475
MX 376331
MY 122164
MZ 2994
NA 10609
NC 2634
NE 164
NG 13983
NI 5354
NL 40053782
NO 15019446
NP 8212
NZ 183898
OM 8519
PA 9990
PE 87267
PF 3100
PG 126
PH 174816
PK 95387
PL 70759051
PM 6
PR 28944
PS 11801
PT 12214250
PW 9
PY 11845
QA 14610
RE 272265
RO 11269964
RS 235021
RU 116527863
RW 825
SA 123391
SB 176
SC 295
SD 8743
SE 29960199
SG 136253
SH 8
SI 95172
SK 742275
SL 91
SM 162
SN 2481
SO 46
SR 1144
ST 68
SV 14561
SY 64
SZ 177
TC 265
TD 364
TG 267
TH 185062
TJ 17095
TL 21
TM 467
TN 19353
TO 439
TR 387160
TT 11506
TW 312340
TZ 4770
UA 762349
UG 3494
US 10717565
UY 52665
UZ 6383
VA 196
VC 531
VE 100972
VG 353
VI 665
VN 122449
VU 228
WF 2
WS 87
YE 2547
YT 4321
ZA 82384
ZM 970
ZW 1734
Raw
20120917-27 Banner Impressions by country (sampled-100 scaled)
# dse hadoop fs -cat /user/otto/banner0/country_count-20120917-27.1/part* | sort | awk '{m = int($2 * 100); print $1 "\t" m}'
A1 93300
A2 48700
AD 12400
AE 259400
AF 3100
AG 6900
AI 1400
AL 119500
AM 86000
AN 17900
AO 21800
AP 17700
AR 2982300
AS 1500
AT 2466800
AU 899500
AW 9300
AX 3200
AZ 75900
BA 179000
BB 16200
BD 80000
BE 2726000
BF 4000
BG 404700
BH 30900
BI 600
BJ 4100
BM 7600
BN 6000
BO 201100
BR 6265600
BS 18900
BT 1300
BW 6000
BY 698200
BZ 9400
CA 7785600
CD 4200
CF 400
CG 1500
CH 2380900
CI 23100
CK 300
CL 1809400
CM 15200
CN 325100
CO 3242200
CR 212400
CU 44500
CV 5800
CY 58000
CZ 1486400
DE 24293100
DJ 6000
DK 1258200
DM 5500
DO 510200
DZ 225400
EC 731900
EE 335600
EG 342700
ER 100
ES 7389300
ET 4100
EU 277900
FI 994400
FJ 6600
FK 400
FM 300
FO 7500
FR 12702400
GA 2300
GB 9976300
GD 7100
GE 117500
GF 11000
GG 8200
GH 77100
GI 5000
GL 1800
GM 700
GN 600
GP 24600
GQ 800
GR 672000
GT 349600
GU 3700
GY 10600
HK 364400
HN 110300
HR 395100
HT 14400
HU 676300
ID 340000
IE 640200
IL 1473400
IM 14400
IN 6925700
IQ 73400
IR 321900
IS 76800
IT 25311100
JE 14900
JM 72000
JO 75600
JP 3521200
KE 121500
KG 18300
KH 7500
KI 400
KM 200
KN 6500
KR 182000
KW 58800
KY 6500
KZ 275800
LA 1800
LB 75400
LC 6500
LI 4700
LK 45300
LR 1500
LS 700
LT 222200
LU 171600
LV 170500
LY 19500
MA 436800
MC 6900
MD 150800
ME 36400
MG 6100
MH 200
MK 122300
ML 4800
MM 5700
MN 8400
MO 17900
MP 1200
MQ 20000
MR 2500
MT 59000
MU 42600
MV 9900
MW 2000
MX 7208900
MY 365300
MZ 10600
NA 8300
NC 7500
NE 800
NG 73200
NI 77400
NL 5584600
NO 1513800
NP 21000
NZ 273900
OM 32000
PA 248200
PE 1186700
PF 7700
PG 1400
PH 2335500
PK 380200
PL 7444600
PM 800
PR 204000
PS 33400
PT 840600
PY 113700
QA 65300
RE 28000
RO 1005100
RS 822300
RU 12463300
RW 5700
SA 403400
SB 800
SC 800
SD 15500
SE 3094400
SG 253500
SH 100
SI 200000
SK 299700
SL 900
SM 8200
SN 22700
SO 1000
SR 7600
SV 182600
SY 400
SZ 1000
TC 1900
TD 300
TG 3300
TH 362400
TJ 4200
TL 300
TM 1000
TN 189100
TO 600
TR 1701200
TT 73900
TW 613000
TZ 11600
UA 4028000
UG 12200
US 74272600
UY 230200
UZ 20600
VA 1800
VC 4300
VE 912100
VG 1700
VI 6000
VN 185500
VU 500
WF 100
WS 500
YE 16600
YT 400
ZA 725400
ZM 5400
ZW 9600
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment