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/15119146/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 379 (3.8%) zeros	Zeros

Reproduction

Analysis started	2024-03-14 15:01:56.489661
Analysis finished	2024-03-14 15:02:12.227485
Duration	15.74 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	6075.4275

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

Quantile statistics

Minimum	1
5-th percentile	620.9
Q1	3036.5
median	6072.5
Q3	9104.5
95-th percentile	11541.05
Maximum	12147
Range	12146
Interquartile range (IQR)	6068

Descriptive statistics

Standard deviation	3503.5186
Coefficient of variation (CV)	0.5766703
Kurtosis	-1.2000519
Mean	6075.4275
Median Absolute Deviation (MAD)	3034.5
Skewness	0.00023588011
Sum	60754275
Variance	12274642
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10771	1	< 0.1%
5839	1	< 0.1%
11621	1	< 0.1%
5474	1	< 0.1%
1624	1	< 0.1%
6618	1	< 0.1%
1280	1	< 0.1%
6788	1	< 0.1%
11025	1	< 0.1%
1142	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
12	1	< 0.1%
13	1	< 0.1%

Value	Count	Frequency (%)
12147	1	< 0.1%
12146	1	< 0.1%
12145	1	< 0.1%
12142	1	< 0.1%
12141	1	< 0.1%
12140	1	< 0.1%
12139	1	< 0.1%
12135	1	< 0.1%
12134	1	< 0.1%
12133	1	< 0.1%

X좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	9929
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23844430

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	22869022
Q1	23343141
median	23815768
Q3	24180717
95-th percentile	25131875
Maximum	25574377
Range	3134275
Interquartile range (IQR)	837576

Descriptive statistics

Standard deviation	670088.86
Coefficient of variation (CV)	0.028102531
Kurtosis	-0.37934149
Mean	23844430
Median Absolute Deviation (MAD)	458740
Skewness	0.53373817
Sum	2.384443 × 10¹¹
Variance	4.4901907 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23962676	2	< 0.1%
23291099	2	< 0.1%
23908260	2	< 0.1%
23151813	2	< 0.1%
23326143	2	< 0.1%
23867182	2	< 0.1%
23437456	2	< 0.1%
23855069	2	< 0.1%
23567369	2	< 0.1%
24987580	2	< 0.1%
Other values (9919)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22440102	1	< 0.1%
22443254	1	< 0.1%
22444773	1	< 0.1%
22458321	1	< 0.1%
22483910	1	< 0.1%
22493316	1	< 0.1%
22540610	1	< 0.1%
22542108	1	< 0.1%
22542336	1	< 0.1%
22542768	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%
25561643	1	< 0.1%
25559470	1	< 0.1%
25555237	1	< 0.1%

Y좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	9963
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25678659

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	24250727
Q1	24956238
median	25495198
Q3	26242617
95-th percentile	27487517
Maximum	27979338
Range	4309298
Interquartile range (IQR)	1286378.8

Descriptive statistics

Standard deviation	956808.79
Coefficient of variation (CV)	0.037260855
Kurtosis	-0.50607447
Mean	25678659
Median Absolute Deviation (MAD)	640871
Skewness	0.4212093
Sum	2.5678659 × 10¹¹
Variance	9.1548305 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25250862	3	< 0.1%
27204893	2	< 0.1%
25697925	2	< 0.1%
25477345	2	< 0.1%
27198605	2	< 0.1%
26024018	2	< 0.1%
25482674	2	< 0.1%
27482024	2	< 0.1%
25530893	2	< 0.1%
24347097	2	< 0.1%
Other values (9953)	9979	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23670040	1	< 0.1%
23694144	1	< 0.1%
23696823	1	< 0.1%
23698721	1	< 0.1%
23699402	1	< 0.1%
23717424	1	< 0.1%
23723079	1	< 0.1%
23744380	1	< 0.1%
23766729	1	< 0.1%
23768390	1	< 0.1%

Value	Count	Frequency (%)
27979338	1	< 0.1%
27949950	1	< 0.1%
27942458	1	< 0.1%
27931609	1	< 0.1%
27925980	1	< 0.1%
27915388	1	< 0.1%
27915110	1	< 0.1%
27914168	1	< 0.1%
27913281	1	< 0.1%
27912130	1	< 0.1%

X좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9941
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23848130

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	23346067
median	23819271
Q3	24187954
95-th percentile	25134374
Maximum	25577671
Range	3134015
Interquartile range (IQR)	841886.5

Descriptive statistics

Standard deviation	669952.89
Coefficient of variation (CV)	0.028092471
Kurtosis	-0.37960874
Mean	23848130
Median Absolute Deviation (MAD)	459024
Skewness	0.53380822
Sum	2.384813 × 10¹¹
Variance	4.4883688 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24743734	2	< 0.1%
23903175	2	< 0.1%
23898359	2	< 0.1%
24954205	2	< 0.1%
23297472	2	< 0.1%
23469508	2	< 0.1%
23296591	2	< 0.1%
24010987	2	< 0.1%
23010164	2	< 0.1%
23480409	2	< 0.1%
Other values (9931)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22443656	1	< 0.1%
22446563	1	< 0.1%
22446913	1	< 0.1%
22466092	1	< 0.1%
22486390	1	< 0.1%
22494888	1	< 0.1%
22541514	1	< 0.1%
22543818	1	< 0.1%
22543967	1	< 0.1%
22546089	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%
25565253	1	< 0.1%
25562750	1	< 0.1%
25558714	1	< 0.1%

Y좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9947
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25682439

Minimum	23696544
Maximum	28025304
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	23696544
5-th percentile	24254482
Q1	24960478
median	25498256
Q3	26246240
95-th percentile	27492121
Maximum	28025304
Range	4328760
Interquartile range (IQR)	1285761.5

Descriptive statistics

Standard deviation	956763.02
Coefficient of variation (CV)	0.037253588
Kurtosis	-0.5063829
Mean	25682439
Median Absolute Deviation (MAD)	640556
Skewness	0.42242835
Sum	2.5682439 × 10¹¹
Variance	9.1539547 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25261839	3	< 0.1%
25462739	2	< 0.1%
25191257	2	< 0.1%
24773517	2	< 0.1%
25249640	2	< 0.1%
25475342	2	< 0.1%
24333955	2	< 0.1%
24824915	2	< 0.1%
25473994	2	< 0.1%
25244202	2	< 0.1%
Other values (9937)	9979	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
23696544	1	< 0.1%
23699341	1	< 0.1%
23701398	1	< 0.1%
23702657	1	< 0.1%
23727531	1	< 0.1%
23749731	1	< 0.1%
23764408	1	< 0.1%
23770182	1	< 0.1%
23772950	1	< 0.1%
23777407	1	< 0.1%

Value	Count	Frequency (%)
28025304	1	< 0.1%
27980978	1	< 0.1%
27959037	1	< 0.1%
27948330	1	< 0.1%
27933757	1	< 0.1%
27928969	1	< 0.1%
27924141	1	< 0.1%
27916980	1	< 0.1%
27916390	1	< 0.1%
27916249	1	< 0.1%

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

UNIQUE

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

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	2707.85
Q1	7805.75
median	11790
Q3	15801.25
95-th percentile	1.0018181 × 10⁸
Maximum	1.001869 × 10⁸
Range	1.001869 × 10⁸
Interquartile range (IQR)	7995.5

Descriptive statistics

Standard deviation	35906158
Coefficient of variation (CV)	2.3659917
Kurtosis	1.7849235
Mean	15175944
Median Absolute Deviation (MAD)	3997
Skewness	1.9453962
Sum	1.5175944 × 10¹¹
Variance	1.2892522 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6073	1	< 0.1%
12776	1	< 0.1%
100171844	1	< 0.1%
16131	1	< 0.1%
15696	1	< 0.1%
9641	1	< 0.1%
870	1	< 0.1%
14727	1	< 0.1%
1886	1	< 0.1%
5284	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%
40	1	< 0.1%
43	1	< 0.1%
48	1	< 0.1%
53	1	< 0.1%

Value	Count	Frequency (%)
100186900	1	< 0.1%
100186880	1	< 0.1%
100186861	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%

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

HIGH CORRELATION

Distinct	7461
Distinct (%)	74.6%
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.2987999 × 10¹³

Descriptive statistics

Standard deviation	5.3406382 × 10¹²
Coefficient of variation (CV)	1.1681101 × 10^-6
Kurtosis	-1.1757228
Mean	4.5720332 × 10¹⁸
Median Absolute Deviation (MAD)	3.0019962 × 10¹²
Skewness	-0.52995714
Sum	-9.1470545 × 10¹⁸
Variance	2.8522417 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4572025021104030000	29	0.3%
4572025023100320000	26	0.3%
4572025021104060000	26	0.3%
4572025023102840000	24	0.2%
4572025021104790000	17	0.2%
4572031025110530000	16	0.2%
4572037024104450000	16	0.2%
4572025021103660000	13	0.1%
4572038029105030000	13	0.1%
4572040024109060000	12	0.1%
Other values (7451)	9808	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	4	< 0.1%
4572025021100570000	1	< 0.1%
4572025021100600000	1	< 0.1%
4572025021100610000	1	< 0.1%
4572025021100620000	1	< 0.1%
4572025021100630000	1	< 0.1%

Value	Count	Frequency (%)
4572040026200520000	2	< 0.1%
4572040026200400000	1	< 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%
4572040026109760000	1	< 0.1%

층수
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0292

Minimum	0
Maximum	5
Zeros	379
Zeros (%)	3.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3660065
Coefficient of variation (CV)	0.35562233
Kurtosis	22.428958
Mean	1.0292
Median Absolute Deviation (MAD)	0
Skewness	2.6693702
Sum	10292
Variance	0.13396076
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	9065	90.6%
2	469	4.7%
0	379	3.8%
3	65	0.7%
4	16	0.2%
5	6	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	379	3.8%
1	9065	90.6%
2	469	4.7%
3	65	0.7%
4	16	0.2%
5	6	0.1%

Value	Count	Frequency (%)
5	6	0.1%
4	16	0.2%
3	65	0.7%
2	469	4.7%
1	9065	90.6%
0	379	3.8%

Phik (φk)
Auto

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건물군관리번호	필지고유번호(PNU)	층수
공간정보관리번호	1.000	0.849	0.852	0.849	0.851	0.388	0.853	0.177
X좌표최소값	0.849	1.000	0.730	1.000	0.729	0.064	0.788	0.100
Y좌표최소값	0.852	0.730	1.000	0.730	0.998	0.074	0.829	0.115
X좌표최대값	0.849	1.000	0.730	1.000	0.729	0.065	0.788	0.101
Y좌표최대값	0.851	0.729	0.998	0.729	1.000	0.073	0.829	0.110
건물군관리번호	0.388	0.064	0.074	0.065	0.073	1.000	0.067	0.095
필지고유번호(PNU)	0.853	0.788	0.829	0.788	0.829	0.067	1.000	0.093
층수	0.177	0.100	0.115	0.101	0.110	0.095	0.093	1.000

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건물군관리번호	필지고유번호(PNU)	층수
공간정보관리번호	1.000	-0.304	0.160	-0.303	0.161	0.067	0.694	-0.061
X좌표최소값	-0.304	1.000	0.447	1.000	0.447	0.026	-0.465	0.034
Y좌표최소값	0.160	0.447	1.000	0.447	1.000	0.025	0.228	0.039
X좌표최대값	-0.303	1.000	0.447	1.000	0.447	0.026	-0.464	0.034
Y좌표최대값	0.161	0.447	1.000	0.447	1.000	0.025	0.228	0.039
건물군관리번호	0.067	0.026	0.025	0.026	0.025	1.000	0.006	0.127
필지고유번호(PNU)	0.694	-0.465	0.228	-0.464	0.228	0.006	1.000	-0.071
층수	-0.061	0.034	0.039	0.034	0.039	0.127	-0.071	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)	층수
10712	10771	23191239	24112420	23193827	24117671	6073	4572036024106340000	1
3355	3442	24948898	26663928	24951721	26666735	15069	4572032021116380000	1
1747	2004	24352472	25320801	24354820	25323214	13991	4572025028100950000	1
8000	7771	23100842	25104118	23103624	25106894	7464	4572037024104960000	1
9218	9277	23930560	26843055	23945095	26863037	100185443	4572040023108240000	1
6545	6546	22663555	24573282	22666249	24576288	12152	4572036025103900000	1
6735	6736	22851682	24938166	22854189	24939593	13618	4572036027105220000	1
541	513	23887516	25472037	23891183	25476748	2220	4572025021104030000	1
679	651	23823334	25472753	23826467	25475539	15992	4572025022101050000	1
3162	3238	24684016	27330527	24687975	27344054	6614	4572031025110530000	1

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	건물군관리번호	필지고유번호(PNU)	층수
7273	6897	22683940	25219557	22686791	25222114	117	4572036028102900000	0
84	335	23850660	25486857	23852634	25489105	13193	4572025021105170000	1
4525	4304	25320038	26224750	25323074	26226827	16674	4572033023106480000	1
7628	7405	23171496	24782689	23174612	24785960	6471	4572037023111110000	1
6	168	22787081	25236300	22790042	25238867	12452	4572037024115260000	1
8054	7825	23183843	24960036	23186986	24961830	6986	4572037025105500000	1
1159	1111	23906251	25306740	23908577	25308829	15509	4572025023100320000	1
5244	5363	23667405	24564812	23669226	24567249	9986	4572035022106360000	1
625	597	23860916	25467064	23867005	25471285	3742	4572025021103640000	1
12089	11777	23372807	26145971	23375181	26151003	8364	4572038021102940000	1

Overview

Variables

Interactions

Correlations

Missing values

Sample