gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	42
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 KiB
Average record size in memory	83.0 B

Variable types

Numeric	8
Categorical	1

Dataset

Description	대전지역 요일별 강력범, 절도범, 폭력범, 지능범, 풍속범, 기타형법범, 특별법범 범죄발생 현황으로 어느 요일에 범죄발생이 많고 적은지 파악할 수 있는 자료 활용
Author	경찰청 대전광역시경찰청
URL	https://www.data.go.kr/data/15094057/fileData.do

Alerts

`일` is highly overall correlated with `월` and 6 other fields	High correlation
`월` is highly overall correlated with `일` and 6 other fields	High correlation
`화` is highly overall correlated with `일` and 6 other fields	High correlation
`수` is highly overall correlated with `일` and 6 other fields	High correlation
`목` is highly overall correlated with `일` and 6 other fields	High correlation
`금` is highly overall correlated with `일` and 6 other fields	High correlation
`토` is highly overall correlated with `일` and 6 other fields	High correlation
`항목` is highly overall correlated with `일` and 6 other fields	High correlation
`일` has unique values	Unique
`월` has unique values	Unique
`화` has unique values	Unique
`목` has unique values	Unique

Reproduction

Analysis started	2024-03-14 12:00:39.401083
Analysis finished	2024-03-14 12:00:50.927551
Duration	11.53 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Real number (ℝ)

Distinct	6
Distinct (%)	14.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2019.5

Minimum	2017
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	2017
5-th percentile	2017
Q1	2018
median	2019.5
Q3	2021
95-th percentile	2022
Maximum	2022
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.7285268
Coefficient of variation (CV)	0.00085591819
Kurtosis	-1.275956
Mean	2019.5
Median Absolute Deviation (MAD)	1.5
Skewness	0
Sum	84819
Variance	2.9878049
Monotonicity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2017	7	16.7%
2018	7	16.7%
2019	7	16.7%
2020	7	16.7%
2021	7	16.7%
2022	7	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2017	7	16.7%
2018	7	16.7%
2019	7	16.7%
2020	7	16.7%
2021	7	16.7%
2022	7	16.7%

Value	Count	Frequency (%)
2022	7	16.7%
2021	7	16.7%
2020	7	16.7%
2019	7	16.7%
2018	7	16.7%
2017	7	16.7%

항목
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	16.7%
Missing	0
Missing (%)	0.0%
Memory size	464.0 B

강력범	6
절도범	6
폭력범	6
지능범	6
풍속범	6
Other values (2)	12

Length

Max length	5
Median length	3
Mean length	3.4285714
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	강력범
2nd row	절도범
3rd row	폭력범
4th row	지능범
5th row	풍속범

Common Values

Value	Count	Frequency (%)
강력범	6	14.3%
절도범	6	14.3%
폭력범	6	14.3%
지능범	6	14.3%
풍속범	6	14.3%
기타형법범	6	14.3%
특별법범	6	14.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
강력범	6	14.3%
절도범	6	14.3%
폭력범	6	14.3%
지능범	6	14.3%
풍속범	6	14.3%
기타형법범	6	14.3%
특별법범	6	14.3%

일
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	42
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	717.97619

Minimum	17
Maximum	2173
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	17
5-th percentile	25.2
Q1	127.5
median	748
Q3	1188.25
95-th percentile	1739.2
Maximum	2173
Range	2156
Interquartile range (IQR)	1060.75

Descriptive statistics

Standard deviation	592.10116
Coefficient of variation (CV)	0.82468077
Kurtosis	-0.63847675
Mean	717.97619
Median Absolute Deviation (MAD)	487
Skewness	0.53092067
Sum	30155
Variance	350583.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
103	1	2.4%
29	1	2.4%
905	1	2.4%
25	1	2.4%
295	1	2.4%
1667	1	2.4%
89	1	2.4%
654	1	2.4%
1036	1	2.4%
832	1	2.4%
Other values (32)	32	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17	1	2.4%
19	1	2.4%
25	1	2.4%
29	1	2.4%
31	1	2.4%
37	1	2.4%
89	1	2.4%
103	1	2.4%
110	1	2.4%
116	1	2.4%

Value	Count	Frequency (%)
2173	1	2.4%
1819	1	2.4%
1743	1	2.4%
1667	1	2.4%
1431	1	2.4%
1429	1	2.4%
1369	1	2.4%
1313	1	2.4%
1246	1	2.4%
1221	1	2.4%

월
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	42
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	961.42857

Minimum	25
Maximum	2963
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	25
5-th percentile	29.35
Q1	112.5
median	804.5
Q3	1572.25
95-th percentile	2520.5
Maximum	2963
Range	2938
Interquartile range (IQR)	1459.75

Descriptive statistics

Standard deviation	859.27576
Coefficient of variation (CV)	0.89374894
Kurtosis	-0.62118305
Mean	961.42857
Median Absolute Deviation (MAD)	695
Skewness	0.71026109
Sum	40380
Variance	738354.84
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
114	1	2.4%
28	1	2.4%
2172	1	2.4%
38	1	2.4%
449	1	2.4%
2266	1	2.4%
107	1	2.4%
748	1	2.4%
981	1	2.4%
1961	1	2.4%
Other values (32)	32	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	1	2.4%
28	1	2.4%
29	1	2.4%
36	1	2.4%
37	1	2.4%
38	1	2.4%
92	1	2.4%
94	1	2.4%
103	1	2.4%
107	1	2.4%

Value	Count	Frequency (%)
2963	1	2.4%
2529	1	2.4%
2522	1	2.4%
2492	1	2.4%
2266	1	2.4%
2172	1	2.4%
2037	1	2.4%
1961	1	2.4%
1832	1	2.4%
1797	1	2.4%

화
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	42
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	951.54762

Minimum	21
Maximum	3055
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	21
5-th percentile	25.15
Q1	119.75
median	741
Q3	1582.25
95-th percentile	2450.5
Maximum	3055
Range	3034
Interquartile range (IQR)	1462.5

Descriptive statistics

Standard deviation	861.25131
Coefficient of variation (CV)	0.90510584
Kurtosis	-0.48386273
Mean	951.54762
Median Absolute Deviation (MAD)	628.5
Skewness	0.75110678
Sum	39965
Variance	741753.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
119	1	2.4%
24	1	2.4%
2171	1	2.4%
25	1	2.4%
455	1	2.4%
2206	1	2.4%
106	1	2.4%
737	1	2.4%
980	1	2.4%
1799	1	2.4%
Other values (32)	32	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	1	2.4%
24	1	2.4%
25	1	2.4%
28	1	2.4%
38	1	2.4%
39	1	2.4%
93	1	2.4%
99	1	2.4%
103	1	2.4%
106	1	2.4%

Value	Count	Frequency (%)
3055	1	2.4%
2699	1	2.4%
2458	1	2.4%
2308	1	2.4%
2206	1	2.4%
2171	1	2.4%
2063	1	2.4%
1835	1	2.4%
1802	1	2.4%
1799	1	2.4%

수
Real number (ℝ)

HIGH CORRELATION

Distinct	39
Distinct (%)	92.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	943.85714

Minimum	20
Maximum	3005
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	20
5-th percentile	24
Q1	131
median	804
Q3	1597.5
95-th percentile	2397.65
Maximum	3005
Range	2985
Interquartile range (IQR)	1466.5

Descriptive statistics

Standard deviation	834.41583
Coefficient of variation (CV)	0.88404886
Kurtosis	-0.52700231
Mean	943.85714
Median Absolute Deviation (MAD)	687.5
Skewness	0.70423586
Sum	39642
Variance	696249.78
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
456	2	4.8%
804	2	4.8%
24	2	4.8%
105	1	2.4%
1960	1	2.4%
2134	1	2.4%
90	1	2.4%
711	1	2.4%
939	1	2.4%
1798	1	2.4%
Other values (29)	29	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20	1	2.4%
23	1	2.4%
24	2	4.8%
30	1	2.4%
43	1	2.4%
90	1	2.4%
91	1	2.4%
103	1	2.4%
105	1	2.4%
128	1	2.4%

Value	Count	Frequency (%)
3005	1	2.4%
2514	1	2.4%
2401	1	2.4%
2334	1	2.4%
2134	1	2.4%
2037	1	2.4%
1960	1	2.4%
1839	1	2.4%
1798	1	2.4%
1792	1	2.4%

목
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	42
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	954.40476

Minimum	25
Maximum	2966
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	25
5-th percentile	30.1
Q1	117.25
median	797.5
Q3	1548
95-th percentile	2419.95
Maximum	2966
Range	2941
Interquartile range (IQR)	1430.75

Descriptive statistics

Standard deviation	846.94591
Coefficient of variation (CV)	0.88740746
Kurtosis	-0.58519022
Mean	954.40476
Median Absolute Deviation (MAD)	684.5
Skewness	0.70531958
Sum	40085
Variance	717317.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=42)

Value	Count	Frequency (%)
124	1	2.4%
32	1	2.4%
1933	1	2.4%
30	1	2.4%
445	1	2.4%
2362	1	2.4%
100	1	2.4%
718	1	2.4%
966	1	2.4%
1834	1	2.4%
Other values (32)	32	76.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
25	1	2.4%
28	1	2.4%
30	1	2.4%
32	1	2.4%
38	1	2.4%
41	1	2.4%
98	1	2.4%
99	1	2.4%
100	1	2.4%
111	1	2.4%

Value	Count	Frequency (%)
2966	1	2.4%
2589	1	2.4%
2423	1	2.4%
2362	1	2.4%
2338	1	2.4%
2046	1	2.4%
1933	1	2.4%
1924	1	2.4%
1834	1	2.4%
1818	1	2.4%

금
Real number (ℝ)

HIGH CORRELATION

Distinct	41
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	993.40476

Minimum	17
Maximum	3165
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	17
5-th percentile	31
Q1	125.25
median	868
Q3	1580
95-th percentile	2618.8
Maximum	3165
Range	3148
Interquartile range (IQR)	1454.75

Descriptive statistics

Standard deviation	882.54734
Coefficient of variation (CV)	0.88840659
Kurtosis	-0.46140088
Mean	993.40476
Median Absolute Deviation (MAD)	745
Skewness	0.71829539
Sum	41723
Variance	778889.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
31	2	4.8%
121	1	2.4%
38	1	2.4%
2024	1	2.4%
412	1	2.4%
2406	1	2.4%
93	1	2.4%
745	1	2.4%
1024	1	2.4%
1684	1	2.4%
Other values (31)	31	73.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17	1	2.4%
24	1	2.4%
31	2	4.8%
36	1	2.4%
38	1	2.4%
93	1	2.4%
112	1	2.4%
119	1	2.4%
121	1	2.4%
125	1	2.4%

Value	Count	Frequency (%)
3165	1	2.4%
2710	1	2.4%
2630	1	2.4%
2406	1	2.4%
2284	1	2.4%
2225	1	2.4%
2024	1	2.4%
1979	1	2.4%
1815	1	2.4%
1684	1	2.4%

토
Real number (ℝ)

HIGH CORRELATION

Distinct	41
Distinct (%)	97.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	811.09524

Minimum	14
Maximum	2490
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	506.0 B

Quantile statistics

Minimum	14
5-th percentile	20.5
Q1	135.75
median	855.5
Q3	1236.5
95-th percentile	2137.55
Maximum	2490
Range	2476
Interquartile range (IQR)	1100.75

Descriptive statistics

Standard deviation	685.87252
Coefficient of variation (CV)	0.8456128
Kurtosis	-0.38685634
Mean	811.09524
Median Absolute Deviation (MAD)	568.5
Skewness	0.64243499
Sum	34066
Variance	470421.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
868	2	4.8%
115	1	2.4%
271	1	2.4%
14	1	2.4%
363	1	2.4%
1977	1	2.4%
131	1	2.4%
731	1	2.4%
1204	1	2.4%
986	1	2.4%
Other values (31)	31	73.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	1	2.4%
18	1	2.4%
20	1	2.4%
30	1	2.4%
34	1	2.4%
42	1	2.4%
114	1	2.4%
115	1	2.4%
125	1	2.4%
128	1	2.4%

Value	Count	Frequency (%)
2490	1	2.4%
2209	1	2.4%
2146	1	2.4%
1977	1	2.4%
1729	1	2.4%
1508	1	2.4%
1486	1	2.4%
1435	1	2.4%
1367	1	2.4%
1330	1	2.4%

Phik (φk)
Auto

Heatmap
Table

	연도	항목	일	월	화	수	목	금	토
연도	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
항목	0.000	1.000	0.861	0.911	0.925	0.914	0.917	0.926	0.899
일	0.000	0.861	1.000	0.966	0.969	0.963	0.978	0.975	0.995
월	0.000	0.911	0.966	1.000	0.996	0.994	0.996	0.989	0.973
화	0.000	0.925	0.969	0.996	1.000	0.995	0.994	0.995	0.981
수	0.000	0.914	0.963	0.994	0.995	1.000	0.993	0.989	0.964
목	0.000	0.917	0.978	0.996	0.994	0.993	1.000	0.997	0.978
금	0.000	0.926	0.975	0.989	0.995	0.989	0.997	1.000	0.978
토	0.000	0.899	0.995	0.973	0.981	0.964	0.978	0.978	1.000

Heatmap
Table

	연도	일	월	화	수	목	금	토	항목
연도	1.000	-0.047	-0.042	-0.045	-0.026	-0.020	-0.029	-0.020	0.000
일	-0.047	1.000	0.930	0.936	0.939	0.942	0.943	0.989	0.642
월	-0.042	0.930	1.000	0.994	0.989	0.990	0.989	0.931	0.739
화	-0.045	0.936	0.994	1.000	0.989	0.992	0.990	0.940	0.771
수	-0.026	0.939	0.989	0.989	1.000	0.994	0.995	0.935	0.746
목	-0.020	0.942	0.990	0.992	0.994	1.000	0.993	0.942	0.752
금	-0.029	0.943	0.989	0.990	0.995	0.993	1.000	0.940	0.774
토	-0.020	0.989	0.931	0.940	0.935	0.942	0.940	1.000	0.714
항목	0.000	0.642	0.739	0.771	0.746	0.752	0.774	0.714	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	2017	강력범	103	114	119	105	124	121	115
1	2017	절도범	909	900	835	824	864	954	928
2	2017	폭력범	1369	1107	1193	1207	1206	1283	1435
3	2017	지능범	726	1399	1319	1410	1374	1421	843
4	2017	풍속범	17	37	39	20	28	24	30
5	2017	기타형법범	285	396	364	456	436	429	299
6	2017	특별법범	2173	2963	3055	3005	2966	3165	2490
7	2018	강력범	153	112	103	128	111	112	128
8	2018	절도범	794	773	739	804	760	802	868
9	2018	폭력범	1431	1250	1264	1217	1247	1307	1486

	연도	항목	일	월	화	수	목	금	토
32	2021	풍속범	29	28	24	43	32	38	34
33	2021	기타형법범	272	387	388	400	392	371	271
34	2021	특별법범	1429	2037	2063	1960	2046	2225	1729
35	2022	강력범	119	92	99	140	115	126	125
36	2022	절도범	784	836	811	865	878	910	949
37	2022	폭력범	1215	1034	1074	1026	1061	1107	1241
38	2022	지능범	1108	2529	2308	2334	2338	2284	1223
39	2022	풍속범	37	36	38	30	41	36	18
40	2022	기타형법범	277	447	380	424	421	407	298
41	2022	특별법범	1313	1797	1802	1792	1924	1979	1508

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample