This report describes standardized data for “Rainfed rice yield and management data from 2006 to 2010 on farmer’s fields under conservation agriculture in the Lake Alaotra region of Madagascar”. These data were standardized on 2023-10-18 by Cedric Ngakou with this R script. The original data have a ETALAB license. Because of the restrictions of this license, you need to run the script yourself to get the standardized data.

This is the full citation of the data set:

Bruelle, Guillaume; Domas, Raphael; Andriamalala, Herizo; Hyac, Paulin; Ravonomanana, Jean Eddy (2020). Rainfed rice yield and management data from 2006 to 2010 on farmer’s fields under conservation agriculture in the Lake Alaotra region of Madagascar. CIRAD Dataverse . Version 1.2. doi:10.18167/DVN1/2EHEQT

You can also consult the accompanying paper.

The dataset has 3803 records and 30 variables for rice in Madagascar. The dataset has 3 treatment(s): land_prep_method, landscape_position, OM_amount.


These are the first 25 records:

records
country location longitude latitude geo_from_source trial_id planting_date season on_farm is_survey crop yield_part yield fertilizer_type N_fertilizer P_fertilizer K_fertilizer OM_used OM_type OM_amount inoculated irrigated land_prep_method rain herbicide_used herbicide_product soil_type landscape_position
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070566 2006-12-25 2006-2007 TRUE FALSE rice grain 980.0 urea;NPK 46.000 0.00000 0.000000 FALSE none 0.0 FALSE TRUE conventional 1130.7 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070688 2006-12-19 2006-2007 TRUE FALSE rice grain 1704.5 urea;NPK 37.628 0.00000 0.000000 FALSE none 0.0 FALSE TRUE reduced tillage 1132.1 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2008090875 2008-11-11 2008-2009 TRUE FALSE rice grain 4300.0 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 600.0 FALSE TRUE reduced tillage 925.0 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070689 2006-12-06 2006-2007 TRUE FALSE rice grain 1585.4 urea;NPK 56.523 10.15459 14.033690 TRUE horse manure 4166.7 FALSE TRUE reduced tillage 1144.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070561 2006-12-28 2006-2007 TRUE FALSE rice grain 1578.9 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 1578.9 FALSE TRUE conventional 1088.9 FALSE none hillside hillside
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070581 2006-12-23 2006-2007 TRUE FALSE rice grain 3500.0 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 3928.6 FALSE TRUE conventional 1132.1 TRUE glyphosate lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070693 2006-12-31 2006-2007 TRUE FALSE rice grain 2114.3 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 4166.7 FALSE TRUE conventional 1087.5 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070116 2006-12-06 2006-2007 TRUE FALSE rice grain 3500.0 urea;NPK 22.655 6.40786 8.855697 FALSE none 0.0 FALSE TRUE reduced tillage 1144.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070115 2006-12-04 2006-2007 TRUE FALSE rice grain 3280.0 urea;NPK 18.400 0.00000 0.000000 TRUE horse manure 1666.7 FALSE TRUE reduced tillage 1091.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070690 2006-12-24 2006-2007 TRUE FALSE rice grain 3631.3 urea;NPK 30.723 26.83231 37.082400 TRUE horse manure 6983.2 FALSE TRUE reduced tillage 1131.1 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070583 2006-12-09 2006-2007 TRUE FALSE rice grain 1500.0 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 3571.4 FALSE TRUE reduced tillage 1137.1 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070560 2006-12-29 2006-2007 TRUE FALSE rice grain 2750.0 urea;NPK 46.000 0.00000 0.000000 TRUE horse manure 2083.3 FALSE TRUE conventional 1089.5 FALSE none hillside hillside
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070584 2006-11-29 2006-2007 TRUE FALSE rice grain 1596.4 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 3928.6 FALSE TRUE reduced tillage 1105.7 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070169 2006-12-06 2006-2007 TRUE FALSE rice grain 2530.6 urea;NPK 55.499 15.68821 21.681188 TRUE horse manure 3225.8 FALSE TRUE conventional 1144.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2008090874 2008-11-11 2008-2009 TRUE FALSE rice grain 4125.0 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 400.0 FALSE TRUE reduced tillage 925.0 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070692 2006-12-02 2006-2007 TRUE FALSE rice grain 1709.1 urea;NPK 0.000 0.00000 0.000000 TRUE horse manure 3125.0 FALSE TRUE reduced tillage 1106.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070558 2006-11-24 2006-2007 TRUE FALSE rice grain 3529.4 urea;NPK 40.572 0.00000 0.000000 TRUE horse manure 1666.7 FALSE TRUE reduced tillage 1171.3 FALSE none hillside hillside
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070601 2006-12-01 2006-2007 TRUE FALSE rice grain 3250.0 urea;NPK 68.000 19.21397 26.553813 TRUE horse manure 2750.0 FALSE TRUE reduced tillage 1106.1 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070117 2006-12-15 2006-2007 TRUE FALSE rice grain 2342.9 urea;NPK 26.266 0.00000 0.000000 TRUE horse manure 2083.3 FALSE TRUE conventional 1132.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070118 2006-12-06 2006-2007 TRUE FALSE rice grain 3800.0 urea;NPK 23.000 0.00000 0.000000 TRUE horse manure 3225.8 FALSE TRUE reduced tillage 1144.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070564 2006-12-13 2006-2007 TRUE FALSE rice grain 2875.0 urea;NPK 34.500 0.00000 0.000000 FALSE none 0.0 FALSE TRUE conventional 1132.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070127 2006-11-24 2006-2007 TRUE FALSE rice grain 1611.8 urea;NPK 21.666 0.00000 0.000000 TRUE horse manure 3000.0 FALSE TRUE conventional 1171.3 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070562 2006-11-15 2006-2007 TRUE FALSE rice grain 1200.0 urea;NPK 30.682 0.00000 0.000000 TRUE horse manure 4000.0 FALSE TRUE conventional 985.7 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2008090873 2009-01-05 2008-2009 TRUE FALSE rice grain 3714.3 urea;NPK 0.000 0.00000 0.000000 FALSE none 0.0 FALSE TRUE reduced tillage 954.8 FALSE none lowland lowland
Madagascar Ambohimiarina 47.568 -21.3561 FALSE F2006070130 2006-11-29 2006-2007 TRUE FALSE rice grain 1946.7 urea;NPK 15.318 0.00000 0.000000 TRUE horse manure 4166.7 FALSE TRUE reduced tillage 1105.7 FALSE none lowland lowland


The observations are for 5 locations, for which we have 5 unique mapped locations.


The standardization script does not emit non-compliance warnings.

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

variable completeness (%)
N_fertilizer 100
P_fertilizer 100
K_fertilizer 100
irrigated 100
latitude 0
longitude 0
location 100


The data are further summarized in the table below.

Variable Stats / Values Freqs (% of Valid) Graph Missing
country [character] 1. Madagascar
3803(100.0%)
 0 (0.0%)
location [character]
1. Ambohimiarina
2. Ambohitsilaozana
3. Ambongabe
4. Ampitatsimo
5. Antsahamamy
1584(41.7%)
757(19.9%)
392(10.3%)
93(2.4%)
977(25.7%)
 0 (0.0%)
geo_from_source [logical] 1. FALSE
3803(100.0%)
 0 (0.0%)
trial_id [character]
1. F2006070001
2. F2006070002
3. F2006070003
4. F2006070004
5. F2006070005
6. F2006070006
7. F2006070007
8. F2006070008
9. F2006070009
10. F2006070010
[ 3793 others ]
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
1(0.0%)
3793(99.7%)
 0 (0.0%)
planting_date [character]
1. 2007-12-26
2. 2007-12-28
3. 2009-12-10
4. 2009-12-15
5. 2007-12-29
6. 2007-12-24
7. 2009-12-12
8. 2007-12-21
9. 2007-12-23
10. 2009-12-11
[ 268 others ]
78(2.1%)
60(1.6%)
57(1.5%)
57(1.5%)
55(1.4%)
52(1.4%)
51(1.3%)
46(1.2%)
46(1.2%)
45(1.2%)
3256(85.6%)
 0 (0.0%)
season [character]
1. 2006-2007
2. 2007-2008
3. 2008-2009
4. 2009-2010
716(18.8%)
978(25.7%)
958(25.2%)
1151(30.3%)
 0 (0.0%)
on_farm [logical] 1. TRUE
3803(100.0%)
 0 (0.0%)
is_survey [logical] 1. FALSE
3803(100.0%)
 0 (0.0%)
crop [character] 1. rice
3803(100.0%)
 0 (0.0%)
yield_part [character] 1. grain
3803(100.0%)
 0 (0.0%)
yield [numeric]
Mean (sd) : 2566.5 (908.3)
min ≤ med ≤ max:
318 ≤ 2546.7 ≤ 5350
IQR (CV) : 1227.3 (0.4)
 1757 distinct values 0 (0.0%)
fertilizer_type [character] 1. urea;NPK
3803(100.0%)
 0 (0.0%)
N_fertilizer [numeric]
Mean (sd) : 10.4 (17.3)
min ≤ med ≤ max:
0 ≤ 0 ≤ 91.5
IQR (CV) : 18.4 (1.7)
 819 distinct values 0 (0.0%)
P_fertilizer [numeric]
Mean (sd) : 2.1 (4.7)
min ≤ med ≤ max:
0 ≤ 0 ≤ 28.8
IQR (CV) : 0 (2.2)
 364 distinct values 0 (0.0%)
K_fertilizer [numeric]
Mean (sd) : 2.9 (6.4)
min ≤ med ≤ max:
0 ≤ 0 ≤ 39.8
IQR (CV) : 0 (2.2)
 364 distinct values 0 (0.0%)
OM_used [logical]
1. FALSE
2. TRUE
1983(52.1%)
1820(47.9%)
 0 (0.0%)
OM_type [character]
1. horse manure
2. none
1820(47.9%)
1983(52.1%)
 0 (0.0%)
OM_amount [numeric]
Mean (sd) : 1198.8 (1676.3)
min ≤ med ≤ max:
0 ≤ 0 ≤ 11976
IQR (CV) : 2500 (1.4)
 476 distinct values 0 (0.0%)
inoculated [logical] 1. FALSE
3803(100.0%)
 0 (0.0%)
irrigated [logical] 1. TRUE
3803(100.0%)
 0 (0.0%)
land_prep_method [character]
1. conventional
2. reduced tillage
1931(50.8%)
1872(49.2%)
 0 (0.0%)
rain [numeric]
Mean (sd) : 919.4 (160.3)
min ≤ med ≤ max:
443.4 ≤ 925.4 ≤ 1325.5
IQR (CV) : 178.5 (0.2)
 481 distinct values 0 (0.0%)
herbicide_used [logical]
1. FALSE
2. TRUE
3127(82.2%)
676(17.8%)
 0 (0.0%)
herbicide_product [character]
1. glyphosate
2. none
676(17.8%)
3127(82.2%)
 0 (0.0%)
soil_type [character]
1. hillside
2. lowland
857(22.5%)
2946(77.5%)
 0 (0.0%)
landscape_position [character]
1. hillside
2. lowland
857(22.5%)
2946(77.5%)
 0 (0.0%)