Overview

Dataset statistics

Number of variables3
Number of observations70
Missing cells3
Missing cells (%)1.4%
Duplicate rows2
Duplicate rows (%)2.9%
Total size in memory1.8 KiB
Average record size in memory26.9 B

Variable types

Categorical1
Numeric1
DateTime1

Dataset

Description석탄합리화정책에 따라 대한석탄공사 산하 화순광업소는 23년 6월 기준 폐광 후 갱내수 배수를 위한 펌프를 유지하고 있으며, 이를 위한 변압기를 설치하여 운영하고 있습니다.현재 유지되고 있는 (구)화순광업소의 변압기 설치 현황을 나타내는 데이터입니다.
Author대한석탄공사
URLhttps://www.data.go.kr/data/15124495/fileData.do

Alerts

Dataset has 2 (2.9%) duplicate rowsDuplicates
제조년월 has 3 (4.3%) missing valuesMissing

Reproduction

Analysis started2023-12-12 04:21:51.145680
Analysis finished2023-12-12 04:21:51.637866
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

설치 장소
Categorical

Distinct34
Distinct (%)48.6%
Missing0
Missing (%)0.0%
Memory size692.0 B
동1사갱8편 컨베어사갱
 
5
변전소
 
4
컨베이어 배전실
 
4
동1사갱 권양기실
 
3
동3사 권양기실
 
3
Other values (29)
51 

Length

Max length12
Median length10
Mean length8.1714286
Min length3

Unique

Unique12 ?
Unique (%)17.1%

Sample

1st row동1사갱 권양기실
2nd row동1사갱 권양기실
3rd row동1사갱 권양기실
4th row동1사갱 5편사갱
5th row동1사갱 8편권립

Common Values

ValueCountFrequency (%)
동1사갱8편 컨베어사갱 5
 
7.1%
변전소 4
 
5.7%
컨베이어 배전실 4
 
5.7%
동1사갱 권양기실 3
 
4.3%
동3사 권양기실 3
 
4.3%
경석 선별장 3
 
4.3%
동3사16편 충전실 3
 
4.3%
공무 현장 3
 
4.3%
동2사12편 충전실 3
 
4.3%
동2사13편 적하시설 3
 
4.3%
Other values (24) 36
51.4%

Length

2023-12-12T13:21:51.734594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
권양기실 14
 
11.1%
충전실 13
 
10.3%
동1사갱8편 5
 
4.0%
동1사갱 5
 
4.0%
컨베어사갱 5
 
4.0%
변전소 4
 
3.2%
컨베이어 4
 
3.2%
배전실 4
 
3.2%
복암2사갱 4
 
3.2%
동2사13편 4
 
3.2%
Other values (34) 64
50.8%

규격(KVA)
Real number (ℝ)

Distinct16
Distinct (%)22.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean524
Minimum10
Maximum5000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size762.0 B
2023-12-12T13:21:51.867253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile10
Q1150
median250
Q3300
95-th percentile2925
Maximum5000
Range4990
Interquartile range (IQR)150

Descriptive statistics

Standard deviation1071.8471
Coefficient of variation (CV)2.0455098
Kurtosis12.482848
Mean524
Median Absolute Deviation (MAD)100
Skewness3.664567
Sum36680
Variance1148856.2
MonotonicityNot monotonic
2023-12-12T13:21:52.005179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
250 21
30.0%
200 10
14.3%
50 8
 
11.4%
10 5
 
7.1%
800 4
 
5.7%
300 3
 
4.3%
100 3
 
4.3%
500 3
 
4.3%
150 2
 
2.9%
5000 2
 
2.9%
Other values (6) 9
12.9%
ValueCountFrequency (%)
10 5
 
7.1%
30 1
 
1.4%
50 8
 
11.4%
100 3
 
4.3%
150 2
 
2.9%
200 10
14.3%
250 21
30.0%
300 3
 
4.3%
400 2
 
2.9%
500 3
 
4.3%
ValueCountFrequency (%)
5000 2
 
2.9%
4500 2
 
2.9%
1000 1
 
1.4%
800 4
 
5.7%
750 1
 
1.4%
600 2
 
2.9%
500 3
 
4.3%
400 2
 
2.9%
300 3
 
4.3%
250 21
30.0%

제조년월
Date

MISSING 

Distinct47
Distinct (%)70.1%
Missing3
Missing (%)4.3%
Memory size692.0 B
Minimum1905-06-01 00:00:00
Maximum2022-03-01 00:00:00
2023-12-12T13:21:52.152363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:21:52.308455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=47)

Interactions

2023-12-12T13:21:51.342320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:21:52.441757image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설치 장소규격(KVA)제조년월
설치 장소1.0000.4330.834
규격(KVA)0.4331.0000.000
제조년월0.8340.0001.000
2023-12-12T13:21:52.552866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
규격(KVA)설치 장소
규격(KVA)1.0000.153
설치 장소0.1531.000

Missing values

2023-12-12T13:21:51.491952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:21:51.597366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

설치 장소규격(KVA)제조년월
0동1사갱 권양기실101981-08
1동1사갱 권양기실501985-12
2동1사갱 권양기실5001905-06
3동1사갱 5편사갱501987-08
4동1사갱 8편권립2502019-07
5동1사갱8편 컨베어사갱2502004-12
6동1사갱8편 컨베어사갱2502015-09
7동1사갱8편 컨베어사갱501983-07
8동1사갱8편 컨베어사갱301986-10
9동1사갱8편 컨베어사갱10<NA>
설치 장소규격(KVA)제조년월
60연탄공장2502005-09
61복암 경석장2002014-10
62복암1사갱 권양기실8001905-06
63복암1사갱 권양기실501905-06
64복암2사갱 권양기실8002004-04
65복암2사갱 권양기실502003-08
66복암2사갱 17편2502021-06
67복암2사갱 17편2502021-06
68복암3사갱 권양기실8002015-11
69복암3사갱 권양기실502007-05

Duplicate rows

Most frequently occurring

설치 장소규격(KVA)제조년월# duplicates
0동2사13편 적하시설2502018-082
1복암2사갱 17편2502021-062