Overview

Dataset statistics

Number of variables7
Number of observations260
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.1 KiB
Average record size in memory59.5 B

Variable types

Categorical3
Numeric2
DateTime2

Dataset

Description회계년도,시민참여단 코드,교육시간코드,시민참여단주소,시민참여단구,등록일시,수정일시
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15722/S/1/datasetView.do

Alerts

회계년도 has constant value ""Constant
시민참여단주소 has constant value ""Constant
시민참여단 코드 is highly overall correlated with 시민참여단구High correlation
시민참여단구 is highly overall correlated with 시민참여단 코드High correlation
시민참여단 코드 has unique valuesUnique

Reproduction

Analysis started2024-05-04 05:15:16.380746
Analysis finished2024-05-04 05:15:19.157483
Duration2.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

회계년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
2014
260 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2014
2nd row2014
3rd row2014
4th row2014
5th row2014

Common Values

ValueCountFrequency (%)
2014 260
100.0%

Length

2024-05-04T05:15:19.434137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T05:15:19.850515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2014 260
100.0%

시민참여단 코드
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct260
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1209.2192
Minimum5
Maximum2490
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-05-04T05:15:20.450051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile69.9
Q1554.5
median1206
Q31850
95-th percentile2371.9
Maximum2490
Range2485
Interquartile range (IQR)1295.5

Descriptive statistics

Standard deviation756.87599
Coefficient of variation (CV)0.62592123
Kurtosis-1.2260566
Mean1209.2192
Median Absolute Deviation (MAD)650
Skewness-0.0086818304
Sum314397
Variance572861.26
MonotonicityNot monotonic
2024-05-04T05:15:20.893064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1759 1
 
0.4%
2262 1
 
0.4%
2048 1
 
0.4%
2143 1
 
0.4%
1563 1
 
0.4%
1158 1
 
0.4%
1917 1
 
0.4%
2236 1
 
0.4%
370 1
 
0.4%
1822 1
 
0.4%
Other values (250) 250
96.2%
ValueCountFrequency (%)
5 1
0.4%
21 1
0.4%
23 1
0.4%
32 1
0.4%
34 1
0.4%
44 1
0.4%
49 1
0.4%
51 1
0.4%
55 1
0.4%
56 1
0.4%
ValueCountFrequency (%)
2490 1
0.4%
2485 1
0.4%
2484 1
0.4%
2477 1
0.4%
2454 1
0.4%
2432 1
0.4%
2428 1
0.4%
2422 1
0.4%
2420 1
0.4%
2418 1
0.4%

교육시간코드
Real number (ℝ)

Distinct6
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.6615385
Minimum1
Maximum6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.4 KiB
2024-05-04T05:15:21.393263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q35
95-th percentile6
Maximum6
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.7289444
Coefficient of variation (CV)0.47219069
Kurtosis-1.2491341
Mean3.6615385
Median Absolute Deviation (MAD)1
Skewness-0.22570014
Sum952
Variance2.9892486
MonotonicityNot monotonic
2024-05-04T05:15:21.722702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
5 55
21.2%
4 50
19.2%
6 45
17.3%
1 45
17.3%
2 33
12.7%
3 32
12.3%
ValueCountFrequency (%)
1 45
17.3%
2 33
12.7%
3 32
12.3%
4 50
19.2%
5 55
21.2%
6 45
17.3%
ValueCountFrequency (%)
6 45
17.3%
5 55
21.2%
4 50
19.2%
3 32
12.3%
2 33
12.7%
1 45
17.3%

시민참여단주소
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
서울시
260 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울시
2nd row서울시
3rd row서울시
4th row서울시
5th row서울시

Common Values

ValueCountFrequency (%)
서울시 260
100.0%

Length

2024-05-04T05:15:22.080596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-04T05:15:22.360927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울시 260
100.0%

시민참여단구
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)9.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
강남구
23 
마포구
 
16
종로구
 
15
송파구
 
14
강동구
 
13
Other values (20)
179 

Length

Max length4
Median length3
Mean length3.0769231
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row송파구
2nd row동대문구
3rd row서대문구
4th row강동구
5th row서대문구

Common Values

ValueCountFrequency (%)
강남구 23
 
8.8%
마포구 16
 
6.2%
종로구 15
 
5.8%
송파구 14
 
5.4%
강동구 13
 
5.0%
동작구 12
 
4.6%
양천구 12
 
4.6%
용산구 12
 
4.6%
광진구 12
 
4.6%
도봉구 12
 
4.6%
Other values (15) 119
45.8%

Length

2024-05-04T05:15:22.693862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
강남구 23
 
8.8%
마포구 16
 
6.2%
종로구 15
 
5.8%
송파구 14
 
5.4%
강동구 13
 
5.0%
동작구 12
 
4.6%
양천구 12
 
4.6%
용산구 12
 
4.6%
광진구 12
 
4.6%
도봉구 12
 
4.6%
Other values (15) 119
45.8%

등록일시
Date

Distinct258
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
Minimum2014-07-08 11:41:44
Maximum2014-07-16 08:04:02
2024-05-04T05:15:23.117812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:15:23.657826image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일시
Date

Distinct259
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Memory size2.2 KiB
Minimum2014-07-08 11:41:44
Maximum2014-07-16 08:04:02
2024-05-04T05:15:24.358494image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:15:25.009488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-05-04T05:15:17.432208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:15:16.768392image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:15:17.756295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-04T05:15:17.106461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-04T05:15:25.418525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시민참여단 코드교육시간코드시민참여단구
시민참여단 코드1.0000.1680.993
교육시간코드0.1681.0000.352
시민참여단구0.9930.3521.000
2024-05-04T05:15:25.773157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시민참여단 코드교육시간코드시민참여단구
시민참여단 코드1.0000.0310.895
교육시간코드0.0311.0000.158
시민참여단구0.8950.1581.000

Missing values

2024-05-04T05:15:18.280776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-04T05:15:18.900658image/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

회계년도시민참여단 코드교육시간코드시민참여단주소시민참여단구등록일시수정일시
0201417595서울시송파구2014-07-16 08:04:02.02014-07-16 08:04:02.0
1201410466서울시동대문구2014-07-15 13:36:00.02014-07-15 13:36:00.0
2201413576서울시서대문구2014-07-15 11:42:12.02014-07-15 11:42:12.0
320141764서울시강동구2014-07-15 10:53:08.02014-07-15 10:53:08.0
4201413036서울시서대문구2014-07-15 09:48:07.02014-07-15 09:48:07.0
520141246서울시강동구2014-07-15 08:23:12.02014-07-15 08:23:12.0
6201423656서울시중구2014-07-14 22:37:08.02014-07-14 22:37:08.0
7201421816서울시은평구2014-07-14 16:55:00.02014-07-14 16:55:00.0
820144666서울시관악구2014-07-14 15:58:49.02014-07-14 16:00:51.0
9201422845서울시종로구2014-07-14 15:05:13.02014-07-14 15:05:13.0
회계년도시민참여단 코드교육시간코드시민참여단주소시민참여단구등록일시수정일시
2502014765서울시강남구2014-07-08 11:44:51.02014-07-08 11:44:51.0
25120145196서울시광진구2014-07-08 11:44:47.02014-07-08 11:44:47.0
252201422806서울시종로구2014-07-08 11:44:35.02014-07-08 22:21:18.0
25320142453서울시강북구2014-07-08 11:44:20.02014-07-08 11:44:20.0
25420145565서울시광진구2014-07-08 11:43:10.02014-07-08 11:43:10.0
255201424184서울시중랑구2014-07-08 11:42:56.02014-07-08 11:42:56.0
25620145606서울시광진구2014-07-08 11:42:35.02014-07-08 11:42:35.0
257201417163서울시송파구2014-07-08 11:42:24.02014-07-08 11:42:24.0
258201412866서울시마포구2014-07-08 11:42:07.02014-07-08 11:42:07.0
259201411926서울시동작구2014-07-08 11:41:44.02014-07-08 11:41:44.0