Community Data Science Workshops (Fall 2014)/Day 2 SQL project: Difference between revisions
From CommunityData
(swap logo) |
(links, title) |
||
| Line 3: | Line 3: | ||
__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 StackExchange projects using the Quarry and Data Explorer applications. Once we've done that, we will download the results of our queries in CSV | In this project, we will explore a few ways to gather data from Wikimedia and StackExchange projects using [https://en.wikipedia.org/wiki/MySQL MySQL] and the [http://quarry.wmflabs.org/ Quarry] and [http://data.stackexchange.com/ Data Explorer] applications. 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 and StackExchange projects. | ||
* Practice running | * Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles and answering questions on StackOverflow. | ||
* 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. | ||
Revision as of 23:32, 14 November 2014
Building a Dataset using MySQL
In this project, we will explore a few ways to gather data from Wikimedia and StackExchange projects using MySQL and the Quarry and Data Explorer applications. 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
- Learn how to use MySQL (a Structured Query Language) to build datasets.
- Get set up to run MySQL queries to gather data from Wikimedia and StackExchange projects.
- Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles and answering questions on StackOverflow.
- Create a few collections of Wikipedia data that you can do research with in the final section.
Prerequisite
To participate in the afternoon session, you must have an a Wikimedia account. If you do not have an account already, you can create one by following these steps.
Practice
If you would like to practice SQL on your own, you can do so in the tutorial section of SQLZoo.
