John Lavery, The Chess Players (1929)
I’ve been working on a project that, like most projects, requires testing with a dataset.
My personal criteria are:
- Relatively small size (Less than 100 KB, or 100ish rows)
- At least 5-6 features (columns)
- Should have both numerical and text-based features
- Ideally a range of different kinds of numbers
- Has good documentation
- Is open and available to the public
- Relatively available for both R and as individual CSV files or Python imports (APIs and download portals count-ish)
- Isn’t overly morbid (i.e not related to cancer, mortality, or murder, etc.)
Normally, I’d use mtcars or iris, but I’ve been a bit tired of both lately, so I asked Twitter for suggestions.
Stats/data people: Tired of iris and mtcars? Tell me about your favorite heterogenous, small dataset! (I.e. has both numerical and text-value columns), is ideally smaller than 500 rows or so, is interesting to work with.— Vicki Boykis (@vboykis) July 23, 2018
I got a lot of good answers, so I thought I’d share them here for anyone else looking for datasets.
Quick note: Attributes = features or columns Observations = Rows
- Forest Fires - A dataset examining factors that lead to forest fires in Northeast Portugal. Includes weather factors and categorical variables like days of the week. 13 attributes, 517 observations.
- Emergency Room Visits - 20 years of select emergency room visit data, by sex and age. Has a lot of data that you can limit your query to with a SQL-like query builder, but can be cumbersome to build a query. Available via R package here.
- Pigeon Racing - If you’ve ever wanted to know how fast pigeons are, you’re in luck. The national Pigeon Racing Database is here for you. Data from 2010-2018, includes the pigeon classifying number (?), the owner, and several more attributes. It can be hard to get this data out because there’s no direct CSV export.
- Street Price of Marijuana A lot of CSV files of marijuana street prices over time.
- RDataSets - An enormous compendium of datasets that shows both their R package and has a correpsonding CSV file. The site also shows whether the datasets have numberic, binary, or character inputs. Includes datasets like population of US cities, Car Speeding and Warning Signs, Weight Data for Domestic Cats, Canadian Women’s Labour-Force Participation, and Egyptian Skulls.
- Star Wars Characters Database - As an API and as an R package - Includes height, weight, birth date, and several other attributes for characters from the movies. Good for text analysis. 13 features, 87 observations
- 120 years of Olympic History - Athletes and results. Mostly text-based, with some numerial columns, available as a CSV file. 15 attributes, 271116 rows - Can be made smaller through Kaggle.
- US Census at School - Random sample of anonymized students and teachers in American schools based on selection by state, years from 2010-2018, selectable by sample size of 50-1000. Has features like height, language spoken, travel time to school, and text messages received.
- Spotify Music Classification Dataset - A dataset built for a personal project based on 2016 and 2017 songs with attributes from Spotify’s API. 16 attributes, ~1000 rows.
- A great blog post full of fun datasets like politicians having affairs and computer prices in the 1990s.
- A whole newsletter of datasets, including ones like Wikipedia edits, most popular government webpages, and a database of glaciers.
Suggestions/Comments either on Twitter or as a pull request are welcome!