-
Home / Old / Workshop / Full Stack / Linear Regression / Index
VerticaPy
Linear Regression¶
Linear regression is one of the most popular regression algorithms and produces good predictions for well-prepared data. Its optimization function computes coefficients to express a response column as a linear relationship of its predictors.
You must verify the Gauss-Markov assumptions when using linear regression algorithms:
- Linearity : the parameters we are estimating using the OLS method must be linear.
- Non-Collinearity : the regressors being calculated aren’t perfectly correlated with each other.
- Exogeneity : the regressors aren’t correlated with the error term.
- Homoscedasticity : no matter what the values of our regressors might be, the error of the variance is constant.
To create a good linear regression model, it's important to:
- Impute missing values
- Encode categorical features (linear regression only accepts numerical variables)
- Compute the correlation matrix to retrieve highly-correlated predictors
- Decompose the data (optional)
- Normalize the data (optional, but recommended)
Example without decomposition¶
Let's use the 'africa_education' dataset to compute a linear regression model of students' performance in school.
import verticapy as vp
africa = vp.read_csv("data/africa_education.csv")
africa = africa.select(["(zralocp + zmalocp) / 2 AS student_score",
"(zraloct + zmaloct) / 2 AS teacher_score",
"XNUMYRS AS teacher_year_teaching",
"numstu AS number_students_school",
"PENGLISH AS english_at_home",
"PTRAVEL AS travel_distance",
"PTRAVEL2 AS means_of_travel",
"PMOTHER AS m_education",
"PFATHER AS f_education",
"PLIGHT AS source_of_lighting",
"PABSENT AS days_absent",
"PREPEAT AS repeated_grades",
"zpsit AS sitting_place",
"PAGE AS age",
"zpses AS socio_eco_statut",
"country_long AS country"])
display(africa)
123 student_scoreFloat | 123 teacher_scoreFloat | 123 teacher_year_teachingNumeric(7,3) | 123 number_students_schoolInteger | Abc english_at_homeVarchar(32) | Abc travel_distanceVarchar(22) | Abc means_of_travelVarchar(26) | Abc Varchar(68) | Abc Varchar(68) | Abc source_of_lightingVarchar(24) | 123 days_absentInteger | Abc repeated_gradesVarchar(20) | Abc sitting_placeVarchar(54) | 123 ageInteger | 123 socio_eco_statutNumeric(7,3) | Abc countryVarchar(24) | |
| 1 | 681.138508424325 | [null] | 26.0 | 24 | ALL THE TIME | >0.5-1KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 15.0 | South Africa | ||
| 2 | 425.993367323877 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >4.5-5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Namibia | ||
| 3 | 534.329515370892 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | ||
| 4 | 536.690743411639 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 5 | 569.392927563969 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | ||
| 6 | 542.037992351316 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | ||
| 7 | 573.771789981159 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | >1.5-2KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | ||
| 8 | 589.279157441376 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia | ||
| 9 | 496.740841813343 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >2.5-3KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 12.0 | Namibia | ||
| 10 | 535.805274812767 | 549.40293941491 | 1.0 | 22 | ALL THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Mozambique | ||
| 11 | 420.509155247374 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | ||
| 12 | 504.298378016207 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | ||
| 13 | 450.768711398358 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 4.0 | Zanzibar | ||
| 14 | 441.927245450751 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >1-1.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | ||
| 15 | 469.987298066451 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | ||
| 16 | 445.259642792635 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >4KM-4.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | ||
| 17 | 551.071920864503 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | ||
| 18 | 473.825234391116 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Zanzibar | ||
| 19 | 544.095820873929 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Zanzibar | ||
| 20 | 564.874824604798 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 8.0 | Zanzibar | ||
| 21 | 386.940445160128 | 569.993686161283 | 11.0 | 23 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 3.0 | Mozambique | ||
| 22 | 458.501728934408 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >2-2.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Mozambique | ||
| 23 | 460.360232184133 | 569.993686161283 | 11.0 | 23 | ALL THE TIME | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 15 | 7.0 | Mozambique | ||
| 24 | 457.035551231015 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Mozambique | ||
| 25 | 504.282977573042 | 593.122754483926 | 3.0 | 23 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Mozambique | ||
| 26 | 475.872247772718 | 569.993686161283 | 11.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 16 | 10.0 | Mozambique | ||
| 27 | 503.899980617811 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 2.0 | Mozambique | ||
| 28 | 480.484906064866 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 3.0 | Mozambique | ||
| 29 | 516.744491629541 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 30 | 394.65259093503 | 641.876995222798 | 20.0 | 25 | NEVER | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 31 | 506.128325450387 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | ||
| 32 | 440.401203829463 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 33 | 453.010211603314 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | ||
| 34 | 498.219068060275 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 11.0 | Namibia | ||
| 35 | 359.385615553614 | 610.956816556605 | 30.0 | 16 | ALL THE TIME | UP TO 0.5KM | WALK | GAS | 0 | NEVER | I have my own sitting place | 14 | [null] | Mozambique | ||
| 36 | 525.275821925396 | 610.956816556605 | 30.0 | 16 | ALL THE TIME | UP TO 0.5KM | WALK | GAS | 0 | NEVER | I have my own sitting place | 17 | [null] | Mozambique | ||
| 37 | 457.035551231015 | 610.956816556605 | 30.0 | 16 | ALL THE TIME | UP TO 0.5KM | WALK | GAS | 0 | NEVER | I have my own sitting place | 12 | [null] | Mozambique | ||
| 38 | 509.337990443557 | 610.956816556605 | 30.0 | 16 | ALL THE TIME | UP TO 0.5KM | WALK | GAS | 0 | NEVER | I have my own sitting place | 12 | [null] | Mozambique | ||
| 39 | 434.970625831997 | 610.956816556605 | 30.0 | 16 | SOMETIMES | UP TO 0.5KM | WALK | GAS | 0 | NEVER | I have my own sitting place | 17 | [null] | Mozambique | ||
| 40 | [null] | 641.477648982361 | 2.0 | 16 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 17 | 4.0 | Mozambique | ||
| 41 | 428.988211440412 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 2.0 | Namibia | ||
| 42 | 532.255684949772 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 2.0 | Namibia | ||
| 43 | 392.664714363554 | 676.11173539576 | 8.0 | 20 | ALL THE TIME | >3-3.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 4.0 | Zambia | ||
| 44 | 415.95588691273 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 4.0 | Namibia | ||
| 45 | 479.525184773189 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 46 | 410.328608434232 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 47 | 425.993367323877 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >3-3.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 48 | 409.430742983857 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 5.0 | Namibia | ||
| 49 | 460.605886281468 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 50 | 560.188989035577 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 51 | 378.486087509513 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 6.0 | Namibia | ||
| 52 | 516.831361986859 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | ||
| 53 | 557.155342162198 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 54 | 631.282997954796 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 55 | 501.677328837489 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 18 | 6.0 | Namibia | ||
| 56 | 466.248533790025 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 57 | 594.667991916549 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 58 | 619.020904331767 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 59 | 422.517903579997 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 60 | 514.338009258817 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | ||
| 61 | 512.766872215611 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 62 | 456.266205420931 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Zambia | ||
| 63 | 380.388263378723 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | CAR | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 8.0 | Namibia | ||
| 64 | 421.344721387902 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 11 | 8.0 | Zambia | ||
| 65 | 486.501284763764 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | ||
| 66 | 453.357504553945 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Namibia | ||
| 67 | 498.219068060275 | 638.008383664231 | 6.0 | 24 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 9.0 | Namibia | ||
| 68 | 514.807687171462 | 638.008383664231 | 6.0 | 24 | NEVER | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 69 | 565.065579807459 | 683.217366694882 | 12.0 | 21 | MOST OF THE TIME | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 13.0 | South Africa | ||
| 70 | 626.714865963592 | 638.008383664231 | 8.0 | 21 | ALL THE TIME | UP TO 0.5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 14.0 | South Africa | ||
| 71 | 457.134154158281 | 683.217366694882 | 12.0 | 21 | SOMETIMES | >5KM | BUS/TRUCK/VAN | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 14.0 | South Africa | ||
| 72 | 510.499756960558 | 634.222848016075 | 9.0 | 20 | MOST OF THE TIME | >1-1.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 16 | 2.0 | Uganda | ||
| 73 | 494.235377715545 | 634.222848016075 | 9.0 | 20 | SOMETIMES | >1.5-2KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 17 | 2.0 | Uganda | ||
| 74 | 365.266644239282 | 617.7225229859 | 1.0 | 13 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 2.0 | Zambia | ||
| 75 | 541.173490674172 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 3.0 | Namibia | ||
| 76 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | SOMETIMES | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 15 | 3.0 | Malawi | ||
| 77 | 422.517903579997 | 645.715848976398 | 8.0 | 20 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 12 | 5.0 | Malawi | ||
| 78 | 398.31103066659 | 651.629260258888 | 1.0 | 21 | MOST OF THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Malawi | ||
| 79 | 395.120560563494 | 639.897815295239 | 1.0 | 22 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 80 | 503.716941803917 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 81 | 427.462485792718 | 623.159046261738 | 8.0 | 18 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 6.0 | Zambia | ||
| 82 | 600.91272658553 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2-2.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 83 | 565.065579807459 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 84 | 540.204883338675 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | ||
| 85 | 558.474690429794 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 86 | 575.637662232951 | 645.715848976398 | 6.0 | 49 | NEVER | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | ||
| 87 | 439.680053114802 | 645.715848976398 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Malawi | ||
| 88 | 353.773643278958 | 617.7225229859 | 1.0 | 13 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Zambia | ||
| 89 | 488.376137298698 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | ||
| 90 | 480.908033418792 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 91 | 535.286927844308 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 92 | 408.529715955022 | 651.629260258888 | 1.0 | 21 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 15 | 9.0 | Malawi | ||
| 93 | 385.53865385057 | 623.159046261738 | 8.0 | 18 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Zambia | ||
| 94 | 528.310827853733 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 95 | 548.67653911654 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 96 | 588.423257247566 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | ||
| 97 | 583.034422772394 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | ||
| 98 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | NEVER | >3.5-4KM | WALK | ELECTRIC | 0 | NEVER | No place/share | 14 | 10.0 | Malawi | ||
| 99 | 459.986311593889 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 11.0 | Namibia | ||
| 100 | 594.667991916549 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia |
First, let's look for missing values.
africa.count_percent()
| count | percent | |
| "number_students_school" | 60890.0 | 100.0 |
| "english_at_home" | 60890.0 | 100.0 |
| "travel_distance" | 60890.0 | 100.0 |
| "means_of_travel" | 60890.0 | 100.0 |
| "m_education" | 60890.0 | 100.0 |
| "source_of_lighting" | 60890.0 | 100.0 |
| "days_absent" | 60890.0 | 100.0 |
| "repeated_grades" | 60890.0 | 100.0 |
| "sitting_place" | 60890.0 | 100.0 |
| "age" | 60890.0 | 100.0 |
| "country" | 60890.0 | 100.0 |
| "socio_eco_statut" | 60832.0 | 99.905 |
| "student_score" | 60809.0 | 99.867 |
| "teacher_year_teaching" | 60708.0 | 99.701 |
| "f_education" | 60599.0 | 99.522 |
| "teacher_score" | 52122.0 | 85.6 |
We'll simply drop the missing values to avoid adding bias to the data.
africa.dropna()
8988 elements were filtered.
123 student_scoreFloat | 123 teacher_scoreFloat | 123 teacher_year_teachingNumeric(7,3) | 123 number_students_schoolInteger | Abc english_at_homeVarchar(32) | Abc travel_distanceVarchar(22) | Abc means_of_travelVarchar(26) | Abc Varchar(68) | Abc Varchar(68) | Abc source_of_lightingVarchar(24) | 123 days_absentInteger | Abc repeated_gradesVarchar(20) | Abc sitting_placeVarchar(54) | 123 ageInteger | 123 socio_eco_statutNumeric(7,3) | Abc countryVarchar(24) | |
| 1 | 425.993367323877 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >4.5-5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Namibia | ||
| 2 | 534.329515370892 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | ||
| 3 | 536.690743411639 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 4 | 569.392927563969 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | ||
| 5 | 542.037992351316 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | ||
| 6 | 573.771789981159 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | >1.5-2KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | ||
| 7 | 589.279157441376 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia | ||
| 8 | 496.740841813343 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >2.5-3KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 12.0 | Namibia | ||
| 9 | 535.805274812767 | 549.40293941491 | 1.0 | 22 | ALL THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Mozambique | ||
| 10 | 420.509155247374 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | ||
| 11 | 504.298378016207 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | ||
| 12 | 450.768711398358 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 4.0 | Zanzibar | ||
| 13 | 441.927245450751 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >1-1.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | ||
| 14 | 469.987298066451 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | ||
| 15 | 445.259642792635 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >4KM-4.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | ||
| 16 | 551.071920864503 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | ||
| 17 | 473.825234391116 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Zanzibar | ||
| 18 | 544.095820873929 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Zanzibar | ||
| 19 | 564.874824604798 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 8.0 | Zanzibar | ||
| 20 | 386.940445160128 | 569.993686161283 | 11.0 | 23 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 3.0 | Mozambique | ||
| 21 | 458.501728934408 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >2-2.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Mozambique | ||
| 22 | 460.360232184133 | 569.993686161283 | 11.0 | 23 | ALL THE TIME | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 15 | 7.0 | Mozambique | ||
| 23 | 457.035551231015 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Mozambique | ||
| 24 | 504.282977573042 | 593.122754483926 | 3.0 | 23 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Mozambique | ||
| 25 | 475.872247772718 | 569.993686161283 | 11.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 16 | 10.0 | Mozambique | ||
| 26 | 503.899980617811 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 2.0 | Mozambique | ||
| 27 | 480.484906064866 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 3.0 | Mozambique | ||
| 28 | 516.744491629541 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 29 | 394.65259093503 | 641.876995222798 | 20.0 | 25 | NEVER | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 30 | 506.128325450387 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | ||
| 31 | 440.401203829463 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 32 | 453.010211603314 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | ||
| 33 | 498.219068060275 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 11.0 | Namibia | ||
| 34 | 428.988211440412 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 2.0 | Namibia | ||
| 35 | 532.255684949772 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 2.0 | Namibia | ||
| 36 | 392.664714363554 | 676.11173539576 | 8.0 | 20 | ALL THE TIME | >3-3.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 4.0 | Zambia | ||
| 37 | 415.95588691273 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 4.0 | Namibia | ||
| 38 | 479.525184773189 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 39 | 410.328608434232 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 40 | 425.993367323877 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >3-3.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | ||
| 41 | 409.430742983857 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 5.0 | Namibia | ||
| 42 | 460.605886281468 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 43 | 560.188989035577 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 44 | 378.486087509513 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 6.0 | Namibia | ||
| 45 | 516.831361986859 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | ||
| 46 | 557.155342162198 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 47 | 631.282997954796 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 48 | 501.677328837489 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 18 | 6.0 | Namibia | ||
| 49 | 466.248533790025 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 50 | 594.667991916549 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 51 | 619.020904331767 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 52 | 422.517903579997 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 53 | 514.338009258817 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | ||
| 54 | 512.766872215611 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 55 | 456.266205420931 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Zambia | ||
| 56 | 380.388263378723 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | CAR | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 8.0 | Namibia | ||
| 57 | 421.344721387902 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 11 | 8.0 | Zambia | ||
| 58 | 486.501284763764 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | ||
| 59 | 453.357504553945 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Namibia | ||
| 60 | 498.219068060275 | 638.008383664231 | 6.0 | 24 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 9.0 | Namibia | ||
| 61 | 514.807687171462 | 638.008383664231 | 6.0 | 24 | NEVER | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 62 | 565.065579807459 | 683.217366694882 | 12.0 | 21 | MOST OF THE TIME | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 13.0 | South Africa | ||
| 63 | 626.714865963592 | 638.008383664231 | 8.0 | 21 | ALL THE TIME | UP TO 0.5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 14.0 | South Africa | ||
| 64 | 457.134154158281 | 683.217366694882 | 12.0 | 21 | SOMETIMES | >5KM | BUS/TRUCK/VAN | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 14.0 | South Africa | ||
| 65 | 510.499756960558 | 634.222848016075 | 9.0 | 20 | MOST OF THE TIME | >1-1.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 16 | 2.0 | Uganda | ||
| 66 | 494.235377715545 | 634.222848016075 | 9.0 | 20 | SOMETIMES | >1.5-2KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 17 | 2.0 | Uganda | ||
| 67 | 365.266644239282 | 617.7225229859 | 1.0 | 13 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 2.0 | Zambia | ||
| 68 | 541.173490674172 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 3.0 | Namibia | ||
| 69 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | SOMETIMES | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 15 | 3.0 | Malawi | ||
| 70 | 422.517903579997 | 645.715848976398 | 8.0 | 20 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 12 | 5.0 | Malawi | ||
| 71 | 398.31103066659 | 651.629260258888 | 1.0 | 21 | MOST OF THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Malawi | ||
| 72 | 395.120560563494 | 639.897815295239 | 1.0 | 22 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 73 | 503.716941803917 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | ||
| 74 | 427.462485792718 | 623.159046261738 | 8.0 | 18 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 6.0 | Zambia | ||
| 75 | 600.91272658553 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2-2.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 76 | 565.065579807459 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 77 | 540.204883338675 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | ||
| 78 | 558.474690429794 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | ||
| 79 | 575.637662232951 | 645.715848976398 | 6.0 | 49 | NEVER | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | ||
| 80 | 439.680053114802 | 645.715848976398 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Malawi | ||
| 81 | 353.773643278958 | 617.7225229859 | 1.0 | 13 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Zambia | ||
| 82 | 488.376137298698 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | ||
| 83 | 480.908033418792 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 84 | 535.286927844308 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | ||
| 85 | 408.529715955022 | 651.629260258888 | 1.0 | 21 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 15 | 9.0 | Malawi | ||
| 86 | 385.53865385057 | 623.159046261738 | 8.0 | 18 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Zambia | ||
| 87 | 528.310827853733 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 88 | 548.67653911654 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | ||
| 89 | 588.423257247566 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | ||
| 90 | 583.034422772394 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | ||
| 91 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | NEVER | >3.5-4KM | WALK | ELECTRIC | 0 | NEVER | No place/share | 14 | 10.0 | Malawi | ||
| 92 | 459.986311593889 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 11.0 | Namibia | ||
| 93 | 594.667991916549 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia | ||
| 94 | 473.481862461084 | 645.715848976398 | 6.0 | 49 | NEVER | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 12.0 | Namibia | ||
| 95 | 584.081078168864 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 13.0 | Namibia | ||
| 96 | 504.241138890166 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 13.0 | Namibia | ||
| 97 | 451.694405556509 | 627.046853631639 | 7.0 | 15 | SOMETIMES | UP TO 0.5KM | WALK | FIRE | 0 | NEVER | No place/share | 17 | 1.0 | Mozambique | ||
| 98 | 522.558825103114 | 627.046853631639 | 7.0 | 15 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 12 | 1.0 | Mozambique | ||
| 99 | 422.842681154036 | 627.046853631639 | 7.0 | 15 | NEVER | >0.5-1KM | WALK | NO LIGHTING | 0 | NEVER | No place/share | 14 | 1.0 | Mozambique | ||
| 100 | 515.308862586361 | 657.567686057395 | 5.0 | 20 | SOMETIMES | >1-1.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 18 | 2.0 | Mozambique |
We need to encode the categorical columns to dummies to retain linearity.
africa.one_hot_encode(max_cardinality = 20)
123 student_scoreFloat | 123 teacher_scoreFloat | 123 teacher_year_teachingNumeric(7,3) | 123 number_students_schoolInteger | Abc english_at_homeVarchar(32) | Abc travel_distanceVarchar(22) | Abc means_of_travelVarchar(26) | Abc Varchar(68) | Abc Varchar(68) | Abc source_of_lightingVarchar(24) | 123 days_absentInteger | Abc repeated_gradesVarchar(20) | Abc sitting_placeVarchar(54) | 123 ageInteger | 123 socio_eco_statutNumeric(7,3) | Abc countryVarchar(24) | 123 english_at_home_ALL_THE_TIMEBool | 123 english_at_home_MOST_OF_THE_TIMEBool | 123 english_at_home_NEVERBool | 123 travel_distance_>0.5-1KMBool | 123 travel_distance_>1-1.5KMBool | 123 travel_distance_>1.5-2KMBool | 123 travel_distance_>2-2.5KMBool | 123 travel_distance_>2.5-3KMBool | 123 travel_distance_>3-3.5KMBool | ... | 123 socio_eco_statut_3.000Bool | 123 socio_eco_statut_4.000Bool | 123 socio_eco_statut_5.000Bool | 123 socio_eco_statut_6.000Bool | 123 socio_eco_statut_7.000Bool | 123 socio_eco_statut_8.000Bool | 123 socio_eco_statut_9.000Bool | 123 socio_eco_statut_10.000Bool | 123 socio_eco_statut_11.000Bool | 123 socio_eco_statut_12.000Bool | 123 socio_eco_statut_13.000Bool | 123 socio_eco_statut_14.000Bool | 123 country_BotswanaBool | 123 country_KenyaBool | 123 country_LesothoBool | 123 country_MalawiBool | 123 country_MozambiqueBool | 123 country_NamibiaBool | 123 country_SeychellesBool | 123 country_South_AfricaBool | 123 country_SwazilandBool | 123 country_TanzaniaBool | 123 country_UgandaBool | 123 country_ZambiaBool | 123 country_ZanzibarBool | |
| 1 | 425.993367323877 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >4.5-5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 2 | 534.329515370892 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 3 | 536.690743411639 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 4 | 569.392927563969 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 5 | 542.037992351316 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 6 | 573.771789981159 | 537.289572911762 | 10.0 | 23 | MOST OF THE TIME | >1.5-2KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 11.0 | Namibia | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 7 | 589.279157441376 | 537.289572911762 | 10.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 8 | 496.740841813343 | 537.289572911762 | 10.0 | 23 | SOMETIMES | >2.5-3KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 12.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 9 | 535.805274812767 | 549.40293941491 | 1.0 | 22 | ALL THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Mozambique | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 10 | 420.509155247374 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 11 | 504.298378016207 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 3.0 | Zanzibar | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 12 | 450.768711398358 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 4.0 | Zanzibar | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 13 | 441.927245450751 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >1-1.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 14 | 469.987298066451 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Zanzibar | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 15 | 445.259642792635 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | >4KM-4.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 16 | 551.071920864503 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 6.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 17 | 473.825234391116 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 18 | 544.095820873929 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 19 | 564.874824604798 | 624.124902231691 | 1.0 | 25 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 8.0 | Zanzibar | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ||
| 20 | 386.940445160128 | 569.993686161283 | 11.0 | 23 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 3.0 | Mozambique | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 21 | 458.501728934408 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >2-2.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Mozambique | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 22 | 460.360232184133 | 569.993686161283 | 11.0 | 23 | ALL THE TIME | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 15 | 7.0 | Mozambique | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 23 | 457.035551231015 | 593.122754483926 | 3.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Mozambique | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 24 | 504.282977573042 | 593.122754483926 | 3.0 | 23 | ALL THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Mozambique | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 25 | 475.872247772718 | 569.993686161283 | 11.0 | 23 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 16 | 10.0 | Mozambique | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 26 | 503.899980617811 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 2.0 | Mozambique | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 27 | 480.484906064866 | 584.886538196464 | 3.0 | 7 | ALL THE TIME | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 15 | 3.0 | Mozambique | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 28 | 516.744491629541 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 29 | 394.65259093503 | 641.876995222798 | 20.0 | 25 | NEVER | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 30 | 506.128325450387 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 31 | 440.401203829463 | 641.876995222798 | 20.0 | 25 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 32 | 453.010211603314 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 33 | 498.219068060275 | 641.876995222798 | 20.0 | 25 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 11 | 11.0 | Namibia | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 34 | 428.988211440412 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 2.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 35 | 532.255684949772 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 14 | 2.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 36 | 392.664714363554 | 676.11173539576 | 8.0 | 20 | ALL THE TIME | >3-3.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 4.0 | Zambia | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 37 | 415.95588691273 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 4.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 38 | 479.525184773189 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 39 | 410.328608434232 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1-1.5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 40 | 425.993367323877 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >3-3.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 12 | 4.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 41 | 409.430742983857 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >1.5-2KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 5.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 42 | 460.605886281468 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 43 | 560.188989035577 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 44 | 378.486087509513 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 14 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 45 | 516.831361986859 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 46 | 557.155342162198 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 47 | 631.282997954796 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 48 | 501.677328837489 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >2.5-3KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 18 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 49 | 466.248533790025 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 50 | 594.667991916549 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 51 | 619.020904331767 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 52 | 422.517903579997 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 53 | 514.338009258817 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 54 | 512.766872215611 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 55 | 456.266205420931 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Zambia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 56 | 380.388263378723 | 656.225505518354 | 8.0 | 23 | SOMETIMES | >5KM | CAR | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 8.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 57 | 421.344721387902 | 676.11173539576 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 11 | 8.0 | Zambia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 58 | 486.501284763764 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 9.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 59 | 453.357504553945 | 638.008383664231 | 6.0 | 24 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 60 | 498.219068060275 | 638.008383664231 | 6.0 | 24 | SOMETIMES | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 9.0 | Namibia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 61 | 514.807687171462 | 638.008383664231 | 6.0 | 24 | NEVER | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 62 | 565.065579807459 | 683.217366694882 | 12.0 | 21 | MOST OF THE TIME | >0.5-1KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 13.0 | South Africa | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ||
| 63 | 626.714865963592 | 638.008383664231 | 8.0 | 21 | ALL THE TIME | UP TO 0.5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 14.0 | South Africa | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ||
| 64 | 457.134154158281 | 683.217366694882 | 12.0 | 21 | SOMETIMES | >5KM | BUS/TRUCK/VAN | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 14.0 | South Africa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ||
| 65 | 510.499756960558 | 634.222848016075 | 9.0 | 20 | MOST OF THE TIME | >1-1.5KM | WALK | FIRE | 0 | NEVER | I have my own sitting place | 16 | 2.0 | Uganda | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||
| 66 | 494.235377715545 | 634.222848016075 | 9.0 | 20 | SOMETIMES | >1.5-2KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 17 | 2.0 | Uganda | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ||
| 67 | 365.266644239282 | 617.7225229859 | 1.0 | 13 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 13 | 2.0 | Zambia | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 68 | 541.173490674172 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 3.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 69 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | SOMETIMES | >5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 15 | 3.0 | Malawi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 70 | 422.517903579997 | 645.715848976398 | 8.0 | 20 | NEVER | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 12 | 5.0 | Malawi | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 71 | 398.31103066659 | 651.629260258888 | 1.0 | 21 | MOST OF THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 14 | 5.0 | Malawi | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 72 | 395.120560563494 | 639.897815295239 | 1.0 | 22 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 73 | 503.716941803917 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 12 | 6.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 74 | 427.462485792718 | 623.159046261738 | 8.0 | 18 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 13 | 6.0 | Zambia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 75 | 600.91272658553 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2-2.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 76 | 565.065579807459 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >5KM | CAR | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 77 | 540.204883338675 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 7.0 | Namibia | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 78 | 558.474690429794 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 7.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 79 | 575.637662232951 | 645.715848976398 | 6.0 | 49 | NEVER | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Namibia | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 80 | 439.680053114802 | 645.715848976398 | 8.0 | 20 | SOMETIMES | UP TO 0.5KM | WALK | CANDLE | 0 | NEVER | No place/share | 11 | 7.0 | Malawi | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 81 | 353.773643278958 | 617.7225229859 | 1.0 | 13 | SOMETIMES | >0.5-1KM | WALK | CANDLE | 0 | NEVER | I have my own sitting place | 13 | 7.0 | Zambia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 82 | 488.376137298698 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 8.0 | Namibia | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 83 | 480.908033418792 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | >1-1.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 84 | 535.286927844308 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 8.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 85 | 408.529715955022 | 651.629260258888 | 1.0 | 21 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 15 | 9.0 | Malawi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 86 | 385.53865385057 | 623.159046261738 | 8.0 | 18 | SOMETIMES | >0.5-1KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 9.0 | Zambia | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ||
| 87 | 528.310827853733 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 88 | 548.67653911654 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 10.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 89 | 588.423257247566 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 90 | 583.034422772394 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 10.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 91 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | NEVER | >3.5-4KM | WALK | ELECTRIC | 0 | NEVER | No place/share | 14 | 10.0 | Malawi | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 92 | 459.986311593889 | 645.715848976398 | 6.0 | 49 | SOMETIMES | >2.5-3KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 13 | 11.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 93 | 594.667991916549 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 12.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 94 | 473.481862461084 | 645.715848976398 | 6.0 | 49 | NEVER | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 12.0 | Namibia | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 95 | 584.081078168864 | 645.715848976398 | 6.0 | 49 | MOST OF THE TIME | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 12 | 13.0 | Namibia | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 96 | 504.241138890166 | 645.715848976398 | 6.0 | 49 | SOMETIMES | UP TO 0.5KM | WALK | ELECTRIC | 0 | NEVER | I have my own sitting place | 11 | 13.0 | Namibia | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 97 | 451.694405556509 | 627.046853631639 | 7.0 | 15 | SOMETIMES | UP TO 0.5KM | WALK | FIRE | 0 | NEVER | No place/share | 17 | 1.0 | Mozambique | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 98 | 522.558825103114 | 627.046853631639 | 7.0 | 15 | ALL THE TIME | UP TO 0.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 12 | 1.0 | Mozambique | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 99 | 422.842681154036 | 627.046853631639 | 7.0 | 15 | NEVER | >0.5-1KM | WALK | NO LIGHTING | 0 | NEVER | No place/share | 14 | 1.0 | Mozambique | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||
| 100 | 515.308862586361 | 657.567686057395 | 5.0 | 20 | SOMETIMES | >1-1.5KM | WALK | PARAFFIN/OIL | 0 | NEVER | No place/share | 18 | 2.0 | Mozambique | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Linear regression can only handle numerical columns, so we'll drop the categorical columns.
africa.drop(columns = ["english_at_home",
"travel_distance",
"means_of_travel",
"m_education",
"f_education",
"source_of_lighting",
"repeated_grades",
"sitting_place",
"country"])
123 student_scoreFloat | 123 teacher_scoreFloat | 123 teacher_year_teachingNumeric(7,3) | 123 number_students_schoolInteger | 123 days_absentInteger | 123 ageInteger | 123 socio_eco_statutNumeric(7,3) | 123 english_at_home_ALL_THE_TIMEBool | 123 english_at_home_MOST_OF_THE_TIMEBool | 123 english_at_home_NEVERBool | 123 travel_distance_>0.5-1KMBool | 123 travel_distance_>1-1.5KMBool | 123 travel_distance_>1.5-2KMBool | 123 travel_distance_>2-2.5KMBool | 123 travel_distance_>2.5-3KMBool | 123 travel_distance_>3-3.5KMBool | 123 travel_distance_>3.5-4KMBool | 123 travel_distance_>4.5-5KMBool | 123 travel_distance_>4KM-4.5KMBool | 123 travel_distance_>5KMBool | 123 means_of_travel_BICYCLEBool | 123 means_of_travel_BUS_TRUCK_VANBool | 123 means_of_travel_CARBool | 123 means_of_travel_OTHERBool | 123 means_of_travel_TRAINBool | ... | 123 socio_eco_statut_3.000Bool | 123 socio_eco_statut_4.000Bool | 123 socio_eco_statut_5.000Bool | 123 socio_eco_statut_6.000Bool | 123 socio_eco_statut_7.000Bool | 123 socio_eco_statut_8.000Bool | 123 socio_eco_statut_9.000Bool | 123 socio_eco_statut_10.000Bool | 123 socio_eco_statut_11.000Bool | 123 socio_eco_statut_12.000Bool | 123 socio_eco_statut_13.000Bool | 123 socio_eco_statut_14.000Bool | 123 country_BotswanaBool | 123 country_KenyaBool | 123 country_LesothoBool | 123 country_MalawiBool | 123 country_MozambiqueBool | 123 country_NamibiaBool | 123 country_SeychellesBool | 123 country_South_AfricaBool | 123 country_SwazilandBool | 123 country_TanzaniaBool | 123 country_UgandaBool | 123 country_ZambiaBool | 123 country_ZanzibarBool | |
| 1 | 425.993367323877 | 537.289572911762 | 10.0 | 23 | 0 | 14 | 5.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 534.329515370892 | 537.289572911762 | 10.0 | 23 | 0 | 13 | 7.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 536.690743411639 | 537.289572911762 | 10.0 | 23 | 0 | 12 | 8.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | 569.392927563969 | 537.289572911762 | 10.0 | 23 | 0 | 13 | 9.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5 | 542.037992351316 | 537.289572911762 | 10.0 | 23 | 0 | 12 | 11.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6 | 573.771789981159 | 537.289572911762 | 10.0 | 23 | 0 | 12 | 11.0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 | 589.279157441376 | 537.289572911762 | 10.0 | 23 | 0 | 12 | 12.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8 | 496.740841813343 | 537.289572911762 | 10.0 | 23 | 0 | 14 | 12.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 9 | 535.805274812767 | 549.40293941491 | 1.0 | 22 | 0 | 13 | 10.0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 10 | 420.509155247374 | 624.124902231691 | 1.0 | 25 | 0 | 13 | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 11 | 504.298378016207 | 624.124902231691 | 1.0 | 25 | 0 | 13 | 3.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 12 | 450.768711398358 | 624.124902231691 | 1.0 | 25 | 0 | 14 | 4.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 13 | 441.927245450751 | 624.124902231691 | 1.0 | 25 | 0 | 14 | 5.0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 14 | 469.987298066451 | 624.124902231691 | 1.0 | 25 | 0 | 14 | 5.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 15 | 445.259642792635 | 624.124902231691 | 1.0 | 25 | 0 | 13 | 6.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 16 | 551.071920864503 | 624.124902231691 | 1.0 | 25 | 0 | 13 | 6.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 17 | 473.825234391116 | 624.124902231691 | 1.0 | 25 | 0 | 12 | 7.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 18 | 544.095820873929 | 624.124902231691 | 1.0 | 25 | 0 | 12 | 8.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 19 | 564.874824604798 | 624.124902231691 | 1.0 | 25 | 0 | 14 | 8.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| 20 | 386.940445160128 | 569.993686161283 | 11.0 | 23 | 0 | 14 | 3.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 21 | 458.501728934408 | 593.122754483926 | 3.0 | 23 | 0 | 14 | 5.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 22 | 460.360232184133 | 569.993686161283 | 11.0 | 23 | 0 | 15 | 7.0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 23 | 457.035551231015 | 593.122754483926 | 3.0 | 23 | 0 | 11 | 7.0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 24 | 504.282977573042 | 593.122754483926 | 3.0 | 23 | 0 | 11 | 8.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 25 | 475.872247772718 | 569.993686161283 | 11.0 | 23 | 0 | 16 | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26 | 503.899980617811 | 584.886538196464 | 3.0 | 7 | 0 | 15 | 2.0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 27 | 480.484906064866 | 584.886538196464 | 3.0 | 7 | 0 | 15 | 3.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 28 | 516.744491629541 | 641.876995222798 | 20.0 | 25 | 0 | 12 | 6.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 29 | 394.65259093503 | 641.876995222798 | 20.0 | 25 | 0 | 12 | 6.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 30 | 506.128325450387 | 641.876995222798 | 20.0 | 25 | 0 | 11 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 31 | 440.401203829463 | 641.876995222798 | 20.0 | 25 | 0 | 12 | 8.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 32 | 453.010211603314 | 641.876995222798 | 20.0 | 25 | 0 | 11 | 8.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 33 | 498.219068060275 | 641.876995222798 | 20.0 | 25 | 0 | 11 | 11.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 34 | 428.988211440412 | 656.225505518354 | 8.0 | 23 | 0 | 12 | 2.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 35 | 532.255684949772 | 656.225505518354 | 8.0 | 23 | 0 | 14 | 2.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 36 | 392.664714363554 | 676.11173539576 | 8.0 | 20 | 0 | 13 | 4.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 37 | 415.95588691273 | 656.225505518354 | 8.0 | 23 | 0 | 13 | 4.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 38 | 479.525184773189 | 656.225505518354 | 8.0 | 23 | 0 | 12 | 4.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 39 | 410.328608434232 | 656.225505518354 | 8.0 | 23 | 0 | 12 | 4.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 40 | 425.993367323877 | 656.225505518354 | 8.0 | 23 | 0 | 12 | 4.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 41 | 409.430742983857 | 656.225505518354 | 8.0 | 23 | 0 | 12 | 5.0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 42 | 460.605886281468 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 43 | 560.188989035577 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 44 | 378.486087509513 | 638.008383664231 | 6.0 | 24 | 0 | 14 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 45 | 516.831361986859 | 638.008383664231 | 6.0 | 24 | 0 | 11 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 46 | 557.155342162198 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 47 | 631.282997954796 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 48 | 501.677328837489 | 656.225505518354 | 8.0 | 23 | 0 | 18 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 49 | 466.248533790025 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 50 | 594.667991916549 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51 | 619.020904331767 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 52 | 422.517903579997 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 53 | 514.338009258817 | 638.008383664231 | 6.0 | 24 | 0 | 11 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 54 | 512.766872215611 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 55 | 456.266205420931 | 676.11173539576 | 8.0 | 20 | 0 | 11 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 56 | 380.388263378723 | 656.225505518354 | 8.0 | 23 | 0 | 13 | 8.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 57 | 421.344721387902 | 676.11173539576 | 8.0 | 20 | 0 | 11 | 8.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 58 | 486.501284763764 | 638.008383664231 | 6.0 | 24 | 0 | 13 | 9.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 59 | 453.357504553945 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 9.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 60 | 498.219068060275 | 638.008383664231 | 6.0 | 24 | 0 | 11 | 9.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 61 | 514.807687171462 | 638.008383664231 | 6.0 | 24 | 0 | 12 | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 62 | 565.065579807459 | 683.217366694882 | 12.0 | 21 | 0 | 12 | 13.0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 63 | 626.714865963592 | 638.008383664231 | 8.0 | 21 | 0 | 11 | 14.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 64 | 457.134154158281 | 683.217366694882 | 12.0 | 21 | 0 | 13 | 14.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| 65 | 510.499756960558 | 634.222848016075 | 9.0 | 20 | 0 | 16 | 2.0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 66 | 494.235377715545 | 634.222848016075 | 9.0 | 20 | 0 | 17 | 2.0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 67 | 365.266644239282 | 617.7225229859 | 1.0 | 13 | 0 | 13 | 2.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 68 | 541.173490674172 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 3.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 69 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | 0 | 15 | 3.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 70 | 422.517903579997 | 645.715848976398 | 8.0 | 20 | 0 | 12 | 5.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 71 | 398.31103066659 | 651.629260258888 | 1.0 | 21 | 0 | 14 | 5.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 72 | 395.120560563494 | 639.897815295239 | 1.0 | 22 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 73 | 503.716941803917 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 74 | 427.462485792718 | 623.159046261738 | 8.0 | 18 | 0 | 13 | 6.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 75 | 600.91272658553 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 76 | 565.065579807459 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 77 | 540.204883338675 | 645.715848976398 | 6.0 | 49 | 0 | 11 | 7.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 78 | 558.474690429794 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 79 | 575.637662232951 | 645.715848976398 | 6.0 | 49 | 0 | 13 | 7.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 80 | 439.680053114802 | 645.715848976398 | 8.0 | 20 | 0 | 11 | 7.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 81 | 353.773643278958 | 617.7225229859 | 1.0 | 13 | 0 | 13 | 7.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 82 | 488.376137298698 | 645.715848976398 | 6.0 | 49 | 0 | 11 | 8.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 83 | 480.908033418792 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 8.0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 84 | 535.286927844308 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 8.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 85 | 408.529715955022 | 651.629260258888 | 1.0 | 21 | 0 | 15 | 9.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 86 | 385.53865385057 | 623.159046261738 | 8.0 | 18 | 0 | 12 | 9.0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| 87 | 528.310827853733 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 88 | 548.67653911654 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 89 | 588.423257247566 | 645.715848976398 | 6.0 | 49 | 0 | 13 | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 90 | 583.034422772394 | 645.715848976398 | 6.0 | 49 | 0 | 13 | 10.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 91 | 455.36049792936 | 645.715848976398 | 8.0 | 20 | 0 | 14 | 10.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 92 | 459.986311593889 | 645.715848976398 | 6.0 | 49 | 0 | 13 | 11.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 93 | 594.667991916549 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 12.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 94 | 473.481862461084 | 645.715848976398 | 6.0 | 49 | 0 | 11 | 12.0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 95 | 584.081078168864 | 645.715848976398 | 6.0 | 49 | 0 | 12 | 13.0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 96 | 504.241138890166 | 645.715848976398 | 6.0 | 49 | 0 | 11 | 13.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 97 | 451.694405556509 | 627.046853631639 | 7.0 | 15 | 0 | 17 | 1.0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 98 | 522.558825103114 | 627.046853631639 | 7.0 | 15 | 0 | 12 | 1.0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 99 | 422.842681154036 | 627.046853631639 | 7.0 | 15 | 0 | 14 | 1.0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 100 | 515.308862586361 | 657.567686057395 | 5.0 | 20 | 0 | 18 | 2.0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ... | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Let's look at the correlation between the response column and the predictors. We'll look to keep columns with correlations coefficients greater than 20% (the top 10 features).
%matplotlib inline
x = africa.corr(focus = "student_score")
africa = africa.select(columns = x["index"][0:12])
display(africa)
123 student_scoreFloat | 123 socio_eco_statutNumeric(7,3) | 123 teacher_scoreFloat | 123 source_of_lighting_ELECTRICInteger | 123 socio_eco_statut_14.000Integer | 123 means_of_travel_CARInteger | 123 repeated_grades_NEVERInteger | 123 english_at_home_NEVERInteger | 123 ageInteger | 123 country_TanzaniaInteger | 123 source_of_lighting_CANDLEInteger | 123 Integer | |
| 1 | 425.993367323877 | 5.0 | 537.289572911762 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 2 | 534.329515370892 | 7.0 | 537.289572911762 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 3 | 536.690743411639 | 8.0 | 537.289572911762 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 4 | 569.392927563969 | 9.0 | 537.289572911762 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 5 | 542.037992351316 | 11.0 | 537.289572911762 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 6 | 573.771789981159 | 11.0 | 537.289572911762 | 1 | 0 | 1 | 1 | 0 | 12 | 0 | 0 | |
| 7 | 589.279157441376 | 12.0 | 537.289572911762 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 8 | 496.740841813343 | 12.0 | 537.289572911762 | 1 | 0 | 1 | 1 | 0 | 14 | 0 | 0 | |
| 9 | 535.805274812767 | 10.0 | 549.40293941491 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 10 | 420.509155247374 | 3.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 11 | 504.298378016207 | 3.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 12 | 450.768711398358 | 4.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 13 | 441.927245450751 | 5.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 14 | 469.987298066451 | 5.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 15 | 445.259642792635 | 6.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 16 | 551.071920864503 | 6.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 17 | 473.825234391116 | 7.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 18 | 544.095820873929 | 8.0 | 624.124902231691 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 19 | 564.874824604798 | 8.0 | 624.124902231691 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 20 | 386.940445160128 | 3.0 | 569.993686161283 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 21 | 458.501728934408 | 5.0 | 593.122754483926 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 1 | |
| 22 | 460.360232184133 | 7.0 | 569.993686161283 | 1 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 23 | 457.035551231015 | 7.0 | 593.122754483926 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 24 | 504.282977573042 | 8.0 | 593.122754483926 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 25 | 475.872247772718 | 10.0 | 569.993686161283 | 1 | 0 | 0 | 1 | 0 | 16 | 0 | 0 | |
| 26 | 503.899980617811 | 2.0 | 584.886538196464 | 0 | 0 | 0 | 1 | 0 | 15 | 0 | 1 | |
| 27 | 480.484906064866 | 3.0 | 584.886538196464 | 0 | 0 | 0 | 1 | 0 | 15 | 0 | 1 | |
| 28 | 516.744491629541 | 6.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 29 | 394.65259093503 | 6.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 30 | 506.128325450387 | 7.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 31 | 440.401203829463 | 8.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 32 | 453.010211603314 | 8.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 33 | 498.219068060275 | 11.0 | 641.876995222798 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 34 | 428.988211440412 | 2.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 35 | 532.255684949772 | 2.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 1 | |
| 36 | 392.664714363554 | 4.0 | 676.11173539576 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 37 | 415.95588691273 | 4.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 38 | 479.525184773189 | 4.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 39 | 410.328608434232 | 4.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 40 | 425.993367323877 | 4.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 41 | 409.430742983857 | 5.0 | 656.225505518354 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 42 | 460.605886281468 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 43 | 560.188989035577 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 44 | 378.486087509513 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 45 | 516.831361986859 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 46 | 557.155342162198 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 47 | 631.282997954796 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 48 | 501.677328837489 | 6.0 | 656.225505518354 | 0 | 0 | 0 | 1 | 0 | 18 | 0 | 1 | |
| 49 | 466.248533790025 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 50 | 594.667991916549 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 51 | 619.020904331767 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 52 | 422.517903579997 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 53 | 514.338009258817 | 6.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 54 | 512.766872215611 | 7.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 55 | 456.266205420931 | 7.0 | 676.11173539576 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 56 | 380.388263378723 | 8.0 | 656.225505518354 | 0 | 0 | 1 | 1 | 0 | 13 | 0 | 0 | |
| 57 | 421.344721387902 | 8.0 | 676.11173539576 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 58 | 486.501284763764 | 9.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 59 | 453.357504553945 | 9.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 60 | 498.219068060275 | 9.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 61 | 514.807687171462 | 10.0 | 638.008383664231 | 1 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 62 | 565.065579807459 | 13.0 | 683.217366694882 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 63 | 626.714865963592 | 14.0 | 638.008383664231 | 1 | 1 | 1 | 1 | 0 | 11 | 0 | 0 | |
| 64 | 457.134154158281 | 14.0 | 683.217366694882 | 1 | 1 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 65 | 510.499756960558 | 2.0 | 634.222848016075 | 0 | 0 | 0 | 1 | 0 | 16 | 0 | 0 | |
| 66 | 494.235377715545 | 2.0 | 634.222848016075 | 0 | 0 | 0 | 1 | 0 | 17 | 0 | 0 | |
| 67 | 365.266644239282 | 2.0 | 617.7225229859 | 0 | 0 | 0 | 1 | 1 | 13 | 0 | 0 | |
| 68 | 541.173490674172 | 3.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 69 | 455.36049792936 | 3.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 70 | 422.517903579997 | 5.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 71 | 398.31103066659 | 5.0 | 651.629260258888 | 0 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 72 | 395.120560563494 | 6.0 | 639.897815295239 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 73 | 503.716941803917 | 6.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 74 | 427.462485792718 | 6.0 | 623.159046261738 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 75 | 600.91272658553 | 7.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 76 | 565.065579807459 | 7.0 | 645.715848976398 | 1 | 0 | 1 | 1 | 0 | 12 | 0 | 0 | |
| 77 | 540.204883338675 | 7.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 78 | 558.474690429794 | 7.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 79 | 575.637662232951 | 7.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 1 | 13 | 0 | 1 | |
| 80 | 439.680053114802 | 7.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 81 | 353.773643278958 | 7.0 | 617.7225229859 | 0 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 82 | 488.376137298698 | 8.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 83 | 480.908033418792 | 8.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 84 | 535.286927844308 | 8.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 85 | 408.529715955022 | 9.0 | 651.629260258888 | 0 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 86 | 385.53865385057 | 9.0 | 623.159046261738 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 87 | 528.310827853733 | 10.0 | 645.715848976398 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 88 | 548.67653911654 | 10.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 89 | 588.423257247566 | 10.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 90 | 583.034422772394 | 10.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 91 | 455.36049792936 | 10.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 1 | 14 | 0 | 0 | |
| 92 | 459.986311593889 | 11.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 93 | 594.667991916549 | 12.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 94 | 473.481862461084 | 12.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 1 | 11 | 0 | 0 | |
| 95 | 584.081078168864 | 13.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 96 | 504.241138890166 | 13.0 | 645.715848976398 | 1 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 97 | 451.694405556509 | 1.0 | 627.046853631639 | 0 | 0 | 0 | 1 | 0 | 17 | 0 | 0 | |
| 98 | 522.558825103114 | 1.0 | 627.046853631639 | 0 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 99 | 422.842681154036 | 1.0 | 627.046853631639 | 0 | 0 | 0 | 1 | 1 | 14 | 0 | 0 | |
| 100 | 515.308862586361 | 2.0 | 657.567686057395 | 0 | 0 | 0 | 1 | 0 | 18 | 0 | 0 |
Let's examine the correlation matrix to see if we have any independent predictors.
africa.corr()
| "student_score" | "socio_eco_statut" | "teacher_score" | "source_of_lighting_ELECTRIC" | "socio_eco_statut_14.000" | "means_of_travel_CAR" | "repeated_grades_NEVER" | "english_at_home_NEVER" | "age" | "country_Tanzania" | "source_of_lighting_CANDLE" | ||
| 1.0 | 0.367578494077163 | 0.277189404656865 | 0.269276087940798 | 0.232857073694549 | 0.23232990042085 | 0.221863062645218 | -0.221448830352243 | -0.215694238695062 | 0.212223906375641 | -0.194832604630241 | ||
| 0.367578494077163 | 1.0 | 0.160875575871585 | 0.731835446489535 | 0.352795513353648 | 0.322932553036259 | 0.163681533395721 | -0.13742263856166 | -0.410125906734765 | -0.171700553969189 | -0.259509579779055 | ||
| 0.277189404656865 | 0.160875575871585 | 1.0 | 0.0998907064067356 | 0.119655864639574 | 0.126735315875308 | 0.0166893126152209 | -0.0281249815391927 | -0.125535236775701 | 0.0198824285793986 | -0.086981719718143 | ||
| 0.269276087940798 | 0.731835446489535 | 0.0998907064067356 | 1.0 | 0.225565600325586 | 0.239404256832631 | 0.128867996924722 | -0.0955727028568643 | -0.318779142277287 | -0.160647227902258 | -0.403666918392685 | ||
| 0.232857073694549 | 0.352795513353648 | 0.119655864639574 | 0.225565600325586 | 1.0 | 0.308426178567738 | 0.0843862366971435 | -0.0590325114887168 | -0.132499799644539 | -0.0492194225528473 | -0.0905938365134978 | ||
| 0.23232990042085 | 0.322932553036259 | 0.126735315875308 | 0.239404256832631 | 0.308426178567738 | 1.0 | 0.0872814865390086 | -0.061318549517247 | -0.149140611604839 | -0.0598279063632101 | -0.0970330131726927 | ||
| 0.221863062645218 | 0.163681533395721 | 0.0166893126152209 | 0.128867996924722 | 0.0843862366971435 | 0.0872814865390086 | 1.0 | -0.071048098664226 | -0.286750817141117 | 0.109225703279925 | -0.102172122741238 | ||
| -0.221448830352243 | -0.13742263856166 | -0.0281249815391927 | -0.0955727028568643 | -0.0590325114887168 | -0.061318549517247 | -0.071048098664226 | 1.0 | 0.0230635800335197 | -0.083897953683188 | 0.0887804299200322 | ||
| -0.215694238695062 | -0.410125906734765 | -0.125535236775701 | -0.318779142277287 | -0.132499799644539 | -0.149140611604839 | -0.286750817141117 | 0.0230635800335197 | 1.0 | 0.139253623535263 | 0.108089618791283 | ||
| 0.212223906375641 | -0.171700553969189 | 0.0198824285793986 | -0.160647227902258 | -0.0492194225528473 | -0.0598279063632101 | 0.109225703279925 | -0.083897953683188 | 0.139253623535263 | 1.0 | -0.128880144361435 | ||
| -0.194832604630241 | -0.259509579779055 | -0.086981719718143 | -0.403666918392685 | -0.0905938365134978 | -0.0970330131726927 | -0.102172122741238 | 0.0887804299200322 | 0.108089618791283 | -0.128880144361435 | 1.0 | ||
| 0.193205735139521 | 0.328249413593304 | 0.0862600953566919 | 0.187491605410671 | 0.235158998086233 | 0.164691705478487 | 0.0734769317031019 | -0.0630544127583362 | -0.122469827224598 | -0.0437059741299854 | -0.0728434882428964 |
Some of these features are highly-correlated, like socioeconomic status and having an electric lighting. We'll drop the lighting column to avoid unexpected results while computing the linear regression.
africa["source_of_lighting_ELECTRIC"].drop()
123 student_scoreFloat | 123 socio_eco_statutNumeric(7,3) | 123 teacher_scoreFloat | 123 socio_eco_statut_14.000Integer | 123 means_of_travel_CARInteger | 123 repeated_grades_NEVERInteger | 123 english_at_home_NEVERInteger | 123 ageInteger | 123 country_TanzaniaInteger | 123 source_of_lighting_CANDLEInteger | 123 Integer | |
| 1 | 425.993367323877 | 5.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 2 | 534.329515370892 | 7.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 3 | 536.690743411639 | 8.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 4 | 569.392927563969 | 9.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 5 | 542.037992351316 | 11.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 6 | 573.771789981159 | 11.0 | 537.289572911762 | 0 | 1 | 1 | 0 | 12 | 0 | 0 | |
| 7 | 589.279157441376 | 12.0 | 537.289572911762 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 8 | 496.740841813343 | 12.0 | 537.289572911762 | 0 | 1 | 1 | 0 | 14 | 0 | 0 | |
| 9 | 535.805274812767 | 10.0 | 549.40293941491 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 10 | 420.509155247374 | 3.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 11 | 504.298378016207 | 3.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 12 | 450.768711398358 | 4.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 13 | 441.927245450751 | 5.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 14 | 469.987298066451 | 5.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 15 | 445.259642792635 | 6.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 16 | 551.071920864503 | 6.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 17 | 473.825234391116 | 7.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 18 | 544.095820873929 | 8.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 19 | 564.874824604798 | 8.0 | 624.124902231691 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 20 | 386.940445160128 | 3.0 | 569.993686161283 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 21 | 458.501728934408 | 5.0 | 593.122754483926 | 0 | 0 | 1 | 0 | 14 | 0 | 1 | |
| 22 | 460.360232184133 | 7.0 | 569.993686161283 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 23 | 457.035551231015 | 7.0 | 593.122754483926 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 24 | 504.282977573042 | 8.0 | 593.122754483926 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 25 | 475.872247772718 | 10.0 | 569.993686161283 | 0 | 0 | 1 | 0 | 16 | 0 | 0 | |
| 26 | 503.899980617811 | 2.0 | 584.886538196464 | 0 | 0 | 1 | 0 | 15 | 0 | 1 | |
| 27 | 480.484906064866 | 3.0 | 584.886538196464 | 0 | 0 | 1 | 0 | 15 | 0 | 1 | |
| 28 | 516.744491629541 | 6.0 | 641.876995222798 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 29 | 394.65259093503 | 6.0 | 641.876995222798 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 30 | 506.128325450387 | 7.0 | 641.876995222798 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 31 | 440.401203829463 | 8.0 | 641.876995222798 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 32 | 453.010211603314 | 8.0 | 641.876995222798 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 33 | 498.219068060275 | 11.0 | 641.876995222798 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 34 | 428.988211440412 | 2.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 35 | 532.255684949772 | 2.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 14 | 0 | 1 | |
| 36 | 392.664714363554 | 4.0 | 676.11173539576 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 37 | 415.95588691273 | 4.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 38 | 479.525184773189 | 4.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 39 | 410.328608434232 | 4.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 40 | 425.993367323877 | 4.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 41 | 409.430742983857 | 5.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 42 | 460.605886281468 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 43 | 560.188989035577 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 44 | 378.486087509513 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 45 | 516.831361986859 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 46 | 557.155342162198 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 47 | 631.282997954796 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 48 | 501.677328837489 | 6.0 | 656.225505518354 | 0 | 0 | 1 | 0 | 18 | 0 | 1 | |
| 49 | 466.248533790025 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 50 | 594.667991916549 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 51 | 619.020904331767 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 52 | 422.517903579997 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 53 | 514.338009258817 | 6.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 54 | 512.766872215611 | 7.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 55 | 456.266205420931 | 7.0 | 676.11173539576 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 56 | 380.388263378723 | 8.0 | 656.225505518354 | 0 | 1 | 1 | 0 | 13 | 0 | 0 | |
| 57 | 421.344721387902 | 8.0 | 676.11173539576 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 58 | 486.501284763764 | 9.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 59 | 453.357504553945 | 9.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 60 | 498.219068060275 | 9.0 | 638.008383664231 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 61 | 514.807687171462 | 10.0 | 638.008383664231 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 62 | 565.065579807459 | 13.0 | 683.217366694882 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 63 | 626.714865963592 | 14.0 | 638.008383664231 | 1 | 1 | 1 | 0 | 11 | 0 | 0 | |
| 64 | 457.134154158281 | 14.0 | 683.217366694882 | 1 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 65 | 510.499756960558 | 2.0 | 634.222848016075 | 0 | 0 | 1 | 0 | 16 | 0 | 0 | |
| 66 | 494.235377715545 | 2.0 | 634.222848016075 | 0 | 0 | 1 | 0 | 17 | 0 | 0 | |
| 67 | 365.266644239282 | 2.0 | 617.7225229859 | 0 | 0 | 1 | 1 | 13 | 0 | 0 | |
| 68 | 541.173490674172 | 3.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 69 | 455.36049792936 | 3.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 70 | 422.517903579997 | 5.0 | 645.715848976398 | 0 | 0 | 1 | 1 | 12 | 0 | 0 | |
| 71 | 398.31103066659 | 5.0 | 651.629260258888 | 0 | 0 | 1 | 0 | 14 | 0 | 0 | |
| 72 | 395.120560563494 | 6.0 | 639.897815295239 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 73 | 503.716941803917 | 6.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 1 | |
| 74 | 427.462485792718 | 6.0 | 623.159046261738 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 75 | 600.91272658553 | 7.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 76 | 565.065579807459 | 7.0 | 645.715848976398 | 0 | 1 | 1 | 0 | 12 | 0 | 0 | |
| 77 | 540.204883338675 | 7.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 78 | 558.474690429794 | 7.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 79 | 575.637662232951 | 7.0 | 645.715848976398 | 0 | 0 | 1 | 1 | 13 | 0 | 1 | |
| 80 | 439.680053114802 | 7.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 11 | 0 | 1 | |
| 81 | 353.773643278958 | 7.0 | 617.7225229859 | 0 | 0 | 1 | 0 | 13 | 0 | 1 | |
| 82 | 488.376137298698 | 8.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 83 | 480.908033418792 | 8.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 84 | 535.286927844308 | 8.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 85 | 408.529715955022 | 9.0 | 651.629260258888 | 0 | 0 | 1 | 0 | 15 | 0 | 0 | |
| 86 | 385.53865385057 | 9.0 | 623.159046261738 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 87 | 528.310827853733 | 10.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 88 | 548.67653911654 | 10.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 89 | 588.423257247566 | 10.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 90 | 583.034422772394 | 10.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 91 | 455.36049792936 | 10.0 | 645.715848976398 | 0 | 0 | 1 | 1 | 14 | 0 | 0 | |
| 92 | 459.986311593889 | 11.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 13 | 0 | 0 | |
| 93 | 594.667991916549 | 12.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 94 | 473.481862461084 | 12.0 | 645.715848976398 | 0 | 0 | 1 | 1 | 11 | 0 | 0 | |
| 95 | 584.081078168864 | 13.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 96 | 504.241138890166 | 13.0 | 645.715848976398 | 0 | 0 | 1 | 0 | 11 | 0 | 0 | |
| 97 | 451.694405556509 | 1.0 | 627.046853631639 | 0 | 0 | 1 | 0 | 17 | 0 | 0 | |
| 98 | 522.558825103114 | 1.0 | 627.046853631639 | 0 | 0 | 1 | 0 | 12 | 0 | 0 | |
| 99 | 422.842681154036 | 1.0 | 627.046853631639 | 0 | 0 | 1 | 1 | 14 | 0 | 0 | |
| 100 | 515.308862586361 | 2.0 | 657.567686057395 | 0 | 0 | 1 | 0 | 18 | 0 | 0 |
Let's normalize the dataset to follow the Gaussian-Markov assumptions.
africa.normalize(columns = africa.get_columns(exclude_columns = ["student_score"]))
123 student_scoreFloat | 123 socio_eco_statutFloat | 123 teacher_scoreFloat | 123 socio_eco_statut_14.000Float | 123 means_of_travel_CARFloat | 123 repeated_grades_NEVERFloat | 123 english_at_home_NEVERFloat | 123 ageFloat | 123 country_TanzaniaFloat | 123 source_of_lighting_CANDLEFloat | 123 Float | |
| 1 | 425.993367323877 | -0.6227716354899414 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 2 | 534.329515370892 | -0.036979420570280655 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 3 | 536.690743411639 | 0.2559166868895497 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 4 | 569.392927563969 | 0.5488127943493801 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 5 | 542.037992351316 | 1.134605009269041 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 6 | 573.771789981159 | 1.134605009269041 | -3.18132114374191 | -0.17522959993794446 | 4.236805643089843 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 7 | 589.279157441376 | 1.4275011167288714 | -3.18132114374191 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 8 | 496.740841813343 | 1.4275011167288714 | -3.18132114374191 | -0.17522959993794446 | 4.236805643089843 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 9 | 535.805274812767 | 0.8417089018092105 | -3.01529274646835 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 10 | 420.509155247374 | -1.2085638504096021 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 11 | 504.298378016207 | -1.2085638504096021 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 12 | 450.768711398358 | -0.9156677429497718 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 13 | 441.927245450751 | -0.6227716354899414 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 14 | 469.987298066451 | -0.6227716354899414 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 15 | 445.259642792635 | -0.32987552803011105 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 16 | 551.071920864503 | -0.32987552803011105 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | -0.521812307163167 | |
| 17 | 473.825234391116 | -0.036979420570280655 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 18 | 544.095820873929 | 0.2559166868895497 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 19 | 564.874824604798 | 0.2559166868895497 | -1.99113751064845 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 20 | 386.940445160128 | -1.2085638504096021 | -2.7330715588177 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 21 | 458.501728934408 | -0.6227716354899414 | -2.41605959166216 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | 1.9163602467967908 | |
| 22 | 460.360232184133 | -0.036979420570280655 | -2.7330715588177 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.9915654737489674 | -0.2858684831209496 | -0.521812307163167 | |
| 23 | 457.035551231015 | -0.036979420570280655 | -2.41605959166216 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | -0.521812307163167 | |
| 24 | 504.282977573042 | 0.2559166868895497 | -2.41605959166216 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | -0.521812307163167 | |
| 25 | 475.872247772718 | 0.8417089018092105 | -2.7330715588177 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 1.5912626705988007 | -0.2858684831209496 | -0.521812307163167 | |
| 26 | 503.899980617811 | -1.5014599578694325 | -2.5289469371784 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.9915654737489674 | -0.2858684831209496 | 1.9163602467967908 | |
| 27 | 480.484906064866 | -1.2085638504096021 | -2.5289469371784 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.9915654737489674 | -0.2858684831209496 | 1.9163602467967908 | |
| 28 | 516.744491629541 | -0.32987552803011105 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | 1.9163602467967908 | |
| 29 | 394.65259093503 | -0.32987552803011105 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | 2.05125048598223 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 30 | 506.128325450387 | -0.036979420570280655 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | 1.9163602467967908 | |
| 31 | 440.401203829463 | 0.2559166868895497 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 32 | 453.010211603314 | 0.2559166868895497 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | -0.521812307163167 | |
| 33 | 498.219068060275 | 1.134605009269041 | -1.74782351971136 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | 1.9163602467967908 | |
| 34 | 428.988211440412 | -1.5014599578694325 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 35 | 532.255684949772 | -1.5014599578694325 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | 1.9163602467967908 | |
| 36 | 392.664714363554 | -0.9156677429497718 | -1.27859483415013 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | 1.9163602467967908 | |
| 37 | 415.95588691273 | -0.9156677429497718 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.20782891995069913 | -0.2858684831209496 | 1.9163602467967908 | |
| 38 | 479.525184773189 | -0.9156677429497718 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | 1.9163602467967908 | |
| 39 | 410.328608434232 | -0.9156677429497718 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | 1.9163602467967908 | |
| 40 | 425.993367323877 | -0.9156677429497718 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 41 | 409.430742983857 | -0.6227716354899414 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 42 | 460.605886281468 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 43 | 560.188989035577 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 44 | 378.486087509513 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 0.3918682768991341 | -0.2858684831209496 | -0.521812307163167 | |
| 45 | 516.831361986859 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | -0.521812307163167 | |
| 46 | 557.155342162198 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 47 | 631.282997954796 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 48 | 501.677328837489 | -0.32987552803011105 | -1.5511597626117 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | 2.7906570642984674 | -0.2858684831209496 | 1.9163602467967908 | |
| 49 | 466.248533790025 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 50 | 594.667991916549 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 51 | 619.020904331767 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 52 | 422.517903579997 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 | -0.2858684831209496 | -0.521812307163167 | |
| 53 | 514.338009258817 | -0.32987552803011105 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -1.4072233136503656 | -0.2858684831209496 | -0.521812307163167 | |
| 54 | 512.766872215611 | -0.036979420570280655 | -1.80084753880431 | -0.17522959993794446 | -0.23602224080487655 | 0.8041706293603288 | -0.48749792800559544 | -0.8075261168005324 |
