Overview

Dataset statistics

Number of variables7
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory59.3 B

Variable types

Text2
Numeric2
Categorical2
DateTime1

Dataset

Description제설함 설치현황(제설함관리번호, 소재지지번주소, 위도, 경도, 관리기관명, 관리기관전화번호, 데이터기준일자)로 구성되어 있음
Author경기도 동두천시
URLhttps://www.data.go.kr/data/15042648/fileData.do

Alerts

관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
제설함관리번호 has unique valuesUnique
위도 has unique valuesUnique
경도 has unique valuesUnique

Reproduction

Analysis started2024-03-15 00:04:35.119683
Analysis finished2024-03-15 00:04:37.417525
Duration2.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제설함관리번호
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
2024-03-15T09:04:38.494675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length5.6
Min length5

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row못골로01
2nd row못골로02
3rd row못골로03
4th row못골로04
5th row못골로05
ValueCountFrequency (%)
못골로01 1
 
1.0%
장고갯로03 1
 
1.0%
평화로04 1
 
1.0%
평화로03 1
 
1.0%
평화로02 1
 
1.0%
평화로01 1
 
1.0%
정고갯로08 1
 
1.0%
장고갯로10 1
 
1.0%
장고갯로09 1
 
1.0%
장고갯로07 1
 
1.0%
Other values (90) 90
90.0%
2024-03-15T09:04:40.050157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
로 100
17.9%
0 55
 
9.8%
삼 50
 
8.9%
육 50
 
8.9%
사 50
 
8.9%
1 33
 
5.9%
2 21
 
3.8%
선 20
 
3.6%
3 20
 
3.6%
4 20
 
3.6%
Other values (14) 141
25.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 360
64.3%
Decimal Number 200
35.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 100
27.8%
삼 50
13.9%
육 50
13.9%
사 50
13.9%
선 20
 
5.6%
행 20
 
5.6%
고 10
 
2.8%
화 10
 
2.8%
평 10
 
2.8%
갯 10
 
2.8%
Other values (4) 30
 
8.3%
Decimal Number
ValueCountFrequency (%)
0 55
27.5%
1 33
16.5%
2 21
 
10.5%
3 20
 
10.0%
4 20
 
10.0%
5 11
 
5.5%
9 10
 
5.0%
8 10
 
5.0%
6 10
 
5.0%
7 10
 
5.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 360
64.3%
Common 200
35.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 100
27.8%
삼 50
13.9%
육 50
13.9%
사 50
13.9%
선 20
 
5.6%
행 20
 
5.6%
고 10
 
2.8%
화 10
 
2.8%
평 10
 
2.8%
갯 10
 
2.8%
Other values (4) 30
 
8.3%
Common
ValueCountFrequency (%)
0 55
27.5%
1 33
16.5%
2 21
 
10.5%
3 20
 
10.0%
4 20
 
10.0%
5 11
 
5.5%
9 10
 
5.0%
8 10
 
5.0%
6 10
 
5.0%
7 10
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 360
64.3%
ASCII 200
35.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
로 100
27.8%
삼 50
13.9%
육 50
13.9%
사 50
13.9%
선 20
 
5.6%
행 20
 
5.6%
고 10
 
2.8%
화 10
 
2.8%
평 10
 
2.8%
갯 10
 
2.8%
Other values (4) 30
 
8.3%
ASCII
ValueCountFrequency (%)
0 55
27.5%
1 33
16.5%
2 21
 
10.5%
3 20
 
10.0%
4 20
 
10.0%
5 11
 
5.5%
9 10
 
5.0%
8 10
 
5.0%
6 10
 
5.0%
7 10
 
5.0%

소재지지번주소
Text

Distinct89
Distinct (%)89.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
2024-03-15T09:04:41.074031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length17.78
Min length15

Characters and Unicode

Total characters1778
Distinct characters32
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

Unique81 ?
Unique (%)81.0%

Sample

1st row경기도 동두천시 생연동 산59
2nd row경기도 동두천시 생연동 89-1
3rd row경기도 동두천시 생연동 89-1
4th row경기도 동두천시 생연동 95-2
5th row경기도 동두천시 생연동 89-1
ValueCountFrequency (%)
경기도 100
25.0%
동두천시 100
25.0%
생연동 41
10.2%
지행동 18
 
4.5%
광암동 18
 
4.5%
상패동 13
 
3.2%
하봉암동 6
 
1.5%
송내동 4
 
1.0%
89-1 4
 
1.0%
354 3
 
0.8%
Other values (86) 93
23.2%
2024-03-15T09:04:42.720065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
300
16.9%
동 200
 
11.2%
경 100
 
5.6%
기 100
 
5.6%
도 100
 
5.6%
두 100
 
5.6%
천 100
 
5.6%
시 100
 
5.6%
- 82
 
4.6%
1 81
 
4.6%
Other values (22) 515
29.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1008
56.7%
Decimal Number 388
 
21.8%
Space Separator 300
 
16.9%
Dash Punctuation 82
 
4.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 200
19.8%
경 100
9.9%
기 100
9.9%
도 100
9.9%
두 100
9.9%
천 100
9.9%
시 100
9.9%
연 41
 
4.1%
생 41
 
4.1%
암 24
 
2.4%
Other values (10) 102
10.1%
Decimal Number
ValueCountFrequency (%)
1 81
20.9%
3 61
15.7%
2 50
12.9%
5 36
9.3%
8 33
8.5%
9 30
 
7.7%
4 29
 
7.5%
0 26
 
6.7%
6 22
 
5.7%
7 20
 
5.2%
Space Separator
ValueCountFrequency (%)
300
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 82
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1008
56.7%
Common 770
43.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 200
19.8%
경 100
9.9%
기 100
9.9%
도 100
9.9%
두 100
9.9%
천 100
9.9%
시 100
9.9%
연 41
 
4.1%
생 41
 
4.1%
암 24
 
2.4%
Other values (10) 102
10.1%
Common
ValueCountFrequency (%)
300
39.0%
- 82
 
10.6%
1 81
 
10.5%
3 61
 
7.9%
2 50
 
6.5%
5 36
 
4.7%
8 33
 
4.3%
9 30
 
3.9%
4 29
 
3.8%
0 26
 
3.4%
Other values (2) 42
 
5.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1008
56.7%
ASCII 770
43.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
300
39.0%
- 82
 
10.6%
1 81
 
10.5%
3 61
 
7.9%
2 50
 
6.5%
5 36
 
4.7%
8 33
 
4.3%
9 30
 
3.9%
4 29
 
3.8%
0 26
 
3.4%
Other values (2) 42
 
5.5%
Hangul
ValueCountFrequency (%)
동 200
19.8%
경 100
9.9%
기 100
9.9%
도 100
9.9%
두 100
9.9%
천 100
9.9%
시 100
9.9%
연 41
 
4.1%
생 41
 
4.1%
암 24
 
2.4%
Other values (10) 102
10.1%

위도
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.901036
Minimum37.873294
Maximum37.974463
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-15T09:04:43.170449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.873294
5-th percentile37.888448
Q137.89402
median37.894942
Q337.905875
95-th percentile37.957935
Maximum37.974463
Range0.1011693
Interquartile range (IQR)0.01185537

Descriptive statistics

Standard deviation0.018019459
Coefficient of variation (CV)0.00047543448
Kurtosis8.6331499
Mean37.901036
Median Absolute Deviation (MAD)0.003593775
Skewness2.8561176
Sum3790.1036
Variance0.00032470091
MonotonicityNot monotonic
2024-03-15T09:04:43.772255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.90642096 1
 
1.0%
37.89805599 1
 
1.0%
37.95869391 1
 
1.0%
37.95873311 1
 
1.0%
37.97255095 1
 
1.0%
37.97238955 1
 
1.0%
37.97446291 1
 
1.0%
37.89754564 1
 
1.0%
37.89673062 1
 
1.0%
37.89729826 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
37.87329361 1
1.0%
37.88121595 1
1.0%
37.88129651 1
1.0%
37.88146857 1
1.0%
37.88840385 1
1.0%
37.88844983 1
1.0%
37.88848004 1
1.0%
37.88863768 1
1.0%
37.88865119 1
1.0%
37.88866659 1
1.0%
ValueCountFrequency (%)
37.97446291 1
1.0%
37.97255095 1
1.0%
37.97238955 1
1.0%
37.95873311 1
1.0%
37.95869391 1
1.0%
37.95789461 1
1.0%
37.91286714 1
1.0%
37.91201715 1
1.0%
37.91147631 1
1.0%
37.90810861 1
1.0%

경도
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.06534
Minimum127.03558
Maximum127.0878
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-15T09:04:44.290283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.03558
5-th percentile127.03848
Q1127.05951
median127.06518
Q3127.07492
95-th percentile127.08381
Maximum127.0878
Range0.0522207
Interquartile range (IQR)0.0154116

Descriptive statistics

Standard deviation0.013373117
Coefficient of variation (CV)0.00010524599
Kurtosis-0.21698931
Mean127.06534
Median Absolute Deviation (MAD)0.0065565
Skewness-0.50996409
Sum12706.534
Variance0.00017884027
MonotonicityNot monotonic
2024-03-15T09:04:44.838371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.0693916 1
 
1.0%
127.0596201 1
 
1.0%
127.0627375 1
 
1.0%
127.0628121 1
 
1.0%
127.0674274 1
 
1.0%
127.0668701 1
 
1.0%
127.0663862 1
 
1.0%
127.0589437 1
 
1.0%
127.0582888 1
 
1.0%
127.0587341 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
127.0355792 1
1.0%
127.0361271 1
1.0%
127.0375068 1
1.0%
127.0375084 1
1.0%
127.0378311 1
1.0%
127.0385158 1
1.0%
127.0391915 1
1.0%
127.0398391 1
1.0%
127.0406047 1
1.0%
127.0412169 1
1.0%
ValueCountFrequency (%)
127.0877999 1
1.0%
127.0874351 1
1.0%
127.0865788 1
1.0%
127.0857794 1
1.0%
127.0848299 1
1.0%
127.0837549 1
1.0%
127.0832431 1
1.0%
127.0831319 1
1.0%
127.0830888 1
1.0%
127.0827471 1
1.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
경기도 동두천시청 도로과
100 

Length

Max length13
Median length13
Mean length13
Min length13

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도 동두천시청 도로과
2nd row경기도 동두천시청 도로과
3rd row경기도 동두천시청 도로과
4th row경기도 동두천시청 도로과
5th row경기도 동두천시청 도로과

Common Values

ValueCountFrequency (%)
경기도 동두천시청 도로과 100
100.0%

Length

2024-03-15T09:04:45.315877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:04:45.939311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 100
33.3%
동두천시청 100
33.3%
도로과 100
33.3%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
031-860-2297
100 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-860-2297
2nd row031-860-2297
3rd row031-860-2297
4th row031-860-2297
5th row031-860-2297

Common Values

ValueCountFrequency (%)
031-860-2297 100
100.0%

Length

2024-03-15T09:04:46.243051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T09:04:46.423549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-860-2297 100
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size928.0 B
Minimum2024-01-02 00:00:00
Maximum2024-01-02 00:00:00
2024-03-15T09:04:46.559424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:04:46.830772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T09:04:36.084232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:04:35.572821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:04:36.400434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T09:04:35.829215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T09:04:47.032168image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제설함관리번호소재지지번주소위도경도
제설함관리번호1.0001.0001.0001.000
소재지지번주소1.0001.0001.0001.000
위도1.0001.0001.0000.848
경도1.0001.0000.8481.000
2024-03-15T09:04:47.190443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.197
경도-0.1971.000

Missing values

2024-03-15T09:04:36.835467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T09:04:37.250798image/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못골로01경기도 동두천시 생연동 산5937.906421127.069392경기도 동두천시청 도로과031-860-22972024-01-02
1못골로02경기도 동두천시 생연동 89-137.906448127.069795경기도 동두천시청 도로과031-860-22972024-01-02
2못골로03경기도 동두천시 생연동 89-137.905915127.07013경기도 동두천시청 도로과031-860-22972024-01-02
3못골로04경기도 동두천시 생연동 95-237.905862127.070521경기도 동두천시청 도로과031-860-22972024-01-02
4못골로05경기도 동두천시 생연동 89-137.905183127.070358경기도 동두천시청 도로과031-860-22972024-01-02
5못골로06경기도 동두천시 생연동 89-137.904753127.070572경기도 동두천시청 도로과031-860-22972024-01-02
6못골로07경기도 동두천시 생연동 91-137.904081127.069955경기도 동두천시청 도로과031-860-22972024-01-02
7못골로08경기도 동두천시 생연동 85-2237.903879127.070121경기도 동두천시청 도로과031-860-22972024-01-02
8못골로09경기도 동두천시 생연동 85-1037.903624127.069895경기도 동두천시청 도로과031-860-22972024-01-02
9못골로10경기도 동두천시 생연동 82-237.902936127.070165경기도 동두천시청 도로과031-860-22972024-01-02
제설함관리번호소재지지번주소위도경도관리기관명관리기관전화번호데이터기준일자
90행선로11경기도 동두천시 지행동 367-837.88943127.060519경기도 동두천시청 도로과031-860-22972024-01-02
91행선로12경기도 동두천시 지행동 365-1037.889139127.060777경기도 동두천시청 도로과031-860-22972024-01-02
92행선로13경기도 동두천시 지행동 351-3337.888699127.060438경기도 동두천시청 도로과031-860-22972024-01-02
93행선로14경기도 동두천시 지행동 365-437.888638127.060778경기도 동두천시청 도로과031-860-22972024-01-02
94행선로15경기도 동두천시 지행동 351-1837.888651127.060262경기도 동두천시청 도로과031-860-22972024-01-02
95행선로16경기도 동두천시 지행동 359-237.888404127.059924경기도 동두천시청 도로과031-860-22972024-01-02
96행선로17경기도 동두천시 지행동 35437.888667127.059582경기도 동두천시청 도로과031-860-22972024-01-02
97행선로18경기도 동두천시 지행동 358-237.88845127.059303경기도 동두천시청 도로과031-860-22972024-01-02
98행선로19경기도 동두천시 지행동 35437.888697127.05892경기도 동두천시청 도로과031-860-22972024-01-02
99행선로20경기도 동두천시 지행동 357-337.88848127.058505경기도 동두천시청 도로과031-860-22972024-01-02