Overview

Dataset statistics

Number of variables7
Number of observations548
Missing cells1096
Missing cells (%)28.6%
Duplicate rows1
Duplicate rows (%)0.2%
Total size in memory34.0 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 548 (100.0%) missing valuesMissing
등록일시 has 548 (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 13 (2.4%) zerosZeros

Reproduction

Analysis started2023-12-11 09:01:22.881895
Analysis finished2023-12-11 09:01:23.304780
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Text

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

Length

Max length16
Median length16
Mean length16
Min length16

Characters and Unicode

Total characters8768
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

Unique1 ?
Unique (%)0.2%

Sample

1st row88571dfffe0e7c8a
2nd row88571dfffe0e7d0f
3rd row88571dfffe0e7b62
4th row88571dfffe0e7b04
5th row88571dfffe0e7d04
ValueCountFrequency (%)
88571dfffe0e7c50 11
 
2.0%
88571dfffe0e7d0d 10
 
1.8%
88571dfffe0e7d41 10
 
1.8%
88571dfffe0e7a4e 9
 
1.6%
88571dfffe0e7cf0 9
 
1.6%
88571dfffe0e7b73 9
 
1.6%
88571dfffe0e7af6 9
 
1.6%
88571dfffe0e7b11 9
 
1.6%
88571dfffe0e7b2a 9
 
1.6%
88571dfffe0e7d00 8
 
1.5%
Other values (68) 455
83.0%
2023-12-11T18:01:23.886111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
f 1741
19.9%
8 1207
13.8%
7 1161
13.2%
e 1128
12.9%
d 706
8.1%
0 653
 
7.4%
5 624
 
7.1%
1 620
 
7.1%
b 215
 
2.5%
a 201
 
2.3%
Other values (6) 512
 
5.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4611
52.6%
Lowercase Letter 4157
47.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 1207
26.2%
7 1161
25.2%
0 653
14.2%
5 624
13.5%
1 620
13.4%
2 101
 
2.2%
3 99
 
2.1%
6 72
 
1.6%
4 56
 
1.2%
9 18
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
f 1741
41.9%
e 1128
27.1%
d 706
17.0%
b 215
 
5.2%
a 201
 
4.8%
c 166
 
4.0%

Most occurring scripts

ValueCountFrequency (%)
Common 4611
52.6%
Latin 4157
47.4%

Most frequent character per script

Common
ValueCountFrequency (%)
8 1207
26.2%
7 1161
25.2%
0 653
14.2%
5 624
13.5%
1 620
13.4%
2 101
 
2.2%
3 99
 
2.1%
6 72
 
1.6%
4 56
 
1.2%
9 18
 
0.4%
Latin
ValueCountFrequency (%)
f 1741
41.9%
e 1128
27.1%
d 706
17.0%
b 215
 
5.2%
a 201
 
4.8%
c 166
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8768
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
f 1741
19.9%
8 1207
13.8%
7 1161
13.2%
e 1128
12.9%
d 706
8.1%
0 653
 
7.4%
5 624
 
7.1%
1 620
 
7.1%
b 215
 
2.5%
a 201
 
2.3%
Other values (6) 512
 
5.8%

모델명
Categorical

Distinct3
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
3031
385 
3032
150 
3030
 
13

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3031 385
70.3%
3032 150
 
27.4%
3030 13
 
2.4%

Length

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

Common Values (Plot)

2023-12-11T18:01:24.135536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3031 385
70.3%
3032 150
 
27.4%
3030 13
 
2.4%

시리얼
Real number (ℝ)

ZEROS 

Distinct9
Distinct (%)1.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean97.260949
Minimum0
Maximum100
Zeros13
Zeros (%)2.4%
Negative0
Negative (%)0.0%
Memory size6.1 KiB
2023-12-11T18:01:24.232994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation15.311971
Coefficient of variation (CV)0.15743185
Kurtosis36.121717
Mean97.260949
Median Absolute Deviation (MAD)0
Skewness-6.1228173
Sum53299
Variance234.45646
MonotonicityNot monotonic
2023-12-11T18:01:24.338559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
100 487
88.9%
99 19
 
3.5%
0 13
 
2.4%
98 9
 
1.6%
97 8
 
1.5%
86 5
 
0.9%
96 4
 
0.7%
88 2
 
0.4%
70 1
 
0.2%
ValueCountFrequency (%)
0 13
 
2.4%
70 1
 
0.2%
86 5
 
0.9%
88 2
 
0.4%
96 4
 
0.7%
97 8
 
1.5%
98 9
 
1.6%
99 19
 
3.5%
100 487
88.9%
ValueCountFrequency (%)
100 487
88.9%
99 19
 
3.5%
98 9
 
1.6%
97 8
 
1.5%
96 4
 
0.7%
88 2
 
0.4%
86 5
 
0.9%
70 1
 
0.2%
0 13
 
2.4%

주차여부
Categorical

CONSTANT 

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

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 548
100.0%

Length

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

Common Values (Plot)

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

배터리용량
Date

Distinct547
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2023-01-02 01:09:21
Maximum2023-01-08 23:22:44
2023-12-11T18:01:24.658901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T18:01:24.808752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

레이더센서상태
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

등록일시
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Interactions

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

Correlations

2023-12-11T18:01:24.911552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기관 명모델명시리얼
기관 명1.0000.9680.961
모델명0.9681.0000.675
시리얼0.9610.6751.000

Missing values

2023-12-11T18:01:23.135279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T18:01:23.251282image/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-00288571dfffe0e7c8a303210002023-01-02 01:09:21<NA><NA>
SKTX-PKS-00288571dfffe0e7d0f303110002023-01-02 01:33:34<NA><NA>
SKTX-PKS-00288571dfffe0e7b62303110002023-01-02 02:04:24<NA><NA>
SKTX-PKS-00288571dfffe0e7b04303210002023-01-02 02:07:01<NA><NA>
SKTX-PKS-00288571dfffe0e7d04303110002023-01-02 02:07:16<NA><NA>
SKTX-PKS-00288571dfffe0e7d18303210002023-01-02 02:16:02<NA><NA>
SKTX-PKS-00288571dfffe0e7b11303110002023-01-02 02:20:31<NA><NA>
SKTX-PKS-00288571dfffe0e7cd5303110002023-01-02 02:24:51<NA><NA>
SKTX-PKS-00288571dfffe0e7af5303110002023-01-02 03:04:04<NA><NA>
SKTX-PKS-00288571dfffe0e7b62303110002023-01-02 03:05:13<NA><NA>
기관 명모델명시리얼주차여부배터리용량레이더센서상태등록일시
성동구SKTX-PKS-00288571dfffe0e7a7c303110002023-01-08 19:58:38<NA><NA>
SKTX-PKS-00288571dfffe0e7c2d303110002023-01-08 20:40:24<NA><NA>
SKTX-PKS-00288571dfffe0e7b53303110002023-01-08 21:44:02<NA><NA>
SKTX-PKS-00288571dfffe0e7b53303110002023-01-08 21:44:39<NA><NA>
SKTX-PKS-00288571dfffe0e7af8303110002023-01-08 21:56:27<NA><NA>
SKTX-PKS-00288571dfffe0e7af8303110002023-01-08 21:57:11<NA><NA>
SKTX-PKS-00288571dfffe0e7b2a303110002023-01-08 21:58:33<NA><NA>
SKTX-PKS-00288571dfffe0e7d55303110002023-01-08 23:02:06<NA><NA>
SKTX-PKS-00288571dfffe0e7d2a303210002023-01-08 23:07:37<NA><NA>
SKTX-PKS-00288571dfffe0e7af4303110002023-01-08 23:22:44<NA><NA>

Duplicate rows

Most frequently occurring

기관 명모델명시리얼주차여부배터리용량# duplicates
088571dfffe0e7c50303110002023-01-05 06:42:042