Dataset statistics
Number of variables | 15 |
---|---|
Number of observations | 100 |
Missing cells | 100 |
Missing cells (%) | 6.7% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 12.8 KiB |
Average record size in memory | 131.3 B |
Variable types
Numeric | 4 |
---|---|
Categorical | 8 |
DateTime | 1 |
Unsupported | 1 |
Boolean | 1 |
Dataset
Description | Sample |
---|---|
Author | 부산정보산업진흥원 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=73d9fd04-2202-4a54-be66-9fa09dcb3dad |
ap_addr has constant value "" | Constant |
year has constant value "" | Constant |
month has constant value "" | Constant |
enc_yn has constant value "" | Constant |
weekofyear is highly overall correlated with idx and 4 other fields | High correlation |
in_time is highly overall correlated with idx and 6 other fields | High correlation |
distance is highly overall correlated with day and 4 other fields | High correlation |
hour is highly overall correlated with day and 4 other fields | High correlation |
mac_addr is highly overall correlated with idx and 6 other fields | High correlation |
idx is highly overall correlated with mac_addr and 2 other fields | High correlation |
day is highly overall correlated with week and 5 other fields | High correlation |
week is highly overall correlated with day and 5 other fields | High correlation |
manuufacturer has 100 (100.0%) missing values | Missing |
idx has unique values | Unique |
collect_date has unique values | Unique |
manuufacturer is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
week has 3 (3.0%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-10 09:39:26.618613 |
---|---|
Analysis finished | 2023-12-10 09:39:30.910002 |
Duration | 4.29 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
idx
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 81015050 |
Minimum | 81000001 |
---|---|
Maximum | 81500000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 81000001 |
---|---|
5-th percentile | 81000007 |
Q1 | 81000028 |
median | 81000054 |
Q3 | 81000078 |
95-th percentile | 81000098 |
Maximum | 81500000 |
Range | 499999 |
Interquartile range (IQR) | 50.5 |
Descriptive statistics
Standard deviation | 85714.286 |
---|---|
Coefficient of variation (CV) | 0.0010580045 |
Kurtosis | 29.897768 |
Mean | 81015050 |
Median Absolute Deviation (MAD) | 25.5 |
Skewness | 5.5946485 |
Sum | 8.101505 × 109 |
Variance | 7.3469388 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
81000001 | 1 | 1.0% |
81000065 | 1 | 1.0% |
81000075 | 1 | 1.0% |
81000074 | 1 | 1.0% |
81000073 | 1 | 1.0% |
81000072 | 1 | 1.0% |
81000071 | 1 | 1.0% |
81000070 | 1 | 1.0% |
81000069 | 1 | 1.0% |
81000068 | 1 | 1.0% |
Other values (90) | 90 |
Value | Count | Frequency (%) |
81000001 | 1 | |
81000003 | 1 | |
81000004 | 1 | |
81000005 | 1 | |
81000006 | 1 | |
81000007 | 1 | |
81000009 | 1 | |
81000010 | 1 | |
81000011 | 1 | |
81000012 | 1 |
Value | Count | Frequency (%) |
81500000 | 1 | |
81499999 | 1 | |
81499998 | 1 | |
81000100 | 1 | |
81000099 | 1 | |
81000098 | 1 | |
81000097 | 1 | |
81000096 | 1 | |
81000095 | 1 | |
81000094 | 1 |
ap_addr
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
78:A3:51:63:23:B4 |
---|
Length
Max length | 17 |
---|---|
Median length | 17 |
Mean length | 17 |
Min length | 17 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 78:A3:51:63:23:B4 |
---|---|
2nd row | 78:A3:51:63:23:B4 |
3rd row | 78:A3:51:63:23:B4 |
4th row | 78:A3:51:63:23:B4 |
5th row | 78:A3:51:63:23:B4 |
Common Values
Value | Count | Frequency (%) |
78:A3:51:63:23:B4 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
78:a3:51:63:23:b4 | 100 |
mac_addr
Categorical
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | |
---|---|
634B2D54A24BB6A8AD6CF209DFA2C866CB1B700C2B3579BDDE3CD81B409CFF56FAC7482D0050790B7471A72F59E1F5FF0DF7A03D0EFCA92F218FB63DF87BD36BD4AA01DC13FC4570F6AC19AA1A0D2319 | |
634B39013CF3F7EF384959A77D375AE032E99C04FC5D3EC11A46B3F4CE998F2F263934EEBFBA9D979E029BA26FE38A16FBC29FC5FA6685D9248CC22C0B5FC857D4AA01DC13FC4570F6AC19AA1A0D2319 | |
634B0F79BC58348E32625822FEFCAB9164A9BA1B9BE77CCC64BC9D9FA58EA7E7EE9C47282751AA20F5DE4BE6BFBEAFA5C6D783F2E3BBD3AA8FBFEB164CED9058D4AA01DC13FC4570F6AC19AA1A0D2319 | |
634E9959A764FE51712421EA0A13D80D3A10F9D13120A20167D5F4CC8E1963C76D00037DC937AE793E7A63E81806EABC6D0DC470799A4780A860A9EF097F0FCCD4AA01DC13FC4570F6AC19AA1A0D2319 | |
Other values (2) |
Length
Max length | 160 |
---|---|
Median length | 160 |
Mean length | 160 |
Min length | 160 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 |
---|---|
2nd row | 912B1272C504549E41A505EDB1B1BD566FF71B238F2E3E52F9614E5837F446A76E5218DA76076F33CC17AF59837F8F552A818623340520628CDEF4B8BAC0FE93D4AA01DC13FC4570F6AC19AA1A0D2319 |
3rd row | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 |
4th row | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 |
5th row | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 |
Common Values
Value | Count | Frequency (%) |
634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 19 | |
634B2D54A24BB6A8AD6CF209DFA2C866CB1B700C2B3579BDDE3CD81B409CFF56FAC7482D0050790B7471A72F59E1F5FF0DF7A03D0EFCA92F218FB63DF87BD36BD4AA01DC13FC4570F6AC19AA1A0D2319 | 18 | |
634B39013CF3F7EF384959A77D375AE032E99C04FC5D3EC11A46B3F4CE998F2F263934EEBFBA9D979E029BA26FE38A16FBC29FC5FA6685D9248CC22C0B5FC857D4AA01DC13FC4570F6AC19AA1A0D2319 | 18 | |
634B0F79BC58348E32625822FEFCAB9164A9BA1B9BE77CCC64BC9D9FA58EA7E7EE9C47282751AA20F5DE4BE6BFBEAFA5C6D783F2E3BBD3AA8FBFEB164CED9058D4AA01DC13FC4570F6AC19AA1A0D2319 | 16 | |
634E9959A764FE51712421EA0A13D80D3A10F9D13120A20167D5F4CC8E1963C76D00037DC937AE793E7A63E81806EABC6D0DC470799A4780A860A9EF097F0FCCD4AA01DC13FC4570F6AC19AA1A0D2319 | 15 | |
634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 11 | |
912B1272C504549E41A505EDB1B1BD566FF71B238F2E3E52F9614E5837F446A76E5218DA76076F33CC17AF59837F8F552A818623340520628CDEF4B8BAC0FE93D4AA01DC13FC4570F6AC19AA1A0D2319 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
634b058c3b7579977bddcbb7f8c4cef46d72aeefecddd6a385a7bfebcc91ab0a65fdaa88bcb6eb74d6996758594f08bc69d7492dd0dc1f54053b221c8e9cdb37d4aa01dc13fc4570f6ac19aa1a0d2319 | 19 | |
634b2d54a24bb6a8ad6cf209dfa2c866cb1b700c2b3579bdde3cd81b409cff56fac7482d0050790b7471a72f59e1f5ff0df7a03d0efca92f218fb63df87bd36bd4aa01dc13fc4570f6ac19aa1a0d2319 | 18 | |
634b39013cf3f7ef384959a77d375ae032e99c04fc5d3ec11a46b3f4ce998f2f263934eebfba9d979e029ba26fe38a16fbc29fc5fa6685d9248cc22c0b5fc857d4aa01dc13fc4570f6ac19aa1a0d2319 | 18 | |
634b0f79bc58348e32625822fefcab9164a9ba1b9be77ccc64bc9d9fa58ea7e7ee9c47282751aa20f5de4be6bfbeafa5c6d783f2e3bbd3aa8fbfeb164ced9058d4aa01dc13fc4570f6ac19aa1a0d2319 | 16 | |
634e9959a764fe51712421ea0a13d80d3a10f9d13120a20167d5f4cc8e1963c76d00037dc937ae793e7a63e81806eabc6d0dc470799a4780a860a9ef097f0fccd4aa01dc13fc4570f6ac19aa1a0d2319 | 15 | |
634eff2d9fabebb56cf8c7f37f35ac6059b701428003121c6d8c9b1f3dc42bd2e931c2110130e74f28df19d30a03cb5a488c19cf9fd3e01f717d857805f4e0c9d4aa01dc13fc4570f6ac19aa1a0d2319 | 11 | |
912b1272c504549e41a505edb1b1bd566ff71b238f2e3e52f9614e5837f446a76e5218da76076f33cc17af59837f8f552a818623340520628cdef4b8bac0fe93d4aa01dc13fc4570f6ac19aa1a0d2319 | 3 | 3.0% |
in_time
Categorical
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 7.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
2021-05-21 08:17:28.0 | |
---|---|
2021-05-19 08:51:59.0 | |
2021-05-29 08:02:26.0 | |
2021-05-18 05:28:51.0 | |
2021-05-18 09:00:46.0 | |
Other values (2) |
Length
Max length | 21 |
---|---|
Median length | 21 |
Mean length | 21 |
Min length | 21 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2021-05-21 08:17:28.0 |
---|---|
2nd row | 2021-05-31 02:44:55.0 |
3rd row | 2021-05-21 08:17:28.0 |
4th row | 2021-05-21 08:17:28.0 |
5th row | 2021-05-21 08:17:28.0 |
Common Values
Value | Count | Frequency (%) |
2021-05-21 08:17:28.0 | 19 | |
2021-05-19 08:51:59.0 | 18 | |
2021-05-29 08:02:26.0 | 18 | |
2021-05-18 05:28:51.0 | 16 | |
2021-05-18 09:00:46.0 | 15 | |
2021-05-20 02:02:02.0 | 11 | |
2021-05-31 02:44:55.0 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2021-05-18 | 31 | |
2021-05-21 | 19 | |
08:17:28.0 | 19 | |
2021-05-19 | 18 | |
08:51:59.0 | 18 | |
2021-05-29 | 18 | |
08:02:26.0 | 18 | |
05:28:51.0 | 16 | |
09:00:46.0 | 15 | |
2021-05-20 | 11 | 5.5% |
Other values (3) | 17 |
duration
Real number (ℝ)
Distinct | 58 |
---|---|
Distinct (%) | 58.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 38.97 |
Minimum | 2 |
---|---|
Maximum | 76 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 2 |
---|---|
5-th percentile | 11.9 |
Q1 | 26 |
median | 38.5 |
Q3 | 52.25 |
95-th percentile | 67.15 |
Maximum | 76 |
Range | 74 |
Interquartile range (IQR) | 26.25 |
Descriptive statistics
Standard deviation | 17.894446 |
---|---|
Coefficient of variation (CV) | 0.45918518 |
Kurtosis | -0.71084145 |
Mean | 38.97 |
Median Absolute Deviation (MAD) | 12.5 |
Skewness | 0.049701116 |
Sum | 3897 |
Variance | 320.21121 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
14 | 4 | 4.0% |
39 | 4 | 4.0% |
26 | 4 | 4.0% |
38 | 4 | 4.0% |
40 | 3 | 3.0% |
49 | 3 | 3.0% |
43 | 3 | 3.0% |
36 | 3 | 3.0% |
34 | 3 | 3.0% |
33 | 3 | 3.0% |
Other values (48) | 66 |
Value | Count | Frequency (%) |
2 | 1 | 1.0% |
4 | 1 | 1.0% |
7 | 1 | 1.0% |
9 | 1 | 1.0% |
10 | 1 | 1.0% |
12 | 1 | 1.0% |
13 | 2 | |
14 | 4 | |
15 | 2 | |
17 | 1 | 1.0% |
Value | Count | Frequency (%) |
76 | 1 | 1.0% |
75 | 1 | 1.0% |
73 | 1 | 1.0% |
71 | 1 | 1.0% |
70 | 1 | 1.0% |
67 | 1 | 1.0% |
66 | 3 | |
65 | 2 | |
62 | 1 | 1.0% |
61 | 2 |
distance
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
3 | |
---|---|
5 | |
0 | |
1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5 |
---|---|
2nd row | 0 |
3rd row | 5 |
4th row | 5 |
5th row | 5 |
Common Values
Value | Count | Frequency (%) |
3 | 34 | |
5 | 30 | |
0 | 21 | |
1 | 15 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
3 | 34 | |
5 | 30 | |
0 | 21 | |
1 | 15 |
collect_date
Date
UNIQUE
 
Distinct | 100 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
Minimum | 2021-05-18 05:28:55 |
---|---|
Maximum | 2021-05-31 02:45:33 |
year
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
2021 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2021 |
---|---|
2nd row | 2021 |
3rd row | 2021 |
4th row | 2021 |
5th row | 2021 |
Common Values
Value | Count | Frequency (%) |
2021 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2021 | 100 |
month
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
5 |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 5 |
---|---|
2nd row | 5 |
3rd row | 5 |
4th row | 5 |
5th row | 5 |
Common Values
Value | Count | Frequency (%) |
5 | 100 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
5 | 100 |
day
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 21.34 |
Minimum | 18 |
---|---|
Maximum | 31 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 18 |
---|---|
5-th percentile | 18 |
Q1 | 18 |
median | 20 |
Q3 | 21 |
95-th percentile | 29 |
Maximum | 31 |
Range | 13 |
Interquartile range (IQR) | 3 |
Descriptive statistics
Standard deviation | 4.2669034 |
---|---|
Coefficient of variation (CV) | 0.19994861 |
Kurtosis | -0.097331303 |
Mean | 21.34 |
Median Absolute Deviation (MAD) | 2 |
Skewness | 1.2447333 |
Sum | 2134 |
Variance | 18.206465 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
18 | 31 | |
21 | 19 | |
19 | 18 | |
29 | 18 | |
20 | 11 | 11.0% |
31 | 3 | 3.0% |
Value | Count | Frequency (%) |
18 | 31 | |
19 | 18 | |
20 | 11 | 11.0% |
21 | 19 | |
29 | 18 | |
31 | 3 | 3.0% |
Value | Count | Frequency (%) |
31 | 3 | 3.0% |
29 | 18 | |
21 | 19 | |
20 | 11 | 11.0% |
19 | 18 | |
18 | 31 |
hour
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
20 | |
---|---|
17 | |
21 | |
14 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20 |
---|---|
2nd row | 14 |
3rd row | 20 |
4th row | 20 |
5th row | 20 |
Common Values
Value | Count | Frequency (%) |
20 | 55 | |
17 | 16 | 16.0% |
21 | 15 | 15.0% |
14 | 14 | 14.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20 | 55 | |
17 | 16 | 16.0% |
21 | 15 | 15.0% |
14 | 14 | 14.0% |
week
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 6 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.66 |
Minimum | 0 |
---|---|
Maximum | 5 |
Zeros | 3 |
Zeros (%) | 3.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.0 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1 |
Q1 | 1 |
median | 2 |
Q3 | 4 |
95-th percentile | 5 |
Maximum | 5 |
Range | 5 |
Interquartile range (IQR) | 3 |
Descriptive statistics
Standard deviation | 1.5841386 |
---|---|
Coefficient of variation (CV) | 0.59554081 |
Kurtosis | -1.4058117 |
Mean | 2.66 |
Median Absolute Deviation (MAD) | 1 |
Skewness | 0.1901496 |
Sum | 266 |
Variance | 2.5094949 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
1 | 31 | |
4 | 19 | |
2 | 18 | |
5 | 18 | |
3 | 11 | 11.0% |
0 | 3 | 3.0% |
Value | Count | Frequency (%) |
0 | 3 | 3.0% |
1 | 31 | |
2 | 18 | |
3 | 11 | 11.0% |
4 | 19 | |
5 | 18 |
Value | Count | Frequency (%) |
5 | 18 | |
4 | 19 | |
3 | 11 | 11.0% |
2 | 18 | |
1 | 31 | |
0 | 3 | 3.0% |
weekofyear
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 3.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 932.0 B |
20 | |
---|---|
21 | |
22 | 3 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20 |
---|---|
2nd row | 22 |
3rd row | 20 |
4th row | 20 |
5th row | 20 |
Common Values
Value | Count | Frequency (%) |
20 | 79 | |
21 | 18 | 18.0% |
22 | 3 | 3.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20 | 79 | |
21 | 18 | 18.0% |
22 | 3 | 3.0% |
manuufacturer
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 100 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.0 KiB |
enc_yn
Boolean
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 1.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 232.0 B |
True |
---|
Value | Count | Frequency (%) |
True | 100 |
idx | mac_addr | in_time | duration | distance | collect_date | day | hour | week | weekofyear | |
---|---|---|---|---|---|---|---|---|---|---|
idx | 1.000 | 1.000 | 1.000 | 0.000 | 0.442 | 1.000 | 1.000 | 0.589 | 1.000 | 1.000 |
mac_addr | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
in_time | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
duration | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 |
distance | 0.442 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 0.736 | 0.945 | 0.954 | 0.495 |
collect_date | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
day | 1.000 | 1.000 | 1.000 | 0.000 | 0.736 | 1.000 | 1.000 | 0.732 | 1.000 | 1.000 |
hour | 0.589 | 1.000 | 1.000 | 0.000 | 0.945 | 1.000 | 0.732 | 1.000 | 0.917 | 0.401 |
week | 1.000 | 1.000 | 1.000 | 0.000 | 0.954 | 1.000 | 1.000 | 0.917 | 1.000 | 1.000 |
weekofyear | 1.000 | 1.000 | 1.000 | 0.000 | 0.495 | 1.000 | 1.000 | 0.401 | 1.000 | 1.000 |
weekofyear | in_time | distance | hour | mac_addr | |
---|---|---|---|---|---|
weekofyear | 1.000 | 0.979 | 0.491 | 0.390 | 0.979 |
in_time | 0.979 | 1.000 | 0.984 | 0.984 | 1.000 |
distance | 0.491 | 0.984 | 1.000 | 0.686 | 0.984 |
hour | 0.390 | 0.984 | 0.686 | 1.000 | 0.984 |
mac_addr | 0.979 | 1.000 | 0.984 | 0.984 | 1.000 |
idx | duration | day | week | mac_addr | in_time | distance | hour | weekofyear | |
---|---|---|---|---|---|---|---|---|---|
idx | 1.000 | 0.019 | 0.017 | -0.163 | 0.974 | 0.974 | 0.295 | 0.402 | 0.995 |
duration | 0.019 | 1.000 | 0.102 | 0.142 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
day | 0.017 | 0.102 | 1.000 | 0.816 | 0.989 | 0.989 | 0.675 | 0.670 | 0.990 |
week | -0.163 | 0.142 | 0.816 | 1.000 | 0.995 | 0.995 | 0.851 | 0.797 | 0.984 |
mac_addr | 0.974 | 0.000 | 0.989 | 0.995 | 1.000 | 1.000 | 0.984 | 0.984 | 0.979 |
in_time | 0.974 | 0.000 | 0.989 | 0.995 | 1.000 | 1.000 | 0.984 | 0.984 | 0.979 |
distance | 0.295 | 0.000 | 0.675 | 0.851 | 0.984 | 0.984 | 1.000 | 0.686 | 0.491 |
hour | 0.402 | 0.000 | 0.670 | 0.797 | 0.984 | 0.984 | 0.686 | 1.000 | 0.390 |
weekofyear | 0.995 | 0.000 | 0.990 | 0.984 | 0.979 | 0.979 | 0.491 | 0.390 | 1.000 |
idx | ap_addr | mac_addr | in_time | duration | distance | collect_date | year | month | day | hour | week | weekofyear | manuufacturer | enc_yn | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 81000001 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 14 | 5 | 2021-05-21 08:17:42.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
1 | 81499998 | 78:A3:51:63:23:B4 | 912B1272C504549E41A505EDB1B1BD566FF71B238F2E3E52F9614E5837F446A76E5218DA76076F33CC17AF59837F8F552A818623340520628CDEF4B8BAC0FE93D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-31 02:44:55.0 | 27 | 0 | 2021-05-31 02:45:22.0 | 2021 | 5 | 31 | 14 | 0 | 22 | <NA> | Y |
2 | 81000003 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 26 | 5 | 2021-05-21 08:17:54.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
3 | 81000004 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 27 | 5 | 2021-05-21 08:17:55.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
4 | 81000005 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 31 | 5 | 2021-05-21 08:17:59.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
5 | 81000006 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 33 | 5 | 2021-05-21 08:18:01.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
6 | 81000007 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 34 | 5 | 2021-05-21 08:18:02.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
7 | 81499999 | 78:A3:51:63:23:B4 | 912B1272C504549E41A505EDB1B1BD566FF71B238F2E3E52F9614E5837F446A76E5218DA76076F33CC17AF59837F8F552A818623340520628CDEF4B8BAC0FE93D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-31 02:44:55.0 | 36 | 0 | 2021-05-31 02:45:31.0 | 2021 | 5 | 31 | 14 | 0 | 22 | <NA> | Y |
8 | 81000009 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 39 | 5 | 2021-05-21 08:18:07.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
9 | 81000010 | 78:A3:51:63:23:B4 | 634B058C3B7579977BDDCBB7F8C4CEF46D72AEEFECDDD6A385A7BFEBCC91AB0A65FDAA88BCB6EB74D6996758594F08BC69D7492DD0DC1F54053B221C8E9CDB37D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-21 08:17:28.0 | 43 | 5 | 2021-05-21 08:18:11.0 | 2021 | 5 | 21 | 20 | 4 | 20 | <NA> | Y |
idx | ap_addr | mac_addr | in_time | duration | distance | collect_date | year | month | day | hour | week | weekofyear | manuufacturer | enc_yn | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
90 | 81000091 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 23 | 5 | 2021-05-20 02:02:25.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
91 | 81000092 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 26 | 5 | 2021-05-20 02:02:28.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
92 | 81000093 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 28 | 5 | 2021-05-20 02:02:30.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
93 | 81000094 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 33 | 5 | 2021-05-20 02:02:35.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
94 | 81000095 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 34 | 5 | 2021-05-20 02:02:36.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
95 | 81000096 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 38 | 5 | 2021-05-20 02:02:40.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
96 | 81000097 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 39 | 5 | 2021-05-20 02:02:41.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
97 | 81000098 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 40 | 5 | 2021-05-20 02:02:42.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
98 | 81000099 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 50 | 5 | 2021-05-20 02:02:52.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |
99 | 81000100 | 78:A3:51:63:23:B4 | 634EFF2D9FABEBB56CF8C7F37F35AC6059B701428003121C6D8C9B1F3DC42BD2E931C2110130E74F28DF19D30A03CB5A488C19CF9FD3E01F717D857805F4E0C9D4AA01DC13FC4570F6AC19AA1A0D2319 | 2021-05-20 02:02:02.0 | 52 | 5 | 2021-05-20 02:02:54.0 | 2021 | 5 | 20 | 14 | 3 | 20 | <NA> | Y |