gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	9074
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	779.9 KiB
Average record size in memory	88.0 B

Variable types

Numeric	8
Categorical	2

Dataset

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

Alerts

`msrste_nm` is highly overall correlated with `msrrgn_cd` and 2 other fields	High correlation
`msrrgn_nm` is highly overall correlated with `msrrgn_cd` and 2 other fields	High correlation
`msrrgn_cd` is highly overall correlated with `msradm` and 2 other fields	High correlation
`msradm` is highly overall correlated with `msrrgn_cd` and 2 other fields	High correlation
`pm10` is highly overall correlated with `no2`	High correlation
`no2` is highly overall correlated with `pm10` and 1 other fields	High correlation
`co` is highly overall correlated with `no2`	High correlation
`pm10` has 620 (6.8%) zeros	Zeros
`o3` has 369 (4.1%) zeros	Zeros
`no2` has 378 (4.2%) zeros	Zeros
`co` has 378 (4.2%) zeros	Zeros
`so2` has 372 (4.1%) zeros	Zeros

Reproduction

Analysis started	2024-05-11 06:42:49.125054
Analysis finished	2024-05-11 06:43:17.993988
Duration	28.87 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

msrdt_de
Real number (ℝ)

Distinct	364
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20200671

Minimum	20200101
Maximum	20201231
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	20200101
5-th percentile	20200120
Q1	20200403
median	20200703
Q3	20201002
95-th percentile	20201213
Maximum	20201231
Range	1130
Interquartile range (IQR)	599

Descriptive statistics

Standard deviation	343.83321
Coefficient of variation (CV)	1.7020881 × 10^-5
Kurtosis	-1.1995848
Mean	20200671
Median Absolute Deviation (MAD)	299
Skewness	-0.016878685
Sum	1.8330089 × 10¹¹
Variance	118221.28
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20201231	25	0.3%
20200520	25	0.3%
20200430	25	0.3%
20200501	25	0.3%
20200502	25	0.3%
20200503	25	0.3%
20200504	25	0.3%
20200505	25	0.3%
20200506	25	0.3%
20200507	25	0.3%
Other values (354)	8824	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20200101	20	0.2%
20200102	20	0.2%
20200103	20	0.2%
20200104	20	0.2%
20200105	20	0.2%
20200106	24	0.3%
20200107	25	0.3%
20200108	25	0.3%
20200109	25	0.3%
20200110	25	0.3%

Value	Count	Frequency (%)
20201231	25	0.3%
20201230	25	0.3%
20201229	25	0.3%
20201228	25	0.3%
20201227	25	0.3%
20201226	25	0.3%
20201225	25	0.3%
20201224	25	0.3%
20201223	25	0.3%
20201222	25	0.3%

msrrgn_cd
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	318.38131

Minimum	100
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	100
5-th percentile	100
Q1	102
median	104
Q3	108
95-th percentile	999
Maximum	999
Range	899
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	382.53054
Coefficient of variation (CV)	1.2014855
Kurtosis	-0.51769466
Mean	318.38131
Median Absolute Deviation (MAD)	4
Skewness	1.2174639
Sum	2888992
Variance	146329.61
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
999	2178	24.0%
103	1456	16.0%
108	1451	16.0%
102	1451	16.0%
100	1092	12.0%
104	1082	11.9%
101	364	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100	1092	12.0%
101	364	4.0%
102	1451	16.0%
103	1456	16.0%
104	1082	11.9%
108	1451	16.0%
999	2178	24.0%

Value	Count	Frequency (%)
999	2178	24.0%
108	1451	16.0%
104	1082	11.9%
103	1456	16.0%
102	1451	16.0%
101	364	4.0%
100	1092	12.0%

msrrgn_nm
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	71.0 KiB

기타	2178
서남권	1456
입체	1451
동북권	1451
도심권	1092
Other values (2)	1446

Length

Max length	3
Median length	3
Mean length	2.6000661
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 (%)
기타	2178	24.0%
서남권	1456	16.0%
입체	1451	16.0%
동북권	1451	16.0%
도심권	1092	12.0%
동남권	1082	11.9%
서북권	364	4.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
기타	2178	24.0%
서남권	1456	16.0%
입체	1451	16.0%
동북권	1451	16.0%
도심권	1092	12.0%
동남권	1082	11.9%
서북권	364	4.0%

msradm
Real number (ℝ)

HIGH CORRELATION

Distinct	25
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	217872.8

Minimum	111122
Maximum	555556
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	111122
5-th percentile	111124
Q1	111162
median	111242
Q3	111545
95-th percentile	555555
Maximum	555556
Range	444434
Interquartile range (IQR)	383

Descriptive statistics

Standard deviation	189784.32
Coefficient of variation (CV)	0.87107851
Kurtosis	-0.51758176
Mean	217872.8
Median Absolute Deviation (MAD)	86
Skewness	1.2175925
Sum	1.9769778 × 10⁹
Variance	3.6018086 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
111232	364	4.0%
111162	364	4.0%
555556	364	4.0%
111124	364	4.0%
555555	364	4.0%
111143	364	4.0%
111272	364	4.0%
111545	364	4.0%
111122	364	4.0%
111155	364	4.0%
Other values (15)	5434	59.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111122	364	4.0%
111124	364	4.0%
111143	364	4.0%
111154	364	4.0%
111155	364	4.0%
111156	364	4.0%
111162	364	4.0%
111192	364	4.0%
111200	359	4.0%
111202	364	4.0%

Value	Count	Frequency (%)
555556	364	4.0%
555555	364	4.0%
555554	364	4.0%
555553	364	4.0%
555552	364	4.0%
555550	358	3.9%
111545	364	4.0%
111278	359	4.0%
111277	364	4.0%
111276	359	4.0%

msrste_nm
Categorical

HIGH CORRELATION

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

영등포로	364
정릉로	364
세곡	364
관악산	364
홍릉로	364
Other values (20)	7254

Length

Max length	6
Median length	5
Mean length	3.5188451
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 (%)
영등포로	364	4.0%
정릉로	364	4.0%
세곡	364	4.0%
관악산	364	4.0%
홍릉로	364	4.0%
남산	364	4.0%
공항대로	364	4.0%
화랑로	364	4.0%
동작대로	364	4.0%
북한산	364	4.0%
Other values (15)	5434	59.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
영등포로	364	4.0%
신촌로	364	4.0%
청계천로	364	4.0%
행주	364	4.0%
서울숲	364	4.0%
올림픽공원	364	4.0%
시흥대로	364	4.0%
한강대로	364	4.0%
종로	364	4.0%
정릉로	364	4.0%
Other values (15)	5434	59.9%

pm10
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	123
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	34.782896

Minimum	0
Maximum	167
Zeros	620
Zeros (%)	6.8%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	21
median	33
Q3	48
95-th percentile	70
Maximum	167
Range	167
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	20.533532
Coefficient of variation (CV)	0.59033418
Kurtosis	1.0268396
Mean	34.782896
Median Absolute Deviation (MAD)	13
Skewness	0.59994923
Sum	315620
Variance	421.62596
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	620	6.8%
30	226	2.5%
28	215	2.4%
25	212	2.3%
26	200	2.2%
24	195	2.1%
29	189	2.1%
27	188	2.1%
31	187	2.1%
32	186	2.0%
Other values (113)	6656	73.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	620	6.8%
3	11	0.1%
4	16	0.2%
5	35	0.4%
6	51	0.6%
7	46	0.5%
8	64	0.7%
9	82	0.9%
10	81	0.9%
11	92	1.0%

Value	Count	Frequency (%)
167	2	< 0.1%
166	1	< 0.1%
153	1	< 0.1%
146	1	< 0.1%
132	1	< 0.1%
131	1	< 0.1%
127	2	< 0.1%
126	1	< 0.1%
118	1	< 0.1%
117	2	< 0.1%

o3
Real number (ℝ)

ZEROS

Distinct	82
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02218812

Minimum	0
Maximum	0.097
Zeros	369
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.003
Q1	0.013
median	0.021
Q3	0.03
95-th percentile	0.046
Maximum	0.097
Range	0.097
Interquartile range (IQR)	0.017

Descriptive statistics

Standard deviation	0.013160079
Coefficient of variation (CV)	0.59311376
Kurtosis	0.680673
Mean	0.02218812
Median Absolute Deviation (MAD)	0.009
Skewness	0.67757593
Sum	201.335
Variance	0.00017318769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	369	4.1%
0.017	305	3.4%
0.014	286	3.2%
0.018	286	3.2%
0.021	284	3.1%
0.019	282	3.1%
0.015	281	3.1%
0.026	273	3.0%
0.016	270	3.0%
0.013	267	2.9%
Other values (72)	6171	68.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	369	4.1%
0.002	9	0.1%
0.003	84	0.9%
0.004	128	1.4%
0.005	188	2.1%
0.006	166	1.8%
0.007	179	2.0%
0.008	194	2.1%
0.009	223	2.5%
0.01	244	2.7%

Value	Count	Frequency (%)
0.097	1	< 0.1%
0.094	1	< 0.1%
0.086	1	< 0.1%
0.084	1	< 0.1%
0.081	2	< 0.1%
0.08	1	< 0.1%
0.079	1	< 0.1%
0.077	1	< 0.1%
0.074	3	< 0.1%
0.073	1	< 0.1%

no2
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	86
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.026707296

Minimum	0
Maximum	0.127
Zeros	378
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.005
Q1	0.016
median	0.025
Q3	0.037
95-th percentile	0.053
Maximum	0.127
Range	0.127
Interquartile range (IQR)	0.021

Descriptive statistics

Standard deviation	0.014824119
Coefficient of variation (CV)	0.55505878
Kurtosis	0.10474236
Mean	0.026707296
Median Absolute Deviation (MAD)	0.01
Skewness	0.48240878
Sum	242.342
Variance	0.0002197545
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	378	4.2%
0.022	268	3.0%
0.017	261	2.9%
0.016	241	2.7%
0.018	241	2.7%
0.023	240	2.6%
0.019	234	2.6%
0.029	232	2.6%
0.028	231	2.5%
0.024	229	2.5%
Other values (76)	6519	71.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	378	4.2%
0.001	11	0.1%
0.002	3	< 0.1%
0.003	5	0.1%
0.004	20	0.2%
0.005	39	0.4%
0.006	70	0.8%
0.007	102	1.1%
0.008	138	1.5%
0.009	177	2.0%

Value	Count	Frequency (%)
0.127	1	< 0.1%
0.095	1	< 0.1%
0.09	1	< 0.1%
0.085	1	< 0.1%
0.083	1	< 0.1%
0.08	2	< 0.1%
0.079	2	< 0.1%
0.078	2	< 0.1%
0.077	3	< 0.1%
0.076	2	< 0.1%

co
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	19
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.52013445

Minimum	0
Maximum	8
Zeros	378
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1
Q1	0.4
median	0.5
Q3	0.7
95-th percentile	1
Maximum	8
Range	8
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	0.2590182
Coefficient of variation (CV)	0.49798316
Kurtosis	76.785839
Mean	0.52013445
Median Absolute Deviation (MAD)	0.1
Skewness	3.0311672
Sum	4719.7
Variance	0.067090426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
0.5	1778	19.6%
0.4	1678	18.5%
0.6	1323	14.6%
0.3	1011	11.1%
0.7	856	9.4%
0.8	563	6.2%
0.2	518	5.7%
0.9	382	4.2%
0.0	378	4.2%
1.0	260	2.9%
Other values (9)	327	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	378	4.2%
0.1	84	0.9%
0.2	518	5.7%
0.3	1011	11.1%
0.4	1678	18.5%
0.5	1778	19.6%
0.6	1323	14.6%
0.7	856	9.4%
0.8	563	6.2%
0.9	382	4.2%

Value	Count	Frequency (%)
8.0	1	< 0.1%
1.7	1	< 0.1%
1.6	4	< 0.1%
1.5	6	0.1%
1.4	15	0.2%
1.3	31	0.3%
1.2	71	0.8%
1.1	114	1.3%
1.0	260	2.9%
0.9	382	4.2%

so2
Real number (ℝ)

ZEROS

Distinct	14
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0034059952

Minimum	0
Maximum	0.058
Zeros	372
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	79.9 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	0.0015207994
Coefficient of variation (CV)	0.44650662
Kurtosis	276.00498
Mean	0.0034059952
Median Absolute Deviation (MAD)	0.001
Skewness	8.3059305
Sum	30.906
Variance	2.3128308 × 10^-6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
0.003	3436	37.9%
0.004	2545	28.0%
0.002	1112	12.3%
0.005	977	10.8%
0.0	372	4.1%
0.006	362	4.0%
0.001	147	1.6%
0.007	106	1.2%
0.008	12	0.1%
0.009	1	< 0.1%
Other values (4)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	372	4.1%
0.001	147	1.6%
0.002	1112	12.3%
0.003	3436	37.9%
0.004	2545	28.0%
0.005	977	10.8%
0.006	362	4.0%
0.007	106	1.2%
0.008	12	0.1%
0.009	1	< 0.1%

Value	Count	Frequency (%)
0.058	1	< 0.1%
0.049	1	< 0.1%
0.025	1	< 0.1%
0.011	1	< 0.1%
0.009	1	< 0.1%
0.008	12	0.1%
0.007	106	1.2%
0.006	362	4.0%
0.005	977	10.8%
0.004	2545	28.0%

Heatmap
Table

	msrdt_de	msrrgn_cd	msrrgn_nm	msradm	msrste_nm	pm10	o3	no2	co	so2
msrdt_de	1.000	0.000	0.000	0.000	0.000	0.552	0.616	0.303	0.383	0.137
msrrgn_cd	0.000	1.000	1.000	1.000	1.000	0.078	0.239	0.312	0.017	0.019
msrrgn_nm	0.000	1.000	1.000	1.000	1.000	0.152	0.196	0.379	0.108	0.155
msradm	0.000	1.000	1.000	1.000	1.000	0.068	0.239	0.309	0.014	0.024
msrste_nm	0.000	1.000	1.000	1.000	1.000	0.250	0.343	0.522	0.270	0.532
pm10	0.552	0.078	0.152	0.068	0.250	1.000	0.337	0.424	0.392	0.109
o3	0.616	0.239	0.196	0.239	0.343	0.337	1.000	0.379	0.326	0.165
no2	0.303	0.312	0.379	0.309	0.522	0.424	0.379	1.000	0.401	0.119
co	0.383	0.017	0.108	0.014	0.270	0.392	0.326	0.401	1.000	0.648
so2	0.137	0.019	0.155	0.024	0.532	0.109	0.165	0.119	0.648	1.000

Heatmap
Table

	msrste_nm	msrrgn_nm
msrste_nm	1.000	0.999
msrrgn_nm	0.999	1.000

Heatmap
Table

	msrdt_de	msrrgn_cd	msradm	pm10	o3	no2	co	so2	msrrgn_nm	msrste_nm
msrdt_de	1.000	0.002	0.002	-0.301	-0.192	-0.096	-0.081	-0.210	0.000	0.000
msrrgn_cd	0.002	1.000	0.684	-0.118	0.171	-0.356	-0.109	-0.126	1.000	0.999
msradm	0.002	0.684	1.000	-0.065	0.088	-0.160	0.036	-0.147	1.000	0.999
pm10	-0.301	-0.118	-0.065	1.000	0.099	0.512	0.489	0.448	0.077	0.090
o3	-0.192	0.171	0.088	0.099	1.000	-0.313	-0.255	-0.036	0.100	0.128
no2	-0.096	-0.356	-0.160	0.512	-0.313	1.000	0.651	0.369	0.211	0.229
co	-0.081	-0.109	0.036	0.489	-0.255	0.651	1.000	0.372	0.061	0.133
so2	-0.210	-0.126	-0.147	0.448	-0.036	0.369	0.372	1.000	0.099	0.259
msrrgn_nm	0.000	1.000	1.000	0.077	0.100	0.211	0.061	0.099	1.000	0.999
msrste_nm	0.000	0.999	0.999	0.090	0.128	0.229	0.133	0.259	0.999	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

	msrdt_de	msrrgn_cd	msrrgn_nm	msradm	msrste_nm	pm10	o3	no2	co	so2
0	20201231	103	서남권	111232	영등포로	28	0.013	0.031	0.5	0.004
1	20201231	999	기타	555553	북한산	20	0.026	0.009	0.4	0.002
2	20201231	108	입체	111200	마포아트센터	25	0.022	0.02	0.7	0.005
3	20201231	999	기타	555554	관악산	27	0.024	0.014	0.2	0.003
4	20201231	102	동북권	111154	홍릉로	5	0.014	0.027	0.5	0.004
5	20201231	999	기타	555552	남산	21	0.022	0.013	0.3	0.003
6	20201231	102	동북권	111276	강변북로	28	0.016	0.026	0.9	0.004
7	20201231	103	서남권	111213	공항대로	33	0.016	0.025	0.4	0.003
8	20201231	999	기타	555550	궁동	26	0.016	0.02	0.4	0.003
9	20201231	102	동북권	111277	화랑로	30	0.01	0.027	0.3	0.003

	msrdt_de	msrrgn_cd	msrrgn_nm	msradm	msrste_nm	pm10	o3	no2	co	so2
9064	20200101	100	도심권	111122	한강대로	39	0.004	0.039	0.7	0.003
9065	20200101	999	기타	555553	북한산	33	0.004	0.032	0.8	0.004
9066	20200101	999	기타	555552	남산	36	0.004	0.045	0.9	0.004
9067	20200101	102	동북권	111277	화랑로	37	0.007	0.03	0.4	0.004
9068	20200101	104	동남권	111156	천호대로	37	0.004	0.037	0.6	0.003
9069	20200101	108	입체	111192	자연사박물관	30	0.0	0.0	0.0	0.0
9070	20200101	108	입체	111143	서울숲	32	0.003	0.042	0.6	0.004
9071	20200101	102	동북권	111162	정릉로	39	0.003	0.033	0.6	0.004
9072	20200101	103	서남권	111545	시흥대로	32	0.003	0.044	0.7	0.004
9073	20200101	999	기타	555554	관악산	24	0.017	0.016	0.6	0.004

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample