gimi9 Pandas Profiling

Dataset statistics

Number of variables	13
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	25
Duplicate rows (%)	0.2%
Total size in memory	1.2 MiB
Average record size in memory	124.0 B

Variable types

DateTime	1
Numeric	12

Dataset

Description	서대문구 전체 업종별 이용률 - 기상현황 - 유동인구 분석 기초자료 - 강수있음 자료 데이터로 날짜별 상권별, 업종별 기온, 습도, 강수량, 풍향, 풍속, 유동인구에 따른 데이터 항목을 제공합니다.
Author	서울특별시 서대문구
URL	https://www.data.go.kr/data/15097049/fileData.do

Alerts

Dataset has 25 (0.2%) duplicate rows	Duplicates
`우편번호` is highly overall correlated with `상권코드`	High correlation
`상권코드` is highly overall correlated with `우편번호` and 1 other fields	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 = 37.32003983)	Skewed

Reproduction

Analysis started	2023-12-12 17:54:45.449993
Analysis finished	2023-12-12 17:55:08.206831
Duration	22.76 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연월일
Date

Distinct	79
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	2020-01-06 00:00:00
Maximum	2020-08-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

시간
Real number (ℝ)

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

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.4198829
Coefficient of variation (CV)	0.35633371
Kurtosis	-0.79003264
Mean	3.9847
Median Absolute Deviation (MAD)	1
Skewness	-0.33929518
Sum	39847
Variance	2.0160675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	2756	27.6%
3	2130	21.3%
4	1974	19.7%
6	1511	15.1%
2	1086	10.9%
1	543	5.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	543	5.4%
2	1086	10.9%
3	2130	21.3%
4	1974	19.7%
5	2756	27.6%
6	1511	15.1%

Value	Count	Frequency (%)
6	1511	15.1%
5	2756	27.6%
4	1974	19.7%
3	2130	21.3%
2	1086	10.9%
1	543	5.4%

우편번호
Real number (ℝ)

HIGH CORRELATION

Distinct	82
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3702.6767

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	3664
median	3709
Q3	3742
95-th percentile	3787
Maximum	3789
Range	184
Interquartile range (IQR)	78

Descriptive statistics

Standard deviation	53.252322
Coefficient of variation (CV)	0.014382115
Kurtosis	-1.160695
Mean	3702.6767
Median Absolute Deviation (MAD)	43
Skewness	-0.049349181
Sum	37026767
Variance	2835.8098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3735	385	3.9%
3712	376	3.8%
3734	343	3.4%
3646	335	3.4%
3692	286	2.9%
3628	279	2.8%
3789	244	2.4%
3788	232	2.3%
3757	231	2.3%
3665	224	2.2%
Other values (72)	7065	70.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3605	166	1.7%
3606	9	0.1%
3607	9	0.1%
3611	54	0.5%
3612	27	0.3%
3615	103	1.0%
3616	91	0.9%
3624	155	1.6%
3625	69	0.7%
3628	279	2.8%

Value	Count	Frequency (%)
3789	244	2.4%
3788	232	2.3%
3787	127	1.3%
3780	129	1.3%
3779	167	1.7%
3778	60	0.6%
3777	208	2.1%
3776	173	1.7%
3767	110	1.1%
3766	180	1.8%

업종코드
Real number (ℝ)

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

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	11
Q3	17
95-th percentile	24
Maximum	25
Range	24
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.5813538
Coefficient of variation (CV)	0.57508203
Kurtosis	-1.2310468
Mean	11.4442
Median Absolute Deviation (MAD)	6
Skewness	0.22196031
Sum	114442
Variance	43.314218
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
17	1388	13.9%
5	1244	12.4%
3	1106	11.1%
13	911	9.1%
4	775	7.8%
9	654	6.5%
16	520	5.2%
24	520	5.2%
18	494	4.9%
19	455	4.5%
Other values (15)	1933	19.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	68	0.7%
2	15	0.1%
3	1106	11.1%
4	775	7.8%
5	1244	12.4%
6	215	2.1%
7	262	2.6%
8	315	3.1%
9	654	6.5%
10	319	3.2%

Value	Count	Frequency (%)
25	22	0.2%
24	520	5.2%
23	58	0.6%
22	108	1.1%
21	108	1.1%
20	158	1.6%
19	455	4.5%
18	494	4.9%
17	1388	13.9%
16	520	5.2%

상권코드
Real number (ℝ)

HIGH CORRELATION

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

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	5
median	11
Q3	20
95-th percentile	29
Maximum	32
Range	31
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.0444405
Coefficient of variation (CV)	0.71647077
Kurtosis	-1.019499
Mean	12.6236
Median Absolute Deviation (MAD)	7
Skewness	0.36155188
Sum	126236
Variance	81.801903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	1340	13.4%
7	627	6.3%
11	507	5.1%
16	507	5.1%
2	487	4.9%
23	474	4.7%
5	423	4.2%
18	407	4.1%
15	406	4.1%
6	379	3.8%
Other values (22)	4443	44.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1340	13.4%
2	487	4.9%
3	346	3.5%
4	257	2.6%
5	423	4.2%
6	379	3.8%
7	627	6.3%
8	198	2.0%
9	275	2.8%
10	312	3.1%

Value	Count	Frequency (%)
32	131	1.3%
31	201	2.0%
30	30	0.3%
29	160	1.6%
28	184	1.8%
27	156	1.6%
26	81	0.8%
25	185	1.8%
24	312	3.1%
23	474	4.7%

평균건수
Real number (ℝ)

HIGH CORRELATION

Distinct	287
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16.1664

Minimum	0.5
Maximum	1479
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
median	6
Q3	16
95-th percentile	67
Maximum	1479
Range	1478.5
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	34.242783
Coefficient of variation (CV)	2.1181453
Kurtosis	388.06733
Mean	16.1664
Median Absolute Deviation (MAD)	5
Skewness	12.733713
Sum	161664
Variance	1172.5682
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.0	1230	12.3%
2.0	742	7.4%
3.0	716	7.2%
4.0	519	5.2%
0.5	465	4.7%
5.0	451	4.5%
6.0	371	3.7%
7.0	359	3.6%
1.5	285	2.9%
8.0	255	2.5%
Other values (277)	4607	46.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.5	465	4.7%
1.0	1230	12.3%
1.5	285	2.9%
2.0	742	7.4%
2.5	166	1.7%
3.0	716	7.2%
3.5	110	1.1%
4.0	519	5.2%
4.5	80	0.8%
5.0	451	4.5%

Value	Count	Frequency (%)
1479.0	1	< 0.1%
746.0	1	< 0.1%
626.0	1	< 0.1%
500.0	1	< 0.1%
459.0	1	< 0.1%
446.0	1	< 0.1%
420.0	1	< 0.1%
378.0	1	< 0.1%
369.0	1	< 0.1%
361.0	1	< 0.1%

평균금액
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5549
Distinct (%)	55.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	243023.69

Minimum	300
Maximum	64928628
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	300
5-th percentile	7000
Q1	28287.5
median	76350
Q3	207250
95-th percentile	931457.5
Maximum	64928628
Range	64928328
Interquartile range (IQR)	178962.5

Descriptive statistics

Standard deviation	1066656.5
Coefficient of variation (CV)	4.3891051
Kurtosis	1875.267
Mean	243023.69
Median Absolute Deviation (MAD)	59350
Skewness	37.32004
Sum	2.4302369 × 10⁹
Variance	1.1377561 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15000.0	71	0.7%
10000.0	62	0.6%
20000.0	52	0.5%
7000.0	50	0.5%
8000.0	47	0.5%
12000.0	44	0.4%
6000.0	40	0.4%
24000.0	38	0.4%
18000.0	35	0.4%
35000.0	35	0.4%
Other values (5539)	9526	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
300.0	1	< 0.1%
500.0	4	< 0.1%
650.0	1	< 0.1%
750.0	1	< 0.1%
875.0	1	< 0.1%
900.0	1	< 0.1%
950.0	1	< 0.1%
1000.0	11	0.1%
1100.0	1	< 0.1%
1150.0	1	< 0.1%

Value	Count	Frequency (%)
64928628.0	1	< 0.1%
46150641.0	1	< 0.1%
34974811.0	1	< 0.1%
28401842.0	1	< 0.1%
17992791.0	1	< 0.1%
16451550.0	1	< 0.1%
14354250.0	1	< 0.1%
10365400.0	1	< 0.1%
9654540.0	1	< 0.1%
9527020.0	1	< 0.1%

기온
Real number (ℝ)

Distinct	434
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.95407

Minimum	-12.975
Maximum	29.725
Zeros	57
Zeros (%)	0.6%
Negative	185
Negative (%)	1.8%
Memory size	166.0 KiB

Quantile statistics

