In [1]:
import os
import sys
import random
import time
from random import seed, randint
import argparse
import platform
from datetime import datetime
import imp
import numpy as np
import fileinput
from itertools import product
import pandas as pd
from scipy.interpolate import griddata
from scipy.interpolate import interp2d
import seaborn as sns
from os import listdir
import matplotlib.pyplot as plt
import seaborn as sns
from scipy.interpolate import griddata
import matplotlib as mpl
sys.path.insert(0,'..')
from notebookFunctions import *
# from .. import notebookFunctions
%matplotlib inline
plt.rcParams['figure.figsize'] = (10,6.180) #golden ratio
# %matplotlib notebook
%load_ext autoreload
%autoreload 2
In [4]:
data = pd.read_excel("/Users/weilu/Downloads/TOP500_201711.xls")
In [35]:
data2 = pd.read_excel("/Users/weilu/Downloads/TOP500_201706.xls")
In [37]:
data3 = pd.read_excel("/Users/weilu/Downloads/TOP500_201611.xls")
In [9]:
data.columns
Out[9]:
Index(['Rank', 'Previous Rank', 'First Appearance', 'First Rank', 'Name',
'Computer', 'Site', 'Manufacturer', 'Country', 'Year', 'Segment',
'Total Cores', 'Accelerator/Co-Processor Cores', 'Rmax [TFlop/s]',
'Rpeak [TFlop/s]', 'Nmax', 'Nhalf', 'HPCG [TFlop/s]', 'Power (kW)',
'Power Source', 'Power Effeciency [GFlops/Watts]', 'Architecture',
'Processor', 'Processor Technology', 'Processor Speed (MHz)',
'Operating System', 'OS Family', 'Accelerator/Co-Processor',
'Cores per Socket', 'Processor Generation', 'System Model',
'System Family', 'Interconnect Family', 'Interconnect', 'Region',
'Continent', 'Site ID', 'System ID'],
dtype='object')
In [14]:
data[['Name', 'Rmax [TFlop/s]', 'Rpeak [TFlop/s]']]
Out[14]:
Name
Rmax [TFlop/s]
Rpeak [TFlop/s]
0
Sunway TaihuLight
93014.59388
125435.9040
1
Tianhe-2 (MilkyWay-2)
33862.70000
54902.4000
2
Piz Daint
19590.00000
25326.2640
3
Gyoukou
19135.80000
28192.0000
4
Titan
17590.00000
27112.5500
5
Sequoia
17173.22400
20132.6592
6
Trinity
14137.30000
43902.5660
7
Cori
14014.70000
27880.6530
8
Oakforest-PACS
13554.60000
24913.4590
9
NaN
10510.00000
11280.3840
10
Mira
8586.61200
10066.3300
11
Stampede2
8317.72000
18215.8000
12
TSUBAME3.0
8125.00000
12127.0690
13
Marconi Intel Xeon Phi
7471.08000
15371.9552
14
NaN
7038.93000
8128.5120
15
MareNostrum
6470.80000
10296.1150
16
Pleiades
5951.55000
7107.1488
17
Theta
5884.62000
9627.2380
18
Hazel Hen
5640.17000
7403.5200
19
Shaheen II
5536.99000
7235.1740
20
Pangea
5283.11000
6712.3200
21
JUQUEEN
5008.85700
5872.0256
22
Tera-1000-2-Part 1
4967.22000
9358.5410
23
Cheyenne
4788.19000
5332.3200
24
Vulcan
4293.30600
5033.1650
25
Abel
4042.46000
5369.8560
26
NaN
3944.68000
4249.3250
27
NaN
3944.68000
4249.3250
28
JURECA
3782.57000
6563.8400
29
NaN
3577.00000
6131.8400
...
...
...
...
470
NaN
581.10000
829.7100
471
NaN
579.68600
1566.7200
472
Sator
579.23200
666.6240
473
MLSystem
579.00000
1198.0800
474
NaN
578.86400
1157.7280
475
NaN
578.10200
976.8960
476
NaN
572.57000
989.1840
477
NaN
572.57000
989.1840
478
NaN
572.57000
989.1840
479
NaN
572.57000
989.1840
480
NaN
570.60000
907.2000
481
NaN
567.06700
1051.0080
482
Gaea C2
565.70000
715.9810
483
NaN
565.24800
942.0800
484
NaN
563.52800
1425.6000
485
NaN
561.20000
898.5600
486
TIFR
558.80000
730.6600
487
CLAIX (Phase I, 2016)
558.42400
662.3230
488
NaN
557.44000
1114.8800
489
NaN
557.34000
1028.3520
490
SuperMIC
557.03300
925.0720
491
NaN
555.41000
1152.0000
492
NaN
555.30000
736.0000
493
NaN
555.20000
896.0000
494
DLSystem
551.10000
912.3070
495
NaN
550.74800
726.8350
496
NaN
550.06400
1372.8000
497
NaN
549.11700
864.0000
498
Discover SCU12
548.67200
712.8580
499
Discover SCU11
548.67200
712.8580
500 rows × 3 columns
In [ ]:
In [34]:
a = data.groupby("Country")['Rmax [TFlop/s]'].sum().plot.pie(figsize=(40,20), labeldistance=0.6)
plt.savefig('/Users/weilu/Desktop/test.png')
In [39]:
data.rename(columns={"Name":"Ntest"})
Out[39]:
Rank
Previous Rank
First Appearance
First Rank
Ntest
Computer
Site
Manufacturer
Country
Year
...
Cores per Socket
Processor Generation
System Model
System Family
Interconnect Family
Interconnect
Region
Continent
Site ID
System ID
0
1
1.0
47
1
Sunway TaihuLight
Sunway MPP, Sunway SW26010 260C 1.45GHz, Sunway
National Supercomputing Center in Wuxi
NRCPC
China
2016
...
260
Sunway
Sunway MPP
Sunway Cluster
Custom Interconnect
Sunway
Eastern Asia
Asia
50623
178764
1
2
2.0
41
1
Tianhe-2 (MilkyWay-2)
TH-IVB-FEP Cluster, Intel Xeon E5-2692 12C 2.2...
National Super Computer Center in Guangzhou
NUDT
China
2013
...
12
Intel Xeon E5 (IvyBridge)
TH-IVB-FEP Cluster
TH-IVB Cluster
Custom Interconnect
TH Express-2
Eastern Asia
Asia
50365
177999
2
3
3.0
40
114
Piz Daint
Cray XC50, Xeon E5-2690v3 12C 2.6GHz, Aries in...
Swiss National Supercomputing Centre (CSCS)
Cray Inc.
Switzerland
2017
...
12
Intel Xeon E5 (Haswell)
Cray XC50
Cray XC
Custom Interconnect
Aries interconnect
Western Europe
Europe
50422
177824
3
4
69.0
49
69
Gyoukou
ZettaScaler-2.2 HPC system, Xeon D-1571 16C 1....
Japan Agency for Marine-Earth Science and Tech...
ExaScaler
Japan
2017
...
16
Intel Xeon E5 (Broadwell)
ZettaScaler-2.2 HPC system
ZettaScaler
Infiniband
Infiniband EDR
Eastern Asia
Asia
49318
179102
4
5
4.0
40
1
Titan
Cray XK7, Opteron 6274 16C 2.200GHz, Cray Gemi...
DOE/SC/Oak Ridge National Laboratory
Cray Inc.
United States
2012
...
16
Opteron 6200 Series "Interlagos"
Cray XK7
Cray XK
Custom Interconnect
Cray Gemini interconnect
North America
Americas
48553
177975
5
6
5.0
38
17
Sequoia
BlueGene/Q, Power BQC 16C 1.60 GHz, Custom
DOE/NNSA/LLNL
IBM
United States
2011
...
16
Power BQC
BlueGene/Q
IBM BlueGene
Custom Interconnect
Custom Interconnect
North America
Americas
49763
177556
6
7
10.0
46
6
Trinity
Cray XC40, Intel Xeon Phi 7250 68C 1.4GHz, Ari...
DOE/NNSA/LANL/SNL
Cray Inc.
United States
2017
...
68
Intel Xeon Phi
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
North America
Americas
50334
178610
7
8
6.0
48
5
Cori
Cray XC40, Intel Xeon Phi 7250 68C 1.4GHz, Ari...
DOE/SC/LBNL/NERSC
Cray Inc.
United States
2016
...
68
Intel Xeon Phi
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
North America
Americas
48429
178924
8
9
7.0
48
6
Oakforest-PACS
PRIMERGY CX1640 M1, Intel Xeon Phi 7250 68C 1....
Joint Center for Advanced High Performance Com...
Fujitsu
Japan
2016
...
68
Intel Xeon Phi
PRIMERGY CX1640 M1
Fujitsu Cluster
Omnipath
Intel Omni-Path
Eastern Asia
Asia
50673
178932
9
10
8.0
37
1
NaN
K computer, SPARC64 VIIIfx 2.0GHz, Tofu interc...
RIKEN Advanced Institute for Computational Sci...
Fujitsu
Japan
2011
...
8
SPARC64 VIIIfx
K computer
Fujitsu Cluster
Custom Interconnect
Custom Interconnect
Eastern Asia
Asia
50313
177232
10
11
9.0
39
3
Mira
BlueGene/Q, Power BQC 16C 1.60GHz, Custom
DOE/SC/Argonne National Laboratory
IBM
United States
2012
...
16
Power BQC
BlueGene/Q
IBM BlueGene
Custom Interconnect
Custom Interconnect
North America
Americas
47347
177718
11
12
12.0
49
12
Stampede2
PowerEdge C6320P/C6420, Intel Xeon Phi 7250 68...
Texas Advanced Computing Center/Univ. of Texas
Dell EMC
United States
2017
...
68
Intel Xeon Phi
PowerEdge C6320P
Dell PowerEdge Cluster
Omnipath
Intel Omni-Path
North America
Americas
48958
179045
12
13
61.0
49
61
TSUBAME3.0
SGI ICE XA, IP139-SXM2, Xeon E5-2680v4 14C 2.4...
GSIC Center, Tokyo Institute of Technology
HPE
Japan
2017
...
14
Intel Xeon E5 (Broadwell)
SGI ICE XA (HPE SGI 8600), IP139-SXM2
HPE SGI 8600
Omnipath
Intel Omni-Path
Eastern Asia
Asia
47912
179093
13
14
14.0
48
12
Marconi Intel Xeon Phi
CINECA Cluster, Lenovo SD530, Intel Xeon Phi 7...
CINECA
Lenovo
Italy
2016
...
68
Intel Xeon Phi
CINECA Cluster
CINECA Cluster
Omnipath
Intel Omni-Path
Southern Europe
Europe
47495
178937
14
15
11.0
48
11
NaN
Cray XC40, Xeon E5-2695v4 18C 2.1GHz, Aries in...
United Kingdom Meteorological Office
Cray Inc.
United Kingdom
2016
...
18
Intel Xeon E5 (Broadwell)
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
Northern Europe
Europe
49064
178925
15
16
13.0
49
13
MareNostrum
Lenovo SD530, Xeon Platinum 8160 24C 2.1GHz, I...
Barcelona Supercomputing Center
Lenovo
Spain
2017
...
24
Xeon Platinum
ThinkSystem SD530
Lenovo ThinkSystem
Omnipath
Intel Omni-Path
Southern Europe
Europe
49748
179067
16
17
15.0
37
7
Pleiades
SGI ICE X, Intel Xeon E5-2670/E5-2680v2/E5-268...
NASA/Ames Research Center/NAS
HPE
United States
2016
...
10
Intel Xeon E5 (IvyBridge)
SGI ICE X
SGI ICE
Infiniband
Infiniband FDR
North America
Americas
48408
177259
17
18
16.0
48
18
Theta
Cray XC40, Intel Xeon Phi 7230 64C 1.3GHz, Ari...
DOE/SC/Argonne National Laboratory
Cray Inc.
United States
2017
...
64
Intel Xeon Phi
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
North America
Americas
47347
178926
18
19
17.0
44
16
Hazel Hen
Cray XC40, Xeon E5-2680v3 12C 2.5GHz, Aries in...
HLRS - Höchstleistungsrechenzentrum Stuttgart
Cray Inc.
Germany
2015
...
12
Intel Xeon E5 (Haswell)
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
Western Europe
Europe
50543
178446
19
20
18.0
45
7
Shaheen II
Cray XC40, Xeon E5-2698v3 16C 2.3GHz, Aries in...
King Abdullah University of Science and Techno...
Cray Inc.
Saudi Arabia
2015
...
16
Intel Xeon E5 (Haswell)
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
Western Asia
Asia
50205
178515
20
21
19.0
41
11
Pangea
SGI ICE X, Xeon Xeon E5-2670/ E5-2680v3 12C 2....
Total Exploration Production
HPE
France
2013
...
12
Intel Xeon E5 (Haswell)
SGI ICE X
SGI ICE
Infiniband
Infiniband FDR
Western Europe
Europe
49546
178071
21
22
21.0
39
8
JUQUEEN
BlueGene/Q, Power BQC 16C 1.600GHz, Custom Int...
Forschungszentrum Juelich (FZJ)
IBM
Germany
2012
...
16
Power BQC
BlueGene/Q
IBM BlueGene
Custom Interconnect
Custom Interconnect
Western Europe
Europe
47871
177722
22
23
NaN
50
23
Tera-1000-2-Part 1
Bull Sequana X1000, Intel Xeon Phi 7250 68C 1....
Commissariat a l'Energie Atomique (CEA)
Bull
France
2017
...
68
Intel Xeon Phi
Bull Sequana X1000
Bull Sequana
Custom Interconnect
Bull BXI 1.2
Western Europe
Europe
47593
179162
23
24
22.0
48
20
Cheyenne
SGI ICE XA, Xeon E5-2697v4 18C 2.3GHz, Infinib...
National Center for Atmospheric Research (NCAR)
HPE
United States
2016
...
18
Intel Xeon E5 (Broadwell)
SGI ICE XA
SGI ICE
Infiniband
Infiniband EDR
North America
Americas
48418
178965
24
25
23.0
39
48
Vulcan
BlueGene/Q, Power BQC 16C 1.600GHz, Custom Int...
DOE/NNSA/LLNL
IBM
United States
2012
...
16
Power BQC
BlueGene/Q
IBM BlueGene
Custom Interconnect
Custom Interconnect
North America
Americas
49763
177732
25
26
24.0
45
12
Abel
Cray XC30, Xeon E5-2698v3 16C 2.3GHz, Aries in...
Petroleum Geo-Services
Cray Inc.
United States
2015
...
16
Intel Xeon E5 (Haswell)
Cray XC30
Cray XC
Custom Interconnect
Aries interconnect
North America
Americas
48602
178556
26
27
26.0
43
19
NaN
Cray XC40, Xeon E5-2695v4 18C 2.1GHz, Aries in...
ECMWF
Cray Inc.
United Kingdom
2016
...
18
Intel Xeon E5 (Broadwell)
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
Northern Europe
Europe
47752
178431
27
28
25.0
47
18
NaN
Cray XC40, Xeon E5-2695v4 18C 2.1GHz, Aries in...
ECMWF
Cray Inc.
United Kingdom
2016
...
18
Intel Xeon E5 (Broadwell)
Cray XC40
Cray XC
Custom Interconnect
Aries interconnect
Northern Europe
Europe
47752
178749
28
29
80.0
46
49
JURECA
T-Platforms V-Class/Dell C6320P, E5-2680v3/Phi...
Forschungszentrum Juelich (FZJ)
T-Platforms, Intel, Dell
Germany
2015
...
12
Intel Xeon E5 (Haswell)
T-Platforms V-Class Cluster
T-Platforms Cluster
Infiniband
Infiniband EDR
Western Europe
Europe
47871
178718
29
30
28.0
44
10
NaN
Cray CS-Storm, Intel Xeon E5-2660v2 10C 2.2GHz...
Government
Cray Inc.
United States
2014
...
10
Intel Xeon E5 (IvyBridge)
Cray CS-Storm
Cray CS-Storm
Infiniband
Infiniband FDR
North America
Americas
50046
178445
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
470
471
340.0
48
254
NaN
Inspur TS10000, Xeon E5-2620v3 6C 2.4GHz, 40G ...
Internet Service (B)
Inspur
China
2016
...
6
Intel Xeon E5 (Haswell)
Inspur TS10000
Inspur Cluster
Gigabit Ethernet
40G Ethernet
Eastern Asia
Asia
50330
178986
471
472
341.0
47
175
NaN
Lenovo RD650, Xeon E5-2620v3 6C 2.4GHz, 10G Et...
Service Provider
Lenovo
China
2015
...
6
Intel Xeon E5 (Haswell)
Lenovo RD650
Lenovo Cluster
10G
10G Ethernet
Eastern Asia
Asia
50647
178825
472
473
342.0
49
342
Sator
NEC HPC1812-Rg-2, Xeon E5-2680v4 14C 2.4GHz, I...
ONERA
NEC
France
2017
...
14
Intel Xeon E5 (Broadwell)
NEC HPC1812-Rg-2
NEC Cluster
Omnipath
Intel Omni-Path
Western Europe
Europe
48549
179090
473
474
343.0
47
176
MLSystem
Sugon TC6000, Xeon E5-2620v3 6C 2.4GHz, 10G Et...
IT Service Provider (L)
Sugon
China
2016
...
6
Intel Xeon E5 (Haswell)
Sugon TC6000
Sugon Cluster
10G
10G Ethernet
Eastern Asia
Asia
50661
178853
474
475
344.0
47
177
NaN
Lenovo RD450, Xeon E5-2650v3 10C 2.3GHz, 10G E...
Internet Service (B)
Lenovo
China
2016
...
10
Intel Xeon E5 (Haswell)
Lenovo RD450
Lenovo Cluster
10G
10G Ethernet
Eastern Asia
Asia
50330
178775
475
476
345.0
49
345
NaN
Cluster Platform DL360, Xeon E5-2673v3 12C 2.4...
Software Company (M)
HPE
United Kingdom
2017
...
12
Intel Xeon E5 (Haswell)
Cluster Platform DL360
HP Cluster Platform 3000
10G
10G Ethernet
Northern Europe
Europe
50728
179141
476
477
346.0
49
346
NaN
Cluster Platform DL360, Xeon E5-2673v4 20C 2.3...
Hosting Company (M)
HPE
Austria
2017
...
20
Intel Xeon E5 (Broadwell)
Cluster Platform DL360
HP Cluster Platform 3000
10G
10G Ethernet
Western Europe
Europe
50672
179131
477
478
347.0
49
347
NaN
Cluster Platform DL360, Xeon E5-2673v4 20C 2.3...
Software Company
HPE
Finland
2017
...
20
Intel Xeon E5 (Broadwell)
Cluster Platform DL360
HP Cluster Platform 3000
10G
10G Ethernet
Northern Europe
Europe
50668
179130
478
479
349.0
49
349
NaN
Cluster Platform DL360, Xeon E5-2673v4 20C 2.3...
Software Company (M)
HPE
United States
2017
...
20
Intel Xeon E5 (Broadwell)
Cluster Platform DL360
HP Cluster Platform 3000
10G
10G Ethernet
North America
Americas
50172
179128
479
480
348.0
49
348
NaN
Cluster Platform DL360, Xeon E5-2673v4 20C 2.3...
Software Company (M)
HPE
United States
2017
...
20
Intel Xeon E5 (Broadwell)
Cluster Platform DL360
HP Cluster Platform 3000
10G
10G Ethernet
North America
Americas
50172
179127
480
481
350.0
46
140
NaN
Sugon TC6000, Intel Xeon E5-2620v2 6C 2.1GHz, ...
Internet Company B
Sugon
China
2015
...
6
Intel Xeon E5 (IvyBridge)
Sugon TC6000
Sugon Cluster
10G
10G Ethernet
Eastern Asia
Asia
50603
178674
481
482
351.0
47
181
NaN
Lenovo RD450, Xeon E5-2670v3 12C 2.3GHz, 10G E...
Service Provider T
Lenovo
China
2016
...
12
Intel Xeon E5 (Haswell)
Lenovo RD450
Lenovo Cluster
10G
10G Ethernet
Eastern Asia
Asia
50329
178780
482
483
352.0
38
20
Gaea C2
Cray XE6, Opteron 6276 16C 2.30GHz, Cray Gemin...
NOAA/Oak Ridge National Laboratory
Cray Inc.
United States
2011
...
16
Opteron 6200 Series "Interlagos"
Cray XE6
Cray XE
Custom Interconnect
Cray Gemini interconnect
North America
Americas
50336
177637
483
484
353.0
47
183
NaN
Lenovo RD450, Xeon E5-2682v4 16C 2.5GHz, 10G E...
Internet Company A
Lenovo
China
2016
...
16
Intel Xeon E5 (Broadwell)
Lenovo RD450
Lenovo Cluster
10G
10G Ethernet
Eastern Asia
Asia
50580
178772
484
485
354.0
46
142
NaN
Lenovo NeXtScale nx360M5, Intel Xeon E5-2660v2...
Telecom Company
Lenovo
China
2015
...
10
Intel Xeon E5 (IvyBridge)
Lenovo NeXtScale nx360 M5
Lenovo NeXtScale
10G
10G Ethernet
Eastern Asia
Asia
50591
178638
485
486
355.0
46
143
NaN
Sugon TC6000, Intel Xeon E5-2630v2 6C 2.6GHz, ...
Government
Sugon
China
2015
...
6
Intel Xeon E5 (IvyBridge)
Sugon TC6000
Sugon Cluster
10G
10G Ethernet
Eastern Asia
Asia
50605
178688
486
487
356.0
45
113
TIFR
Cray XC30, Intel Xeon E5-2680v2 10C 2.8GHz, A...
Indian Lattice Gauge Theory Initiative (ILGTI)...
Cray Inc.
India
2015
...
10
Intel Xeon E5 (IvyBridge)
Cray XC30
Cray XC
Custom Interconnect
Aries interconnect
South-central Asia
Asia
50545
178516
487
488
357.0
48
309
CLAIX (Phase I, 2016)
NEC HPC1812-Rg-2, Xeon E5-2650v4 12C 2.2GHz, I...
Universitaet Aachen/RWTH - IT Center
NEC
Germany
2016
...
12
Intel Xeon E5 (Broadwell)
NEC HPC1812-Rg-2
NEC Cluster
Omnipath
Intel Omni-Path
Western Europe
Europe
50675
178934
488
489
359.0
47
187
NaN
Lenovo RD450, Xeon E5-2640v3 8C 2.6GHz, 10G Et...
Internet Company A
Lenovo
China
2016
...
8
Intel Xeon E5 (Haswell)
Lenovo RD450
Lenovo Cluster
10G
10G Ethernet
Eastern Asia
Asia
50580
178767
489
490
360.0
45
114
NaN
Huawei Cluster RH2288H V2, Intel Xeon E5-2650...
Internet Company A
Huawei
China
2015
...
8
Intel Xeon E5 (IvyBridge)
Huawei Cluster RH2288H V2
Huawei Cluster
Gigabit Ethernet
Gigabit Ethernet
Eastern Asia
Asia
50580
178581
490
491
361.0
43
65
SuperMIC
Dell C8220X Cluster, Intel Xeon E5-2680v2 10C...
Louisiana State University
Dell EMC
United States
2014
...
10
Intel Xeon E5 (IvyBridge)
Dell C8220X Cluster
Dell PowerEdge Cluster
Infiniband
Infiniband FDR
North America
Americas
48279
178423
491
492
362.0
46
148
NaN
Inspur TS10000 HPC Server, Xeon E5-2650v3 10C ...
Internet Service (B)
Inspur
China
2015
...
10
Intel Xeon E5 (Haswell)
Inspur TS10000 HPC Server
Inspur Cluster
10G
10G Ethernet
Eastern Asia
Asia
50330
178653
492
493
363.0
48
270
NaN
FusionServer XH620 V3 Cluster, Xeon E5-2650v3 ...
Meteorological Service
Huawei
China
2016
...
10
Intel Xeon E5 (Haswell)
FusionServer XH620 V3 Cluster
Huawei Cluster
Infiniband
Infiniband FDR
Eastern Asia
Asia
50696
179005
493
494
364.0
46
149
NaN
Sugon TC6000, Intel Xeon E5-2450v2 8C 2.5GHz, ...
Internet Company M
Sugon
China
2015
...
8
Intel Xeon E5 (IvyBridge)
Sugon TC6000
Sugon Cluster
10G
10G Ethernet
Eastern Asia
Asia
50604
178687
494
495
365.0
47
192
DLSystem
Sugon W580-G20, Xeon E5-2640v3 8C 2.6GHz, 10G ...
Trading Company
Sugon
China
2016
...
8
Intel Xeon E5 (Haswell)
Sugon W580-G20
Sugon Cluster
10G
10G Ethernet
Eastern Asia
Asia
50618
178846
495
496
NaN
50
496
NaN
Cluster Platform DL380, Xeon E5-2680v4 14C 2.4...
Telecom Company
HPE
Mexico
2017
...
14
Intel Xeon E5 (Broadwell)
Cluster Platform DL380
HP Cluster Platform 3000
Infiniband
Infiniband FDR
Central America
Americas
50750
179288
496
497
366.0
46
150
NaN
Lenovo NeXtScale nx360M5, Intel Xeon E5-2660v2...
Telecom Company
Lenovo
China
2015
...
10
Intel Xeon E5 (IvyBridge)
Lenovo NeXtScale nx360 M5
Lenovo NeXtScale
10G
10G Ethernet
Eastern Asia
Asia
50592
178639
497
498
367.0
46
187
NaN
Apollo 6000 XL230a, Xeon E5-2680v3 12C 2.5GHz,...
WETA Digital
HPE
New Zealand
2015
...
12
Intel Xeon E5 (Haswell)
Apollo 6000 XL230a
HP Apollo
10G
10G Ethernet
Australia and New Zealand
Oceania
49557
178725
498
499
368.0
45
117
Discover SCU12
Rackable Cluster, Xeon E5-2697v3 14C 2.6GHz, I...
NASA/Goddard Space Flight Center
HPE
United States
2015
...
14
Intel Xeon E5 (Haswell)
Rackable Cluster
Rackable Cluster
Infiniband
Infiniband FDR
North America
Americas
49817
178530
499
500
369.0
45
116
Discover SCU11
Rackable Cluster, Xeon E5-2697v3 14C 2.6GHz, I...
NASA/Goddard Space Flight Center
HPE
United States
2015
...
14
Intel Xeon E5 (Haswell)
Rackable Cluster
Rackable Cluster
Infiniband
Infiniband FDR
North America
Americas
49817
178529
500 rows × 38 columns
In [ ]:
data.hist()
In [ ]:
data.groupby("Country").sum()
In [7]:
data.groupby("Country").count()
Out[7]:
Rank
Previous Rank
First Appearance
First Rank
Name
Computer
Site
Manufacturer
Year
Segment
...
Cores per Socket
Processor Generation
System Model
System Family
Interconnect Family
Interconnect
Region
Continent
Site ID
System ID
Country
Australia
4
3
4
4
4
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Austria
2
2
2
2
1
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
Canada
5
5
5
5
5
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
China
202
106
202
202
54
202
202
202
202
202
...
202
202
202
202
202
202
202
202
202
202
Czech Republic
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Finland
2
2
2
2
1
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
France
18
16
18
18
17
18
18
18
18
18
...
18
18
18
18
18
18
18
18
18
18
Germany
21
21
21
21
14
21
21
21
21
21
...
21
21
21
21
21
21
21
21
21
21
India
4
3
4
4
2
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Ireland
4
2
4
4
0
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Italy
6
6
6
6
6
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
Japan
35
28
35
35
29
35
35
35
35
35
...
35
35
35
35
35
35
35
35
35
35
Korea, South
5
5
5
5
2
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Mexico
1
0
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Netherlands
6
4
6
6
1
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
New Zealand
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Norway
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Poland
5
5
5
5
5
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Russia
3
3
3
3
3
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Saudi Arabia
4
3
4
4
4
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Singapore
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
South Africa
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Spain
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Sweden
5
4
5
5
1
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Switzerland
3
3
3
3
3
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Taiwan
1
0
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
United Kingdom
15
12
15
15
9
15
15
15
15
15
...
15
15
15
15
15
15
15
15
15
15
United States
143
124
143
143
72
143
143
143
143
143
...
143
143
143
143
143
143
143
143
143
143
28 rows × 37 columns
In [36]:
data2.groupby("Country").count()
Out[36]:
Rank
Previous Rank
First Appearance
First Rank
Name
Computer
Site
Manufacturer
Year
Segment
...
OS Family
Accelerator/Co-Processor
Cores per Socket
Processor Generation
System Model
System Family
Interconnect Family
Interconnect
Region
Continent
Country
Australia
4
2
4
4
3
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Austria
3
2
3
3
1
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Belgium
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Brazil
2
1
2
2
1
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
Canada
6
1
6
6
5
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
China
160
122
160
160
19
160
160
160
160
160
...
160
160
160
160
160
160
160
160
160
160
Czech Republic
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Denmark
2
1
2
2
2
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
Finland
3
2
3
3
1
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
France
18
16
18
18
18
18
18
18
18
18
...
18
18
18
18
18
18
18
18
18
18
Germany
28
25
28
28
19
28
28
28
28
28
...
28
28
28
28
28
28
28
28
28
28
India
4
4
4
4
2
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Ireland
2
0
2
2
0
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
Italy
8
6
8
8
8
8
8
8
8
8
...
8
8
8
8
8
8
8
8
8
8
Japan
33
23
33
33
27
33
33
33
33
33
...
33
33
33
33
33
33
33
33
33
33
Korea, South
8
3
8
8
3
8
8
8
8
8
...
8
8
8
8
8
8
8
8
8
8
Netherlands
4
2
4
4
1
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
New Zealand
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Norway
1
0
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Poland
6
6
6
6
5
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
Russia
3
3
3
3
3
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Saudi Arabia
6
5
6
6
6
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
Singapore
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
South Africa
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Spain
1
0
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Sweden
5
3
5
5
2
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Switzerland
3
3
3
3
3
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
United Kingdom
17
12
17
17
10
17
17
17
17
17
...
17
17
17
17
17
17
17
17
17
17
United States
168
141
168
168
81
168
168
168
168
168
...
168
168
168
168
168
168
168
168
168
168
29 rows × 35 columns
In [38]:
data3.groupby("Country").count()
Out[38]:
Rank
Previous Rank
First Appearance
First Rank
Name
Computer
Site
Manufacturer
Year
Segment
...
OS Family
Accelerator/Co-Processor
Cores per Socket
Processor Generation
System Model
System Family
Interconnect Family
Interconnect
Region
Continent
Country
Australia
3
3
3
3
2
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Austria
3
3
3
3
1
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Belgium
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Brazil
3
3
3
3
3
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Canada
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
China
171
136
171
171
19
171
171
171
171
171
...
171
171
171
171
171
171
171
171
171
171
Czech Republic
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Denmark
2
2
2
2
2
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
Finland
2
2
2
2
1
2
2
2
2
2
...
2
2
2
2
2
2
2
2
2
2
France
20
15
20
20
20
20
20
20
20
20
...
20
20
20
20
20
20
20
20
20
20
Germany
31
21
31
31
22
31
31
31
31
31
...
31
31
31
31
31
31
31
31
31
31
India
5
5
5
5
3
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Ireland
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Italy
6
5
6
6
6
6
6
6
6
6
...
6
6
6
6
6
6
6
6
6
6
Japan
27
24
27
27
21
27
27
27
27
27
...
27
27
27
27
27
27
27
27
27
27
Korea, South
4
4
4
4
3
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Netherlands
3
3
3
3
1
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
New Zealand
3
1
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
3
3
3
3
Norway
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Poland
7
6
7
7
6
7
7
7
7
7
...
7
7
7
7
7
7
7
7
7
7
Russia
5
5
5
5
5
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Saudi Arabia
5
5
5
5
5
5
5
5
5
5
...
5
5
5
5
5
5
5
5
5
5
Singapore
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
South Africa
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Spain
1
1
1
1
1
1
1
1
1
1
...
1
1
1
1
1
1
1
1
1
1
Sweden
4
2
4
4
2
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
Switzerland
4
3
4
4
3
4
4
4
4
4
...
4
4
4
4
4
4
4
4
4
4
United Kingdom
13
9
13
13
7
13
13
13
13
13
...
13
13
13
13
13
13
13
13
13
13
United States
171
122
171
171
83
171
171
171
171
171
...
171
171
171
171
171
171
171
171
171
171
29 rows × 34 columns
In [ ]:
Content source: luwei0917/awsemmd_script
Similar notebooks: