gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.6 KiB
Average record size in memory	88.3 B

Variable types

Numeric	7
Categorical	2
DateTime	1

Dataset

Description	샘플 데이터
Author	아이렉스넷
URL	https://www.bigdata-environment.kr/user/data_market/detail.do?id=fcb27fb0-2df7-11ea-9c1b-71bfb969ab02

Alerts

`게이트웨이ID` has constant value ""	Constant
`ID` is highly overall correlated with `위도 값` and 2 other fields	High correlation
`위도 값` is highly overall correlated with `ID` and 1 other fields	High correlation
`속도` is highly overall correlated with `ID` and 1 other fields	High correlation
`노드ID` is highly overall correlated with `ID`	High correlation
`노드ID` is highly imbalanced (56.4%)	Imbalance
`ID` has unique values	Unique
`시간` has unique values	Unique
`진동 값(y)` has 6 (6.0%) zeros	Zeros
`속도` has 33 (33.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 13:03:59.796830
Analysis finished	2023-12-10 13:04:05.592199
Duration	5.8 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

ID
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61571607

Minimum	60307011
Maximum	62866002
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	60307011
5-th percentile	60307018
Q1	61286958
median	61478858
Q3	62534773
95-th percentile	62833822
Maximum	62866002
Range	2558991
Interquartile range (IQR)	1247815.5

Descriptive statistics

Standard deviation	842133.35
Coefficient of variation (CV)	0.0136773
Kurtosis	-1.0805872
Mean	61571607
Median Absolute Deviation (MAD)	1055906.5
Skewness	-0.084382967
Sum	6.1571607 × 10⁹
Variance	7.0918858 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60307011	1	1.0%
61753921	1	1.0%
62534770	1	1.0%
62534767	1	1.0%
62534766	1	1.0%
62534765	1	1.0%
62534764	1	1.0%
62534763	1	1.0%
61813298	1	1.0%
61813297	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60307011	1	1.0%
60307012	1	1.0%
60307013	1	1.0%
60307014	1	1.0%
60307015	1	1.0%
60307018	1	1.0%
60307029	1	1.0%
60307040	1	1.0%
60307051	1	1.0%
60307062	1	1.0%

Value	Count	Frequency (%)
62866002	1	1.0%
62866001	1	1.0%
62866000	1	1.0%
62865999	1	1.0%
62865998	1	1.0%
62832129	1	1.0%
62769109	1	1.0%
62769108	1	1.0%
62651694	1	1.0%
62597945	1	1.0%

게이트웨이ID
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

SERVER	100

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SERVER
2nd row	SERVER
3rd row	SERVER
4th row	SERVER
5th row	SERVER

Common Values

Value	Count	Frequency (%)
SERVER	100	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
server	100	100.0%

시간
Date

UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

Minimum	2019-01-01 10:04:46
Maximum	2019-01-23 09:09:34

Histogram

Histogram with fixed size bins (bins=50)

노드ID
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

IK1012	91
IK1032	9

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IK1012
2nd row	IK1012
3rd row	IK1012
4th row	IK1012
5th row	IK1012

Common Values

Value	Count	Frequency (%)
IK1012	91	91.0%
IK1032	9	9.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ik1012	91	91.0%
ik1032	9	9.0%

진동 값(x)
Real number (ℝ)

Distinct	71
Distinct (%)	71.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-0.011364746

Minimum	-0.074707031
Maximum	0.1105957
Zeros	0
Zeros (%)	0.0%
Negative	86
Negative (%)	86.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	-0.074707031
5-th percentile	-0.028076172
Q1	-0.018615723
median	-0.014038086
Q3	-0.0094604492
95-th percentile	0.020056152
Maximum	0.1105957
Range	0.18530273
Interquartile range (IQR)	0.0091552734

Descriptive statistics

Standard deviation	0.021401219
Coefficient of variation (CV)	-1.8831234
Kurtosis	13.049125
Mean	-0.011364746
Median Absolute Deviation (MAD)	0.0046386719
Skewness	2.3446016
Sum	-1.1364746
Variance	0.00045801218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.01416015625	6	6.0%
-0.012939453125	3	3.0%
-0.017333984375	3	3.0%
-0.013671875	3	3.0%
-0.014892578125	3	3.0%
-0.013916015625	3	3.0%
-0.019287109375	3	3.0%
-0.013427734375	3	3.0%
-0.011962890625	3	3.0%
-0.0166015625	3	3.0%
Other values (61)	67	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.07470703125	1	1.0%
-0.06640625	1	1.0%
-0.050048828125	1	1.0%
-0.041259765625	1	1.0%
-0.03271484375	1	1.0%
-0.02783203125	1	1.0%
-0.027587890625	2	2.0%
-0.027099609375	1	1.0%
-0.026611328125	1	1.0%
-0.025146484375	1	1.0%

Value	Count	Frequency (%)
0.110595703125	1	1.0%
0.068359375	1	1.0%
0.055419921875	1	1.0%
0.026123046875	1	1.0%
0.020751953125	1	1.0%
0.02001953125	1	1.0%
0.01123046875	1	1.0%
0.01025390625	1	1.0%
0.0078125	1	1.0%
0.0068359375	1	1.0%

진동 값(y)
Real number (ℝ)

ZEROS

Distinct	64
Distinct (%)	64.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0038867187

Minimum	-0.082763672
Maximum	0.10644531
Zeros	6
Zeros (%)	6.0%
Negative	24
Negative (%)	24.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	-0.082763672
5-th percentile	-0.0069335937
Q1	0
median	0.0032958984
Q3	0.0068969727
95-th percentile	0.017810059
Maximum	0.10644531
Range	0.18920898
Interquartile range (IQR)	0.0068969727

Descriptive statistics

Standard deviation	0.01626937
Coefficient of variation (CV)	4.1858882
Kurtosis	23.59573
Mean	0.0038867187
Median Absolute Deviation (MAD)	0.0035400391
Skewness	0.86006174
Sum	0.38867188
Variance	0.0002646924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	6	6.0%
0.00439453125	5	5.0%
0.001708984375	5	5.0%
-0.0009765625	4	4.0%
0.002685546875	3	3.0%
0.003662109375	3	3.0%
0.00244140625	3	3.0%
-0.002197265625	3	3.0%
0.004638671875	3	3.0%
0.003173828125	3	3.0%
Other values (54)	62	62.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.082763671875	1	1.0%
-0.0380859375	1	1.0%
-0.034423828125	1	1.0%
-0.0107421875	1	1.0%
-0.0087890625	1	1.0%
-0.0068359375	1	1.0%
-0.00537109375	1	1.0%
-0.00439453125	1	1.0%
-0.004150390625	1	1.0%
-0.00390625	1	1.0%

Value	Count	Frequency (%)
0.1064453125	1	1.0%
0.03759765625	1	1.0%
0.024169921875	1	1.0%
0.022705078125	1	1.0%
0.022216796875	1	1.0%
0.017578125	1	1.0%
0.0166015625	1	1.0%
0.014892578125	1	1.0%
0.0146484375	2	2.0%
0.014404296875	1	1.0%

진동 값(z)
Real number (ℝ)

Distinct	54
Distinct (%)	54.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.24880371

Minimum	0.22949219
Maximum	0.27026367
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0.22949219
5-th percentile	0.24189453
Q1	0.24560547
median	0.24841309
Q3	0.25195312
95-th percentile	0.25689697
Maximum	0.27026367
Range	0.040771484
Interquartile range (IQR)	0.0063476562

Descriptive statistics

Standard deviation	0.0057774738
Coefficient of variation (CV)	0.023221011
Kurtosis	3.4486426
Mean	0.24880371
Median Absolute Deviation (MAD)	0.0030517578
Skewness	0.10500024
Sum	24.880371
Variance	3.3379203 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.24951171875	5	5.0%
0.245361328125	5	5.0%
0.24560546875	5	5.0%
0.242919921875	4	4.0%
0.248046875	4	4.0%
0.250244140625	3	3.0%
0.2529296875	3	3.0%
0.2470703125	3	3.0%
0.247314453125	3	3.0%
0.252685546875	3	3.0%
Other values (44)	62	62.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2294921875	1	1.0%
0.229736328125	1	1.0%
0.236572265625	1	1.0%
0.23779296875	1	1.0%
0.240966796875	1	1.0%
0.241943359375	1	1.0%
0.242919921875	4	4.0%
0.2431640625	1	1.0%
0.24365234375	1	1.0%
0.244140625	2	2.0%

Value	Count	Frequency (%)
0.270263671875	1	1.0%
0.263916015625	1	1.0%
0.263427734375	1	1.0%
0.26025390625	1	1.0%
0.258056640625	1	1.0%
0.2568359375	1	1.0%
0.25634765625	1	1.0%
0.255859375	1	1.0%
0.255615234375	2	2.0%
0.2548828125	1	1.0%

위도 값
Real number (ℝ)

HIGH CORRELATION

Distinct	20
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.864065

Minimum	35.837625
Maximum	35.898918
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	35.837625
5-th percentile	35.83776
Q1	35.84041
median	35.873324
Q3	35.874995
95-th percentile	35.898918
Maximum	35.898918
Range	0.061293
Interquartile range (IQR)	0.034585

Descriptive statistics

Standard deviation	0.022062261
Coefficient of variation (CV)	0.00061516341
Kurtosis	-1.2695597
Mean	35.864065
Median Absolute Deviation (MAD)	0.025594
Skewness	0.28065029
Sum	3586.4065
Variance	0.00048674336
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
35.898918	18	18.0%
35.84041	16	16.0%
35.874995	13	13.0%
35.873552	8	8.0%
35.873324	7	7.0%
35.859626	7	7.0%
35.83776	5	5.0%
35.840143	5	5.0%
35.847437	3	3.0%
35.8471	3	3.0%
Other values (10)	15	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
35.837625	2	2.0%
35.83763	1	1.0%
35.83776	5	5.0%
35.83927	3	3.0%
35.840143	5	5.0%
35.840152	1	1.0%
35.84041	16	16.0%
35.844306	1	1.0%
35.8471	3	3.0%
35.847437	3	3.0%

Value	Count	Frequency (%)
35.898918	18	18.0%
35.893028	1	1.0%
35.874995	13	13.0%
35.873552	8	8.0%
35.87351	3	3.0%
35.873423	1	1.0%
35.873324	7	7.0%
35.861664	1	1.0%
35.859626	7	7.0%
35.848541	1	1.0%

경도 값
Real number (ℝ)

Distinct	20
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	128.59695

Minimum	128.54618
Maximum	128.61685
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	128.54618
5-th percentile	128.56844
Q1	128.59114
median	128.59681
Q3	128.61184
95-th percentile	128.61356
Maximum	128.61685
Range	0.07067
Interquartile range (IQR)	0.020695

Descriptive statistics

Standard deviation	0.014335667
Coefficient of variation (CV)	0.0001114775
Kurtosis	0.83414813
Mean	128.59695
Median Absolute Deviation (MAD)	0.00567
Skewness	-0.83351279
Sum	12859.695
Variance	0.00020551135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
128.611835	18	18.0%
128.59681	16	16.0%
128.59114	13	13.0%
128.592509	8	8.0%
128.592487	7	7.0%
128.568436	7	7.0%
128.613563	5	5.0%
128.5983	5	5.0%
128.614852	3	3.0%
128.613427	3	3.0%
Other values (10)	15	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
128.546179	1	1.0%
128.568436	7	7.0%
128.569971	1	1.0%
128.570607	3	3.0%
128.588553	1	1.0%
128.59114	13	13.0%
128.592487	7	7.0%
128.592509	8	8.0%
128.592753	1	1.0%
128.592775	3	3.0%

Value	Count	Frequency (%)
128.616849	1	1.0%
128.614852	3	3.0%
128.613583	1	1.0%
128.613563	5	5.0%
128.613504	2	2.0%
128.613427	3	3.0%
128.611835	18	18.0%
128.5983	5	5.0%
128.59681	16	16.0%
128.592916	1	1.0%

속도
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	12
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.52

Minimum	0
Maximum	43
Zeros	33
Zeros (%)	33.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	14
95-th percentile	36
Maximum	43
Range	43
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	14.002511
Coefficient of variation (CV)	1.3310371
Kurtosis	-0.2428318
Mean	10.52
Median Absolute Deviation (MAD)	3
Skewness	1.202641
Sum	1052
Variance	196.0703
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	33	33.0%
36	18	18.0%
3	16	16.0%
7	13	13.0%
14	7	7.0%
2	5	5.0%
10	3	3.0%
9	1	1.0%
35	1	1.0%
39	1	1.0%
Other values (2)	2	2.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	33.0%
1	1	1.0%
2	5	5.0%
3	16	16.0%
7	13	13.0%
9	1	1.0%
10	3	3.0%
14	7	7.0%
35	1	1.0%
36	18	18.0%

Value	Count	Frequency (%)
43	1	1.0%
39	1	1.0%
36	18	18.0%
35	1	1.0%
14	7	7.0%
10	3	3.0%
9	1	1.0%
7	13	13.0%
3	16	16.0%
2	5	5.0%

Phik (φk)
Auto

Heatmap
Table

	ID	시간	노드ID	진동 값(x)	진동 값(y)	진동 값(z)	위도 값	경도 값	속도
ID	1.000	1.000	1.000	0.334	0.226	0.000	0.945	0.769	0.897
시간	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
노드ID	1.000	1.000	1.000	0.524	0.431	0.000	0.457	0.392	0.332
진동 값(x)	0.334	1.000	0.524	1.000	0.788	0.516	0.166	0.306	0.000
진동 값(y)	0.226	1.000	0.431	0.788	1.000	0.570	0.081	0.301	0.000
진동 값(z)	0.000	1.000	0.000	0.516	0.570	1.000	0.275	0.306	0.325
위도 값	0.945	1.000	0.457	0.166	0.081	0.275	1.000	0.832	0.979
경도 값	0.769	1.000	0.392	0.306	0.301	0.306	0.832	1.000	0.781
속도	0.897	1.000	0.332	0.000	0.000	0.325	0.979	0.781	1.000

Heatmap
Table

	ID	진동 값(x)	진동 값(y)	진동 값(z)	위도 값	경도 값	속도	노드ID
ID	1.000	0.292	-0.145	0.067	-0.783	0.227	-0.505	0.979
진동 값(x)	0.292	1.000	-0.092	0.075	-0.266	0.136	-0.194	0.382
진동 값(y)	-0.145	-0.092	1.000	0.050	0.036	-0.060	-0.001	0.450
진동 값(z)	0.067	0.075	0.050	1.000	0.054	0.124	0.025	0.000
위도 값	-0.783	-0.266	0.036	0.054	1.000	-0.116	0.579	0.322
경도 값	0.227	0.136	-0.060	0.124	-0.116	1.000	0.015	0.460
속도	-0.505	-0.194	-0.001	0.025	0.579	0.015	1.000	0.233
노드ID	0.979	0.382	0.450	0.000	0.322	0.460	0.233	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	ID	게이트웨이ID	시간	노드ID	진동 값(x)	진동 값(y)	진동 값(z)	위도 값	경도 값	속도
0	60307011	SERVER	2019-01-01 10:04:46	IK1012	-0.020996	0.002197	0.24292	35.898918	128.611835	36
1	60307012	SERVER	2019-01-01 10:04:56	IK1012	-0.01709	0.002441	0.249512	35.898918	128.611835	36
2	60307013	SERVER	2019-01-01 10:05:06	IK1012	-0.012695	0.003662	0.249756	35.898918	128.611835	36
3	60307014	SERVER	2019-01-01 10:05:15	IK1012	-0.01416	0.002686	0.250732	35.898918	128.611835	36
4	60307015	SERVER	2019-01-01 10:05:25	IK1012	-0.01416	0.006104	0.24585	35.898918	128.611835	36
5	60307018	SERVER	2019-01-01 10:05:34	IK1012	-0.013672	0.003174	0.250488	35.898918	128.611835	36
6	60307029	SERVER	2019-01-01 10:05:45	IK1012	-0.014893	0.004639	0.248535	35.898918	128.611835	36
7	60307040	SERVER	2019-01-01 10:05:55	IK1012	-0.013916	0.004395	0.25	35.898918	128.611835	36
8	60307051	SERVER	2019-01-01 10:06:06	IK1012	-0.019287	0.003418	0.245605	35.898918	128.611835	36
9	60307062	SERVER	2019-01-01 10:06:15	IK1012	-0.018799	0.001465	0.248535	35.898918	128.611835	36

	ID	게이트웨이ID	시간	노드ID	진동 값(x)	진동 값(y)	진동 값(z)	위도 값	경도 값	속도
90	62597945	SERVER	2019-01-05 23:18:51	IK1012	-0.003906	0.008545	0.252197	35.873423	128.592753	1
91	62651694	SERVER	2019-01-14 03:50:46	IK1032	-0.010986	0.0	0.251465	35.844306	128.588553	43
92	62769108	SERVER	2019-01-17 13:56:12	IK1032	-0.04126	0.106445	0.245605	35.837625	128.613504	0
93	62769109	SERVER	2019-01-17 13:56:22	IK1032	0.05542	-0.082764	0.260254	35.837625	128.613504	0
94	62832129	SERVER	2019-01-23 00:15:58	IK1032	0.110596	-0.038086	0.25293	35.83763	128.613583	0
95	62865998	SERVER	2019-01-23 09:08:54	IK1032	-0.002441	0.01001	0.247314	35.83776	128.613563	2
96	62865999	SERVER	2019-01-23 09:09:04	IK1032	-0.009766	0.005615	0.252197	35.83776	128.613563	2
97	62866000	SERVER	2019-01-23 09:09:13	IK1032	-0.00708	-0.000977	0.247803	35.83776	128.613563	2
98	62866001	SERVER	2019-01-23 09:09:24	IK1032	-0.010498	0.004395	0.244141	35.83776	128.613563	2
99	62866002	SERVER	2019-01-23 09:09:34	IK1032	-0.007324	0.002686	0.241943	35.83776	128.613563	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample