Coffee Quality Database From CQI

A database scrapped from Coffee Quality Institute

@kaggle.volpatto_coffee_quality_database_from_cqi

Table List

3 tables(352.02 KB)

Arabica Data Cleaned

Merged Data Cleaned

Robusta Data Cleaned

Merged Data Cleaned

@kaggle.volpatto_coffee_quality_database_from_cqi.merged_data_cleaned

160.59 KB
1339 rows
44 columns

unnamed_0 Unnamed: 0	species Species	owner Owner	country_of_origin Country.of.Origin	farm_name Farm.Name	lot_number Lot.Number	mill Mill	ico_number ICO.Number	company Company	altitude Altitude	region Region	producer Producer	number_of_bags Number.of.Bags	bag_weight Bag.Weight	in_country_partner In.Country.Partner	harvest_year Harvest.Year	grading_date Grading.Date	owner_1 Owner.1	variety Variety	processing_method Processing.Method	aroma Aroma	flavor Flavor	aftertaste Aftertaste	acidity Acidity	body Body	balance Balance	uniformity Uniformity	clean_cup Clean.Cup	sweetness Sweetness	cupper_points Cupper.Points	total_cup_points Total.Cup.Points	moisture Moisture	color Color	category_two_defects Category.Two.Defects	expiration Expiration	certification_body Certification.Body	certification_address Certification.Address	certification_contact Certification.Contact	unit_of_measurement Unit Of Measurement	altitude_low_meters Altitude Low Meters	altitude_high_meters Altitude High Meters	altitude_mean_meters Altitude Mean Meters
	Arabica	metad plc	Ethiopia	metad plc	nan	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	nan	Washed / Wet	8.67	8.83	8.67	8.75	8.5	8.42	10	10	10	8.75	90.58	0.12	Green		April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950	2200	2075
1	Arabica	metad plc	Ethiopia	metad plc	nan	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	Other	Washed / Wet	8.75	8.67	8.5	8.58	8.42	8.42	10	10	10	8.58	89.92	0.12	Green	1	April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950	2200	2075
2	Arabica	grounds for health admin	Guatemala	san marcos barrancas "san cristobal cuch	nan	nan	nan	nan	1600 - 1800 m	nan	nan	5	1	Specialty Coffee Association	nan	May 31st, 2010	Grounds for Health Admin	Bourbon	nan	8.42	8.5	8.42	8.42	8.33	8.42	10	10	10	9.25	89.75		nan		May 31st, 2011	Specialty Coffee Association	36d0d00a3724338ba7937c52a378d085f2172daa	0878a7d4b9d35ddbf0fe2ce69a2062cceb45a660	m	1600	1800	1700
3	Arabica	yidnekachew dabessa	Ethiopia	yidnekachew dabessa coffee plantation	nan	wolensu	nan	yidnekachew debessa coffee plantation	1800-2200	oromia	Yidnekachew Dabessa Coffee Plantation	320	60 kg	METAD Agricultural Development plc	2014	March 26th, 2015	Yidnekachew Dabessa	nan	Natural / Dry	8.17	8.58	8.42	8.42	8.5	8.25	10	10	10	8.67	89	0.11	Green	2	March 25th, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1800	2200	2000
4	Arabica	metad plc	Ethiopia	metad plc	nan	metad plc	2014/2015	metad agricultural developmet plc	1950-2200	guji-hambela	METAD PLC	300	60 kg	METAD Agricultural Development plc	2014	April 4th, 2015	metad plc	Other	Washed / Wet	8.25	8.5	8.25	8.5	8.42	8.33	10	10	10	8.58	88.83	0.12	Green	2	April 3rd, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1950	2200	2075
5	Arabica	ji-ae ahn	Brazil	nan	nan	nan	nan	nan	nan	nan	nan	100	30 kg	Specialty Coffee Institute of Asia	2013	September 3rd, 2013	Ji-Ae Ahn	nan	Natural / Dry	8.58	8.42	8.42	8.5	8.25	8.33	10	10	10	8.33	88.83	0.11	Bluish-Green	1	September 3rd, 2014	Specialty Coffee Institute of Asia	726e4891cf2c9a4848768bd34b668124d12c4224	b70da261fcc84831e3e9620c30a8701540abc200	m
6	Arabica	hugo valdivia	Peru	nan	nan	hvc	nan	richmond investment-coffee department	nan	nan	HVC	100	69 kg	Specialty Coffee Institute of Asia	2012	September 17th, 2012	Hugo Valdivia	Other	Washed / Wet	8.42	8.5	8.33	8.5	8.25	8.25	10	10	10	8.5	88.75	0.11	Bluish-Green		September 17th, 2013	Specialty Coffee Institute of Asia	726e4891cf2c9a4848768bd34b668124d12c4224	b70da261fcc84831e3e9620c30a8701540abc200	m
7	Arabica	ethiopia commodity exchange	Ethiopia	aolme	nan	c.p.w.e	010/0338	nan	1570-1700	oromia	Bazen Agricultural & Industrial Dev't Plc	300	60 kg	Ethiopia Commodity Exchange	March 2010	September 2nd, 2010	Ethiopia Commodity Exchange	nan	nan	8.25	8.33	8.5	8.42	8.33	8.5	10	10	9.33	9	88.67	0.03	nan		September 2nd, 2011	Ethiopia Commodity Exchange	a176532400aebdc345cf3d870f84ed3ecab6249e	61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24b	m	1570	1700	1635
8	Arabica	ethiopia commodity exchange	Ethiopia	aolme	nan	c.p.w.e	010/0338	nan	1570-1700	oromiya	Bazen Agricultural & Industrial Dev't Plc	300	60 kg	Ethiopia Commodity Exchange	March 2010	September 2nd, 2010	Ethiopia Commodity Exchange	nan	nan	8.67	8.67	8.58	8.42	8.33	8.42	9.33	10	9.33	8.67	88.42	0.03	nan		September 2nd, 2011	Ethiopia Commodity Exchange	a176532400aebdc345cf3d870f84ed3ecab6249e	61bbaf6a9f341e5782b8e7bd3ebf76aac89fe24b	m	1570	1700	1635
9	Arabica	diamond enterprise plc	Ethiopia	tulla coffee farm	nan	tulla coffee farm	2014/15	diamond enterprise plc	1795-1850	snnp/kaffa zone,gimbowereda	Diamond Enterprise Plc	50	60 kg	METAD Agricultural Development plc	2014	March 30th, 2015	Diamond Enterprise Plc	Other	Natural / Dry	8.08	8.58	8.5	8.5	7.67	8.42	10	10	10	8.5	88.25	0.1	Green	4	March 29th, 2016	METAD Agricultural Development plc	309fcf77415a3661ae83e027f7e5f05dad786e44	19fef5a731de2db57d16da10287413f5f99bc2dd	m	1795	1850	1822.5


CREATE TABLE merged_data_cleaned (
  "unnamed_0" BIGINT,
  "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
);