Minimum	-12.975
5-th percentile	3.9
Q1	13
median	20.325
Q3	24.35
95-th percentile	26.725
Maximum	29.725
Range	42.7
Interquartile range (IQR)	11.35

Descriptive statistics

Standard deviation	7.8920246
Coefficient of variation (CV)	0.43956744
Kurtosis	0.21706816
Mean	17.95407
Median Absolute Deviation (MAD)	4.875
Skewness	-0.9356142
Sum	179540.7
Variance	62.284053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5.575	119	1.2%
25.55	106	1.1%
12.825	104	1.0%
21.625	99	1.0%
23.1	96	1.0%
24.875	87	0.9%
24.6	85	0.9%
13.7	82	0.8%
16.85	81	0.8%
21.55	79	0.8%
Other values (424)	9062	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-12.975	27	0.3%
-9.275	32	0.3%
-5.55	1	< 0.1%
-4.125	6	0.1%
-3.825	8	0.1%
-3.4	4	< 0.1%
-3.075	31	0.3%
-2.15	40	0.4%
-1.05	1	< 0.1%
-1.025	15	0.1%

Value	Count	Frequency (%)
29.725	19	0.2%
29.3	3	< 0.1%
29.05	1	< 0.1%
28.975	5	0.1%
28.65	3	< 0.1%
28.625	4	< 0.1%
28.475	7	0.1%
28.375	7	0.1%
28.275	2	< 0.1%
28.1	37	0.4%

습도
Real number (ℝ)

Distinct	140
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.030625

Minimum	17.75
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	17.75
5-th percentile	64
Q1	88.25
median	94.25
Q3	96
95-th percentile	99
Maximum	100
Range	82.25
Interquartile range (IQR)	7.75

Descriptive statistics

Standard deviation	11.298411
Coefficient of variation (CV)	0.12549519
Kurtosis	7.5396922
Mean	90.030625
Median Absolute Deviation (MAD)	2.75
Skewness	-2.5573624
Sum	900306.25
Variance	127.65408
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
96.0	1890	18.9%
97.0	658	6.6%
94.0	437	4.4%
93.0	261	2.6%
100.0	252	2.5%
95.5	248	2.5%
96.75	226	2.3%
93.5	210	2.1%
91.5	187	1.9%
96.25	167	1.7%
Other values (130)	5464	54.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17.75	7	0.1%
21.75	4	< 0.1%
33.75	31	0.3%
35.0	32	0.3%
40.25	8	0.1%
41.0	4	< 0.1%
45.5	9	0.1%
46.0	27	0.3%
47.75	5	0.1%
48.5	6	0.1%

Value	Count	Frequency (%)
100.0	252	2.5%
99.75	40	0.4%
99.5	85	0.9%
99.25	108	1.1%
99.0	65	0.7%
98.75	74	0.7%
98.5	45	0.4%
98.25	99	1.0%
98.0	60	0.6%
97.75	33	0.3%

강수량
Real number (ℝ)

Distinct	129
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.55669

Minimum	-0.25
Maximum	18.125
Zeros	0
Zeros (%)	0.0%
Negative	135
Negative (%)	1.4%
Memory size	166.0 KiB

Quantile statistics

Minimum	-0.25
5-th percentile	0.125
Q1	0.25
median	0.5
Q3	1.625
95-th percentile	7.75
Maximum	18.125
Range	18.375
Interquartile range (IQR)	1.375

Descriptive statistics

Standard deviation	2.6444804
Coefficient of variation (CV)	1.6987842
Kurtosis	12.481176
Mean	1.55669
Median Absolute Deviation (MAD)	0.375
Skewness	3.2300029
Sum	15566.9
Variance	6.9932764
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.125	2043	20.4%
0.25	1178	11.8%
0.375	1091	10.9%
0.5	499	5.0%
0.75	430	4.3%
0.625	347	3.5%
1.0	338	3.4%
1.875	264	2.6%
0.875	257	2.6%
1.5	197	2.0%
Other values (119)	3356	33.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.25	124	1.2%
-0.125	11	0.1%
0.025	52	0.5%
0.05	24	0.2%
0.075	32	0.3%
0.1	34	0.3%
0.125	2043	20.4%
0.15	16	0.2%
0.175	14	0.1%
0.2	21	0.2%

Value	Count	Frequency (%)
18.125	20	0.2%
17.25	53	0.5%
16.975	6	0.1%
13.875	20	0.2%
13.225	2	< 0.1%
13.125	44	0.4%
10.5	8	0.1%
9.625	31	0.3%
9.5	20	0.2%
8.875	46	0.5%

풍향
Real number (ℝ)

Distinct	589
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	168.93944

Minimum	0
Maximum	357.833
Zeros	40
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	40.6016
Q1	91.836
median	166.2428
Q3	229.5765
95-th percentile	325.8897
Maximum	357.833
Range	357.833
Interquartile range (IQR)	137.7405

Descriptive statistics

Standard deviation	89.731249
Coefficient of variation (CV)	0.53114447
Kurtosis	-0.82697314
Mean	168.93944
Median Absolute Deviation (MAD)	70.8425
Skewness	0.20018941
Sum	1689394.4
Variance	8051.697
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
174.1248	66	0.7%
89.6131	64	0.6%
159.6931	62	0.6%
194.7114	61	0.6%
100.7341	60	0.6%
323.4571	59	0.6%
285.4114	59	0.6%
102.1996	58	0.6%
172.7431	58	0.6%
281.8179	57	0.6%
Other values (579)	9396	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	40	0.4%
3.0577	46	0.5%
3.121	13	0.1%
6.1221	37	0.4%
7.3247	11	0.1%
8.1593	21	0.2%
9.821	56	0.6%
10.8497	32	0.3%
12.742	6	0.1%
13.4494	5	0.1%

Value	Count	Frequency (%)
357.833	52	0.5%
357.7509	3	< 0.1%
356.5859	5	0.1%
354.7356	39	0.4%
353.4841	45	0.4%
351.7413	55	0.5%
351.4076	39	0.4%
350.1614	27	0.3%
348.6819	40	0.4%
344.6707	4	< 0.1%

풍속
Real number (ℝ)

Distinct	588
Distinct (%)	5.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6106834

Minimum	0
Maximum	7.8494
Zeros	40
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.2542
Q1	0.8009
median	1.319
Q3	2.1963
95-th percentile	3.847
Maximum	7.8494
Range	7.8494
Interquartile range (IQR)	1.3954

Descriptive statistics

Standard deviation	1.1524731
Coefficient of variation (CV)	0.71551808
Kurtosis	2.209312
Mean	1.6106834
Median Absolute Deviation (MAD)	0.6724
Skewness	1.3091234
Sum	16106.834
Variance	1.3281943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.0078	67	0.7%
4.7198	66	0.7%
0.2542	64	0.6%
0.8009	62	0.6%
4.1678	61	0.6%
0.1363	60	0.6%
2.7514	59	0.6%
0.841	59	0.6%
1.7749	58	0.6%
2.7185	58	0.6%
Other values (578)	9386	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	40	0.4%
0.0259	1	< 0.1%
0.0871	47	0.5%
0.0976	5	0.1%
0.103	14	0.1%
0.1254	36	0.4%
0.1363	60	0.6%
0.1488	33	0.3%
0.1746	3	< 0.1%
0.1869	39	0.4%

Value	Count	Frequency (%)
7.8494	5	0.1%
6.9171	17	0.2%
6.7699	3	< 0.1%
6.4989	19	0.2%
6.0891	4	< 0.1%
5.9878	14	0.1%
5.8119	8	0.1%
5.5354	5	0.1%
5.5221	2	< 0.1%
5.4247	13	0.1%

유동인구
Real number (ℝ)

HIGH CORRELATION

Distinct	4283
Distinct (%)	42.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17929.14

Minimum	541.12
Maximum	117806.23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	541.12
5-th percentile	1840.943
Q1	5818.3025
median	12642.7
Q3	19073.69
95-th percentile	65520.36
Maximum	117806.23
Range	117265.11
Interquartile range (IQR)	13255.387

Descriptive statistics

Standard deviation	19598.537
Coefficient of variation (CV)	1.0931108
Kurtosis	4.5559613
Mean	17929.14
Median Absolute Deviation (MAD)	6755.65
Skewness	2.1647713
Sum	1.792914 × 10⁸
Variance	3.8410263 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63953.7	21	0.2%
63252.39	18	0.2%
64261.76	16	0.2%
77350.76	16	0.2%
64715.06	15	0.1%
59345.1	15	0.1%
59624.25	15	0.1%
80968.66	14	0.1%
74440.41	14	0.1%
76839.85	14	0.1%
Other values (4273)	9842	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
541.12	1	< 0.1%
604.51	2	< 0.1%
620.15	1	< 0.1%
653.8	1	< 0.1%
655.45	2	< 0.1%
687.89	2	< 0.1%
713.7	3	< 0.1%
718.29	2	< 0.1%
728.63	1	< 0.1%
734.17	1	< 0.1%

Value	Count	Frequency (%)
117806.23	10	0.1%
115588.49	13	0.1%
109816.38	10	0.1%
101616.79	8	0.1%
94630.98	13	0.1%
93400.91	9	0.1%
92396.13	9	0.1%
89624.74	10	0.1%
85147.18	4	< 0.1%
84961.71	6	0.1%

Phik (φk)
Auto

Heatmap
Table

	연월일	시간	우편번호	업종코드	상권코드	평균건수	평균금액	기온	습도	강수량	풍향	풍속	유동인구
연월일	1.000	0.769	0.139	0.188	0.119	0.000	0.000	0.968	0.962	0.823	0.893	0.819	0.523
시간	0.769	1.000	0.083	0.263	0.078	0.059	0.014	0.300	0.307	0.266	0.274	0.212	0.351
우편번호	0.139	0.083	1.000	0.275	0.932	0.109	0.048	0.124	0.099	0.095	0.375	0.348	0.816
업종코드	0.188	0.263	0.275	1.000	0.259	0.054	0.016	0.064	0.051	0.020	0.073	0.080	0.215
상권코드	0.119	0.078	0.932	0.259	1.000	0.073	0.000	0.062	0.049	0.072	0.288	0.239	0.707
평균건수	0.000	0.059	0.109	0.054	0.073	1.000	0.984	0.000	0.000	0.031	0.023	0.000	0.194
평균금액	0.000	0.014	0.048	0.016	0.000	0.984	1.000	0.000	0.000	0.000	0.023	0.000	0.137
기온	0.968	0.300	0.124	0.064	0.062	0.000	0.000	1.000	0.768	0.307	0.590	0.412	0.308
습도	0.962	0.307	0.099	0.051	0.049	0.000	0.000	0.768	1.000	0.264	0.489	0.418	0.163
강수량	0.823	0.266	0.095	0.020	0.072	0.031	0.000	0.307	0.264	1.000	0.392	0.341	0.162
풍향	0.893	0.274	0.375	0.073	0.288	0.023	0.023	0.590	0.489	0.392	1.000	0.475	0.357
풍속	0.819	0.212	0.348	0.080	0.239	0.000	0.000	0.412	0.418	0.341	0.475	1.000	0.373
유동인구	0.523	0.351	0.816	0.215	0.707	0.194	0.137	0.308	0.163	0.162	0.357	0.373	1.000

Heatmap
Table

	시간	우편번호	업종코드	상권코드	평균건수	평균금액	기온	습도	강수량	풍향	풍속	유동인구
시간	1.000	-0.016	-0.049	0.018	0.030	0.163	0.029	0.105	0.071	-0.036	0.099	-0.022
우편번호	-0.016	1.000	-0.053	-0.564	0.121	0.115	0.043	0.084	0.002	-0.008	0.239	0.342
업종코드	-0.049	-0.053	1.000	0.047	-0.034	-0.127	-0.015	-0.010	-0.013	-0.002	-0.018	-0.034
상권코드	0.018	-0.564	0.047	1.000	-0.201	-0.170	-0.044	-0.078	-0.001	0.009	-0.157	-0.562
평균건수	0.030	0.121	-0.034	-0.201	1.000	0.813	-0.016	0.045	-0.011	0.044	0.017	0.187
평균금액	0.163	0.115	-0.127	-0.170	0.813	1.000	0.001	0.068	-0.004	0.048	0.029	0.190
기온	0.029	0.043	-0.015	-0.044	-0.016	0.001	1.000	0.041	0.095	-0.014	-0.044	0.023
습도	0.105	0.084	-0.010	-0.078	0.045	0.068	0.041	1.000	0.336	-0.037	0.011	0.067
강수량	0.071	0.002	-0.013	-0.001	-0.011	-0.004	0.095	0.336	1.000	-0.097	0.177	0.020
풍향	-0.036	-0.008	-0.002	0.009	0.044	0.048	-0.014	-0.037	-0.097	1.000	-0.045	-0.018
풍속	0.099	0.239	-0.018	-0.157	0.017	0.029	-0.044	0.011	0.177	-0.045	1.000	0.026
유동인구	-0.022	0.342	-0.034	-0.562	0.187	0.190	0.023	0.067	0.020	-0.018	0.026	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

	연월일	시간	우편번호	업종코드	상권코드	평균건수	평균금액	기온	습도	강수량	풍향	풍속	유동인구
13035	2020-02-28	2	3696	16	25	9.0	75950.0	4.1	92.0	0.125	74.2455	0.4924	4453.22
83959	2020-08-10	4	3789	4	1	54.0	442700.0	24.375	100.0	5.625	206.7406	0.9749	80455.54
43008	2020-06-25	4	3628	5	11	9.5	206250.0	19.275	94.0	0.375	216.4706	1.2647	10086.31
46193	2020-06-29	6	3788	11	1	7.0	180899.0	20.3	93.5	0.5	310.5967	3.031	43394.31
3000	2020-01-07	3	3616	9	9	6.0	56850.0	7.7	97.0	2.625	58.8841	3.5718	12680.73
83790	2020-08-10	3	3734	18	29	19.0	386900.0	25.925	95.5	2.1	212.8965	1.1938	5720.04
71032	2020-08-02	6	3744	3	5	4.0	82500.0	24.925	98.0	8.525	222.4332	3.0231	2884.18
62347	2020-07-28	4	3736	9	3	10.0	39010.0	23.1	95.5	0.875	40.6016	1.6102	33565.0
67410	2020-08-01	3	3776	19	1	17.0	380950.0	25.75	89.75	0.125	233.8328	1.5043	56225.68
44453	2020-06-29	3	3726	16	14	3.0	21800.0	21.625	85.25	1.875	190.0964	1.369	5530.07

	연월일	시간	우편번호	업종코드	상권코드	평균건수	평균금액	기온	습도	강수량	풍향	풍속	유동인구
5852	2020-02-11	6	3779	24	1	28.0	185400.0	7.075	64.0	0.25	108.3692	2.4446	56636.96
11487	2020-02-24	5	3767	4	2	8.0	112860.0	6.75	79.75	0.5	92.1427	3.5171	14568.68
94760	2020-08-29	2	3735	18	3	0.5	4500.0	26.95	87.25	0.5	153.2454	0.5699	19201.87
54831	2020-07-19	4	3628	20	27	1.0	7000.0	25.55	84.0	0.375	164.3415	2.5662	7309.84
62621	2020-07-28	4	3646	19	23	3.0	93450.0	23.1	95.5	0.875	40.6016	1.6102	13318.73
65949	2020-07-31	5	3646	7	23	2.5	27700.0	23.925	96.0	0.5	94.5691	0.5684	14965.97
26312	2020-05-14	5	3665	12	16	5.0	149500.0	17.275	51.75	0.25	89.5722	0.8919	7742.1
25684	2020-05-11	4	3628	13	27	11.0	78800.0	9.75	87.5	0.75	180.3531	0.2374	6332.34
86573	2020-08-14	5	3665	9	16	24.0	152100.0	25.075	96.0	6.5	229.5765	0.8149	7353.71
56735	2020-07-22	2	3740	13	21	4.0	19300.0	22.875	97.0	0.375	166.2428	0.5388	7889.83

Most frequently occurring

	연월일	시간	우편번호	업종코드	상권코드	평균건수	평균금액	기온	습도	강수량	풍향	풍속	유동인구	# duplicates
0	2020-01-06	3	3646	8	23	1.5	39900.0	3.85	95.25	0.125	75.8704	2.7375	17194.82	2
1	2020-01-07	5	3646	16	23	93.5	828220.0	1.8	97.0	0.75	285.4114	2.7514	19561.77	2
2	2020-02-15	5	3646	4	23	12.5	214700.0	0.0	96.0	0.875	281.8179	2.0123	21196.89	2
3	2020-02-15	5	3646	8	23	1.5	17000.0	0.0	96.0	0.875	281.8179	2.0123	21196.89	2
4	2020-04-11	6	3646	5	23	2.5	83350.0	-3.075	33.75	-0.25	180.9998	1.0078	18977.86	2
5	2020-05-09	4	3646	4	23	1.0	24000.0	12.525	97.0	0.125	188.1183	1.0393	16954.81	2
6	2020-05-11	4	3646	18	23	7.5	209600.0	9.75	87.5	0.75	180.3531	0.2374	15514.33	2
7	2020-05-15	4	3646	16	23	18.0	236365.0	14.925	96.0	0.125	71.8918	1.1453	15577.75	2
8	2020-05-18	5	3646	3	23	3.0	100800.0	11.4	86.25	0.375	163.3108	1.1202	16689.81	2
9	2020-06-24	5	3646	7	23	2.0	47350.0	20.8	94.0	1.0	159.6931	0.8009	14738.04	2

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring