gimi9 Pandas Profiling

Dataset statistics

Number of variables	8
Number of observations	10000
Missing cells	9126
Missing cells (%)	11.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	771.5 KiB
Average record size in memory	79.0 B

Variable types

Numeric	7
Text	1

Dataset

Description	측정월,측정소명,이산화질소농도(ppm),오존농도(ppm),일산화탄소농도(ppm),아황산가스(ppm),미세먼지(㎍/㎥),초미세먼지(㎍/㎥)
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-2217/S/1/datasetView.do

Alerts

`측정월` 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
`오존농도(ppm)` is highly overall correlated with `이산화질소농도(ppm)` and 1 other fields	High correlation
`일산화탄소농도(ppm)` is highly overall correlated with `측정월` and 4 other fields	High correlation
`아황산가스(ppm)` is highly overall correlated with `측정월` and 3 other fields	High correlation
`미세먼지(㎍/㎥)` is highly overall correlated with `측정월` and 4 other fields	High correlation
`초미세먼지(㎍/㎥)` is highly overall correlated with `이산화질소농도(ppm)` and 3 other fields	High correlation
`이산화질소농도(ppm)` has 314 (3.1%) missing values	Missing
`오존농도(ppm)` has 492 (4.9%) missing values	Missing
`일산화탄소농도(ppm)` has 334 (3.3%) missing values	Missing
`아황산가스(ppm)` has 506 (5.1%) missing values	Missing
`미세먼지(㎍/㎥)` has 1621 (16.2%) missing values	Missing
`초미세먼지(㎍/㎥)` has 5859 (58.6%) missing values	Missing

Reproduction

Analysis started	2024-05-11 06:33:33.871213
Analysis finished	2024-05-11 06:33:44.216923
Duration	10.35 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

측정월
Real number (ℝ)

HIGH CORRELATION

Distinct	449
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	200916.63

Minimum	198701
Maximum	202405
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	198701
5-th percentile	199209
Q1	200111
median	201006
Q3	201804
95-th percentile	202303
Maximum	202405
Range	3704
Interquartile range (IQR)	1693

Descriptive statistics

Standard deviation	970.65464
Coefficient of variation (CV)	0.0048311314
Kurtosis	-0.93997151
Mean	200916.63
Median Absolute Deviation (MAD)	802
Skewness	-0.30274035
Sum	2.0091663 × 10⁹
Variance	942170.43
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
202004	43	0.4%
202201	41	0.4%
202206	41	0.4%
202212	41	0.4%
202005	39	0.4%
202305	39	0.4%
202107	39	0.4%
202211	39	0.4%
202111	39	0.4%
202204	39	0.4%
Other values (439)	9600	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
198701	6	0.1%
198702	7	0.1%
198703	6	0.1%
198704	7	0.1%
198705	9	0.1%
198706	5	0.1%
198707	7	0.1%
198708	5	0.1%
198709	5	0.1%
198710	8	0.1%

Value	Count	Frequency (%)
202405	33	0.3%
202404	32	0.3%
202403	27	0.3%
202402	38	0.4%
202401	33	0.3%
202312	34	0.3%
202311	34	0.3%
202310	36	0.4%
202309	32	0.3%
202308	38	0.4%

측정소명
Text

Distinct	53
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Length

Max length	6
Median length	3
Mean length	3.2725
Min length	2

Characters and Unicode

Total characters	32725
Distinct characters	71
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	정릉로
2nd row	화랑로
3rd row	신촌로
4th row	강변북로
5th row	은평구

Value	Count	Frequency (%)
서초구	330	3.3%
용산구	311	3.1%
서대문구	307	3.1%
도봉구	307	3.1%
성동구	303	3.0%
구로구	301	3.0%
천호대로	292	2.9%
송파구	292	2.9%
광진구	291	2.9%
강서구	266	2.7%
Other values (43)	7000	70.0%

Most occurring characters

Value	Count	Frequency (%)
구	7255	22.2%
로	3346	10.2%
대	1699	5.2%
강	1402	4.3%
동	1105	3.4%
천	993	3.0%
서	950	2.9%
포	776	2.4%
산	696	2.1%
문	693	2.1%
Other values (61)	13810	42.2%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	32358	98.9%
Decimal Number	367	1.1%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
구	7255	22.4%
로	3346	10.3%
대	1699	5.3%
강	1402	4.3%
동	1105	3.4%
천	993	3.1%
서	950	2.9%
포	776	2.4%
산	696	2.2%
문	693	2.1%
Other values (60)	13443	41.5%

Decimal Number

Value	Count	Frequency (%)
2	367	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	32358	98.9%
Common	367	1.1%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
구	7255	22.4%
로	3346	10.3%
대	1699	5.3%
강	1402	4.3%
동	1105	3.4%
천	993	3.1%
서	950	2.9%
포	776	2.4%
산	696	2.2%
문	693	2.1%
Other values (60)	13443	41.5%

Common

Value	Count	Frequency (%)
2	367	100.0%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	32358	98.9%
ASCII	367	1.1%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
구	7255	22.4%
로	3346	10.3%
대	1699	5.3%
강	1402	4.3%
동	1105	3.4%
천	993	3.1%
서	950	2.9%
포	776	2.4%
산	696	2.2%
문	693	2.1%
Other values (60)	13443	41.5%

ASCII

Value	Count	Frequency (%)
2	367	100.0%

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

HIGH CORRELATION MISSING

Distinct	295
Distinct (%)	3.0%
Missing	314
Missing (%)	3.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.035424159

Minimum	0.002
Maximum	0.622
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.002
5-th percentile	0.015
Q1	0.026
median	0.03455
Q3	0.043
95-th percentile	0.059
Maximum	0.622
Range	0.62
Interquartile range (IQR)	0.017

Descriptive statistics

Standard deviation	0.014865421
Coefficient of variation (CV)	0.41964076
Kurtosis	250.68723
Mean	0.035424159
Median Absolute Deviation (MAD)	0.00845
Skewness	6.9391148
Sum	343.1184
Variance	0.00022098074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.036	341	3.4%
0.037	329	3.3%
0.032	328	3.3%
0.038	324	3.2%
0.034	311	3.1%
0.035	302	3.0%
0.04	299	3.0%
0.033	292	2.9%
0.031	282	2.8%
0.039	280	2.8%
Other values (285)	6598	66.0%
(Missing)	314	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.002	1	< 0.1%
0.004	1	< 0.1%
0.0045	1	< 0.1%
0.005	3	< 0.1%
0.006	8	0.1%
0.0061	1	< 0.1%
0.0063	2	< 0.1%
0.0064	1	< 0.1%
0.0066	1	< 0.1%
0.007	15	0.1%

Value	Count	Frequency (%)
0.622	1	< 0.1%
0.109	1	< 0.1%
0.107	1	< 0.1%
0.103	1	< 0.1%
0.101	1	< 0.1%
0.1	1	< 0.1%
0.099	3	< 0.1%
0.097	2	< 0.1%
0.096	2	< 0.1%
0.095	1	< 0.1%

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

HIGH CORRELATION MISSING

Distinct	303
Distinct (%)	3.2%
Missing	492
Missing (%)	4.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.01883231

Minimum	0
Maximum	0.478
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.006
Q1	0.011
median	0.017
Q3	0.025
95-th percentile	0.038
Maximum	0.478
Range	0.478
Interquartile range (IQR)	0.014

Descriptive statistics

Standard deviation	0.01095891
Coefficient of variation (CV)	0.58192067
Kurtosis	323.49221
Mean	0.01883231
Median Absolute Deviation (MAD)	0.007
Skewness	8.3035222
Sum	179.0576
Variance	0.00012009771
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.011	461	4.6%
0.014	427	4.3%
0.01	419	4.2%
0.012	413	4.1%
0.013	408	4.1%
0.016	402	4.0%
0.008	390	3.9%
0.015	384	3.8%
0.009	378	3.8%
0.018	356	3.6%
Other values (293)	5470	54.7%
(Missing)	492	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	3	< 0.1%
0.001	5	0.1%
0.002	19	0.2%
0.003	54	0.5%
0.004	101	1.0%
0.005	182	1.8%
0.006	231	2.3%
0.007	331	3.3%
0.008	390	3.9%
0.009	378	3.8%

Value	Count	Frequency (%)
0.478	1	< 0.1%
0.065	1	< 0.1%
0.064	1	< 0.1%
0.0635	1	< 0.1%
0.06	1	< 0.1%
0.057	1	< 0.1%
0.056	2	< 0.1%
0.054	1	< 0.1%
0.0534	1	< 0.1%
0.053	1	< 0.1%

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

HIGH CORRELATION MISSING

Distinct	126
Distinct (%)	1.3%
Missing	334
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.81145562

Minimum	0
Maximum	12.2
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.3
Q1	0.5
median	0.6
Q3	0.8
95-th percentile	2
Maximum	12.2
Range	12.2
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.72217776
Coefficient of variation (CV)	0.88997814
Kurtosis	40.932725
Mean	0.81145562
Median Absolute Deviation (MAD)	0.2
Skewness	5.0203931
Sum	7843.53
Variance	0.52154072
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6	1538	15.4%
0.5	1498	15.0%
0.4	1350	13.5%
0.7	1141	11.4%
0.8	758	7.6%
0.3	523	5.2%
0.9	497	5.0%
1.0	321	3.2%
1.1	227	2.3%
1.2	145	1.5%
Other values (116)	1668	16.7%
(Missing)	334	3.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	< 0.1%
0.1	7	0.1%
0.2	63	0.6%
0.22	2	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.26	2	< 0.1%
0.27	3	< 0.1%
0.28	2	< 0.1%
0.29	2	< 0.1%

Value	Count	Frequency (%)
12.2	1	< 0.1%
11.7	1	< 0.1%
11.2	1	< 0.1%
10.6	1	< 0.1%
8.7	1	< 0.1%
8.3	1	< 0.1%
8.2	1	< 0.1%
8.1	1	< 0.1%
7.8	1	< 0.1%
7.5	1	< 0.1%

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

HIGH CORRELATION MISSING

Distinct	170
Distinct (%)	1.8%
Missing	506
Missing (%)	5.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.0083261744

Minimum	0
Maximum	0.24
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0023
Q1	0.003
median	0.005
Q3	0.007
95-th percentile	0.022
Maximum	0.24
Range	0.24
Interquartile range (IQR)	0.004

Descriptive statistics

Standard deviation	0.016071028
Coefficient of variation (CV)	1.9301815
Kurtosis	62.235611
Mean	0.0083261744
Median Absolute Deviation (MAD)	0.002
Skewness	7.1922826
Sum	79.0487
Variance	0.00025827793
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.003	1695	17.0%
0.004	1539	15.4%
0.005	1429	14.3%
0.006	1150	11.5%
0.007	786	7.9%
0.008	467	4.7%
0.002	444	4.4%
0.009	311	3.1%
0.01	188	1.9%
0.011	133	1.3%
Other values (160)	1352	13.5%
(Missing)	506	5.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	2	< 0.1%
0.001	8	0.1%
0.0019	1	< 0.1%
0.002	444	4.4%
0.0021	3	< 0.1%
0.0022	13	0.1%
0.0023	18	0.2%
0.0024	28	0.3%
0.0025	44	0.4%
0.0026	55	0.5%

Value	Count	Frequency (%)
0.24	1	< 0.1%
0.211	1	< 0.1%
0.204	1	< 0.1%
0.2	2	< 0.1%
0.194	1	< 0.1%
0.192	2	< 0.1%
0.19	1	< 0.1%
0.188	1	< 0.1%
0.187	1	< 0.1%
0.185	1	< 0.1%

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

HIGH CORRELATION MISSING

Distinct	150
Distinct (%)	1.8%
Missing	1621
Missing (%)	16.2%
Infinite	0
Infinite (%)	0.0%
Mean	51.538131

Minimum	0
Maximum	399
Zeros	7
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	23
Q1	37
median	49
Q3	64
95-th percentile	87
Maximum	399
Range	399
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	20.988261
Coefficient of variation (CV)	0.40723753
Kurtosis	11.730421
Mean	51.538131
Median Absolute Deviation (MAD)	13
Skewness	1.5283378
Sum	431838
Variance	440.50711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	194	1.9%
46	192	1.9%
42	192	1.9%
41	186	1.9%
48	184	1.8%
45	183	1.8%
44	179	1.8%
43	172	1.7%
50	167	1.7%
47	164	1.6%
Other values (140)	6566	65.7%
(Missing)	1621	16.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	0.1%
1	1	< 0.1%
4	1	< 0.1%
5	4	< 0.1%
6	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	3	< 0.1%
12	3	< 0.1%
13	3	< 0.1%

Value	Count	Frequency (%)
399	1	< 0.1%
255	1	< 0.1%
186	1	< 0.1%
183	1	< 0.1%
179	1	< 0.1%
172	1	< 0.1%
168	1	< 0.1%
165	1	< 0.1%
163	1	< 0.1%
160	1	< 0.1%

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

HIGH CORRELATION MISSING

Distinct	49
Distinct (%)	1.2%
Missing	5859
Missing (%)	58.6%
Infinite	0
Infinite (%)	0.0%
Mean	22.689206

Minimum	5
Maximum	55
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	5
5-th percentile	11
Q1	17
median	22
Q3	28
95-th percentile	35
Maximum	55
Range	50
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	7.6271351
Coefficient of variation (CV)	0.33615699
Kurtosis	0.40867438
Mean	22.689206
Median Absolute Deviation (MAD)	5
Skewness	0.49072507
Sum	93956
Variance	58.17319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
22	223	2.2%
21	220	2.2%
23	215	2.1%
24	204	2.0%
18	202	2.0%
17	199	2.0%
20	195	1.9%
26	193	1.9%
19	191	1.9%
16	177	1.8%
Other values (39)	2122	21.2%
(Missing)	5859	58.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	5	0.1%
6	9	0.1%
7	20	0.2%
8	29	0.3%
9	35	0.4%
10	56	0.6%
11	67	0.7%
12	96	1.0%
13	128	1.3%
14	154	1.5%

Value	Count	Frequency (%)
55	1	< 0.1%
52	2	< 0.1%
51	2	< 0.1%
50	6	0.1%
49	5	0.1%
48	5	0.1%
47	6	0.1%
46	9	0.1%
45	6	0.1%
44	8	0.1%

Phik (φk)
Auto

Heatmap
Table

	측정월	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
측정월	1.000	0.527	0.197	0.186	0.673	0.678	0.387	0.342
측정소명	0.527	1.000	0.524	0.343	0.297	0.268	0.251	0.254
이산화질소농도(ppm)	0.197	0.524	1.000	0.000	0.258	0.043	0.114	0.197
오존농도(ppm)	0.186	0.343	0.000	1.000	0.035	0.077	0.082	0.145
일산화탄소농도(ppm)	0.673	0.297	0.258	0.035	1.000	0.832	0.290	0.000
아황산가스(ppm)	0.678	0.268	0.043	0.077	0.832	1.000	0.174	NaN
미세먼지(㎍/㎥)	0.387	0.251	0.114	0.082	0.290	0.174	1.000	0.686
초미세먼지(㎍/㎥)	0.342	0.254	0.197	0.145	0.000	NaN	0.686	1.000

Heatmap
Table

	측정월	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
측정월	1.000	-0.295	0.459	-0.584	-0.643	-0.557	-0.357
이산화질소농도(ppm)	-0.295	1.000	-0.516	0.493	0.445	0.586	0.635
오존농도(ppm)	0.459	-0.516	1.000	-0.613	-0.460	-0.359	-0.378
일산화탄소농도(ppm)	-0.584	0.493	-0.613	1.000	0.634	0.550	0.573
아황산가스(ppm)	-0.643	0.445	-0.460	0.634	1.000	0.560	0.529
미세먼지(㎍/㎥)	-0.557	0.586	-0.359	0.550	0.560	1.000	0.856
초미세먼지(㎍/㎥)	-0.357	0.635	-0.378	0.573	0.529	0.856	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)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
938	202211	정릉로	0.036	0.012	0.6	0.003	42	24
5648	201312	화랑로	0.051	0.005	1.1	0.008	72	43
11598	200004	신촌로	0.046	0.015	1.4	0.009	74	<NA>
2903	201907	강변북로	0.046	0.018	0.3	0.004	26	18
8978	200607	은평구	0.019	0.017	0.5	0.002	42	<NA>
4017	201705	은평구	0.027	0.042	0.5	0.005	72	26
2714	201911	도봉구	0.027	0.015	0.6	0.003	32	17
5698	201310	구로구	0.032	0.015	0.5	0.005	32	17
6118	201212	정릉로	0.043	0.012	0.7	0.006	45	24
10214	200307	강북구	0.027	0.017	0.5	0.002	64	<NA>

	측정월	측정소명	이산화질소농도(ppm)	오존농도(ppm)	일산화탄소농도(ppm)	아황산가스(ppm)	미세먼지(㎍/㎥)	초미세먼지(㎍/㎥)
4261	201611	화랑로	0.043	0.009	0.8	0.005	64	31
14034	199110	광진구	0.032	0.015	1.4	0.023	<NA>	<NA>
7592	200910	영등포로	0.058	0.009	0.8	0.007	61	<NA>
5631	201312	송파구	0.039	0.009	0.8	0.007	52	33
14260	199002	광진구	0.036	0.004	2.7	0.051	<NA>	<NA>
13640	199405	신촌로	0.071	0.013	1.7	0.02	<NA>	<NA>
13933	199207	송파구	0.025	0.028	0.7	0.006	70	<NA>
6987	201102	서대문구	0.041	0.016	0.7	0.006	83	<NA>
1064	202208	도봉구	0.01	0.031	0.3	0.002	17	9
5271	201409	송파구	0.03	0.021	0.6	0.003	26	16

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Interactions

Correlations

Missing values

Sample