gimi9 Pandas Profiling

Dataset statistics

Number of variables	8
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	781.2 KiB
Average record size in memory	80.0 B

Variable types

Numeric	8

Dataset

Description	전북특별자치도 진안군 도시계획정보시스템 건축물 주제도 건폐율별에 대한 데이터로 공간정보관리번호, X좌표 및 Y좌표 정보, 건폐율, 건물군관리번호, 필지고유번호(PNU) 정보를 제공합니다.
Author	전북특별자치도 진안군
URL	https://www.data.go.kr/data/15119141/fileData.do

Alerts

`공간정보관리번호` is highly overall correlated with `필지고유번호(PNU)`	High correlation
`X좌표최소값` is highly overall correlated with `X좌표최대값`	High correlation
`Y좌표최소값` is highly overall correlated with `Y좌표최대값`	High correlation
`X좌표최대값` is highly overall correlated with `X좌표최소값`	High correlation
`Y좌표최대값` is highly overall correlated with `Y좌표최소값`	High correlation
`필지고유번호(PNU)` is highly overall correlated with `공간정보관리번호`	High correlation
`공간정보관리번호` has unique values	Unique
`건물군관리번호` has unique values	Unique
`건폐율` has 2905 (29.0%) zeros	Zeros

Reproduction

Analysis started	2024-03-15 01:39:27.759165
Analysis finished	2024-03-15 01:39:48.598886
Duration	20.84 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

공간정보관리번호
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6086.9184

Minimum	1
Maximum	12145
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1
5-th percentile	603.95
Q1	3083.75
median	6099.5
Q3	9102.25
95-th percentile	11528.05
Maximum	12145
Range	12144
Interquartile range (IQR)	6018.5

Descriptive statistics

Standard deviation	3495.7212
Coefficient of variation (CV)	0.57430065
Kurtosis	-1.1883685
Mean	6086.9184
Median Absolute Deviation (MAD)	3010
Skewness	-0.0060194724
Sum	60869184
Variance	12220067
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7089	1	< 0.1%
5451	1	< 0.1%
6698	1	< 0.1%
9448	1	< 0.1%
8834	1	< 0.1%
2052	1	< 0.1%
3084	1	< 0.1%
10062	1	< 0.1%
3941	1	< 0.1%
6262	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	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%
11	1	< 0.1%
12	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
12145	1	< 0.1%
12144	1	< 0.1%
12143	1	< 0.1%
12142	1	< 0.1%
12141	1	< 0.1%
12139	1	< 0.1%
12138	1	< 0.1%
12137	1	< 0.1%
12136	1	< 0.1%
12134	1	< 0.1%

X좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	9933
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23842493

Minimum	22440102
Maximum	25574377
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	22440102
5-th percentile	22868974
Q1	23340978
median	23815426
Q3	24164946
95-th percentile	25129962
Maximum	25574377
Range	3134275
Interquartile range (IQR)	823968.25

Descriptive statistics

Standard deviation	670687.34
Coefficient of variation (CV)	0.028129917
Kurtosis	-0.3834673
Mean	23842493
Median Absolute Deviation (MAD)	460762
Skewness	0.52848817
Sum	2.3842493 × 10¹¹
Variance	4.4982151 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23850660	3	< 0.1%
23846512	2	< 0.1%
25126290	2	< 0.1%
23908400	2	< 0.1%
22846272	2	< 0.1%
23437663	2	< 0.1%
23914978	2	< 0.1%
23979642	2	< 0.1%
23744700	2	< 0.1%
25126777	2	< 0.1%
Other values (9923)	9979	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22440102	1	< 0.1%
22443254	1	< 0.1%
22444773	1	< 0.1%
22457198	1	< 0.1%
22458321	1	< 0.1%
22493316	1	< 0.1%
22540610	1	< 0.1%
22541794	1	< 0.1%
22542108	1	< 0.1%
22542336	1	< 0.1%

Value	Count	Frequency (%)
25574377	1	< 0.1%
25573069	1	< 0.1%
25571786	1	< 0.1%
25568337	1	< 0.1%
25567808	1	< 0.1%
25566304	1	< 0.1%
25565980	1	< 0.1%
25563581	1	< 0.1%
25561643	1	< 0.1%
25559470	1	< 0.1%

Y좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	9960
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25678534

Minimum	23670040
Maximum	27979338
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	23670040
5-th percentile	24246969
Q1	24951387
median	25496180
Q3	26247102
95-th percentile	27484492
Maximum	27979338
Range	4309298
Interquartile range (IQR)	1295715.2

Descriptive statistics

