Name: Coffee Quality Database From CQI
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Coffee Quality Database From CQI

Coffee Quality database

These datasets are gathered from Coffee Quality Institute (CQI) in January, 2018.
I'm not the Owner of the Datasets, nor scrapping was performed by me. It was done in this GitHub's repo (kudos for the author), see there for further details.

What about the data files?

Three CSV files are provided:

An Arabica coffee pre-cleaned dataset;
A Robusta coffee pre-cleaned dataset;
A dataset constructed through a merging of the datasets.

The file names indicates the above datasets clearly.

And what is inside?

As explained in the repo, the datasets have reviews from specialized reviewers for both coffees: arabica and robusta. The below information is provided in each dataset.

Quality Measures

Aroma
Flavor
Aftertaste
Acidity
Body
Balance
Uniformity
Cup Cleanliness
Sweetness
Moisture
Defects

Bean Metadata

Processing Method
Color
Species (arabica / robusta)

Farm Metadata

Owner
Country of Origin
Farm Name
Lot Number
Mill
Company
Altitude
Region

Related datasets

There is one related dataset here in Kaggle, please check here. It's pretty much similar to the datasets presented here, but without Robusta coffee data.

Tables

Arabica Data Cleaned

@kaggle.volpatto_coffee_quality_database_from_cqi.arabica_data_cleaned

160.94 kB
1,311 rows
44 columns

CREATE TABLE arabica_data_cleaned (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "species" VARCHAR,
  "owner" VARCHAR,
  "country_of_origin" VARCHAR,
  "farm_name" VARCHAR,
  "lot_number" VARCHAR,
  "mill" VARCHAR,
  "ico_number" VARCHAR,
  "company" VARCHAR,
  "altitude" VARCHAR,
  "region" VARCHAR,
  "producer" VARCHAR,
  "number_of_bags" BIGINT,
  "bag_weight" VARCHAR,
  "in_country_partner" VARCHAR,
  "harvest_year" VARCHAR,
  "grading_date" VARCHAR,
  "owner_1" VARCHAR,
  "variety" VARCHAR,
  "processing_method" VARCHAR,
  "aroma" DOUBLE,
  "flavor" DOUBLE,
  "aftertaste" DOUBLE,
  "acidity" DOUBLE,
  "body" DOUBLE,
  "balance" DOUBLE,
  "uniformity" DOUBLE,
  "clean_cup" DOUBLE,
  "sweetness" DOUBLE,
  "cupper_points" DOUBLE,
  "total_cup_points" DOUBLE,
  "moisture" DOUBLE,
  "category_one_defects" BIGINT,
  "quakers" DOUBLE,
  "color" VARCHAR,
  "category_two_defects" BIGINT,
  "expiration" VARCHAR,
  "certification_body" VARCHAR,
  "certification_address" VARCHAR,
  "certification_contact" VARCHAR,
  "unit_of_measurement" VARCHAR,
  "altitude_low_meters" DOUBLE,
  "altitude_high_meters" DOUBLE,
  "altitude_mean_meters" DOUBLE
);

Merged Data Cleaned

@kaggle.volpatto_coffee_quality_database_from_cqi.merged_data_cleaned

164.44 kB
1,339 rows
44 columns

CREATE TABLE merged_data_cleaned (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "species" VARCHAR,
  "owner" VARCHAR,
  "country_of_origin" VARCHAR,
  "farm_name" VARCHAR,
  "lot_number" VARCHAR,
  "mill" VARCHAR,
  "ico_number" VARCHAR,
  "company" VARCHAR,
  "altitude" VARCHAR,
  "region" VARCHAR,
  "producer" VARCHAR,
  "number_of_bags" BIGINT,
  "bag_weight" VARCHAR,
  "in_country_partner" VARCHAR,
  "harvest_year" VARCHAR,
  "grading_date" VARCHAR,
  "owner_1" VARCHAR,
  "variety" VARCHAR,
  "processing_method" VARCHAR,
  "aroma" DOUBLE,
  "flavor" DOUBLE,
  "aftertaste" DOUBLE,
  "acidity" DOUBLE,
  "body" DOUBLE,
  "balance" DOUBLE,
  "uniformity" DOUBLE,
  "clean_cup" DOUBLE,
  "sweetness" DOUBLE,
  "cupper_points" DOUBLE,
  "total_cup_points" DOUBLE,
  "moisture" DOUBLE,
  "category_one_defects" BIGINT,
  "quakers" DOUBLE,
  "color" VARCHAR,
  "category_two_defects" BIGINT,
  "expiration" VARCHAR,
  "certification_body" VARCHAR,
  "certification_address" VARCHAR,
  "certification_contact" VARCHAR,
  "unit_of_measurement" VARCHAR,
  "altitude_low_meters" DOUBLE,
  "altitude_high_meters" DOUBLE,
  "altitude_mean_meters" DOUBLE
);

Robusta Data Cleaned

@kaggle.volpatto_coffee_quality_database_from_cqi.robusta_data_cleaned

35.09 kB
28 rows
44 columns

CREATE TABLE robusta_data_cleaned (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "species" VARCHAR,
  "owner" VARCHAR,
  "country_of_origin" VARCHAR,
  "farm_name" VARCHAR,
  "lot_number" VARCHAR,
  "mill" VARCHAR,
  "ico_number" VARCHAR,
  "company" VARCHAR,
  "altitude" VARCHAR,
  "region" VARCHAR,
  "producer" VARCHAR,
  "number_of_bags" BIGINT,
  "bag_weight" VARCHAR,
  "in_country_partner" VARCHAR,
  "harvest_year" BIGINT,
  "grading_date" VARCHAR,
  "owner_1" VARCHAR,
  "variety" VARCHAR,
  "processing_method" VARCHAR,
  "fragrance_aroma" DOUBLE  -- Fragrance...Aroma,
  "flavor" DOUBLE,
  "aftertaste" DOUBLE,
  "salt_acid" DOUBLE  -- Salt...Acid,
  "bitter_sweet" DOUBLE  -- Bitter...Sweet,
  "mouthfeel" DOUBLE,
  "uniform_cup" DOUBLE,
  "clean_cup" DOUBLE,
  "balance" DOUBLE,
  "cupper_points" DOUBLE,
  "total_cup_points" DOUBLE,
  "moisture" DOUBLE,
  "category_one_defects" BIGINT,
  "quakers" BIGINT,
  "color" VARCHAR,
  "category_two_defects" BIGINT,
  "expiration" VARCHAR,
  "certification_body" VARCHAR,
  "certification_address" VARCHAR,
  "certification_contact" VARCHAR,
  "unit_of_measurement" VARCHAR,
  "altitude_low_meters" DOUBLE,
  "altitude_high_meters" DOUBLE,
  "altitude_mean_meters" DOUBLE
);