This report describes standardized data for “Conservation Agriculture Mother Trials in Malawi”. These data were standardized on 2024-01-16 by Mitchelle Njukuya with this R script. The original data have a CC-BY-4.0 license. Here you can download the standardized data.

This is the full citation of the data set:

International Maize and Wheat Improvement Center (CIMMYT) (2020). Conservation Agriculture Mother Trials in Malawi. Harvard Dataverse. Version 2.0. doi:10.7910/DVN/NZW56Q

The dataset has 1026 records and 25 variables for 4 crops (cowpea, groundnut, maize, pigeon pea) in Malawi. The dataset has 1 treatment(s): variety.


These are the first 25 records:

records
trial_id planting_date harvest_date on_farm is_survey treatment crop variety fwy_residue yield_part yield fertilizer_type N_fertilizer P_fertilizer K_fertilizer irrigated plant_density country adm2 location longitude latitude geo_from_source
6128 2018 2019 TRUE FALSE CA+Mz maize ZM 523 5525 grain 5328 urea 46 NA NA FALSE 37164 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6129 2018 2019 TRUE FALSE CA+Mz maize PAN 53 7442 grain 5529 urea 46 NA NA FALSE 37736 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6130 2018 2019 TRUE FALSE CA+Mz maize MH 30 5504 grain 2950 urea 46 NA NA FALSE 31469 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6127 2018 2019 TRUE FALSE CA+Mz maize ZM 309 2180 grain 2296 urea 46 NA NA FALSE 29399 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6118 2018 2019 TRUE FALSE CA+Mz/leg maize ZM 523 2149 grain 1492 urea 46 NA NA FALSE 18110 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6106 2018 2019 TRUE FALSE Check maize DKC 80-53 2370 grain 2003 urea 46 NA NA FALSE 23385 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6107 2018 2019 TRUE FALSE Check maize ZM 309 1952 grain 1652 urea 46 NA NA FALSE 25277 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6108 2018 2019 TRUE FALSE Check maize ZM 523 3405 grain 3228 urea 46 NA NA FALSE 33925 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6109 2018 2019 TRUE FALSE Check maize PAN 53 3413 grain 3003 urea 46 NA NA FALSE 38085 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6110 2018 2019 TRUE FALSE Check maize MH 30 2138 grain 2221 urea 46 NA NA FALSE 20621 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6111 2018 2019 TRUE FALSE CA+Mz maize DKC 80-53 1267 grain 1554 urea 46 NA NA FALSE 24032 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6112 2018 2019 TRUE FALSE CA+Mz maize ZM 309 1065 grain 1353 urea 46 NA NA FALSE 19625 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6113 2018 2019 TRUE FALSE CA+Mz maize ZM 523 1260 grain 1305 urea 46 NA NA FALSE 21172 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6114 2018 2019 TRUE FALSE CA+Mz maize PAN 53 1360 grain 1688 urea 46 NA NA FALSE 20143 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6115 2018 2019 TRUE FALSE CA+Mz maize MH 30 2153 grain 1894 urea 46 NA NA FALSE 17298 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6116 2018 2019 TRUE FALSE CA+Mz/leg maize DKC 80-53 2052 grain 1668 urea 46 NA NA FALSE 19409 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6117 2018 2019 TRUE FALSE CA+Mz/leg maize ZM 309 1912 grain 1225 urea 46 NA NA FALSE 19231 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6171 2018 2019 TRUE FALSE CA+Mz maize DKC 80-53 5911 grain 5559 urea 46 NA NA FALSE 47312 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6119 2018 2019 TRUE FALSE CA+Mz/leg maize PAN 53 1860 grain 1462 urea 46 NA NA FALSE 16986 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6120 2018 2019 TRUE FALSE CA+Mz/leg maize MH 30 1906 grain 1297 urea 46 NA NA FALSE 18594 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6121 2018 2019 TRUE FALSE Check maize DKC 80-53 2493 grain 1792 urea 46 NA NA FALSE 25221 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6122 2018 2019 TRUE FALSE Check maize ZM 309 2050 grain 1268 urea 46 NA NA FALSE 25390 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6123 2018 2019 TRUE FALSE Check maize ZM 523 5109 grain 3741 urea 46 NA NA FALSE 41242 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6124 2018 2019 TRUE FALSE Check maize PAN 53 4297 grain 3379 urea 46 NA NA FALSE 41907 Malawi Balaka Lemu 35.0532 -15.0485 FALSE
6125 2018 2019 TRUE FALSE Check maize MH 30 4344 grain 3056 urea 46 NA NA FALSE 30735 Malawi Balaka Lemu 35.0532 -15.0485 FALSE


The observations were made at 9 locations. We have coordinates for 6 of these locations.


The standardization script does not emit non-compliance warnings.

The overall quality of the dataset, given the completeness of required variables was 6.9 on a scale of 10. See the table below

variable completeness (%)
planting_date 100
harvest_date 100
crop 100
variety 100
N_fertilizer 100
P_fertilizer 0
K_fertilizer 0
irrigated 100
latitude 0
longitude 0
location 100
adm 100
yield 100


The data are further summarized in the table below.

Variable Stats / Values Freqs (% of Valid) Graph Missing
trial_id [integer]
Mean (sd) : 6438.5 (296.3)
min ≤ med ≤ max:
5926 ≤ 6438.5 ≤ 6951
IQR (CV) : 512.5 (0)
 1026 distinct values 0 (0.0%)
planting_date [integer] 1 distinct value
2018:1026(100.0%)
 0 (0.0%)
harvest_date [integer] 1 distinct value
2019:1026(100.0%)
 0 (0.0%)
on_farm [logical] 1. TRUE
1026(100.0%)
 0 (0.0%)
is_survey [logical] 1. FALSE
1026(100.0%)
 0 (0.0%)
treatment [character]
1. Alley crop
2. CA+Mz
3. CA+Mz/leg
4. CA1+ legume
5. CA1+Alley
6. CA2+Alley
7. CA2+legume
8. Check
9. Check+Alley
10. Check+legume
11. Legume intercrop
18(1.8%)
270(26.3%)
270(26.3%)
53(5.2%)
1(0.1%)
1(0.1%)
53(5.2%)
270(26.3%)
1(0.1%)
53(5.2%)
36(3.5%)
 0 (0.0%)
crop [character]
1. cowpea
2. groundnut
3. maize
4. pigeon pea
30(2.9%)
90(8.8%)
810(78.9%)
96(9.4%)
 0 (0.0%)
variety [character]
1. PAN 53
2. DKC 80-53
3. MH 30
4. ZM 523
5. SC719
6. Mtawajuni
7. CG7
8. ZM 309
9. DKC80-53
10. MH30
[ 3 others ]
144(14.0%)
126(12.3%)
126(12.3%)
126(12.3%)
108(10.5%)
96(9.4%)
90(8.8%)
54(5.3%)
36(3.5%)
36(3.5%)
84(8.2%)
 0 (0.0%)
fwy_residue [integer]
Mean (sd) : 5264.4 (2442.2)
min ≤ med ≤ max:
825 ≤ 4978 ≤ 18891
IQR (CV) : 2974 (0.5)
 943 distinct values 6 (0.6%)
yield_part [character]
1. grain
2. seed
810(78.9%)
216(21.1%)
 0 (0.0%)
yield [integer]
Mean (sd) : 3698.1 (2102.4)
min ≤ med ≤ max:
0 ≤ 3651.5 ≤ 12609
IQR (CV) : 3131.5 (0.6)
 966 distinct values 0 (0.0%)
fertilizer_type [character] 1. urea
1026(100.0%)
 0 (0.0%)
N_fertilizer [integer] 1 distinct value
46:1026(100.0%)
 0 (0.0%)
P_fertilizer [logical]
All NA's
 1026 (100.0%)
K_fertilizer [logical]
All NA's
 1026 (100.0%)
irrigated [logical] 1. FALSE
1026(100.0%)
 0 (0.0%)
plant_density [numeric]
Mean (sd) : 46060.6 (42240.5)
min ≤ med ≤ max:
3200 ≤ 38252.9 ≤ 454772
IQR (CV) : 15205.3 (0.9)
 974 distinct values 6 (0.6%)
country [character] 1. Malawi
1026(100.0%)
 0 (0.0%)
adm2 [character]
1. Balaka
2. Dowa
3. Machinga
4. Nkhotakota
5. Salima
6. Zomba
360(35.1%)
108(10.5%)
114(11.1%)
222(21.6%)
108(10.5%)
114(11.1%)
 0 (0.0%)
location [character]
1. Chinguluwe
2. Chipeni
3. Herbert
4. Lemu
5. Malula
6. Matandika
7. Mwansambo
8. Songani
9. Zidyana
108(10.5%)
108(10.5%)
114(11.1%)
132(12.9%)
114(11.1%)
114(11.1%)
114(11.1%)
114(11.1%)
108(10.5%)
 0 (0.0%)
geo_from_source [logical] 1. FALSE
1026(100.0%)
 0 (0.0%)