Editing Community Data Science Workshops (Fall 2014)/Day 2 SQL project
From CommunityData
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
| Latest revision | Your text | ||
| Line 5: | Line 5: | ||
== Building a Dataset using MySQL == | == Building a Dataset using MySQL == | ||
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] | 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 MySQL (a [https://en.wikipedia.org/wiki/SQL Structured Query Language]) to build datasets. | * Learn how to use MySQL (a [https://en.wikipedia.org/wiki/SQL Structured Query Language]) to build datasets. | ||
* Get set up to run MySQL queries to gather data from Wikimedia projects. | * 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. | * 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. | ||
