{"cells": [{"cell_type": "markdown", "metadata": {"deletable": true, "editable": true}, "source": ["# Evaluation Python ann\u00e9e 2016-2017 - solution\n", "\n", "Le r\u00e9pertoire [data](https://github.com/sdpython/actuariat_python/tree/master/_doc/notebooks/examen/data) contient deux fichiers csv simul\u00e9s al\u00e9atoirement dont il faudra se servir pour r\u00e9pondre aux 10 questions qui suivent. Chaque question vaut deux points. Le travail est \u00e0 rendre pour le lundi 20 f\u00e9vrier sous la forme d'un notebook envoy\u00e9 en pi\u00e8ce jointe d'un mail."]}, {"cell_type": "code", "execution_count": 1, "metadata": {"collapsed": true, "deletable": true, "editable": true}, "outputs": [], "source": ["%matplotlib inline"]}, {"cell_type": "code", "execution_count": 2, "metadata": {"collapsed": false, "deletable": true, "editable": true}, "outputs": [{"data": {"text/html": ["
\n", ""], "text/plain": ["\n", " | age | \n", "gender | \n", "idc | \n", "name | \n", "
---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "Cendrillon | \n", "
1 | \n", "41 | \n", "0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "Cendrillon | \n", "
2 | \n", "46 | \n", "1 | \n", "304895f0-f686-4b0e-8854-a705bb5a6982 | \n", "Balthazar | \n", "
3 | \n", "42 | \n", "1 | \n", "3f0d31d2-0ef4-4e7e-b876-07d10225cc8c | \n", "Balthazar | \n", "
4 | \n", "41 | \n", "1 | \n", "f29273f4-a76c-4158-b5f5-b3e5a080a0c7 | \n", "Balthazar | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "
---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "
1 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "a65f721a-de11-4a01-be71-b26e2da3ac00 | \n", "65.0 | \n", "
2 | \n", "2016-12-07 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "644b1236-b9ee-4ef5-8ca7-d1adadb547c8 | \n", "75.0 | \n", "
3 | \n", "2016-12-17 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "aff6ac9e-5dd0-434e-9888-f724f6d40969 | \n", "80.0 | \n", "
4 | \n", "2017-01-07 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "9ca87507-aa95-49a9-88b3-86ec9fbc44d6 | \n", "80.0 | \n", "
\n", " | price | \n", "
---|---|
idc | \n", "\n", " |
003b0195-2acb-4f46-b7fa-28cf266a8f60 | \n", "80.0 | \n", "
009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "80.0 | \n", "
00a213c2-1174-4359-8a67-fe710ec1b439 | \n", "70.0 | \n", "
00e42818-aade-4758-a5f6-c78a6f235ea5 | \n", "70.0 | \n", "
0153b785-9acd-4d28-aad1-62f8bf2faea3 | \n", "75.0 | \n", "
\n", " | age | \n", "gender | \n", "idc | \n", "name | \n", "price | \n", "
---|---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "Cendrillon | \n", "70.000000 | \n", "
1 | \n", "41 | \n", "0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "Cendrillon | \n", "78.333333 | \n", "
2 | \n", "46 | \n", "1 | \n", "304895f0-f686-4b0e-8854-a705bb5a6982 | \n", "Balthazar | \n", "75.000000 | \n", "
3 | \n", "42 | \n", "1 | \n", "3f0d31d2-0ef4-4e7e-b876-07d10225cc8c | \n", "Balthazar | \n", "95.000000 | \n", "
4 | \n", "41 | \n", "1 | \n", "f29273f4-a76c-4158-b5f5-b3e5a080a0c7 | \n", "Balthazar | \n", "90.000000 | \n", "
Dep. Variable: | price | R-squared: | 0.579 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.579 | \n", "
Method: | Least Squares | F-statistic: | 686.6 | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 3.25e-188 | \n", "
Time: | 13:20:20 | Log-Likelihood: | -3149.8 | \n", "
No. Observations: | 1000 | AIC: | 6306. | \n", "
Df Residuals: | 997 | BIC: | 6320. | \n", "
Df Model: | 2 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
Intercept | 61.0506 | 0.640 | 95.432 | 0.000 | 59.795 | 62.306 | \n", "
age | 0.5244 | 0.015 | 35.302 | 0.000 | 0.495 | 0.554 | \n", "
gender | -4.3637 | 0.358 | -12.194 | 0.000 | -5.066 | -3.662 | \n", "
Omnibus: | 300.096 | Durbin-Watson: | 1.999 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 719.506 | \n", "
Skew: | 1.618 | Prob(JB): | 5.77e-157 | \n", "
Kurtosis: | 5.608 | Cond. No. | 151. | \n", "
Dep. Variable: | price | R-squared: | 0.579 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.579 | \n", "
Method: | Least Squares | F-statistic: | 686.6 | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 3.25e-188 | \n", "
Time: | 13:21:49 | Log-Likelihood: | -3149.8 | \n", "
No. Observations: | 1000 | AIC: | 6306. | \n", "
Df Residuals: | 997 | BIC: | 6320. | \n", "
Df Model: | 2 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
age | 0.5244 | 0.015 | 35.302 | 0.000 | 0.495 | 0.554 | \n", "
gender | -4.3637 | 0.358 | -12.194 | 0.000 | -5.066 | -3.662 | \n", "
cst | 61.0506 | 0.640 | 95.432 | 0.000 | 59.795 | 62.306 | \n", "
Omnibus: | 300.096 | Durbin-Watson: | 1.999 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 719.506 | \n", "
Skew: | 1.618 | Prob(JB): | 5.77e-157 | \n", "
Kurtosis: | 5.608 | Cond. No. | 151. | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "
---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "
1 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "a65f721a-de11-4a01-be71-b26e2da3ac00 | \n", "65.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "
2 | \n", "2016-12-07 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "644b1236-b9ee-4ef5-8ca7-d1adadb547c8 | \n", "75.0 | \n", "2016-12-07 19:47:45.068274 | \n", "2 | \n", "
3 | \n", "2016-12-17 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "aff6ac9e-5dd0-434e-9888-f724f6d40969 | \n", "80.0 | \n", "2016-12-17 19:47:45.068274 | \n", "5 | \n", "
4 | \n", "2017-01-07 19:47:45.068274 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "9ca87507-aa95-49a9-88b3-86ec9fbc44d6 | \n", "80.0 | \n", "2017-01-07 19:47:45.068274 | \n", "5 | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "constant | \n", "jour | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "
1 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "a65f721a-de11-4a01-be71-b26e2da3ac00 | \n", "65.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "constant | \n", "jour | \n", "jouri | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "
1 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "a65f721a-de11-4a01-be71-b26e2da3ac00 | \n", "65.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "constant | \n", "jour | \n", "jouri | \n", "diff | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "-26.0 | \n", "
1 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "a65f721a-de11-4a01-be71-b26e2da3ac00 | \n", "65.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "0.0 | \n", "
\n", " | idc | \n", "date | \n", "j365 | \n", "
---|---|---|---|
0 | \n", "003b0195-2acb-4f46-b7fa-28cf266a8f60 | \n", "2016-12-02 19:47:45.068274 | \n", "365 | \n", "
1 | \n", "009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "2016-11-26 19:47:45.068274 | \n", "365 | \n", "
\n", " | idc | \n", "jouri | \n", "date | \n", "j365 | \n", "
---|---|---|---|---|
0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "14 | \n", "2016-12-02 19:47:45.068274 | \n", "365.0 | \n", "
1 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "14 | \n", "2016-12-02 19:47:45.068274 | \n", "365.0 | \n", "
2 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "19 | \n", "2016-12-07 19:47:45.068274 | \n", "365.0 | \n", "
3 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "29 | \n", "2016-12-17 19:47:45.068274 | \n", "NaN | \n", "
4 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "50 | \n", "2017-01-07 19:47:45.068274 | \n", "NaN | \n", "
\n", " | idc | \n", "jouri | \n", "date | \n", "j365 | \n", "delay | \n", "
---|---|---|---|---|---|
0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "14 | \n", "2016-12-02 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
1 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "14 | \n", "2016-12-02 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
2 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "19 | \n", "2016-12-07 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
3 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "29 | \n", "2016-12-17 19:47:45.068274 | \n", "NaN | \n", "29.0 | \n", "
4 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "50 | \n", "2017-01-07 19:47:45.068274 | \n", "NaN | \n", "50.0 | \n", "
5 | \n", "304895f0-f686-4b0e-8854-a705bb5a6982 | \n", "1 | \n", "2016-11-19 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
6 | \n", "3f0d31d2-0ef4-4e7e-b876-07d10225cc8c | \n", "30 | \n", "2016-12-18 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
7 | \n", "f29273f4-a76c-4158-b5f5-b3e5a080a0c7 | \n", "2 | \n", "2016-11-20 19:47:45.068274 | \n", "365.0 | \n", "365.0 | \n", "
\n", " | delay | \n", "delay1 | \n", "
---|---|---|
0 | \n", "365.0 | \n", "0.002732 | \n", "
1 | \n", "365.0 | \n", "0.002732 | \n", "
2 | \n", "365.0 | \n", "0.002732 | \n", "
3 | \n", "29.0 | \n", "0.033333 | \n", "
4 | \n", "50.0 | \n", "0.019608 | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "constant | \n", "jour | \n", "jouri | \n", "diff | \n", "
---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "003b0195-2acb-4f46-b7fa-28cf266a8f60 | \n", "6d65b2b5-f34d-4440-8442-679175554db4 | \n", "80.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "365.0 | \n", "
1 | \n", "2016-11-26 19:47:45.068274 | \n", "009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "065474ed-6ba3-4ee1-aa83-b89e97d5a2aa | \n", "80.0 | \n", "2016-11-26 19:47:45.068274 | \n", "5 | \n", "2016-11-18 19:47:45.068274 | \n", "8 days | \n", "8 | \n", "365.0 | \n", "
2 | \n", "2016-12-20 19:47:45.068274 | \n", "009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "38a02a6a-8c04-4630-aaa6-2077077a9f87 | \n", "80.0 | \n", "2016-12-20 19:47:45.068274 | \n", "1 | \n", "2016-11-18 19:47:45.068274 | \n", "32 days | \n", "32 | \n", "24.0 | \n", "
3 | \n", "2017-01-12 19:47:45.068274 | \n", "009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "f4cf0df4-0b6a-4b0f-93c7-d12499026fab | \n", "80.0 | \n", "2017-01-12 19:47:45.068274 | \n", "3 | \n", "2016-11-18 19:47:45.068274 | \n", "55 days | \n", "55 | \n", "23.0 | \n", "
4 | \n", "2016-12-02 19:47:45.068274 | \n", "00a213c2-1174-4359-8a67-fe710ec1b439 | \n", "c1b3381b-9663-429d-a8fb-3b24c20a125b | \n", "70.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "365.0 | \n", "
\n", " | age | \n", "gender | \n", "delay | \n", "delay1 | \n", "weekday | \n", "price | \n", "
---|---|---|---|---|---|---|
age | \n", "1.000000 | \n", "0.030852 | \n", "-0.010694 | \n", "-0.023011 | \n", "0.032413 | \n", "0.614708 | \n", "
gender | \n", "0.030852 | \n", "1.000000 | \n", "0.008700 | \n", "-0.026779 | \n", "-0.000064 | \n", "-0.198835 | \n", "
delay | \n", "-0.010694 | \n", "0.008700 | \n", "1.000000 | \n", "-0.616038 | \n", "0.039766 | \n", "0.049796 | \n", "
delay1 | \n", "-0.023011 | \n", "-0.026779 | \n", "-0.616038 | \n", "1.000000 | \n", "0.025400 | \n", "-0.054954 | \n", "
weekday | \n", "0.032413 | \n", "-0.000064 | \n", "0.039766 | \n", "0.025400 | \n", "1.000000 | \n", "0.448584 | \n", "
price | \n", "0.614708 | \n", "-0.198835 | \n", "0.049796 | \n", "-0.054954 | \n", "0.448584 | \n", "1.000000 | \n", "
Dep. Variable: | price | R-squared: | 0.612 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.612 | \n", "
Method: | Least Squares | F-statistic: | 800.0 | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 0.00 | \n", "
Time: | 13:24:17 | Log-Likelihood: | -8257.2 | \n", "
No. Observations: | 2537 | AIC: | 1.653e+04 | \n", "
Df Residuals: | 2531 | BIC: | 1.656e+04 | \n", "
Df Model: | 5 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
Intercept | 55.4146 | 0.545 | 101.618 | 0.000 | 54.345 | 56.484 | \n", "
age | 0.5081 | 0.010 | 48.918 | 0.000 | 0.488 | 0.528 | \n", "
gender | -4.4125 | 0.250 | -17.683 | 0.000 | -4.902 | -3.923 | \n", "
delay | 0.0005 | 0.001 | 0.562 | 0.574 | -0.001 | 0.002 | \n", "
delay1 | -16.0797 | 4.842 | -3.321 | 0.001 | -25.575 | -6.585 | \n", "
weekday | 2.1216 | 0.061 | 34.623 | 0.000 | 2.001 | 2.242 | \n", "
Omnibus: | 55.147 | Durbin-Watson: | 1.969 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 57.558 | \n", "
Skew: | 0.358 | Prob(JB): | 3.17e-13 | \n", "
Kurtosis: | 2.823 | Cond. No. | 9.20e+03 | \n", "
\n", " | age | \n", "gender | \n", "idc | \n", "name | \n", "price | \n", "pred_moy | \n", "
---|---|---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "Cendrillon | \n", "70.000000 | \n", "80.453648 | \n", "
1 | \n", "41 | \n", "0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "Cendrillon | \n", "78.333333 | \n", "82.551278 | \n", "
2 | \n", "46 | \n", "1 | \n", "304895f0-f686-4b0e-8854-a705bb5a6982 | \n", "Balthazar | \n", "75.000000 | \n", "80.809575 | \n", "
3 | \n", "42 | \n", "1 | \n", "3f0d31d2-0ef4-4e7e-b876-07d10225cc8c | \n", "Balthazar | \n", "95.000000 | \n", "78.711946 | \n", "
4 | \n", "41 | \n", "1 | \n", "f29273f4-a76c-4158-b5f5-b3e5a080a0c7 | \n", "Balthazar | \n", "90.000000 | \n", "78.187538 | \n", "
\n", " | age | \n", "gender | \n", "delay | \n", "delay1 | \n", "weekday | \n", "price | \n", "idc | \n", "predc | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "4 | \n", "75.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "82.855082 | \n", "
1 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "4 | \n", "65.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "82.855082 | \n", "
2 | \n", "41 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "2 | \n", "75.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "80.644421 | \n", "
3 | \n", "41 | \n", "0 | \n", "29.0 | \n", "0.033333 | \n", "5 | \n", "80.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "86.334615 | \n", "
4 | \n", "41 | \n", "0 | \n", "50.0 | \n", "0.019608 | \n", "5 | \n", "80.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "86.566717 | \n", "
\n", " | predc | \n", "price | \n", "
---|---|---|
idc | \n", "\n", " | \n", " |
003b0195-2acb-4f46-b7fa-28cf266a8f60 | \n", "85.048055 | \n", "80.0 | \n", "
009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "83.945104 | \n", "80.0 | \n", "
00a213c2-1174-4359-8a67-fe710ec1b439 | \n", "72.345309 | \n", "70.0 | \n", "
00e42818-aade-4758-a5f6-c78a6f235ea5 | \n", "65.277461 | \n", "70.0 | \n", "
0153b785-9acd-4d28-aad1-62f8bf2faea3 | \n", "79.298313 | \n", "75.0 | \n", "
\n", " | index | \n", "age | \n", "gender | \n", "idc | \n", "name | \n", "price | \n", "pred_moy | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "18 | \n", "1 | \n", "6423a722-4769-4a7c-8d1d-266538c2a07a | \n", "Balthazar | \n", "60.0 | \n", "66.12617 | \n", "
\n", " | index | \n", "predc | \n", "price | \n", "
---|---|---|---|
0 | \n", "0 | \n", "64.54544 | \n", "60.0 | \n", "
\n", " | lu | \n", "ma | \n", "me | \n", "je | \n", "ve | \n", "sa | \n", "di | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
2 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "
3 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
4 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "
\n", " | date | \n", "idc | \n", "idr | \n", "price | \n", "date2 | \n", "weekday | \n", "constant | \n", "jour | \n", "jouri | \n", "diff | \n", "... | \n", "delay1 | \n", "age | \n", "gender | \n", "name | \n", "ma | \n", "me | \n", "je | \n", "ve | \n", "sa | \n", "di | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "2016-12-02 19:47:45.068274 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "b7db0ac9-86a1-46f9-98ac-f1f8eb54072d | \n", "75.0 | \n", "2016-12-02 19:47:45.068274 | \n", "4 | \n", "2016-11-18 19:47:45.068274 | \n", "14 days | \n", "14 | \n", "-26.0 | \n", "... | \n", "0.002732 | \n", "37 | \n", "0 | \n", "Cendrillon | \n", "0 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "
1 rows \u00d7 22 columns
\n", "Dep. Variable: | price | R-squared: | 0.918 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.917 | \n", "
Method: | Least Squares | F-statistic: | 2812. | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 0.00 | \n", "
Time: | 13:50:22 | Log-Likelihood: | -6293.7 | \n", "
No. Observations: | 2537 | AIC: | 1.261e+04 | \n", "
Df Residuals: | 2526 | BIC: | 1.267e+04 | \n", "
Df Model: | 10 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
Intercept | 59.0371 | 0.272 | 217.342 | 0.000 | 58.504 | 59.570 | \n", "
age | 0.5005 | 0.005 | 104.318 | 0.000 | 0.491 | 0.510 | \n", "
gender | -4.0722 | 0.115 | -35.321 | 0.000 | -4.298 | -3.846 | \n", "
delay | 0.0003 | 0.000 | 0.661 | 0.509 | -0.001 | 0.001 | \n", "
delay1 | -20.7385 | 2.236 | -9.275 | 0.000 | -25.123 | -16.354 | \n", "
ma | -0.0840 | 0.208 | -0.405 | 0.686 | -0.491 | 0.323 | \n", "
me | 0.3003 | 0.216 | 1.392 | 0.164 | -0.123 | 0.723 | \n", "
je | 0.1607 | 0.219 | 0.735 | 0.463 | -0.268 | 0.590 | \n", "
ve | -0.1748 | 0.212 | -0.825 | 0.409 | -0.590 | 0.240 | \n", "
sa | 0.1849 | 0.210 | 0.879 | 0.379 | -0.227 | 0.597 | \n", "
di | 20.0978 | 0.211 | 95.203 | 0.000 | 19.684 | 20.512 | \n", "
Omnibus: | 257.849 | Durbin-Watson: | 2.034 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 484.437 | \n", "
Skew: | -0.672 | Prob(JB): | 6.40e-106 | \n", "
Kurtosis: | 4.666 | Cond. No. | 9.20e+03 | \n", "
\n", " | age | \n", "gender | \n", "delay | \n", "delay1 | \n", "price | \n", "idc | \n", "di | \n", "predc | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "75.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "0 | \n", "77.664596 | \n", "
1 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "65.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "0 | \n", "77.664596 | \n", "
2 | \n", "41 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "75.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "0 | \n", "79.668165 | \n", "
3 | \n", "41 | \n", "0 | \n", "29.0 | \n", "0.033333 | \n", "80.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "0 | \n", "78.934710 | \n", "
4 | \n", "41 | \n", "0 | \n", "50.0 | \n", "0.019608 | \n", "80.0 | \n", "f44b004b-b01e-4835-b86d-1a42846c6d93 | \n", "0 | \n", "79.225084 | \n", "
\n", " | predc | \n", "price | \n", "
---|---|---|
idc | \n", "\n", " | \n", " |
003b0195-2acb-4f46-b7fa-28cf266a8f60 | \n", "80.103904 | \n", "80.0 | \n", "
009e689c-51a1-4cef-99ca-a4ba364eba8d | \n", "80.812446 | \n", "80.0 | \n", "
00a213c2-1174-4359-8a67-fe710ec1b439 | \n", "67.581598 | \n", "70.0 | \n", "
00e42818-aade-4758-a5f6-c78a6f235ea5 | \n", "66.890947 | \n", "70.0 | \n", "
0153b785-9acd-4d28-aad1-62f8bf2faea3 | \n", "74.158351 | \n", "75.0 | \n", "
\n", " | weekday | \n", "col_weekday_0 | \n", "col_weekday_1 | \n", "col_weekday_2 | \n", "col_weekday_3 | \n", "col_weekday_4 | \n", "col_weekday_5 | \n", "col_weekday_6 | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "4 | \n", "1.0 | \n", "0.188982 | \n", "-3.273268e-01 | \n", "-0.408248 | \n", "0.080582 | \n", "0.545545 | \n", "0.493464 | \n", "
1 | \n", "4 | \n", "1.0 | \n", "0.188982 | \n", "-3.273268e-01 | \n", "-0.408248 | \n", "0.080582 | \n", "0.545545 | \n", "0.493464 | \n", "
2 | \n", "2 | \n", "1.0 | \n", "-0.188982 | \n", "-3.273268e-01 | \n", "0.408248 | \n", "0.080582 | \n", "-0.545545 | \n", "0.493464 | \n", "
3 | \n", "5 | \n", "1.0 | \n", "0.377964 | \n", "5.551115e-17 | \n", "-0.408248 | \n", "-0.564076 | \n", "-0.436436 | \n", "-0.197386 | \n", "
4 | \n", "5 | \n", "1.0 | \n", "0.377964 | \n", "5.551115e-17 | \n", "-0.408248 | \n", "-0.564076 | \n", "-0.436436 | \n", "-0.197386 | \n", "
\n", " | weekday | \n", "price | \n", "
---|---|---|
0 | \n", "0 | \n", "76.112532 | \n", "
1 | \n", "1 | \n", "76.195373 | \n", "
2 | \n", "2 | \n", "77.047478 | \n", "
3 | \n", "3 | \n", "76.677116 | \n", "
4 | \n", "4 | \n", "76.049724 | \n", "
5 | \n", "5 | \n", "76.630728 | \n", "
6 | \n", "6 | \n", "97.078804 | \n", "
\n", " | age | \n", "gender | \n", "delay | \n", "delay1 | \n", "price | \n", "idc | \n", "weekday | \n", "price_label | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "75.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "4 | \n", "76.049724 | \n", "
1 | \n", "37 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "65.0 | \n", "4ba0b473-f8ca-4466-a65b-40e9b8ba5029 | \n", "4 | \n", "76.049724 | \n", "
2 | \n", "57 | \n", "1 | \n", "365.0 | \n", "0.002732 | \n", "85.0 | \n", "7ffb8a8b-a829-41f1-9572-2985ee9ba05e | \n", "4 | \n", "76.049724 | \n", "
3 | \n", "30 | \n", "0 | \n", "365.0 | \n", "0.002732 | \n", "75.0 | \n", "0153b785-9acd-4d28-aad1-62f8bf2faea3 | \n", "4 | \n", "76.049724 | \n", "
4 | \n", "28 | \n", "1 | \n", "28.0 | \n", "0.034483 | \n", "70.0 | \n", "47e415f0-f4e9-40c5-a59d-adc4c0621c8a | \n", "4 | \n", "76.049724 | \n", "
Dep. Variable: | price | R-squared: | 0.612 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.612 | \n", "
Method: | Least Squares | F-statistic: | 800.0 | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 0.00 | \n", "
Time: | 18:57:20 | Log-Likelihood: | -8257.2 | \n", "
No. Observations: | 2537 | AIC: | 1.653e+04 | \n", "
Df Residuals: | 2531 | BIC: | 1.656e+04 | \n", "
Df Model: | 5 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
Intercept | 55.4146 | 0.545 | 101.618 | 0.000 | 54.345 | 56.484 | \n", "
age | 0.5081 | 0.010 | 48.918 | 0.000 | 0.488 | 0.528 | \n", "
gender | -4.4125 | 0.250 | -17.683 | 0.000 | -4.902 | -3.923 | \n", "
delay | 0.0005 | 0.001 | 0.562 | 0.574 | -0.001 | 0.002 | \n", "
delay1 | -16.0797 | 4.842 | -3.321 | 0.001 | -25.575 | -6.585 | \n", "
weekday | 2.1216 | 0.061 | 34.623 | 0.000 | 2.001 | 2.242 | \n", "
Omnibus: | 55.147 | Durbin-Watson: | 0.442 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 57.558 | \n", "
Skew: | 0.358 | Prob(JB): | 3.17e-13 | \n", "
Kurtosis: | 2.823 | Cond. No. | 9.20e+03 | \n", "
Dep. Variable: | price | R-squared: | 0.917 | \n", "
---|---|---|---|
Model: | OLS | Adj. R-squared: | 0.917 | \n", "
Method: | Least Squares | F-statistic: | 5611. | \n", "
Date: | Sun, 12 Mar 2017 | Prob (F-statistic): | 0.00 | \n", "
Time: | 18:58:01 | Log-Likelihood: | -6298.8 | \n", "
No. Observations: | 2537 | AIC: | 1.261e+04 | \n", "
Df Residuals: | 2531 | BIC: | 1.264e+04 | \n", "
Df Model: | 5 | \n", " | |
Covariance Type: | nonrobust | \n", " |
coef | std err | t | P>|t| | [0.025 | 0.975] | \n", "|
---|---|---|---|---|---|---|
Intercept | -14.9859 | 0.664 | -22.576 | 0.000 | -16.288 | -13.684 | \n", "
age | 0.5000 | 0.005 | 104.173 | 0.000 | 0.491 | 0.509 | \n", "
gender | -4.0767 | 0.115 | -35.344 | 0.000 | -4.303 | -3.851 | \n", "
delay | 0.0003 | 0.000 | 0.601 | 0.548 | -0.001 | 0.001 | \n", "
delay1 | -20.8060 | 2.237 | -9.303 | 0.000 | -25.192 | -16.420 | \n", "
price_label | 0.9696 | 0.008 | 122.209 | 0.000 | 0.954 | 0.985 | \n", "
Omnibus: | 249.245 | Durbin-Watson: | 2.035 | \n", "
---|---|---|---|
Prob(Omnibus): | 0.000 | Jarque-Bera (JB): | 459.156 | \n", "
Skew: | -0.660 | Prob(JB): | 1.98e-100 | \n", "
Kurtosis: | 4.613 | Cond. No. | 9.47e+03 | \n", "