gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	870
Missing cells	870
Missing cells (%)	10.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	75.7 KiB
Average record size in memory	89.2 B

Variable types

Numeric	8
Categorical	1
Unsupported	1

Dataset

Description	년월,기관/유형,전화,방문,이메일,게시판,SNS,이동상담,문자,합계
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15735/S/1/datasetView.do

Alerts

`년월` is highly overall correlated with `합계`	High correlation
`전화` is highly overall correlated with `방문` and 2 other fields	High correlation
`방문` is highly overall correlated with `전화` and 2 other fields	High correlation
`이메일` is highly overall correlated with `전화` and 2 other fields	High correlation
`합계` is highly overall correlated with `년월` and 3 other fields	High correlation
`문자` has 870 (100.0%) missing values	Missing
`문자` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`방문` has 123 (14.1%) zeros	Zeros
`이메일` has 426 (49.0%) zeros	Zeros
`게시판` has 697 (80.1%) zeros	Zeros
`SNS` has 851 (97.8%) zeros	Zeros
`이동상담` has 848 (97.5%) zeros	Zeros
`합계` has 158 (18.2%) zeros	Zeros

Reproduction

Analysis started	2024-05-03 21:02:53.181837
Analysis finished	2024-05-03 21:03:08.727390
Duration	15.55 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년월
Real number (ℝ)

HIGH CORRELATION

Distinct	58
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202147.91

Minimum	201907
Maximum	202404
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

Minimum	201907
5-th percentile	201909
Q1	202009
median	202111.5
Q3	202302
95-th percentile	202402
Maximum	202404
Range	497
Interquartile range (IQR)	293

Descriptive statistics

Standard deviation	144.18753
Coefficient of variation (CV)	0.00071327737
Kurtosis	-1.0477929
Mean	202147.91
Median Absolute Deviation (MAD)	104
Skewness	0.0010646508
Sum	1.7586868 × 10⁸
Variance	20790.044
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
202404	15	1.7%
202008	15	1.7%
202108	15	1.7%
202107	15	1.7%
202106	15	1.7%
202105	15	1.7%
202104	15	1.7%
202103	15	1.7%
202102	15	1.7%
202101	15	1.7%
Other values (48)	720	82.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201907	15	1.7%
201908	15	1.7%
201909	15	1.7%
201910	15	1.7%
201911	15	1.7%
201912	15	1.7%
202001	15	1.7%
202002	15	1.7%
202003	15	1.7%
202004	15	1.7%

Value	Count	Frequency (%)
202404	15	1.7%
202403	15	1.7%
202402	15	1.7%
202401	15	1.7%
202312	15	1.7%
202311	15	1.7%
202310	15	1.7%
202309	15	1.7%
202308	15	1.7%
202307	15	1.7%

기관/유형
Categorical

Distinct	15
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	6.9 KiB

교육	58
교통	58
금융	58
기타	58
노무	58
Other values (10)	580

Length

Max length	6
Median length	2
Mean length	3.2
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	교육
2nd row	교통
3rd row	금융
4th row	기타
5th row	노무

Common Values

Value	Count	Frequency (%)
교육	58	6.7%
교통	58	6.7%
금융	58	6.7%
기타	58	6.7%
노무	58	6.7%
문화/관광	58	6.7%
보건/복지	58	6.7%
비즈니스	58	6.7%
안전	58	6.7%
여성/가족	58	6.7%
Other values (5)	290	33.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
교육	58	6.2%
교통	58	6.2%
금융	58	6.2%
기타	58	6.2%
노무	58	6.2%
문화/관광	58	6.2%
보건/복지	58	6.2%
비즈니스	58	6.2%
안전	58	6.2%
여성/가족	58	6.2%
Other values (6)	348	37.5%

전화
Real number (ℝ)

HIGH CORRELATION

Distinct	334
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	217.87126

Minimum	0
Maximum	3957
Zeros	6
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	13
median	36
Q3	221.75
95-th percentile	1374.35
Maximum	3957
Range	3957
Interquartile range (IQR)	208.75

Descriptive statistics

Standard deviation	464.71326
Coefficient of variation (CV)	2.1329718
Kurtosis	15.952084
Mean	217.87126
Median Absolute Deviation (MAD)	31
Skewness	3.7632533
Sum	189548
Variance	215958.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	23	2.6%
9	23	2.6%
5	23	2.6%
4	20	2.3%
8	19	2.2%
6	19	2.2%
15	18	2.1%
2	16	1.8%
11	16	1.8%
3	16	1.8%
Other values (324)	677	77.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.7%
1	12	1.4%
2	16	1.8%
3	16	1.8%
4	20	2.3%
5	23	2.6%
6	19	2.2%
7	23	2.6%
8	19	2.2%
9	23	2.6%

Value	Count	Frequency (%)
3957	1	0.1%
3382	1	0.1%
2731	1	0.1%
2694	1	0.1%
2537	1	0.1%
2402	1	0.1%
2317	1	0.1%
2287	2	0.2%
2259	1	0.1%
2253	1	0.1%

방문
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	158
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.367816

Minimum	0
Maximum	753
Zeros	123
Zeros (%)	14.1%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	6
Q3	31
95-th percentile	210.1
Maximum	753
Range	753
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	91.384469
Coefficient of variation (CV)	2.3818001
Kurtosis	20.740304
Mean	38.367816
Median Absolute Deviation (MAD)	6
Skewness	4.229627
Sum	33380
Variance	8351.1212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	123	14.1%
1	98	11.3%
2	78	9.0%
3	56	6.4%
5	38	4.4%
4	36	4.1%
7	35	4.0%
6	26	3.0%
9	16	1.8%
11	15	1.7%
Other values (148)	349	40.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	123	14.1%
1	98	11.3%
2	78	9.0%
3	56	6.4%
4	36	4.1%
5	38	4.4%
6	26	3.0%
7	35	4.0%
8	14	1.6%
9	16	1.8%

Value	Count	Frequency (%)
753	1	0.1%
730	1	0.1%
613	1	0.1%
611	1	0.1%
584	1	0.1%
573	1	0.1%
551	1	0.1%
524	1	0.1%
516	1	0.1%
508	1	0.1%

이메일
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	77
Distinct (%)	8.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.5149425

Minimum	0
Maximum	587
Zeros	426
Zeros (%)	49.0%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	40.617462
Coefficient of variation (CV)	4.268808
Kurtosis	100.94976
Mean	9.5149425
Median Absolute Deviation (MAD)	1
Skewness	8.8792676
Sum	8278
Variance	1649.7783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	426	49.0%
1	142	16.3%
2	49	5.6%
3	40	4.6%
4	34	3.9%
5	29	3.3%
7	16	1.8%
6	12	1.4%
9	9	1.0%
8	8	0.9%
Other values (67)	105	12.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	426	49.0%
1	142	16.3%
2	49	5.6%
3	40	4.6%
4	34	3.9%
5	29	3.3%
6	12	1.4%
7	16	1.8%
8	8	0.9%
9	9	1.0%

Value	Count	Frequency (%)
587	1	0.1%
565	1	0.1%
357	1	0.1%
279	1	0.1%
269	1	0.1%
245	1	0.1%
244	1	0.1%
241	1	0.1%
179	1	0.1%
160	1	0.1%

게시판
Real number (ℝ)

ZEROS

Distinct	43
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0758621

Minimum	0
Maximum	177
Zeros	697
Zeros (%)	80.1%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	14.985417
Coefficient of variation (CV)	4.8719403
Kurtosis	62.305898
Mean	3.0758621
Median Absolute Deviation (MAD)	0
Skewness	7.4193796
Sum	2676
Variance	224.56271
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0	697	80.1%
1	48	5.5%
2	22	2.5%
3	15	1.7%
4	13	1.5%
10	8	0.9%
9	6	0.7%
7	6	0.7%
6	6	0.7%
13	4	0.5%
Other values (33)	45	5.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	697	80.1%
1	48	5.5%
2	22	2.5%
3	15	1.7%
4	13	1.5%
5	4	0.5%
6	6	0.7%
7	6	0.7%
9	6	0.7%
10	8	0.9%

Value	Count	Frequency (%)
177	1	0.1%
153	1	0.1%
147	1	0.1%
134	1	0.1%
128	1	0.1%
96	1	0.1%
91	1	0.1%
90	1	0.1%
89	1	0.1%
86	2	0.2%

SNS
Real number (ℝ)

ZEROS

Distinct	7
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.055172414

Minimum	0
Maximum	8
Zeros	851
Zeros (%)	97.8%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	0.45176005
Coefficient of variation (CV)	8.1881508
Kurtosis	148.04872
Mean	0.055172414
Median Absolute Deviation (MAD)	0
Skewness	11.040038
Sum	48
Variance	0.20408714
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	851	97.8%
1	7	0.8%
2	4	0.5%
3	4	0.5%
4	2	0.2%
5	1	0.1%
8	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	851	97.8%
1	7	0.8%
2	4	0.5%
3	4	0.5%
4	2	0.2%
5	1	0.1%
8	1	0.1%

Value	Count	Frequency (%)
8	1	0.1%
5	1	0.1%
4	2	0.2%
3	4	0.5%
2	4	0.5%
1	7	0.8%
0	851	97.8%

이동상담
Real number (ℝ)

ZEROS

Distinct	17
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6436782

Minimum	0
Maximum	333
Zeros	848
Zeros (%)	97.5%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	18.490365
Coefficient of variation (CV)	11.249383
Kurtosis	208.69106
Mean	1.6436782
Median Absolute Deviation (MAD)	0
Skewness	13.755993
Sum	1430
Variance	341.8936
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	848	97.5%
1	5	0.6%
2	3	0.3%
292	1	0.1%
4	1	0.1%
333	1	0.1%
176	1	0.1%
147	1	0.1%
10	1	0.1%
3	1	0.1%
Other values (7)	7	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	848	97.5%
1	5	0.6%
2	3	0.3%
3	1	0.1%
4	1	0.1%
5	1	0.1%
7	1	0.1%
10	1	0.1%
16	1	0.1%
61	1	0.1%

Value	Count	Frequency (%)
333	1	0.1%
292	1	0.1%
176	1	0.1%
155	1	0.1%
147	1	0.1%
120	1	0.1%
90	1	0.1%
61	1	0.1%
16	1	0.1%
10	1	0.1%

문자
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	870
Missing (%)	100.0%
Memory size	7.8 KiB

합계
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	334
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	257.90115

Minimum	0
Maximum	4450
Zeros	158
Zeros (%)	18.2%
Negative	0
Negative (%)	0.0%
Memory size	7.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	7.25
median	30
Q3	265.75
95-th percentile	1633.85
Maximum	4450
Range	4450
Interquartile range (IQR)	258.5

Descriptive statistics

Standard deviation	579.12075
Coefficient of variation (CV)	2.2455144
Kurtosis	14.962402
Mean	257.90115
Median Absolute Deviation (MAD)	30
Skewness	3.7130708
Sum	224374
Variance	335380.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	158	18.2%
20	21	2.4%
9	16	1.8%
5	15	1.7%
12	14	1.6%
10	14	1.6%
24	14	1.6%
15	13	1.5%
7	13	1.5%
11	12	1.4%
Other values (324)	580	66.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	18.2%
1	7	0.8%
2	4	0.5%
3	5	0.6%
4	4	0.5%
5	15	1.7%
6	12	1.4%
7	13	1.5%
8	9	1.0%
9	16	1.8%

Value	Count	Frequency (%)
4450	1	0.1%
3988	1	0.1%
3630	1	0.1%
3420	1	0.1%
3393	1	0.1%
3232	1	0.1%
2916	1	0.1%
2915	1	0.1%
2913	1	0.1%
2847	1	0.1%

Phik (φk)
Auto

Heatmap
Table

	년월	기관/유형	전화	방문	이메일	게시판	SNS	이동상담	합계
년월	1.000	0.000	0.179	0.147	0.160	0.180	0.221	0.125	0.249
기관/유형	0.000	1.000	0.673	0.651	0.374	0.297	0.118	0.114	0.689
전화	0.179	0.673	1.000	0.753	0.717	0.817	0.000	0.269	0.934
방문	0.147	0.651	0.753	1.000	0.586	0.730	0.115	0.542	0.918
이메일	0.160	0.374	0.717	0.586	1.000	0.558	0.000	0.000	0.658
게시판	0.180	0.297	0.817	0.730	0.558	1.000	0.000	0.000	0.759
SNS	0.221	0.118	0.000	0.115	0.000	0.000	1.000	0.000	0.000
이동상담	0.125	0.114	0.269	0.542	0.000	0.000	0.000	1.000	0.404
합계	0.249	0.689	0.934	0.918	0.658	0.759	0.000	0.404	1.000

Heatmap
Table

	년월	전화	방문	이메일	게시판	SNS	이동상담	합계	기관/유형
년월	1.000	-0.244	-0.123	-0.267	-0.470	0.197	-0.246	-0.519	0.000
전화	-0.244	1.000	0.876	0.710	0.376	0.020	0.141	0.830	0.349
방문	-0.123	0.876	1.000	0.667	0.241	0.061	0.182	0.691	0.305
이메일	-0.267	0.710	0.667	1.000	0.311	-0.008	0.101	0.710	0.178
게시판	-0.470	0.376	0.241	0.311	1.000	-0.074	0.051	0.431	0.125
SNS	0.197	0.020	0.061	-0.008	-0.074	1.000	-0.024	-0.207	0.053
이동상담	-0.246	0.141	0.182	0.101	0.051	-0.024	1.000	0.166	0.048
합계	-0.519	0.830	0.691	0.710	0.431	-0.207	0.166	1.000	0.336
기관/유형	0.000	0.349	0.305	0.178	0.125	0.053	0.048	0.336	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

	년월	기관/유형	전화	방문	문자
0	202404	교육	23	11	<NA>
1	202404	교통	7	1	<NA>
2	202404	금융	4	4	<NA>
3	202404	기타	43	6	<NA>
4	202404	노무	116	28	<NA>
5	202404	문화/관광	1	1	<NA>
6	202404	보건/복지	42	16	<NA>
7	202404	비즈니스	30	10	<NA>
8	202404	안전	7	0	<NA>
9	202404	여성/가족	10	3	<NA>

	년월	기관/유형	전화	방문	이메일	게시판	문자	합계
860	201907	문화/관광	17	1	0	0	<NA>	18
861	201907	보건/복지	348	64	4	0	<NA>	416
862	201907	비즈니스	11	3	1	0	<NA>	15
863	201907	안전	49	22	1	0	<NA>	72
864	201907	여성/가족	22	4	0	0	<NA>	26
865	201907	전년도 총계	2221	504	91	2	<NA>	2818
866	201907	정보통신	7	4	0	0	<NA>	11
867	201907	주거	34	7	1	0	<NA>	42
868	201907	출입국	455	184	4	0	<NA>	643
869	201907	행정	370	52	22	1	<NA>	445

Overview

Variables

Common Values

Length

Interactions

Correlations

Missing values

Sample