Standard deviation	959254.96
Coefficient of variation (CV)	0.037356298
Kurtosis	-0.51635985
Mean	25678534
Median Absolute Deviation (MAD)	643733
Skewness	0.41549199
Sum	2.5678534 × 10¹¹
Variance	9.2017008 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25482674	2	< 0.1%
25095354	2	< 0.1%
26612103	2	< 0.1%
25530893	2	< 0.1%
26050551	2	< 0.1%
25256751	2	< 0.1%
24038023	2	< 0.1%
25271968	2	< 0.1%
24617110	2	< 0.1%
26024018	2	< 0.1%
Other values (9950)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23670040	1	< 0.1%
23696823	1	< 0.1%
23698721	1	< 0.1%
23699402	1	< 0.1%
23717424	1	< 0.1%
23723079	1	< 0.1%
23766729	1	< 0.1%
23774842	1	< 0.1%
23785596	1	< 0.1%
23810633	1	< 0.1%

Value	Count	Frequency (%)
27979338	1	< 0.1%
27949950	1	< 0.1%
27942458	1	< 0.1%
27915388	1	< 0.1%
27914168	1	< 0.1%
27913281	1	< 0.1%
27911736	1	< 0.1%
27909557	1	< 0.1%
27909309	1	< 0.1%
27908657	1	< 0.1%

X좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9939
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23846198

Minimum	22443656
Maximum	25577671
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	22443656
5-th percentile	22871434
Q1	23343772
median	23818823
Q3	24170791
95-th percentile	25133130
Maximum	25577671
Range	3134015
Interquartile range (IQR)	827018.75

Descriptive statistics

Standard deviation	670531.4
Coefficient of variation (CV)	0.028119007
Kurtosis	-0.38385393
Mean	23846198
Median Absolute Deviation (MAD)	460230.5
Skewness	0.52839109
Sum	2.3846198 × 10¹¹
Variance	4.4961236 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23298804	2	< 0.1%
25125093	2	< 0.1%
23961634	2	< 0.1%
23296591	2	< 0.1%
23845034	2	< 0.1%
23846914	2	< 0.1%
23806149	2	< 0.1%
23832155	2	< 0.1%
23303726	2	< 0.1%
23440310	2	< 0.1%
Other values (9929)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22443656	1	< 0.1%
22446563	1	< 0.1%
22446913	1	< 0.1%
22461115	1	< 0.1%
22466092	1	< 0.1%
22494888	1	< 0.1%
22541514	1	< 0.1%
22543818	1	< 0.1%
22543967	1	< 0.1%
22544751	1	< 0.1%

Value	Count	Frequency (%)
25577671	1	< 0.1%
25575603	1	< 0.1%
25574568	1	< 0.1%
25571693	1	< 0.1%
25571271	1	< 0.1%
25569378	1	< 0.1%
25568170	1	< 0.1%
25566036	1	< 0.1%
25565253	1	< 0.1%
25562750	1	< 0.1%

Y좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9944
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25682331

Minimum	23699341
Maximum	28033127
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	23699341
5-th percentile	24249970
Q1	24955191
median	25499605
Q3	26250033
95-th percentile	27489204
Maximum	28033127
Range	4333786
Interquartile range (IQR)	1294841.8

Descriptive statistics

Standard deviation	959349.57
Coefficient of variation (CV)	0.037354459
Kurtosis	-0.51629143
Mean	25682331
Median Absolute Deviation (MAD)	643390.5
Skewness	0.41682589
Sum	2.5682331 × 10¹¹
Variance	9.203516 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25261839	3	< 0.1%
25838104	2	< 0.1%
25428043	2	< 0.1%
24721858	2	< 0.1%
25501331	2	< 0.1%
25219238	2	< 0.1%
24333955	2	< 0.1%
25497064	2	< 0.1%
24733024	2	< 0.1%
27381200	2	< 0.1%
Other values (9934)	9979	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23699341	1	< 0.1%
23701398	1	< 0.1%
23702657	1	< 0.1%
23727531	1	< 0.1%
23764408	1	< 0.1%
23770182	1	< 0.1%
23777407	1	< 0.1%
23788274	1	< 0.1%
23822656	1	< 0.1%
23824569	1	< 0.1%

Value	Count	Frequency (%)
28033127	1	< 0.1%
28025304	1	< 0.1%
27980978	1	< 0.1%
27959037	1	< 0.1%
27948330	1	< 0.1%
27924141	1	< 0.1%
27916980	1	< 0.1%
27916390	1	< 0.1%
27914378	1	< 0.1%
27911932	1	< 0.1%

건폐율
Real number (ℝ)

ZEROS

Distinct	3732
Distinct (%)	37.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.171545

Minimum	0
Maximum	222.49
Zeros	2905
Zeros (%)	29.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	16.075
Q3	27.5225
95-th percentile	51.043
Maximum	222.49
Range	222.49
Interquartile range (IQR)	27.5225

Descriptive statistics

Standard deviation	18.383754
Coefficient of variation (CV)	1.0116781
Kurtosis	8.8479621
Mean	18.171545
Median Absolute Deviation (MAD)	14.33
Skewness	1.877122
Sum	181715.45
Variance	337.96242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	2905	29.0%
15.0	15	0.1%
14.5	11	0.1%
24.5	10	0.1%
19.8	9	0.1%
10.0	9	0.1%
21.8	9	0.1%
24.0	9	0.1%
19.7	8	0.1%
15.5	8	0.1%
Other values (3722)	7007	70.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	2905	29.0%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.05	1	< 0.1%
0.066	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.1	1	< 0.1%
0.15	1	< 0.1%

Value	Count	Frequency (%)
222.49	1	< 0.1%
213.49	1	< 0.1%
200.28	1	< 0.1%
187.87	1	< 0.1%
176.88	1	< 0.1%
163.95	1	< 0.1%
162.58	1	< 0.1%
156.24	1	< 0.1%
149.95	1	< 0.1%
148.96	1	< 0.1%

건물군관리번호
Real number (ℝ)

UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15526564

Minimum	4
Maximum	1.001869 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4
5-th percentile	2734.85
Q1	7883.75
median	11890.5
Q3	15840.25
95-th percentile	1.0018202 × 10⁸
Maximum	1.001869 × 10⁸
Range	1.001869 × 10⁸
Interquartile range (IQR)	7956.5

Descriptive statistics

Standard deviation	36243843
Coefficient of variation (CV)	2.3343118
Kurtosis	1.6404899
Mean	15526564
Median Absolute Deviation (MAD)	3975
Skewness	1.9079208
Sum	1.5526564 × 10¹¹
Variance	1.3136162 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13614	1	< 0.1%
12735	1	< 0.1%
16970	1	< 0.1%
6309	1	< 0.1%
17166	1	< 0.1%
9104	1	< 0.1%
14853	1	< 0.1%
16592	1	< 0.1%
100186161	1	< 0.1%
16210	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
15	1	< 0.1%
20	1	< 0.1%
22	1	< 0.1%
40	1	< 0.1%
42	1	< 0.1%
43	1	< 0.1%

Value	Count	Frequency (%)
100186900	1	< 0.1%
100186880	1	< 0.1%
100186860	1	< 0.1%
100186840	1	< 0.1%
100186819	1	< 0.1%
100186809	1	< 0.1%
100186808	1	< 0.1%
100186805	1	< 0.1%
100186804	1	< 0.1%
100186803	1	< 0.1%

필지고유번호(PNU)
Real number (ℝ)

HIGH CORRELATION

Distinct	7441
Distinct (%)	74.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.5720332 × 10¹⁸

Minimum	4.572025 × 10¹⁸
Maximum	4.57204 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4.572025 × 10¹⁸
5-th percentile	4.572025 × 10¹⁸
Q1	4.572025 × 10¹⁸
median	4.572035 × 10¹⁸
Q3	4.572038 × 10¹⁸
95-th percentile	4.57204 × 10¹⁸
Maximum	4.57204 × 10¹⁸
Range	1.50051 × 10¹³
Interquartile range (IQR)	1.2987991 × 10¹³

Descriptive statistics

Standard deviation	5.3174158 × 10¹²
Coefficient of variation (CV)	1.1630309 × 10^-6
Kurtosis	-1.1511129
Mean	4.5720332 × 10¹⁸
Median Absolute Deviation (MAD)	3.0019925 × 10¹²
Skewness	-0.54349936
Sum	-9.146689 × 10¹⁸
Variance	2.8274911 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4572025021104030000	28	0.3%
4572025021104060000	24	0.2%
4572025023100320000	24	0.2%
4572025023102840000	21	0.2%
4572031025110530000	18	0.2%
4572025021104790000	16	0.2%
4572025022101250000	16	0.2%
4572025021103660000	15	0.1%
4572037024104450000	15	0.1%
4572025021104020000	13	0.1%
Other values (7431)	9810	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4572025021100280000	1	< 0.1%
4572025021100330000	1	< 0.1%
4572025021100450000	1	< 0.1%
4572025021100540000	1	< 0.1%
4572025021100560000	3	< 0.1%
4572025021100570000	1	< 0.1%
4572025021100600000	1	< 0.1%
4572025021100610000	1	< 0.1%
4572025021100630000	1	< 0.1%
4572025021100640000	1	< 0.1%

Value	Count	Frequency (%)
4572040026200720000	1	< 0.1%
4572040026200520000	2	< 0.1%
4572040026200280000	1	< 0.1%
4572040026110540000	1	< 0.1%
4572040026110460000	1	< 0.1%
4572040026109900000	1	< 0.1%
4572040026109880000	1	< 0.1%
4572040026109800000	1	< 0.1%
4572040026109770000	1	< 0.1%
4572040026109360000	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건폐율	건물군관리번호	필지고유번호(PNU)
공간정보관리번호	1.000	0.849	0.853	0.849	0.852	0.220	0.399	0.854
X좌표최소값	0.849	1.000	0.730	1.000	0.732	0.138	0.068	0.791
Y좌표최소값	0.853	0.730	1.000	0.730	0.998	0.180	0.083	0.829
X좌표최대값	0.849	1.000	0.730	1.000	0.732	0.137	0.069	0.791
Y좌표최대값	0.852	0.732	0.998	0.732	1.000	0.182	0.074	0.829
건폐율	0.220	0.138	0.180	0.137	0.182	1.000	0.095	0.091
건물군관리번호	0.399	0.068	0.083	0.069	0.074	0.095	1.000	0.071
필지고유번호(PNU)	0.854	0.791	0.829	0.791	0.829	0.091	0.071	1.000

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건폐율	건물군관리번호	필지고유번호(PNU)
공간정보관리번호	1.000	-0.306	0.160	-0.305	0.160	-0.033	0.078	0.690
X좌표최소값	-0.306	1.000	0.451	1.000	0.451	0.006	0.036	-0.470
Y좌표최소값	0.160	0.451	1.000	0.452	1.000	-0.069	0.010	0.222
X좌표최대값	-0.305	1.000	0.452	1.000	0.451	0.004	0.035	-0.469
Y좌표최대값	0.160	0.451	1.000	0.451	1.000	-0.070	0.010	0.223
건폐율	-0.033	0.006	-0.069	0.004	-0.070	1.000	0.102	-0.031
건물군관리번호	0.078	0.036	0.010	0.035	0.010	0.102	1.000	0.006
필지고유번호(PNU)	0.690	-0.470	0.222	-0.469	0.223	-0.031	0.006	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건폐율	건물군관리번호	필지고유번호(PNU)
7056	7089	23346838	24811826	23348438	24813608	21.83	13614	4572037021109780000
7742	7405	23171496	24782689	23174612	24785960	19.44	6471	4572037023111110000
5596	5799	23748161	24322990	23751269	24325853	34.99	6302	4572035027103290000
1808	1809	24104994	25549732	24108189	25551926	0.0	8088	4572025028104440000
10748	10419	23913476	27895922	23917088	27898425	17.27	11881	4572040025105880000
9314	9373	23932026	26720721	23935126	26722696	26.54	17014	4572039022114120000
6587	6587	22906976	24809396	22909307	24812255	21.87	9475	4572036026103690000
6432	6460	23253528	24139394	23255554	24142257	0.0	5178	4572036024103840000
5723	5954	23564614	24545709	23566796	24547958	32.15	8551	4572035029107390000
8477	8225	23170655	25791587	23197512	25824096	0.0	6890	4572038022200250000

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건폐율	건물군관리번호	필지고유번호(PNU)
5183	5409	23489190	24457632	23493802	24459853	15.86	6762	4572035023100250000
11086	11210	23307224	24800070	23309103	24802330	14.4	5307	4572037021109220000
5852	5630	23828887	24020089	23852859	24043206	0.08	12804	4572035026200300000
10835	10506	23437550	27896401	23440354	27898940	0.0	15520	4572040026108870000
4681	4739	24740913	25777088	24745124	25779512	14.9	6281	4572033026109420000
3794	3881	24877498	26339856	24879693	26342310	14.01	10392	4572032023107620000
5678	5881	23880457	24663311	23883273	24665315	32.06	8849	4572035028103640000
4619	4284	25337643	26234446	25341777	26237690	18.23	11712	4572033023105980000
11314	11536	23854754	26380186	23858982	26384456	8.22	100182595	4572039021105400000
9933	9565	25021030	26503867	25023880	26506113	38.4	14677	4572032021105170000

Overview

Variables

Interactions

Correlations

Missing values

Sample