Overview

Dataset statistics

Number of variables6
Number of observations5919
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory283.4 KiB
Average record size in memory49.0 B

Variable types

Numeric1
Categorical2
Text2
DateTime1

Dataset

Description인천광역시 내 버스정류장에 대해 부여된 사물주소 현황입니다.( 순번, 시군구, 사물명. 고유번호, 사물주소, 사물주소 확정일 정보 제공)
Author인천광역시
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15077371&srcSe=7661IVAWM27C61E190

Alerts

진행상태 has constant value ""Constant
순번 is highly overall correlated with 시군구High correlation
시군구 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique
사물주소 has unique valuesUnique

Reproduction

Analysis started2024-01-28 06:38:30.126602
Analysis finished2024-01-28 06:38:31.141186
Duration1.01 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct5919
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2960
Minimum1
Maximum5919
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size52.2 KiB
2024-01-28T15:38:31.192708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile296.9
Q11480.5
median2960
Q34439.5
95-th percentile5623.1
Maximum5919
Range5918
Interquartile range (IQR)2959

Descriptive statistics

Standard deviation1708.8125
Coefficient of variation (CV)0.5773015
Kurtosis-1.2
Mean2960
Median Absolute Deviation (MAD)1480
Skewness0
Sum17520240
Variance2920040
MonotonicityStrictly increasing
2024-01-28T15:38:31.303792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
3944 1
 
< 0.1%
3953 1
 
< 0.1%
3952 1
 
< 0.1%
3951 1
 
< 0.1%
3950 1
 
< 0.1%
3949 1
 
< 0.1%
3948 1
 
< 0.1%
3947 1
 
< 0.1%
3946 1
 
< 0.1%
Other values (5909) 5909
99.8%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
5919 1
< 0.1%
5918 1
< 0.1%
5917 1
< 0.1%
5916 1
< 0.1%
5915 1
< 0.1%
5914 1
< 0.1%
5913 1
< 0.1%
5912 1
< 0.1%
5911 1
< 0.1%
5910 1
< 0.1%

시군구
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
강화군
1251 
서구
1027 
남동구
749 
부평구
678 
중구
578 
Other values (5)
1636 

Length

Max length4
Median length3
Mean length2.784592
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강화군
2nd row강화군
3rd row강화군
4th row강화군
5th row강화군

Common Values

ValueCountFrequency (%)
강화군 1251
21.1%
서구 1027
17.4%
남동구 749
12.7%
부평구 678
11.5%
중구 578
9.8%
연수구 547
9.2%
미추홀구 484
 
8.2%
계양구 440
 
7.4%
동구 154
 
2.6%
옹진군 11
 
0.2%

Length

2024-01-28T15:38:31.410005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T15:38:31.502556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
강화군 1251
21.1%
서구 1027
17.4%
남동구 749
12.7%
부평구 678
11.5%
중구 578
9.8%
연수구 547
9.2%
미추홀구 484
 
8.2%
계양구 440
 
7.4%
동구 154
 
2.6%
옹진군 11
 
0.2%

사물명
Text

Distinct3437
Distinct (%)58.1%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
2024-01-28T15:38:31.755561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length19
Mean length6.5046461
Min length2

Characters and Unicode

Total characters38501
Distinct characters616
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1425 ?
Unique (%)24.1%

Sample

1st row해망
2nd row해망
3rd row탑재입구
4th row탑재입구
5th row탄토마을
ValueCountFrequency (%)
대동아파트 13
 
0.2%
현대아파트 13
 
0.2%
광명아파트 10
 
0.2%
한국아파트 10
 
0.2%
쌍용아파트 9
 
0.2%
뉴서울아파트 9
 
0.2%
신동아아파트 9
 
0.2%
부대앞 9
 
0.2%
대림아파트 8
 
0.1%
풍림아파트 8
 
0.1%
Other values (3438) 5846
98.4%
2024-01-28T15:38:32.136769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
아 1051
 
2.7%
트 997
 
2.6%
파 875
 
2.3%
교 797
 
2.1%
동 777
 
2.0%
리 749
 
1.9%
지 716
 
1.9%
구 714
 
1.9%
학 631
 
1.6%
( 503
 
1.3%
Other values (606) 30691
79.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 35873
93.2%
Decimal Number 1126
 
2.9%
Open Punctuation 503
 
1.3%
Close Punctuation 503
 
1.3%
Uppercase Letter 279
 
0.7%
Other Punctuation 158
 
0.4%
Lowercase Letter 32
 
0.1%
Space Separator 25
 
0.1%
Dash Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
아 1051
 
2.9%
트 997
 
2.8%
파 875
 
2.4%
교 797
 
2.2%
동 777
 
2.2%
리 749
 
2.1%
지 716
 
2.0%
구 714
 
2.0%
학 631
 
1.8%
인 483
 
1.3%
Other values (556) 28083
78.3%
Uppercase Letter
ValueCountFrequency (%)
S 36
12.9%
K 36
12.9%
T 33
11.8%
G 32
11.5%
C 27
9.7%
L 23
8.2%
H 15
 
5.4%
A 15
 
5.4%
B 12
 
4.3%
I 11
 
3.9%
Other values (12) 39
14.0%
Decimal Number
ValueCountFrequency (%)
1 348
30.9%
2 262
23.3%
3 153
13.6%
0 94
 
8.3%
4 77
 
6.8%
5 59
 
5.2%
6 44
 
3.9%
7 38
 
3.4%
8 26
 
2.3%
9 25
 
2.2%
Lowercase Letter
ValueCountFrequency (%)
e 19
59.4%
s 4
 
12.5%
k 2
 
6.2%
n 1
 
3.1%
t 1
 
3.1%
i 1
 
3.1%
f 1
 
3.1%
m 1
 
3.1%
y 1
 
3.1%
g 1
 
3.1%
Other Punctuation
ValueCountFrequency (%)
. 141
89.2%
· 12
 
7.6%
, 3
 
1.9%
• 2
 
1.3%
Open Punctuation
ValueCountFrequency (%)
( 503
100.0%
Close Punctuation
ValueCountFrequency (%)
) 503
100.0%
Space Separator
ValueCountFrequency (%)
25
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 35873
93.2%
Common 2317
 
6.0%
Latin 311
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
아 1051
 
2.9%
트 997
 
2.8%
파 875
 
2.4%
교 797
 
2.2%
동 777
 
2.2%
리 749
 
2.1%
지 716
 
2.0%
구 714
 
2.0%
학 631
 
1.8%
인 483
 
1.3%
Other values (556) 28083
78.3%
Latin
ValueCountFrequency (%)
S 36
11.6%
K 36
11.6%
T 33
10.6%
G 32
10.3%
C 27
8.7%
L 23
 
7.4%
e 19
 
6.1%
H 15
 
4.8%
A 15
 
4.8%
B 12
 
3.9%
Other values (22) 63
20.3%
Common
ValueCountFrequency (%)
( 503
21.7%
) 503
21.7%
1 348
15.0%
2 262
11.3%
3 153
 
6.6%
. 141
 
6.1%
0 94
 
4.1%
4 77
 
3.3%
5 59
 
2.5%
6 44
 
1.9%
Other values (8) 133
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 35873
93.2%
ASCII 2614
 
6.8%
None 12
 
< 0.1%
Punctuation 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
아 1051
 
2.9%
트 997
 
2.8%
파 875
 
2.4%
교 797
 
2.2%
동 777
 
2.2%
리 749
 
2.1%
지 716
 
2.0%
구 714
 
2.0%
학 631
 
1.8%
인 483
 
1.3%
Other values (556) 28083
78.3%
ASCII
ValueCountFrequency (%)
( 503
19.2%
) 503
19.2%
1 348
13.3%
2 262
10.0%
3 153
 
5.9%
. 141
 
5.4%
0 94
 
3.6%
4 77
 
2.9%
5 59
 
2.3%
6 44
 
1.7%
Other values (38) 430
16.4%
None
ValueCountFrequency (%)
· 12
100.0%
Punctuation
ValueCountFrequency (%)
• 2
100.0%

사물주소
Text

UNIQUE 

Distinct5919
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
2024-01-28T15:38:32.406632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length34
Mean length24.52965
Min length20

Characters and Unicode

Total characters145191
Distinct characters296
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

Unique5919 ?
Unique (%)100.0%

Sample

1st row인천광역시 강화군 양도면 해안서로 471 버스정류장
2nd row인천광역시 강화군 양도면 해안서로 474 버스정류장
3rd row인천광역시 강화군 삼산면 어류정길 37 버스정류장
4th row인천광역시 강화군 삼산면 어류정길 36 버스정류장
5th row인천광역시 강화군 삼산면 상리길 38 버스정류장
ValueCountFrequency (%)
인천광역시 5919
19.2%
버스정류장 5919
19.2%
강화군 1251
 
4.1%
서구 1027
 
3.3%
남동구 749
 
2.4%
부평구 678
 
2.2%
중구 578
 
1.9%
연수구 547
 
1.8%
미추홀구 484
 
1.6%
계양구 440
 
1.4%
Other values (1976) 13265
43.0%
2024-01-28T15:38:32.805010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
24938
 
17.2%
인 6211
 
4.3%
장 6196
 
4.3%
정 6079
 
4.2%
천 6017
 
4.1%
시 6011
 
4.1%
류 5967
 
4.1%
역 5938
 
4.1%
스 5931
 
4.1%
버 5919
 
4.1%
Other values (286) 65984
45.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 102606
70.7%
Space Separator 24938
 
17.2%
Decimal Number 17504
 
12.1%
Dash Punctuation 143
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
인 6211
 
6.1%
장 6196
 
6.0%
정 6079
 
5.9%
천 6017
 
5.9%
시 6011
 
5.9%
류 5967
 
5.8%
역 5938
 
5.8%
스 5931
 
5.8%
버 5919
 
5.8%
광 5919
 
5.8%
Other values (274) 42418
41.3%
Decimal Number
ValueCountFrequency (%)
1 3135
17.9%
2 2351
13.4%
3 1992
11.4%
4 1774
10.1%
5 1575
9.0%
7 1444
8.2%
6 1443
8.2%
8 1356
7.7%
0 1243
 
7.1%
9 1191
 
6.8%
Space Separator
ValueCountFrequency (%)
24938
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 143
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 102606
70.7%
Common 42585
29.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
인 6211
 
6.1%
장 6196
 
6.0%
정 6079
 
5.9%
천 6017
 
5.9%
시 6011
 
5.9%
류 5967
 
5.8%
역 5938
 
5.8%
스 5931
 
5.8%
버 5919
 
5.8%
광 5919
 
5.8%
Other values (274) 42418
41.3%
Common
ValueCountFrequency (%)
24938
58.6%
1 3135
 
7.4%
2 2351
 
5.5%
3 1992
 
4.7%
4 1774
 
4.2%
5 1575
 
3.7%
7 1444
 
3.4%
6 1443
 
3.4%
8 1356
 
3.2%
0 1243
 
2.9%
Other values (2) 1334
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 102606
70.7%
ASCII 42585
29.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
24938
58.6%
1 3135
 
7.4%
2 2351
 
5.5%
3 1992
 
4.7%
4 1774
 
4.2%
5 1575
 
3.7%
7 1444
 
3.4%
6 1443
 
3.4%
8 1356
 
3.2%
0 1243
 
2.9%
Other values (2) 1334
 
3.1%
Hangul
ValueCountFrequency (%)
인 6211
 
6.1%
장 6196
 
6.0%
정 6079
 
5.9%
천 6017
 
5.9%
시 6011
 
5.9%
류 5967
 
5.8%
역 5938
 
5.8%
스 5931
 
5.8%
버 5919
 
5.8%
광 5919
 
5.8%
Other values (274) 42418
41.3%

진행상태
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
사물주소 확정
5919 

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 (%)
사물주소 확정 5919
100.0%

Length

2024-01-28T15:38:32.906445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T15:38:32.974268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사물주소 5919
50.0%
확정 5919
50.0%

확정일자
Date

Distinct120
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size46.4 KiB
Minimum2020-04-14 00:00:00
Maximum2023-01-11 00:00:00
2024-01-28T15:38:33.051884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T15:38:33.140334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-01-28T15:38:30.938437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T15:38:33.201001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구
순번1.0000.987
시군구0.9871.000
2024-01-28T15:38:33.263302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시군구
순번1.0000.795
시군구0.7951.000

Missing values

2024-01-28T15:38:31.030678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T15:38:31.106515image/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

순번시군구사물명사물주소진행상태확정일자
01강화군해망인천광역시 강화군 양도면 해안서로 471 버스정류장사물주소 확정2021-11-29
12강화군해망인천광역시 강화군 양도면 해안서로 474 버스정류장사물주소 확정2021-11-29
23강화군탑재입구인천광역시 강화군 삼산면 어류정길 37 버스정류장사물주소 확정2021-11-29
34강화군탑재입구인천광역시 강화군 삼산면 어류정길 36 버스정류장사물주소 확정2021-11-29
45강화군탄토마을인천광역시 강화군 삼산면 상리길 38 버스정류장사물주소 확정2021-11-29
56강화군탄토 마을인천광역시 강화군 삼산면 상리길 37 버스정류장사물주소 확정2021-11-29
67강화군지석초등학교입구인천광역시 강화군 교동면 교동북1길 51 버스정류장사물주소 확정2021-11-29
78강화군지석리오현부락인천광역시 강화군 교동면 교동북1길 276 버스정류장사물주소 확정2021-10-13
89강화군지석리망향단입구인천광역시 강화군 교동면 교동북1길 192 버스정류장사물주소 확정2021-11-29
910강화군지석리마을회관인천광역시 강화군 교동면 교동북1길 214 버스정류장사물주소 확정2021-11-29
순번시군구사물명사물주소진행상태확정일자
59095910중구을왕리해수욕장인천광역시 중구 용유서로 302 버스정류장사물주소 확정2020-05-22
59105911중구을왕리해수욕장인천광역시 중구 용유서로 311 버스정류장사물주소 확정2020-05-22
59115912중구서해수산연구소인천광역시 중구 선녀바위로 15 버스정류장사물주소 확정2020-05-22
59125913중구서해수산연구소인천광역시 중구 선녀바위로 18 버스정류장사물주소 확정2020-05-22
59135914중구선녀바위유원지인천광역시 중구 선녀바위로 49 버스정류장사물주소 확정2020-05-22
59145915중구덕교동인천광역시 중구 용유로 38 버스정류장사물주소 확정2020-05-22
59155916중구선녀바위유원지인천광역시 중구 선녀바위로 60 버스정류장사물주소 확정2020-05-22
59165917중구덕교동인천광역시 중구 용유로 49 버스정류장사물주소 확정2020-05-22
59175918중구무의도입구인천광역시 중구 영종해안남로 7 버스정류장사물주소 확정2020-05-22
59185919중구무의도입구인천광역시 중구 영종해안남로 10 버스정류장사물주소 확정2020-05-22