Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-27 Thread Erik Zachte
erybody who has an interest in Wikipedia and analytics. Subject: Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages? Hi Andre. Jaime's query is a good starting point, it would get you the data you need for one wiki. We can import the templatelinks table and th

Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-27 Thread Dan Andreescu
Hi Andre. Jaime's query is a good starting point, it would get you the data you need for one wiki. We can import the templatelinks table and then we can run it on Hadoop and get all wikis at once (we already have the other tables). But once we got that, we'd have a graph with millions of nodes a

Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-21 Thread Joseph Allemandou
Hi Andre, I'm not aware of any tool as you describe. I however think it would be super useful ! I'll think a bout it some more and possibly draft a ticket. Cheers Joseph On Tue, Nov 21, 2017 at 4:29 PM, Federico Leva (Nemo) wrote: > Andre Klapper, 21/11/2017 17:15: > >> I've been wondering if an

Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-21 Thread Jaime Crespo
Andre, I do not have a tool, but maybe I can give you a query on quarry to (start) do that: https://quarry.wmflabs.org/query/23197 Obviously it requires some iterations, but recursive queries are not yet available on MariaDB, so a script should do that for you. On Tue, Nov 21, 2017 at 4:15 PM,

Re: [Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-21 Thread Federico Leva (Nemo)
Andre Klapper, 21/11/2017 17:15: I've been wondering if anyone's aware of any visualization tool that draws a graph showing which wiki pages are linked from which other wiki pages (up to a certain depth) The closest thing I can think of is Erik's chart of category links, generated with a scrip

[Analytics] Tool to visualize which wiki pages link to which wiki pages?

2017-11-21 Thread Andre Klapper
Hi, trying to improve the mess of our docs for developers on mediawiki.org, I've been wondering if anyone's aware of any visualization tool that draws a graph showing which wiki pages are linked from which other wiki pages (up to a certain depth), ignores pages which include {{Outdated}} or {{Hist