gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	19
Duplicate rows (%)	0.2%
Total size in memory	859.4 KiB
Average record size in memory	88.0 B

Variable types

DateTime	1
Numeric	8

Dataset

Description	서대문구 전체 상권별 업종별 이용률-미세먼지 분석 기초자료 데이터로 날짜별 상권별, 업종별 날짜별, 시간별, 매출건수와 매출금액, 미세먼지, 초미세먼지 데이터 항목을 제공합니다
Author	서울특별시 서대문구
URL	https://www.data.go.kr/data/15097165/fileData.do

Alerts

Dataset has 19 (0.2%) duplicate rows	Duplicates
`우편번호` is highly overall correlated with `상권코드`	High correlation
`상권코드` is highly overall correlated with `우편번호`	High correlation
`매출건수` is highly overall correlated with `매출금액`	High correlation
`매출금액` is highly overall correlated with `매출건수`	High correlation
`미세먼지` is highly overall correlated with `초미세먼지`	High correlation
`초미세먼지` is highly overall correlated with `미세먼지`	High correlation
`매출금액` is highly skewed (γ1 = 31.88829233)	Skewed

Reproduction

Analysis started	2023-12-12 03:15:15.684431
Analysis finished	2023-12-12 03:15:27.390282
Duration	11.71 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연월일
Date

Distinct	34
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	2020-01-01 00:00:00
Maximum	2020-02-03 00:00:00

Histogram

Histogram with fixed size bins (bins=34)

시간
Real number (ℝ)

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9117

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

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.4302824
Coefficient of variation (CV)	0.36564214
Kurtosis	-0.82967299
Mean	3.9117
Median Absolute Deviation (MAD)	1
Skewness	-0.28408211
Sum	39117
Variance	2.0457077
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	2542	25.4%
4	2137	21.4%
3	2076	20.8%
6	1432	14.3%
2	1226	12.3%
1	587	5.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	587	5.9%
2	1226	12.3%
3	2076	20.8%
4	2137	21.4%
5	2542	25.4%
6	1432	14.3%

Value	Count	Frequency (%)
6	1432	14.3%
5	2542	25.4%
4	2137	21.4%
3	2076	20.8%
2	1226	12.3%
1	587	5.9%

우편번호
Real number (ℝ)

HIGH CORRELATION

Distinct	81
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3706.9431

Minimum	3605
Maximum	3789
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	3605
5-th percentile	3624
Q1	3665
median	3711
Q3	3757
95-th percentile	3788
Maximum	3789
Range	184
Interquartile range (IQR)	92

Descriptive statistics

Standard deviation	53.687951
Coefficient of variation (CV)	0.014483079
Kurtosis	-1.1779145
Mean	3706.9431
Median Absolute Deviation (MAD)	46
Skewness	-0.12362624
Sum	37069431
Variance	2882.3961
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3712	406	4.1%
3646	322	3.2%
3735	322	3.2%
3734	321	3.2%
3789	297	3.0%
3692	285	2.9%
3777	260	2.6%
3766	257	2.6%
3628	255	2.5%
3741	240	2.4%
Other values (71)	7035	70.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3605	136	1.4%
3606	6	0.1%
3607	17	0.2%
3611	39	0.4%
3612	27	0.3%
3615	75	0.8%
3616	103	1.0%
3624	131	1.3%
3625	57	0.6%
3628	255	2.5%

Value	Count	Frequency (%)
3789	297	3.0%
3788	218	2.2%
3787	152	1.5%
3780	182	1.8%
3779	188	1.9%
3778	67	0.7%
3777	260	2.6%
3776	216	2.2%
3767	145	1.5%
3766	257	2.6%

업종코드
Real number (ℝ)

Distinct	25
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.7897

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

Quantile statistics

Minimum	1
5-th percentile	3
Q1	5
median	12
Q3	17
95-th percentile	24
Maximum	25
Range	24
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.7156819
Coefficient of variation (CV)	0.5696228
Kurtosis	-1.2575136
Mean	11.7897
Median Absolute Deviation (MAD)	6
Skewness	0.17117726
Sum	117897
Variance	45.100384
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
17	1432	14.3%
5	1140	11.4%
3	1088	10.9%
13	862	8.6%
4	750	7.5%
9	643	6.4%
24	614	6.1%
16	541	5.4%
18	487	4.9%
19	444	4.4%
Other values (15)	1999	20.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	72	0.7%
2	17	0.2%
3	1088	10.9%
4	750	7.5%
5	1140	11.4%
6	169	1.7%
7	269	2.7%
8	348	3.5%
9	643	6.4%
10	282	2.8%

Value	Count	Frequency (%)
25	30	0.3%
24	614	6.1%
23	81	0.8%
22	140	1.4%
21	101	1.0%
20	206	2.1%
19	444	4.4%
18	487	4.9%
17	1432	14.3%
16	541	5.4%

상권코드
Real number (ℝ)

HIGH CORRELATION

Distinct	32
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.1579

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

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	11
Q3	20
95-th percentile	29
Maximum	32
Range	31
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	9.1364608
Coefficient of variation (CV)	0.75148346
Kurtosis	-0.9665326
Mean	12.1579
Median Absolute Deviation (MAD)	8
Skewness	0.42254201
Sum	121579
Variance	83.474915
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	1580	15.8%
2	649	6.5%
7	645	6.5%
11	489	4.9%
16	485	4.9%
18	457	4.6%
23	432	4.3%
6	403	4.0%
15	363	3.6%
20	346	3.5%
Other values (22)	4151	41.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1580	15.8%
2	649	6.5%
3	275	2.8%
4	207	2.1%
5	341	3.4%
6	403	4.0%
7	645	6.5%
8	212	2.1%
9	244	2.4%
10	303	3.0%

Value	Count	Frequency (%)
32	148	1.5%
31	206	2.1%
30	30	0.3%
29	171	1.7%
28	159	1.6%
27	128	1.3%
26	79	0.8%
25	167	1.7%
24	248	2.5%
23	432	4.3%

매출건수
Real number (ℝ)

HIGH CORRELATION

Distinct	311
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.96005

Minimum	0.5
Maximum	1425
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.5
5-th percentile	1
Q1	2.5
median	6.5
Q3	18
95-th percentile	70.05
Maximum	1425
Range	1424.5
Interquartile range (IQR)	15.5

Descriptive statistics

Standard deviation	43.902018
Coefficient of variation (CV)	2.4444263
Kurtosis	343.94448
Mean	17.96005
Median Absolute Deviation (MAD)	5.5
Skewness	14.138817
Sum	179600.5
Variance	1927.3872
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.0	1146	11.5%
3.0	690	6.9%
2.0	673	6.7%
4.0	514	5.1%
0.5	446	4.5%
5.0	441	4.4%
6.0	398	4.0%
7.0	333	3.3%
8.0	287	2.9%
9.0	243	2.4%
Other values (301)	4829	48.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	446	4.5%
1.0	1146	11.5%
1.5	233	2.3%
2.0	673	6.7%
2.5	159	1.6%
3.0	690	6.9%
3.5	111	1.1%
4.0	514	5.1%
4.5	111	1.1%
5.0	441	4.4%

Value	Count	Frequency (%)
1425.0	1	< 0.1%
1375.0	1	< 0.1%
1302.0	1	< 0.1%
1012.0	1	< 0.1%
880.0	1	< 0.1%
804.0	1	< 0.1%
669.0	1	< 0.1%
666.0	1	< 0.1%
513.0	1	< 0.1%
503.0	1	< 0.1%

매출금액
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5677
Distinct (%)	56.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	290087.12

Minimum	500
Maximum	74311243
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	500
5-th percentile	7450
Q1	30000
median	82500
Q3	220500
95-th percentile	1000000
Maximum	74311243
Range	74310743
Interquartile range (IQR)	190500

Descriptive statistics

Standard deviation	1671529
Coefficient of variation (CV)	5.7621619
Kurtosis	1197.4774
Mean	290087.12
Median Absolute Deviation (MAD)	64565
Skewness	31.888292
Sum	2.9008712 × 10⁹
Variance	2.7940091 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15000.0	65	0.7%
10000.0	60	0.6%
6000.0	44	0.4%
20000.0	44	0.4%
18000.0	40	0.4%
12000.0	38	0.4%
5000.0	37	0.4%
25000.0	33	0.3%
17000.0	32	0.3%
40000.0	32	0.3%
Other values (5667)	9575	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500.0	1	< 0.1%
625.0	1	< 0.1%
700.0	1	< 0.1%
750.0	2	< 0.1%
825.0	1	< 0.1%
900.0	2	< 0.1%
950.0	1	< 0.1%
1000.0	9	0.1%
1150.0	1	< 0.1%
1200.0	3	< 0.1%

Value	Count	Frequency (%)
74311243.0	1	< 0.1%
70466805.0	1	< 0.1%
65646380.0	1	< 0.1%
58516614.0	1	< 0.1%
44352677.0	1	< 0.1%
39286942.0	1	< 0.1%
37907238.0	1	< 0.1%
33388383.0	1	< 0.1%
20930948.0	1	< 0.1%
15992664.0	1	< 0.1%

미세먼지
Real number (ℝ)

HIGH CORRELATION

Distinct	144
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.9843

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

Quantile statistics

Minimum	3
5-th percentile	6.75
Q1	26
median	43.25
Q3	58.25
95-th percentile	78.25
Maximum	94.75
Range	91.75
Interquartile range (IQR)	32.25

Descriptive statistics

Standard deviation	22.678912
Coefficient of variation (CV)	0.52760919
Kurtosis	-0.7062694
Mean	42.9843
Median Absolute Deviation (MAD)	15.75
Skewness	0.071155654
Sum	429843
Variance	514.33304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64.5	287	2.9%
40.25	249	2.5%
3.0	221	2.2%
13.75	198	2.0%
34.5	163	1.6%
39.0	162	1.6%
26.0	160	1.6%
57.25	152	1.5%
47.5	143	1.4%
71.5	137	1.4%
Other values (134)	8128	81.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.0	221	2.2%
3.25	71	0.7%
3.5	15	0.1%
4.25	79	0.8%
5.25	57	0.6%
5.5	14	0.1%
6.75	82	0.8%
7.0	92	0.9%
7.25	76	0.8%
7.5	96	1.0%

Value	Count	Frequency (%)
94.75	35	0.4%
92.75	88	0.9%
92.25	49	0.5%
91.0	72	0.7%
87.25	67	0.7%
84.5	75	0.8%
83.75	50	0.5%
80.5	62	0.6%
78.25	62	0.6%
77.5	46	0.5%

초미세먼지
Real number (ℝ)

HIGH CORRELATION

Distinct	135
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	27.021725

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

Quantile statistics

Minimum	1
5-th percentile	3
Q1	15
median	26.5
Q3	34.25
95-th percentile	60.25
Maximum	76.75
Range	75.75
Interquartile range (IQR)	19.25

Descriptive statistics

Standard deviation	16.503637
Coefficient of variation (CV)	0.6107544
Kurtosis	0.29568202
Mean	27.021725
Median Absolute Deviation (MAD)	9
Skewness	0.65311317
Sum	270217.25
Variance	272.37005
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.0	228	2.3%
3.0	223	2.2%
31.0	196	2.0%
34.25	184	1.8%
31.5	184	1.8%
34.0	168	1.7%
29.5	161	1.6%
18.75	161	1.6%
22.5	161	1.6%
1.0	158	1.6%
Other values (125)	8176	81.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.0	158	1.6%
1.25	43	0.4%
1.5	114	1.1%
1.75	71	0.7%
2.25	57	0.6%
2.5	17	0.2%
3.0	223	2.2%
3.75	77	0.8%
4.0	60	0.6%
4.25	57	0.6%

Value	Count	Frequency (%)
76.75	49	0.5%
74.5	35	0.4%
72.25	88	0.9%
67.0	50	0.5%
66.5	32	0.3%
65.75	75	0.8%
63.0	14	0.1%
62.0	77	0.8%
61.25	59	0.6%
60.25	65	0.7%

Phik (φk)
Auto

Heatmap
Table

	연월일	시간	우편번호	업종코드	상권코드	매출건수	매출금액	미세먼지	초미세먼지
연월일	1.000	0.081	0.042	0.037	0.049	0.000	0.049	0.919	0.907
시간	0.081	1.000	0.099	0.254	0.075	0.080	0.000	0.333	0.318
우편번호	0.042	0.099	1.000	0.264	0.937	0.125	0.032	0.029	0.000
업종코드	0.037	0.254	0.264	1.000	0.245	0.083	0.049	0.066	0.064
상권코드	0.049	0.075	0.937	0.245	1.000	0.082	0.000	0.000	0.000
매출건수	0.000	0.080	0.125	0.083	0.082	1.000	0.902	0.024	0.010
매출금액	0.049	0.000	0.032	0.049	0.000	0.902	1.000	0.000	0.000
미세먼지	0.919	0.333	0.029	0.066	0.000	0.024	0.000	1.000	0.942
초미세먼지	0.907	0.318	0.000	0.064	0.000	0.010	0.000	0.942	1.000

Heatmap
Table

	시간	우편번호	업종코드	상권코드	매출건수	매출금액	미세먼지	초미세먼지
시간	1.000	-0.016	-0.060	0.012	0.051	0.165	-0.035	-0.044
우편번호	-0.016	1.000	-0.058	-0.599	0.152	0.150	-0.010	-0.007
업종코드	-0.060	-0.058	1.000	0.040	-0.028	-0.124	0.016	0.018
상권코드	0.012	-0.599	0.040	1.000	-0.221	-0.198	-0.007	-0.009
매출건수	0.051	0.152	-0.028	-0.221	1.000	0.802	-0.006	-0.020
매출금액	0.165	0.150	-0.124	-0.198	0.802	1.000	0.008	-0.006
미세먼지	-0.035	-0.010	0.016	-0.007	-0.006	0.008	1.000	0.946
초미세먼지	-0.044	-0.007	0.018	-0.009	-0.020	-0.006	0.946	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

	연월일	시간	우편번호	업종코드	상권코드	매출건수	매출금액	미세먼지	초미세먼지
38913	2020-01-14	5	3764	3	2	21.0	175100.0	22.0	12.25
4738	2020-01-02	5	3757	16	8	11.5	75845.0	73.5	39.5
64869	2020-01-23	4	3682	5	18	4.0	196000.0	70.75	48.0
294	2020-01-01	2	3611	5	9	4.0	36100.0	22.0	9.75
58966	2020-01-21	4	3628	7	27	2.0	28250.0	44.75	26.75
43042	2020-01-16	1	3713	17	12	13.0	74200.0	27.5	24.0
78508	2020-01-28	6	3735	17	3	4.0	13020.0	8.25	4.25
89517	2020-02-01	5	3780	13	1	46.0	404800.0	92.75	72.25
52469	2020-01-19	2	3711	18	7	2.0	25700.0	40.25	31.75
31196	2020-01-11	6	3734	3	22	4.0	105100.0	58.0	32.5

	연월일	시간	우편번호	업종코드	상권코드	매출건수	매출금액	미세먼지	초미세먼지
47474	2020-01-17	4	3692	16	4	61.5	1315265.0	68.25	40.0
37697	2020-01-14	2	3789	24	1	1.0	17000.0	29.0	21.75
57969	2020-01-21	2	3665	13	16	23.0	194300.0	36.0	23.0
23000	2020-01-09	2	3691	13	18	1.0	6500.0	50.75	30.75
13460	2020-01-05	5	3710	16	7	22.0	296360.0	57.25	31.0
41405	2020-01-15	4	3672	8	6	5.0	21300.0	27.75	17.5
91268	2020-02-02	3	3692	18	4	2.0	49000.0	83.75	67.0
85308	2020-01-31	3	3628	16	11	38.0	955900.0	26.0	18.75
8119	2020-01-03	6	3605	9	28	8.0	58100.0	56.25	31.5
21263	2020-01-08	4	3757	17	8	6.5	35635.0	37.75	22.5

Most frequently occurring

	연월일	시간	우편번호	업종코드	상권코드	매출건수	매출금액	미세먼지	초미세먼지	# duplicates
0	2020-01-03	2	3646	5	23	4.0	28500.0	77.0	43.75	2
1	2020-01-04	4	3646	13	23	20.0	147845.0	41.75	20.25	2
2	2020-01-05	4	3646	3	23	15.5	181700.0	56.0	30.0	2
3	2020-01-08	2	3646	4	23	4.0	32500.0	4.25	1.5	2
4	2020-01-08	5	3646	16	23	105.5	1112885.0	54.75	32.5	2
5	2020-01-10	5	3646	18	23	10.0	179145.0	52.5	26.25	2
6	2020-01-10	6	3646	3	23	6.0	92800.0	50.0	30.0	2
7	2020-01-11	4	3646	8	23	1.5	24650.0	53.25	27.75	2
8	2020-01-13	2	3646	3	23	7.5	71950.0	34.25	16.25	2
9	2020-01-17	6	3646	10	23	2.0	44000.0	59.25	40.25	2

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring