Overview

Dataset statistics

Number of variables5
Number of observations35
Missing cells6
Missing cells (%)3.4%
Duplicate rows1
Duplicate rows (%)2.9%
Total size in memory1.5 KiB
Average record size in memory43.8 B

Variable types

Text3
Categorical1
DateTime1

Dataset

Description인천광역시 서구 자전거 판매 및 수리업소에 대한 데이터로 상호명, 전화번호, 구분, 주소 등의 정보가 포함되어 있습니다.
URLhttps://www.data.go.kr/data/15090849/fileData.do

Alerts

구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 1 (2.9%) duplicate rowsDuplicates
전화번호 has 6 (17.1%) missing valuesMissing

Reproduction

Analysis started2023-12-12 11:45:41.091350
Analysis finished2023-12-12 11:45:41.441392
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

Distinct34
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-12T20:45:41.619742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length8
Mean length6.1142857
Min length4

Characters and Unicode

Total characters214
Distinct characters79
Distinct categories4 ?
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 (%)94.3%

Sample

1st row벨로하우스
2nd row바이크로
3rd row삼천리서구청점
4th row알톤심곡로점
5th row웨이바이크
ValueCountFrequency (%)
알톤심곡로점 2
 
5.6%
알톤청라루비로점 1
 
2.8%
가좌mtb 1
 
2.8%
지오닉스 1
 
2.8%
스포츠 1
 
2.8%
알톤석남점 1
 
2.8%
알톤바이크코리아 1
 
2.8%
알톤바이코리아 1
 
2.8%
유니랜드 1
 
2.8%
씨앤바이크 1
 
2.8%
Other values (25) 25
69.4%
2023-12-12T20:45:41.956106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
점 16
 
7.5%
이 14
 
6.5%
리 12
 
5.6%
바 11
 
5.1%
천 9
 
4.2%
크 9
 
4.2%
삼 9
 
4.2%
로 8
 
3.7%
톤 7
 
3.3%
라 7
 
3.3%
Other values (69) 112
52.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 209
97.7%
Lowercase Letter 3
 
1.4%
Space Separator 1
 
0.5%
Decimal Number 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
점 16
 
7.7%
이 14
 
6.7%
리 12
 
5.7%
바 11
 
5.3%
천 9
 
4.3%
크 9
 
4.3%
삼 9
 
4.3%
로 8
 
3.8%
톤 7
 
3.3%
라 7
 
3.3%
Other values (64) 107
51.2%
Lowercase Letter
ValueCountFrequency (%)
b 1
33.3%
t 1
33.3%
m 1
33.3%
Space Separator
ValueCountFrequency (%)
1
100.0%
Decimal Number
ValueCountFrequency (%)
2 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 209
97.7%
Latin 3
 
1.4%
Common 2
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
점 16
 
7.7%
이 14
 
6.7%
리 12
 
5.7%
바 11
 
5.3%
천 9
 
4.3%
크 9
 
4.3%
삼 9
 
4.3%
로 8
 
3.8%
톤 7
 
3.3%
라 7
 
3.3%
Other values (64) 107
51.2%
Latin
ValueCountFrequency (%)
b 1
33.3%
t 1
33.3%
m 1
33.3%
Common
ValueCountFrequency (%)
1
50.0%
2 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 209
97.7%
ASCII 5
 
2.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
점 16
 
7.7%
이 14
 
6.7%
리 12
 
5.7%
바 11
 
5.3%
천 9
 
4.3%
크 9
 
4.3%
삼 9
 
4.3%
로 8
 
3.8%
톤 7
 
3.3%
라 7
 
3.3%
Other values (64) 107
51.2%
ASCII
ValueCountFrequency (%)
1
20.0%
b 1
20.0%
t 1
20.0%
m 1
20.0%
2 1
20.0%

전화번호
Text

MISSING 

Distinct26
Distinct (%)89.7%
Missing6
Missing (%)17.1%
Memory size412.0 B
2023-12-12T20:45:42.157954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length12.931034
Min length12

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)79.3%

Sample

1st row0507-1406-6418
2nd row032-568-9785
3rd row032-544-6673
4th row0507-1497-0310
5th row0507-1408-5917
ValueCountFrequency (%)
0507-1375-6001 2
 
6.9%
032-544-6673 2
 
6.9%
0507-1358-3627 2
 
6.9%
032-565-4416 1
 
3.4%
032-569-1179 1
 
3.4%
032-572-1500 1
 
3.4%
032-567-6145 1
 
3.4%
032-573-4442 1
 
3.4%
032-561-1998 1
 
3.4%
032-512-0033 1
 
3.4%
Other values (16) 16
55.2%
2023-12-12T20:45:42.504798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 65
17.3%
- 58
15.5%
5 45
12.0%
3 37
9.9%
1 36
9.6%
7 34
9.1%
6 26
 
6.9%
2 26
 
6.9%
4 24
 
6.4%
9 14
 
3.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 317
84.5%
Dash Punctuation 58
 
15.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 65
20.5%
5 45
14.2%
3 37
11.7%
1 36
11.4%
7 34
10.7%
6 26
 
8.2%
2 26
 
8.2%
4 24
 
7.6%
9 14
 
4.4%
8 10
 
3.2%
Dash Punctuation
ValueCountFrequency (%)
- 58
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 375
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 65
17.3%
- 58
15.5%
5 45
12.0%
3 37
9.9%
1 36
9.6%
7 34
9.1%
6 26
 
6.9%
2 26
 
6.9%
4 24
 
6.4%
9 14
 
3.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 375
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 65
17.3%
- 58
15.5%
5 45
12.0%
3 37
9.9%
1 36
9.6%
7 34
9.1%
6 26
 
6.9%
2 26
 
6.9%
4 24
 
6.4%
9 14
 
3.7%

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
판매 및 수리
35 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row판매 및 수리
2nd row판매 및 수리
3rd row판매 및 수리
4th row판매 및 수리
5th row판매 및 수리

Common Values

ValueCountFrequency (%)
판매 및 수리 35
100.0%

Length

2023-12-12T20:45:42.633015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:45:42.729783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
판매 35
33.3%
및 35
33.3%
수리 35
33.3%

주소
Text

Distinct30
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
2023-12-12T20:45:42.912215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length22
Mean length19.142857
Min length15

Characters and Unicode

Total characters670
Distinct characters64
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique26 ?
Unique (%)74.3%

Sample

1st row인천광역시 서구 승학로 515 대림프라자
2nd row인천광역시 서구 서곶로 458 101호
3rd row인천광역시 서구 서곶로 337
4th row인천광역시 서구 승학로 281
5th row인천광역시 서구 청라에메랄드로163번길 4
ValueCountFrequency (%)
인천광역시 35
24.8%
서구 35
24.8%
청라루비로144번길 3
 
2.1%
21 3
 
2.1%
승학로 3
 
2.1%
가정로 3
 
2.1%
서곶로 2
 
1.4%
중봉대로 2
 
1.4%
6 2
 
1.4%
담지로8번길 2
 
1.4%
Other values (45) 51
36.2%
2023-12-12T20:45:43.281029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
106
15.8%
서 37
 
5.5%
인 35
 
5.2%
천 35
 
5.2%
구 35
 
5.2%
로 35
 
5.2%
시 35
 
5.2%
광 35
 
5.2%
역 35
 
5.2%
1 25
 
3.7%
Other values (54) 257
38.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 423
63.1%
Decimal Number 134
 
20.0%
Space Separator 106
 
15.8%
Dash Punctuation 7
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 37
 
8.7%
인 35
 
8.3%
천 35
 
8.3%
구 35
 
8.3%
로 35
 
8.3%
시 35
 
8.3%
광 35
 
8.3%
역 35
 
8.3%
길 17
 
4.0%
번 17
 
4.0%
Other values (42) 107
25.3%
Decimal Number
ValueCountFrequency (%)
1 25
18.7%
2 22
16.4%
4 15
11.2%
3 15
11.2%
6 13
9.7%
5 12
9.0%
8 12
9.0%
7 10
 
7.5%
9 6
 
4.5%
0 4
 
3.0%
Space Separator
ValueCountFrequency (%)
106
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 423
63.1%
Common 247
36.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 37
 
8.7%
인 35
 
8.3%
천 35
 
8.3%
구 35
 
8.3%
로 35
 
8.3%
시 35
 
8.3%
광 35
 
8.3%
역 35
 
8.3%
길 17
 
4.0%
번 17
 
4.0%
Other values (42) 107
25.3%
Common
ValueCountFrequency (%)
106
42.9%
1 25
 
10.1%
2 22
 
8.9%
4 15
 
6.1%
3 15
 
6.1%
6 13
 
5.3%
5 12
 
4.9%
8 12
 
4.9%
7 10
 
4.0%
- 7
 
2.8%
Other values (2) 10
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 423
63.1%
ASCII 247
36.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
106
42.9%
1 25
 
10.1%
2 22
 
8.9%
4 15
 
6.1%
3 15
 
6.1%
6 13
 
5.3%
5 12
 
4.9%
8 12
 
4.9%
7 10
 
4.0%
- 7
 
2.8%
Other values (2) 10
 
4.0%
Hangul
ValueCountFrequency (%)
서 37
 
8.7%
인 35
 
8.3%
천 35
 
8.3%
구 35
 
8.3%
로 35
 
8.3%
시 35
 
8.3%
광 35
 
8.3%
역 35
 
8.3%
길 17
 
4.0%
번 17
 
4.0%
Other values (42) 107
25.3%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
Minimum2022-09-01 00:00:00
Maximum2022-09-01 00:00:00
2023-12-12T20:45:43.399937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:45:43.580366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-12T20:45:43.700970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호명전화번호주소
상호명1.0001.0001.000
전화번호1.0001.0001.000
주소1.0001.0001.000

Missing values

2023-12-12T20:45:41.310837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:45:41.405220image/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

상호명전화번호구분주소데이터기준일자
0벨로하우스<NA>판매 및 수리인천광역시 서구 승학로 515 대림프라자2022-09-01
1바이크로0507-1406-6418판매 및 수리인천광역시 서구 서곶로 458 101호2022-09-01
2삼천리서구청점032-568-9785판매 및 수리인천광역시 서구 서곶로 3372022-09-01
3알톤심곡로점032-544-6673판매 및 수리인천광역시 서구 승학로 2812022-09-01
4웨이바이크0507-1497-0310판매 및 수리인천광역시 서구 청라에메랄드로163번길 42022-09-01
5뉴욕바이크0507-1408-5917판매 및 수리인천광역시 서구 청라에메랄드로112번길2022-09-01
6오마이벨로0507-1376-0619판매 및 수리인천광역시 서구 청라에메랄드로76번길 72022-09-01
7삼천리청라점0507-1410-5511판매 및 수리인천광역시 서구 담지로8번길 62022-09-01
8트라이코리아070-5121-7960판매 및 수리인천광역시 서구 중봉대로 6022022-09-01
9삼천리연희점0507-1375-6001판매 및 수리인천광역시 서구 중봉대로586번길 222022-09-01
상호명전화번호구분주소데이터기준일자
25유니랜드032-512-0033판매 및 수리인천광역시 서구 원당대로428번길 62022-09-01
26삼천리원당점032-561-1998판매 및 수리인천광역시 서구 고산후로 972022-09-01
27알톤청라루비로점0507-1358-3627판매 및 수리인천광역시 서구 청라루비로144번길 212022-09-01
28알톤심곡로점032-544-6673판매 및 수리인천광역시 서구 승학로 2812022-09-01
29알톤바이크코리아<NA>판매 및 수리인천광역시 서구 가정로 340-12022-09-01
30알톤석남점032-573-4442판매 및 수리인천광역시 서구 가정로 1772022-09-01
31지오닉스 스포츠032-567-6145판매 및 수리인천광역시 서구 검단로326번길 35-932022-09-01
32가좌mtb032-572-1500판매 및 수리인천광역시 서구 장고개로 2642022-09-01
33코렉스가좌점032-578-4533판매 및 수리인천광역시 서구 장고개로 3292022-09-01
34삼천리청라연희점0507-1375-6001판매 및 수리인천광역시 서구 중봉대로586번길 222022-09-01

Duplicate rows

Most frequently occurring

상호명전화번호구분주소데이터기준일자# duplicates
0알톤심곡로점032-544-6673판매 및 수리인천광역시 서구 승학로 2812022-09-012