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.
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.