Editing Community Data Science Workshops (Fall 2014)/Day 2 SQL project
From CommunityData
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 1: | Line 1: | ||
[[File: | [[File:Twitter.png|right|260px]] | ||
__NOTOC__ | __NOTOC__ | ||
== Building a Dataset using | == Building a Dataset using the Twitter API == | ||
In this project, we will explore a few ways to gather data from Wikimedia using | 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 files which can be used to ask and answer questions and visualize data in the final session. | ||
=== Goals === | === Goals === | ||
* Learn how to use | * Learn how to use SQL (Structured Query Language) to build datasets. | ||
* Get set up to run | * Get set up to run SQL queries to gather data from Wikimedia and StackExchange projects. | ||
* Practice running | * Practice running SQL queries 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. | ||
=== Prerequisite === | === Prerequisite === | ||
To participate in the afternoon session, you must have an a Wikimedia account. | 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. | ||
If you do not have | |||
=== 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]. | ||