gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	9125
Missing cells	457
Missing cells (%)	0.6%
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 3 other fields	High correlation
`오존농도(ppm)` is highly overall correlated with `이산화질소농도(ppm)`	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 99 (1.1%) missing values	Missing
`일산화탄소농도(ppm)` has 159 (1.7%) missing values	Missing

Reproduction

Analysis started	2024-05-03 21:50:18.730598
Analysis finished	2024-05-03 21:50:43.015892
Duration	24.29 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	20210668

Minimum	20210101
Maximum	20211231
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	20210101
5-th percentile	20210119
Q1	20210402
median	20210702
Q3	20211001
95-th percentile	20211213
Maximum	20211231
Range	1130
Interquartile range (IQR)	599

Descriptive statistics

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

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20210101	25	0.3%
20210909	25	0.3%
20210907	25	0.3%
20210906	25	0.3%
20210905	25	0.3%
20210904	25	0.3%
20210903	25	0.3%
20210902	25	0.3%
20210901	25	0.3%
20210831	25	0.3%
Other values (355)	8875	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20210101	25	0.3%
20210102	25	0.3%
20210103	25	0.3%
20210104	25	0.3%
20210105	25	0.3%
20210106	25	0.3%
20210107	25	0.3%
20210108	25	0.3%
20210109	25	0.3%
20210110	25	0.3%

Value	Count	Frequency (%)
20211231	25	0.3%
20211230	25	0.3%
20211229	25	0.3%
20211228	25	0.3%
20211227	25	0.3%
20211226	25	0.3%
20211225	25	0.3%
20211224	25	0.3%
20211223	25	0.3%
20211222	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 MISSING

Distinct	71
Distinct (%)	0.8%
Missing	99
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.023506647

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

Quantile statistics

Minimum	0.002
5-th percentile	0.009
Q1	0.014
median	0.021
Q3	0.031
95-th percentile	0.047
Maximum	0.081
Range	0.079
Interquartile range (IQR)	0.017

Descriptive statistics

Standard deviation	0.012104055
Coefficient of variation (CV)	0.51492053
Kurtosis	0.21374002
Mean	0.023506647
Median Absolute Deviation (MAD)	0.008
Skewness	0.8651156
Sum	212.171
Variance	0.00014650816
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.014	404	4.4%
0.015	385	4.2%
0.013	382	4.2%
0.016	378	4.1%
0.012	370	4.1%
0.017	366	4.0%
0.019	337	3.7%
0.018	322	3.5%
0.011	314	3.4%
0.02	306	3.4%
Other values (61)	5462	59.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.002	2	< 0.1%
0.003	5	0.1%
0.004	18	0.2%
0.005	33	0.4%
0.006	70	0.8%
0.007	119	1.3%
0.008	170	1.9%
0.009	258	2.8%
0.01	271	3.0%
0.011	314	3.4%

Value	Count	Frequency (%)
0.081	1	< 0.1%
0.073	1	< 0.1%
0.071	1	< 0.1%
0.069	1	< 0.1%
0.068	1	< 0.1%
0.067	2	< 0.1%
0.066	2	< 0.1%
0.065	3	< 0.1%
0.064	5	0.1%
0.063	11	0.1%

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

HIGH CORRELATION

Distinct	79
Distinct (%)	0.9%
Missing	42
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	0.02764351

Minimum	0.001
Maximum	0.08
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.001
5-th percentile	0.007
Q1	0.018
median	0.027
Q3	0.037
95-th percentile	0.048
Maximum	0.08
Range	0.079
Interquartile range (IQR)	0.019

Descriptive statistics

Standard deviation	0.01278252
Coefficient of variation (CV)	0.46240584
Kurtosis	-0.019403376
Mean	0.02764351
Median Absolute Deviation (MAD)	0.009
Skewness	0.29219225
Sum	251.086
Variance	0.00016339283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.025	291	3.2%
0.027	285	3.1%
0.033	269	2.9%
0.021	261	2.9%
0.03	258	2.8%
0.028	257	2.8%
0.024	254	2.8%
0.023	254	2.8%
0.026	253	2.8%
0.038	251	2.8%
Other values (69)	6450	70.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001	8	0.1%
0.002	58	0.6%
0.003	84	0.9%
0.004	64	0.7%
0.005	87	1.0%
0.006	92	1.0%
0.007	104	1.1%
0.008	110	1.2%
0.009	111	1.2%
0.01	151	1.7%

Value	Count	Frequency (%)
0.08	1	< 0.1%
0.078	3	< 0.1%
0.077	2	< 0.1%
0.076	2	< 0.1%
0.075	2	< 0.1%
0.074	1	< 0.1%
0.073	1	< 0.1%
0.072	2	< 0.1%
0.071	2	< 0.1%
0.07	8	0.1%

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

HIGH CORRELATION MISSING

Distinct	14
Distinct (%)	0.2%
Missing	159
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.46309391

Minimum	0.1
Maximum	1.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.1
5-th percentile	0.3
Q1	0.3
median	0.4
Q3	0.5
95-th percentile	0.8
Maximum	1.5
Range	1.4
Interquartile range (IQR)	0.2

Descriptive statistics

Standard deviation	0.16824867
Coefficient of variation (CV)	0.36331437
Kurtosis	1.2769007
Mean	0.46309391
Median Absolute Deviation (MAD)	0.1
Skewness	1.0639354
Sum	4152.1
Variance	0.028307616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0.4	2634	28.9%
0.3	2032	22.3%
0.5	1772	19.4%
0.6	968	10.6%
0.7	571	6.3%
0.2	356	3.9%
0.8	322	3.5%
0.9	200	2.2%
1.0	77	0.8%
1.1	25	0.3%
Other values (4)	9	0.1%
(Missing)	159	1.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.1	2	< 0.1%
0.2	356	3.9%
0.3	2032	22.3%
0.4	2634	28.9%
0.5	1772	19.4%
0.6	968	10.6%
0.7	571	6.3%
0.8	322	3.5%
0.9	200	2.2%
1.0	77	0.8%

Value	Count	Frequency (%)
1.5	1	< 0.1%
1.4	1	< 0.1%
1.2	5	0.1%
1.1	25	0.3%
1.0	77	0.8%
0.9	200	2.2%
0.8	322	3.5%
0.7	571	6.3%
0.6	968	10.6%
0.5	1772	19.4%

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

Distinct	9
Distinct (%)	0.1%
Missing	67
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	0.0030895341

Minimum	0.001
Maximum	0.009
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	80.3 KiB

Quantile statistics

Minimum	0.001
5-th percentile	0.002
Q1	0.003
median	0.003
Q3	0.003
95-th percentile	0.004
Maximum	0.009
Range	0.008
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.00078424279
Coefficient of variation (CV)	0.25383853
Kurtosis	2.4182165
Mean	0.0030895341
Median Absolute Deviation (MAD)	0
Skewness	0.84172158
Sum	27.985
Variance	6.1503675 × 10^-7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
0.003	4995	54.7%
0.004	1881	20.6%
0.002	1833	20.1%
0.005	273	3.0%
0.006	53	0.6%
0.007	10	0.1%
0.001	7	0.1%
0.008	4	< 0.1%
0.009	2	< 0.1%
(Missing)	67	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001	7	0.1%
0.002	1833	20.1%
0.003	4995	54.7%
0.004	1881	20.6%
0.005	273	3.0%
0.006	53	0.6%
0.007	10	0.1%
0.008	4	< 0.1%
0.009	2	< 0.1%

Value	Count	Frequency (%)
0.009	2	< 0.1%
0.008	4	< 0.1%
0.007	10	0.1%
0.006	53	0.6%
0.005	273	3.0%
0.004	1881	20.6%
0.003	4995	54.7%
0.002	1833	20.1%
0.001	7	0.1%

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

HIGH CORRELATION

Distinct	217
Distinct (%)	2.4%
Missing	47
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	37.899647

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

Quantile statistics

Minimum	3
5-th percentile	10
Q1	20
median	30
Q3	44
95-th percentile	86
Maximum	503
Range	500
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	37.411182
Coefficient of variation (CV)	0.9871116
Kurtosis	55.73103
Mean	37.899647
Median Absolute Deviation (MAD)	11
Skewness	6.2089401
Sum	344053
Variance	1399.5965
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	272	3.0%
23	251	2.8%
28	244	2.7%
21	240	2.6%
25	235	2.6%
27	226	2.5%
26	224	2.5%
30	215	2.4%
19	215	2.4%
29	215	2.4%
Other values (207)	6741	73.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	8	0.1%
4	24	0.3%
5	35	0.4%
6	43	0.5%
7	64	0.7%
8	92	1.0%
9	120	1.3%
10	156	1.7%
11	146	1.6%
12	162	1.8%

Value	Count	Frequency (%)
503	1	< 0.1%
497	1	< 0.1%
478	1	< 0.1%
473	1	< 0.1%
471	1	< 0.1%
466	1	< 0.1%
465	1	< 0.1%
463	1	< 0.1%
460	1	< 0.1%
458	1	< 0.1%

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

HIGH CORRELATION

Distinct	112
Distinct (%)	1.2%
Missing	43
Missing (%)	0.5%
Infinite	0
Infinite (%)	0.0%
Mean	19.774499

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

Quantile statistics

Minimum	1
5-th percentile	4
Q1	10
median	16
Q3	24
95-th percentile	48
Maximum	123
Range	122
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	15.017943
Coefficient of variation (CV)	0.75946011
Kurtosis	7.296018
Mean	19.774499
Median Absolute Deviation (MAD)	7
Skewness	2.2729945
Sum	179592
Variance	225.53862
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	428	4.7%
13	408	4.5%
14	404	4.4%
11	378	4.1%
15	374	4.1%
16	371	4.1%
17	371	4.1%
10	344	3.8%
18	330	3.6%
9	317	3.5%
Other values (102)	5357	58.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	29	0.3%
2	104	1.1%
3	153	1.7%
4	238	2.6%
5	263	2.9%
6	240	2.6%
7	288	3.2%
8	313	3.4%
9	317	3.5%
10	344	3.8%

Value	Count	Frequency (%)
123	1	< 0.1%
114	1	< 0.1%
113	1	< 0.1%
111	1	< 0.1%
110	3	< 0.1%
109	1	< 0.1%
108	1	< 0.1%
107	2	< 0.1%
106	2	< 0.1%
104	3	< 0.1%

Heatmap
Table

	측정일시	권역명	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지농도(㎍/㎥)	초미세먼지농도(㎍/㎥)
측정일시	1.000	0.000	0.000	0.574	0.699	0.453	0.307	0.463	0.480
권역명	0.000	1.000	1.000	0.218	0.064	0.099	0.222	0.041	0.066
측정소명	0.000	1.000	1.000	0.326	0.119	0.285	0.451	0.000	0.070
이산화질소농도(ppm)	0.574	0.218	0.326	1.000	0.658	0.771	0.403	0.466	0.637
오존농도(ppm)	0.699	0.064	0.119	0.658	1.000	0.471	0.248	0.226	0.425
일산화탄소농도(ppm)	0.453	0.099	0.285	0.771	0.471	1.000	0.415	0.369	0.536
아황산가스농도(ppm)	0.307	0.222	0.451	0.403	0.248	0.415	1.000	0.238	0.353
미세먼지농도(㎍/㎥)	0.463	0.041	0.000	0.466	0.226	0.369	0.238	1.000	0.805
초미세먼지농도(㎍/㎥)	0.480	0.066	0.070	0.637	0.425	0.536	0.353	0.805	1.000

Heatmap
Table

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

Heatmap
Table

	측정일시	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지농도(㎍/㎥)	초미세먼지농도(㎍/㎥)	권역명	측정소명
측정일시	1.000	-0.116	-0.108	-0.097	-0.140	-0.237	-0.213	0.000	0.000
이산화질소농도(ppm)	-0.116	1.000	-0.584	0.754	0.494	0.603	0.632	0.092	0.120
오존농도(ppm)	-0.108	-0.584	1.000	-0.491	-0.203	-0.120	-0.131	0.026	0.042
일산화탄소농도(ppm)	-0.097	0.754	-0.491	1.000	0.485	0.618	0.683	0.057	0.113
아황산가스농도(ppm)	-0.140	0.494	-0.203	0.485	1.000	0.437	0.455	0.129	0.190
미세먼지농도(㎍/㎥)	-0.237	0.603	-0.120	0.618	0.437	1.000	0.900	0.017	0.000
초미세먼지농도(㎍/㎥)	-0.213	0.632	-0.131	0.683	0.455	0.900	1.000	0.027	0.025
권역명	0.000	0.092	0.026	0.057	0.129	0.017	0.027	1.000	0.999
측정소명	0.000	0.120	0.042	0.113	0.190	0.000	0.025	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	20210101	동남권	강남구	0.022	0.017	0.5	0.004	22	14
1	20210101	동남권	강동구	0.029	0.014	0.5	0.003	30	20
2	20210101	동북권	강북구	0.025	0.013	0.6	0.003	33	19
3	20210101	서남권	강서구	0.027	0.018	0.3	0.005	25	14
4	20210101	서남권	관악구	0.033	0.013	0.6	0.004	21	12
5	20210101	동북권	광진구	0.025	0.011	0.6	<NA>	25	16
6	20210101	서남권	구로구	0.029	0.016	0.4	0.004	24	14
7	20210101	서남권	금천구	0.03	0.015	0.5	0.003	28	18
8	20210101	동북권	노원구	0.029	0.015	0.6	0.004	29	21
9	20210101	동북권	도봉구	0.023	0.017	0.4	0.002	22	17

	측정일시	권역명	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스농도(ppm)	미세먼지농도(㎍/㎥)	초미세먼지농도(㎍/㎥)
9115	20211231	동북권	성동구	0.014	0.031	0.3	0.003	21	5
9116	20211231	동북권	성북구	0.014	0.03	0.4	0.002	17	4
9117	20211231	동남권	송파구	0.02	0.025	0.4	0.003	23	7
9118	20211231	서남권	양천구	0.017	0.024	0.4	0.002	22	8
9119	20211231	서남권	영등포구	0.015	0.026	0.3	0.002	22	6
9120	20211231	도심권	용산구	0.012	0.028	0.3	0.003	25	8
9121	20211231	서북권	은평구	0.014	0.027	<NA>	0.004	26	8
9122	20211231	도심권	종로구	0.012	0.032	0.3	0.003	23	6
9123	20211231	도심권	중구	0.013	0.033	0.3	0.003	20	7
9124	20211231	동북권	중랑구	0.017	0.028	0.3	0.003	22	6

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample