1) By Tuesday 11/29, read this excerpt from Paul Bradshaw’s Scraping for Journalists. (You will need to know how to scrape for your
2) By Tuesday 11/29, poke around this Data Viz Catalogue.
3) By Thursday 12/1 at 10:45 a.m., complete this scraping assignment, which requires you to clean up a small data set and then analyze and visualize it.
Part 1 of your data assignment for this class will be to convert unsearchable PDFs of certified election results into .csv spreadsheet files. This is for the crowdsourced Open Elections project.
Here are detailed instructions on creating a usable .csv file for Open Elections. (Scroll down to “The Process.”) Please follow these detailed instructions. If we turn in something that varies from this format, it will be not usable for the project (and your grade will reflect this). If you have any questions, email me before 3 p.m. on Monday.
We are focusing on 2015 general election results in Mississippi. You can find your county assignment(s) here. (Here’s a list of all the the MS counties with 2015 results.)
You will need to email me your .csv files (one for each county) by 12:30 p.m. on Tuesday 11/22. You can create your .csv files by using Excel/Numbers or you can make your county spreadsheets in Google Sheets. Here’s a guide to using Google Sheets.
Here is the landline survey. Share away.
I chose to create a pie chart with the values of the reward minimum for each independent person.
I chose to make a pie chart using the kickstarter data organized by the total backer city because I thought it would be interesting to see in terms of which city backed the most.
In Google Fusion Tables, I chose to create the node chart. It linked the city by the amount donated. I thought this was a new and interesting way to see the data.
I chose to filter the donation data by city.
The visualization is on the second tab of the sheet linked below.
I used Google Fusion Tables to create a pie chart organized by the city that the donation came from. I also changed the spelling of Birmingham in one of the rows because it was spelled wrong!
Google Fusion Table
I used a Pie Chart to visualize my data. I organized it by donation amount. That seemed like a logical way to organize the data.