gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	517.6 KiB
Average record size in memory	53.0 B

Variable types

Numeric	4
Categorical	1

Dataset

Description	KCB(코리아크레딧뷰로)에서 제공한 데이터의 통계 자료로 월별, 시군별(행정동코드), 연령구간(만18세이상 ~ 104세이하를 5세단위로 구분), 월신용평균현황(0~1,000점)을 확인할 수 있습니다. <성별> 1 남성, 2 여성 <연령구간> 10 : 20세미만, 21 : 25세미만, 22 : 30세미만, 31 : 35세미만, 32 : 40세미만, 41 : 45세미만, 42 : 50세미만, 51 : 55세미만, 52 : 60세미만, 61 : 65세미만, 62 : 70세미만, 70 : 70세이상 본 자료는 상업적 이용금지 및 재배포할 수 없습니다.
Author	충청남도
URL	https://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=2162

Reproduction

Analysis started	2024-01-09 21:37:38.295081
Analysis finished	2024-01-09 21:37:40.062428
Duration	1.77 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준연월
Real number (ℝ)

Distinct	18
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201638.61

Minimum	201601
Maximum	201712
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	201601
5-th percentile	201601
Q1	201605
median	201609
Q3	201702
95-th percentile	201712
Maximum	201712
Range	111
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	46.953928
Coefficient of variation (CV)	0.00023286179
Kurtosis	-1.3769362
Mean	201638.61
Median Absolute Deviation (MAD)	5
Skewness	0.76950765
Sum	2.0163861 × 10⁹
Variance	2204.6713
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
201712	605	6.0%
201601	593	5.9%
201611	587	5.9%
201701	587	5.9%
201702	586	5.9%
201605	583	5.8%
201612	576	5.8%
201606	568	5.7%
201607	567	5.7%
201710	566	5.7%
Other values (8)	4182	41.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201601	593	5.9%
201602	560	5.6%
201603	557	5.6%
201604	540	5.4%
201605	583	5.8%
201606	568	5.7%
201607	567	5.7%
201608	551	5.5%
201609	561	5.6%
201610	556	5.6%

Value	Count	Frequency (%)
201712	605	6.0%
201711	565	5.7%
201710	566	5.7%
201703	292	2.9%
201702	586	5.9%
201701	587	5.9%
201612	576	5.8%
201611	587	5.9%
201610	556	5.6%
201609	561	5.6%

행정동코드
Real number (ℝ)

Distinct	208
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44418992

Minimum	44131250
Maximum	44825360
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	44131250
5-th percentile	44131530
Q1	44180360
median	44230400
Q3	44770310
95-th percentile	44810380
Maximum	44825360
Range	694110
Interquartile range (IQR)	589950

Descriptive statistics

Standard deviation	290296.7
Coefficient of variation (CV)	0.0065354185
Kurtosis	-1.7389247
Mean	44418992
Median Absolute Deviation (MAD)	96880
Skewness	0.42519573
Sum	4.4418992 × 10¹¹
Variance	8.4272176 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44270390	67	0.7%
44131330	64	0.6%
44810380	62	0.6%
44180400	61	0.6%
44760310	61	0.6%
44710360	60	0.6%
44825310	60	0.6%
44131250	58	0.6%
44770340	58	0.6%
44760320	58	0.6%
Other values (198)	9391	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44131250	58	0.6%
44131310	55	0.5%
44131320	43	0.4%
44131330	64	0.6%
44131340	38	0.4%
44131350	46	0.5%
44131360	41	0.4%
44131370	48	0.5%
44131510	35	0.4%
44131520	49	0.5%

Value	Count	Frequency (%)
44825360	53	0.5%
44825350	57	0.6%
44825340	56	0.6%
44825330	44	0.4%
44825320	46	0.5%
44825310	60	0.6%
44825253	39	0.4%
44825250	40	0.4%
44810400	55	0.5%
44810390	50	0.5%

성별
Categorical

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

2	5022
1	4978

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	2
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
2	5022	50.2%
1	4978	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	5022	50.2%
1	4978	49.8%

연령구간
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.2668

