gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	927.7 KiB
Average record size in memory	95.0 B

Variable types

Categorical	2
Numeric	7
DateTime	1

Dataset

Description	파일 다운로드
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-20464/S/1/datasetView.do

Alerts

`기관 명` has constant value ""	Constant
`모델명` has constant value ""	Constant
`초미세먼지(㎍/㎥)` 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
`초미세먼지(㎍/㎥)` has 2022 (20.2%) zeros	Zeros
`미세먼지(㎍/㎥)` has 1886 (18.9%) zeros	Zeros

Reproduction

Analysis started	2024-05-18 01:56:14.093659
Analysis finished	2024-05-18 01:56:29.707580
Duration	15.61 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기관 명
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

중랑구	10000

Length

Max length	3
Median length	3
Mean length	3
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 (%)
중랑구	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
중랑구	10000	100.0%

모델명
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

AN-EMD-TA100L	10000

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AN-EMD-TA100L
2nd row	AN-EMD-TA100L
3rd row	AN-EMD-TA100L
4th row	AN-EMD-TA100L
5th row	AN-EMD-TA100L

Common Values

Value	Count	Frequency (%)
AN-EMD-TA100L	10000	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
an-emd-ta100l	10000	100.0%

시리얼
Real number (ℝ)

Distinct	291
Distinct (%)	2.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	310.7316

Minimum	76
Maximum	607
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	76
5-th percentile	91
Q1	181
median	312
Q3	428
95-th percentile	524
Maximum	607
Range	531
Interquartile range (IQR)	247

Descriptive statistics

Standard deviation	142.21373
Coefficient of variation (CV)	0.45767385
Kurtosis	-1.0182399
Mean	310.7316
Median Absolute Deviation (MAD)	125
Skewness	0.085856439
Sum	3107316
Variance	20224.745
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
512	55	0.5%
335	51	0.5%
107	51	0.5%
348	51	0.5%
385	50	0.5%
307	50	0.5%
178	48	0.5%
181	48	0.5%
442	47	0.5%
603	47	0.5%
Other values (281)	9502	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
76	36	0.4%
77	34	0.3%
78	37	0.4%
79	39	0.4%
80	35	0.4%
82	38	0.4%
83	41	0.4%
84	34	0.3%
85	41	0.4%
86	45	0.4%

Value	Count	Frequency (%)
607	28	0.3%
606	36	0.4%
605	39	0.4%
604	40	0.4%
603	47	0.5%
602	33	0.3%
601	40	0.4%
600	42	0.4%
599	40	0.4%
532	8	0.1%

초미세먼지(㎍/㎥)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	120
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.7959

Minimum	0
Maximum	386
Zeros	2022
Zeros (%)	20.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	9
Q3	22
95-th percentile	47
Maximum	386
Range	386
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	17.602955
Coefficient of variation (CV)	1.1897184
Kurtosis	42.179826
Mean	14.7959
Median Absolute Deviation (MAD)	9
Skewness	3.5587651
Sum	147959
Variance	309.86403
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2022	20.2%
1	434	4.3%
2	427	4.3%
3	341	3.4%
5	334	3.3%
4	329	3.3%
6	315	3.1%
7	300	3.0%
8	279	2.8%
9	265	2.6%
Other values (110)	4954	49.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2022	20.2%
1	434	4.3%
2	427	4.3%
3	341	3.4%
4	329	3.3%
5	334	3.3%
6	315	3.1%
7	300	3.0%
8	279	2.8%
9	265	2.6%

Value	Count	Frequency (%)
386	1	< 0.1%
346	1	< 0.1%
278	1	< 0.1%
204	1	< 0.1%
193	1	< 0.1%
136	1	< 0.1%
135	1	< 0.1%
124	1	< 0.1%
123	1	< 0.1%
118	1	< 0.1%

미세먼지(㎍/㎥)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	128
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.1806

Minimum	0
Maximum	426
Zeros	1886
Zeros (%)	18.9%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	11
Q3	25
95-th percentile	56
Maximum	426
Range	426
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	20.327088
Coefficient of variation (CV)	1.1831419
Kurtosis	32.613941
Mean	17.1806
Median Absolute Deviation (MAD)	10
Skewness	3.1578076
Sum	171806
Variance	413.1905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1886	18.9%
1	420	4.2%
2	391	3.9%
3	335	3.4%
6	307	3.1%
7	298	3.0%
4	285	2.9%
5	285	2.9%
8	246	2.5%
9	242	2.4%
Other values (118)	5305	53.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1886	18.9%
1	420	4.2%
2	391	3.9%
3	335	3.4%
4	285	2.9%
5	285	2.9%
6	307	3.1%
7	298	3.0%
8	246	2.5%
9	242	2.4%

Value	Count	Frequency (%)
426	1	< 0.1%
375	1	< 0.1%
283	1	< 0.1%
207	1	< 0.1%
202	1	< 0.1%
145	1	< 0.1%
141	1	< 0.1%
136	1	< 0.1%
135	1	< 0.1%
132	1	< 0.1%

온도(℃)
Real number (ℝ)

Distinct	37
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.3517

Minimum	0
Maximum	36
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	20
median	23
Q3	26
95-th percentile	29
Maximum	36
Range	36
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.9044482
Coefficient of variation (CV)	0.21942171
Kurtosis	1.4008443
Mean	22.3517
Median Absolute Deviation (MAD)	3
Skewness	-0.87285229
Sum	223517
Variance	24.053612
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
24	962	9.6%
25	929	9.3%
23	923	9.2%
26	852	8.5%
22	788	7.9%
21	682	6.8%
20	651	6.5%
27	649	6.5%
19	506	5.1%
28	503	5.0%
Other values (27)	2555	25.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	8	0.1%
2	3	< 0.1%
3	11	0.1%
4	16	0.2%
5	20	0.2%
6	23	0.2%
7	35	0.4%
8	50	0.5%
9	43	0.4%

Value	Count	Frequency (%)
36	1	< 0.1%
35	1	< 0.1%
34	27	0.3%
33	31	0.3%
32	40	0.4%
31	94	0.9%
30	196	2.0%
29	287	2.9%
28	503	5.0%
27	649	6.5%

습도(%)
Real number (ℝ)

Distinct	72
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.9043

Minimum	8
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	8
5-th percentile	18
Q1	25
median	31
Q3	38
95-th percentile	49
Maximum	81
Range	73
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.6898158
Coefficient of variation (CV)	0.30371504
Kurtosis	1.2338983
Mean	31.9043
Median Absolute Deviation (MAD)	6
Skewness	0.74636286
Sum	319043
Variance	93.892531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	456	4.6%
27	444	4.4%
31	443	4.4%
26	439	4.4%
25	428	4.3%
24	422	4.2%
28	417	4.2%
29	414	4.1%
32	398	4.0%
34	369	3.7%
Other values (62)	5770	57.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	2	< 0.1%
9	3	< 0.1%
10	11	0.1%
11	25	0.2%
12	43	0.4%
13	44	0.4%
14	45	0.4%
15	59	0.6%
16	62	0.6%
17	80	0.8%

Value	Count	Frequency (%)
81	3	< 0.1%
80	4	< 0.1%
78	1	< 0.1%
77	1	< 0.1%
76	6	0.1%
75	2	< 0.1%
74	2	< 0.1%
73	1	< 0.1%
72	4	< 0.1%
71	5	0.1%

총 유기 휘발성 화합물
Real number (ℝ)

HIGH CORRELATION

Distinct	425
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	73.9843

Minimum	0
Maximum	499
Zeros	96
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	13
Q1	41
median	54
Q3	69
95-th percentile	238.05
Maximum	499
Range	499
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	84.007765
Coefficient of variation (CV)	1.135481
Kurtosis	13.584893
Mean	73.9843
Median Absolute Deviation (MAD)	14
Skewness	3.5884218
Sum	739843
Variance	7057.3046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
51	507	5.1%
50	462	4.6%
52	322	3.2%
53	295	2.9%
57	271	2.7%
55	265	2.6%
56	258	2.6%
54	241	2.4%
58	239	2.4%
59	210	2.1%
Other values (415)	6930	69.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	96	1.0%
1	30	0.3%
2	27	0.3%
3	22	0.2%
4	16	0.2%
5	26	0.3%
6	26	0.3%
7	32	0.3%
8	34	0.3%
9	38	0.4%

Value	Count	Frequency (%)
499	145	1.5%
498	1	< 0.1%
497	2	< 0.1%
496	3	< 0.1%
495	2	< 0.1%
493	1	< 0.1%
492	4	< 0.1%
491	1	< 0.1%
490	1	< 0.1%
489	2	< 0.1%

이산화탄소
Real number (ℝ)

HIGH CORRELATION

Distinct	1859
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	848.8131

Minimum	0
Maximum	9700
Zeros	37
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	401
Q1	484
median	639
Q3	906
95-th percentile	2150.1
Maximum	9700
Range	9700
Interquartile range (IQR)	422

Descriptive statistics

Standard deviation	654.81358
Coefficient of variation (CV)	0.77144613
Kurtosis	22.00986
Mean	848.8131
Median Absolute Deviation (MAD)	182
Skewness	3.6302119
Sum	8488131
Variance	428780.83
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	427	4.3%
401	155	1.6%
402	114	1.1%
403	74	0.7%
405	66	0.7%
404	63	0.6%
408	42	0.4%
406	42	0.4%
407	41	0.4%
410	40	0.4%
Other values (1849)	8936	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	0.4%
267	1	< 0.1%
320	1	< 0.1%
362	1	< 0.1%
371	1	< 0.1%
380	1	< 0.1%
397	1	< 0.1%
400	427	4.3%
401	155	1.6%
402	114	1.1%

Value	Count	Frequency (%)
9700	2	< 0.1%
8536	1	< 0.1%
8073	1	< 0.1%
6685	1	< 0.1%
6530	1	< 0.1%
6349	1	< 0.1%
6340	1	< 0.1%
6271	1	< 0.1%
5990	1	< 0.1%
5968	1	< 0.1%

등록일시
Date

Distinct	4767
Distinct (%)	47.7%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	2023-01-09 00:22:28
Maximum	2023-01-15 23:23:06

Histogram

Histogram with fixed size bins (bins=50)

Phik (φk)
Auto

Heatmap
Table

	시리얼	초미세먼지(㎍/㎥)	미세먼지(㎍/㎥)	온도(℃)	습도(%)	총 유기 휘발성 화합물	이산화탄소
시리얼	1.000	0.149	0.148	0.454	0.302	0.210	0.128
초미세먼지(㎍/㎥)	0.149	1.000	0.972	0.269	0.063	0.105	0.115
미세먼지(㎍/㎥)	0.148	0.972	1.000	0.261	0.085	0.116	0.106
온도(℃)	0.454	0.269	0.261	1.000	0.588	0.215	0.174
습도(%)	0.302	0.063	0.085	0.588	1.000	0.175	0.143
총 유기 휘발성 화합물	0.210	0.105	0.116	0.215	0.175	1.000	0.549
이산화탄소	0.128	0.115	0.106	0.174	0.143	0.549	1.000

Heatmap
Table

	시리얼	초미세먼지(㎍/㎥)	미세먼지(㎍/㎥)	온도(℃)	습도(%)	총 유기 휘발성 화합물	이산화탄소
시리얼	1.000	0.051	0.045	-0.158	0.013	-0.148	-0.048
초미세먼지(㎍/㎥)	0.051	1.000	0.998	-0.149	-0.276	-0.072	0.069
미세먼지(㎍/㎥)	0.045	0.998	1.000	-0.155	-0.274	-0.069	0.072
온도(℃)	-0.158	-0.149	-0.155	1.000	-0.393	0.214	0.253
습도(%)	0.013	-0.276	-0.274	-0.393	1.000	0.163	0.159
총 유기 휘발성 화합물	-0.148	-0.072	-0.069	0.214	0.163	1.000	0.686
이산화탄소	-0.048	0.069	0.072	0.253	0.159	0.686	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

	기관 명	모델명	시리얼	초미세먼지(㎍/㎥)	미세먼지(㎍/㎥)	온도(℃)	습도(%)	총 유기 휘발성 화합물	이산화탄소	등록일시
35122	중랑구	AN-EMD-TA100L	284	0	0	23	30	76	1001	2023-01-14 11:22:49
28612	중랑구	AN-EMD-TA100L	515	4	5	25	35	66	1190	2023-01-13 10:23:04
32665	중랑구	AN-EMD-TA100L	524	9	10	24	39	99	1615	2023-01-14 01:59:35
38881	중랑구	AN-EMD-TA100L	603	0	0	18	39	24	407	2023-01-15 01:59:27
7462	중랑구	AN-EMD-TA100L	242	6	7	19	37	44	400	2023-01-10 04:23:41
13372	중랑구	AN-EMD-TA100L	254	21	25	25	30	29	614	2023-01-11 04:22:42
2215	중랑구	AN-EMD-TA100L	378	10	12	17	41	42	448	2023-01-09 08:22:48
15912	중랑구	AN-EMD-TA100L	463	0	0	20	33	32	719	2023-01-11 11:22:59
26414	중랑구	AN-EMD-TA100L	414	37	41	14	38	33	428	2023-01-13 04:22:56
4423	중랑구	AN-EMD-TA100L	429	34	40	32	14	24	488	2023-01-09 16:22:52

	기관 명	모델명	시리얼	초미세먼지(㎍/㎥)	미세먼지(㎍/㎥)	온도(℃)	습도(%)	총 유기 휘발성 화합물	이산화탄소	등록일시
35678	중랑구	AN-EMD-TA100L	344	0	0	15	32	62	787	2023-01-14 13:22:53
3761	중랑구	AN-EMD-TA100L	217	14	16	25	49	155	2426	2023-01-09 14:22:39
34821	중랑구	AN-EMD-TA100L	200	3	4	29	29	58	747	2023-01-14 10:22:43
20263	중랑구	AN-EMD-TA100L	527	52	58	24	21	50	628	2023-01-12 04:23:33
37560	중랑구	AN-EMD-TA100L	473	2	4	14	41	29	415	2023-01-14 20:23:02
43532	중랑구	AN-EMD-TA100L	86	13	15	21	32	52	428	2023-01-15 20:22:38
424	중랑구	AN-EMD-TA100L	392	39	44	23	18	46	476	2023-01-09 01:59:09
37531	중랑구	AN-EMD-TA100L	429	1	1	34	21	59	797	2023-01-14 20:22:58
30848	중랑구	AN-EMD-TA100L	605	1	1	24	45	55	1118	2023-01-13 18:23:07
4824	중랑구	AN-EMD-TA100L	171	13	15	25	26	94	1118	2023-01-09 18:22:36

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample