从majestic_million中获取常见的TLD
一、数据来源
数据来源：https://majestic.com/reports/majestic-million
二、代码
import pandas as pd
from pandas import Series, DataFrame
majesticata = pd.read_csv('majestic_million.csv',usecols=['TLD'])
tld= majesticata["TLD"].value_counts()
tld.to_csv('tld.csv')
三、结果
TLD,数量
com,486213
org,78279
net,44852
ru,31695
tk,30230
de,29074
cn,27135
uk,23329
jp,14684
nl,12303
it,10130
fr,8988
pl,8601
info,7935
au,7808
br,7471
ca,6924
us,6355
in,5843
co,5247
es,4931
eu,4558
cz,4364
gq,4159
ga,4124
ml,4122
biz,4105
cf,4081
edu,4078
ua,3752
ch,3276
io,3206
se,2992
be,2768
at,2691
hu,2631
tw,2601
vn,2529
ro,2324
dk,2180
tv,2155
ir,2112
xyz,2103
gov,1971
me,1948
top,1900
za,1845
kr,1844
gr,1833
no,1744
fi,1595
tr,1538
nz,1444
online,1410
mx,1382
cc,1377
ie,1297
ar,1278
id,1155
pt,1142
cl,1133
xn--p1ai,1073
site,1032
il,1016
my,1007
club,978
sk,959
sg,928
hk,877
by,810
pro,783
su,740
kz,727
pk,653
mobi,631
hr,613
lt,573
space,553
ng,535
cat,513
bg,506
rs,495
lv,483
ae,466
ph,463
th,463
to,458
si,451
ee,442
pe,399
is,388
website,377
fm,371
name,360
pw,337
nu,333
news,330
icu,324
ai,306
ws,303
network,303
win,280
tech,276
vip,269
sa,258
live,257
np,253
ma,244
md,241
asia,229
app,228
am,225
ke,217
fun,215
life,213
ge,211
bd,203
lk,200
shop,197
store,188
az,181
team,180
travel,172
mk,170
uz,166
lu,166
ec,165
ba,158
media,157
company,155
world,148
ly,147
coop,147
today,137
im,137
wiki,135
aero,134
uy,134
global,133
la,133
tn,132
blog,132
link,130
eg,127
int,126
ve,125
mn,124
st,124
do,114
bz,114
guru,110
li,109
one,109
al,108
gg,108
vc,104
host,104
dev,100
mil,95
agency,90
ovh,89
wtf,89
best,88
kg,87
zw,85
social,85
work,84
design,83
cy,80
sh,80
eus,80
ag,78
cu,77
nyc,77
qa,75
mo,74
cx,74
cloud,74
mt,72
xxx,71
py,70
digital,70
run,69
irish,68
tel,67
reviews,67
lb,66
games,66
bo,65
dz,65
gs,64
cr,64
ug,63
stream,63
ms,63
group,62
jo,61
re,61
so,58
tc,58
scot,58
ps,57
bid,56
rocks,56
monster,54
ooo,54
ac,54
press,53
city,53
bet,53
gh,53
mu,53
art,52
institute,51
tz,51
review,50
wales,49
kh,48
gt,48
expert,47
tokyo,47
berlin,47
cm,45
solutions,45
va,44
recipes,44
center,44
community,43
academy,43
zone,43
jobs,42
science,42
sc,42
email,41
plus,41
rw,40
tt,40
education,39
video,39
tj,39
tips,38
sn,38
buzz,38
ltd,38
wang,38
pub,38
af,37
events,37
london,37
museum,36
international,36
guide,36
bank,36
ninja,35
studio,35
bio,35
movie,35
mz,35
services,34
as,34
vg,34
om,33
ci,33
foundation,32
cyou,32
ink,32
kw,32
onl,32
cash,32
iq,31
gl,31
trade,31
exchange,31
swiss,31
hn,31
works,31
gal,29
et,29
mg,29
party,29
vu,29
chat,28
red,28
tools,28
na,28
download,27
click,27
support,27
paris,27
nrw,27
mv,27
mm,26
golf,26
technology,26
help,26
sv,25
software,25
ni,25
ao,25
google,25
love,24
market,24
cool,24
bzh,24
report,24
surf,23
moscow,23
zm,23
earth,23
pa,23
finance,23
tl,23
gd,23
jm,23
moe,22
nc,22
africa,22
ht,22
bh,22
sy,22
bt,22
codes,21
church,21
mc,21
brussels,21
land,21
game,21
money,21
uno,20
yu,20
cd,20
gi,20
systems,20
school,20
yoga,20
dj,20
law,20
gy,20
health,19
eco,19
ngo,19
bn,19
lc,19
rodeo,19
pr,19
bw,19
photos,19
business,18
care,18
page,18
srl,18
fj,18
casa,18
capital,18
taipei,18
pm,18
joburg,18
gallery,17
tm,17
accountant,17
style,17
cam,17
photography,17
fo,17
ad,17
ky,17
town,16
mw,16
ltda,16
gm,16
fit,16
capetown,16
bf,16
date,16
loan,16
durban,16
energy,15
fund,15
sport,15
pf,15
pn,15
directory,15
amsterdam,15
watch,15
bike,15
bm,15
xn--80adxhks,14
bayern,14
tube,14
men,14
bb,14
cafe,14
xn--p1acf,14
abbott,14
porn,13
training,13
dating,13
canon,13
sm,13
xn--80asehdb,13
casino,13
legal,13
fyi,13
tf,13
rest,13
wine,13
farm,13
cv,13
sx,12
sex,12
show,12
blue,12
audio,12
coffee,12
marketing,12
xin,11
domains,11
sale,11
vin,11
sexy,11
barcelona,11
je,11
express,11
cymru,11
bs,11
lol,10
pics,10
tours,10
sb,10
rugby,10
deals,10
rentals,10
vision,10
coach,10
gp,10
webcam,10
pg,10
dog,9
fashion,9
sr,9
camp,9
lgbt,9
ax,9
gdn,9
bar,9
hamburg,9
mom,9
wien,9
bi,9
beer,9
bj,9
istanbul,8
house,8
corsica,8
ki,8
kim,8
ventures,8
lat,8
how,8
restaurant,8
mp,8
mr,8
loans,8
fitness,8
dm,8
ski,8
realtor,8
yt,8
film,8
cern,8
gold,8
faith,7
sd,7
graphics,7
pictures,7
photo,7
ye,7
family,7
vote,7
nf,7
nr,7
ls,7
forsale,7
gratis,7
university,7
menu,7
quebec,7
camera,7
cards,7
build,7
solar,7
taxi,7
sl,7
weber,7
partners,7
direct,7
fan,7
pet,7
vegas,7
careers,7
bnpparibas,6
place,6
ist,6
immo,6
doctor,6
dance,6
engineering,6
rip,6
kiwi,6
aws,6
sz,6
xn--d1acj3b,6
pizza,6
hosting,6
kn,6
tg,6
poker,6
gop,6
ren,6
college,6
toys,6
nagoya,6
auto,5
holiday,5
saarland,5
properties,5
credit,5
frl,5
horse,5
garden,5
futbol,5
haus,5
wf,5
melbourne,5
xn--90ais,5
rent,5
xn--j1amh,5
inc,5
barclays,5
ne,5
alsace,5
vet,5
pink,5
tirol,4
tp,4
shoes,4
xn--c1avg,4
cars,4
clothing,4
markets,4
clinic,4
radio,4
fans,4
security,4
cricket,4
vi,4
pharmacy,4
football,4
consulting,4
aw,4
archi,4
basketball,4
vlaanderen,4
youtube,4
hm,4
fail,4
koeln,4
new,4
aq,4
kp,4
villas,4
kitchen,3
schule,3
parts,3
dhl,3
adult,3
builders,3
ong,3
yokohama,3
sharp,3
industries,3
nico,3
post,3
xn--80aswg,3
jetzt,3
cw,3
tax,3
actor,3
cab,3
car,3
krd,3
xn--fiqs8s,3
kyoto,3
sydney,3
army,3
rio,3
dental,3
leclerc,3
green,3
black,3
neustar,3
productions,3
limited,3
physio,3
goog,3
fish,3
boutique,3
supply,3
cheap,3
band,3
ck,3
gle,3
sandvik,3
moda,3
yandex,3
cg,2
pioneer,2
kred,2
computer,2
associates,2
reisen,2
soccer,2
lease,2
afl,2
gift,2
desi,2
buy,2
sbi,2
lawyer,2
hockey,2
glass,2
shell,2
healthcare,2
catering,2
equipment,2
apple,2
cologne,2
racing,2
wedding,2
bot,2
tattoo,2
flights,2
enterprises,2
delivery,2
sncf,2
komatsu,2
uol,2
mortgage,2
citic,2
brother,2
tatar,2
madrid,2
box,2
ruhr,2
observer,2
pictet,2
microsoft,2
td,2
broker,2
immobilien,2
promo,2
softbank,2
kpmg,2
jcb,1
gf,1
yahoo,1
an,1
rehab,1
ipiranga,1
xn--y9a3aq,1
miami,1
saxo,1
management,1
diamonds,1
qpon,1
sky,1
xn--90a3ac,1
realty,1
cuisinella,1
ntt,1
crs,1
lr,1
flowers,1
limo,1
shiksha,1
auction,1
coupons,1
audi,1
cooking,1
map,1
barclaycard,1
kaufen,1
hisamitsu,1
hitachi,1
abb,1
fk,1
career,1
fast,1
cs,1
ses,1
big,1
cleaning,1
cbs,1
nissan,1
lidl,1
stockholm,1
insurance,1
charity,1
xn--io0a7i,1
discount,1
zara,1
edeka,1
estate,1
repair,1
gent,1
bible,1
toyota,1
erni,1
free,1
gripe,1
hot,1
xn--3e0b707e,1
trust,1
osaka,1
organic,1
bradesco,1
insure,1
yun,1
med,1
fishing,1
rwe,1
reise,1
axa,1
luxury,1
baidu,1
attorney,1
sony,1
llc,1
homes,1
construction,1
you,1
exposed,1
flickr,1
gay,1
godaddy,1
schmidt,1
gu,1
abudhabi,1
gmail,1
sener,1
gives,1
weir,1
sap,1
zip,1
honda,1
guitars,1
study,1
ismaili,1
here,1
monash,1
country,1
hair,1
chrome,1
gmbh,1
mh,1
supplies,1
channel,1
okinawa,1
property,1
jll,1
java,1
surgery,1
kpn,1
mq,1
bauhaus,1
hiv,1
juegos,1
sucks,1
bugatti,1
forex,1
vanguard,1
toshiba,1
tennis,1
fage,1
rmit,1
tickets,1
bbc,1
bingo,1
gifts,1
amazon,1
abc,1
forum,1
goo,1
xn--tckwe,1
salon,1