Minimum	10
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	10
5-th percentile	10
Q1	31
median	41
Q3	52
95-th percentile	70
Maximum	70
Range	60
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	17.697071
Coefficient of variation (CV)	0.42884526
Kurtosis	-1.0703134
Mean	41.2668
Median Absolute Deviation (MAD)	11
Skewness	-0.076480123
Sum	412668
Variance	313.18634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
32	873	8.7%
61	849	8.5%
31	847	8.5%
52	845	8.5%
62	845	8.5%
22	845	8.5%
41	841	8.4%
42	822	8.2%
51	816	8.2%
10	810	8.1%
Other values (2)	1607	16.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	810	8.1%
21	805	8.1%
22	845	8.5%
31	847	8.5%
32	873	8.7%
41	841	8.4%
42	822	8.2%
51	816	8.2%
52	845	8.5%
61	849	8.5%

Value	Count	Frequency (%)
70	802	8.0%
62	845	8.5%
61	849	8.5%
52	845	8.5%
51	816	8.2%
42	822	8.2%
41	841	8.4%
32	873	8.7%
31	847	8.5%
22	845	8.5%

월신용평점평균
Real number (ℝ)

Distinct	257
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	758.9441

Minimum	597
Maximum	927
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	597
5-th percentile	702
Q1	728
median	757
Q3	787
95-th percentile	824
Maximum	927
Range	330
Interquartile range (IQR)	59

Descriptive statistics

Standard deviation	39.364704
Coefficient of variation (CV)	0.051867725
Kurtosis	-0.0094925806
Mean	758.9441
Median Absolute Deviation (MAD)	30
Skewness	0.19562167
Sum	7589441
Variance	1549.5799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
723	136	1.4%
722	136	1.4%
728	124	1.2%
726	124	1.2%
721	121	1.2%
725	118	1.2%
727	117	1.2%
724	116	1.2%
782	111	1.1%
720	109	1.1%
Other values (247)	8788	87.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
597	1	< 0.1%
608	1	< 0.1%
630	1	< 0.1%
631	1	< 0.1%
634	1	< 0.1%
636	1	< 0.1%
638	1	< 0.1%
639	1	< 0.1%
640	1	< 0.1%
641	1	< 0.1%

Value	Count	Frequency (%)
927	1	< 0.1%
916	1	< 0.1%
911	2	< 0.1%
910	1	< 0.1%
908	1	< 0.1%
901	2	< 0.1%
898	1	< 0.1%
897	2	< 0.1%
896	1	< 0.1%
895	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	기준연월	행정동코드	성별	연령구간	월신용평점평균
기준연월	1.000	0.000	0.000	0.000	0.030
행정동코드	0.000	1.000	0.000	0.023	0.170
성별	0.000	0.000	1.000	0.019	0.300
연령구간	0.000	0.023	0.019	1.000	0.476
월신용평점평균	0.030	0.170	0.300	0.476	1.000

Heatmap
Table

	기준연월	행정동코드	연령구간	월신용평점평균	성별
기준연월	1.000	-0.010	-0.004	0.030	0.000
행정동코드	-0.010	1.000	0.000	-0.041	0.000
연령구간	-0.004	0.000	1.000	0.364	0.016
월신용평점평균	0.030	-0.041	0.364	1.000	0.230
성별	0.000	0.000	0.016	0.230	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

	기준연월	행정동코드	성별	연령구간	월신용평점평균
85944	201703	44825360	1	51	755
56212	201609	44790310	2	52	797
74406	201711	44180565	1	70	776
17869	201612	44210535	1	42	775
717	201601	44760380	1	62	807
68847	201710	44825253	2	22	727
15811	201612	44150310	1	52	764
64987	201710	44710310	2	21	745
74321	201711	44790390	1	22	680
32043	201604	44760250	1	61	822

	기준연월	행정동코드	성별	연령구간	월신용평점평균
57724	201609	44150510	2	10	723
5901	201610	44760320	1	31	735
51447	201608	44210320	2	61	815
13835	201611	44800253	1	41	710
6558	201610	44810360	2	62	785
19469	201612	44760340	1	70	748
66705	201710	44760370	1	51	754
31258	201604	44800360	1	41	693
11642	201611	44200250	2	62	785
14517	201611	44200400	1	41	712

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample