Here are all 96610 subcategories of Education, with 2.6 million articles.
The problem is sometimes one unexpected subcategory can draw in lots of unexpected content, and the most viewed article can thus be totally off-topic.
I could do some iterations and prune the tree into something more manageable, by blacklisting weird subbranches.
Erik Zachte
From: Wiki-research-l [mailto:wiki-research-l-bounces@lists.wikimedia.org] On Behalf Of Leila Zia
Sent: Thursday, April 21, 2016 23:13
To: Research into Wikimedia content and communities
Subject: Re: [Wiki-research-l] Finding the most viewed Wikipedia articles on education
John, I played with Wikipedia Tools for Google and I'm sure it will do what you're looking for. Check out this Google spreadsheet. You just have to repeat a slightly modified formula in columns B and C to get what you have in column D for all subcategories of Education listed in A. You can automate that part, too.
L
On Thu, Apr 21, 2016 at 12:39 PM, john cummings <mrjohncummings@gmail.com> wrote:
Hi Leila
Thanks very much, what I need to be able to do is get all the articles within the category and subcategories of Category:Education and then get page views for all of them, its a lot of pages...... My friend Ed Saperia created a spreadsheet to do this but unfortunately the query API limits to a few 100 articles so its not possible to run the query through that.
Any other suggestions would be very much appreciated.
Thanks
John
On 21 April 2016 at 18:54, Leila Zia <leila@wikimedia.org> wrote:
Hi John,
Two comments:
* Have you tried Wikipedia Tools for Google? It's a very neat add-on for Chrome, and in your case, the two functions WIKICATEGORYMEMBERS and WIKIPAGEVIEWS may help you get what you want.
* If you are looking for having a list of articles related to Education that are available in English and are missing in another language, you can use the article recommendation API. For example: http://recommend.wmflabs.org/api?s=en&t=fr&n=10&article=Education gives you the top 10 recommendations for articles related to Education that are available in English but missing in French. Note that "related" is not the same as articles that are in category "Education" though I hope we can accommodate categories in the future. The documentation for the API is in here.
Hope this helps.
Best,
Leila
Leila Zia
Research Scientist
Wikimedia Foundation
On Thu, Apr 21, 2016 at 5:04 AM, john cummings <mrjohncummings@gmail.com> wrote: