Introduction
I tracked my vegetable gardening progress between April 2021 and June 2023. The purpose of this project was to take my garbled notes and make sense of them to answer a few questions:
- When should I start each plant?
- Which plants are worth growing again and which are not?
- Which sowing and growing methods do I use the most? So, I can stock up on materials for next year.
- Where do I need to concentrate my efforts in terms of pest control?
About the Data
The data originally consisted of handwritten notes in my garden journal written between April 2021 and June 2023. When I realized it was very time consuming to search through my notes, I transferred all the information to an excel sheet. The data contains 3 tables consists of 23 fields and 53 records in xlsx format. And consists of plant information, growing methods, pests and productivity. I collected information about grocery store prices per ld.
Tools Used
- Excel (Data Collecting & Cleaning)
- SQL BigQuery (Data Exploration)
- Tableau (Visualization)
Insights
- There is no correlation between productivity and taste. Some of the less tasty varieties are ‘pretty productive'.
- Most of the 'not productive' varieties are really tasty.
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/aed91e93-11ab-4bdd-ab99-c9a4467ecc12.png)
- Some of the quicker growing varieties are more expensive at the grocery store.
- Some of the slower growing varieties are cheaper.
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/7ad54216-b133-4de4-8681-32a274aac1ec.png)
Exploring which plants I should grow using SQL
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/2de5862b-0266-46b2-9d94-1a1430a14ca6.png)
- Most of my plants were not affected by pests.
- I start most of my plants by directly seeding into the ground and in seed trays.
- I grow mostly in fabric grow bags and plastic pots.
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/6151e571-a939-480c-89e7-f7bd7e7dc023.png)
Exploring Pests and Diseases using SQL
The complete SQL code can be found Here
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/8dda254e-7f42-4ee9-9e17-eb67bb52edf0.png)
Recommendations
With the rising cost of food and questionable growing practices it makes sense to grow as much of my own food as possible.
- Herbs are a must grow at $57 per lb. and under 60 days to harvest.
- Carrots and squash may not be worth the time and effort, since they are relatively inexpensive to purchase and take a long time to grow.
- The productive but not so great tasting varieties such as Micro Tom Tomato aren't worth growing since I won't eat them.
- It may be worth growing some tastier varieties such as Dragon Tongue Beans and some of the less productive Lettuces in larger quantities to make up for their low productivity.
- Since direct seeding doesn't require equipment, I'll only need to stock up on seed trays.
- I'll need to stock up on fabric grow bags and plastic pots depending on how many plants I decide to grow next year.
- I will have to keep an eye out for white flies and aphids since they are the most prevalent of the pests in my garden.
This is the master list of of must grow and won't grow varieties:
![undefined](https://mavenanalyticsio-upload-bucket-prod.s3.us-west-2.amazonaws.com/183601303/projects/6581ca22-9378-4bb3-b16e-dc6958d76204.png)
Data Limitations
I'm a new gardener so many of my plantings were an experiment just to see if they would grow.
- This collection of data is by no means complete, I often forgot to write things down as they happened.
- Unintended casualties, i.e. dead plants were not included in this data.
- At the beginning of my gardening adventures i didn't know any better and made many many mistakes.
Data Source
Data was collected by me in a garden journal over the course of 2 years.