gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	49
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.3 KiB
Average record size in memory	90.6 B

Variable types

Numeric	8
Categorical	1
DateTime	1

Dataset

Description	전북특별자치도 진안군 도시계획정보시스템 공공 문화체육시설 집행에 대한 데이터로 공간정보관리번호, X좌표 및 Y좌표 정보, 라벨명, 면적_도형, 길이_도형 등 정보를 제공합니다.
Author	전북특별자치도 진안군
URL	https://www.data.go.kr/data/15119128/fileData.do

Alerts

`X좌표최소값` is highly overall correlated with `Y좌표최소값` and 1 other fields	High correlation
`Y좌표최소값` is highly overall correlated with `X좌표최소값` and 2 other fields	High correlation
`X좌표최대값` is highly overall correlated with `X좌표최소값` and 2 other fields	High correlation
`Y좌표최대값` is highly overall correlated with `Y좌표최소값` and 1 other fields	High correlation
`면적_도형` is highly overall correlated with `길이_도형` and 1 other fields	High correlation
`길이_도형` is highly overall correlated with `면적_도형` and 1 other fields	High correlation
`라벨명` is highly overall correlated with `면적_도형` and 1 other fields	High correlation
`공간정보관리번호` has unique values	Unique

Reproduction

Analysis started	2024-03-14 12:01:36.689135
Analysis finished	2024-03-14 12:01:51.932480
Duration	15.24 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

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

UNIQUE

Distinct	49
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	85

Minimum	61
Maximum	109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	61
5-th percentile	63.4
Q1	73
median	85
Q3	97
95-th percentile	106.6
Maximum	109
Range	48
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	14.28869
Coefficient of variation (CV)	0.16810224
Kurtosis	-1.2
Mean	85
Median Absolute Deviation (MAD)	12
Skewness	0
Sum	4165
Variance	204.16667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
61	1	2.0%
98	1	2.0%
88	1	2.0%
89	1	2.0%
90	1	2.0%
91	1	2.0%
92	1	2.0%
93	1	2.0%
94	1	2.0%
95	1	2.0%
Other values (39)	39	79.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61	1	2.0%
62	1	2.0%
63	1	2.0%
64	1	2.0%
65	1	2.0%
66	1	2.0%
67	1	2.0%
68	1	2.0%
69	1	2.0%
70	1	2.0%

Value	Count	Frequency (%)
109	1	2.0%
108	1	2.0%
107	1	2.0%
106	1	2.0%
105	1	2.0%
104	1	2.0%
103	1	2.0%
102	1	2.0%
101	1	2.0%
100	1	2.0%

X좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23808149

Minimum	22830318
Maximum	25166566
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	22830318
5-th percentile	22912516
Q1	23350454
median	23789695
Q3	23924365
95-th percentile	25108392
Maximum	25166566
Range	2336248
Interquartile range (IQR)	573911

Descriptive statistics

Standard deviation	641233.41
Coefficient of variation (CV)	0.026933359
Kurtosis	-0.056390044
Mean	23808149
Median Absolute Deviation (MAD)	406983
Skewness	0.73249534
Sum	1.1665993 × 10⁹
Variance	4.1118029 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
23815488	2	4.1%
24679113	1	2.0%
23755792	1	2.0%
22830318	1	2.0%
23382712	1	2.0%
23826266	1	2.0%
23815744	1	2.0%
23785488	1	2.0%
23326606	1	2.0%
23350454	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22830318	1	2.0%
22890780	1	2.0%
22910224	1	2.0%
22915953	1	2.0%
22932876	1	2.0%
23006892	1	2.0%
23201837	1	2.0%
23244788	1	2.0%
23249338	1	2.0%
23291292	1	2.0%

Value	Count	Frequency (%)
25166566	1	2.0%
25150014	1	2.0%
25114203	1	2.0%
25099676	1	2.0%
25043609	1	2.0%
24976922	1	2.0%
24679113	1	2.0%
24662934	1	2.0%
24444455	1	2.0%
24385675	1	2.0%

Y좌표최소값
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25612581

Minimum	24113721
Maximum	27537767
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	24113721
5-th percentile	24322039
Q1	25128235
median	25535922
Q3	25986493
95-th percentile	27464382
Maximum	27537767
Range	3424046
Interquartile range (IQR)	858258

Descriptive statistics

Standard deviation	888466.63
Coefficient of variation (CV)	0.034688681
Kurtosis	0.054641131
Mean	25612581
Median Absolute Deviation (MAD)	450571
Skewness	0.5308021
Sum	1.2550165 × 10⁹
Variance	7.8937296 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
25438859	2	4.1%
27406798	1	2.0%
25558381	1	2.0%
25922282	1	2.0%
24241511	1	2.0%
25464163	1	2.0%
25453682	1	2.0%
25565197	1	2.0%
24835691	1	2.0%
24807373	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24113721	1	2.0%
24241511	1	2.0%
24319227	1	2.0%
24326257	1	2.0%
24351535	1	2.0%
24478319	1	2.0%
24517972	1	2.0%
24540714	1	2.0%
24799198	1	2.0%
24807373	1	2.0%

Value	Count	Frequency (%)
27537767	1	2.0%
27512765	1	2.0%
27502772	1	2.0%
27406798	1	2.0%
27389828	1	2.0%
26671639	1	2.0%
26639557	1	2.0%
26367204	1	2.0%
26359505	1	2.0%
26019445	1	2.0%

X좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23829751

Minimum	22911925
Maximum	25200538
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	22911925
5-th percentile	22962966
Q1	23366970
median	23805767
Q3	23943653
95-th percentile	25122731
Maximum	25200538
Range	2288613
Interquartile range (IQR)	576683

Descriptive statistics

Standard deviation	633826.81
Coefficient of variation (CV)	0.02659813
Kurtosis	-0.022332682
Mean	23829751
Median Absolute Deviation (MAD)	392861
Skewness	0.78163168
Sum	1.1676578 × 10⁹
Variance	4.0173643 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
23825268	2	4.1%
24690793	1	2.0%
23772448	1	2.0%
23019980	1	2.0%
23460612	1	2.0%
23839476	1	2.0%
23832567	1	2.0%
23805767	1	2.0%
23343565	1	2.0%
23366970	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22911925	1	2.0%
22925934	1	2.0%
22946667	1	2.0%
22987415	1	2.0%
23019980	1	2.0%
23026133	1	2.0%
23212454	1	2.0%
23255292	1	2.0%
23267032	1	2.0%
23306156	1	2.0%

Value	Count	Frequency (%)
25200538	1	2.0%
25165309	1	2.0%
25126434	1	2.0%
25117176	1	2.0%
25057133	1	2.0%
24988485	1	2.0%
24690793	1	2.0%
24674746	1	2.0%
24455609	1	2.0%
24398337	1	2.0%

Y좌표최대값
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25632291

Minimum	24187928
Maximum	27555377
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	24187928
5-th percentile	24336490
Q1	25156054
median	25555447
Q3	26009647
95-th percentile	27477369
Maximum	27555377
Range	3367449
Interquartile range (IQR)	853593

Descriptive statistics

Standard deviation	885547.66
Coefficient of variation (CV)	0.034548128
Kurtosis	0.038388232
Mean	25632291
Median Absolute Deviation (MAD)	454200
Skewness	0.53987375
Sum	1.2559822 × 10⁹
Variance	7.8419467 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
25448413	2	4.1%
27426880	1	2.0%
25584107	1	2.0%
26054386	1	2.0%
24294316	1	2.0%
25477503	1	2.0%
25470189	1	2.0%
25582772	1	2.0%
24850744	1	2.0%
24823386	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24187928	1	2.0%
24294316	1	2.0%
24335676	1	2.0%
24337710	1	2.0%
24370881	1	2.0%
24506799	1	2.0%
24533533	1	2.0%
24551127	1	2.0%
24814211	1	2.0%
24823386	1	2.0%

Value	Count	Frequency (%)
27555377	1	2.0%
27525081	1	2.0%
27511029	1	2.0%
27426880	1	2.0%
27406638	1	2.0%
26689022	1	2.0%
26650727	1	2.0%
26378531	1	2.0%
26368599	1	2.0%
26054386	1	2.0%

도면번호
Real number (ℝ)

Distinct	19
Distinct (%)	38.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.2653061

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	9
95-th percentile	16.6
Maximum	19
Range	18
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	5.3881642
Coefficient of variation (CV)	0.86000014
Kurtosis	-0.36588485
Mean	6.2653061
Median Absolute Deviation (MAD)	3
Skewness	0.91401623
Sum	307
Variance	29.032313
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	11	22.4%
3	5	10.2%
2	5	10.2%
4	4	8.2%
6	3	6.1%
5	3	6.1%
8	2	4.1%
9	2	4.1%
14	2	4.1%
7	2	4.1%
Other values (9)	10	20.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11	22.4%
2	5	10.2%
3	5	10.2%
4	4	8.2%
5	3	6.1%
6	3	6.1%
7	2	4.1%
8	2	4.1%
9	2	4.1%
10	1	2.0%

Value	Count	Frequency (%)
19	1	2.0%
18	1	2.0%
17	1	2.0%
16	1	2.0%
15	2	4.1%
14	2	4.1%
13	1	2.0%
12	1	2.0%
11	1	2.0%
10	1	2.0%

라벨명
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	22.4%
Missing	0
Missing (%)	0.0%
Memory size	520.0 B

청사(국가)	14
초등학교	11
중학교	8
고등학교	4
기타 공공청사시설	3
Other values (6)	9

Length

Max length	9
Median length	7
Mean length	5.1632653
Min length	3

Unique

Unique	3 ?
Unique (%)	6.1%

Sample

1st row	청사(국가)
2nd row	초등학교
3rd row	지방자치단체
4th row	초등학교
5th row	중학교

Common Values

Value	Count	Frequency (%)
청사(국가)	14	28.6%
초등학교	11	22.4%
중학교	8	16.3%
고등학교	4	8.2%
기타 공공청사시설	3	6.1%
기타 학교시설	2	4.1%
기타 문화시설	2	4.1%
기타 체육시설	2	4.1%
지방자치단체	1	2.0%
골프장	1	2.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
청사(국가	14	23.7%
초등학교	11	18.6%
기타	10	16.9%
중학교	8	13.6%
고등학교	4	6.8%
공공청사시설	3	5.1%
학교시설	2	3.4%
문화시설	2	3.4%
체육시설	2	3.4%
지방자치단체	1	1.7%
Other values (2)	2	3.4%

면적_도형
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	53977.137

Minimum	4090.22
Maximum	1405821.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	4090.22
5-th percentile	4925.162
Q1	8492.89
median	12512.63
Q3	18921.34
95-th percentile	154372.65
Maximum	1405821.8
Range	1401731.6
Interquartile range (IQR)	10428.45

Descriptive statistics

Standard deviation	205721.12
Coefficient of variation (CV)	3.811264
Kurtosis	40.973528
Mean	53977.137
Median Absolute Deviation (MAD)	5050.97
Skewness	6.2457519
Sum	2644879.7
Variance	4.2321177 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
5702.27	2	4.1%
12512.63	1	2.0%
20252.66	1	2.0%
1405821.78	1	2.0%
199135.38	1	2.0%
9903.66	1	2.0%
14378.2	1	2.0%
19524.63	1	2.0%
14744.59	1	2.0%
14550.94	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4090.22	1	2.0%
4123.05	1	2.0%
4407.09	1	2.0%
5702.27	2	4.1%
5736.8	1	2.0%
6028.69	1	2.0%
6360.63	1	2.0%
6595.86	1	2.0%
6630.13	1	2.0%
7461.66	1	2.0%

Value	Count	Frequency (%)
1405821.78	1	2.0%
375963.15	1	2.0%
199135.38	1	2.0%
87228.56	1	2.0%
31280.96	1	2.0%
28231.3	1	2.0%
24544.15	1	2.0%
24331.28	1	2.0%
20304.61	1	2.0%
20252.66	1	2.0%

길이_도형
Real number (ℝ)

HIGH CORRELATION

Distinct	48
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	722.89347

Minimum	272.89
Maximum	6147.12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	569.0 B

Quantile statistics

Minimum	272.89
5-th percentile	313.336
Q1	400.22
median	488.09
Q3	640.95
95-th percentile	2086.886
Maximum	6147.12
Range	5874.23
Interquartile range (IQR)	240.73

Descriptive statistics

Standard deviation	917.31663
Coefficient of variation (CV)	1.2689513
Kurtosis	26.563087
Mean	722.89347
Median Absolute Deviation (MAD)	111.77
Skewness	4.854461
Sum	35421.78
Variance	841469.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
315.37	2	4.1%
599.86	1	2.0%
778.88	1	2.0%
6147.12	1	2.0%
2621.15	1	2.0%
400.22	1	2.0%
474.22	1	2.0%
655.09	1	2.0%
519.6	1	2.0%
525.68	1	2.0%
Other values (38)	38	77.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
272.89	1	2.0%
290.84	1	2.0%
311.98	1	2.0%
315.37	2	4.1%
328.8	1	2.0%
330.17	1	2.0%
336.12	1	2.0%
343.27	1	2.0%
361.4	1	2.0%
365.09	1	2.0%

Value	Count	Frequency (%)
6147.12	1	2.0%
2636.69	1	2.0%
2621.15	1	2.0%
1285.49	1	2.0%
957.88	1	2.0%
841.29	1	2.0%
823.19	1	2.0%
817.66	1	2.0%
805.22	1	2.0%
778.88	1	2.0%

현황도형 생성일지
Date

Distinct	11
Distinct (%)	22.4%
Missing	0
Missing (%)	0.0%
Memory size	520.0 B

Minimum	2013-01-02 00:00:00
Maximum	2020-12-10 00:00:00

Histogram

Histogram with fixed size bins (bins=11)

Phik (φk)
Auto

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	도면번호	라벨명	면적_도형	길이_도형	현황도형 생성일지
공간정보관리번호	1.000	0.545	0.606	0.517	0.545	0.000	0.393	0.000	0.000	0.555
X좌표최소값	0.545	1.000	0.816	0.992	0.739	0.000	0.000	0.298	0.000	0.000
Y좌표최소값	0.606	0.816	1.000	0.738	0.995	0.530	0.000	0.000	0.000	0.000
X좌표최대값	0.517	0.992	0.738	1.000	0.690	0.000	0.163	0.365	0.000	0.000
Y좌표최대값	0.545	0.739	0.995	0.690	1.000	0.465	0.000	0.000	0.494	0.000
도면번호	0.000	0.000	0.530	0.000	0.465	1.000	0.000	0.000	0.000	0.000
라벨명	0.393	0.000	0.000	0.163	0.000	0.000	1.000	0.924	0.926	0.902
면적_도형	0.000	0.298	0.000	0.365	0.000	0.000	0.924	1.000	1.000	0.817
길이_도형	0.000	0.000	0.000	0.000	0.494	0.000	0.926	1.000	1.000	0.769
현황도형 생성일지	0.555	0.000	0.000	0.000	0.000	0.000	0.902	0.817	0.769	1.000

Heatmap
Table

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	도면번호	면적_도형	길이_도형	라벨명
공간정보관리번호	1.000	-0.187	0.070	-0.176	0.063	-0.055	-0.060	-0.170	0.161
X좌표최소값	-0.187	1.000	0.514	0.998	0.492	-0.193	-0.183	-0.183	0.000
Y좌표최소값	0.070	0.514	1.000	0.525	0.996	0.097	-0.229	-0.161	0.000
X좌표최대값	-0.176	0.998	0.525	1.000	0.506	-0.207	-0.167	-0.167	0.000
Y좌표최대값	0.063	0.492	0.996	0.506	1.000	0.078	-0.208	-0.141	0.000
도면번호	-0.055	-0.193	0.097	-0.207	0.078	1.000	-0.025	-0.033	0.000
면적_도형	-0.060	-0.183	-0.229	-0.167	-0.208	-0.025	1.000	0.954	0.776
길이_도형	-0.170	-0.183	-0.161	-0.167	-0.141	-0.033	0.954	1.000	0.766
라벨명	0.161	0.000	0.000	0.000	0.000	0.000	0.776	0.766	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좌표최대값	도면번호	라벨명	면적_도형	길이_도형	현황도형 생성일지
0	61	24679113	27406798	24690793	27426880	1	청사(국가)	12512.63	599.86	2013-01-02
1	62	23924365	25499484	23943653	25520831	5	초등학교	20304.61	723.7	2013-01-02
2	63	23705657	25371063	23752824	25401791	1	지방자치단체	87228.56	1285.49	2013-01-02
3	64	24444455	25297345	24455609	25311264	1	초등학교	10591.7	425.12	2013-01-02
4	65	25150014	25960037	25165309	25977212	5	중학교	15586.09	591.37	2013-01-02
5	66	22932876	24517972	22946667	24533533	8	초등학교	11758.7	509.95	2013-01-02
6	67	22890780	24478319	22911925	24506799	9	중학교	24331.28	817.66	2013-01-02
7	68	23006892	25535922	23026133	25555447	14	초등학교	12490.34	823.19	2013-01-02
8	69	23868452	26359505	23883585	26368599	16	초등학교	8714.14	421.19	2013-01-02
9	70	24385675	25811028	24398337	25823208	3	청사(국가)	8234.58	402.55	2013-01-02

	공간정보관리번호	X좌표최소값	Y좌표최소값	X좌표최대값	Y좌표최대값	도면번호	라벨명	면적_도형	길이_도형	현황도형 생성일지
39	100	22910224	24113721	22987415	24187928	1	기타 연구시설	375963.15	2636.69	2016-03-11
40	101	23567399	25663567	23580528	25674568	1	기타 문화시설	9400.73	405.58	2019-08-22
41	102	25166566	26019445	25200538	26036877	2	기타 체육시설	28231.3	841.29	2018-11-22
42	103	23201837	25945172	23212454	25958227	3	기타 체육시설	9860.76	407.72	2017-08-28
43	104	23249338	25969616	23267032	25989665	13	초등학교	18921.34	595.29	2013-01-02
44	105	23244788	25967410	23255292	25978514	7	청사(국가)	5736.8	328.8	2018-11-22
45	106	25114203	25986493	25126434	25994317	2	청사(국가)	6630.13	336.12	2020-03-04
46	107	23922731	25547020	23934402	25557254	3	기타 공공청사시설	6028.69	343.27	2019-11-29
47	108	23291292	25996776	23306156	26009647	15	중학교	12933.2	483.11	2013-01-02
48	109	23870443	25512293	23882228	25527905	4	청사(국가)	13046.93	466.48	2020-12-10

Overview

Variables

Common Values

Length

Interactions

Correlations

Missing values

Sample