Overview

Dataset statistics

Number of variables7
Number of observations547
Missing cells1094
Missing cells (%)28.6%
Duplicate rows1
Duplicate rows (%)0.2%
Total size in memory33.9 KiB
Average record size in memory63.5 B

Variable types

Text1
Categorical2
Numeric1
DateTime1
Unsupported2

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-20462/S/1/datasetView.do

Alerts

주차여부 has constant value ""Constant
Dataset has 1 (0.2%) duplicate rowsDuplicates
레이더센서상태 has 547 (100.0%) missing valuesMissing
등록일시 has 547 (100.0%) missing valuesMissing
레이더센서상태 is an unsupported type, check if it needs cleaning or further analysisUnsupported
등록일시 is an unsupported type, check if it needs cleaning or further analysisUnsupported
시리얼 has 21 (3.8%) zerosZeros

Reproduction

Analysis started2023-12-11 09:01:14.150633
Analysis finished2023-12-11 09:01:14.650259
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Text

Distinct79
Distinct (%)14.4%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2023-12-11T18:01:14.837405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

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

Unique

Unique2 ?
Unique (%)0.4%

Sample

1st row88571dfffe0e7a7c
2nd row88571dfffe0e7d39
3rd row88571dfffe0e7c8f
4th row88571dfffe0e7af2
5th row88571dfffe0e7b33
ValueCountFrequency (%)
88571dfffe0e7b7e 11
 
2.0%
88571dfffe0e7ab7 10
 
1.8%
88571dfffe0e7ab2 10
 
1.8%
88571dfffe0e7aeb 9
 
1.6%
88571dfffe0e7af2 9
 
1.6%
88571dfffe0e7b53 9
 
1.6%
88571dfffe0e7b7c 9
 
1.6%
88571dfffe0e7c33 9
 
1.6%
88571dfffe0e7a8f 8
 
1.5%
88571dfffe0e7cd1 8
 
1.5%
Other values (69) 455
83.2%
2023-12-11T18:01:15.251861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
f 1734
19.8%
8 1196
13.7%
7 1173
13.4%
e 1134
13.0%
d 689
 
7.9%
0 635
 
7.3%
5 618
 
7.1%
1 612
 
7.0%
b 240
 
2.7%
a 216
 
2.5%
Other values (6) 505
 
5.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4582
52.4%
Lowercase Letter 4170
47.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 1196
26.1%
7 1173
25.6%
0 635
13.9%
5 618
13.5%
1 612
13.4%
2 103
 
2.2%
3 100
 
2.2%
6 66
 
1.4%
4 56
 
1.2%
9 23
 
0.5%
Lowercase Letter
ValueCountFrequency (%)
f 1734
41.6%
e 1134
27.2%
d 689
 
16.5%
b 240
 
5.8%
a 216
 
5.2%
c 157
 
3.8%

Most occurring scripts

ValueCountFrequency (%)
Common 4582
52.4%
Latin 4170
47.6%

Most frequent character per script

Common
ValueCountFrequency (%)
8 1196
26.1%
7 1173
25.6%
0 635
13.9%
5 618
13.5%
1 612
13.4%
2 103
 
2.2%
3 100
 
2.2%
6 66
 
1.4%
4 56
 
1.2%
9 23
 
0.5%
Latin
ValueCountFrequency (%)
f 1734
41.6%
e 1134
27.2%
d 689
 
16.5%
b 240
 
5.8%
a 216
 
5.2%
c 157
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8752
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
f 1734
19.8%
8 1196
13.7%
7 1173
13.4%
e 1134
13.0%
d 689
 
7.9%
0 635
 
7.3%
5 618
 
7.1%
1 612
 
7.0%
b 240
 
2.7%
a 216
 
2.5%
Other values (6) 505
 
5.8%

모델명
Categorical

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
3031
368 
3032
158 
3030
 
21

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3031 368
67.3%
3032 158
28.9%
3030 21
 
3.8%

Length

2023-12-11T18:01:15.427981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T18:01:15.543626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3031 368
67.3%
3032 158
28.9%
3030 21
 
3.8%

시리얼
Real number (ℝ)

ZEROS 

Distinct9
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean95.608775
Minimum0
Maximum100
Zeros21
Zeros (%)3.8%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2023-12-11T18:01:15.667839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile89
Q1100
median100
Q3100
95-th percentile100
Maximum100
Range100
Interquartile range (IQR)0

Descriptive statistics

Standard deviation19.253099
Coefficient of variation (CV)0.20137377
Kurtosis20.636156
Mean95.608775
Median Absolute Deviation (MAD)0
Skewness-4.7207675
Sum52298
Variance370.68183
MonotonicityNot monotonic
2023-12-11T18:01:15.819148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
100 469
85.7%
0 21
 
3.8%
97 16
 
2.9%
98 14
 
2.6%
96 10
 
1.8%
89 9
 
1.6%
99 3
 
0.5%
80 3
 
0.5%
88 2
 
0.4%
ValueCountFrequency (%)
0 21
 
3.8%
80 3
 
0.5%
88 2
 
0.4%
89 9
 
1.6%
96 10
 
1.8%
97 16
 
2.9%
98 14
 
2.6%
99 3
 
0.5%
100 469
85.7%
ValueCountFrequency (%)
100 469
85.7%
99 3
 
0.5%
98 14
 
2.6%
97 16
 
2.9%
96 10
 
1.8%
89 9
 
1.6%
88 2
 
0.4%
80 3
 
0.5%
0 21
 
3.8%

주차여부
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
0
547 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 547
100.0%

Length

2023-12-11T18:01:15.987558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T18:01:16.132494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 547
100.0%

배터리용량
Date

Distinct545
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2023-01-23 00:07:16
Maximum2023-01-29 23:44:27
2023-12-11T18:01:16.256974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T18:01:16.405006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

레이더센서상태
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing547
Missing (%)100.0%
Memory size6.1 KiB

등록일시
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing547
Missing (%)100.0%
Memory size6.1 KiB

Interactions

2023-12-11T18:01:14.307039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T18:01:16.501997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기관 명모델명시리얼
기관 명1.0000.9560.994
모델명0.9561.0000.677
시리얼0.9940.6771.000

Missing values

2023-12-11T18:01:14.449624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T18:01:14.588424image/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

기관 명모델명시리얼주차여부배터리용량레이더센서상태등록일시
성동구SKTX-PKS-00288571dfffe0e7a7c303110002023-01-23 00:07:16<NA><NA>
SKTX-PKS-00288571dfffe0e7d39303110002023-01-23 00:18:51<NA><NA>
SKTX-PKS-00288571dfffe0e7c8f303110002023-01-23 00:21:58<NA><NA>
SKTX-PKS-00288571dfffe0e7af2303110002023-01-23 00:26:07<NA><NA>
SKTX-PKS-00288571dfffe0e7b33303110002023-01-23 00:42:57<NA><NA>
SKTX-PKS-00288571dfffe0e7af5303110002023-01-23 01:28:34<NA><NA>
SKTX-PKS-00288571dfffe0e7c18303110002023-01-23 01:51:05<NA><NA>
SKTX-PKS-00288571dfffe0e7b38303110002023-01-23 01:57:51<NA><NA>
SKTX-PKS-00288571dfffe0e7d68303110002023-01-23 02:10:20<NA><NA>
SKTX-PKS-00288571dfffe0e7b10303210002023-01-23 03:08:57<NA><NA>
기관 명모델명시리얼주차여부배터리용량레이더센서상태등록일시
성동구SKTX-PKS-00288571dfffe0e7b39303110002023-01-29 21:47:04<NA><NA>
SKTX-PKS-00288571dfffe0e7cbd303110002023-01-29 21:59:05<NA><NA>
SKTX-PKS-00288571dfffe0e7c50303110002023-01-29 22:04:11<NA><NA>
SKTX-PKS-00288571dfffe0e7c8f303210002023-01-29 22:35:18<NA><NA>
SKTX-PKS-00288571dfffe0e7b53303110002023-01-29 23:11:41<NA><NA>
SKTX-PKS-00288571dfffe0e7d2a3030002023-01-29 23:23:27<NA><NA>
SKTX-PKS-00288571dfffe0e7ab7303110002023-01-29 23:25:18<NA><NA>
SKTX-PKS-00288571dfffe0e7ab7303110002023-01-29 23:25:46<NA><NA>
SKTX-PKS-00288571dfffe0e7b11303110002023-01-29 23:40:41<NA><NA>
SKTX-PKS-00288571dfffe0e7b7c303110002023-01-29 23:44:27<NA><NA>

Duplicate rows

Most frequently occurring

기관 명모델명시리얼주차여부배터리용량# duplicates
088571dfffe0e7ab230318902023-01-25 12:44:113