547_no2

Dataset statistics

Number of variables	8
Number of observations	500
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	31.4 KiB
Average record size in memory	64.3 B

Variable types

NUM	8

Reproduction

Analysis started	2020-08-25 00:03:41.578884
Analysis finished	2020-08-25 00:03:51.391763
Duration	9.81 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

temperature_diff_2m_25m has 49 (9.8%) zeros Zeros

cars_per_hour
Real number (ℝ_≥0)

Distinct count	464
Unique (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	6.973342054367065
Minimum	4.127130031585693
Maximum	8.348540306091309
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	4.127130032
5-th percentile	4.812180042
Q1	6.175842404
median	7.425360203
Q3	7.793175101
95-th percentile	8.196201801
Maximum	8.348540306
Range	4.221410275
Interquartile range (IQR)	1.617332697

Descriptive statistics

Standard deviation	1.087166381
Coefficient of variation (CV)	0.1559032058
Kurtosis	-0.5827549183
Mean	6.973342054
Median Absolute Deviation (MAD)	0.5599648952
Skewness	-0.8173996438
Sum	3486.671027
Variance	1.181930741

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4.812180042	3	0.6%
6.549650192	2	0.4%
7.425360203	2	0.4%
7.236340046	2	0.4%
6.575079918	2	0.4%
5.666429996	2	0.4%
5.505330086	2	0.4%
5.099870205	2	0.4%
7.675549984	2	0.4%
7.82723999	2	0.4%
8.195890427	2	0.4%
7.995639801	2	0.4%
4.68212986	2	0.4%
7.748030186	2	0.4%
5.176149845	2	0.4%
5.111989975	2	0.4%
7.753190041	2	0.4%
7.712440014	2	0.4%
4.983610153	2	0.4%
6.530879974	2	0.4%
5.147490025	2	0.4%
5.509389877	2	0.4%
4.454349995	2	0.4%
7.648260117	2	0.4%
6.393589973	2	0.4%
Other values (439)	449	89.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.127130032	1	0.2%
4.317490101	1	0.2%
4.394450188	1	0.2%
4.454349995	2	0.4%
4.499810219	1	0.2%
4.532599926	1	0.2%
4.543290138	1	0.2%
4.553880215	1	0.2%
4.564350128	1	0.2%
4.584969997	1	0.2%

Value	Count	Frequency (%)
8.348540306	1	0.2%
8.346400261	1	0.2%
8.318989754	1	0.2%
8.316300392	1	0.2%
8.313850403	1	0.2%
8.310660362	1	0.2%
8.302510262	1	0.2%
8.270529747	1	0.2%
8.264619827	1	0.2%
8.262559891	1	0.2%

temperature_at_2m
Real number (ℝ)

Distinct count	223
Unique (%)	44.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.8473999881744385
Minimum	-18.600000381469727
Maximum	21.100000381469727
Zeros	3
Zeros (%)	0.6%
Memory size	4.0 KiB

Quantile statistics

Minimum	-18.60000038
5-th percentile	-9.600000381
Q1	-3.900000095
median	1.100000024
Q3	4.900000095
95-th percentile	11.31000018
Maximum	21.10000038
Range	39.70000076
Interquartile range (IQR)	8.800000191

Descriptive statistics

Standard deviation	6.524636009
Coefficient of variation (CV)	7.699594171
Kurtosis	0.3137769745
Mean	0.8473999882
Median Absolute Deviation (MAD)	4.5
Skewness	0.1388416772
Sum	423.6999941
Variance	42.57087505

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1.100000024	7	1.4%
-4.099999905	7	1.4%
-2.799999952	6	1.2%
-4.199999809	6	1.2%
6.400000095	6	1.2%
4.900000095	6	1.2%
-1.600000024	6	1.2%
2.099999905	6	1.2%
1.299999952	6	1.2%
6.699999809	5	1.0%
-5.099999905	5	1.0%
3.400000095	5	1.0%
0.3000000119	5	1.0%
3.599999905	5	1.0%
2.700000048	5	1.0%
2.200000048	5	1.0%
-5.599999905	5	1.0%
4.800000191	5	1.0%
1.799999952	5	1.0%
1.600000024	5	1.0%
-0.8999999762	4	0.8%
4.199999809	4	0.8%
2.599999905	4	0.8%
-6.400000095	4	0.8%
-2.099999905	4	0.8%
Other values (198)	369	73.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-18.60000038	1	0.2%
-16.20000076	1	0.2%
-14.69999981	1	0.2%
-14.30000019	1	0.2%
-13.80000019	3	0.6%
-13.60000038	2	0.4%
-13.5	1	0.2%
-13.39999962	1	0.2%
-12.89999962	1	0.2%
-12.69999981	1	0.2%

Value	Count	Frequency (%)
21.10000038	1	0.2%
20.79999924	1	0.2%
20.29999924	1	0.2%
19.60000038	1	0.2%
19.10000038	1	0.2%
18.10000038	1	0.2%
17.79999924	1	0.2%
16.79999924	1	0.2%
16.60000038	1	0.2%
16.10000038	2	0.4%

wind_speed
Real number (ℝ_≥0)

Distinct count	78
Unique (%)	15.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.0560000032186507
Minimum	0.30000001192092896
Maximum	9.899999618530273
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0.3000000119
5-th percentile	0.6949999899
Q1	1.675000042
median	2.799999952
Q3	4.199999809
95-th percentile	6.405000091
Maximum	9.899999619
Range	9.599999607
Interquartile range (IQR)	2.524999768

Descriptive statistics

Standard deviation	1.784172238
Coefficient of variation (CV)	0.5838259935
Kurtosis	0.6021474867
Mean	3.056000003
Median Absolute Deviation (MAD)	1.200000048
Skewness	0.8258422274
Sum	1528.000002
Variance	3.183270574

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1.299999952	16	3.2%
2.099999905	16	3.2%
2.900000095	15	3.0%
3.5	14	2.8%
1.600000024	14	2.8%
2.799999952	14	2.8%
4.199999809	14	2.8%
1.700000048	13	2.6%
0.8000000119	12	2.4%
1.5	12	2.4%
2.5	12	2.4%
2	11	2.2%
3	11	2.2%
2.599999905	11	2.2%
4.300000191	11	2.2%
3.900000095	10	2.0%
2.200000048	10	2.0%
1.100000024	10	2.0%
3.400000095	10	2.0%
0.6000000238	10	2.0%
3.099999905	9	1.8%
0.8999999762	9	1.8%
1.799999952	9	1.8%
3.799999952	9	1.8%
2.400000095	9	1.8%
Other values (53)	209	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.3000000119	2	0.4%
0.400000006	6	1.2%
0.5	7	1.4%
0.6000000238	10	2.0%
0.6999999881	4	0.8%
0.8000000119	12	2.4%
0.8999999762	9	1.8%
1	8	1.6%
1.100000024	10	2.0%
1.200000048	9	1.8%

Value	Count	Frequency (%)
9.899999619	1	0.2%
9.600000381	1	0.2%
9.300000191	1	0.2%
8.399999619	1	0.2%
8.300000191	1	0.2%
8.100000381	2	0.4%
7.800000191	1	0.2%
7.699999809	1	0.2%
7.5	2	0.4%
7.300000191	1	0.2%

temperature_diff_2m_25m
Real number (ℝ)

ZEROS

Distinct count	61
Unique (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.14940000182390212
Minimum	-5.400000095367432
Maximum	4.300000190734863
Zeros	49
Zeros (%)	9.8%
Memory size	4.0 KiB

Quantile statistics

Minimum	-5.400000095
5-th percentile	-1.510000002
Q1	-0.200000003
median	0
Q3	0.6000000238
95-th percentile	1.799999952
Maximum	4.300000191
Range	9.700000286
Interquartile range (IQR)	0.8000000268

Descriptive statistics

Standard deviation	1.065236639
Coefficient of variation (CV)	7.130097901
Kurtosis	4.634905178
Mean	0.1494000018
Median Absolute Deviation (MAD)	0.3000000119
Skewness	-0.8379516128
Sum	74.70000091
Variance	1.134729098

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
-0.1000000015	65	13.0%
0	49	9.8%
-0.200000003	42	8.4%
0.3000000119	31	6.2%
0.1000000015	27	5.4%
0.200000003	23	4.6%
0.6000000238	21	4.2%
0.400000006	19	3.8%
-0.3000000119	16	3.2%
0.5	13	2.6%
1	12	2.4%
0.6999999881	11	2.2%
1.100000024	11	2.2%
1.299999952	10	2.0%
-0.400000006	9	1.8%
1.700000048	8	1.6%
1.5	7	1.4%
-0.6000000238	7	1.4%
1.200000048	7	1.4%
-1.100000024	6	1.2%
-0.8999999762	6	1.2%
-2.099999905	6	1.2%
0.8000000119	6	1.2%
1.399999976	6	1.2%
-0.5	5	1.0%
Other values (36)	77	15.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-5.400000095	1	0.2%
-5.099999905	1	0.2%
-4.099999905	1	0.2%
-3.900000095	1	0.2%
-3.700000048	1	0.2%
-3.599999905	1	0.2%
-3.5	1	0.2%
-2.799999952	2	0.4%
-2.700000048	2	0.4%
-2.599999905	2	0.4%

Value	Count	Frequency (%)
4.300000191	1	0.2%
3.200000048	1	0.2%
3	2	0.4%
2.900000095	1	0.2%
2.799999952	1	0.2%
2.700000048	1	0.2%
2.599999905	1	0.2%
2.299999952	4	0.8%
2.200000048	3	0.6%
2.099999905	2	0.4%

wind_direction
Real number (ℝ_≥0)

Distinct count	373
Unique (%)	74.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	143.37039994049073
Minimum	2.0
Maximum	359.0
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	2
5-th percentile	42.06999855
Q1	72
median	97
Q3	220
95-th percentile	282.4349945
Maximum	359
Range	357
Interquartile range (IQR)	148

Descriptive statistics

Standard deviation	86.51021318
Coefficient of variation (CV)	0.6034035841
Kurtosis	-1.203404395
Mean	143.3703999
Median Absolute Deviation (MAD)	53.75
Skewness	0.4029950539
Sum	71685.19997
Variance	7484.016985

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
77	9	1.8%
73	8	1.6%
82	7	1.4%
80	6	1.2%
78	6	1.2%
79	6	1.2%
85	5	1.0%
76	5	1.0%
212	4	0.8%
215	4	0.8%
220	4	0.8%
194	3	0.6%
219	3	0.6%
56	3	0.6%
249	3	0.6%
81	3	0.6%
248	3	0.6%
229	3	0.6%
216	3	0.6%
86	3	0.6%
88	3	0.6%
74	3	0.6%
59	3	0.6%
67	3	0.6%
65	3	0.6%
Other values (348)	394	78.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	0.2%
3	1	0.2%
5.800000191	1	0.2%
8	1	0.2%
9	1	0.2%
9.300000191	1	0.2%
9.399999619	1	0.2%
10.5	1	0.2%
16	1	0.2%
17	1	0.2%

Value	Count	Frequency (%)
359	1	0.2%
354	1	0.2%
352	1	0.2%
338	1	0.2%
337	1	0.2%
336	1	0.2%
334	1	0.2%
325.6000061	1	0.2%
322	1	0.2%
317	1	0.2%

hour_of_day
Real number (ℝ_≥0)

Distinct count	24
Unique (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.382
Minimum	1.0
Maximum	24.0
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	12.5
Q3	18
95-th percentile	23
Maximum	24
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.802692795
Coefficient of variation (CV)	0.5494017763
Kurtosis	-1.207816404
Mean	12.382
Median Absolute Deviation (MAD)	5.5
Skewness	0.01072258922
Sum	6191
Variance	46.27662926

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
17	26	5.2%
5	26	5.2%
15	25	5.0%
6	25	5.0%
2	24	4.8%
14	23	4.6%
21	23	4.6%
10	22	4.4%
11	22	4.4%
9	22	4.4%
8	22	4.4%
16	22	4.4%
20	22	4.4%
22	21	4.2%
18	20	4.0%
4	20	4.0%
7	19	3.8%
23	18	3.6%
1	17	3.4%
13	17	3.4%
3	17	3.4%
19	17	3.4%
24	16	3.2%
12	14	2.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	17	3.4%
2	24	4.8%
3	17	3.4%
4	20	4.0%
5	26	5.2%
6	25	5.0%
7	19	3.8%
8	22	4.4%
9	22	4.4%
10	22	4.4%

Value	Count	Frequency (%)
24	16	3.2%
23	18	3.6%
22	21	4.2%
21	23	4.6%
20	22	4.4%
19	17	3.4%
18	20	4.0%
17	26	5.2%
16	22	4.4%
15	25	5.0%

day
Real number (ℝ_≥0)

Distinct count	287
Unique (%)	57.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	310.474
Minimum	32.0
Maximum	608.0
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	32
5-th percentile	48
Q1	118.75
median	212
Q3	513
95-th percentile	591.05
Maximum	608
Range	576
Interquartile range (IQR)	394.25

Descriptive statistics

Standard deviation	200.9777536
Coefficient of variation (CV)	0.6473255525
Kurtosis	-1.685810177
Mean	310.474
Median Absolute Deviation (MAD)	180
Skewness	0.06303856518
Sum	155237
Variance	40392.05744

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
576	5	1.0%
417	4	0.8%
128	4	0.8%
141	4	0.8%
174	4	0.8%
573	4	0.8%
520	4	0.8%
445	4	0.8%
33	4	0.8%
95	4	0.8%
529	4	0.8%
409	4	0.8%
196	4	0.8%
126	3	0.6%
400	3	0.6%
50	3	0.6%
582	3	0.6%
184	3	0.6%
91	3	0.6%
116	3	0.6%
101	3	0.6%
119	3	0.6%
406	3	0.6%
540	3	0.6%
191	3	0.6%
Other values (262)	411	82.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
32	2	0.4%
33	4	0.8%
34	3	0.6%
35	2	0.4%
36	2	0.4%
40	2	0.4%
41	1	0.2%
42	2	0.4%
43	2	0.4%
44	2	0.4%

Value	Count	Frequency (%)
608	1	0.2%
607	2	0.4%
605	3	0.6%
604	1	0.2%
603	2	0.4%
602	2	0.4%
601	1	0.2%
600	2	0.4%
599	1	0.2%
598	2	0.4%

target
Real number (ℝ_≥0)

Distinct count	385
Unique (%)	77.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.6983678576946257
Minimum	1.2237800359725952
Maximum	6.395090103149414
Zeros	0
Zeros (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	1.223780036
5-th percentile	2.415462005
Q1	3.213862479
median	3.848020077
Q3	4.216929913
95-th percentile	4.623990059
Maximum	6.395090103
Range	5.171310067
Interquartile range (IQR)	1.003067434

Descriptive statistics

Standard deviation	0.7505966217
Coefficient of variation (CV)	0.2029534785
Kurtosis	0.7673830733
Mean	3.698367858
Median Absolute Deviation (MAD)	0.4661297798
Skewness	-0.5509190525
Sum	1849.183929
Variance	0.5633952885

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3.813309908	4	0.8%
2.424799919	4	0.8%
2.95491004	3	0.6%
4.261270046	3	0.6%
2.734369993	3	0.6%
4.048299789	3	0.6%
3.716010094	3	0.6%
2.873559952	3	0.6%
3.912019968	3	0.6%
3.1738801	3	0.6%
3.795490026	3	0.6%
3.966510057	3	0.6%
3.815510035	3	0.6%
3.440419912	3	0.6%
3.484309912	3	0.6%
3.456320047	3	0.6%
3.194580078	3	0.6%
4.001860142	2	0.4%
3.811100006	2	0.4%
2.360850096	2	0.4%
4.141550064	2	0.4%
2.928519964	2	0.4%
4.297289848	2	0.4%
4.091010094	2	0.4%
3.169689894	2	0.4%
Other values (360)	431	86.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1.223780036	1	0.2%
1.280930042	1	0.2%
1.335000038	1	0.2%
1.360980034	1	0.2%
1.504080057	1	0.2%
1.547559977	1	0.2%
1.589239955	1	0.2%
1.629240036	1	0.2%
1.704749942	1	0.2%
1.722769976	1	0.2%

Value	Count	Frequency (%)
6.395090103	1	0.2%
5.781050205	1	0.2%
5.582369804	1	0.2%
5.547130108	1	0.2%
5.373889923	1	0.2%
5.329329967	1	0.2%
5.236440182	1	0.2%
5.130489826	1	0.2%
5.114999771	1	0.2%
5.112589836	1	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	cars_per_hour	temperature_at_2m	wind_speed	temperature_diff_2m_25m	wind_direction	hour_of_day	day	target
0	7.69120	9.2	4.8	-0.1	74.400002	20.0	600.0	3.71844
1	7.69894	6.4	3.5	-0.3	56.000000	14.0	196.0	3.10009
2	4.81218	-3.7	0.9	-0.1	281.299988	4.0	513.0	3.31419
3	6.95177	-7.2	1.7	1.2	74.000000	23.0	143.0	4.38826
4	7.51806	-1.3	2.6	-0.1	65.000000	11.0	115.0	4.34640
5	7.67183	2.6	1.6	0.3	224.199997	19.0	527.0	4.16044
6	5.52545	-7.9	1.6	0.3	211.899994	5.0	502.0	4.01277
7	4.68213	-4.1	3.8	-0.1	63.099998	4.0	453.0	2.15176
8	7.15618	-12.7	5.2	-0.1	64.500000	12.0	462.0	3.15700
9	4.74493	-1.6	3.0	0.4	58.299999	3.0	554.0	2.37955

Last rows

	cars_per_hour	temperature_at_2m	wind_speed	temperature_diff_2m_25m	wind_direction	hour_of_day	day	target
490	5.14749	-6.5	1.7	0.8	184.000000	5.0	154.0	4.31615
491	5.66643	6.7	2.4	-0.1	66.099998	5.0	592.0	3.33932
492	7.34923	-0.4	1.9	1.0	77.000000	21.0	72.0	3.96651
493	4.45435	-13.8	4.2	0.2	80.000000	4.0	95.0	3.86073
494	4.58497	1.8	2.3	0.1	59.000000	4.0	164.0	2.56495
495	7.68202	3.5	5.0	-1.0	78.000000	11.0	166.0	4.30946
496	6.52942	9.5	6.5	-0.8	210.000000	10.0	35.0	2.94444
497	7.75791	5.2	4.6	-0.8	214.000000	14.0	176.0	4.17439
498	5.78996	8.4	0.5	-2.6	108.500000	7.0	588.0	2.95491
499	8.16223	4.7	5.9	0.4	207.000000	17.0	128.0	4.03247

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows