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/15119144/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 2915 (29.1%) zeros	Zeros

Reproduction

Analysis started	2024-03-14 10:27:42.572211
Analysis finished	2024-03-14 10:28:00.082797
Duration	17.51 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	6078.7728

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

Quantile statistics

Minimum	3
5-th percentile	608.95
Q1	3046.75
median	6104.5
Q3	9112.25
95-th percentile	11535.05
Maximum	12147
Range	12144
Interquartile range (IQR)	6065.5

Descriptive statistics

Standard deviation	3501.8577
Coefficient of variation (CV)	0.57607972
Kurtosis	-1.1968276
Mean	6078.7728
Median Absolute Deviation (MAD)	3033.5
Skewness	-0.0062962433
Sum	60787728
Variance	12263008
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6999	1	< 0.1%
1177	1	< 0.1%
1621	1	< 0.1%
1624	1	< 0.1%
11264	1	< 0.1%
11831	1	< 0.1%
4478	1	< 0.1%
7956	1	< 0.1%
2647	1	< 0.1%
6054	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
12147	1	< 0.1%
12146	1	< 0.1%
12145	1	< 0.1%
12144	1	< 0.1%
12143	1	< 0.1%
12142	1	< 0.1%
12141	1	< 0.1%
12138	1	< 0.1%
12136	1	< 0.1%
12133	1	< 0.1%

X좌표최소값
Real number (ℝ)

HIGH CORRELATION

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

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

Quantile statistics

Minimum	22440102
5-th percentile	22886821
Q1	23340714
median	23815526
Q3	24159896
95-th percentile	25131875
Maximum	25571786
Range	3131684
Interquartile range (IQR)	819182.75

Descriptive statistics

Standard deviation	670019.37
Coefficient of variation (CV)	0.028099705
Kurtosis	-0.37336704
Mean	23844356
Median Absolute Deviation (MAD)	460083
Skewness	0.54154898
Sum	2.3844356 × 10¹¹
Variance	4.4892596 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
23850660	3	< 0.1%
23841934	2	< 0.1%
23908400	2	< 0.1%
23352386	2	< 0.1%
23921707	2	< 0.1%
22849557	2	< 0.1%
23908260	2	< 0.1%
22682084	2	< 0.1%
23979642	2	< 0.1%
23419764	2	< 0.1%
Other values (9931)	9979	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22440102	1	< 0.1%
22457198	1	< 0.1%
22458321	1	< 0.1%
22483910	1	< 0.1%
22493316	1	< 0.1%
22541794	1	< 0.1%
22542108	1	< 0.1%
22542336	1	< 0.1%
22542768	1	< 0.1%
22542781	1	< 0.1%

Value	Count	Frequency (%)
25571786	1	< 0.1%
25568337	1	< 0.1%
25567808	1	< 0.1%
25565980	1	< 0.1%
25563581	1	< 0.1%
25561643	1	< 0.1%
25555237	1	< 0.1%
25555073	1	< 0.1%
25554299	1	< 0.1%
25551951	1	< 0.1%

Y좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	9962
Distinct (%)	99.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25672959

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	24245535
Q1	24951387
median	25496180
Q3	26234570
95-th percentile	27482036
Maximum	27979338
Range	4309298
Interquartile range (IQR)	1283183.5

Descriptive statistics

Standard deviation	952619.51
Coefficient of variation (CV)	0.037105949
Kurtosis	-0.48434503
Mean	25672959
Median Absolute Deviation (MAD)	639459
Skewness	0.4157778
Sum	2.5672959 × 10¹¹
Variance	9.0748394 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25477345	2	< 0.1%
25438845	2	< 0.1%
25697925	2	< 0.1%
24877978	2	< 0.1%
24617110	2	< 0.1%
27329264	2	< 0.1%
26612103	2	< 0.1%
24347097	2	< 0.1%
25489418	2	< 0.1%
26637151	2	< 0.1%
Other values (9952)	9980	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%
23768390	1	< 0.1%
23774842	1	< 0.1%

Value	Count	Frequency (%)
27979338	1	< 0.1%
27942458	1	< 0.1%
27925980	1	< 0.1%
27915388	1	< 0.1%
27915110	1	< 0.1%
27913281	1	< 0.1%
27912130	1	< 0.1%
27911321	1	< 0.1%
27909557	1	< 0.1%
27909309	1	< 0.1%

X좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9945
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23848072

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

Quantile statistics

Minimum	22443656
5-th percentile	22890342
Q1	23343294
median	23818966
Q3	24162943
95-th percentile	25134466
Maximum	25575603
Range	3131947
Interquartile range (IQR)	819649.5

Descriptive statistics

Standard deviation	669827.1
Coefficient of variation (CV)	0.028087265
Kurtosis	-0.37355546
Mean	23848072
Median Absolute Deviation (MAD)	460043
Skewness	0.54167275
Sum	2.3848072 × 10¹¹
Variance	4.4866835 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22766405	2	< 0.1%
23832155	2	< 0.1%
23196148	2	< 0.1%
24743734	2	< 0.1%
23846935	2	< 0.1%
25126341	2	< 0.1%
23153894	2	< 0.1%
23638194	2	< 0.1%
23863017	2	< 0.1%
23827777	2	< 0.1%
Other values (9935)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22443656	1	< 0.1%
22461115	1	< 0.1%
22466092	1	< 0.1%
22486390	1	< 0.1%
22494888	1	< 0.1%
22543818	1	< 0.1%
22543967	1	< 0.1%
22544751	1	< 0.1%
22545004	1	< 0.1%
22546089	1	< 0.1%

Value	Count	Frequency (%)
25575603	1	< 0.1%
25571693	1	< 0.1%
25571271	1	< 0.1%
25568170	1	< 0.1%
25566036	1	< 0.1%
25565253	1	< 0.1%
25558714	1	< 0.1%
25557789	1	< 0.1%
25557186	1	< 0.1%
25557019	1	< 0.1%

Y좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	9949
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25676784

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

Quantile statistics

Minimum	23696544
5-th percentile	24247959
Q1	24955191
median	25499467
Q3	26238358
95-th percentile	27485011
Maximum	28033127
Range	4336583
Interquartile range (IQR)	1283166.8

Descriptive statistics

Standard deviation	952645.98
Coefficient of variation (CV)	0.037101452
Kurtosis	-0.48450164
Mean	25676784
Median Absolute Deviation (MAD)	638810
Skewness	0.41729644
Sum	2.5676784 × 10¹¹
Variance	9.0753437 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25498208	2	< 0.1%
27118453	2	< 0.1%
26658538	2	< 0.1%
27206485	2	< 0.1%
25444359	2	< 0.1%
25954743	2	< 0.1%
25238951	2	< 0.1%
25473994	2	< 0.1%
25255822	2	< 0.1%
25438116	2	< 0.1%
Other values (9939)	9980	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%
23772950	1	< 0.1%
23777407	1	< 0.1%
23788274	1	< 0.1%

Value	Count	Frequency (%)
28033127	1	< 0.1%
28025304	1	< 0.1%
27980978	1	< 0.1%
27948330	1	< 0.1%
27928969	1	< 0.1%
27924141	1	< 0.1%
27916390	1	< 0.1%
27916249	1	< 0.1%
27915522	1	< 0.1%
27913801	1	< 0.1%

용적률
Real number (ℝ)

ZEROS

Distinct	3839
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.76898

Minimum	0
Maximum	1011
Zeros	2915
Zeros (%)	29.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	15.94
Q3	28.0225
95-th percentile	55.203
Maximum	1011
Range	1011
Interquartile range (IQR)	28.0225

Descriptive statistics

Standard deviation	27.775151
Coefficient of variation (CV)	1.4049865
Kurtosis	308.38982
Mean	19.76898
Median Absolute Deviation (MAD)	15.025
Skewness	11.163292
Sum	197689.8
Variance	771.45904
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	2915	29.1%
15.0	16	0.2%
24.5	12	0.1%
14.5	11	0.1%
20.0	10	0.1%
25.0	9	0.1%
13.9	9	0.1%
10.0	9	0.1%
13.5	8	0.1%
16.38	8	0.1%
Other values (3829)	6993	69.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	2915	29.1%
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	3	< 0.1%
0.08	1	< 0.1%
0.1	1	< 0.1%
0.15	1	< 0.1%

Value	Count	Frequency (%)
1011.0	1	< 0.1%
937.58	1	< 0.1%
566.35	1	< 0.1%
308.65	1	< 0.1%
308.5	1	< 0.1%
268.48	1	< 0.1%
260.8	1	< 0.1%
257.98	1	< 0.1%
256.39	1	< 0.1%
254.5	1	< 0.1%

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

UNIQUE

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

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

Quantile statistics

Minimum	11
5-th percentile	2686.75
Q1	7837.75
median	11797
Q3	15797
95-th percentile	1.0018187 × 10⁸
Maximum	1.001869 × 10⁸
Range	1.0018689 × 10⁸
Interquartile range (IQR)	7959.25

Descriptive statistics

Standard deviation	36070986
Coefficient of variation (CV)	2.3504802
Kurtosis	1.7139123
Mean	15346220
Median Absolute Deviation (MAD)	3981.5
Skewness	1.9270624
Sum	1.534622 × 10¹¹
Variance	1.301116 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100173932	1	< 0.1%
100180452	1	< 0.1%
15754	1	< 0.1%
15696	1	< 0.1%
100179336	1	< 0.1%
100176790	1	< 0.1%
11154	1	< 0.1%
100183183	1	< 0.1%
13056	1	< 0.1%
10692	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
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%
44	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%
100186804	1	< 0.1%
100186803	1	< 0.1%

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

HIGH CORRELATION

Distinct	7412
Distinct (%)	74.1%
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.2987998 × 10¹³

Descriptive statistics

Standard deviation	5.3362871 × 10¹²
Coefficient of variation (CV)	1.1671584 × 10^-6
Kurtosis	-1.1695958
Mean	4.5720332 × 10¹⁸
Median Absolute Deviation (MAD)	3.0019968 × 10¹²
Skewness	-0.53645056
Sum	-9.1469247 × 10¹⁸
Variance	2.847596 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4572025021104030000	32	0.3%
4572025023100320000	24	0.2%
4572025021104060000	23	0.2%
4572025023102840000	22	0.2%
4572025021104790000	17	0.2%
4572031025110530000	17	0.2%
4572038029105030000	15	0.1%
4572025021103660000	14	0.1%
4572037024104450000	14	0.1%
4572025022101250000	13	0.1%
Other values (7402)	9809	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	2	< 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%
4572040026200400000	1	< 0.1%
4572040026110540000	1	< 0.1%
4572040026110460000	1	< 0.1%
4572040026109930000	1	< 0.1%
4572040026109900000	1	< 0.1%
4572040026109880000	1	< 0.1%
4572040026109760000	1	< 0.1%
4572040026109500000	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	용적률	건물군관리번호	필지고유번호(PNU)
공간정보관리번호	1.000	0.848	0.853	0.848	0.851	0.156	0.389	0.852
X좌표최소값	0.848	1.000	0.727	1.000	0.729	0.100	0.068	0.789
Y좌표최소값	0.853	0.727	1.000	0.727	0.998	0.122	0.071	0.829
X좌표최대값	0.848	1.000	0.727	1.000	0.729	0.100	0.066	0.788
Y좌표최대값	0.851	0.729	0.998	0.729	1.000	0.125	0.068	0.829
용적률	0.156	0.100	0.122	0.100	0.125	1.000	0.022	0.096
건물군관리번호	0.389	0.068	0.071	0.066	0.068	0.022	1.000	0.071
필지고유번호(PNU)	0.852	0.789	0.829	0.788	0.829	0.096	0.071	1.000

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	용적률	건물군관리번호	필지고유번호(PNU)
공간정보관리번호	1.000	-0.302	0.162	-0.301	0.163	-0.041	0.078	0.694
X좌표최소값	-0.302	1.000	0.446	1.000	0.445	0.005	0.028	-0.463
Y좌표최소값	0.162	0.446	1.000	0.446	1.000	-0.064	0.004	0.230
X좌표최대값	-0.301	1.000	0.446	1.000	0.445	0.003	0.027	-0.462
Y좌표최대값	0.163	0.445	1.000	0.445	1.000	-0.064	0.003	0.230
용적률	-0.041	0.005	-0.064	0.003	-0.064	1.000	0.107	-0.039
건물군관리번호	0.078	0.028	0.004	0.027	0.003	0.107	1.000	0.009
필지고유번호(PNU)	0.694	-0.463	0.230	-0.462	0.230	-0.039	0.009	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)
6941	6999	23347736	24829979	23349911	24831782	45.31	100173932	4572037021105750000
8451	8563	23489076	26218519	23492980	26222460	0.0	6789	4572038025111410000
11840	12035	23494358	25242284	23500680	25244993	0.0	100184986	4572025032106020000
5167	5393	23666886	24556215	23669700	24558595	33.17	100175292	4572035022107240000
10502	10801	23492052	24459160	23494404	24461890	0.0	11592	4572035023100200000
2216	2458	23418641	25272504	23421704	25275962	15.07	7634	4572025032107730000
953	899	23814903	25432832	23818633	25434771	25.01	6923	4572025022102840000
6987	7303	23583372	24952946	23586659	24954979	23.49	16204	4572037022100930000
10448	10558	23501737	27865697	23503982	27867835	34.83	10378	4572040026101560000
5078	4699	24975608	25844548	24978422	25848366	34.0	9047	4572033026100850000

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	용적률	건물군관리번호	필지고유번호(PNU)
2251	2357	23646227	25339352	23648841	25342287	9.64	6234	4572025031100750000
9742	9800	24545028	25279849	24546298	25283004	8.43	100181172	4572025027108700000
9715	9773	23850824	27521254	23852918	27523253	21.68	9116	4572040021101070000
9395	9454	23954361	25656408	23957501	25659117	10.53	100181775	4572025033111300000
6387	6037	23543679	24473356	23546254	24475622	23.82	16639	4572035029109270000
6313	6366	22896678	24223007	22899419	24225974	30.52	14556	4572036023104220000
883	1216	23753725	25178801	23758660	25184269	152.28	12905	4572025023106900000
1576	1222	23778816	25001979	23782655	25009908	0.0	5464	4572025024109880000
465	410	24141028	25221651	24142225	25222406	26.61	100182953	4572025029102870000
9156	9512	24376228	26688240	24379557	26691272	16.84	14969	4572039023109700000

Overview

Variables

Interactions

Correlations

Missing values

Sample