Baselight

Candy Power Rankings Dataset

Attributes and Popularity Rankings for Halloween Candy

@fivethirtyeight.candy_power_ranking

Candy Power Rankings And Attributes
@fivethirtyeight.candy_power_ranking.candy_data

Column Description
competitorname Name of the candy
chocolate 1 if the candy contains chocolate, 0 otherwise
fruity 1 if the candy is fruit-flavored, 0 otherwise
caramel 1 if the candy contains caramel, 0 otherwise
peanutalmondy 1 if the candy contains peanuts, peanut butter, or almonds, 0 otherwise
nougat 1 if the candy contains nougat, 0 otherwise
crispedricewafer 1 if the candy contains crisped rice, wafers, or a cookie component, 0 otherwise
hard 1 if the candy is hard candy, 0 otherwise
bar 1 if the candy is a candy bar, 0 otherwise
pluribus 1 if the candy is one of many candies in a bag or box (individually wrapped), 0 otherwise
sugarpercent The percentile of sugar content compared to other candies in the dataset
pricepercent The unit price percentile compared to other candies in the dataset
winpercent The overall win percentage in 269,000 head-to-head matchups
  • 12.19 KB
  • 85 rows
  • 13 columns
competitorname

Competitorname

chocolate

Chocolate

fruity

Fruity

caramel

Caramel

peanutyalmondy

Peanutyalmondy

nougat

Nougat

crispedricewafer

Crispedricewafer

hard

Hard

bar

Bar

pluribus

Pluribus

sugarpercent

Sugarpercent

pricepercent

Pricepercent

winpercent

Winpercent

100 Grand11110.731999990.8600000166.971725
3 Musketeers1110.603999970.5109999867.602936
One dime0.0110.11632.261086
One quarter0.0110.5109999846.116505
Air Heads10.906000020.5109999852.341465
Almond Joy1110.4650.7670000250.347546
Baby Ruth111110.603999970.7670000256.914547
Boston Baked Beans110.312999990.5109999823.417824
Candy Corn10.906000020.3249999938.010963
Caramel Apple Pops110.603999970.3249999934.517681

CREATE TABLE candy_data (
  "competitorname" VARCHAR,
  "chocolate" BIGINT,
  "fruity" BIGINT,
  "caramel" BIGINT,
  "peanutyalmondy" BIGINT,
  "nougat" BIGINT,
  "crispedricewafer" BIGINT,
  "hard" BIGINT,
  "bar" BIGINT,
  "pluribus" BIGINT,
  "sugarpercent" DOUBLE,
  "pricepercent" DOUBLE,
  "winpercent" DOUBLE
);

Share link

Anyone who has the link will be able to view this.