Overview

Dataset statistics

Number of variables7
Number of observations22
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory65.0 B

Variable types

Numeric2
Categorical3
Text1
DateTime1

Dataset

Description교육시스템_제휴기관 카테고리에 대한 데이터로 채널 일련번호, 메뉴코드, 과정 구분코드, 등록일자, 정렬 순번에 대한 항목을 제공합니다.
Author소상공인시장진흥공단
URLhttps://www.data.go.kr/data/15093460/fileData.do

Alerts

메뉴코드 is highly overall correlated with 과정구분코드 ( SC ) and 1 other fieldsHigh correlation
과정구분코드 ( SC ) is highly overall correlated with 메뉴코드 and 1 other fieldsHigh correlation
채널 일련번호 is highly overall correlated with 일련번호High correlation
일련번호 is highly overall correlated with 채널 일련번호High correlation
정렬순번 is highly overall correlated with 메뉴코드 and 1 other fieldsHigh correlation
일련번호 has unique valuesUnique
채널_변경된명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 20:49:44.941673
Analysis finished2023-12-12 20:49:45.827220
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

채널 일련번호
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean94.772727
Minimum3
Maximum147
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-13T05:49:45.879864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3
Q152
median107
Q3134
95-th percentile147
Maximum147
Range144
Interquartile range (IQR)82

Descriptive statistics

Standard deviation52.690409
Coefficient of variation (CV)0.55596595
Kurtosis-0.86716733
Mean94.772727
Median Absolute Deviation (MAD)34
Skewness-0.81574212
Sum2085
Variance2776.2792
MonotonicityNot monotonic
2023-12-13T05:49:45.991808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
147 5
22.7%
3 3
13.6%
105 3
13.6%
107 3
13.6%
131 2
 
9.1%
22 1
 
4.5%
91 1
 
4.5%
130 1
 
4.5%
39 1
 
4.5%
135 1
 
4.5%
ValueCountFrequency (%)
3 3
13.6%
22 1
 
4.5%
26 1
 
4.5%
39 1
 
4.5%
91 1
 
4.5%
105 3
13.6%
107 3
13.6%
130 1
 
4.5%
131 2
9.1%
135 1
 
4.5%
ValueCountFrequency (%)
147 5
22.7%
135 1
 
4.5%
131 2
 
9.1%
130 1
 
4.5%
107 3
13.6%
105 3
13.6%
91 1
 
4.5%
39 1
 
4.5%
26 1
 
4.5%
22 1
 
4.5%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean67.5
Minimum4
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size330.0 B
2023-12-13T05:49:46.141779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile7.45
Q149
median75.5
Q393.25
95-th percentile98.95
Maximum100
Range96
Interquartile range (IQR)44.25

Descriptive statistics

Standard deviation28.905017
Coefficient of variation (CV)0.42822247
Kurtosis-0.040423784
Mean67.5
Median Absolute Deviation (MAD)20
Skewness-0.82330662
Sum1485
Variance835.5
MonotonicityNot monotonic
2023-12-13T05:49:46.274230image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
4 1
 
4.5%
55 1
 
4.5%
35 1
 
4.5%
95 1
 
4.5%
97 1
 
4.5%
98 1
 
4.5%
99 1
 
4.5%
100 1
 
4.5%
91 1
 
4.5%
47 1
 
4.5%
Other values (12) 12
54.5%
ValueCountFrequency (%)
4 1
4.5%
6 1
4.5%
35 1
4.5%
41 1
4.5%
46 1
4.5%
47 1
4.5%
55 1
4.5%
58 1
4.5%
59 1
4.5%
60 1
4.5%
ValueCountFrequency (%)
100 1
4.5%
99 1
4.5%
98 1
4.5%
97 1
4.5%
95 1
4.5%
94 1
4.5%
91 1
4.5%
84 1
4.5%
83 1
4.5%
82 1
4.5%

메뉴코드
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
CHU001003
10 
CHU001004
4 
CHU001005
4 
CHU001007
2 
CHU001006
2 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowCHU001003
2nd rowCHU001004
3rd rowCHU001003
4th rowCHU001005
5th rowCHU001007

Common Values

ValueCountFrequency (%)
CHU001003 10
45.5%
CHU001004 4
 
18.2%
CHU001005 4
 
18.2%
CHU001007 2
 
9.1%
CHU001006 2
 
9.1%

Length

2023-12-13T05:49:46.408353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:49:46.578187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
chu001003 10
45.5%
chu001004 4
 
18.2%
chu001005 4
 
18.2%
chu001007 2
 
9.1%
chu001006 2
 
9.1%

과정구분코드 ( SC )
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
SC0300
10 
SC0400
4 
SC0500
4 
SC0700
2 
SC0600
2 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSC0300
2nd rowSC0400
3rd rowSC0300
4th rowSC0500
5th rowSC0700

Common Values

ValueCountFrequency (%)
SC0300 10
45.5%
SC0400 4
 
18.2%
SC0500 4
 
18.2%
SC0700 2
 
9.1%
SC0600 2
 
9.1%

Length

2023-12-13T05:49:46.724978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:49:46.866956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
sc0300 10
45.5%
sc0400 4
 
18.2%
sc0500 4
 
18.2%
sc0700 2
 
9.1%
sc0600 2
 
9.1%

채널_변경된명
Text

UNIQUE 

Distinct22
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size308.0 B
2023-12-13T05:49:47.115558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length9
Mean length6.3181818
Min length2

Characters and Unicode

Total characters139
Distinct characters84
Distinct categories4 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique22 ?
Unique (%)100.0%

Sample

1st row노동법
2nd row폐업부터 창업까지
3rd row대기만성CEO
4th row창업특강 꿈이룸
5th row취업
ValueCountFrequency (%)
노동법 1
 
3.2%
소상공인지원전문가 1
 
3.2%
상권르네상스사업 1
 
3.2%
역량 1
 
3.2%
디지털 1
 
3.2%
법률 1
 
3.2%
마케팅 1
 
3.2%
기획·관리 1
 
3.2%
창업교육 1
 
3.2%
청소년 1
 
3.2%
Other values (21) 21
67.7%
2023-12-13T05:49:47.487063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
업 10
 
7.2%
9
 
6.5%
소 6
 
4.3%
교 5
 
3.6%
상 5
 
3.6%
육 4
 
2.9%
창 4
 
2.9%
공 4
 
2.9%
지 4
 
2.9%
기 4
 
2.9%
Other values (74) 84
60.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 126
90.6%
Space Separator 9
 
6.5%
Uppercase Letter 3
 
2.2%
Other Punctuation 1
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
업 10
 
7.9%
소 6
 
4.8%
교 5
 
4.0%
상 5
 
4.0%
육 4
 
3.2%
창 4
 
3.2%
공 4
 
3.2%
지 4
 
3.2%
기 4
 
3.2%
법 3
 
2.4%
Other values (69) 77
61.1%
Uppercase Letter
ValueCountFrequency (%)
C 1
33.3%
E 1
33.3%
O 1
33.3%
Space Separator
ValueCountFrequency (%)
9
100.0%
Other Punctuation
ValueCountFrequency (%)
· 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 126
90.6%
Common 10
 
7.2%
Latin 3
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
업 10
 
7.9%
소 6
 
4.8%
교 5
 
4.0%
상 5
 
4.0%
육 4
 
3.2%
창 4
 
3.2%
공 4
 
3.2%
지 4
 
3.2%
기 4
 
3.2%
법 3
 
2.4%
Other values (69) 77
61.1%
Latin
ValueCountFrequency (%)
C 1
33.3%
E 1
33.3%
O 1
33.3%
Common
ValueCountFrequency (%)
9
90.0%
· 1
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 126
90.6%
ASCII 12
 
8.6%
None 1
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
업 10
 
7.9%
소 6
 
4.8%
교 5
 
4.0%
상 5
 
4.0%
육 4
 
3.2%
창 4
 
3.2%
공 4
 
3.2%
지 4
 
3.2%
기 4
 
3.2%
법 3
 
2.4%
Other values (69) 77
61.1%
ASCII
ValueCountFrequency (%)
9
75.0%
C 1
 
8.3%
E 1
 
8.3%
O 1
 
8.3%
None
ValueCountFrequency (%)
· 1
100.0%

등록일자
Date

Distinct16
Distinct (%)72.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
Minimum2019-10-02 11:02:00
Maximum2021-10-14 09:07:00
2023-12-13T05:49:47.616134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:49:47.730119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)

정렬순번
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)22.7%
Missing0
Missing (%)0.0%
Memory size308.0 B
1
11 
2
5 
3
4 
5
 
1
4
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique2 ?
Unique (%)9.1%

Sample

1st row1
2nd row2
3rd row1
4th row3
5th row3

Common Values

ValueCountFrequency (%)
1 11
50.0%
2 5
22.7%
3 4
 
18.2%
5 1
 
4.5%
4 1
 
4.5%

Length

2023-12-13T05:49:47.866054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:49:47.992167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 11
50.0%
2 5
22.7%
3 4
 
18.2%
5 1
 
4.5%
4 1
 
4.5%

Interactions

2023-12-13T05:49:45.450594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:49:45.260911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:49:45.559764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:49:45.356715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:49:48.083925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채널 일련번호일련번호메뉴코드과정구분코드 ( SC )채널_변경된명등록일자정렬순번
채널 일련번호1.0000.9380.0000.0001.0001.0000.000
일련번호0.9381.0000.0000.0001.0001.0000.000
메뉴코드0.0000.0001.0001.0001.0000.0000.931
과정구분코드 ( SC )0.0000.0001.0001.0001.0000.0000.931
채널_변경된명1.0001.0001.0001.0001.0001.0001.000
등록일자1.0001.0000.0000.0001.0001.0000.000
정렬순번0.0000.0000.9310.9311.0000.0001.000
2023-12-13T05:49:48.193839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
정렬순번메뉴코드과정구분코드 ( SC )
정렬순번1.0000.6280.628
메뉴코드0.6281.0001.000
과정구분코드 ( SC )0.6281.0001.000
2023-12-13T05:49:48.287998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
채널 일련번호일련번호메뉴코드과정구분코드 ( SC )정렬순번
채널 일련번호1.0000.9610.0000.0000.000
일련번호0.9611.0000.0000.0000.000
메뉴코드0.0000.0001.0001.0000.628
과정구분코드 ( SC )0.0000.0001.0001.0000.628
정렬순번0.0000.0000.6280.6281.000

Missing values

2023-12-13T05:49:45.667906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:49:45.781982image/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

채널 일련번호일련번호메뉴코드과정구분코드 ( SC )채널_변경된명등록일자정렬순번
0224CHU001003SC0300노동법2019-10-02 11:021
1341CHU001004SC0400폐업부터 창업까지2019-11-21 09:452
236CHU001003SC0300대기만성CEO2019-11-06 18:161
3346CHU001005SC0500창업특강 꿈이룸2020-01-14 15:593
410560CHU001007SC0700취업2021-03-31 15:253
510559CHU001006SC0600재창업2021-03-31 15:252
610558CHU001005SC0500폐업2021-03-31 15:251
710777CHU001004SC0400가맹사업법2021-06-08 09:471
810794CHU001005SC0500소송지원제도2021-09-16 17:093
910774CHU001003SC0300정보공개서 등록2021-04-16 14:422
채널 일련번호일련번호메뉴코드과정구분코드 ( SC )채널_변경된명등록일자정렬순번
129155CHU001003SC0300배민아카데미2020-11-30 16:211
1313082CHU001003SC0300소상공인지원전문가2021-07-07 14:311
143947CHU001003SC0300중소기업 기술보호 교육2020-02-14 14:351
1513591CHU001003SC0300학교 밖 청소년 창업교육2021-09-06 16:531
16147100CHU001007SC0700기획·관리2021-10-14 09:075
1714799CHU001006SC0600마케팅2021-10-14 09:074
1814798CHU001005SC0500법률2021-10-14 09:073
1914797CHU001004SC0400디지털 역량2021-10-14 09:072
2014795CHU001003SC0300상권르네상스사업2021-10-13 11:031
212635CHU001003SC0300파트너스퀘어2019-11-08 14:591