gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	46
Missing cells	12
Missing cells (%)	4.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 KiB
Average record size in memory	56.9 B

Variable types

Numeric	6

Dataset

Description	근로복지공단 소속병원 연도별 일반검진,특수검진,채용신검,보건관리대행,작업환경측정 현황 통계입니다. *1977년부터 2022년까지
URL	https://www.data.go.kr/data/15051522/fileData.do

Alerts

`년도` is highly overall correlated with `일반검진(명)` and 2 other fields	High correlation
`일반검진(명)` is highly overall correlated with `년도` and 2 other fields	High correlation
`채용신검(명)` is highly overall correlated with `년도` and 2 other fields	High correlation
`보건관리대행(명)` is highly overall correlated with `작업환경측정(개소)`	High correlation
`작업환경측정(개소)` is highly overall correlated with `년도` and 3 other fields	High correlation
`보건관리대행(명)` has 11 (23.9%) missing values	Missing
`작업환경측정(개소)` has 1 (2.2%) missing values	Missing
`년도` has unique values	Unique
`일반검진(명)` has unique values	Unique
`특수검진(명)` has unique values	Unique
`채용신검(명)` has unique values	Unique

Reproduction

Analysis started	2023-12-12 06:37:15.206101
Analysis finished	2023-12-12 06:37:19.355576
Duration	4.15 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

년도
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1999.5

Minimum	1977
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	1977
5-th percentile	1979.25
Q1	1988.25
median	1999.5
Q3	2010.75
95-th percentile	2019.75
Maximum	2022
Range	45
Interquartile range (IQR)	22.5

Descriptive statistics

Standard deviation	13.422618
Coefficient of variation (CV)	0.0067129871
Kurtosis	-1.2
Mean	1999.5
Median Absolute Deviation (MAD)	11.5
Skewness	0
Sum	91977
Variance	180.16667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
1977	1	2.2%
2012	1	2.2%
2003	1	2.2%
2004	1	2.2%
2005	1	2.2%
2006	1	2.2%
2007	1	2.2%
2008	1	2.2%
2009	1	2.2%
2010	1	2.2%
Other values (36)	36	78.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1977	1	2.2%
1978	1	2.2%
1979	1	2.2%
1980	1	2.2%
1981	1	2.2%
1982	1	2.2%
1983	1	2.2%
1984	1	2.2%
1985	1	2.2%
1986	1	2.2%

Value	Count	Frequency (%)
2022	1	2.2%
2021	1	2.2%
2020	1	2.2%
2019	1	2.2%
2018	1	2.2%
2017	1	2.2%
2016	1	2.2%
2015	1	2.2%
2014	1	2.2%
2013	1	2.2%

일반검진(명)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127056.43

Minimum	3399
Maximum	247829
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	3399
5-th percentile	13784.5
Q1	59502.75
median	146528
Q3	184193.75
95-th percentile	214361.75
Maximum	247829
Range	244430
Interquartile range (IQR)	124691

Descriptive statistics

Standard deviation	70129.064
Coefficient of variation (CV)	0.55195208
Kurtosis	-1.2321859
Mean	127056.43
Median Absolute Deviation (MAD)	62209
Skewness	-0.22843879
Sum	5844596
Variance	4.9180856 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
3399	1	2.2%
186004	1	2.2%
167575	1	2.2%
168124	1	2.2%
178763	1	2.2%
225156	1	2.2%
215220	1	2.2%
247829	1	2.2%
211787	1	2.2%
195129	1	2.2%
Other values (36)	36	78.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3399	1	2.2%
3495	1	2.2%
10708	1	2.2%
23014	1	2.2%
23836	1	2.2%
35311	1	2.2%
48257	1	2.2%
51377	1	2.2%
51979	1	2.2%
54861	1	2.2%

Value	Count	Frequency (%)
247829	1	2.2%
225156	1	2.2%
215220	1	2.2%
211787	1	2.2%
209373	1	2.2%
209205	1	2.2%
208841	1	2.2%
208780	1	2.2%
201189	1	2.2%
200457	1	2.2%

특수검진(명)
Real number (ℝ)

UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	81482.978

Minimum	8640
Maximum	128637
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	8640
5-th percentile	12932.25
Q1	70313.5
median	85913.5
Q3	103729.5
95-th percentile	122007.5
Maximum	128637
Range	119997
Interquartile range (IQR)	33416

Descriptive statistics

Standard deviation	31385.769
Coefficient of variation (CV)	0.3851819
Kurtosis	0.33152937
Mean	81482.978
Median Absolute Deviation (MAD)	17802.5
Skewness	-0.91671266
Sum	3748217
Variance	9.8506648 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
8640	1	2.2%
80676	1	2.2%
65490	1	2.2%
72152	1	2.2%
70184	1	2.2%
80024	1	2.2%
81745	1	2.2%
91101	1	2.2%
79644	1	2.2%
81392	1	2.2%
Other values (36)	36	78.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8640	1	2.2%
10275	1	2.2%
10935	1	2.2%
18924	1	2.2%
24995	1	2.2%
25568	1	2.2%
51762	1	2.2%
56429	1	2.2%
63092	1	2.2%
64672	1	2.2%

Value	Count	Frequency (%)
128637	1	2.2%
126517	1	2.2%
124068	1	2.2%
115826	1	2.2%
115185	1	2.2%
114670	1	2.2%
112505	1	2.2%
110643	1	2.2%
107938	1	2.2%
104832	1	2.2%

채용신검(명)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	46
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	38659.565

Minimum	1817
Maximum	78630
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	1817
5-th percentile	6053.5
Q1	20361
median	35477
Q3	57895.25
95-th percentile	74686.5
Maximum	78630
Range	76813
Interquartile range (IQR)	37534.25

Descriptive statistics

Standard deviation	22271.403
Coefficient of variation (CV)	0.57609036
Kurtosis	-1.145885
Mean	38659.565
Median Absolute Deviation (MAD)	17798
Skewness	0.17632913
Sum	1778340
Variance	4.9601538 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
1817	1	2.2%
58523	1	2.2%
48701	1	2.2%
55130	1	2.2%
56012	1	2.2%
42199	1	2.2%
44345	1	2.2%
50492	1	2.2%
47349	1	2.2%
60375	1	2.2%
Other values (36)	36	78.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1817	1	2.2%
4381	1	2.2%
5049	1	2.2%
9067	1	2.2%
9911	1	2.2%
11057	1	2.2%
13907	1	2.2%
15134	1	2.2%
18454	1	2.2%
18456	1	2.2%

Value	Count	Frequency (%)
78630	1	2.2%
75412	1	2.2%
74852	1	2.2%
74190	1	2.2%
71210	1	2.2%
68037	1	2.2%
67912	1	2.2%
65505	1	2.2%
60375	1	2.2%
60316	1	2.2%

보건관리대행(명)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	35
Distinct (%)	100.0%
Missing	11
Missing (%)	23.9%
Infinite	0
Infinite (%)	0.0%
Mean	59093.2

Minimum	321
Maximum	70305
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	321
5-th percentile	28172.1
Q1	57450.5
median	64716
Q3	67911
95-th percentile	69258.9
Maximum	70305
Range	69984
Interquartile range (IQR)	10460.5

Descriptive statistics

Standard deviation	14547.118
Coefficient of variation (CV)	0.24617245
Kurtosis	8.1255056
Mean	59093.2
Median Absolute Deviation (MAD)	4076
Skewness	-2.6931735
Sum	2068262
Variance	2.1161864 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=35)

Value	Count	Frequency (%)
22185	1	2.2%
68792	1	2.2%
65686	1	2.2%
67772	1	2.2%
67244	1	2.2%
68681	1	2.2%
66197	1	2.2%
64716	1	2.2%
67508	1	2.2%
58365	1	2.2%
Other values (25)	25	54.3%
(Missing)	11	23.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
321	1	2.2%
22185	1	2.2%
30738	1	2.2%
49726	1	2.2%
50316	1	2.2%
53911	1	2.2%
55337	1	2.2%
55824	1	2.2%
56936	1	2.2%
57965	1	2.2%

Value	Count	Frequency (%)
70305	1	2.2%
70290	1	2.2%
68817	1	2.2%
68792	1	2.2%
68681	1	2.2%
68459	1	2.2%
68408	1	2.2%
68350	1	2.2%
68050	1	2.2%
67772	1	2.2%

작업환경측정(개소)
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	45
Distinct (%)	100.0%
Missing	1
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%
Mean	2691.4

Minimum	12
Maximum	4228
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	546.0 B

Quantile statistics

Minimum	12
5-th percentile	62.2
Q1	1532
median	3547
Q3	3774
95-th percentile	4048
Maximum	4228
Range	4216
Interquartile range (IQR)	2242

Descriptive statistics

Standard deviation	1483.2859
Coefficient of variation (CV)	0.55112056
Kurtosis	-0.88890399
Mean	2691.4
Median Absolute Deviation (MAD)	378
Skewness	-0.89740685
Sum	121113
Variance	2200137
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=45)

Value	Count	Frequency (%)
12	1	2.2%
3809	1	2.2%
4062	1	2.2%
4228	1	2.2%
3798	1	2.2%
3642	1	2.2%
3756	1	2.2%
3774	1	2.2%
3677	1	2.2%
3754	1	2.2%
Other values (35)	35	76.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	1	2.2%
34	1	2.2%
58	1	2.2%
79	1	2.2%
86	1	2.2%
304	1	2.2%
348	1	2.2%
395	1	2.2%
448	1	2.2%
511	1	2.2%

Value	Count	Frequency (%)
4228	1	2.2%
4072	1	2.2%
4062	1	2.2%
3992	1	2.2%
3925	1	2.2%
3900	1	2.2%
3849	1	2.2%
3847	1	2.2%
3838	1	2.2%
3809	1	2.2%

Phik (φk)
Auto

Heatmap
Table

	년도	일반검진(명)	특수검진(명)	채용신검(명)	보건관리대행(명)	작업환경측정(개소)
년도	1.000	0.907	0.726	0.886	0.814	0.781
일반검진(명)	0.907	1.000	0.772	0.739	0.836	0.749
특수검진(명)	0.726	0.772	1.000	0.576	0.560	0.696
채용신검(명)	0.886	0.739	0.576	1.000	0.461	0.622
보건관리대행(명)	0.814	0.836	0.560	0.461	1.000	0.760
작업환경측정(개소)	0.781	0.749	0.696	0.622	0.760	1.000

Heatmap
Table

	년도	일반검진(명)	특수검진(명)	채용신검(명)	보건관리대행(명)	작업환경측정(개소)
년도	1.000	0.837	0.359	0.962	-0.140	0.513
일반검진(명)	0.837	1.000	0.237	0.852	0.329	0.680
특수검진(명)	0.359	0.237	1.000	0.332	-0.086	0.148
채용신검(명)	0.962	0.852	0.332	1.000	-0.051	0.594
보건관리대행(명)	-0.140	0.329	-0.086	-0.051	1.000	0.549
작업환경측정(개소)	0.513	0.680	0.148	0.594	0.549	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

	년도	일반검진(명)	특수검진(명)	채용신검(명)	보건관리대행(명)	작업환경측정(개소)
0	1977	3399	8640	1817	<NA>	<NA>
1	1978	3495	10275	4381	<NA>	12
2	1979	10708	10935	5049	<NA>	34
3	1980	23014	24995	15134	<NA>	79
4	1981	23836	18924	9911	<NA>	86
5	1982	35311	25568	9067	<NA>	58
6	1983	56509	51762	11057	<NA>	348
7	1984	54861	63092	18454	<NA>	448
8	1985	51979	74832	13907	<NA>	304
9	1986	60150	76004	20874	<NA>	395

	년도	일반검진(명)	특수검진(명)	채용신검(명)	보건관리대행(명)	작업환경측정(개소)
36	2013	201189	81416	78630	66197	3925
37	2014	209373	91773	74852	64716	3692
38	2015	208780	103689	74190	67508	3707
39	2016	209205	112505	68037	58365	3589
40	2017	200457	104832	59289	56936	3426
41	2018	163512	104601	75412	55824	3072
42	2019	165643	98325	71210	55337	2638
43	2020	145260	88100	54050	53911	2487
44	2021	154048	98299	67912	50316	2427
45	2022	151960	97294	65505	49726	2447

Overview

Variables

Interactions

Correlations

Missing values

Sample