gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	85
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.7 KiB
Average record size in memory	80.6 B

Variable types

DateTime	1
Categorical	7
Numeric	1

Dataset

Description	국내 가스종류(LPG, 도시가스)별, 원인(취급부주의, 시설미비, 제품노흐 가스누출, 자연재해, 아차사고 등 12개)별, 월별 가스사고 현황에 대한 데이터로가스사고 통계 자료등으로 활용가능한 데이터입니다.
Author	한국가스안전공사
URL	https://www.data.go.kr/data/15067796/fileData.do

Alerts

`교통사고` is highly imbalanced (78.0%)	Imbalance
`사용자취급부주의` has 43 (50.6%) zeros	Zeros

Reproduction

Analysis started	2023-12-12 17:44:02.830149
Analysis finished	2023-12-12 17:44:03.761335
Duration	0.93 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

사고연월
Date

Distinct	31
Distinct (%)	36.5%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

Minimum	2021-01-01 00:00:00
Maximum	2023-08-01 00:00:00

Histogram

Histogram with fixed size bins (bins=31)

가스구분
Categorical

Distinct	4
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

LPG	28
이동식부탄연소기(접합용기)	20
도시가스	19
고압가스	18

Length

Max length	14
Median length	4
Mean length	6.0235294
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	LPG
2nd row	도시가스
3rd row	이동식부탄연소기(접합용기)
4th row	고압가스
5th row	LPG

Common Values

Value	Count	Frequency (%)
LPG	28	32.9%
이동식부탄연소기(접합용기)	20	23.5%
도시가스	19	22.4%
고압가스	18	21.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
lpg	28	32.9%
이동식부탄연소기(접합용기	20	23.5%
도시가스	19	22.4%
고압가스	18	21.2%

공급자취급부주의
Categorical

Distinct	3
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	69
1	14
2	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	69	81.2%
1	14	16.5%
2	2	2.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	69	81.2%
1	14	16.5%
2	2	2.4%

기타(1-3급)
Categorical

Distinct	3
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	66
1	18
2	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	1 ?
Unique (%)	1.2%

Sample

1st row	1
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	66	77.6%
1	18	21.2%
2	1	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	66	77.6%
1	18	21.2%
2	1	1.2%

사용자취급부주의
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.69411765

Minimum	0
Maximum	5
Zeros	43
Zeros (%)	50.6%
Negative	0
Negative (%)	0.0%
Memory size	897.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.92612261
Coefficient of variation (CV)	1.3342444
Kurtosis	6.0145013
Mean	0.69411765
Median Absolute Deviation (MAD)	0
Skewness	2.0343428
Sum	59
Variance	0.85770308
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	43	50.6%
1	31	36.5%
2	8	9.4%
3	1	1.2%
5	1	1.2%
4	1	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	43	50.6%
1	31	36.5%
2	8	9.4%
3	1	1.2%
4	1	1.2%
5	1	1.2%

Value	Count	Frequency (%)
5	1	1.2%
4	1	1.2%
3	1	1.2%
2	8	9.4%
1	31	36.5%
0	43	50.6%

시설미비
Categorical

Distinct	4
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	61
1	14
2	7
3	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	3

Common Values

Value	Count	Frequency (%)
0	61	71.8%
1	14	16.5%
2	7	8.2%
3	3	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	61	71.8%
1	14	16.5%
2	7	8.2%
3	3	3.5%

제품노후(고장)
Categorical

Distinct	4
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	59
1	20
2	5
3	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	1 ?
Unique (%)	1.2%

Sample

1st row	2
2nd row	1
3rd row	0
4th row	1
5th row	2

Common Values

Value	Count	Frequency (%)
0	59	69.4%
1	20	23.5%
2	5	5.9%
3	1	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	59	69.4%
1	20	23.5%
2	5	5.9%
3	1	1.2%

타공사
Categorical

Distinct	3
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	69
1	13
2	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	69	81.2%
1	13	15.3%
2	3	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	69	81.2%
1	13	15.3%
2	3	3.5%

교통사고
Categorical

IMBALANCE

Distinct	2
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	812.0 B

0	82
1	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	82	96.5%
1	3	3.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	82	96.5%
1	3	3.5%

사용자취급부주의

사용자취급부주의

Heatmap
Table

	사고연월	가스구분	공급자취급부주의	기타(1-3급)	사용자취급부주의	시설미비	제품노후(고장)	타공사	교통사고
사고연월	1.000	0.000	0.338	0.000	0.516	0.000	0.000	0.000	0.521
가스구분	0.000	1.000	0.212	0.000	0.457	0.533	0.418	0.396	0.201
공급자취급부주의	0.338	0.212	1.000	0.000	0.000	0.000	0.000	0.289	0.000
기타(1-3급)	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000
사용자취급부주의	0.516	0.457	0.000	0.000	1.000	0.000	0.331	0.000	0.000
시설미비	0.000	0.533	0.000	0.000	0.000	1.000	0.481	0.000	0.000
제품노후(고장)	0.000	0.418	0.000	0.000	0.331	0.481	1.000	0.101	0.000
타공사	0.000	0.396	0.289	0.000	0.000	0.000	0.101	1.000	0.000
교통사고	0.521	0.201	0.000	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

	공급자취급부주의	시설미비	가스구분	제품노후(고장)	교통사고	타공사	기타(1-3급)
공급자취급부주의	1.000	0.000	0.199	0.000	0.000	0.095	0.000
시설미비	0.000	1.000	0.230	0.203	0.000	0.000	0.000
가스구분	0.199	0.230	1.000	0.172	0.130	0.384	0.000
제품노후(고장)	0.000	0.203	0.172	1.000	0.000	0.092	0.000
교통사고	0.000	0.000	0.130	0.000	1.000	0.000	0.000
타공사	0.095	0.000	0.384	0.092	0.000	1.000	0.000
기타(1-3급)	0.000	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

	사용자취급부주의	가스구분	공급자취급부주의	기타(1-3급)	시설미비	제품노후(고장)	타공사	교통사고
사용자취급부주의	1.000	0.306	0.000	0.000	0.000	0.214	0.000	0.000
가스구분	0.306	1.000	0.199	0.000	0.230	0.172	0.384	0.130
공급자취급부주의	0.000	0.199	1.000	0.000	0.000	0.000	0.095	0.000
기타(1-3급)	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000
시설미비	0.000	0.230	0.000	0.000	1.000	0.203	0.000	0.000
제품노후(고장)	0.214	0.172	0.000	0.000	0.203	1.000	0.092	0.000
타공사	0.000	0.384	0.095	0.000	0.000	0.092	1.000	0.000
교통사고	0.000	0.130	0.000	0.000	0.000	0.000	0.000	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

	사고연월	가스구분	기타(1-3급)	사용자취급부주의	시설미비	제품노후(고장)	타공사
0	2021-01	LPG	1	3	0	2	0
1	2021-01	도시가스	1	0	0	1	1
2	2021-01	이동식부탄연소기(접합용기)	0	5	0	0	0
3	2021-01	고압가스	0	0	0	1	0
4	2021-02	LPG	0	0	3	2	0
5	2021-02	도시가스	0	0	0	0	2
6	2021-02	이동식부탄연소기(접합용기)	0	1	0	0	0
7	2021-03	LPG	0	0	0	1	1
8	2021-03	도시가스	0	0	2	0	0
9	2021-03	이동식부탄연소기(접합용기)	0	1	0	0	0

	사고연월	가스구분	공급자취급부주의	기타(1-3급)	사용자취급부주의	시설미비
75	2023-05	LPG	1	0	0	0
76	2023-05	도시가스	0	1	1	0
77	2023-05	고압가스	0	0	1	0
78	2023-06	고압가스	0	0	1	1
79	2023-07	LPG	0	0	0	1
80	2023-07	도시가스	0	0	0	2
81	2023-07	고압가스	0	1	0	1
82	2023-07	이동식부탄연소기(접합용기)	0	0	1	0
83	2023-08	LPG	1	0	1	0
84	2023-08	고압가스	0	0	1	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample