Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows545
Duplicate rows (%)5.5%
Total size in memory566.4 KiB
Average record size in memory58.0 B

Variable types

Text1
Numeric2
Categorical3

Dataset

Description울산광역시 울주군 가로등에 대한 현황 자료로 관리번호, 위도, 경도, 관리기관전화번호, 관리기관명에 대한 자료를 제공합니다.
Author울산광역시 울주군
URLhttps://www.data.go.kr/data/15127428/fileData.do

Alerts

관리기관전화번호 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 545 (5.5%) duplicate rowsDuplicates
위도 is highly overall correlated with 경도High correlation
경도 is highly overall correlated with 위도High correlation

Reproduction

Analysis started2024-04-06 08:08:42.027466
Analysis finished2024-04-06 08:08:44.630279
Duration2.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

관리번호
Text

Distinct9433
Distinct (%)94.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-06T17:08:45.131815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length7
Mean length7.1788
Min length4

Characters and Unicode

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

Unique

Unique8866 ?
Unique (%)88.7%

Sample

1st row범서99_20
2nd row온양16_16
3rd row청량38_24
4th row청량01_24
5th row청량44_26
ValueCountFrequency (%)
삼남85_하부 3
 
< 0.1%
삼남11_18 2
 
< 0.1%
상북56_09 2
 
< 0.1%
웅촌09_02 2
 
< 0.1%
삼남72_01 2
 
< 0.1%
삼남08_14 2
 
< 0.1%
온산95_09 2
 
< 0.1%
온산85_04 2
 
< 0.1%
온산84_08 2
 
< 0.1%
온산12_05 2
 
< 0.1%
Other values (9426) 9986
99.8%
2024-04-06T17:08:45.992442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 9218
 
12.8%
0 7938
 
11.1%
1 7648
 
10.7%
2 4692
 
6.5%
3 3519
 
4.9%
4 3133
 
4.4%
5 3120
 
4.3%
6 2876
 
4.0%
7 2652
 
3.7%
서 2413
 
3.4%
Other values (61) 24579
34.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 40141
55.9%
Other Letter 20703
28.8%
Connector Punctuation 9218
 
12.8%
Dash Punctuation 1218
 
1.7%
Uppercase Letter 501
 
0.7%
Space Separator 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
서 2413
11.7%
온 2262
10.9%
양 2045
9.9%
산 1634
 
7.9%
범 1436
 
6.9%
언 1408
 
6.8%
삼 1392
 
6.7%
남 1286
 
6.2%
청 1080
 
5.2%
량 1080
 
5.2%
Other values (45) 4667
22.5%
Decimal Number
ValueCountFrequency (%)
0 7938
19.8%
1 7648
19.1%
2 4692
11.7%
3 3519
8.8%
4 3133
 
7.8%
5 3120
 
7.8%
6 2876
 
7.2%
7 2652
 
6.6%
8 2400
 
6.0%
9 2163
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
L 250
49.9%
P 250
49.9%
C 1
 
0.2%
Connector Punctuation
ValueCountFrequency (%)
_ 9218
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1218
100.0%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 50584
70.5%
Hangul 20703
28.8%
Latin 501
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
서 2413
11.7%
온 2262
10.9%
양 2045
9.9%
산 1634
 
7.9%
범 1436
 
6.9%
언 1408
 
6.8%
삼 1392
 
6.7%
남 1286
 
6.2%
청 1080
 
5.2%
량 1080
 
5.2%
Other values (45) 4667
22.5%
Common
ValueCountFrequency (%)
_ 9218
18.2%
0 7938
15.7%
1 7648
15.1%
2 4692
9.3%
3 3519
 
7.0%
4 3133
 
6.2%
5 3120
 
6.2%
6 2876
 
5.7%
7 2652
 
5.2%
8 2400
 
4.7%
Other values (3) 3388
 
6.7%
Latin
ValueCountFrequency (%)
L 250
49.9%
P 250
49.9%
C 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 51085
71.2%
Hangul 20703
28.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 9218
18.0%
0 7938
15.5%
1 7648
15.0%
2 4692
9.2%
3 3519
 
6.9%
4 3133
 
6.1%
5 3120
 
6.1%
6 2876
 
5.6%
7 2652
 
5.2%
8 2400
 
4.7%
Other values (6) 3889
7.6%
Hangul
ValueCountFrequency (%)
서 2413
11.7%
온 2262
10.9%
양 2045
9.9%
산 1634
 
7.9%
범 1436
 
6.9%
언 1408
 
6.8%
삼 1392
 
6.7%
남 1286
 
6.2%
청 1080
 
5.2%
량 1080
 
5.2%
Other values (45) 4667
22.5%

위도
Real number (ℝ)

HIGH CORRELATION 

Distinct8889
Distinct (%)88.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.51403
Minimum35.339826
Maximum35.718801
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:08:46.311548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum35.339826
5-th percentile35.365785
Q135.45219
median35.546617
Q335.565559
95-th percentile35.616802
Maximum35.718801
Range0.37897506
Interquartile range (IQR)0.11336926

Descriptive statistics

Standard deviation0.079346186
Coefficient of variation (CV)0.0022342208
Kurtosis-0.27966199
Mean35.51403
Median Absolute Deviation (MAD)0.05032355
Skewness-0.092058626
Sum355140.3
Variance0.0062958173
MonotonicityNot monotonic
2024-04-06T17:08:46.604915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.5571173 5
 
0.1%
35.5634846 4
 
< 0.1%
35.5476868 4
 
< 0.1%
35.5718277 4
 
< 0.1%
35.5367056 4
 
< 0.1%
35.4643479 4
 
< 0.1%
35.5498924 4
 
< 0.1%
35.573228 4
 
< 0.1%
35.4684767 4
 
< 0.1%
35.4656522 4
 
< 0.1%
Other values (8879) 9959
99.6%
ValueCountFrequency (%)
35.33982584 1
< 0.1%
35.3406505 1
< 0.1%
35.3407887 1
< 0.1%
35.3410475 1
< 0.1%
35.34105514 1
< 0.1%
35.3412553 1
< 0.1%
35.3415018 1
< 0.1%
35.3417377 1
< 0.1%
35.3418375 1
< 0.1%
35.3419281 1
< 0.1%
ValueCountFrequency (%)
35.7188009 1
< 0.1%
35.718537 1
< 0.1%
35.7181744 1
< 0.1%
35.7175898 1
< 0.1%
35.7173493 1
< 0.1%
35.7170701 1
< 0.1%
35.71587257 1
< 0.1%
35.7157532 1
< 0.1%
35.7157427 1
< 0.1%
35.715541 1
< 0.1%

경도
Real number (ℝ)

HIGH CORRELATION 

Distinct8882
Distinct (%)88.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean129.22039
Minimum129.00982
Maximum129.36357
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:08:46.931608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum129.00982
5-th percentile129.08248
Q1129.13867
median129.23273
Q3129.30671
95-th percentile129.34147
Maximum129.36357
Range0.353745
Interquartile range (IQR)0.16804575

Descriptive statistics

Standard deviation0.090366498
Coefficient of variation (CV)0.00069932075
Kurtosis-1.2554949
Mean129.22039
Median Absolute Deviation (MAD)0.08419045
Skewness-0.17242049
Sum1292203.9
Variance0.008166104
MonotonicityNot monotonic
2024-04-06T17:08:47.266637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
129.3043649 5
 
0.1%
129.2636112 5
 
0.1%
129.1331614 4
 
< 0.1%
129.1313091 4
 
< 0.1%
129.1440535 4
 
< 0.1%
129.1392928 4
 
< 0.1%
129.1405971 4
 
< 0.1%
129.1305676 4
 
< 0.1%
129.3410451 4
 
< 0.1%
129.3367085 4
 
< 0.1%
Other values (8872) 9958
99.6%
ValueCountFrequency (%)
129.0098249 1
< 0.1%
129.009843 1
< 0.1%
129.0099314 1
< 0.1%
129.0100298 1
< 0.1%
129.0100362 1
< 0.1%
129.0110686 1
< 0.1%
129.0111167 1
< 0.1%
129.0114546 1
< 0.1%
129.0116934 1
< 0.1%
129.0122354 1
< 0.1%
ValueCountFrequency (%)
129.3635699 1
< 0.1%
129.3634096 1
< 0.1%
129.3631572 1
< 0.1%
129.3630078 1
< 0.1%
129.3626059 1
< 0.1%
129.3626031 2
< 0.1%
129.3625998 2
< 0.1%
129.3625973 1
< 0.1%
129.3625952 1
< 0.1%
129.3625913 2
< 0.1%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
052-204-2452
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row052-204-2452
2nd row052-204-2452
3rd row052-204-2452
4th row052-204-2452
5th row052-204-2452

Common Values

ValueCountFrequency (%)
052-204-2452 10000
100.0%

Length

2024-04-06T17:08:47.536866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:08:47.721815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
052-204-2452 10000
100.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
울산광역시 울주군청
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산광역시 울주군청
2nd row울산광역시 울주군청
3rd row울산광역시 울주군청
4th row울산광역시 울주군청
5th row울산광역시 울주군청

Common Values

ValueCountFrequency (%)
울산광역시 울주군청 10000
100.0%

Length

2024-04-06T17:08:47.930436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:08:48.188822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
울산광역시 10000
50.0%
울주군청 10000
50.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-29
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-03-29
2nd row2024-03-29
3rd row2024-03-29
4th row2024-03-29
5th row2024-03-29

Common Values

ValueCountFrequency (%)
2024-03-29 10000
100.0%

Length

2024-04-06T17:08:48.373393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:08:48.566144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-29 10000
100.0%

Interactions

2024-04-06T17:08:43.406522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:08:42.842412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:08:43.997666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:08:43.131316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:08:48.688609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.872
경도0.8721.000
2024-04-06T17:08:48.860496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.000-0.717
경도-0.7171.000

Missing values

2024-04-06T17:08:44.315233image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:08:44.526830image/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

관리번호위도경도관리기관전화번호관리기관명데이터기준일자
2509범서99_2035.55813129.235383052-204-2452울산광역시 울주군청2024-03-29
9681온양16_1635.406907129.290201052-204-2452울산광역시 울주군청2024-03-29
11179청량38_2435.476622129.321831052-204-2452울산광역시 울주군청2024-03-29
10296청량01_2435.532839129.251033052-204-2452울산광역시 울주군청2024-03-29
11352청량44_2635.46926129.315813052-204-2452울산광역시 울주군청2024-03-29
10521청량16_1835.486539129.303928052-204-2452울산광역시 울주군청2024-03-29
625두서30_1035.697116129.192259052-204-2452울산광역시 울주군청2024-03-29
7377온산04_0235.469189129.335548052-204-2452울산광역시 울주군청2024-03-29
5195상북55_1935.609354129.070806052-204-2452울산광역시 울주군청2024-03-29
1383범서39_1135.574952129.257103052-204-2452울산광역시 울주군청2024-03-29
관리번호위도경도관리기관전화번호관리기관명데이터기준일자
5751서생35_0735.384637129.343637052-204-2452울산광역시 울주군청2024-03-29
2088범서71_1135.571887129.197311052-204-2452울산광역시 울주군청2024-03-29
13666청량77-0535.491703129.304655052-204-2452울산광역시 울주군청2024-03-29
13253서생72_0235.352491129.314091052-204-2452울산광역시 울주군청2024-03-29
3599삼남61_1335.521883129.094451052-204-2452울산광역시 울주군청2024-03-29
8419온산50_0235.426104129.314598052-204-2452울산광역시 울주군청2024-03-29
1581범서50_0735.561839129.248547052-204-2452울산광역시 울주군청2024-03-29
121두동06_1335.715873129.201581052-204-2452울산광역시 울주군청2024-03-29
6682언양50_1435.549143129.165467052-204-2452울산광역시 울주군청2024-03-29
2762삼남09_1935.552787129.139118052-204-2452울산광역시 울주군청2024-03-29

Duplicate rows

Most frequently occurring

관리번호위도경도관리기관전화번호관리기관명데이터기준일자# duplicates
0두동04_0335.709431129.204256052-204-2452울산광역시 울주군청2024-03-292
1두동05_1535.709186129.204208052-204-2452울산광역시 울주군청2024-03-292
2두동06_0435.713966129.203476052-204-2452울산광역시 울주군청2024-03-292
3두동06_0735.714616129.202743052-204-2452울산광역시 울주군청2024-03-292
4두동06_1035.715102129.20229052-204-2452울산광역시 울주군청2024-03-292
5두동07_0335.71546129.201678052-204-2452울산광역시 울주군청2024-03-292
6두동13_1835.608051129.164872052-204-2452울산광역시 울주군청2024-03-292
7두동13_2135.61257129.157749052-204-2452울산광역시 울주군청2024-03-292
8범서02_1435.576906129.197379052-204-2452울산광역시 울주군청2024-03-292
9범서03_0935.571943129.20069052-204-2452울산광역시 울주군청2024-03-292