Overview

Dataset statistics

Number of variables7
Number of observations50
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory61.6 B

Variable types

Numeric1
Categorical4
Text1
DateTime1

Dataset

Description한국교통안전공단 통합홈페이지시스템에서 관리하고 있는 기기검사 일정 정보입니다
Author한국교통안전공단
URLhttps://www.data.go.kr/data/15066111/fileData.do

Alerts

일자_월 has constant value ""Constant
등록일시 has constant value ""Constant
일련번호 is highly overall correlated with 주소 and 1 other fieldsHigh correlation
일자_일 is highly overall correlated with 주소High correlation
주소 is highly overall correlated with 일련번호 and 2 other fieldsHigh correlation
지사 is highly overall correlated with 일련번호 and 1 other fieldsHigh correlation
일련번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:50:35.959208
Analysis finished2023-12-12 10:50:37.051049
Duration1.09 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct50
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79525.44
Minimum78670
Maximum80554
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size582.0 B
2023-12-12T19:50:37.201640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum78670
5-th percentile78690
Q179384.25
median79494.5
Q379654.75
95-th percentile80443.1
Maximum80554
Range1884
Interquartile range (IQR)270.5

Descriptive statistics

Standard deviation437.23893
Coefficient of variation (CV)0.0054981014
Kurtosis0.84788897
Mean79525.44
Median Absolute Deviation (MAD)160
Skewness0.43882911
Sum3976272
Variance191177.88
MonotonicityNot monotonic
2023-12-12T19:50:37.491167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
79113 1
 
2.0%
79427 1
 
2.0%
79484 1
 
2.0%
79387 1
 
2.0%
79388 1
 
2.0%
79800 1
 
2.0%
78672 1
 
2.0%
78671 1
 
2.0%
78670 1
 
2.0%
78712 1
 
2.0%
Other values (40) 40
80.0%
ValueCountFrequency (%)
78670 1
2.0%
78671 1
2.0%
78672 1
2.0%
78712 1
2.0%
79112 1
2.0%
79113 1
2.0%
79114 1
2.0%
79115 1
2.0%
79116 1
2.0%
79269 1
2.0%
ValueCountFrequency (%)
80554 1
2.0%
80553 1
2.0%
80552 1
2.0%
80310 1
2.0%
80205 1
2.0%
80178 1
2.0%
80014 1
2.0%
79895 1
2.0%
79800 1
2.0%
79767 1
2.0%

일자_월
Categorical

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
3
50 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
3 50
100.0%

Length

2023-12-12T19:50:37.755403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:50:37.911748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 50
100.0%

일자_일
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
30
20 
31
16 
27
10 
28
4 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
30 20
40.0%
31 16
32.0%
27 10
20.0%
28 4
 
8.0%

Length

2023-12-12T19:50:38.105835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:50:38.294775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
30 20
40.0%
31 16
32.0%
27 10
20.0%
28 4
 
8.0%

회사명
Text

Distinct40
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
2023-12-12T19:50:38.666186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length12
Mean length8.54
Min length2

Characters and Unicode

Total characters427
Distinct characters103
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)66.0%

Sample

1st row(주)명문정비
2nd row(주)명문정비
3rd row승일자동차정비
4th row흥일자동차정비
5th row흥일자동차정비
ValueCountFrequency (%)
구미자동차검사소 3
 
5.2%
신탄진자동차검사소 3
 
5.2%
주 3
 
5.2%
주)삼삼1급자동차서비스 3
 
5.2%
주)명문정비 2
 
3.4%
신일정비 2
 
3.4%
흥일자동차정비 2
 
3.4%
청주자동차검사소 2
 
3.4%
ok자동차공업사 1
 
1.7%
신한국특장 1
 
1.7%
Other values (36) 36
62.1%
2023-12-12T19:50:39.366927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 28
 
6.6%
차 28
 
6.6%
자 26
 
6.1%
비 24
 
5.6%
주 21
 
4.9%
사 19
 
4.4%
) 19
 
4.4%
( 19
 
4.4%
정 16
 
3.7%
스 13
 
3.0%
Other values (93) 214
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 370
86.7%
Close Punctuation 19
 
4.4%
Open Punctuation 19
 
4.4%
Space Separator 8
 
1.9%
Decimal Number 8
 
1.9%
Uppercase Letter 2
 
0.5%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 28
 
7.6%
차 28
 
7.6%
자 26
 
7.0%
비 24
 
6.5%
주 21
 
5.7%
사 19
 
5.1%
정 16
 
4.3%
스 13
 
3.5%
신 10
 
2.7%
검 10
 
2.7%
Other values (84) 175
47.3%
Decimal Number
ValueCountFrequency (%)
1 6
75.0%
5 1
 
12.5%
0 1
 
12.5%
Uppercase Letter
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 370
86.7%
Common 55
 
12.9%
Latin 2
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 28
 
7.6%
차 28
 
7.6%
자 26
 
7.0%
비 24
 
6.5%
주 21
 
5.7%
사 19
 
5.1%
정 16
 
4.3%
스 13
 
3.5%
신 10
 
2.7%
검 10
 
2.7%
Other values (84) 175
47.3%
Common
ValueCountFrequency (%)
) 19
34.5%
( 19
34.5%
8
14.5%
1 6
 
10.9%
5 1
 
1.8%
0 1
 
1.8%
- 1
 
1.8%
Latin
ValueCountFrequency (%)
O 1
50.0%
K 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 370
86.7%
ASCII 57
 
13.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 28
 
7.6%
차 28
 
7.6%
자 26
 
7.0%
비 24
 
6.5%
주 21
 
5.7%
사 19
 
5.1%
정 16
 
4.3%
스 13
 
3.5%
신 10
 
2.7%
검 10
 
2.7%
Other values (84) 175
47.3%
ASCII
ValueCountFrequency (%)
) 19
33.3%
( 19
33.3%
8
14.0%
1 6
 
10.5%
O 1
 
1.8%
K 1
 
1.8%
5 1
 
1.8%
0 1
 
1.8%
- 1
 
1.8%

주소
Categorical

HIGH CORRELATION 

Distinct24
Distinct (%)48.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
경상남도 김해시
5 
광주광역시 광산구
5 
대전광역시 대덕구
5 
대구광역시 서구
3 
경상북도 구미시
3 
Other values (19)
29 

Length

Max length9
Median length9
Mean length8.68
Min length7

Unique

Unique12 ?
Unique (%)24.0%

Sample

1st row경상남도 김해시
2nd row경상남도 김해시
3rd row경상남도 김해시
4th row경상남도 김해시
5th row경상남도 김해시

Common Values

ValueCountFrequency (%)
경상남도 김해시 5
 
10.0%
광주광역시 광산구 5
 
10.0%
대전광역시 대덕구 5
 
10.0%
대구광역시 서구 3
 
6.0%
경상북도 구미시 3
 
6.0%
광주광역시 서구 3
 
6.0%
충청북도 청주시 3
 
6.0%
경기도 고양시 3
 
6.0%
대구광역시 동구 2
 
4.0%
광주광역시 북구 2
 
4.0%
Other values (14) 16
32.0%

Length

2023-12-12T19:50:39.715626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
광주광역시 10
 
10.0%
대구광역시 9
 
9.0%
서구 6
 
6.0%
경상남도 5
 
5.0%
부산광역시 5
 
5.0%
김해시 5
 
5.0%
대덕구 5
 
5.0%
대전광역시 5
 
5.0%
광산구 5
 
5.0%
경기도 4
 
4.0%
Other values (24) 41
41.0%

지사
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
대구경북본부
13 
광주전남본부
12 
부산본부
10 
대전충남본부
8 
서울본부
7 

Length

Max length6
Median length6
Mean length5.32
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산본부
2nd row부산본부
3rd row부산본부
4th row부산본부
5th row부산본부

Common Values

ValueCountFrequency (%)
대구경북본부 13
26.0%
광주전남본부 12
24.0%
부산본부 10
20.0%
대전충남본부 8
16.0%
서울본부 7
14.0%

Length

2023-12-12T19:50:40.041926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T19:50:40.309564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구경북본부 13
26.0%
광주전남본부 12
24.0%
부산본부 10
20.0%
대전충남본부 8
16.0%
서울본부 7
14.0%

등록일시
Date

CONSTANT 

Distinct1
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size532.0 B
Minimum2020-01-10 00:00:00
Maximum2020-01-10 00:00:00
2023-12-12T19:50:40.539996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:50:40.775385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T19:50:36.485794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:50:40.953015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호일자_일회사명주소지사
일련번호1.0000.5601.0001.0000.857
일자_일0.5601.0001.0000.9930.431
회사명1.0001.0001.0001.0001.000
주소1.0000.9931.0001.0001.000
지사0.8570.4311.0001.0001.000
2023-12-12T19:50:41.246348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주소일자_일지사
주소1.0000.6680.760
일자_일0.6681.0000.358
지사0.7600.3581.000
2023-12-12T19:50:41.438059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호일자_일주소지사
일련번호1.0000.3820.7960.686
일자_일0.3821.0000.6680.358
주소0.7960.6681.0000.760
지사0.6860.3580.7601.000

Missing values

2023-12-12T19:50:36.746234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T19:50:36.966690image/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

일련번호일자_월일자_일회사명주소지사등록일시
079113331(주)명문정비경상남도 김해시부산본부2020-01-10
179112331(주)명문정비경상남도 김해시부산본부2020-01-10
279114331승일자동차정비경상남도 김해시부산본부2020-01-10
379115331흥일자동차정비경상남도 김해시부산본부2020-01-10
479116331흥일자동차정비경상남도 김해시부산본부2020-01-10
579552331아우토슈타트(주)대구지점대구광역시 수성구대구경북본부2020-01-10
679412331가제트광주광역시 북구광주전남본부2020-01-10
779269331구미자동차검사소경상북도 구미시대구경북본부2020-01-10
879270331구미자동차검사소경상북도 구미시대구경북본부2020-01-10
979271331구미자동차검사소경상북도 구미시대구경북본부2020-01-10
일련번호일자_월일자_일회사명주소지사등록일시
4079767327(주)동성모터스 해운대서비스센터부산광역시 해운대부산본부2020-01-10
4180014327OK자동차공업사인천광역시 계양구서울본부2020-01-10
4279384327(주) 뉴런테크광주광역시 광산구광주전남본부2020-01-10
4379466327제인모터스대구광역시 달성군대구경북본부2020-01-10
4479731327대림자동차정비공장부산광역시 수영구부산본부2020-01-10
4579385327(주) 신한국특장광주광역시 광산구광주전남본부2020-01-10
4679654327신일정비부산광역시 동래구부산본부2020-01-10
4779386327(주)부림특장차광주광역시 광산구광주전남본부2020-01-10
4879655327신일정비부산광역시 동래구부산본부2020-01-10
4979895327(주)그린자동차서울특별시 성동구서울본부2020-01-10