Community Data Science Workshops (Fall 2014)/Day 2 SQL project: Difference between revisions
(basic info for afternoon session) |
(→Notes) |
||
(6 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
[[File: | [[File:Database-mysql.png|right|260px]] | ||
__NOTOC__ | __NOTOC__ | ||
== Building a Dataset using | == Building a Dataset using MySQL == | ||
In this project, we will explore a few ways to gather data from Wikimedia and | In this project, we will explore a few ways to gather data from Wikimedia using [https://en.wikipedia.org/wiki/MySQL MySQL] and the [http://quarry.wmflabs.org/ Quarry] web application. Once we've done that, we will download the results of our queries in [https://en.wikipedia.org/wiki/Comma-separated_values CSV format] which can be used to ask and answer questions and visualize data in the final session. | ||
=== Goals === | === Goals === | ||
* Learn how to use SQL | * Learn how to use MySQL (a [https://en.wikipedia.org/wiki/SQL Structured Query Language]) to build datasets. | ||
* Get set up to run | * Get set up to run MySQL queries to gather data from Wikimedia projects. | ||
* Practice running | * Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles. | ||
* Create a few collections of Wikipedia data that you can do research with in the final section. | * Create a few collections of Wikipedia data that you can do research with in the final section. | ||
=== Prerequisite === | === Prerequisite === | ||
To participate in the afternoon session, you must have an a Wikimedia account. If you do not have | To participate in the afternoon session, you must have an a Wikimedia account. This is the account is used to run queries with Quarry. It is also an account you can use when you edit Wikipedia and other Wikimedia websites. | ||
If you do not have a Wikimedia account already, <font size="+1">[https://en.wikipedia.org/wiki/Special:UserLogin >>click here to create an account <<]</font>. | |||
If for some reason you are unable to create your account via the link above, try creating it via one of the links below. No matter which link you use, your account will allow you to log in to Quarry as well as any of the 100s of [https://meta.wikimedia.org/wiki/Wikimedia_projects Wikimedia project]. | |||
;Alternate account creation links | |||
* [https://meta.wikimedia.org/wiki/Special:UserLogin meta.wikimedia.org] | |||
* [https://commons.wikimedia.org/wiki/Special:UserLogin commons.wikimedia.org] | |||
* [https://www.mediawiki.org/wiki/Special:UserLogin mediawiki.org] | |||
* [https://en.wikisource.org/wiki/Special:UserLogin en.wikisource.org] | |||
* [https://en.wiktionary.org/wiki/Special:UserLogin wiktionary.org] | |||
* [https://en.wikivoyage.org/wiki/Special:UserLogin wikivoyage.org] | |||
=== Practice === | === Practice === | ||
If you would like to practice SQL on your own, you can do so in the tutorial section of [http://sqlzoo.net/wiki/Main_Page SQLZoo]. | If you would like to practice SQL on your own, you can do so in the tutorial section of [http://sqlzoo.net/wiki/Main_Page SQLZoo]. | ||
=== Notes === | |||
* For this session, you will not need to use Python or type commands on the command line. | |||
==== Queries and other notes ==== | |||
* https://etherpad.wikimedia.org/p/CDSW_fall_2014_SQL_session_1 |
Latest revision as of 18:56, 15 November 2014
Building a Dataset using MySQL[edit]
In this project, we will explore a few ways to gather data from Wikimedia using MySQL and the Quarry web application. Once we've done that, we will download the results of our queries in CSV format which can be used to ask and answer questions and visualize data in the final session.
Goals[edit]
- Learn how to use MySQL (a Structured Query Language) to build datasets.
- Get set up to run MySQL queries to gather data from Wikimedia projects.
- Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles.
- Create a few collections of Wikipedia data that you can do research with in the final section.
Prerequisite[edit]
To participate in the afternoon session, you must have an a Wikimedia account. This is the account is used to run queries with Quarry. It is also an account you can use when you edit Wikipedia and other Wikimedia websites.
If you do not have a Wikimedia account already, >>click here to create an account <<.
If for some reason you are unable to create your account via the link above, try creating it via one of the links below. No matter which link you use, your account will allow you to log in to Quarry as well as any of the 100s of Wikimedia project.
- Alternate account creation links
- meta.wikimedia.org
- commons.wikimedia.org
- mediawiki.org
- en.wikisource.org
- wiktionary.org
- wikivoyage.org
Practice[edit]
If you would like to practice SQL on your own, you can do so in the tutorial section of SQLZoo.
Notes[edit]
- For this session, you will not need to use Python or type commands on the command line.