Name: Lisa's Vegetable Garden
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Lisa's Vegetable Garden

Lisa's Vegetable Garden Data

Here we're exploring Lisa Lendway's vegetable garden from summer 2020 and summer 2021, from her {gardenR} package.

The gardenR package contains data collected by Lisa Lendway from her vegetable garden, starting in the summer of 2020. Data from the summer of 2021 was added 2022-01-29 (finally!). The data were used in her Introduction to Data Science course at Macalester College to introduce many concepts. For examples, see the tutorials for the course.

Lisa also has a YouTube video with a visual tour of the garden.

What changed between 2020 and 2021?

Data Dictionary

`planting_2020.csv`

variable	class	description
plot	character	label of plot where vegetables were planted - see garden_coords dataset (in the package) for more info
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
number_seeds_planted	numeric	the exact number or a guess at how many seeds/plants were planted
date	Date	date the vegetable was planted
number_seeds_exact	logical	if number_seeds_planted is exact, this is TRUE; if it was a guess, then this is FALSE
notes	character	mostly missing but intially created just in case

`planting_2021.csv`

variable	class	description
date	Date	date the vegetable was planted
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
plot	character	label of plot where vegetables were planted - see garden_coords dataset (in the package) for more info
number_seeds_planted	numeric	the exact number or a guess at how many seeds/plants were planted
number_seeds_exact	logical	if number_seeds_planted is exact, this is TRUE; if it was a guess, then this is FALSE
notes	character	mostly missing but intially created just in case

`harvest_2020.csv`

variable	class	description
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
date	Date	date the vegetable was harvested
weight	numeric	weight harvested in grams
units	character	all "grams" - this variable was originally created in case larger vegetables were weighed in other units but there was no need

`harvest_2021.csv`

variable	class	description
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
date	Date	date the vegetable was harvested
weight	numeric	weight harvested in grams
units	character	all "grams" - this variable was originally created in case larger vegetables were weighed in other units but there was no need

`spending_2020.csv`

variable	class	description
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
brand	character	brand of seed or plant
eggplant_item_number	numeric	item number of item at Eggplant, the store where most of the seeds were purchased
price	numeric	raw price - no taxes
price_with_tax	numeric	price with taxes

`spending_2021.csv`

variable	class	description
vegetable	character	type of vegetable planted
variety	character	variety of vegetable planted, usually according to the information on the seed package, but sometimes inferred by Lisa and sometimes unknown or reseeded from last year's plants
brand	character	brand of seed or plant
price	numeric	raw price - no taxes
price_with_tax	numeric	price with taxes

Tables

Harvest 2020

@kaggle.joebeachcapital_lisas_vegetable_garden.harvest_2020

10.25 KB
781 rows
5 columns


CREATE TABLE harvest_2020 (
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "date" TIMESTAMP,
  "weight" BIGINT,
  "units" VARCHAR
);

Harvest 2021

@kaggle.joebeachcapital_lisas_vegetable_garden.harvest_2021

10.07 KB
726 rows
5 columns


CREATE TABLE harvest_2021 (
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "date" TIMESTAMP,
  "weight" BIGINT,
  "units" VARCHAR
);

Planting 2020

@kaggle.joebeachcapital_lisas_vegetable_garden.planting_2020

6.95 KB
93 rows
7 columns


CREATE TABLE planting_2020 (
  "plot" VARCHAR,
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "number_seeds_planted" DOUBLE,
  "date" TIMESTAMP,
  "number_seeds_exact" VARCHAR,
  "notes" VARCHAR
);

Planting 2021

@kaggle.joebeachcapital_lisas_vegetable_garden.planting_2021

6.99 KB
102 rows
7 columns


CREATE TABLE planting_2021 (
  "date" TIMESTAMP,
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "plot" VARCHAR,
  "number_seeds_planted" BIGINT,
  "number_seeds_exact" BOOLEAN,
  "notes" VARCHAR
);

Spending 2020

@kaggle.joebeachcapital_lisas_vegetable_garden.spending_2020

6.53 KB
65 rows
6 columns


CREATE TABLE spending_2020 (
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "brand" VARCHAR,
  "eggplant_item_number" DOUBLE,
  "price" DOUBLE,
  "price_with_tax" DOUBLE
);

Spending 2021

@kaggle.joebeachcapital_lisas_vegetable_garden.spending_2021

4.49 KB
18 rows
5 columns


CREATE TABLE spending_2021 (
  "vegetable" VARCHAR,
  "variety" VARCHAR,
  "brand" VARCHAR,
  "price" DOUBLE,
  "price_with_tax" DOUBLE
);