gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	9125
Missing cells	724
Missing cells (%)	0.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	704.1 KiB
Average record size in memory	79.0 B

Variable types

Numeric	7
Categorical	2

Dataset

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

Alerts

`측정소명` is highly overall correlated with `권역명`	High correlation
`권역명` is highly overall correlated with `측정소명`	High correlation
`이산화질소농도(ppm)` is highly overall correlated with `일산화탄소농도(ppm)` and 2 other fields	High correlation
`일산화탄소농도(ppm)` is highly overall correlated with `이산화질소농도(ppm)` and 2 other fields	High correlation
`미세먼지(㎍/㎥)` is highly overall correlated with `이산화질소농도(ppm)` and 2 other fields	High correlation
`초미세먼지(㎍/㎥)` is highly overall correlated with `이산화질소농도(ppm)` and 2 other fields	High correlation
`일산화탄소농도(ppm)` has 260 (2.8%) missing values	Missing
`아황산가스농도(ppm)` has 153 (1.7%) missing values	Missing

Reproduction

Analysis started	2024-05-03 21:52:13.681980
Analysis finished	2024-05-03 21:52:33.923630
Duration	20.24 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

측정일시
Real number (ℝ)

Distinct	365
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20230668

Minimum	20230101
Maximum	20231231
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	20230101
5-th percentile	20230119
Q1	20230402
median	20230702
Q3	20231001
95-th percentile	20231213
Maximum	20231231
Range	1130
Interquartile range (IQR)	599

Descriptive statistics

Standard deviation	345.02079
Coefficient of variation (CV)	1.7054345 × 10^-5
Kurtosis	-1.2057171
Mean	20230668
Median Absolute Deviation (MAD)	300
Skewness	-0.010696166
Sum	1.8460485 × 10¹¹
Variance	119039.35
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20230101	25	0.3%
20230909	25	0.3%
20230907	25	0.3%
20230906	25	0.3%
20230905	25	0.3%
20230904	25	0.3%
20230903	25	0.3%
20230902	25	0.3%
20230901	25	0.3%
20230831	25	0.3%
Other values (355)	8875	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20230101	25	0.3%
20230102	25	0.3%
20230103	25	0.3%
20230104	25	0.3%
20230105	25	0.3%
20230106	25	0.3%
20230107	25	0.3%
20230108	25	0.3%
20230109	25	0.3%
20230110	25	0.3%

Value	Count	Frequency (%)
20231231	25	0.3%
20231230	25	0.3%
20231229	25	0.3%
20231228	25	0.3%
20231227	25	0.3%
20231226	25	0.3%
20231225	25	0.3%
20231224	25	0.3%
20231223	25	0.3%
20231222	25	0.3%

권역명
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.4 KiB

동북권	2920
서남권	2555
동남권	1460
서북권	1095
도심권	1095

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 (%)
동북권	2920	32.0%
서남권	2555	28.0%
동남권	1460	16.0%
서북권	1095	12.0%
도심권	1095	12.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
동북권	2920	32.0%
서남권	2555	28.0%
동남권	1460	16.0%
서북권	1095	12.0%
도심권	1095	12.0%

측정소명
Categorical

HIGH CORRELATION

Distinct	25
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	71.4 KiB

강남구	365
강동구	365
강북구	365
강서구	365
관악구	365
Other values (20)	7300

Length

Max length	4
Median length	3
Mean length	3.08
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	강남구
2nd row	강동구
3rd row	강북구
4th row	강서구
5th row	관악구

Common Values

Value	Count	Frequency (%)
강남구	365	4.0%
강동구	365	4.0%
강북구	365	4.0%
강서구	365	4.0%
관악구	365	4.0%
광진구	365	4.0%
구로구	365	4.0%
금천구	365	4.0%
노원구	365	4.0%
도봉구	365	4.0%
Other values (15)	5475	60.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
강남구	365	4.0%
서대문구	365	4.0%
중구	365	4.0%
종로구	365	4.0%
은평구	365	4.0%
용산구	365	4.0%
영등포구	365	4.0%
양천구	365	4.0%
송파구	365	4.0%
성북구	365	4.0%
Other values (15)	5475	60.0%

이산화질소농도(ppm)
Real number (ℝ)

HIGH CORRELATION

Distinct	562
Distinct (%)	6.2%
Missing	77
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.020383963

Minimum	0.0019
Maximum	0.0696
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.0019
5-th percentile	0.0077
Q1	0.0123
median	0.0174
Q3	0.0259
95-th percentile	0.0434
Maximum	0.0696
Range	0.0677
Interquartile range (IQR)	0.0136

Descriptive statistics

Standard deviation	0.011042318
Coefficient of variation (CV)	0.54171594
Kurtosis	1.1358772
Mean	0.020383963
Median Absolute Deviation (MAD)	0.0062
Skewness	1.1694211
Sum	184.4341
Variance	0.00012193278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.015	61	0.7%
0.0108	59	0.6%
0.0121	58	0.6%
0.016	58	0.6%
0.0118	55	0.6%
0.01	55	0.6%
0.0152	55	0.6%
0.0125	54	0.6%
0.0128	54	0.6%
0.011	54	0.6%
Other values (552)	8485	93.0%
(Missing)	77	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0019	1	< 0.1%
0.0028	1	< 0.1%
0.0033	2	< 0.1%
0.0035	2	< 0.1%
0.0036	1	< 0.1%
0.0037	1	< 0.1%
0.0038	2	< 0.1%
0.0039	4	< 0.1%
0.004	2	< 0.1%
0.0042	4	< 0.1%

Value	Count	Frequency (%)
0.0696	1	< 0.1%
0.0684	1	< 0.1%
0.068	2	< 0.1%
0.0673	1	< 0.1%
0.0672	1	< 0.1%
0.0668	1	< 0.1%
0.0664	2	< 0.1%
0.0658	1	< 0.1%
0.0652	1	< 0.1%
0.0651	1	< 0.1%

오존농도(ppm)
Real number (ℝ)

Distinct	705
Distinct (%)	7.8%
Missing	71
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.030583422

Minimum	0.002
Maximum	0.0951
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.002
5-th percentile	0.0092
Q1	0.0207
median	0.0293
Q3	0.0395
95-th percentile	0.0548
Maximum	0.0951
Range	0.0931
Interquartile range (IQR)	0.0188

Descriptive statistics

Standard deviation	0.013846683
Coefficient of variation (CV)	0.45275127
Kurtosis	0.16537272
Mean	0.030583422
Median Absolute Deviation (MAD)	0.0093
Skewness	0.4792767
Sum	276.9023
Variance	0.00019173063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0243	45	0.5%
0.0318	36	0.4%
0.027	35	0.4%
0.0266	35	0.4%
0.0204	34	0.4%
0.024	34	0.4%
0.021	34	0.4%
0.0215	33	0.4%
0.0274	33	0.4%
0.0283	33	0.4%
Other values (695)	8702	95.4%
(Missing)	71	0.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.002	2	< 0.1%
0.0022	1	< 0.1%
0.0023	1	< 0.1%
0.0024	1	< 0.1%
0.0025	3	< 0.1%
0.0028	1	< 0.1%
0.0029	2	< 0.1%
0.003	3	< 0.1%
0.0032	2	< 0.1%
0.0033	2	< 0.1%

Value	Count	Frequency (%)
0.0951	1	< 0.1%
0.0876	1	< 0.1%
0.087	1	< 0.1%
0.086	1	< 0.1%
0.0838	1	< 0.1%
0.0834	1	< 0.1%
0.0827	1	< 0.1%
0.0817	2	< 0.1%
0.0815	1	< 0.1%
0.0812	1	< 0.1%

일산화탄소농도(ppm)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	115
Distinct (%)	1.3%
Missing	260
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	0.45122279

Minimum	0.09
Maximum	1.41
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.09
5-th percentile	0.26
Q1	0.35
median	0.41
Q3	0.52
95-th percentile	0.77
Maximum	1.41
Range	1.32
Interquartile range (IQR)	0.17

Descriptive statistics

Standard deviation	0.15829955
Coefficient of variation (CV)	0.35082349
Kurtosis	2.5882251
Mean	0.45122279
Median Absolute Deviation (MAD)	0.08
Skewness	1.3494107
Sum	4000.09
Variance	0.025058748
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.35	398	4.4%
0.36	344	3.8%
0.4	339	3.7%
0.37	333	3.6%
0.39	326	3.6%
0.38	320	3.5%
0.41	286	3.1%
0.42	275	3.0%
0.33	265	2.9%
0.34	264	2.9%
Other values (105)	5715	62.6%
(Missing)	260	2.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.09	1	< 0.1%
0.1	3	< 0.1%
0.11	1	< 0.1%
0.13	2	< 0.1%
0.14	4	< 0.1%
0.15	1	< 0.1%
0.16	1	< 0.1%
0.17	10	0.1%
0.18	15	0.2%
0.19	26	0.3%

Value	Count	Frequency (%)
1.41	1	< 0.1%
1.38	1	< 0.1%
1.34	3	< 0.1%
1.25	1	< 0.1%
1.22	2	< 0.1%
1.2	1	< 0.1%
1.19	2	< 0.1%
1.18	1	< 0.1%
1.17	2	< 0.1%
1.16	2	< 0.1%

아황산가스농도(ppm)
Real number (ℝ)

MISSING

Distinct	55
Distinct (%)	0.6%
Missing	153
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.0028125279

Minimum	0.0012
Maximum	0.0079
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.0012
5-th percentile	0.002
Q1	0.0024
median	0.0028
Q3	0.0031
95-th percentile	0.0038
Maximum	0.0079
Range	0.0067
Interquartile range (IQR)	0.0007

Descriptive statistics

Standard deviation	0.00056714684
Coefficient of variation (CV)	0.20165021
Kurtosis	3.9557954
Mean	0.0028125279
Median Absolute Deviation (MAD)	0.0004
Skewness	1.0773645
Sum	25.234
Variance	3.2165554 × 10^-7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.003	754	8.3%
0.0026	663	7.3%
0.0027	650	7.1%
0.0029	624	6.8%
0.0024	618	6.8%
0.0028	616	6.8%
0.0025	590	6.5%
0.0023	545	6.0%
0.0031	459	5.0%
0.0022	450	4.9%
Other values (45)	3003	32.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0012	1	< 0.1%
0.0013	3	< 0.1%
0.0014	3	< 0.1%
0.0015	5	0.1%
0.0016	19	0.2%
0.0017	32	0.4%
0.0018	60	0.7%
0.0019	136	1.5%
0.002	309	3.4%
0.0021	314	3.4%

Value	Count	Frequency (%)
0.0079	1	< 0.1%
0.0074	1	< 0.1%
0.0072	1	< 0.1%
0.0068	1	< 0.1%
0.0067	1	< 0.1%
0.0065	3	< 0.1%
0.0063	1	< 0.1%
0.0061	2	< 0.1%
0.006	3	< 0.1%
0.0057	1	< 0.1%

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

HIGH CORRELATION

Distinct	190
Distinct (%)	2.1%
Missing	89
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.734949

Minimum	3
Maximum	319
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	3
5-th percentile	10
Q1	21
median	32
Q3	45
95-th percentile	87
Maximum	319
Range	316
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	26.9441
Coefficient of variation (CV)	0.71403568
Kurtosis	17.22586
Mean	37.734949
Median Absolute Deviation (MAD)	12
Skewness	3.0175362
Sum	340973
Variance	725.98453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	239	2.6%
18	236	2.6%
31	235	2.6%
20	231	2.5%
22	230	2.5%
29	229	2.5%
30	223	2.4%
23	221	2.4%
19	220	2.4%
27	220	2.4%
Other values (180)	6752	74.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	9	0.1%
4	44	0.5%
5	48	0.5%
6	52	0.6%
7	60	0.7%
8	68	0.7%
9	82	0.9%
10	109	1.2%
11	104	1.1%
12	107	1.2%

Value	Count	Frequency (%)
319	1	< 0.1%
309	1	< 0.1%
306	1	< 0.1%
291	1	< 0.1%
288	1	< 0.1%
286	1	< 0.1%
282	1	< 0.1%
273	1	< 0.1%
269	1	< 0.1%
267	2	< 0.1%

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

HIGH CORRELATION

Distinct	93
Distinct (%)	1.0%
Missing	74
Missing (%)	0.8%
Infinite	0
Infinite (%)	0.0%
Mean	19.660259

Minimum	1
Maximum	116
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	11
median	17
Q3	25
95-th percentile	47
Maximum	116
Range	115
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	13.013382
Coefficient of variation (CV)	0.66191304
Kurtosis	4.163792
Mean	19.660259
Median Absolute Deviation (MAD)	7
Skewness	1.6784699
Sum	177945
Variance	169.3481
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	452	5.0%
16	436	4.8%
10	403	4.4%
15	393	4.3%
17	377	4.1%
13	375	4.1%
11	373	4.1%
18	371	4.1%
12	357	3.9%
19	329	3.6%
Other values (83)	5185	56.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	61	0.7%
2	102	1.1%
3	132	1.4%
4	141	1.5%
5	184	2.0%
6	196	2.1%
7	268	2.9%
8	275	3.0%
9	327	3.6%
10	403	4.4%

Value	Count	Frequency (%)
116	1	< 0.1%
101	1	< 0.1%
98	3	< 0.1%
96	2	< 0.1%
95	2	< 0.1%
94	2	< 0.1%
92	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
89	2	< 0.1%

Heatmap
Table

	측정일시	권역명	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
측정일시	1.000	0.000	0.000	0.576	0.690	0.568	0.344	0.573	0.501
권역명	0.000	1.000	1.000	0.211	0.083	0.188	0.308	0.043	0.014
측정소명	0.000	1.000	1.000	0.299	0.122	0.291	0.430	0.000	0.054
이산화질소농도(ppm)	0.576	0.211	0.299	1.000	0.634	0.780	0.569	0.504	0.610
오존농도(ppm)	0.690	0.083	0.122	0.634	1.000	0.533	0.244	0.247	0.388
일산화탄소농도(ppm)	0.568	0.188	0.291	0.780	0.533	1.000	0.693	0.538	0.715
아황산가스농도(ppm)	0.344	0.308	0.430	0.569	0.244	0.693	1.000	0.416	0.359
미세먼지(㎍/㎥)	0.573	0.043	0.000	0.504	0.247	0.538	0.416	1.000	0.753
초미세먼지(㎍/㎥)	0.501	0.014	0.054	0.610	0.388	0.715	0.359	0.753	1.000

Heatmap
Table

	측정소명	권역명
측정소명	1.000	0.999
권역명	0.999	1.000

Heatmap
Table

	측정일시	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)	권역명	측정소명
측정일시	1.000	-0.172	-0.100	-0.137	-0.255	-0.423	-0.292	0.000	0.000
이산화질소농도(ppm)	-0.172	1.000	-0.467	0.729	0.478	0.530	0.581	0.089	0.109
오존농도(ppm)	-0.100	-0.467	1.000	-0.295	-0.035	0.075	0.032	0.035	0.043
일산화탄소농도(ppm)	-0.137	0.729	-0.295	1.000	0.426	0.577	0.682	0.079	0.106
아황산가스농도(ppm)	-0.255	0.478	-0.035	0.426	1.000	0.463	0.467	0.133	0.166
미세먼지(㎍/㎥)	-0.423	0.530	0.075	0.577	0.463	1.000	0.851	0.018	0.000
초미세먼지(㎍/㎥)	-0.292	0.581	0.032	0.682	0.467	0.851	1.000	0.007	0.020
권역명	0.000	0.089	0.035	0.079	0.133	0.018	0.007	1.000	0.999
측정소명	0.000	0.109	0.043	0.106	0.166	0.000	0.020	0.999	1.000

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.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	측정일시	권역명	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
0	20230101	동남권	강남구	0.024	0.024	0.6	0.004	52	36
1	20230101	동남권	강동구	0.027	0.017	0.7	0.003	56	43
2	20230101	동북권	강북구	<NA>	0.026	0.7	0.004	51	34
3	20230101	서남권	강서구	0.021	0.025	0.6	0.004	62	38
4	20230101	서남권	관악구	0.025	0.02	0.6	0.003	54	35
5	20230101	동북권	광진구	0.0175	0.0176	0.79	0.0026	48	36
6	20230101	서남권	구로구	0.019	0.021	0.4	0.003	53	35
7	20230101	서남권	금천구	0.023	0.024	0.6	0.004	47	38
8	20230101	동북권	노원구	0.031	0.022	0.7	0.004	51	39
9	20230101	동북권	도봉구	0.02	0.029	0.7	0.003	43	32

	측정일시	권역명	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
9115	20231231	동북권	성동구	0.0281	0.0136	0.65	0.0022	24	17
9116	20231231	동북권	성북구	0.0268	0.0145	0.84	0.0021	21	18
9117	20231231	동남권	송파구	0.0292	0.014	0.7	0.0025	21	16
9118	20231231	서남권	양천구	0.0315	0.0164	0.73	0.003	27	22
9119	20231231	서남권	영등포구	0.0266	0.0182	0.68	0.0027	23	18
9120	20231231	도심권	용산구	0.0286	0.0146	0.78	0.0025	22	15
9121	20231231	서북권	은평구	0.0172	0.0178	1.12	0.0025	21	18
9122	20231231	도심권	종로구	0.0238	0.018	0.73	0.0029	22	18
9123	20231231	도심권	중구	0.0261	0.0179	0.67	0.0028	20	18
9124	20231231	동북권	중랑구	0.0316	0.013	0.68	0.0024	20	16

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample