User:APaskulin (WMF)/Sandbox/Data

wiki_db	editors	bot_editors	bot_editor_ratio	edits	content_pages
dewiki	80531	71	0.09%	168897	2429468
hiwiki	15449	15	0.10%	20805	141852

* Metrics definition:

Editors: number of registered users who made edits on the given wiki in the given month
Bot Editors: number of users who are bots by user group or by user name and made edits on the given wiki in the given month
Bot Editor Ratio: bot editors/editors
Edits: number of edits made on the given wikis during the given month. Edits that have been reverted or deleted are included among total edits
Content pages: number of existing (non-deleted) and non-redirected pages in content namespaces on the given wikis

project	project_family	Category	Category talk	Content	File	File talk	Help	Help talk	MediaWiki	MediaWiki talk	Other	Project	Project talk	Talk	Template	Template talk	User	User talk	Grand Total	Content Edits%
en.wikipedia	wikipedia	91833	16781	1962241	89944	991	50	399	37	313	38016	764770	15027	209610	45891	10989	496897	190703	3934492	49.87%
ar.wikipedia	wikipedia	596209	80865	2619849	7552	7	77	5	0	4	5475	30403	179	93504	125069	22977	17220	1328785	4928180	53.16%
commons.wikimedia	commons	331504	388	5021	20624623	1543	160	0	29	48	27676	91794	1001	143	6975	63	224111	34532	21349611	0.02%
ca.wiktionary	wiktionary	0	0	40412	0	0	0	0	0	0	0	0	0	0	0	0	0	0	40412	100.00%
www.wikidata	wikidata	5	0	54007654	0	0	4910	10	32	36	744939	264339	745	923	2107	7	91969	1038	55118714	97.98%

Percentile	nonbot_edits_Apr	nonbot_edits_May	content page	Avg of monthly bot_editors
0.25	221	246	2869	2.5
0.5	962	983	10541	5
0.75	6250	6384	82666	8.5
1	5621913	5762249	6071412	319.5

Test[edit]