Overview

Dataset statistics

Number of variables5
Number of observations34
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory46.9 B

Variable types

Numeric2
Categorical1
DateTime1
Text1

Dataset

Description한국콘텐츠진흥원의 광화문 CKL기업지원센터에서의 클럽 멤버 정보를 데이터로 나타내어 제공되는 자료입니다. (클럽 멤버에 대한 정보)
Author한국콘텐츠진흥원
URLhttps://www.data.go.kr/data/15041608/fileData.do

Alerts

일련번호 is highly overall correlated with 클럽일련번호 and 1 other fieldsHigh correlation
클럽일련번호 is highly overall correlated with 일련번호High correlation
등급 is highly overall correlated with 일련번호High correlation
일련번호 has unique valuesUnique
등록일시 has unique valuesUnique

Reproduction

Analysis started2023-12-12 06:58:54.368057
Analysis finished2023-12-12 06:58:55.485098
Duration1.12 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean103.05882
Minimum1
Maximum261
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size438.0 B
2023-12-12T15:58:55.579012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.65
Q146
median103.5
Q3136
95-th percentile242.35
Maximum261
Range260
Interquartile range (IQR)90

Descriptive statistics

Standard deviation78.124974
Coefficient of variation (CV)0.75806196
Kurtosis-0.57929442
Mean103.05882
Median Absolute Deviation (MAD)50
Skewness0.52451365
Sum3504
Variance6103.5116
MonotonicityNot monotonic
2023-12-12T15:58:55.743170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
4 1
 
2.9%
221 1
 
2.9%
105 1
 
2.9%
106 1
 
2.9%
108 1
 
2.9%
121 1
 
2.9%
141 1
 
2.9%
161 1
 
2.9%
241 1
 
2.9%
61 1
 
2.9%
Other values (24) 24
70.6%
ValueCountFrequency (%)
1 1
2.9%
2 1
2.9%
3 1
2.9%
4 1
2.9%
5 1
2.9%
6 1
2.9%
21 1
2.9%
22 1
2.9%
41 1
2.9%
61 1
2.9%
ValueCountFrequency (%)
261 1
2.9%
243 1
2.9%
242 1
2.9%
241 1
2.9%
221 1
2.9%
201 1
2.9%
181 1
2.9%
161 1
2.9%
141 1
2.9%
121 1
2.9%

클럽일련번호
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)32.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59.735294
Minimum1
Maximum141
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size438.0 B
2023-12-12T15:58:55.871015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q121
median81
Q383
95-th percentile121
Maximum141
Range140
Interquartile range (IQR)62

Descriptive statistics

Standard deviation41.522764
Coefficient of variation (CV)0.69511274
Kurtosis-1.1264759
Mean59.735294
Median Absolute Deviation (MAD)40
Skewness-0.0073665442
Sum2031
Variance1724.1399
MonotonicityNot monotonic
2023-12-12T15:58:55.997161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
83 7
20.6%
1 5
14.7%
21 5
14.7%
41 4
11.8%
81 3
8.8%
121 3
8.8%
82 2
 
5.9%
101 2
 
5.9%
2 1
 
2.9%
61 1
 
2.9%
ValueCountFrequency (%)
1 5
14.7%
2 1
 
2.9%
21 5
14.7%
41 4
11.8%
61 1
 
2.9%
81 3
8.8%
82 2
 
5.9%
83 7
20.6%
101 2
 
5.9%
121 3
8.8%
ValueCountFrequency (%)
141 1
 
2.9%
121 3
8.8%
101 2
 
5.9%
83 7
20.6%
82 2
 
5.9%
81 3
8.8%
61 1
 
2.9%
41 4
11.8%
21 5
14.7%
2 1
 
2.9%

등급
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)14.7%
Missing0
Missing (%)0.0%
Memory size404.0 B
3
19 
0
11 
1
2 
8
 
1
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)5.9%

Sample

1st row3
2nd row0
3rd row3
4th row0
5th row3

Common Values

ValueCountFrequency (%)
3 19
55.9%
0 11
32.4%
1 2
 
5.9%
8 1
 
2.9%
5 1
 
2.9%

Length

2023-12-12T15:58:56.151109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:58:56.305515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 19
55.9%
0 11
32.4%
1 2
 
5.9%
8 1
 
2.9%
5 1
 
2.9%

등록일시
Date

UNIQUE 

Distinct34
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size404.0 B
Minimum2016-11-01 12:15:00
Maximum2020-01-13 16:24:00
2023-12-12T15:58:56.430119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:56.557393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)

승인일시
Text

Distinct33
Distinct (%)97.1%
Missing0
Missing (%)0.0%
Memory size404.0 B
2023-12-12T15:58:56.825575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length16
Mean length15.588235
Min length2

Characters and Unicode

Total characters530
Distinct characters15
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique32 ?
Unique (%)94.1%

Sample

1st row2016-11-01 15:50
2nd row2016-11-01 14:16
3rd row2016-11-01 15:50
4th row2017-01-05 09:55
5th row2017-02-08 10:58
ValueCountFrequency (%)
2016-11-01 6
 
9.0%
2017-02-07 6
 
9.0%
2017-02-08 4
 
6.0%
2019-08-07 3
 
4.5%
2016-12-29 2
 
3.0%
2016-12-15 2
 
3.0%
17:14 2
 
3.0%
14:17 2
 
3.0%
15:50 2
 
3.0%
2016-12-28 2
 
3.0%
Other values (35) 36
53.7%
2023-12-12T15:58:57.281180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 110
20.8%
0 86
16.2%
2 69
13.0%
- 66
12.5%
33
 
6.2%
: 33
 
6.2%
7 33
 
6.2%
6 23
 
4.3%
5 22
 
4.2%
4 16
 
3.0%
Other values (5) 39
 
7.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 396
74.7%
Dash Punctuation 66
 
12.5%
Space Separator 33
 
6.2%
Other Punctuation 33
 
6.2%
Other Letter 2
 
0.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 110
27.8%
0 86
21.7%
2 69
17.4%
7 33
 
8.3%
6 23
 
5.8%
5 22
 
5.6%
4 16
 
4.0%
3 15
 
3.8%
8 14
 
3.5%
9 8
 
2.0%
Other Letter
ValueCountFrequency (%)
없 1
50.0%
음 1
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%
Space Separator
ValueCountFrequency (%)
33
100.0%
Other Punctuation
ValueCountFrequency (%)
: 33
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 528
99.6%
Hangul 2
 
0.4%

Most frequent character per script

Common
ValueCountFrequency (%)
1 110
20.8%
0 86
16.3%
2 69
13.1%
- 66
12.5%
33
 
6.2%
: 33
 
6.2%
7 33
 
6.2%
6 23
 
4.4%
5 22
 
4.2%
4 16
 
3.0%
Other values (3) 37
 
7.0%
Hangul
ValueCountFrequency (%)
없 1
50.0%
음 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 528
99.6%
Hangul 2
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 110
20.8%
0 86
16.3%
2 69
13.1%
- 66
12.5%
33
 
6.2%
: 33
 
6.2%
7 33
 
6.2%
6 23
 
4.4%
5 22
 
4.2%
4 16
 
3.0%
Other values (3) 37
 
7.0%
Hangul
ValueCountFrequency (%)
없 1
50.0%
음 1
50.0%

Interactions

2023-12-12T15:58:55.093543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:54.887388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:55.194225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:55.000067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:58:57.373768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호클럽일련번호등급등록일시승인일시
일련번호1.0000.8220.9341.0001.000
클럽일련번호0.8221.0000.0001.0001.000
등급0.9340.0001.0001.0001.000
등록일시1.0001.0001.0001.0001.000
승인일시1.0001.0001.0001.0001.000
2023-12-12T15:58:57.484348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호클럽일련번호등급
일련번호1.0000.9050.593
클럽일련번호0.9051.0000.000
등급0.5930.0001.000

Missing values

2023-12-12T15:58:55.323024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:58:55.441065image/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

일련번호클럽일련번호등급등록일시승인일시
04132016-11-01 14:142016-11-01 15:50
15202016-11-01 14:162016-11-01 14:16
26132016-11-01 15:482016-11-01 15:50
3816102017-01-05 09:552017-01-05 09:55
41078332017-02-08 10:582017-02-08 10:58
51098232017-02-08 17:502017-02-08 17:50
61108332017-02-08 17:512017-02-08 17:51
72018382017-03-15 11:182017-03-15 11:18
81102016-11-01 12:152016-11-01 12:15
93132016-11-01 12:242016-11-01 12:24
일련번호클럽일련번호등급등록일시승인일시
241414132017-02-16 06:532017-02-16 06:53
251618332017-02-28 14:492017-02-28 14:49
2622110152017-10-23 11:29없음
2724112102019-08-07 14:212019-08-07 14:21
2824312132019-08-07 15:402019-08-07 15:40
29212102016-12-15 13:342016-12-15 13:34
30222132016-12-15 14:572016-12-15 14:57
3118110102017-03-09 17:142017-03-09 17:14
3224212132019-08-07 15:312019-08-07 15:31
3326114102020-01-13 16:242020-01-13 16:24