Overview

Dataset statistics

Number of variables6
Number of observations200
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.9 KiB
Average record size in memory50.7 B

Variable types

Categorical3
DateTime2
Text1

Dataset

DescriptionSample
Author(재)인천테크노파크
URLhttps://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=ICTBITIPACPRC0000001

Alerts

충격발생건수 has constant value ""Constant
시설물ID is highly overall correlated with 충격레벨High correlation
충격레벨 is highly overall correlated with 시설물IDHigh correlation
충격발생일시 has unique valuesUnique
등록일시 has unique valuesUnique
충격감지영상경로 has unique valuesUnique

Reproduction

Analysis started2023-12-10 06:37:31.205725
Analysis finished2023-12-10 06:37:32.168763
Duration0.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시설물ID
Categorical

HIGH CORRELATION 

Distinct27
Distinct (%)13.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
SDTRBIS00100133
40 
SDTRBIS00100044
32 
YJTRBIS00100001
23 
SDTRBIS00100114
15 
SDTRBIS00100121
15 
Other values (22)
75 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique11 ?
Unique (%)5.5%

Sample

1st rowSDTRBIS00100042
2nd rowYJTRBIS00100001
3rd rowSDTRBIS00100133
4th rowSDTRBIS00100131
5th rowSDTRBIS00100052

Common Values

ValueCountFrequency (%)
SDTRBIS00100133 40
20.0%
SDTRBIS00100044 32
16.0%
YJTRBIS00100001 23
11.5%
SDTRBIS00100114 15
 
7.5%
SDTRBIS00100121 15
 
7.5%
SDTRBIS00100131 13
 
6.5%
SDTRBIS00100110 11
 
5.5%
YJTRBIS00100003 9
 
4.5%
SDTRBIS00100166 7
 
3.5%
SDTRBIS00100113 4
 
2.0%
Other values (17) 31
15.5%

Length

2023-12-10T15:37:32.283891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
sdtrbis00100133 40
20.0%
sdtrbis00100044 32
16.0%
yjtrbis00100001 23
11.5%
sdtrbis00100114 15
 
7.5%
sdtrbis00100121 15
 
7.5%
sdtrbis00100131 13
 
6.5%
sdtrbis00100110 11
 
5.5%
yjtrbis00100003 9
 
4.5%
sdtrbis00100166 7
 
3.5%
sdtrbis00100113 4
 
2.0%
Other values (17) 31
15.5%

충격발생일시
Date

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2019-12-11 15:01:02
Maximum2019-12-12 14:45:06
2023-12-10T15:37:32.471299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:37:32.724152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등록일시
Date

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
Minimum2019-12-11 06:01:57
Maximum2019-12-12 14:34:53
2023-12-10T15:37:32.927337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:37:33.157884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

충격감지영상경로
Text

UNIQUE 

Distinct200
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
2023-12-10T15:37:33.506886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length34
Mean length34
Min length34

Characters and Unicode

Total characters6800
Distinct characters21
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique200 ?
Unique (%)100.0%

Sample

1st rowShock/1200526_1_20191211151048.avi
2nd rowShock/1202282_1_20191212114049.avi
3rd rowShock/1200481_1_20191212120057.avi
4th rowShock/1202523_1_20191212153527.avi
5th rowShock/1201997_1_20191212002816.avi
ValueCountFrequency (%)
shock/1200526_1_20191211151048.avi 1
 
0.5%
shock/1200481_1_20191212080502.avi 1
 
0.5%
shock/1202523_1_20191212161121.avi 1
 
0.5%
shock/1202280_1_20191211153657.avi 1
 
0.5%
shock/1202523_1_20191212223806.avi 1
 
0.5%
shock/1200755_1_20191212140300.avi 1
 
0.5%
shock/1202286_1_20191211201001.avi 1
 
0.5%
shock/1202282_1_20191212132848.avi 1
 
0.5%
shock/1200755_1_20191212133312.avi 1
 
0.5%
shock/1200481_1_20191212142142.avi 1
 
0.5%
Other values (190) 190
95.0%
2023-12-10T15:37:34.136699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1374
20.2%
2 1150
16.9%
0 666
 
9.8%
_ 400
 
5.9%
9 252
 
3.7%
5 250
 
3.7%
S 200
 
2.9%
a 200
 
2.9%
o 200
 
2.9%
c 200
 
2.9%
Other values (11) 1908
28.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4400
64.7%
Lowercase Letter 1400
 
20.6%
Connector Punctuation 400
 
5.9%
Other Punctuation 400
 
5.9%
Uppercase Letter 200
 
2.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1374
31.2%
2 1150
26.1%
0 666
15.1%
9 252
 
5.7%
5 250
 
5.7%
3 163
 
3.7%
4 160
 
3.6%
8 154
 
3.5%
7 143
 
3.2%
6 88
 
2.0%
Lowercase Letter
ValueCountFrequency (%)
a 200
14.3%
o 200
14.3%
c 200
14.3%
k 200
14.3%
h 200
14.3%
i 200
14.3%
v 200
14.3%
Other Punctuation
ValueCountFrequency (%)
/ 200
50.0%
. 200
50.0%
Connector Punctuation
ValueCountFrequency (%)
_ 400
100.0%
Uppercase Letter
ValueCountFrequency (%)
S 200
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5200
76.5%
Latin 1600
 
23.5%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1374
26.4%
2 1150
22.1%
0 666
12.8%
_ 400
 
7.7%
9 252
 
4.8%
5 250
 
4.8%
/ 200
 
3.8%
. 200
 
3.8%
3 163
 
3.1%
4 160
 
3.1%
Other values (3) 385
 
7.4%
Latin
ValueCountFrequency (%)
S 200
12.5%
a 200
12.5%
o 200
12.5%
c 200
12.5%
k 200
12.5%
h 200
12.5%
i 200
12.5%
v 200
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6800
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1374
20.2%
2 1150
16.9%
0 666
 
9.8%
_ 400
 
5.9%
9 252
 
3.7%
5 250
 
3.7%
S 200
 
2.9%
a 200
 
2.9%
o 200
 
2.9%
c 200
 
2.9%
Other values (11) 1908
28.1%

충격발생건수
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
1
200 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
1 200
100.0%

Length

2023-12-10T15:37:34.353204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:37:34.509570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 200
100.0%

충격레벨
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size1.7 KiB
51
109 
0
91 

Length

Max length2
Median length2
Mean length1.545
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row51
2nd row51
3rd row0
4th row0
5th row0

Common Values

ValueCountFrequency (%)
51 109
54.5%
0 91
45.5%

Length

2023-12-10T15:37:34.691349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:37:34.877867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
51 109
54.5%
0 91
45.5%

Correlations

2023-12-10T15:37:34.985925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설물ID충격레벨
시설물ID1.0001.000
충격레벨1.0001.000
2023-12-10T15:37:35.130745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설물ID충격레벨
시설물ID1.0000.935
충격레벨0.9351.000
2023-12-10T15:37:35.374709image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시설물ID충격레벨
시설물ID1.0000.935
충격레벨0.9351.000

Missing values

2023-12-10T15:37:31.869465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:37:32.094704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

시설물ID충격발생일시등록일시충격감지영상경로충격발생건수충격레벨
0SDTRBIS001000422019-12-11 15:10:482019-12-11 06:11:39Shock/1200526_1_20191211151048.avi151
1YJTRBIS001000012019-12-12 11:40:492019-12-12 02:41:45Shock/1202282_1_20191212114049.avi151
2SDTRBIS001001332019-12-12 03:00:582019-12-12 03:00:57Shock/1200481_1_20191212120057.avi10
3SDTRBIS001001312019-12-12 06:35:282019-12-12 05:45:20Shock/1202523_1_20191212153527.avi10
4SDTRBIS001000522019-12-11 15:28:172019-12-11 15:28:19Shock/1201997_1_20191212002816.avi10
5SDTRBIS001001142019-12-12 02:17:402019-12-11 17:18:32Shock/1202286_1_20191212021740.avi151
6SDTRBIS001001212019-12-12 12:05:282019-12-12 12:08:07Shock/1202507_1_20191212210526.avi10
7SDTRBIS001000442019-12-11 16:23:392019-12-11 07:24:30Shock/1200755_1_20191211162339.avi151
8YJTRBIS001000032019-12-12 06:35:522019-12-11 21:37:07Shock/1202284_1_20191212063552.avi151
9YJTRBIS001000012019-12-12 08:48:112019-12-11 23:49:42Shock/1202282_1_20191212084811.avi151
시설물ID충격발생일시등록일시충격감지영상경로충격발생건수충격레벨
190SDTRBIS001001052019-12-12 06:43:582019-12-11 21:44:49Shock/1202272_1_20191212064358.avi151
191SDTRBIS001001332019-12-12 03:51:282019-12-12 03:51:27Shock/1200481_1_20191212125127.avi10
192SDTRBIS001001332019-12-12 09:51:002019-12-12 09:50:59Shock/1200481_1_20191212185059.avi10
193SDTRBIS001001352019-12-11 15:05:492019-12-11 15:07:11Shock/1202600_1_20191212000548.avi10
194SDTRBIS001001332019-12-12 04:24:192019-12-12 04:24:18Shock/1200481_1_20191212132418.avi10
195SDTRBIS001000442019-12-12 14:27:522019-12-12 05:29:05Shock/1200755_1_20191212142752.avi151
196SDTRBIS001001332019-12-12 09:29:142019-12-12 09:29:13Shock/1200481_1_20191212182913.avi10
197YJTRBIS001000012019-12-12 08:19:562019-12-11 23:21:36Shock/1202282_1_20191212081956.avi151
198SDTRBIS001001312019-12-12 11:57:342019-12-12 11:07:27Shock/1202523_1_20191212205733.avi10
199SDTRBIS001001332019-12-12 12:21:352019-12-12 12:21:34Shock/1200481_1_20191212212134.avi10