gimi9 Pandas Profiling

Dataset statistics

Number of variables	4
Number of observations	30
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.2 KiB
Average record size in memory	39.4 B

Variable types

Numeric	3
DateTime	1

Dataset

Description	샘플 데이터
Author	식품안전나라
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=65

Alerts

`년월(occrrnc_ym)` has unique values	Unique
`발생건수(occrrnc_cnt)` has 2 (6.7%) zeros	Zeros
`환자수(patnt_co)` has 1 (3.3%) zeros	Zeros

Reproduction

Analysis started	2024-01-14 06:50:57.985728
Analysis finished	2024-01-14 06:50:59.285982
Duration	1.3 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년월(occrrnc_ym)
Real number (ℝ)

UNIQUE

Distinct	30
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201643.57

Minimum	201202
Maximum	202105
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	402.0 B

Quantile statistics

Minimum	201202
5-th percentile	201207.9
Q1	201334.25
median	201659
Q3	201904
95-th percentile	202102.1
Maximum	202105
Range	903
Interquartile range (IQR)	569.75

Descriptive statistics

Standard deviation	307.02552
Coefficient of variation (CV)	0.001522615
Kurtosis	-1.397795
Mean	201643.57
Median Absolute Deviation (MAD)	254
Skewness	-0.018856752
Sum	6049307
Variance	94264.668
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
201805	1	3.3%
201404	1	3.3%
202103	1	3.3%
201912	1	3.3%
201512	1	3.3%
202004	1	3.3%
201211	1	3.3%
201804	1	3.3%
201209	1	3.3%
201510	1	3.3%
Other values (20)	20	66.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201202	1	3.3%
201207	1	3.3%
201209	1	3.3%
201211	1	3.3%
201301	1	3.3%
201306	1	3.3%
201307	1	3.3%
201311	1	3.3%
201404	1	3.3%
201408	1	3.3%

Value	Count	Frequency (%)
202105	1	3.3%
202103	1	3.3%
202101	1	3.3%
202008	1	3.3%
202004	1	3.3%
202003	1	3.3%
201912	1	3.3%
201905	1	3.3%
201901	1	3.3%
201812	1	3.3%

발생건수(occrrnc_cnt)
Real number (ℝ)

ZEROS

Distinct	9
Distinct (%)	30.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1333333

Minimum	0
Maximum	9
Zeros	2
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	402.0 B

Quantile statistics

Minimum	0
5-th percentile	0.45
Q1	2
median	3
Q3	4
95-th percentile	6.55
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.0296651
Coefficient of variation (CV)	0.64776544
Kurtosis	1.1905187
Mean	3.1333333
Median Absolute Deviation (MAD)	1
Skewness	0.89320087
Sum	94
Variance	4.1195402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
3	8	26.7%
2	6	20.0%
5	4	13.3%
1	4	13.3%
4	3	10.0%
0	2	6.7%
6	1	3.3%
7	1	3.3%
9	1	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2	6.7%
1	4	13.3%
2	6	20.0%
3	8	26.7%
4	3	10.0%
5	4	13.3%
6	1	3.3%
7	1	3.3%
9	1	3.3%

Value	Count	Frequency (%)
9	1	3.3%
7	1	3.3%
6	1	3.3%
5	4	13.3%
4	3	10.0%
3	8	26.7%
2	6	20.0%
1	4	13.3%
0	2	6.7%

환자수(patnt_co)
Real number (ℝ)

ZEROS

Distinct	27
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	70.833333

Minimum	0
Maximum	466
Zeros	1
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	402.0 B

Quantile statistics

Minimum	0
5-th percentile	3.35
Q1	11
median	51.5
Q3	106
95-th percentile	170.4
Maximum	466
Range	466
Interquartile range (IQR)	95

Descriptive statistics

Standard deviation	90.52189
Coefficient of variation (CV)	1.2779561
Kurtosis	12.437227
Mean	70.833333
Median Absolute Deviation (MAD)	43
Skewness	3.0885395
Sum	2125
Variance	8194.2126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
11	2	6.7%
16	2	6.7%
5	2	6.7%
8	1	3.3%
58	1	3.3%
83	1	3.3%
68	1	3.3%
95	1	3.3%
466	1	3.3%
60	1	3.3%
Other values (17)	17	56.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	3.3%
2	1	3.3%
5	2	6.7%
8	1	3.3%
9	1	3.3%
10	1	3.3%
11	2	6.7%
15	1	3.3%
16	2	6.7%
37	1	3.3%

Value	Count	Frequency (%)
466	1	3.3%
210	1	3.3%
122	1	3.3%
119	1	3.3%
116	1	3.3%
114	1	3.3%
109	1	3.3%
108	1	3.3%
100	1	3.3%
95	1	3.3%

적재일시(ldadng_dt)
Date

Distinct	6
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Memory size	372.0 B

Minimum	2017-11-21 17:09:11
Maximum	2021-07-19 13:33:06

Histogram

Histogram with fixed size bins (bins=6)

Phik (φk)
Auto

Heatmap
Table

	년월(occrrnc_ym)	발생건수(occrrnc_cnt)	환자수(patnt_co)	적재일시(ldadng_dt)
년월(occrrnc_ym)	1.000	0.000	0.127	0.181
발생건수(occrrnc_cnt)	0.000	1.000	0.621	0.000
환자수(patnt_co)	0.127	0.621	1.000	0.396
적재일시(ldadng_dt)	0.181	0.000	0.396	1.000

Heatmap
Table

	년월(occrrnc_ym)	발생건수(occrrnc_cnt)	환자수(patnt_co)
년월(occrrnc_ym)	1.000	-0.007	-0.145
발생건수(occrrnc_cnt)	-0.007	1.000	0.337
환자수(patnt_co)	-0.145	0.337	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

	년월(occrrnc_ym)	발생건수(occrrnc_cnt)	환자수(patnt_co)	적재일시(ldadng_dt)
0	201805	2	8	2018-08-21 16:56:45
1	202003	5	37	2017-11-21 17:09:11
2	202105	3	116	2017-11-21 17:09:11
3	201301	5	52	2019-04-22 14:35:29
4	201812	6	109	2017-11-21 17:09:11
5	201706	1	9	2017-11-21 17:09:11
6	201611	2	108	2021-01-22 09:59:48
7	201901	2	0	2017-11-21 17:09:11
8	201408	3	11	2018-08-21 16:56:45
9	201709	0	15	2017-11-21 17:09:11

	년월(occrrnc_ym)	발생건수(occrrnc_cnt)	환자수(patnt_co)	적재일시(ldadng_dt)
20	201207	5	16	2017-11-21 17:09:11
21	201612	1	2	2018-08-21 16:56:45
22	201510	3	210	2021-01-22 09:59:48
23	201209	3	60	2017-11-21 17:09:11
24	201804	1	11	2017-11-21 17:09:11
25	201211	9	466	2017-11-21 17:09:11
26	202004	4	5	2017-11-21 17:09:11
27	201512	0	95	2017-11-21 17:09:11
28	201912	3	68	2018-08-21 16:56:45
29	202103	2	83	2017-11-21 17:09:11

Overview

Variables

Interactions

Correlations

Missing values

Sample