Forwarding to the Wiki Medicine mailing list, and also to the Cascadia
Wikimedians mailing list because we've had discussions about how to
prioritize the development of articles related to WikiProject Seattle.

Thanks,

Pine

---------- Forwarded message ----------
From: Lane Rasberry <l...@bluerasberry.com>
Date: Mon, May 9, 2016 at 8:38 AM
Subject: Re: [Wiki-research-l] [Wikidata] [ANN] Wikipedia Tools for Google
Spreadsheets
To: "Discussion list for the Wikidata project." <
wikid...@lists.wikimedia.org>, Research into Wikimedia content and
communities <wiki-researc...@lists.wikimedia.org>, Thomas Steiner <
to...@google.com>


Hello,

I wanted to make an on-wiki place to host discussion of the tool so I set
up this project page on meta.
<https://meta.wikimedia.org/wiki/Wikipedia_Tools_for_Google_Spreadsheets>

This is an interesting tool. I have been playing with it for some weeks
trying to learn whether it could be used to generate monthly traffic
reports for sets of Wikipedia articles. Among editors of Wikipedia's
medical articles, there is continual discussion about monthly article
traffic for certain sets of articles, and I think that somehow this tool
could be used to get those reports for health articles in different
languages.

If anyone wants to join me in discussing the tool then write me or meet me
on that wiki page.

yours,

On Mon, May 2, 2016 at 4:08 AM, Thomas Steiner <to...@google.com> wrote:

> Esteemed Wikipedia, Wikidata, Linked Data, and Semantic Web communities[*],
>
> ===
> tl;dr: Released a Google Spreadsheets add-on called Wikipedia Tools
> [1] that makes working with data from Wikipedia and Wikidata a breeze.
> ===
>
> I am happy to release a Google Spreadsheets add-on called Wikipedia
> Tools [1]. This add-on allows you to work with data from Wikipedia and
> Wikidata from within a spreadsheet context using custom formulas. Let
> me motivate the tools with a short example:
>
> You may have heard of Volkswagen's #DieselGate scandal. Is this still
> a problem for Volkswagen—and if so, where? Google Trends to the
> rescue? Maybe [2]. But what about global impact? How do people in
> Korea, an important Volkswagen export market [citation needed😉],
> refer to the scandal? Turns out they call it 폭스바겐 배기가스 조작 (among
> probably other options).
>
> With a custom function from Wikipedia Tools, we can safely "translate"
> from one English (a language that, for the sake of this example, we
> assume we dominate well enough) Wikipedia article to many other
> languages (that we do not necessarily dominate):
>
> =WIKITRANSLATE("en:Volkswagen_emissions_scandal")
>   bg Афера на Фолксваген
>   cs Dieselgate
>   de VW-Abgasskandal
>   […]
>   zh 福斯集團汽車舞弊事件
>
> Then, using Wikipedia page views as one (among others) reasonable
> popularity indicator, for each of these language results, for example
> for Korean, we can get =WIKIPAGEVIEWS("ko:폭스바겐 배기가스 조작") for the last
> n days, and plot the results [3] (in practice, you would probably
> still normalize by size and/or total views of the particular
> Wikipedia[**]).
>
> There are a lot more custom functions implemented than I could cover
> in this short example. I have put together a slide deck [4] and paper
> [5] that go into more detail if you are interested, a demo with all
> functions is available at [6]. The add-on also has a built-in manual
> (in Google Sheets, click Add-ons→Wikipedia Tools→Show documentation)
> and its underlying code is open-source [7].
>
> Please let me know in case of any open question, feature request, or
> bug. Thanks!
>
> Cheers,
> Tom
>
> --
> [1] http://bit.ly/wikipedia-tools-add-on
> [2]
> http://www.google.com/trends/explore?hl=en-US&q=volkswagen+emissions+scandal,+dieselgate&date=today+12-m
> [3]
> https://docs.google.com/spreadsheets/d/1PyFq59iEeLWpPQrWDUyU8mlmQrb4GDv2QElmEU9aFec/edit?usp=sharing
> [4] bit.ly/wikipedia-tools-slides
> [5] bit.ly/wikipedia-tools-paper (PDF)
> [6]
> https://docs.google.com/spreadsheets/d/1sVduZul787O-bRzuy0UKpRl7bkouxwaIOsxXuJGm6yg/edit?usp=sharing
> [7] https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/
> [*] Cross-posted on purpose
> (http://ruben.verborgh.org/blog/2014/01/31/apologies-for-cross-posting/),
> please choose your reply options accordingly.
> [**] This is a simple example for illustrative purposes, I do _not_
> claim it is an accurate popularity prediction, nor do I mean to bash
> Volkswagen.
>
> --
> Dr. Thomas Steiner, Employee (http://blog.tomayac.com,
> https://twitter.com/tomayac)
>
> Google Germany GmbH, ABC-Str. 19, 20354 Hamburg, Germany
> Managing Directors: Matthew Scott Sucherman, Paul Terence Manicle
> Registration office and registration number: Hamburg, HRB 86891
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.29 (GNU/Linux)
>
>
> iFy0uwAntT0bE3xtRa5AfeCheCkthAtTh3reSabiGbl0ck0fjumBl3DCharaCTersAttH3b0ttom
> hTtPs://xKcd.cOm/1181/
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Wikidata mailing list
> wikid...@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikidata
>



-- 
Lane Rasberry
user:bluerasberry on Wikipedia
206.801.0814
l...@bluerasberry.com

_______________________________________________
Wiki-research-l mailing list
wiki-researc...@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
_______________________________________________
Wikimedia-Medicine mailing list
Wikimedia-Medicine@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikimedia-medicine

Reply via email to