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.

[1]:

import verticapy as vp
vp.set_option("plotting_lib","highcharts")
africa = vp.read_csv("data/africa_education.csv")
africa = africa.select(["(zralocp + zmalocp) / 2 AS student_score",
                        "zraloct 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_score Float(22)	123 teacher_score Float(22)	123 teacher_year_teaching Numeric(9)	123 number_students_school Integer	Abc english_at_home Varchar(32)	Abc travel_distance Varchar(22)	Abc means_of_travel Varchar(26)	Abc Varchar(68)	Abc Varchar(68)	Abc source_of_lighting Varchar(24)	123 days_absent Integer	Abc repeated_grades Varchar(20)	Abc sitting_place Varchar(54)	123 age Integer	123 socio_eco_statut Numeric(9)	Abc country Varchar(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	581.994282503848	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	581.994282503848	10.0	23	SOMETIMES	>0.5-1KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	13	7.0	Namibia
4	536.690743411639	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	10.0	23	SOMETIMES	>2.5-3KM	CAR			ELECTRIC	0	NEVER	I have my own sitting place	14	12.0	Namibia
10	535.805274812767	601.83282358059	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	601.83282358059	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	648.090960225876	3.0	23	SOMETIMES	>2-2.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	14	5.0	Mozambique
23	460.360232184133	601.83282358059	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	648.090960225876	3.0	23	SOMETIMES	>1.5-2KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	7.0	Mozambique
25	504.282977573042	648.090960225876	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	601.83282358059	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	613.278135740248	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	613.278135740248	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	715.332169163869	20.0	25	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	6.0	Namibia
30	394.65259093503	715.332169163869	20.0	25	NEVER	>5KM	WALK			PARAFFIN/OIL	0	NEVER	I have my own sitting place	12	6.0	Namibia
31	506.128325450387	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	20.0	25	SOMETIMES	>1-1.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	11	11.0	Namibia
35	359.385615553614	648.090960225876	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	648.090960225876	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	648.090960225876	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	648.090960225876	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	648.090960225876	30.0	16	SOMETIMES	UP TO 0.5KM	WALK			GAS	0	NEVER	I have my own sitting place	17	[null]	Mozambique
40	[null]	709.132625077388	2.0	16	SOMETIMES	>5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	17	4.0	Mozambique
41	428.988211440412	727.826634938163	8.0	23	SOMETIMES	>5KM	WALK			FIRE	0	NEVER	I have my own sitting place	12	2.0	Namibia
42	532.255684949772	727.826634938163	8.0	23	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	14	2.0	Namibia
43	392.664714363554	767.599094692976	8.0	20	ALL THE TIME	>3-3.5KM	WALK			CANDLE	0	NEVER	No place/share	13	4.0	Zambia
44	415.95588691273	727.826634938163	8.0	23	SOMETIMES	>5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	4.0	Namibia
45	479.525184773189	727.826634938163	8.0	23	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	4.0	Namibia
46	410.328608434232	727.826634938163	8.0	23	SOMETIMES	>1-1.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	4.0	Namibia
47	425.993367323877	727.826634938163	8.0	23	SOMETIMES	>3-3.5KM	WALK			FIRE	0	NEVER	I have my own sitting place	12	4.0	Namibia
48	409.430742983857	727.826634938163	8.0	23	SOMETIMES	>1.5-2KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	12	5.0	Namibia
49	460.605886281468	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	727.826634938163	8.0	23	SOMETIMES	>2.5-3KM	WALK			CANDLE	0	NEVER	I have my own sitting place	18	6.0	Namibia
56	466.248533790025	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	767.599094692976	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	11	7.0	Zambia
63	380.388263378723	727.826634938163	8.0	23	SOMETIMES	>5KM	CAR			PARAFFIN/OIL	0	NEVER	I have my own sitting place	13	8.0	Namibia
64	421.344721387902	767.599094692976	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	11	8.0	Zambia
65	486.501284763764	691.392391229917	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	691.392391229917	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	691.392391229917	6.0	24	SOMETIMES	>0.5-1KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	9.0	Namibia
68	514.807687171462	691.392391229917	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	781.810357291219	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	691.392391229917	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	781.810357291219	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	668.40638930927	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	668.40638930927	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	635.405739248921	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	691.392391229917	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	691.392391229917	8.0	20	SOMETIMES	>5KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	15	3.0	Malawi
77	422.517903579997	691.392391229917	8.0	20	NEVER	>0.5-1KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	12	5.0	Malawi
78	398.31103066659	703.219213794897	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	679.756323867598	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	691.392391229917	6.0	49	SOMETIMES	>5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	6.0	Namibia
81	427.462485792718	646.278785800597	8.0	18	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	13	6.0	Zambia
82	600.91272658553	691.392391229917	6.0	49	SOMETIMES	>2-2.5KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	12	7.0	Namibia
83	565.065579807459	691.392391229917	6.0	49	SOMETIMES	>5KM	CAR			ELECTRIC	0	NEVER	I have my own sitting place	12	7.0	Namibia
84	540.204883338675	691.392391229917	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	691.392391229917	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	691.392391229917	6.0	49	NEVER	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	7.0	Namibia
87	439.680053114802	691.392391229917	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	11	7.0	Malawi
88	353.773643278958	635.405739248921	1.0	13	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	7.0	Zambia
89	488.376137298698	691.392391229917	6.0	49	SOMETIMES	>1-1.5KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	8.0	Namibia
90	480.908033418792	691.392391229917	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	691.392391229917	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	703.219213794897	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	8.0	20	NEVER	>3.5-4KM	WALK			ELECTRIC	0	NEVER	No place/share	14	10.0	Malawi
99	459.986311593889	691.392391229917	6.0	49	SOMETIMES	>2.5-3KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	13	11.0	Namibia
100	594.667991916549	691.392391229917	6.0	49	SOMETIMES	UP TO 0.5KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	12	12.0	Namibia

Rows: 1-100 | Columns: 16

First, let’s look for missing values.

[2]:

africa.count_percent()

[2]:

	count	percent
"number_students_school"	59909.0	100.0
"english_at_home"	59909.0	100.0
"travel_distance"	59909.0	100.0
"means_of_travel"	59909.0	100.0
"m_education"	59909.0	100.0
"source_of_lighting"	59909.0	100.0
"days_absent"	59909.0	100.0
"repeated_grades"	59909.0	100.0
"sitting_place"	59909.0	100.0
"age"	59909.0	100.0
"country"	59909.0	100.0
"socio_eco_statut"	59851.0	99.903
"student_score"	59829.0	99.866
"teacher_year_teaching"	59728.0	99.698
"f_education"	59618.0	99.514
"teacher_score"	53527.0	89.347

Rows: 1-16 | Columns: 3

We’ll simply drop the missing values to avoid adding bias to the data.

[3]:

africa.dropna()

6722 elements were filtered.

[3]:

	123 student_score Float(22)	123 teacher_score Float(22)	123 teacher_year_teaching Numeric(9)	123 number_students_school Integer	Abc english_at_home Varchar(32)	Abc travel_distance Varchar(22)	Abc means_of_travel Varchar(26)	Abc Varchar(68)	Abc Varchar(68)	Abc source_of_lighting Varchar(24)	123 days_absent Integer	Abc repeated_grades Varchar(20)	Abc sitting_place Varchar(54)	123 age Integer	123 socio_eco_statut Numeric(9)	Abc country Varchar(24)
1	425.993367323877	581.994282503848	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	581.994282503848	10.0	23	SOMETIMES	>0.5-1KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	13	7.0	Namibia
3	536.690743411639	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	10.0	23	SOMETIMES	>2.5-3KM	CAR			ELECTRIC	0	NEVER	I have my own sitting place	14	12.0	Namibia
9	535.805274812767	601.83282358059	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	601.83282358059	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	648.090960225876	3.0	23	SOMETIMES	>2-2.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	14	5.0	Mozambique
22	460.360232184133	601.83282358059	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	648.090960225876	3.0	23	SOMETIMES	>1.5-2KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	7.0	Mozambique
24	504.282977573042	648.090960225876	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	601.83282358059	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	613.278135740248	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	613.278135740248	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	715.332169163869	20.0	25	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	6.0	Namibia
29	394.65259093503	715.332169163869	20.0	25	NEVER	>5KM	WALK			PARAFFIN/OIL	0	NEVER	I have my own sitting place	12	6.0	Namibia
30	506.128325450387	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	20.0	25	SOMETIMES	>1-1.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	11	11.0	Namibia
34	428.988211440412	727.826634938163	8.0	23	SOMETIMES	>5KM	WALK			FIRE	0	NEVER	I have my own sitting place	12	2.0	Namibia
35	532.255684949772	727.826634938163	8.0	23	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	14	2.0	Namibia
36	392.664714363554	767.599094692976	8.0	20	ALL THE TIME	>3-3.5KM	WALK			CANDLE	0	NEVER	No place/share	13	4.0	Zambia
37	415.95588691273	727.826634938163	8.0	23	SOMETIMES	>5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	4.0	Namibia
38	479.525184773189	727.826634938163	8.0	23	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	4.0	Namibia
39	410.328608434232	727.826634938163	8.0	23	SOMETIMES	>1-1.5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	4.0	Namibia
40	425.993367323877	727.826634938163	8.0	23	SOMETIMES	>3-3.5KM	WALK			FIRE	0	NEVER	I have my own sitting place	12	4.0	Namibia
41	409.430742983857	727.826634938163	8.0	23	SOMETIMES	>1.5-2KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	12	5.0	Namibia
42	460.605886281468	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	727.826634938163	8.0	23	SOMETIMES	>2.5-3KM	WALK			CANDLE	0	NEVER	I have my own sitting place	18	6.0	Namibia
49	466.248533790025	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	767.599094692976	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	11	7.0	Zambia
56	380.388263378723	727.826634938163	8.0	23	SOMETIMES	>5KM	CAR			PARAFFIN/OIL	0	NEVER	I have my own sitting place	13	8.0	Namibia
57	421.344721387902	767.599094692976	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	11	8.0	Zambia
58	486.501284763764	691.392391229917	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	691.392391229917	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	691.392391229917	6.0	24	SOMETIMES	>0.5-1KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	9.0	Namibia
61	514.807687171462	691.392391229917	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	781.810357291219	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	691.392391229917	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	781.810357291219	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	668.40638930927	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	668.40638930927	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	635.405739248921	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	691.392391229917	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	691.392391229917	8.0	20	SOMETIMES	>5KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	15	3.0	Malawi
70	422.517903579997	691.392391229917	8.0	20	NEVER	>0.5-1KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	12	5.0	Malawi
71	398.31103066659	703.219213794897	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	679.756323867598	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	691.392391229917	6.0	49	SOMETIMES	>5KM	WALK			CANDLE	0	NEVER	I have my own sitting place	12	6.0	Namibia
74	427.462485792718	646.278785800597	8.0	18	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	13	6.0	Zambia
75	600.91272658553	691.392391229917	6.0	49	SOMETIMES	>2-2.5KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	12	7.0	Namibia
76	565.065579807459	691.392391229917	6.0	49	SOMETIMES	>5KM	CAR			ELECTRIC	0	NEVER	I have my own sitting place	12	7.0	Namibia
77	540.204883338675	691.392391229917	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	691.392391229917	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	691.392391229917	6.0	49	NEVER	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	7.0	Namibia
80	439.680053114802	691.392391229917	8.0	20	SOMETIMES	UP TO 0.5KM	WALK			CANDLE	0	NEVER	No place/share	11	7.0	Malawi
81	353.773643278958	635.405739248921	1.0	13	SOMETIMES	>0.5-1KM	WALK			CANDLE	0	NEVER	I have my own sitting place	13	7.0	Zambia
82	488.376137298698	691.392391229917	6.0	49	SOMETIMES	>1-1.5KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	11	8.0	Namibia
83	480.908033418792	691.392391229917	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	691.392391229917	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	703.219213794897	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	8.0	20	NEVER	>3.5-4KM	WALK			ELECTRIC	0	NEVER	No place/share	14	10.0	Malawi
92	459.986311593889	691.392391229917	6.0	49	SOMETIMES	>2.5-3KM	WALK			ELECTRIC	0	NEVER	I have my own sitting place	13	11.0	Namibia
93	594.667991916549	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	648.090960225876	7.0	15	SOMETIMES	UP TO 0.5KM	WALK			FIRE	0	NEVER	No place/share	17	1.0	Mozambique
98	522.558825103114	648.090960225876	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	648.090960225876	7.0	15	NEVER	>0.5-1KM	WALK			NO LIGHTING	0	NEVER	No place/share	14	1.0	Mozambique
100	515.308862586361	709.132625077388	5.0	20	SOMETIMES	>1-1.5KM	WALK			PARAFFIN/OIL	0	NEVER	No place/share	18	2.0	Mozambique

Rows: 1-100 of 53187 | Columns: 16

We need to encode the categorical columns to dummies to retain linearity.

[4]:

africa.one_hot_encode(max_cardinality = 20)

/opt/venv/lib/python3.10/site-packages/verticapy/core/vdataframe/_encoding.py:123: Warning: The vDataColumn '"student_score"' was ignored because of its high cardinality.
Increase the parameter 'max_cardinality' to solve this issue or use directly the vDataColumn get_dummies method.
warnings.warn(warning_message, Warning)
/opt/venv/lib/python3.10/site-packages/verticapy/core/vdataframe/_encoding.py:123: Warning: The vDataColumn '"teacher_score"' was ignored because of its high cardinality.
Increase the parameter 'max_cardinality' to solve this issue or use directly the vDataColumn get_dummies method.
warnings.warn(warning_message, Warning)
/opt/venv/lib/python3.10/site-packages/verticapy/core/vdataframe/_encoding.py:123: Warning: The vDataColumn '"teacher_year_teaching"' was ignored because of its high cardinality.
Increase the parameter 'max_cardinality' to solve this issue or use directly the vDataColumn get_dummies method.
warnings.warn(warning_message, Warning)
/opt/venv/lib/python3.10/site-packages/verticapy/core/vdataframe/_encoding.py:123: Warning: The vDataColumn '"number_students_school"' was ignored because of its high cardinality.
Increase the parameter 'max_cardinality' to solve this issue or use directly the vDataColumn get_dummies method.
warnings.warn(warning_message, Warning)
/opt/venv/lib/python3.10/site-packages/verticapy/core/vdataframe/_encoding.py:123: Warning: The vDataColumn '"days_absent"' was ignored because of its high cardinality.
Increase the parameter 'max_cardinality' to solve this issue or use directly the vDataColumn get_dummies method.
warnings.warn(warning_message, Warning)

[4]:

	123 student_score Float(22)	123 teacher_score Float(22)	123 teacher_year_teaching Numeric(9)	123 number_students_school Integer	Abc english_at_home Varchar(32)	Abc travel_distance Varchar(22)	Abc means_of_travel Varchar(26)	Abc Varchar(68)	Abc Varchar(68)	Abc source_of_lighting Varchar(24)	123 days_absent Integer	Abc repeated_grades Varchar(20)	Abc sitting_place Varchar(54)	123 age Integer	123 socio_eco_statut Numeric(9)	Abc country Varchar(24)	123 english_at_home_ALL_THE_TIME Integer	123 english_at_home_MOST_OF_THE_TIME Integer	123 english_at_home_NEVER Integer	123 travel_distance_>0.5-1KM Integer	123 travel_distance_>1-1.5KM Integer	123 travel_distance_>1.5-2KM Integer	123 travel_distance_>2-2.5KM Integer	123 travel_distance_>2.5-3KM Integer	123 travel_distance_>3-3.5KM Integer	...	123 socio_eco_statut_3.000 Integer	123 socio_eco_statut_4.000 Integer	123 socio_eco_statut_5.000 Integer	123 socio_eco_statut_6.000 Integer	123 socio_eco_statut_7.000 Integer	123 socio_eco_statut_8.000 Integer	123 socio_eco_statut_9.000 Integer	123 socio_eco_statut_10.000 Integer	123 socio_eco_statut_11.000 Integer	123 socio_eco_statut_12.000 Integer	123 socio_eco_statut_13.000 Integer	123 socio_eco_statut_14.000 Integer	123 country_Botswana Integer	123 country_Kenya Integer	123 country_Lesotho Integer	123 country_Malawi Integer	123 country_Mozambique Integer	123 country_Namibia Integer	123 country_Seychelles Integer	123 country_South_Africa Integer	123 country_Swaziland Integer	123 country_Tanzania Integer	123 country_Uganda Integer	123 country_Zambia Integer	123 country_Zanzibar Integer
1	425.993367323877	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	601.83282358059	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	601.83282358059	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	648.090960225876	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	601.83282358059	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	648.090960225876	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	648.090960225876	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	601.83282358059	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	613.278135740248	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	613.278135740248	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	727.826634938163	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	727.826634938163	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	767.599094692976	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	727.826634938163	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	767.599094692976	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	727.826634938163	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	767.599094692976	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	781.810357291219	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	691.392391229917	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	781.810357291219	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	668.40638930927	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	668.40638930927	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	635.405739248921	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	703.219213794897	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	679.756323867598	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	691.392391229917	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	635.405739248921	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	703.219213794897	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	648.090960225876	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	648.090960225876	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	648.090960225876	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	709.132625077388	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

Rows: 1-100 of 53187 | Columns: 51

Linear regression can only handle numerical columns, so we’ll drop the categorical columns.

[5]:

africa.drop(columns = ["english_at_home",
                       "travel_distance",
                       "means_of_travel",
                       "m_education",
                       "f_education",
                       "source_of_lighting",
                       "repeated_grades",
                       "sitting_place",
                       "country"])

[5]:

	123 student_score Float(22)	123 teacher_score Float(22)	123 teacher_year_teaching Numeric(9)	123 number_students_school Integer	123 days_absent Integer	123 age Integer	123 socio_eco_statut Numeric(9)	123 english_at_home_ALL_THE_TIME Integer	123 english_at_home_MOST_OF_THE_TIME Integer	123 english_at_home_NEVER Integer	123 travel_distance_>0.5-1KM Integer	123 travel_distance_>1-1.5KM Integer	123 travel_distance_>1.5-2KM Integer	123 travel_distance_>2-2.5KM Integer	123 travel_distance_>2.5-3KM Integer	123 travel_distance_>3-3.5KM Integer	123 travel_distance_>3.5-4KM Integer	123 travel_distance_>4.5-5KM Integer	123 travel_distance_>4KM-4.5KM Integer	123 travel_distance_>5KM Integer	123 means_of_travel_BICYCLE Integer	123 means_of_travel_BUS_TRUCK_VAN Integer	123 means_of_travel_CAR Integer	123 means_of_travel_OTHER Integer	123 means_of_travel_TRAIN Integer	...	123 socio_eco_statut_3.000 Integer	123 socio_eco_statut_4.000 Integer	123 socio_eco_statut_5.000 Integer	123 socio_eco_statut_6.000 Integer	123 socio_eco_statut_7.000 Integer	123 socio_eco_statut_8.000 Integer	123 socio_eco_statut_9.000 Integer	123 socio_eco_statut_10.000 Integer	123 socio_eco_statut_11.000 Integer	123 socio_eco_statut_12.000 Integer	123 socio_eco_statut_13.000 Integer	123 socio_eco_statut_14.000 Integer	123 country_Botswana Integer	123 country_Kenya Integer	123 country_Lesotho Integer	123 country_Malawi Integer	123 country_Mozambique Integer	123 country_Namibia Integer	123 country_Seychelles Integer	123 country_South_Africa Integer	123 country_Swaziland Integer	123 country_Tanzania Integer	123 country_Uganda Integer	123 country_Zambia Integer	123 country_Zanzibar Integer
1	425.993367323877	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	581.994282503848	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	601.83282358059	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	715.046036359878	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	601.83282358059	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	648.090960225876	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	601.83282358059	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	648.090960225876	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	648.090960225876	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	601.83282358059	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	613.278135740248	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	613.278135740248	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	715.332169163869	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	727.826634938163	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	727.826634938163	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	767.599094692976	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	727.826634938163	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	727.826634938163	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	767.599094692976	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	727.826634938163	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	767.599094692976	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	781.810357291219	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	691.392391229917	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	781.810357291219	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	668.40638930927	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	668.40638930927	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	635.405739248921	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	703.219213794897	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	679.756323867598	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	691.392391229917	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	635.405739248921	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	703.219213794897	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	646.278785800597	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	691.392391229917	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	648.090960225876	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	648.090960225876	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	648.090960225876	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	709.132625077388	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

Rows: 1-100 of 53187 | Columns: 50

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).

[6]:

x = africa.corr(focus = "student_score", show = False)

[7]:

africa = africa.select(columns = x["index"][0:12])
display(africa)

	123 student_score Float(22)	123 socio_eco_statut Numeric(9)	123 source_of_lighting_ELECTRIC Integer	123 means_of_travel_CAR Integer	123 socio_eco_statut_14.000 Integer	123 repeated_grades_NEVER Integer	123 english_at_home_NEVER Integer	123 age Integer	123 country_Tanzania Integer	123 teacher_score Float(22)	123 source_of_lighting_CANDLE Integer	123 Integer
1	425.993367323877	5.0	0	0	0	1	0	14	0	581.994282503848	0
2	534.329515370892	7.0	1	0	0	1	0	13	0	581.994282503848	0
3	536.690743411639	8.0	1	0	0	1	0	12	0	581.994282503848	0
4	569.392927563969	9.0	1	0	0	1	0	13	0	581.994282503848	0
5	542.037992351316	11.0	1	0	0	1	0	12	0	581.994282503848	0
6	573.771789981159	11.0	1	1	0	1	0	12	0	581.994282503848	0
7	589.279157441376	12.0	1	0	0	1	0	12	0	581.994282503848	0
8	496.740841813343	12.0	1	1	0	1	0	14	0	581.994282503848	0
9	535.805274812767	10.0	1	0	0	1	0	13	0	601.83282358059	0
10	420.509155247374	3.0	0	0	0	1	0	13	0	715.046036359878	0
11	504.298378016207	3.0	0	0	0	1	0	13	0	715.046036359878	0
12	450.768711398358	4.0	0	0	0	1	0	14	0	715.046036359878	0
13	441.927245450751	5.0	0	0	0	1	0	14	0	715.046036359878	0
14	469.987298066451	5.0	0	0	0	1	0	14	0	715.046036359878	0
15	445.259642792635	6.0	0	0	0	1	0	13	0	715.046036359878	0
16	551.071920864503	6.0	0	0	0	1	0	13	0	715.046036359878	0
17	473.825234391116	7.0	0	0	0	1	0	12	0	715.046036359878	0
18	544.095820873929	8.0	1	0	0	1	0	12	0	715.046036359878	0
19	564.874824604798	8.0	0	0	0	1	0	14	0	715.046036359878	0
20	386.940445160128	3.0	0	0	0	1	0	14	0	601.83282358059	0
21	458.501728934408	5.0	0	0	0	1	0	14	0	648.090960225876	1
22	460.360232184133	7.0	1	0	0	1	0	15	0	601.83282358059	0
23	457.035551231015	7.0	1	0	0	1	0	11	0	648.090960225876	0
24	504.282977573042	8.0	1	0	0	1	0	11	0	648.090960225876	0
25	475.872247772718	10.0	1	0	0	1	0	16	0	601.83282358059	0
26	503.899980617811	2.0	0	0	0	1	0	15	0	613.278135740248	1
27	480.484906064866	3.0	0	0	0	1	0	15	0	613.278135740248	1
28	516.744491629541	6.0	0	0	0	1	0	12	0	715.332169163869	1
29	394.65259093503	6.0	0	0	0	1	1	12	0	715.332169163869	0
30	506.128325450387	7.0	0	0	0	1	0	11	0	715.332169163869	1
31	440.401203829463	8.0	0	0	0	1	0	12	0	715.332169163869	0
32	453.010211603314	8.0	0	0	0	1	0	11	0	715.332169163869	0
33	498.219068060275	11.0	0	0	0	1	0	11	0	715.332169163869	1
34	428.988211440412	2.0	0	0	0	1	0	12	0	727.826634938163	0
35	532.255684949772	2.0	0	0	0	1	0	14	0	727.826634938163	1
36	392.664714363554	4.0	0	0	0	1	0	13	0	767.599094692976	1
37	415.95588691273	4.0	0	0	0	1	0	13	0	727.826634938163	1
38	479.525184773189	4.0	0	0	0	1	0	12	0	727.826634938163	1
39	410.328608434232	4.0	0	0	0	1	0	12	0	727.826634938163	1
40	425.993367323877	4.0	0	0	0	1	0	12	0	727.826634938163	0
41	409.430742983857	5.0	1	0	0	1	0	12	0	727.826634938163	0
42	460.605886281468	6.0	1	0	0	1	0	12	0	691.392391229917	0
43	560.188989035577	6.0	1	0	0	1	0	12	0	691.392391229917	0
44	378.486087509513	6.0	1	0	0	1	0	14	0	691.392391229917	0
45	516.831361986859	6.0	1	0	0	1	0	11	0	691.392391229917	0
46	557.155342162198	6.0	1	0	0	1	0	12	0	691.392391229917	0
47	631.282997954796	6.0	1	0	0	1	0	12	0	691.392391229917	0
48	501.677328837489	6.0	0	0	0	1	0	18	0	727.826634938163	1
49	466.248533790025	6.0	1	0	0	1	0	12	0	691.392391229917	0
50	594.667991916549	6.0	1	0	0	1	0	12	0	691.392391229917	0
51	619.020904331767	6.0	1	0	0	1	0	12	0	691.392391229917	0
52	422.517903579997	6.0	1	0	0	1	0	12	0	691.392391229917	0
53	514.338009258817	6.0	1	0	0	1	0	11	0	691.392391229917	0
54	512.766872215611	7.0	1	0	0	1	0	12	0	691.392391229917	0
55	456.266205420931	7.0	0	0	0	1	0	11	0	767.599094692976	1
56	380.388263378723	8.0	0	1	0	1	0	13	0	727.826634938163	0
57	421.344721387902	8.0	0	0	0	1	0	11	0	767.599094692976	0
58	486.501284763764	9.0	1	0	0	1	0	13	0	691.392391229917	0
59	453.357504553945	9.0	1	0	0	1	0	12	0	691.392391229917	0
60	498.219068060275	9.0	1	0	0	1	0	11	0	691.392391229917	0
61	514.807687171462	10.0	1	0	0	1	1	12	0	691.392391229917	0
62	565.065579807459	13.0	1	0	0	1	0	12	0	781.810357291219	0
63	626.714865963592	14.0	1	1	1	1	0	11	0	691.392391229917	0
64	457.134154158281	14.0	1	0	1	1	0	13	0	781.810357291219	0
65	510.499756960558	2.0	0	0	0	1	0	16	0	668.40638930927	0
66	494.235377715545	2.0	0	0	0	1	0	17	0	668.40638930927	0
67	365.266644239282	2.0	0	0	0	1	1	13	0	635.405739248921	0
68	541.173490674172	3.0	1	0	0	1	0	12	0	691.392391229917	0
69	455.36049792936	3.0	0	0	0	1	0	15	0	691.392391229917	0
70	422.517903579997	5.0	0	0	0	1	1	12	0	691.392391229917	0
71	398.31103066659	5.0	0	0	0	1	0	14	0	703.219213794897	0
72	395.120560563494	6.0	0	0	0	1	0	12	0	679.756323867598	0
73	503.716941803917	6.0	0	0	0	1	0	12	0	691.392391229917	1
74	427.462485792718	6.0	0	0	0	1	0	13	0	646.278785800597	1
75	600.91272658553	7.0	1	0	0	1	0	12	0	691.392391229917	0
76	565.065579807459	7.0	1	1	0	1	0	12	0	691.392391229917	0
77	540.204883338675	7.0	1	0	0	1	0	11	0	691.392391229917	0
78	558.474690429794	7.0	0	0	0	1	0	12	0	691.392391229917	0
79	575.637662232951	7.0	0	0	0	1	1	13	0	691.392391229917	1
80	439.680053114802	7.0	0	0	0	1	0	11	0	691.392391229917	1
81	353.773643278958	7.0	0	0	0	1	0	13	0	635.405739248921	1
82	488.376137298698	8.0	1	0	0	1	0	11	0	691.392391229917	0
83	480.908033418792	8.0	1	0	0	1	0	12	0	691.392391229917	0
84	535.286927844308	8.0	1	0	0	1	0	12	0	691.392391229917	0
85	408.529715955022	9.0	0	0	0	1	0	15	0	703.219213794897	0
86	385.53865385057	9.0	0	0	0	1	0	12	0	646.278785800597	0
87	528.310827853733	10.0	0	0	0	1	0	12	0	691.392391229917	0
88	548.67653911654	10.0	1	0	0	1	0	12	0	691.392391229917	0
89	588.423257247566	10.0	1	0	0	1	0	13	0	691.392391229917	0
90	583.034422772394	10.0	1	0	0	1	0	13	0	691.392391229917	0
91	455.36049792936	10.0	1	0	0	1	1	14	0	691.392391229917	0
92	459.986311593889	11.0	1	0	0	1	0	13	0	691.392391229917	0
93	594.667991916549	12.0	1	0	0	1	0	12	0	691.392391229917	0
94	473.481862461084	12.0	1	0	0	1	1	11	0	691.392391229917	0
95	584.081078168864	13.0	1	0	0	1	0	12	0	691.392391229917	0
96	504.241138890166	13.0	1	0	0	1	0	11	0	691.392391229917	0
97	451.694405556509	1.0	0	0	0	1	0	17	0	648.090960225876	0
98	522.558825103114	1.0	0	0	0	1	0	12	0	648.090960225876	0
99	422.842681154036	1.0	0	0	0	1	1	14	0	648.090960225876	0
100	515.308862586361	2.0	0	0	0	1	0	18	0	709.132625077388	0

Rows: 1-100 | Columns: 12

Let’s examine the correlation matrix to see if we have any independent predictors.

[8]:

africa.corr()

[8]:

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.

[9]:

africa["source_of_lighting_ELECTRIC"].drop()

[9]:

	123 student_score Float(22)	123 socio_eco_statut Numeric(9)	123 means_of_travel_CAR Integer	123 socio_eco_statut_14.000 Integer	123 repeated_grades_NEVER Integer	123 english_at_home_NEVER Integer	123 age Integer	123 country_Tanzania Integer	123 teacher_score Float(22)	123 source_of_lighting_CANDLE Integer	123 Integer
1	425.993367323877	5.0	0	0	1	0	14	0	581.994282503848	0
2	534.329515370892	7.0	0	0	1	0	13	0	581.994282503848	0
3	536.690743411639	8.0	0	0	1	0	12	0	581.994282503848	0
4	569.392927563969	9.0	0	0	1	0	13	0	581.994282503848	0
5	542.037992351316	11.0	0	0	1	0	12	0	581.994282503848	0
6	573.771789981159	11.0	1	0	1	0	12	0	581.994282503848	0
7	589.279157441376	12.0	0	0	1	0	12	0	581.994282503848	0
8	496.740841813343	12.0	1	0	1	0	14	0	581.994282503848	0
9	535.805274812767	10.0	0	0	1	0	13	0	601.83282358059	0
10	420.509155247374	3.0	0	0	1	0	13	0	715.046036359878	0
11	504.298378016207	3.0	0	0	1	0	13	0	715.046036359878	0
12	450.768711398358	4.0	0	0	1	0	14	0	715.046036359878	0
13	441.927245450751	5.0	0	0	1	0	14	0	715.046036359878	0
14	469.987298066451	5.0	0	0	1	0	14	0	715.046036359878	0
15	445.259642792635	6.0	0	0	1	0	13	0	715.046036359878	0
16	551.071920864503	6.0	0	0	1	0	13	0	715.046036359878	0
17	473.825234391116	7.0	0	0	1	0	12	0	715.046036359878	0
18	544.095820873929	8.0	0	0	1	0	12	0	715.046036359878	0
19	564.874824604798	8.0	0	0	1	0	14	0	715.046036359878	0
20	386.940445160128	3.0	0	0	1	0	14	0	601.83282358059	0
21	458.501728934408	5.0	0	0	1	0	14	0	648.090960225876	1
22	460.360232184133	7.0	0	0	1	0	15	0	601.83282358059	0
23	457.035551231015	7.0	0	0	1	0	11	0	648.090960225876	0
24	504.282977573042	8.0	0	0	1	0	11	0	648.090960225876	0
25	475.872247772718	10.0	0	0	1	0	16	0	601.83282358059	0
26	503.899980617811	2.0	0	0	1	0	15	0	613.278135740248	1
27	480.484906064866	3.0	0	0	1	0	15	0	613.278135740248	1
28	516.744491629541	6.0	0	0	1	0	12	0	715.332169163869	1
29	394.65259093503	6.0	0	0	1	1	12	0	715.332169163869	0
30	506.128325450387	7.0	0	0	1	0	11	0	715.332169163869	1
31	440.401203829463	8.0	0	0	1	0	12	0	715.332169163869	0
32	453.010211603314	8.0	0	0	1	0	11	0	715.332169163869	0
33	498.219068060275	11.0	0	0	1	0	11	0	715.332169163869	1
34	428.988211440412	2.0	0	0	1	0	12	0	727.826634938163	0
35	532.255684949772	2.0	0	0	1	0	14	0	727.826634938163	1
36	392.664714363554	4.0	0	0	1	0	13	0	767.599094692976	1
37	415.95588691273	4.0	0	0	1	0	13	0	727.826634938163	1
38	479.525184773189	4.0	0	0	1	0	12	0	727.826634938163	1
39	410.328608434232	4.0	0	0	1	0	12	0	727.826634938163	1
40	425.993367323877	4.0	0	0	1	0	12	0	727.826634938163	0
41	409.430742983857	5.0	0	0	1	0	12	0	727.826634938163	0
42	460.605886281468	6.0	0	0	1	0	12	0	691.392391229917	0
43	560.188989035577	6.0	0	0	1	0	12	0	691.392391229917	0
44	378.486087509513	6.0	0	0	1	0	14	0	691.392391229917	0
45	516.831361986859	6.0	0	0	1	0	11	0	691.392391229917	0
46	557.155342162198	6.0	0	0	1	0	12	0	691.392391229917	0
47	631.282997954796	6.0	0	0	1	0	12	0	691.392391229917	0
48	501.677328837489	6.0	0	0	1	0	18	0	727.826634938163	1
49	466.248533790025	6.0	0	0	1	0	12	0	691.392391229917	0
50	594.667991916549	6.0	0	0	1	0	12	0	691.392391229917	0
51	619.020904331767	6.0	0	0	1	0	12	0	691.392391229917	0
52	422.517903579997	6.0	0	0	1	0	12	0	691.392391229917	0
53	514.338009258817	6.0	0	0	1	0	11	0	691.392391229917	0
54	512.766872215611	7.0	0	0	1	0	12	0	691.392391229917	0
55	456.266205420931	7.0	0	0	1	0	11	0	767.599094692976	1
56	380.388263378723	8.0	1	0	1	0	13	0	727.826634938163	0
57	421.344721387902	8.0	0	0	1	0	11	0	767.599094692976	0
58	486.501284763764	9.0	0	0	1	0	13	0	691.392391229917	0
59	453.357504553945	9.0	0	0	1	0	12	0	691.392391229917	0
60	498.219068060275	9.0	0	0	1	0	11	0	691.392391229917	0
61	514.807687171462	10.0	0	0	1	1	12	0	691.392391229917	0
62	565.065579807459	13.0	0	0	1	0	12	0	781.810357291219	0
63	626.714865963592	14.0	1	1	1	0	11	0	691.392391229917	0
64	457.134154158281	14.0	0	1	1	0	13	0	781.810357291219	0
65	510.499756960558	2.0	0	0	1	0	16	0	668.40638930927	0
66	494.235377715545	2.0	0	0	1	0	17	0	668.40638930927	0
67	365.266644239282	2.0	0	0	1	1	13	0	635.405739248921	0
68	541.173490674172	3.0	0	0	1	0	12	0	691.392391229917	0
69	455.36049792936	3.0	0	0	1	0	15	0	691.392391229917	0
70	422.517903579997	5.0	0	0	1	1	12	0	691.392391229917	0
71	398.31103066659	5.0	0	0	1	0	14	0	703.219213794897	0
72	395.120560563494	6.0	0	0	1	0	12	0	679.756323867598	0
73	503.716941803917	6.0	0	0	1	0	12	0	691.392391229917	1
74	427.462485792718	6.0	0	0	1	0	13	0	646.278785800597	1
75	600.91272658553	7.0	0	0	1	0	12	0	691.392391229917	0
76	565.065579807459	7.0	1	0	1	0	12	0	691.392391229917	0
77	540.204883338675	7.0	0	0	1	0	11	0	691.392391229917	0
78	558.474690429794	7.0	0	0	1	0	12	0	691.392391229917	0
79	575.637662232951	7.0	0	0	1	1	13	0	691.392391229917	1
80	439.680053114802	7.0	0	0	1	0	11	0	691.392391229917	1
81	353.773643278958	7.0	0	0	1	0	13	0	635.405739248921	1
82	488.376137298698	8.0	0	0	1	0	11	0	691.392391229917	0
83	480.908033418792	8.0	0	0	1	0	12	0	691.392391229917	0
84	535.286927844308	8.0	0	0	1	0	12	0	691.392391229917	0
85	408.529715955022	9.0	0	0	1	0	15	0	703.219213794897	0
86	385.53865385057	9.0	0	0	1	0	12	0	646.278785800597	0
87	528.310827853733	10.0	0	0	1	0	12	0	691.392391229917	0
88	548.67653911654	10.0	0	0	1	0	12	0	691.392391229917	0
89	588.423257247566	10.0	0	0	1	0	13	0	691.392391229917	0
90	583.034422772394	10.0	0	0	1	0	13	0	691.392391229917	0
91	455.36049792936	10.0	0	0	1	1	14	0	691.392391229917	0
92	459.986311593889	11.0	0	0	1	0	13	0	691.392391229917	0
93	594.667991916549	12.0	0	0	1	0	12	0	691.392391229917	0
94	473.481862461084	12.0	0	0	1	1	11	0	691.392391229917	0
95	584.081078168864	13.0	0	0	1	0	12	0	691.392391229917	0
96	504.241138890166	13.0	0	0	1	0	11	0	691.392391229917	0
97	451.694405556509	1.0	0	0	1	0	17	0	648.090960225876	0
98	522.558825103114	1.0	0	0	1	0	12	0	648.090960225876	0
99	422.842681154036	1.0	0	0	1	1	14	0	648.090960225876	0
100	515.308862586361	2.0	0	0	1	0	18	0	709.132625077388	0

Rows: 1-100 | Columns: 11

Let’s normalize the dataset to follow the Gaussian-Markov assumptions.

[10]:

africa.normalize(columns = africa.get_columns(exclude_columns = ["student_score"]))

[10]:

	123 student_score Float(22)	123 socio_eco_statut Numeric(49)	123 means_of_travel_CAR Numeric(66)	123 socio_eco_statut_14.000 Numeric(66)	123 repeated_grades_NEVER Numeric(65)	123 english_at_home_NEVER Numeric(65)	123 age Numeric(62)	123 country_Tanzania Numeric(65)	123 teacher_score Float(22)	123 source_of_lighting_CANDLE Numeric(65)	123 Numeric(65)
1	425.993367323877	-0.6232054442632663	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
2	534.329515370892	-0.03943601904258274	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
3	536.690743411639	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
4	569.392927563969	0.5443334061781009	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
5	542.037992351316	1.1281028313987844	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
6	573.771789981159	1.1281028313987844	4.180166793098136	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
7	589.279157441376	1.4199875440091263	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
8	496.740841813343	1.4199875440091263	4.180166793098136	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-2.25571926837901	-0.5195382107595631
9	535.805274812767	0.8362181187884427	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-1.98588881675302	-0.5195382107595631
10	420.509155247374	-1.20697486948395	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
11	504.298378016207	-1.20697486948395	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
12	450.768711398358	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
13	441.927245450751	-0.6232054442632663	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
14	469.987298066451	-0.6232054442632663	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
15	445.259642792635	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
16	551.071920864503	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
17	473.825234391116	-0.03943601904258274	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
18	544.095820873929	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
19	564.874824604798	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.446039075983578	-0.5195382107595631
20	386.940445160128	-1.20697486948395	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-1.98588881675302	-0.5195382107595631
21	458.501728934408	-0.6232054442632663	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-1.35671685022128	1.9247500524574985
22	460.360232184133	-0.03943601904258274	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.9834086341847834	-0.28509087397763944	-1.98588881675302	-0.5195382107595631
23	457.035551231015	-0.03943601904258274	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-1.35671685022128	-0.5195382107595631
24	504.282977573042	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-1.35671685022128	-0.5195382107595631
25	475.872247772718	0.8362181187884427	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	1.5814688812363171	-0.28509087397763944	-1.98588881675302	-0.5195382107595631
26	503.899980617811	-1.4988595820942916	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.9834086341847834	-0.28509087397763944	-1.83021740235342	1.9247500524574985
27	480.484906064866	-1.20697486948395	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.9834086341847834	-0.28509087397763944	-1.83021740235342	1.9247500524574985
28	516.744491629541	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.442147290623594	1.9247500524574985
29	394.65259093503	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	2.0669357515682547	-0.8107721069698178	-0.28509087397763944	-0.442147290623594	-0.5195382107595631
30	506.128325450387	-0.03943601904258274	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-0.442147290623594	1.9247500524574985
31	440.401203829463	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.442147290623594	-0.5195382107595631
32	453.010211603314	0.25244869356775906	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-0.442147290623594	-0.5195382107595631
33	498.219068060275	1.1281028313987844	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-0.442147290623594	1.9247500524574985
34	428.988211440412	-1.4988595820942916	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.272205996570688	-0.5195382107595631
35	532.255684949772	-1.4988595820942916	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.272205996570688	1.9247500524574985
36	392.664714363554	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	0.268752168467943	1.9247500524574985
37	415.95588691273	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.21271185991828412	-0.28509087397763944	-0.272205996570688	1.9247500524574985
38	479.525184773189	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.272205996570688	1.9247500524574985
39	410.328608434232	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.272205996570688	1.9247500524574985
40	425.993367323877	-0.9150901568736081	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.272205996570688	-0.5195382107595631
41	409.430742983857	-0.6232054442632663	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.272205996570688	-0.5195382107595631
42	460.605886281468	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
43	560.188989035577	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
44	378.486087509513	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	0.38534838713324965	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
45	516.831361986859	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-1.4088323540213517	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
46	557.155342162198	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
47	631.282997954796	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944	-0.7677599990761	-0.5195382107595631
48	501.677328837489	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	2.7775893753393848	-0.28509087397763944	-0.272205996570688	1.9247500524574985
49	466.248533790025	-0.3313207316529245	-0.23922040624412672	-0.17707300662955064	0.8056324835156974	-0.48379887843849295	-0.8107721069698178	-0.28509087397763944