Name: Food.com - Recipes And Reviews
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Food.com - Recipes And Reviews

Context

The recipes dataset contains 522,517 recipes from 312 different categories. This dataset provides information about each recipe like cooking times, servings, ingredients, nutrition, instructions, and more.
The reviews dataset contains 1,401,982 reviews from 271,907 different users. This dataset provides information about the author, rating, review text, and more.

Content

The recipes dataset is provided in two different formats:

recipes.parquet and reviews.parquet are recommended as they preserve the schema of the original data.
recipes.csv is designed to be parsed in R while reviews.csv does not contain any list-columns so it can be easily parsed.

Parsing

To read recipes.csv and parse the list-column values (Images, Keywords, RecipeIngredientQuantities, RecipeIngredientParts, RecipeInstructions) in R:

library(readr)

recipes &lt;- read_csv("recipes.csv")

print(recipes$Images[3])
### "c(\"https://img.sndimg.com/food/image/upload/w_555,h_416,c_fit,fl_progressive,q_95/v1/img/recipes/40/picJ4Sz3N.jpg\", \"https://img.sndimg.com/food/image/upload/w_555,h_416,c_fit,fl_progressive,q_95/v1/img/recipes/40/pic23FWio.jpg\")"

print(eval(parse(text = recipes$Images[3])))
### "https://img.sndimg.com/food/image/upload/w_555,h_416,c_fit,fl_progressive,q_95/v1/img/recipes/40/picJ4Sz3N.jpg"
### "https://img.sndimg.com/food/image/upload/w_555,h_416,c_fit,fl_progressive,q_95/v1/img/recipes/40/pic23FWio.jpg"

To parse ISO 8601 duration format values (CookTime, PrepTime, and TotalTime) in R:

library(lubridate)

duration("PT24H45M")
### "89100s (~1.03 days)"

Tables

Recipes

@kaggle.irkaal_foodcom_recipes_and_reviews.recipes

303.69 MB
522,517 rows
28 columns

CREATE TABLE recipes (
  "recipeid" BIGINT,
  "name" VARCHAR,
  "authorid" BIGINT,
  "authorname" VARCHAR,
  "cooktime" VARCHAR,
  "preptime" VARCHAR,
  "totaltime" VARCHAR,
  "datepublished" VARCHAR,
  "description" VARCHAR,
  "images" VARCHAR,
  "recipecategory" VARCHAR,
  "keywords" VARCHAR,
  "recipeingredientquantities" VARCHAR,
  "recipeingredientparts" VARCHAR,
  "aggregatedrating" DOUBLE,
  "reviewcount" DOUBLE,
  "calories" DOUBLE,
  "fatcontent" DOUBLE,
  "saturatedfatcontent" DOUBLE,
  "cholesterolcontent" DOUBLE,
  "sodiumcontent" DOUBLE,
  "carbohydratecontent" DOUBLE,
  "fibercontent" DOUBLE,
  "sugarcontent" DOUBLE,
  "proteincontent" DOUBLE,
  "recipeservings" DOUBLE,
  "recipeyield" VARCHAR,
  "recipeinstructions" VARCHAR
);

Reviews

@kaggle.irkaal_foodcom_recipes_and_reviews.reviews

279.98 MB
1,401,982 rows
8 columns

CREATE TABLE reviews (
  "reviewid" BIGINT,
  "recipeid" BIGINT,
  "authorid" BIGINT,
  "authorname" VARCHAR,
  "rating" BIGINT,
  "review" VARCHAR,
  "datesubmitted" VARCHAR,
  "datemodified" VARCHAR
);