Are Avocados costly everywhere in the United States?

Production: The United States is the second largest producer of avocados after Mexico. About 90% of avocado production in the United States takes place in California by more than 5,000 growers. The average grove size in California is about 13 acres. One avocado tree can produce from 200 to 500 avocados per year. About 400 million pounds of avocados are harvested each year in California alone. Florida and Hawaii produce most of the remaining 10% of avocados produced in the United States.

Consumption: Avocado consumption in the United States has doubled over the past 10 years and is now about four times higher than consumption in the mid-1990s. Avocados have become more abundant in the U.S. due to a large increase in avocado imports. From 2012-2015, U.S. net production accounted for about 20% of U.S. consumption, compared to about 80% of U.S. consumption in the 1990s.

Prices: Avocado prices have rocketed in recent years by up to 129%, with the average national price of a single Hass avocado reaching $2.10 in 2019, almost doubling in just one year. The resources needed to produce almost 200 million pounds of avocados is the reason for avocados' elevated prices. According to experts, it takes roughly 270 liters of water to grow a pound of avocados. So 200 million pounds could require as much as 54 billion liters of water, which means droughts or heat waves can have devastating consequences on the avocado industry.

Exploratory Data Analysis

Why I chose this data:

When I moved to the US, a friend once told me about Avocados and its health benefits, which I was unaware of earlier. I have loved Avocados ever since then! I love the creamy and rich texture of this fruit and I innovate dishes using avocados in my kitchen; on toasts, salads, and smoothies. Recently, I've become so fond of avocados, that I started using avocado lotions, bodywash, and also avocado oil for cooking. However, I do not indulge in them too often because they are so expensive.

I lived in California for about 8 months before I moved to Boston, and I realised the differences in cost of avocados for both organic and conventional types in both the places. I was unable to really judge the reasons of the steep prices. Therefore, I have decided to study the pattern of Avocado prices in various regions of the United States from 2015 to 2018.

The Dataset:

The above dataset on avocado prices is from here. This dataset scans data for National retail volume (units) and price. The Average Price (of avocados) in the table reflects a per unit (per avocado) cost, even when multiple units (avocados) are sold in bags. It gives us weekly average price and volume for 50 regions & cities from 2015 to 2018 for two types of avocados –– organic and conventional.

How I wanted to clean, parse and refine my data:

This dataset has multiple variables and I wanted to visualize my data through a lollipop chart. To be able to show avocado prices for two types, in the years 2015 and 2018, across 14 regions, I had to flatten my dataset and simplify it in order to append the shapes in my SVG.

A simple flowchart below shows how I imagined my data to be simplified:

The array of the dataset was simplified using Javascript & D3 to this structure:

Prices of Conventional and Organic Avocados in 2015 & 2018

Choosing 16 Regions from the dataset based on Geography:

For this visualization, I chose 4 states from each region - Mid-West, North-East, South and West. The strategy was to study the patterns of Avocado prices by grouping them based on regions, since the differences in prices is mainly due to its the location. Closer the states are to the cultivation and production sites, the cheaper their prices are per unit.

Below is a Lollipop chart that I constructed using D3 and JS. This shows the average price difference between avocados sold in 2015 and 2018 for both organic and conventional avocados. The y-axis of the chart shows the states in the order of South, North-East, Mid-west, and West from top to below.


Hover over the points to view the region, average price, year and type of avocados.

Legend:

Inferences

Organic and Conventional Avocado Prices in Boston: 2015-2018

Below is a Line Chart made using D3.js with a data-update pattern. Each year shows the fluctuations in avocado prices over 52 weeks for Boston. Particularly, I chose Boston as I live here currently and would love to study the pricing patterns because I love avocados, and this will make me more conscious about economical avocado shopping in Boston in the coming years.

However, this dataset consisits of data only upto March 2018 and hence we will see a shorter line for 2018.

Toggle between the years 2015, 2016, 2017, and 2018 to see the fluctuations of prices over time.

Hover over the dots to see the date, type and price.

Legend:

Design and Content by Tanvi Modi

References:
  • Data: Kaggle
  • Code: W3 Schools , StackOverflow, Grid Generator
  • Design Inspiration: CSS Zen Garden
  • Visualization: D3 Graph Gallery