Overview

Dataset statistics

Number of variables7
Number of observations545
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory31.0 KiB
Average record size in memory58.2 B

Variable types

Numeric2
Categorical5

Dataset

Description중소벤처기업부 정책자금 운용계획 공고 기준에 따른 사회적 경제기업(사회적기업, 협동조합, 마을기업, 자활기업, 예비사회적기업) 지원 현황
Author중소벤처기업진흥공단
URLhttps://www.data.go.kr/data/15040452/fileData.do

Alerts

대출년도 has constant value ""Constant
일련번호 has unique valuesUnique

Reproduction

Analysis started2024-03-14 19:44:02.580188
Analysis finished2024-03-14 19:44:04.848641
Duration2.27 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일련번호
Real number (ℝ)

UNIQUE 

Distinct545
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean273
Minimum1
Maximum545
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.9 KiB
2024-03-15T04:44:05.068000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile28.2
Q1137
median273
Q3409
95-th percentile517.8
Maximum545
Range544
Interquartile range (IQR)272

Descriptive statistics

Standard deviation157.47222
Coefficient of variation (CV)0.57682132
Kurtosis-1.2
Mean273
Median Absolute Deviation (MAD)136
Skewness0
Sum148785
Variance24797.5
MonotonicityStrictly increasing
2024-03-15T04:44:05.522509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
367 1
 
0.2%
361 1
 
0.2%
362 1
 
0.2%
363 1
 
0.2%
364 1
 
0.2%
365 1
 
0.2%
366 1
 
0.2%
368 1
 
0.2%
410 1
 
0.2%
Other values (535) 535
98.2%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
545 1
0.2%
544 1
0.2%
543 1
0.2%
542 1
0.2%
541 1
0.2%
540 1
0.2%
539 1
0.2%
538 1
0.2%
537 1
0.2%
536 1
0.2%

지역
Categorical

Distinct17
Distinct (%)3.1%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
경기
98 
서울
69 
경북
57 
대구
39 
전남
36 
Other values (12)
246 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울
2nd row서울
3rd row충북
4th row충북
5th row경기

Common Values

ValueCountFrequency (%)
경기 98
18.0%
서울 69
12.7%
경북 57
10.5%
대구 39
 
7.2%
전남 36
 
6.6%
인천 32
 
5.9%
전북 31
 
5.7%
경남 28
 
5.1%
충북 28
 
5.1%
강원 26
 
4.8%
Other values (7) 101
18.5%

Length

2024-03-15T04:44:05.936256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기 98
18.0%
서울 69
12.7%
경북 57
10.5%
대구 39
 
7.2%
전남 36
 
6.6%
인천 32
 
5.9%
전북 31
 
5.7%
충북 28
 
5.1%
경남 28
 
5.1%
강원 26
 
4.8%
Other values (7) 101
18.5%

업력
Categorical

Distinct8
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
3년미만
131 
7년미만
115 
5년미만
84 
10년미만
80 
15년미만
70 
Other values (3)
65 

Length

Max length5
Median length4
Mean length4.3633028
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row15년미만
2nd row15년미만
3rd row20년이상
4th row20년이상
5th row7년미만

Common Values

ValueCountFrequency (%)
3년미만 131
24.0%
7년미만 115
21.1%
5년미만 84
15.4%
10년미만 80
14.7%
15년미만 70
12.8%
20년이상 33
 
6.1%
1년미만 17
 
3.1%
20년미만 15
 
2.8%

Length

2024-03-15T04:44:06.337050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:44:06.700428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3년미만 131
24.0%
7년미만 115
21.1%
5년미만 84
15.4%
10년미만 80
14.7%
15년미만 70
12.8%
20년이상 33
 
6.1%
1년미만 17
 
3.1%
20년미만 15
 
2.8%

대출년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2023년
545 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023년
2nd row2023년
3rd row2023년
4th row2023년
5th row2023년

Common Values

ValueCountFrequency (%)
2023년 545
100.0%

Length

2024-03-15T04:44:07.108525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:44:07.405080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023년 545
100.0%

대출월
Categorical

Distinct11
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
06월
85 
03월
80 
05월
59 
08월
56 
02월
56 
Other values (6)
209 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row05월
2nd row05월
3rd row11월
4th row03월
5th row03월

Common Values

ValueCountFrequency (%)
06월 85
15.6%
03월 80
14.7%
05월 59
10.8%
08월 56
10.3%
02월 56
10.3%
09월 55
10.1%
11월 48
8.8%
04월 40
7.3%
10월 33
 
6.1%
07월 25
 
4.6%

Length

2024-03-15T04:44:07.762031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
06월 85
15.6%
03월 80
14.7%
05월 59
10.8%
08월 56
10.3%
02월 56
10.3%
09월 55
10.1%
11월 48
8.8%
04월 40
7.3%
10월 33
 
6.1%
07월 25
 
4.6%

대출금액(백만원)
Real number (ℝ)

Distinct66
Distinct (%)12.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean193.80908
Minimum30
Maximum3600
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.9 KiB
2024-03-15T04:44:08.151469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30
5-th percentile50
Q1100
median100
Q3200
95-th percentile500
Maximum3600
Range3570
Interquartile range (IQR)100

Descriptive statistics

Standard deviation279.50782
Coefficient of variation (CV)1.4421813
Kurtosis66.79559
Mean193.80908
Median Absolute Deviation (MAD)50
Skewness7.0060226
Sum105625.95
Variance78124.621
MonotonicityNot monotonic
2024-03-15T04:44:08.616062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
100.0 207
38.0%
200.0 92
16.9%
50.0 65
 
11.9%
300.0 35
 
6.4%
150.0 28
 
5.1%
500.0 18
 
3.3%
70.0 8
 
1.5%
400.0 6
 
1.1%
250.0 5
 
0.9%
30.0 5
 
0.9%
Other values (56) 76
 
13.9%
ValueCountFrequency (%)
30.0 5
 
0.9%
36.0 1
 
0.2%
40.0 4
 
0.7%
49.0 1
 
0.2%
50.0 65
11.9%
55.0 3
 
0.6%
56.0 1
 
0.2%
60.0 1
 
0.2%
68.0 1
 
0.2%
70.0 8
 
1.5%
ValueCountFrequency (%)
3600.0 1
 
0.2%
3000.0 1
 
0.2%
2300.0 1
 
0.2%
1530.0 1
 
0.2%
1500.0 2
0.4%
1100.0 2
0.4%
1000.0 3
0.6%
928.0 1
 
0.2%
870.0 1
 
0.2%
800.0 1
 
0.2%

업종
Categorical

Distinct11
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
기타
176 
식료
105 
잡화
68 
유통
52 
정보
39 
Other values (6)
105 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row섬유
2nd row섬유
3rd row식료
4th row식료
5th row정보

Common Values

ValueCountFrequency (%)
기타 176
32.3%
식료 105
19.3%
잡화 68
 
12.5%
유통 52
 
9.5%
정보 39
 
7.2%
섬유 23
 
4.2%
화공 23
 
4.2%
금속 17
 
3.1%
전기 17
 
3.1%
기계 13
 
2.4%

Length

2024-03-15T04:44:09.123693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
기타 176
32.3%
식료 105
19.3%
잡화 68
 
12.5%
유통 52
 
9.5%
정보 39
 
7.2%
섬유 23
 
4.2%
화공 23
 
4.2%
금속 17
 
3.1%
전기 17
 
3.1%
기계 13
 
2.4%

Interactions

2024-03-15T04:44:03.667311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:44:03.141330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:44:03.931054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:44:03.393284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T04:44:09.389813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호지역업력대출월대출금액(백만원)업종
일련번호1.0000.3180.5660.6760.1530.328
지역0.3181.0000.2070.2500.0000.378
업력0.5660.2071.0000.2020.1300.306
대출월0.6760.2500.2021.0000.0550.019
대출금액(백만원)0.1530.0000.1300.0551.0000.249
업종0.3280.3780.3060.0190.2491.000
2024-03-15T04:44:09.678984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업종업력지역대출월
업종1.0000.1490.1490.000
업력0.1491.0000.0870.096
지역0.1490.0871.0000.095
대출월0.0000.0960.0951.000
2024-03-15T04:44:10.014349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일련번호대출금액(백만원)지역업력대출월업종
일련번호1.0000.0500.1280.3120.3670.145
대출금액(백만원)0.0501.0000.0000.0700.0260.125
지역0.1280.0001.0000.0870.0950.149
업력0.3120.0700.0871.0000.0960.149
대출월0.3670.0260.0950.0961.0000.000
업종0.1450.1250.1490.1490.0001.000

Missing values

2024-03-15T04:44:04.300589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T04:44:04.698488image/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

일련번호지역업력대출년도대출월대출금액(백만원)업종
01서울15년미만2023년05월1100.0섬유
12서울15년미만2023년05월200.0섬유
23충북20년이상2023년11월120.0식료
34충북20년이상2023년03월50.0식료
45경기7년미만2023년03월300.0정보
56울산10년미만2023년04월100.0기타
67대전15년미만2023년05월500.0금속
78제주20년이상2023년06월500.0유통
89서울15년미만2023년05월400.0전자
910전남20년이상2023년05월500.0기타
일련번호지역업력대출년도대출월대출금액(백만원)업종
535536경기3년미만2023년11월55.0식료
536537경기3년미만2023년11월110.0식료
537538경기3년미만2023년09월385.0식료
538539경기3년미만2023년08월100.0식료
539540충북7년미만2023년06월600.0기타
540541서울15년미만2023년05월200.0금속
541542경남20년이상2023년06월500.0기타
542543충북20년이상2023년06월1500.0유통
543544경북3년미만2023년08월100.0유통
544545전북20년이상2023년11월150.0식료