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

Categorical	2
Numeric	6

Dataset

Description	시군구코드 읍면동코드 리코드 토지구분 본번 부번 동일련번호 주택공시가격
Author	충청남도 태안군
URL	https://www.data.go.kr/data/15013655/fileData.do

Alerts

`시군구코드` has constant value ""	Constant
`토지구분` is highly imbalanced (94.6%)	Imbalance
`부번` has 3140 (31.4%) zeros	Zeros
`동일련번호` has 3784 (37.8%) zeros	Zeros

Reproduction

Analysis started	2024-04-17 14:43:59.148508
Analysis finished	2024-04-17 14:44:03.131345
Duration	3.98 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

시군구코드
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

44825	10000

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	44825
2nd row	44825
3rd row	44825
4th row	44825
5th row	44825

Common Values

Value	Count	Frequency (%)
44825	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
44825	10000	100.0%

읍면동코드
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	299.7631

Minimum	250
Maximum	360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	250
5-th percentile	250
Q1	253
median	320
Q3	340
95-th percentile	360
Maximum	360
Range	110
Interquartile range (IQR)	87

Descriptive statistics

Standard deviation	42.545778
Coefficient of variation (CV)	0.14193134
Kurtosis	-1.7070327
Mean	299.7631
Median Absolute Deviation (MAD)	30
Skewness	-0.10571967
Sum	2997631
Variance	1810.1432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
250	2262	22.6%
253	1887	18.9%
320	1175	11.8%
340	1155	11.6%
330	1021	10.2%
350	991	9.9%
310	820	8.2%
360	689	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
250	2262	22.6%
253	1887	18.9%
310	820	8.2%
320	1175	11.8%
330	1021	10.2%
340	1155	11.6%
350	991	9.9%
360	689	6.9%

Value	Count	Frequency (%)
360	689	6.9%
350	991	9.9%
340	1155	11.6%
330	1021	10.2%
320	1175	11.8%
310	820	8.2%
253	1887	18.9%
250	2262	22.6%

리코드
Real number (ℝ)

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.0237

Minimum	21
Maximum	33
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	21
5-th percentile	21
Q1	22
median	23
Q3	26
95-th percentile	29
Maximum	33
Range	12
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.8491315
Coefficient of variation (CV)	0.1185967
Kurtosis	0.22614014
Mean	24.0237
Median Absolute Deviation (MAD)	2
Skewness	0.92457763
Sum	240237
Variance	8.1175501
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
21	2264	22.6%
22	1612	16.1%
23	1583	15.8%
24	912	9.1%
26	773	7.7%
27	757	7.6%
25	710	7.1%
28	665	6.7%
29	296	3.0%
30	140	1.4%
Other values (3)	288	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	2264	22.6%
22	1612	16.1%
23	1583	15.8%
24	912	9.1%
25	710	7.1%
26	773	7.7%
27	757	7.6%
28	665	6.7%
29	296	3.0%
30	140	1.4%

Value	Count	Frequency (%)
33	132	1.3%
32	49	0.5%
31	107	1.1%
30	140	1.4%
29	296	3.0%
28	665	6.7%
27	757	7.6%
26	773	7.7%
25	710	7.1%
24	912	9.1%

토지구분
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

1	9939
2	61

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	9939	99.4%
2	61	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	9939	99.4%
2	61	0.6%

본번
Real number (ℝ)

Distinct	1551
Distinct (%)	15.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	583.256

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

Quantile statistics

Minimum	1
5-th percentile	42
Q1	269
median	481
Q3	785
95-th percentile	1370.05
Maximum	3483
Range	3482
Interquartile range (IQR)	516

Descriptive statistics

Standard deviation	467.76723
Coefficient of variation (CV)	0.80199301
Kurtosis	5.6693863
Mean	583.256
Median Absolute Deviation (MAD)	248
Skewness	1.8178712
Sum	5832560
Variance	218806.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
339	71	0.7%
600	39	0.4%
1	38	0.4%
353	37	0.4%
1525	35	0.4%
63	34	0.3%
333	33	0.3%
8	32	0.3%
172	31	0.3%
680	31	0.3%
Other values (1541)	9619	96.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	38	0.4%
2	14	0.1%
3	5	0.1%
4	18	0.2%
5	16	0.2%
6	17	0.2%
7	6	0.1%
8	32	0.3%
9	11	0.1%
10	10	0.1%

Value	Count	Frequency (%)
3483	1	< 0.1%
3456	1	< 0.1%
3452	1	< 0.1%
3446	1	< 0.1%
3282	2	< 0.1%
3271	2	< 0.1%
3268	1	< 0.1%
3267	1	< 0.1%
3266	1	< 0.1%
3265	1	< 0.1%

부번
Real number (ℝ)

ZEROS

Distinct	249
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.3117

Minimum	0
Maximum	645
Zeros	3140
Zeros (%)	31.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	40.989515
Coefficient of variation (CV)	3.329314
Kurtosis	82.024416
Mean	12.3117
Median Absolute Deviation (MAD)	2
Skewness	7.9561189
Sum	123117
Variance	1680.1404
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3140	31.4%
1	1389	13.9%
2	954	9.5%
3	603	6.0%
4	488	4.9%
5	357	3.6%
6	285	2.9%
7	256	2.6%
8	196	2.0%
9	160	1.6%
Other values (239)	2172	21.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3140	31.4%
1	1389	13.9%
2	954	9.5%
3	603	6.0%
4	488	4.9%
5	357	3.6%
6	285	2.9%
7	256	2.6%
8	196	2.0%
9	160	1.6%

Value	Count	Frequency (%)
645	3	< 0.1%
638	2	< 0.1%
637	1	< 0.1%
564	1	< 0.1%
549	1	< 0.1%
519	1	< 0.1%
510	5	0.1%
509	1	< 0.1%
469	1	< 0.1%
467	1	< 0.1%

동일련번호
Real number (ℝ)

ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7451

Minimum	0
Maximum	21
Zeros	3784
Zeros (%)	37.8%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	0.90233442
Coefficient of variation (CV)	1.2110246
Kurtosis	93.102139
Mean	0.7451
Median Absolute Deviation (MAD)	0
Skewness	6.310187
Sum	7451
Variance	0.81420741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	5573	55.7%
0	3784	37.8%
2	408	4.1%
3	108	1.1%
4	61	0.6%
5	29	0.3%
10	10	0.1%
6	9	0.1%
7	4	< 0.1%
8	4	< 0.1%
Other values (6)	10	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3784	37.8%
1	5573	55.7%
2	408	4.1%
3	108	1.1%
4	61	0.6%
5	29	0.3%
6	9	0.1%
7	4	< 0.1%
8	4	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
20	2	< 0.1%
13	1	< 0.1%
12	1	< 0.1%
11	2	< 0.1%
10	10	0.1%
9	3	< 0.1%
8	4	< 0.1%
7	4	< 0.1%
6	9	0.1%

주택공시가격
Real number (ℝ)

Distinct	1451
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	59555583

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

Quantile statistics

Minimum	1580000
5-th percentile	10400000
Q1	24000000
median	44400000
Q3	75600000
95-th percentile	1.53 × 10⁸
Maximum	6.13 × 10⁸
Range	6.1142 × 10⁸
Interquartile range (IQR)	51600000

Descriptive statistics

Standard deviation	56565771
Coefficient of variation (CV)	0.94979795
Kurtosis	16.935426
Mean	59555583
Median Absolute Deviation (MAD)	23800000
Skewness	3.2420416
Sum	5.9555583 × 10¹¹
Variance	3.1996864 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102000000	38	0.4%
122000000	33	0.3%
11500000	32	0.3%
105000000	31	0.3%
104000000	30	0.3%
101000000	30	0.3%
100000000	30	0.3%
108000000	28	0.3%
106000000	27	0.3%
112000000	26	0.3%
Other values (1441)	9695	97.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1580000	1	< 0.1%
2390000	1	< 0.1%
2460000	1	< 0.1%
2560000	1	< 0.1%
3170000	1	< 0.1%
3240000	1	< 0.1%
3330000	1	< 0.1%
3650000	2	< 0.1%
3660000	1	< 0.1%
3730000	1	< 0.1%

Value	Count	Frequency (%)
613000000	1	< 0.1%
583000000	1	< 0.1%
568000000	1	< 0.1%
559000000	1	< 0.1%
525000000	1	< 0.1%
522000000	1	< 0.1%
520000000	1	< 0.1%
512000000	1	< 0.1%
506000000	1	< 0.1%
502000000	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	읍면동코드	리코드	토지구분	본번	부번	동일련번호	주택공시가격
읍면동코드	1.000	0.549	0.071	0.342	0.168	0.087	0.189
리코드	0.549	1.000	0.065	0.339	0.163	0.053	0.125
토지구분	0.071	0.065	1.000	0.133	0.052	0.074	0.056
본번	0.342	0.339	0.133	1.000	0.147	0.133	0.177
부번	0.168	0.163	0.052	0.147	1.000	0.191	0.200
동일련번호	0.087	0.053	0.074	0.133	0.191	1.000	0.000
주택공시가격	0.189	0.125	0.056	0.177	0.200	0.000	1.000

Heatmap
Table

	읍면동코드	리코드	본번	부번	동일련번호	주택공시가격	토지구분
읍면동코드	1.000	0.243	-0.036	-0.222	-0.192	-0.196	0.062
리코드	0.243	1.000	-0.054	-0.090	0.029	-0.113	0.051
본번	-0.036	-0.054	1.000	-0.007	-0.064	0.076	0.102
부번	-0.222	-0.090	-0.007	1.000	0.102	0.186	0.040
동일련번호	-0.192	0.029	-0.064	0.102	1.000	0.134	0.055
주택공시가격	-0.196	-0.113	0.076	0.186	0.134	1.000	0.043
토지구분	0.062	0.051	0.102	0.040	0.055	0.043	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

	시군구코드	읍면동코드	리코드	토지구분	본번	부번	동일련번호	주택공시가격
3503	44825	253	23	1	921	7	0	39000000
1438	44825	250	24	1	116	0	1	49800000
298	44825	250	21	1	361	1	1	26700000
166	44825	250	21	1	328	12	1	55100000
5484	44825	320	23	1	376	17	1	32400000
4993	44825	310	23	1	1673	3	0	158000000
2434	44825	253	21	1	249	54	1	153000000
5778	44825	320	25	1	471	0	1	25400000
5620	44825	320	24	1	659	7	1	19200000
2485	44825	253	21	1	339	321	1	302000000

	시군구코드	읍면동코드	리코드	토지구분	본번	부번	동일련번호	주택공시가격
8636	44825	350	22	1	619	0	0	12800000
1855	44825	250	28	1	276	2	1	32900000
4297	44825	310	21	1	309	3	0	19200000
3052	44825	253	22	1	2	123	0	20500000
3226	44825	253	22	1	1196	5	0	21900000
701	44825	250	21	1	812	2	0	182000000
9273	44825	350	29	1	200	0	0	12000000
9427	44825	350	31	1	144	4	0	44500000
9896	44825	360	23	1	519	0	2	7150000
3888	44825	253	24	1	1183	2	0	131000000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample