Get pages with most page views (including their translated versions) on mediawiki.org for last six months
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Aklapper
	Sep 10 2018, 4:05 PM

Description

...because T185202 is meh and translated versions are counted separately.
I'm curious about these numbers as it's a potential data source for T653.

Mentioned Here: P7532 page views mw.org
T653: Refresh the mediawiki.org homepage
T185202: Top views should strip "Special:MyLanguage" prefix for mediawiki.org pages and merge the number of pageviews with the non-prefixed result

http://tools.wmflabs.org/topviews : Uncheck "Show only mainspace pages"
Download all the top pageviews on mw.org for last six months as CSV
Concatenante the six files into one CSV file
Remove the "Edits" and "Editors" columns
Drop all "Special:MyLanguage/" prefixes
Drop language version suffixes/subpages
Make sure there's a heading row left
In Libreoffice, Data > Pivot Table > Create and drag page name column to Row Fields and drag pageview column to Data Fields

(Data also includes redirected pages separately.)

Result in P7532