Data Cleaning and Visualization Workshop: Home

A guide to assist all Loyola community members in incorporating Universal Design principles in their creations.

This resource showcases Loyola student and faculty digital scholarship projects as well as tools and resources for engaging in digital scholarship.

This guide will introduce you to data management best practices and tools. Topics covered will include: Data Management Plan, File Naming, Security and Backups,
Publication and Preservation

Also Data Organization in Spreadsheets for Ecology

Excel tutorial from NPR on finding, questioning, cleaning, and manipulating data.
Questions to ask about your data
Who created this dataset?
Who is responsible for maintaining it?
What point in time or time-range does it apply to?
How was the data collected?
How was the data processed after being collected?

WTFcsv gives you a quick overview of what is in your .csv (“comma-separated values”) file. It helps you quickly move to asking your spreadsheet some questions that can help you find stories to tell. For example, here is our data set for today summarized.

A data collection of Hispanic Baroque painters and paintings from 1550 to 1850. Downloaded from CulturePlex Lab, BaroqueArt, 23 Mar. 2018, http://baroqueart.cultureplex.ca and converted to Google Sheets.

Data from historical restaurant menus at the New York Public Library. Downloaded from NYPL Labs, What's on the menu?, 23 Mar. 2018, http://menus.nypl.org/data and converted to Google Sheets.

Data from the following article: Ghirlanda S, Acerbi A, Herzog H (2014) Dog Movie Stars and Dog Breed Popularity: A Case Study in Media Influence on Choice. PLoS ONE 9(9): e106565. https://doi.org/10.1371/journal.pone.0106565. Data downloaded 23 Mar. 2018 from https://figshare.com/articles/Dog_movie_stars_and_dog_breed_popularity_data_/715262 and converted to Google Sheets.

Data from City of New Orleans Police Department detailing complaints of misconduct originated by a citizen either directly to NOPD or through the IPM or by an employee of the Police Department per NOPD Misconduct Complaint Intake and Investigation policy. Downloaded from City of New Orleans Open Data, 23 Mar. 2018, https://data.nola.gov/Public-Safety-and-Preparedness/NOPD-Misconduct-Complaints/gz2m-ef5u and converted to Google Sheets.

Letters of Advice (LOAs) issued to importers and manufacturers beginning in Fiscal Year 2013. Downloaded from U.S. Consumer Product Safety Commission, Violations, 23 Mar. 2018, https://www.cpsc.gov/Recalls/Violations/ and converted to Google Sheets.

Data presenting the age-adjusted death rates, based on resident death certificates, for the 10 leading causes of death in the United States beginning in 1999. Downloaded from Data.gov, CDC, 23 Mar. 2018, https://catalog.data.gov/dataset/age-adjusted-death-rates-for-the-top-10-leading-causes-of-death-united-states-2013.

Data set of painting elements used in the works painted during episodes of Bob Ross “The Joy of Painting.” Data set was created for Walt Hickey, FiveThirtyEight, "A Statistical Analysis of the Work of Bob Ross." Data downloaded 23 Mar. 2018 from https://github.com/fivethirtyeight/data/tree/master/bob-ross.

Data on Pacific walrus haulouts. Downloaded from U.S. Geological Survey, Alaska Science Center, 23 Mar. 2018, https://alaska.usgs.gov/products/data.php?dataid=74 and converted to Google Sheets.

Animals registered with Sunshine Coast Council, 2016-present. Downloaded from Sunshine Coast Council, 4 Apr. 2018, https://data.sunshinecoast.qld.gov.au/Administration/Registered-Animals/7f87-i6kx/about and converted to Google Sheets.