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+sca... [3] https://docs.google.com/spreadsheets/d/1PyFq59iEeLWpPQrWDUyU8mlmQrb4GDv2QElm... [4] bit.ly/wikipedia-tools-slides [5] bit.ly/wikipedia-tools-paper (PDF) [6] https://docs.google.com/spreadsheets/d/1sVduZul787O-bRzuy0UKpRl7bkouxwaIOsxX... [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.
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 tomac@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+sca... [3] https://docs.google.com/spreadsheets/d/1PyFq59iEeLWpPQrWDUyU8mlmQrb4GDv2QElm... [4] bit.ly/wikipedia-tools-slides [5] bit.ly/wikipedia-tools-paper (PDF) [6] https://docs.google.com/spreadsheets/d/1sVduZul787O-bRzuy0UKpRl7bkouxwaIOsxX... [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 Wikidata@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata
Hi Lane, all,
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
Thanks for creating this, I reworded it slightly, mostly removed mentions of Google Chrome, as Google Sheets add-ons work independently from the Web browser. I also left a clarifying comment on the Discussion page.
Cheers, Tom
wiki-research-l@lists.wikimedia.org