-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path분석.txt
84 lines (68 loc) · 4.92 KB
/
분석.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
선형회귀분석 Linear_regression
mse = 136.87282811741787
Lasso 모델
polynomial_regression 다항 회귀분석
2차
mse = 100.9114134622955
4차
mse = 102.64407250818077
windspeed 이상치 제거 값 > 0값 제거하지 않고 이상치 제거
count 10659.000000
mean 12.292752
std 7.441015
min 0.000000
25% 7.001500
50% 11.001400
75% 16.997900
max 31.000900
Name: windspeed, dtype: float64
위 값에서 0값 제거
count 9346.000000
mean 14.019735
std 6.239691
min 6.003200
25% 8.998100
50% 12.998000
75% 19.001200
max 31.000900
Name: windspeed, dtype: float64
windspeed 이상치 제거 값 > 0값 전부 삭제후 이상치 제거
count 9426.000000
mean 14.180802
std 6.452468
min 6.003200
25% 8.998100
50% 12.998000
75% 19.001200
max 32.997500
Name: windspeed, dtype: float64
windspeed 이상치 제거 X
count 10886.000000
mean 12.799395
std 8.164537
min 0.000000
25% 7.001500
50% 12.998000
75% 16.997900
max 56.996900
Name: windspeed, dtype: float64
기본 값
season holiday workingday weather temp atemp humidity windspeed casual registered count year month hour dayofweek
count 10886.000000 10886.000000 10886.000000 10886.000000 10886.00000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000 10886.000000
mean 2.506614 0.028569 0.680875 1.418427 20.23086 23.655084 61.886460 12.799395 36.021955 155.552177 191.574132 2011.501929 6.521495 11.541613 3.013963
std 1.116174 0.166599 0.466159 0.633839 7.79159 8.474601 19.245033 8.164537 49.960477 151.039033 181.144454 0.500019 3.444373 6.915838 2.004585
min 1.000000 0.000000 0.000000 1.000000 0.82000 0.760000 0.000000 0.000000 0.000000 0.000000 1.000000 2011.000000 1.000000 0.000000 0.000000
25% 2.000000 0.000000 0.000000 1.000000 13.94000 16.665000 47.000000 7.001500 4.000000 36.000000 42.000000 2011.000000 4.000000 6.000000 1.000000
50% 3.000000 0.000000 1.000000 1.000000 20.50000 24.240000 62.000000 12.998000 17.000000 118.000000 145.000000 2012.000000 7.000000 12.000000 3.000000
75% 4.000000 0.000000 1.000000 2.000000 26.24000 31.060000 77.000000 16.997900 49.000000 222.000000 284.000000 2012.000000 10.000000 18.000000 5.000000
max 4.000000 1.000000 1.000000 4.000000 41.00000 45.455000 100.000000 56.996900 367.000000 886.000000 977.000000 2012.000000 12.000000 23.000000 6.000000
반복문 실행 후
season holiday workingday weather temp atemp humidity windspeed casual registered count year month hour dayofweek
count 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000 9426.000000
mean 2.489285 0.028326 0.680246 1.424358 20.328101 23.687485 61.260980 14.180802 36.872693 158.864099 195.736792 2011.506153 6.468810 11.732230 3.014853
std 1.110042 0.165911 0.466406 0.638015 7.781531 8.554989 18.985517 6.452468 50.180503 151.707547 181.859503 0.499989 3.424321 6.869563 2.007940
min 1.000000 0.000000 0.000000 1.000000 0.820000 0.760000 0.000000 6.003200 0.000000 0.000000 1.000000 2011.000000 1.000000 0.000000 0.000000
25% 2.000000 0.000000 0.000000 1.000000 13.940000 16.665000 46.000000 8.998100 4.000000 40.000000 47.000000 2011.000000 4.000000 6.000000 1.000000
50% 2.000000 0.000000 1.000000 1.000000 20.500000 24.240000 61.000000 12.998000 18.000000 122.000000 150.000000 2012.000000 6.000000 12.000000 3.000000
75% 3.000000 0.000000 1.000000 2.000000 26.240000 31.060000 77.000000 19.001200 50.000000 227.000000 289.000000 2012.000000 9.000000 18.000000 5.000000
max 4.000000 1.000000 1.000000 4.000000 41.000000 45.455000 100.000000 32.997500 362.000000 886.000000 977.000000 2012.000000 12.000000 23.000000 6.000000