DS4UX (Spring 2016)/Panama Papers: Difference between revisions

From CommunityData
Line 61: Line 61:


* When was the most recent edit to the Panama Papers article?
* When was the most recent edit to the Panama Papers article?
:* View result in Sandbox: https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer
:* View query in Sandbox: https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=older
:* View result in browser: https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer
:* View result in browser: https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer
# When was the article about the Panama Papers created?


* When was the article about the Panama Papers created?
:* View query in Sandbox: https://en.wikipedia.org/wiki/Special:ApiSandbox#action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer
:* View result in browser: https://en.wikipedia.org/w/api.php?action=query&format=json&prop=revisions&list=&meta=&titles=Panama_Papers&rvprop=ids%7Ctimestamp%7Cflags%7Ccomment%7Cuser&rvlimit=1&rvdir=newer


* How many edits did Panama Papers receive in its first 24 hours?
:* View query in Sandbox:
:* View result in browser:
:*Note: this query returns ''data'' about each edit, but it doesn't count them for us. We need to use Python for that!


;User the Wikipedia page view API sandbox...
;User the Wikipedia page view API sandbox...

Revision as of 19:23, 27 April 2016

This page is a work in progress.

In this project, we will explore a few ways to gather data using two Wikipedia APIs: one provides data related to edits, and the other provides data related to pageviews. Once we've done that, we will extend this to code to create our own datasets of Wikipedia edits or other data that we might be able to use to ask and answer questions in the final session.

Panama Papers

Goals

  • Get set up to build datasets with Wikipedia APIs
  • Have fun collecting different types of data from Wikipedia
  • Practice reading API documentation
  • Pracice testing API queries in an API Sandbox
  • Practice reading and extending other people's code

Download and test the Wikipedia API project

Datasources

Wikipedia Edit API


Wikipedia Page View API

Exercises

Building queries in the API Sandbox

Using the Wikipedia edit API sandbox...
  • When was the most recent edit to the Panama Papers article?
  • When was the article about the Panama Papers created?
  • How many edits did Panama Papers receive in its first 24 hours?
  • View query in Sandbox:
  • View result in browser:
  • Note: this query returns data about each edit, but it doesn't count them for us. We need to use Python for that!
User the Wikipedia page view API sandbox...
  1. How many views did Panama Papers have on the day it was created?
  2. How many views did Panama Papers have yesterday?

Building queries with Python requests

  1. How many views did Panama Papers have in the first week?
  2. How many edits did Panama Papers get in the first 24 hours?

Resources