Get prefixed pages for each wiki

Out[6]:
dbname pagesWithPrefix totalMainNsPages
0 afwiktionary 0 22173
1 amwiktionary 0 770
2 angwiktionary 0 2464
3 anwiktionary 0 4083
4 arwiktionary 0 72467
5 astwiktionary 0 35396
6 aywiktionary 0 1156
7 azwiktionary 0 56380
8 bclwiktionary 0 2065
9 bewiktionary 0 4634
10 bgwiktionary 0 787656
11 bnwiktionary 15 14941
12 brwiktionary 0 46177
13 bswiktionary 0 7871
14 cawiktionary 0 477960
15 chrwiktionary 0 194587
16 cowiktionary 0 9494
17 csbwiktionary 0 1570
18 cswiktionary 0 129863
19 cywiktionary 0 24818
20 dawiktionary 0 40880
21 dewiktionary 0 953897
22 diqwiktionary 0 4789
23 dvwiktionary 0 433
24 elwiktionary 0 807013
25 enwiktionary 0 6601989
26 eowiktionary 0 105580
27 eswiktionary 0 906391
28 etwiktionary 0 150003
29 euwiktionary 0 54948
... ... ... ...
70 kywiktionary 0 73358
71 lawiktionary 0 35058
72 lbwiktionary 0 8241
73 liwiktionary 0 116078
74 lnwiktionary 0 684
75 lowiktionary 0 61345
76 ltwiktionary 1 631569
77 lvwiktionary 0 11716
78 mgwiktionary 0 1696776
79 minwiktionary 0 9034
80 miwiktionary 0 1080
81 mkwiktionary 0 4966
82 mlwiktionary 2 131683
83 mnwiktionary 1 44777
84 mrwiktionary 0 2143
85 mswiktionary 11 7619
86 mtwiktionary 0 2038
87 mywiktionary 0 124786
88 nahwiktionary 0 7532
89 nawiktionary 0 565
90 ndswiktionary 1 8130
91 newiktionary 0 14875
92 niawiktionary 0 1948
93 nlwiktionary 0 776961
94 nnwiktionary 5 12157
95 nowiktionary 14 145385
96 ocwiktionary 4 57163
97 omwiktionary 0 835
98 orwiktionary 9 108780
99 pawiktionary 0 15551

100 rows × 3 columns

Get existing aliases

Out[7]:
dbname Aliases for NS_PROJECT Short aliases for NS_PROJECT
0 afwiktionary
1 amwiktionary
2 angwiktionary Wiciwordboc, Wiciwordbōc, Wikiwordboc, Wiktion...
3 anwiktionary Wiktionary
4 arwiktionary Wiktionary
5 astwiktionary Uiccionariu, Wiktionary
6 aywiktionary
7 azwiktionary Wiktionary
8 bclwiktionary Wiktionary
9 bewiktionary Wiktionary
10 bgwiktionary Wiktionary
11 bnwiktionary Wiktionary
12 brwiktionary Wiktionary
13 bswiktionary Vikirječnik, Wiktionary
14 cawiktionary Wiktionary
15 chrwiktionary
16 cowiktionary
17 csbwiktionary
18 cswiktionary WS, WT, Wiktionary WS, WT
19 cywiktionary Wiktionary
20 dawiktionary
21 dewiktionary WT WT
22 diqwiktionary Wiktionary
23 dvwiktionary Wiktionary
24 elwiktionary Wiktionary
25 enwiktionary WT WT
26 eowiktionary Wiktionary
27 eswiktionary WN, Wiktionary WN
28 etwiktionary Wiktionary
29 euwiktionary
... ... ... ...
70 kywiktionary
71 lawiktionary Wiktionary
72 lbwiktionary Wiktionary
73 liwiktionary
74 lnwiktionary
75 lowiktionary
76 ltwiktionary Wiktionary
77 lvwiktionary Wiktionary
78 mgwiktionary
79 minwiktionary Wiktionary
80 miwiktionary
81 mkwiktionary Wiktionary
82 mlwiktionary Wiktionary, വിക്കി‌‌ നിഘണ്ടു
83 mnwiktionary
84 mrwiktionary Wiktionary
85 mswiktionary
86 mtwiktionary Wiktionary
87 mywiktionary WT, Wiktionary WT
88 nahwiktionary Wikipedia
89 nawiktionary
90 ndswiktionary
91 newiktionary Wiktionary
92 niawiktionary
93 nlwiktionary Wiktionary
94 nnwiktionary
95 nowiktionary
96 ocwiktionary Wiktionary
97 omwiktionary
98 orwiktionary Wiktionary
99 pawiktionary

100 rows × 3 columns

Number of different short aliases

Out[11]:
Alias Number of usages Number of usages (%)
0 WS 1 9.090909
1 WT 5 45.454545
2 WN 1 9.090909
3 وو 1 9.090909
4 WZ 1 9.090909
5 낱 1 9.090909
6 WF 1 9.090909

Aggregate data

Out[8]:
Variable Value %
0 NonzeroPrefixedPages 17 17.0
1 ZeroPrefixedPages 83 83.0
2 TotalProjects 100 100.0
3 LessThanThousandContentPages 11 11.0
4 MoreThanOneShortAlias 10 10.0
5 MoreThanShortAliasOrNonzeroPrefixedPages 27 27.0
In [ ]: