Overview

Dataset statistics

Number of variables4
Number of observations5379
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory173.5 KiB
Average record size in memory33.0 B

Variable types

Numeric1
Text1
Categorical2

Dataset

Description합천군 원격검침기 등록현황 데이터는 합천군 관내에 설치되어 있는 원격검침기의 등록일자, 등록 위치 등에 대한 정보를 제공하고 있습니다.
Author경상남도 합천군
URLhttps://www.data.go.kr/data/15104097/fileData.do

Alerts

데이터기준일 has constant value ""Constant
번호 is highly overall correlated with 설치일자High correlation
설치일자 is highly overall correlated with 번호High correlation
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 16:11:08.745071
Analysis finished2023-12-12 16:11:09.762714
Duration1.02 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct5379
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2690
Minimum1
Maximum5379
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size47.4 KiB
2023-12-13T01:11:09.848205image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile269.9
Q11345.5
median2690
Q34034.5
95-th percentile5110.1
Maximum5379
Range5378
Interquartile range (IQR)2689

Descriptive statistics

Standard deviation1552.9279
Coefficient of variation (CV)0.57729661
Kurtosis-1.2
Mean2690
Median Absolute Deviation (MAD)1345
Skewness0
Sum14469510
Variance2411585
MonotonicityStrictly increasing
2023-12-13T01:11:09.980417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
3585 1
 
< 0.1%
3593 1
 
< 0.1%
3592 1
 
< 0.1%
3591 1
 
< 0.1%
3590 1
 
< 0.1%
3589 1
 
< 0.1%
3588 1
 
< 0.1%
3587 1
 
< 0.1%
3586 1
 
< 0.1%
Other values (5369) 5369
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 (%)
5379 1
< 0.1%
5378 1
< 0.1%
5377 1
< 0.1%
5376 1
< 0.1%
5375 1
< 0.1%
5374 1
< 0.1%
5373 1
< 0.1%
5372 1
< 0.1%
5371 1
< 0.1%
5370 1
< 0.1%

설치장소
Text

Distinct4908
Distinct (%)91.2%
Missing0
Missing (%)0.0%
Memory size42.2 KiB
2023-12-13T01:11:10.296076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length32
Mean length17.618888
Min length11

Characters and Unicode

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

Unique

Unique4666 ?
Unique (%)86.7%

Sample

1st row합천군 합천읍 중앙로 50-11
2nd row합천군 합천읍 중앙로 30-8
3rd row합천군 합천읍 중흥길 35-11
4th row합천군 합천읍 중흥길 35-22
5th row합천군 합천읍 중흥길 30-6
ValueCountFrequency (%)
합천군 5379
23.0%
합천읍 2576
 
11.0%
덕곡면 617
 
2.6%
야로면 567
 
2.4%
초계면 559
 
2.4%
용주면 310
 
1.3%
삼가면 304
 
1.3%
옥산로 299
 
1.3%
중앙로 280
 
1.2%
쌍백면 261
 
1.1%
Other values (2356) 12200
52.2%
2023-12-13T01:11:10.754755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
17982
19.0%
천 8088
 
8.5%
합 8039
 
8.5%
군 5380
 
5.7%
1 5190
 
5.5%
길 3261
 
3.4%
2 3252
 
3.4%
로 2854
 
3.0%
면 2803
 
3.0%
읍 2576
 
2.7%
Other values (223) 35347
37.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 54262
57.3%
Decimal Number 19809
 
20.9%
Space Separator 17982
 
19.0%
Dash Punctuation 2573
 
2.7%
Open Punctuation 69
 
0.1%
Close Punctuation 69
 
0.1%
Uppercase Letter 7
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 8088
14.9%
합 8039
14.8%
군 5380
 
9.9%
길 3261
 
6.0%
로 2854
 
5.3%
면 2803
 
5.2%
읍 2576
 
4.7%
야 918
 
1.7%
곡 799
 
1.5%
동 772
 
1.4%
Other values (206) 18772
34.6%
Decimal Number
ValueCountFrequency (%)
1 5190
26.2%
2 3252
16.4%
3 2190
11.1%
0 1939
 
9.8%
4 1734
 
8.8%
5 1354
 
6.8%
8 1136
 
5.7%
6 1058
 
5.3%
7 1054
 
5.3%
9 902
 
4.6%
Uppercase Letter
ValueCountFrequency (%)
B 5
71.4%
A 2
 
28.6%
Space Separator
ValueCountFrequency (%)
17982
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2573
100.0%
Open Punctuation
ValueCountFrequency (%)
( 69
100.0%
Close Punctuation
ValueCountFrequency (%)
) 69
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 54263
57.3%
Common 40502
42.7%
Latin 7
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 8088
14.9%
합 8039
14.8%
군 5380
 
9.9%
길 3261
 
6.0%
로 2854
 
5.3%
면 2803
 
5.2%
읍 2576
 
4.7%
야 918
 
1.7%
곡 799
 
1.5%
동 772
 
1.4%
Other values (207) 18773
34.6%
Common
ValueCountFrequency (%)
17982
44.4%
1 5190
 
12.8%
2 3252
 
8.0%
- 2573
 
6.4%
3 2190
 
5.4%
0 1939
 
4.8%
4 1734
 
4.3%
5 1354
 
3.3%
8 1136
 
2.8%
6 1058
 
2.6%
Other values (4) 2094
 
5.2%
Latin
ValueCountFrequency (%)
B 5
71.4%
A 2
 
28.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 54262
57.3%
ASCII 40509
42.7%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
17982
44.4%
1 5190
 
12.8%
2 3252
 
8.0%
- 2573
 
6.4%
3 2190
 
5.4%
0 1939
 
4.8%
4 1734
 
4.3%
5 1354
 
3.3%
8 1136
 
2.8%
6 1058
 
2.6%
Other values (6) 2101
 
5.2%
Hangul
ValueCountFrequency (%)
천 8088
14.9%
합 8039
14.8%
군 5380
 
9.9%
길 3261
 
6.0%
로 2854
 
5.3%
면 2803
 
5.2%
읍 2576
 
4.7%
야 918
 
1.7%
곡 799
 
1.5%
동 772
 
1.4%
Other values (206) 18772
34.6%
None
ValueCountFrequency (%)
㈜ 1
100.0%

설치일자
Categorical

HIGH CORRELATION 

Distinct29
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size42.2 KiB
2020-12-31
1512 
2022-05-24
1048 
2022-06-03
685 
2021-01-19
507 
2021-09-17
387 
Other values (24)
1240 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row2022-06-03
2nd row2022-06-03
3rd row2022-06-03
4th row2022-06-03
5th row2022-06-03

Common Values

ValueCountFrequency (%)
2020-12-31 1512
28.1%
2022-05-24 1048
19.5%
2022-06-03 685
12.7%
2021-01-19 507
 
9.4%
2021-09-17 387
 
7.2%
2019-12-23 250
 
4.6%
2018-11-25 191
 
3.6%
2019-11-27 160
 
3.0%
2020-07-29 93
 
1.7%
2019-11-26 90
 
1.7%
Other values (19) 456
 
8.5%

Length

2023-12-13T01:11:10.903859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2020-12-31 1512
28.1%
2022-05-24 1048
19.5%
2022-06-03 685
12.7%
2021-01-19 507
 
9.4%
2021-09-17 387
 
7.2%
2019-12-23 250
 
4.6%
2018-11-25 191
 
3.6%
2019-11-27 160
 
3.0%
2020-07-29 93
 
1.7%
2019-11-26 90
 
1.7%
Other values (19) 456
 
8.5%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size42.2 KiB
2022-08-16
5379 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-16
2nd row2022-08-16
3rd row2022-08-16
4th row2022-08-16
5th row2022-08-16

Common Values

ValueCountFrequency (%)
2022-08-16 5379
100.0%

Length

2023-12-13T01:11:11.011576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:11:11.098473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-16 5379
100.0%

Interactions

2023-12-13T01:11:09.439085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:11:11.155516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호설치일자
번호1.0000.876
설치일자0.8761.000
2023-12-13T01:11:11.246211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호설치일자
번호1.0000.550
설치일자0.5501.000

Missing values

2023-12-13T01:11:09.606271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:11:09.715892image/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합천군 합천읍 중앙로 50-112022-06-032022-08-16
12합천군 합천읍 중앙로 30-82022-06-032022-08-16
23합천군 합천읍 중흥길 35-112022-06-032022-08-16
34합천군 합천읍 중흥길 35-222022-06-032022-08-16
45합천군 합천읍 중흥길 30-62022-06-032022-08-16
56합천군 쌍백면 청정로 2752019-11-272022-08-16
67합천군 쌍백면 청정로 121-62019-11-272022-08-16
78합천군 쌍백면 청정로 1172019-11-272022-08-16
89합천군 쌍백면 외초1길 14-132019-11-262022-08-16
910합천군 쌍백면 외초1길302019-11-262022-08-16
번호설치장소설치일자데이터기준일
53695370합천군 덕곡면 본곡리 7522021-09-172022-08-16
53705371합천군 덕곡면 본곡2길 162019-12-232022-08-16
53715372합천군 덕곡면 본곡1길 26-122019-12-232022-08-16
53725373합천군 덕곡면 본곡1길 26-112019-12-232022-08-16
53735374합천군 덕곡면 본곡1길 36-62019-12-232022-08-16
53745375합천군 덕곡면 오광대로 6142019-12-232022-08-16
53755376합천군 덕곡면 오광대로 7472021-09-172022-08-16
53765377합천군 덕곡면 본곡길 97-142021-09-172022-08-16
53775378합천군 덕곡면 본곡리 4302021-09-172022-08-16
53785379합천군 덕곡면 본곡1길 26-262019-12-232022-08-16