Overview

Dataset statistics

Number of variables8
Number of observations359
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.6 KiB
Average record size in memory67.4 B

Variable types

Numeric3
Categorical2
Text1
Boolean2

Dataset

Description경기도 의정부시 관내 버스정보시스템 설치 정류장에 대한 데이터로 번호, 관리기관, 정류장명, 경도, 위도, 발광다이오드(led) 디스플레이 여부, 액정디스플레이(lcd) 여부, 데이터기준일자 등의 데이터로 구성되어 있습니다.
Author경기도 의정부시
URLhttps://www.data.go.kr/data/15042862/fileData.do

Alerts

관리기관 has constant value ""Constant
데이터기준일자 has constant value ""Constant
발광다이오드(led) is highly overall correlated with 번호 and 1 other fieldsHigh correlation
액정디스플레이(lcd) is highly overall correlated with 번호 and 1 other fieldsHigh correlation
번호 is highly overall correlated with 발광다이오드(led) and 1 other fieldsHigh correlation
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:32:07.796320
Analysis finished2023-12-12 07:32:09.321781
Duration1.53 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct359
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean180
Minimum1
Maximum359
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T16:32:09.409483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.9
Q190.5
median180
Q3269.5
95-th percentile341.1
Maximum359
Range358
Interquartile range (IQR)179

Descriptive statistics

Standard deviation103.77861
Coefficient of variation (CV)0.57654784
Kurtosis-1.2
Mean180
Median Absolute Deviation (MAD)90
Skewness0
Sum64620
Variance10770
MonotonicityStrictly increasing
2023-12-12T16:32:09.576004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
248 1
 
0.3%
246 1
 
0.3%
245 1
 
0.3%
244 1
 
0.3%
243 1
 
0.3%
242 1
 
0.3%
241 1
 
0.3%
240 1
 
0.3%
239 1
 
0.3%
Other values (349) 349
97.2%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
359 1
0.3%
358 1
0.3%
357 1
0.3%
356 1
0.3%
355 1
0.3%
354 1
0.3%
353 1
0.3%
352 1
0.3%
351 1
0.3%
350 1
0.3%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
경기도 의정부시
359 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 의정부시
2nd row경기도 의정부시
3rd row경기도 의정부시
4th row경기도 의정부시
5th row경기도 의정부시

Common Values

ValueCountFrequency (%)
경기도 의정부시 359
100.0%

Length

2023-12-12T16:32:09.725441image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:32:09.846232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 359
50.0%
의정부시 359
50.0%

정류장명
Text

Distinct236
Distinct (%)65.7%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T16:32:10.071187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length8.5905292
Min length2

Characters and Unicode

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

Unique

Unique119 ?
Unique (%)33.1%

Sample

1st row가능역.성베드로병원
2nd row가능역.성베드로병원
3rd row녹양역
4th row녹양역
5th row중앙초등학교
ValueCountFrequency (%)
홈플러스 6
 
1.6%
경기도청북부청사 4
 
1.1%
구 3
 
0.8%
호원가든2차아파트 2
 
0.5%
가능역.성베드로병원 2
 
0.5%
녹양역 2
 
0.5%
장암역.석림사입구 2
 
0.5%
의정부여자고등학교후문 2
 
0.5%
금오현대아이파크아파트 2
 
0.5%
의정부면허시험장 2
 
0.5%
Other values (229) 338
92.6%
2023-12-12T16:32:10.443269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
. 131
 
4.2%
트 103
 
3.3%
아 102
 
3.3%
파 94
 
3.0%
교 89
 
2.9%
부 80
 
2.6%
의 71
 
2.3%
지 70
 
2.3%
정 68
 
2.2%
학 61
 
2.0%
Other values (252) 2215
71.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2815
91.3%
Other Punctuation 140
 
4.5%
Decimal Number 79
 
2.6%
Close Punctuation 14
 
0.5%
Open Punctuation 14
 
0.5%
Lowercase Letter 8
 
0.3%
Uppercase Letter 8
 
0.3%
Space Separator 6
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
트 103
 
3.7%
아 102
 
3.6%
파 94
 
3.3%
교 89
 
3.2%
부 80
 
2.8%
의 71
 
2.5%
지 70
 
2.5%
정 68
 
2.4%
학 61
 
2.2%
동 54
 
1.9%
Other values (229) 2023
71.9%
Decimal Number
ValueCountFrequency (%)
2 21
26.6%
1 17
21.5%
3 16
20.3%
5 6
 
7.6%
4 5
 
6.3%
6 4
 
5.1%
8 3
 
3.8%
9 3
 
3.8%
7 2
 
2.5%
0 2
 
2.5%
Uppercase Letter
ValueCountFrequency (%)
T 2
25.0%
B 2
25.0%
R 2
25.0%
C 1
12.5%
I 1
12.5%
Lowercase Letter
ValueCountFrequency (%)
e 4
50.0%
k 2
25.0%
s 2
25.0%
Other Punctuation
ValueCountFrequency (%)
. 131
93.6%
, 9
 
6.4%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2815
91.3%
Common 253
 
8.2%
Latin 16
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
트 103
 
3.7%
아 102
 
3.6%
파 94
 
3.3%
교 89
 
3.2%
부 80
 
2.8%
의 71
 
2.5%
지 70
 
2.5%
정 68
 
2.4%
학 61
 
2.2%
동 54
 
1.9%
Other values (229) 2023
71.9%
Common
ValueCountFrequency (%)
. 131
51.8%
2 21
 
8.3%
1 17
 
6.7%
3 16
 
6.3%
) 14
 
5.5%
( 14
 
5.5%
, 9
 
3.6%
6
 
2.4%
5 6
 
2.4%
4 5
 
2.0%
Other values (5) 14
 
5.5%
Latin
ValueCountFrequency (%)
e 4
25.0%
T 2
12.5%
B 2
12.5%
R 2
12.5%
k 2
12.5%
s 2
12.5%
C 1
 
6.2%
I 1
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2815
91.3%
ASCII 269
 
8.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
. 131
48.7%
2 21
 
7.8%
1 17
 
6.3%
3 16
 
5.9%
) 14
 
5.2%
( 14
 
5.2%
, 9
 
3.3%
6
 
2.2%
5 6
 
2.2%
4 5
 
1.9%
Other values (13) 30
 
11.2%
Hangul
ValueCountFrequency (%)
트 103
 
3.7%
아 102
 
3.6%
파 94
 
3.3%
교 89
 
3.2%
부 80
 
2.8%
의 71
 
2.5%
지 70
 
2.5%
정 68
 
2.4%
학 61
 
2.2%
동 54
 
1.9%
Other values (229) 2023
71.9%

위도
Real number (ℝ)

Distinct341
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.741186
Minimum37.6947
Maximum37.767383
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T16:32:10.585037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.6947
5-th percentile37.712681
Q137.73487
median37.743033
Q337.750525
95-th percentile37.757343
Maximum37.767383
Range0.072683
Interquartile range (IQR)0.015655145

Descriptive statistics

Standard deviation0.013167894
Coefficient of variation (CV)0.00034889984
Kurtosis1.3110164
Mean37.741186
Median Absolute Deviation (MAD)0.007698
Skewness-1.0638863
Sum13549.086
Variance0.00017339342
MonotonicityNot monotonic
2023-12-12T16:32:10.728224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.735683 3
 
0.8%
37.748283 3
 
0.8%
37.742433 2
 
0.6%
37.7452 2
 
0.6%
37.742283 2
 
0.6%
37.737417 2
 
0.6%
37.741667 2
 
0.6%
37.752083 2
 
0.6%
37.754667 2
 
0.6%
37.743033 2
 
0.6%
Other values (331) 337
93.9%
ValueCountFrequency (%)
37.6947 1
0.3%
37.694783 1
0.3%
37.700017 1
0.3%
37.700167 1
0.3%
37.702467 1
0.3%
37.7029 1
0.3%
37.704683 1
0.3%
37.705233 1
0.3%
37.70545 1
0.3%
37.705583 1
0.3%
ValueCountFrequency (%)
37.767383 1
0.3%
37.767 1
0.3%
37.7655 1
0.3%
37.76525 1
0.3%
37.76495 1
0.3%
37.764417 1
0.3%
37.7622 1
0.3%
37.761983 1
0.3%
37.760183 1
0.3%
37.759867 1
0.3%

경도
Real number (ℝ)

Distinct351
Distinct (%)97.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.0671
Minimum127.01328
Maximum127.7307
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.3 KiB
2023-12-12T16:32:10.859074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.01328
5-th percentile127.03283
Q1127.04379
median127.05873
Q3127.08795
95-th percentile127.11266
Maximum127.7307
Range0.717414
Interquartile range (IQR)0.0441585

Descriptive statistics

Standard deviation0.043950194
Coefficient of variation (CV)0.00034588177
Kurtosis144.85553
Mean127.0671
Median Absolute Deviation (MAD)0.017984
Skewness9.7274356
Sum45617.09
Variance0.0019316196
MonotonicityNot monotonic
2023-12-12T16:32:10.982683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.09035 2
 
0.6%
127.055783 2
 
0.6%
127.04745 2
 
0.6%
127.096083 2
 
0.6%
127.03455 2
 
0.6%
127.047917 2
 
0.6%
127.043317 2
 
0.6%
127.0583 2
 
0.6%
127.09745 1
 
0.3%
127.093783 1
 
0.3%
Other values (341) 341
95.0%
ValueCountFrequency (%)
127.013283 1
0.3%
127.01786 1
0.3%
127.0219 1
0.3%
127.023033 1
0.3%
127.023183 1
0.3%
127.026233 1
0.3%
127.0267 1
0.3%
127.026967 1
0.3%
127.0279 1
0.3%
127.029085 1
0.3%
ValueCountFrequency (%)
127.730697 1
0.3%
127.11814 1
0.3%
127.117883 1
0.3%
127.117764 1
0.3%
127.117567 1
0.3%
127.117045 1
0.3%
127.117 1
0.3%
127.1164 1
0.3%
127.116284 1
0.3%
127.115633 1
0.3%

발광다이오드(led)
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size491.0 B
False
249 
True
110 
ValueCountFrequency (%)
False 249
69.4%
True 110
30.6%
2023-12-12T16:32:11.125743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

액정디스플레이(lcd)
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size491.0 B
True
249 
False
110 
ValueCountFrequency (%)
True 249
69.4%
False 110
30.6%
2023-12-12T16:32:11.207047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-01-01
359 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-01-01
2nd row2023-01-01
3rd row2023-01-01
4th row2023-01-01
5th row2023-01-01

Common Values

ValueCountFrequency (%)
2023-01-01 359
100.0%

Length

2023-12-12T16:32:11.314635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:32:11.398307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-01-01 359
100.0%

Interactions

2023-12-12T16:32:08.706354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.074731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.418718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.799132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.160098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.515463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.916486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.300616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:32:08.606653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:32:11.449327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호위도경도발광다이오드(led)액정디스플레이(lcd)
번호1.0000.4760.5010.8670.867
위도0.4761.0000.1490.2760.276
경도0.5010.1491.0000.0170.017
발광다이오드(led)0.8670.2760.0171.0001.000
액정디스플레이(lcd)0.8670.2760.0171.0001.000
2023-12-12T16:32:11.533658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발광다이오드(led)액정디스플레이(lcd)
발광다이오드(led)1.0000.993
액정디스플레이(lcd)0.9931.000
2023-12-12T16:32:11.619570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호위도경도발광다이오드(led)액정디스플레이(lcd)
번호1.0000.1240.2610.6920.692
위도0.1241.0000.0550.2090.209
경도0.2610.0551.0000.0280.028
발광다이오드(led)0.6920.2090.0281.0000.993
액정디스플레이(lcd)0.6920.2090.0280.9931.000

Missing values

2023-12-12T16:32:09.073182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:32:09.246101image/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

번호관리기관정류장명위도경도발광다이오드(led)액정디스플레이(lcd)데이터기준일자
01경기도 의정부시가능역.성베드로병원37.747633127.045283YN2023-01-01
12경기도 의정부시가능역.성베드로병원37.748133127.045467YN2023-01-01
23경기도 의정부시녹양역37.760183127.043117YN2023-01-01
34경기도 의정부시녹양역37.75975127.042617YN2023-01-01
45경기도 의정부시중앙초등학교37.745083127.046267YN2023-01-01
56경기도 의정부시의정부부대찌개거리.중앙역37.74385127.0503NY2023-01-01
67경기도 의정부시의정부부대찌개거리.중앙역37.7435127.049YN2023-01-01
78경기도 의정부시의정부역.흥선지하도입구37.741183127.046967YN2023-01-01
89경기도 의정부시의정부역.동부광장37.739567127.047667YN2023-01-01
910경기도 의정부시의정부역.농협앞37.741483127.047183YN2023-01-01
번호관리기관정류장명위도경도발광다이오드(led)액정디스플레이(lcd)데이터기준일자
349350경기도 의정부시청구아파트37.736787127.09523YN2023-01-01
350351경기도 의정부시경기도교육북부청사37.750379127.051974YN2023-01-01
351352경기도 의정부시곤제역37.750937127.084047YN2023-01-01
352353경기도 의정부시가능역(마을)37.748796127.045067YN2023-01-01
353354경기도 의정부시광동고앞37.754502127.037721YN2023-01-01
354355경기도 의정부시의정부법원,검찰청입구37.753005127.035659YN2023-01-01
355356경기도 의정부시민락푸루지오아파트37.751692127.112161YN2023-01-01
356357경기도 의정부시만가대사거리37.729969127.084421YN2023-01-01
357358경기도 의정부시현대힐스테이트아파트37.755234127.041071YN2023-01-01
358359경기도 의정부시현대힐스테이트아파트37.755014127.041165YN2023-01-01