Overview

Dataset statistics

Number of variables7
Number of observations1749
Missing cells293
Missing cells (%)2.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory102.6 KiB
Average record size in memory60.1 B

Variable types

Numeric4
Categorical3

Dataset

Description연도,지역이름,정신건강증진시설 분류코드,정신건강증진시설 분류,정신재활시설 코드,정신재활시설 분류,정신건강증진시설 수
Author서울시정신건강복지센터
URLhttps://data.seoul.go.kr/dataList/OA-20328/S/1/datasetView.do

Alerts

정신재활시설 분류 is highly overall correlated with 정신건강증진시설 분류코드 and 2 other fieldsHigh correlation
정신건강증진시설 분류 is highly overall correlated with 정신건강증진시설 분류코드 and 2 other fieldsHigh correlation
정신건강증진시설 분류코드 is highly overall correlated with 정신재활시설 코드 and 2 other fieldsHigh correlation
정신재활시설 코드 is highly overall correlated with 정신건강증진시설 분류코드 and 2 other fieldsHigh correlation
정신건강증진시설 수 has 293 (16.8%) missing valuesMissing
정신건강증진시설 수 has 958 (54.8%) zerosZeros

Reproduction

Analysis started2024-05-04 01:29:27.217932
Analysis finished2024-05-04 01:29:33.628014
Duration6.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Real number (ℝ)

Distinct6
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2019.4717
Minimum2017
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.5 KiB
2024-05-04T01:29:33.800458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2017
5-th percentile2017
Q12018
median2019
Q32021
95-th percentile2022
Maximum2022
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.708079
Coefficient of variation (CV)0.00084580486
Kurtosis-1.267766
Mean2019.4717
Median Absolute Deviation (MAD)1
Skewness0.025591439
Sum3532056
Variance2.9175338
MonotonicityDecreasing
2024-05-04T01:29:34.171410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2019 297
17.0%
2018 297
17.0%
2017 297
17.0%
2022 286
16.4%
2021 286
16.4%
2020 286
16.4%
ValueCountFrequency (%)
2017 297
17.0%
2018 297
17.0%
2019 297
17.0%
2020 286
16.4%
2021 286
16.4%
2022 286
16.4%
ValueCountFrequency (%)
2022 286
16.4%
2021 286
16.4%
2020 286
16.4%
2019 297
17.0%
2018 297
17.0%
2017 297
17.0%

지역이름
Categorical

Distinct27
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size13.8 KiB
구로구
 
66
서초구
 
66
관악구
 
66
송파구
 
66
동작구
 
66
Other values (22)
1419 

Length

Max length11
Median length10
Mean length9.6792453
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row 구로구
2nd row 서초구
3rd row 서초구
4th row 관악구
5th row 송파구

Common Values

ValueCountFrequency (%)
구로구 66
 
3.8%
서초구 66
 
3.8%
관악구 66
 
3.8%
송파구 66
 
3.8%
동작구 66
 
3.8%
서울시 66
 
3.8%
영등포구 66
 
3.8%
금천구 66
 
3.8%
강남구 66
 
3.8%
서대문구 66
 
3.8%
Other values (17) 1089
62.3%

Length

2024-05-04T01:29:34.626501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
구로구 66
 
3.8%
중랑구 66
 
3.8%
광진구 66
 
3.8%
강동구 66
 
3.8%
노원구 66
 
3.8%
강서구 66
 
3.8%
양천구 66
 
3.8%
마포구 66
 
3.8%
성동구 66
 
3.8%
용산구 66
 
3.8%
Other values (17) 1089
62.3%

정신건강증진시설 분류코드
Real number (ℝ)

HIGH CORRELATION 

Distinct7
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11404.364
Minimum11401
Maximum11407
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.5 KiB
2024-05-04T01:29:34.970542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11401
5-th percentile11401
Q111403
median11405
Q311405
95-th percentile11407
Maximum11407
Range6
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.6668678
Coefficient of variation (CV)0.00014616052
Kurtosis-0.41591424
Mean11404.364
Median Absolute Deviation (MAD)1
Skewness-0.5869641
Sum19946232
Variance2.7784481
MonotonicityNot monotonic
2024-05-04T01:29:35.315383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
11405 795
45.5%
11401 159
 
9.1%
11407 159
 
9.1%
11403 159
 
9.1%
11406 159
 
9.1%
11402 159
 
9.1%
11404 159
 
9.1%
ValueCountFrequency (%)
11401 159
 
9.1%
11402 159
 
9.1%
11403 159
 
9.1%
11404 159
 
9.1%
11405 795
45.5%
11406 159
 
9.1%
11407 159
 
9.1%
ValueCountFrequency (%)
11407 159
 
9.1%
11406 159
 
9.1%
11405 795
45.5%
11404 159
 
9.1%
11403 159
 
9.1%
11402 159
 
9.1%
11401 159
 
9.1%

정신건강증진시설 분류
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size13.8 KiB
재활훈련시설
795 
광역형 정신건강복지센터
159 
종합시설
159 
정신건강복지센터
159 
중독자재활시설
159 
Other values (2)
318 

Length

Max length12
Median length6
Mean length7
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row재활훈련시설
2nd row재활훈련시설
3rd row재활훈련시설
4th row재활훈련시설
5th row광역형 정신건강복지센터

Common Values

ValueCountFrequency (%)
재활훈련시설 795
45.5%
광역형 정신건강복지센터 159
 
9.1%
종합시설 159
 
9.1%
정신건강복지센터 159
 
9.1%
중독자재활시설 159
 
9.1%
자살예방센터 159
 
9.1%
중독관리통합지원센터 159
 
9.1%

Length

2024-05-04T01:29:35.843383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T01:29:36.248765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
재활훈련시설 795
41.7%
정신건강복지센터 318
 
16.7%
광역형 159
 
8.3%
종합시설 159
 
8.3%
중독자재활시설 159
 
8.3%
자살예방센터 159
 
8.3%
중독관리통합지원센터 159
 
8.3%

정신재활시설 코드
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1140438.3
Minimum1140101
Maximum1140701
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size15.5 KiB
2024-05-04T01:29:36.621527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1140101
5-th percentile1140101
Q11140301
median1140502
Q31140505
95-th percentile1140701
Maximum1140701
Range600
Interquartile range (IQR)204

Descriptive statistics

Standard deviation167.03937
Coefficient of variation (CV)0.00014646945
Kurtosis-0.4235599
Mean1140438.3
Median Absolute Deviation (MAD)99
Skewness-0.59711336
Sum1.9946265 × 109
Variance27902.152
MonotonicityNot monotonic
2024-05-04T01:29:36.970503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
1140504 159
9.1%
1140501 159
9.1%
1140505 159
9.1%
1140101 159
9.1%
1140503 159
9.1%
1140701 159
9.1%
1140301 159
9.1%
1140601 159
9.1%
1140201 159
9.1%
1140502 159
9.1%
ValueCountFrequency (%)
1140101 159
9.1%
1140201 159
9.1%
1140301 159
9.1%
1140401 159
9.1%
1140501 159
9.1%
1140502 159
9.1%
1140503 159
9.1%
1140504 159
9.1%
1140505 159
9.1%
1140601 159
9.1%
ValueCountFrequency (%)
1140701 159
9.1%
1140601 159
9.1%
1140505 159
9.1%
1140504 159
9.1%
1140503 159
9.1%
1140502 159
9.1%
1140501 159
9.1%
1140401 159
9.1%
1140301 159
9.1%
1140201 159
9.1%

정신재활시설 분류
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size13.8 KiB
지역사회전환시설
159 
주간재활시설
159 
공동생활가정
159 
광역형 정신건강복지센터
159 
아동청소년정신건강지원시설
159 
Other values (6)
954 

Length

Max length13
Median length12
Mean length7.8181818
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row지역사회전환시설
2nd row지역사회전환시설
3rd row주간재활시설
4th row공동생활가정
5th row광역형 정신건강복지센터

Common Values

ValueCountFrequency (%)
지역사회전환시설 159
9.1%
주간재활시설 159
9.1%
공동생활가정 159
9.1%
광역형 정신건강복지센터 159
9.1%
아동청소년정신건강지원시설 159
9.1%
종합시설 159
9.1%
정신건강복지센터 159
9.1%
중독자재활시설 159
9.1%
자살예방센터 159
9.1%
직업재활시설 159
9.1%

Length

2024-05-04T01:29:37.345680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
정신건강복지센터 318
16.7%
지역사회전환시설 159
8.3%
주간재활시설 159
8.3%
공동생활가정 159
8.3%
광역형 159
8.3%
아동청소년정신건강지원시설 159
8.3%
종합시설 159
8.3%
중독자재활시설 159
8.3%
자살예방센터 159
8.3%
직업재활시설 159
8.3%

정신건강증진시설 수
Real number (ℝ)

MISSING  ZEROS 

Distinct19
Distinct (%)1.3%
Missing293
Missing (%)16.8%
Infinite0
Infinite (%)0.0%
Mean0.89697802
Minimum0
Maximum56
Zeros958
Zeros (%)54.8%
Negative0
Negative (%)0.0%
Memory size15.5 KiB
2024-05-04T01:29:37.655128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile3.25
Maximum56
Range56
Interquartile range (IQR)1

Descriptive statistics

Standard deviation3.825987
Coefficient of variation (CV)4.2654189
Kurtosis127.64362
Mean0.89697802
Median Absolute Deviation (MAD)0
Skewness10.472596
Sum1306
Variance14.638176
MonotonicityNot monotonic
2024-05-04T01:29:38.003907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
0 958
54.8%
1 364
 
20.8%
2 50
 
2.9%
4 28
 
1.6%
5 13
 
0.7%
3 11
 
0.6%
6 8
 
0.5%
25 8
 
0.5%
7 4
 
0.2%
10 2
 
0.1%
Other values (9) 10
 
0.6%
(Missing) 293
 
16.8%
ValueCountFrequency (%)
0 958
54.8%
1 364
 
20.8%
2 50
 
2.9%
3 11
 
0.6%
4 28
 
1.6%
5 13
 
0.7%
6 8
 
0.5%
7 4
 
0.2%
8 1
 
0.1%
9 2
 
0.1%
ValueCountFrequency (%)
56 1
 
0.1%
55 1
 
0.1%
53 1
 
0.1%
51 1
 
0.1%
50 1
 
0.1%
27 1
 
0.1%
25 8
0.5%
18 1
 
0.1%
10 2
 
0.1%
9 2
 
0.1%

Interactions

2024-05-04T01:29:31.618078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:27.850750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:28.994272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:30.351302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:32.110956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:28.129902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:29.281544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:30.696794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:32.392152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:28.428743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:29.643905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:30.994702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:32.688211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:28.709618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:29.978247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T01:29:31.322485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-04T01:29:38.281577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도지역이름정신건강증진시설 분류코드정신건강증진시설 분류정신재활시설 코드정신재활시설 분류정신건강증진시설 수
연도1.0000.0000.0000.0000.0000.0000.000
지역이름0.0001.0000.0000.0000.0000.0000.506
정신건강증진시설 분류코드0.0000.0001.0001.0001.0001.0000.153
정신건강증진시설 분류0.0000.0001.0001.0001.0001.0000.096
정신재활시설 코드0.0000.0001.0001.0001.0001.0000.153
정신재활시설 분류0.0000.0001.0001.0001.0001.0000.226
정신건강증진시설 수0.0000.5060.1530.0960.1530.2261.000
2024-05-04T01:29:38.639896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역이름정신재활시설 분류정신건강증진시설 분류
지역이름1.0000.0000.000
정신재활시설 분류0.0001.0000.999
정신건강증진시설 분류0.0000.9991.000
2024-05-04T01:29:38.982917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도정신건강증진시설 분류코드정신재활시설 코드정신건강증진시설 수지역이름정신건강증진시설 분류정신재활시설 분류
연도1.0000.0000.0000.0070.0000.0000.000
정신건강증진시설 분류코드0.0001.0000.953-0.0020.0001.0000.999
정신재활시설 코드0.0000.9531.000-0.0000.0001.0000.999
정신건강증진시설 수0.007-0.002-0.0001.0000.2470.0570.117
지역이름0.0000.0000.0000.2471.0000.0000.000
정신건강증진시설 분류0.0001.0001.0000.0570.0001.0000.999
정신재활시설 분류0.0000.9990.9990.1170.0000.9991.000

Missing values

2024-05-04T01:29:33.056896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-04T01:29:33.462753image/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

연도지역이름정신건강증진시설 분류코드정신건강증진시설 분류정신재활시설 코드정신재활시설 분류정신건강증진시설 수
02022구로구11405재활훈련시설1140504지역사회전환시설<NA>
12022서초구11405재활훈련시설1140504지역사회전환시설<NA>
22022서초구11405재활훈련시설1140501주간재활시설<NA>
32022관악구11405재활훈련시설1140505공동생활가정<NA>
42022송파구11401광역형 정신건강복지센터1140101광역형 정신건강복지센터<NA>
52022동작구11401광역형 정신건강복지센터1140101광역형 정신건강복지센터<NA>
62022동작구11405재활훈련시설1140501주간재활시설<NA>
72022동작구11405재활훈련시설1140503아동청소년정신건강지원시설<NA>
82022동작구11407종합시설1140701종합시설<NA>
92022관악구11403정신건강복지센터1140301정신건강복지센터<NA>
연도지역이름정신건강증진시설 분류코드정신건강증진시설 분류정신재활시설 코드정신재활시설 분류정신건강증진시설 수
17392017노원구11405재활훈련시설1140504지역사회전환시설0
17402017마포구11401광역형 정신건강복지센터1140101광역형 정신건강복지센터0
17412017마포구11405재활훈련시설1140503아동청소년정신건강지원시설0
17422017노원구11401광역형 정신건강복지센터1140101광역형 정신건강복지센터0
17432017양천구11402자살예방센터1140201자살예방센터0
17442017양천구11405재활훈련시설1140504지역사회전환시설0
17452017양천구11405재활훈련시설1140503아동청소년정신건강지원시설1
17462017동대문구11405재활훈련시설1140501주간재활시설1
17472017도봉구11406중독자재활시설1140601중독자재활시설1
17482017금천구11401광역형 정신건강복지센터1140101광역형 정신건강복지센터0