Learning and Evaluation/Wikiresearch webinars

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
Share icon WHITE-01.svgLearning and Evaluation

Wikiresearch Webinars[edit]

Sessions[edit]

Check for more details on upcoming webinars and other related events at the Evaluation portal news page

Part 1: Beyond Wikimetrics[edit]

date: July 16 2014

MySQL overview[edit]

API overview[edit]

Part 2: Becoming Wikimetrics[edit]

In the second part of our series, we will learn how to write and run MySQL queries against the Wikimedia MySQL databases. The replica databases hosted on Wikimedia Cloud VPS allow you to ask questions about what is happening on Wikimedia projects such as "how many people have edited articles that I created?" and get back a precise answer in the form of data. A new tool called Quarry will help us ask and answer these questions together.

This session will be more interactive than the first session: you will have the opportunity to write and run your own queries, and collect your own data! Veteran query-wranglers will be standing by in #wikimedia-researchconnect ready to answer any questions you might have, and to help you if you get stuck.

Explanatory queries
Example queries

Part 3: Building on Wikimetrics[edit]

In our third session, we will talk about the Python programming language, and the JSON and CSV data storage formats. We will walk step by step through several example research "projects" that involve downloading MySQL results from Quarry and using Python to combine the data with other results available through the MediaWiki API and the stats.grok.se pageview API.

Python scripts and sample CSVs for today's exercises

folder of Python scripts. Download this file, unzip it, and place it on your desktop.

Setting up and running Python scripts
Challenge queries
Python research project queries
Sample API requests
Data visualization

Getting help[edit]

Resources[edit]

please add new resources that you think would be helpful to others

Research tools[edit]

Data[edit]

Software[edit]

Learning[edit]

Setup and practice
MySQL
Python