Overview

Dataset statistics

Number of variables7
Number of observations52
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory61.5 B

Variable types

Numeric2
Categorical4
Text1

Dataset

Description경남 함양군 관내 의류수거함 위치정보 현황으로 연번, 관리번호, 관리단체명, 설치장소명, 설치수량 으로 구성되어 있습니다.
Author경상남도 함양군
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15127178

Alerts

관리단체명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 is highly overall correlated with 관리번호High correlation
관리번호 is highly overall correlated with 연번High correlation
행정동 is highly imbalanced (86.3%)Imbalance
설치수량 is highly imbalanced (60.9%)Imbalance
연번 has unique valuesUnique
관리번호 has unique valuesUnique
설치장소명 has unique valuesUnique

Reproduction

Analysis started2024-03-23 07:18:35.895873
Analysis finished2024-03-23 07:18:38.890993
Duration3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.5
Minimum1
Maximum52
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2024-03-23T07:18:39.193128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.55
Q113.75
median26.5
Q339.25
95-th percentile49.45
Maximum52
Range51
Interquartile range (IQR)25.5

Descriptive statistics

Standard deviation15.154757
Coefficient of variation (CV)0.57187763
Kurtosis-1.2
Mean26.5
Median Absolute Deviation (MAD)13
Skewness0
Sum1378
Variance229.66667
MonotonicityStrictly increasing
2024-03-23T07:18:39.816130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
28 1
 
1.9%
30 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
Other values (42) 42
80.8%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
52 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%
44 1
1.9%
43 1
1.9%

관리번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.5
Minimum1
Maximum52
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size600.0 B
2024-03-23T07:18:40.261383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.55
Q113.75
median26.5
Q339.25
95-th percentile49.45
Maximum52
Range51
Interquartile range (IQR)25.5

Descriptive statistics

Standard deviation15.154757
Coefficient of variation (CV)0.57187763
Kurtosis-1.2
Mean26.5
Median Absolute Deviation (MAD)13
Skewness0
Sum1378
Variance229.66667
MonotonicityStrictly increasing
2024-03-23T07:18:41.002225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.9%
28 1
 
1.9%
30 1
 
1.9%
31 1
 
1.9%
32 1
 
1.9%
33 1
 
1.9%
34 1
 
1.9%
35 1
 
1.9%
36 1
 
1.9%
37 1
 
1.9%
Other values (42) 42
80.8%
ValueCountFrequency (%)
1 1
1.9%
2 1
1.9%
3 1
1.9%
4 1
1.9%
5 1
1.9%
6 1
1.9%
7 1
1.9%
8 1
1.9%
9 1
1.9%
10 1
1.9%
ValueCountFrequency (%)
52 1
1.9%
51 1
1.9%
50 1
1.9%
49 1
1.9%
48 1
1.9%
47 1
1.9%
46 1
1.9%
45 1
1.9%
44 1
1.9%
43 1
1.9%

관리단체명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size548.0 B
함양자원
52 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row함양자원
2nd row함양자원
3rd row함양자원
4th row함양자원
5th row함양자원

Common Values

ValueCountFrequency (%)
함양자원 52
100.0%

Length

2024-03-23T07:18:41.504058image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:18:41.751635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
함양자원 52
100.0%

행정동
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size548.0 B
함양읍
51 
지곡면
 
1

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique1 ?
Unique (%)1.9%

Sample

1st row함양읍
2nd row함양읍
3rd row함양읍
4th row함양읍
5th row함양읍

Common Values

ValueCountFrequency (%)
함양읍 51
98.1%
지곡면 1
 
1.9%

Length

2024-03-23T07:18:42.048486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:18:42.369643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
함양읍 51
98.1%
지곡면 1
 
1.9%

설치장소명
Text

UNIQUE 

Distinct52
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size548.0 B
2024-03-23T07:18:42.912340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length8.5961538
Min length4

Characters and Unicode

Total characters447
Distinct characters149
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

Unique52 ?
Unique (%)100.0%

Sample

1st row위성초등길2 (청도계발)
2nd row함양카센터 옆
3rd row위성빌라
4th row웰가아파트
5th row행복주택아파트
ValueCountFrequency (%)
12
 
11.1%
7
 
6.5%
건너편 6
 
5.6%
5
 
4.6%
인당 3
 
2.8%
하림 2
 
1.9%
성심병원 2
 
1.9%
아파트 2
 
1.9%
위성초등길2 1
 
0.9%
물레방아주유소 1
 
0.9%
Other values (67) 67
62.0%
2024-03-23T07:18:44.220860image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
56
 
12.5%
14
 
3.1%
12
 
2.7%
10
 
2.2%
( 10
 
2.2%
) 10
 
2.2%
9
 
2.0%
8
 
1.8%
8
 
1.8%
8
 
1.8%
Other values (139) 302
67.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 356
79.6%
Space Separator 56
 
12.5%
Decimal Number 11
 
2.5%
Open Punctuation 10
 
2.2%
Close Punctuation 10
 
2.2%
Uppercase Letter 4
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
14
 
3.9%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.2%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
Other values (129) 265
74.4%
Decimal Number
ValueCountFrequency (%)
2 4
36.4%
3 3
27.3%
1 2
18.2%
8 1
 
9.1%
0 1
 
9.1%
Uppercase Letter
ValueCountFrequency (%)
A 2
50.0%
B 2
50.0%
Space Separator
ValueCountFrequency (%)
56
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 356
79.6%
Common 87
 
19.5%
Latin 4
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
14
 
3.9%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.2%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
Other values (129) 265
74.4%
Common
ValueCountFrequency (%)
56
64.4%
( 10
 
11.5%
) 10
 
11.5%
2 4
 
4.6%
3 3
 
3.4%
1 2
 
2.3%
8 1
 
1.1%
0 1
 
1.1%
Latin
ValueCountFrequency (%)
A 2
50.0%
B 2
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 356
79.6%
ASCII 91
 
20.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
56
61.5%
( 10
 
11.0%
) 10
 
11.0%
2 4
 
4.4%
3 3
 
3.3%
A 2
 
2.2%
B 2
 
2.2%
1 2
 
2.2%
8 1
 
1.1%
0 1
 
1.1%
Hangul
ValueCountFrequency (%)
14
 
3.9%
12
 
3.4%
10
 
2.8%
9
 
2.5%
8
 
2.2%
8
 
2.2%
8
 
2.2%
8
 
2.2%
7
 
2.0%
7
 
2.0%
Other values (129) 265
74.4%

설치수량
Categorical

IMBALANCE 

Distinct4
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size548.0 B
1
44 
2
4
 
1
3
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)3.8%

Sample

1st row1
2nd row1
3rd row1
4th row4
5th row2

Common Values

ValueCountFrequency (%)
1 44
84.6%
2 6
 
11.5%
4 1
 
1.9%
3 1
 
1.9%

Length

2024-03-23T07:18:44.758789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:18:45.617060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 44
84.6%
2 6
 
11.5%
4 1
 
1.9%
3 1
 
1.9%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size548.0 B
2024-03-13
52 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2024-03-13 52
100.0%

Length

2024-03-23T07:18:46.252164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-23T07:18:46.539280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-03-13 52
100.0%

Interactions

2024-03-23T07:18:37.539431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:18:36.590273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:18:37.809035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-23T07:18:37.125772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-23T07:18:46.739954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관리번호행정동설치장소명설치수량
연번1.0001.0000.0001.0000.298
관리번호1.0001.0000.0001.0000.298
행정동0.0000.0001.0001.0000.464
설치장소명1.0001.0001.0001.0001.000
설치수량0.2980.2980.4641.0001.000
2024-03-23T07:18:47.077250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동설치수량
행정동1.0000.306
설치수량0.3061.000
2024-03-23T07:18:47.328939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번관리번호행정동설치수량
연번1.0001.0000.0000.160
관리번호1.0001.0000.0000.160
행정동0.0000.0001.0000.306
설치수량0.1600.1600.3061.000

Missing values

2024-03-23T07:18:38.265649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-23T07:18:38.699101image/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

연번관리번호관리단체명행정동설치장소명설치수량데이터기준일자
011함양자원함양읍위성초등길2 (청도계발)12024-03-13
122함양자원함양읍함양카센터 옆12024-03-13
233함양자원함양읍위성빌라12024-03-13
344함양자원함양읍웰가아파트42024-03-13
455함양자원함양읍행복주택아파트22024-03-13
566함양자원함양읍한마음아파트12024-03-13
677함양자원함양읍함양제일고 앞 다목적쉼터12024-03-13
788함양자원함양읍위성아파트22024-03-13
899함양자원함양읍함양교통 뒤 한솔슈퍼 건너편12024-03-13
91010함양자원함양읍한주아파트32024-03-13
연번관리번호관리단체명행정동설치장소명설치수량데이터기준일자
424343함양자원함양읍다산축산정육점 (용평8길)12024-03-13
434444함양자원함양읍진아맨션A12024-03-13
444545함양자원함양읍진아맨션B12024-03-13
454646함양자원함양읍청해수산 옆 (청록식당)22024-03-13
464747함양자원함양읍명성 아파트 뒤22024-03-13
474848함양자원함양읍용평1길 (성심병원 건너편)12024-03-13
484949함양자원함양읍성심병원 별관 뒤12024-03-13
495050함양자원함양읍관변마을회관12024-03-13
505151함양자원함양읍위성초등길122024-03-13
515252함양자원지곡면행복마을22024-03-13