Overview

Dataset statistics

Number of variables10
Number of observations69
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.6 KiB
Average record size in memory82.9 B

Variable types

Numeric1
Categorical5
Text2
DateTime2

Dataset

Description광주광역시 북구에 소재하고 있는 대부업체 현황(등록신청사업, 영업구분, 상호명, 법인여부, 주소, 등록일자 등) 정보를 제공합니다.
Author광주광역시 북구
URLhttps://www.data.go.kr/data/15113018/fileData.do

Alerts

시군구명 has constant value ""Constant
영업구분 has constant value ""Constant
본점여부 has constant value ""Constant
데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
상호명 has unique valuesUnique

Reproduction

Analysis started2024-04-29 23:04:00.789128
Analysis finished2024-04-29 23:04:03.320906
Duration2.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35
Minimum1
Maximum69
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size753.0 B
2024-04-30T08:04:03.436644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.4
Q118
median35
Q352
95-th percentile65.6
Maximum69
Range68
Interquartile range (IQR)34

Descriptive statistics

Standard deviation20.062403
Coefficient of variation (CV)0.5732115
Kurtosis-1.2
Mean35
Median Absolute Deviation (MAD)17
Skewness0
Sum2415
Variance402.5
MonotonicityStrictly increasing
2024-04-30T08:04:03.621120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.4%
45 1
 
1.4%
51 1
 
1.4%
50 1
 
1.4%
49 1
 
1.4%
48 1
 
1.4%
47 1
 
1.4%
46 1
 
1.4%
44 1
 
1.4%
53 1
 
1.4%
Other values (59) 59
85.5%
ValueCountFrequency (%)
1 1
1.4%
2 1
1.4%
3 1
1.4%
4 1
1.4%
5 1
1.4%
6 1
1.4%
7 1
1.4%
8 1
1.4%
9 1
1.4%
10 1
1.4%
ValueCountFrequency (%)
69 1
1.4%
68 1
1.4%
67 1
1.4%
66 1
1.4%
65 1
1.4%
64 1
1.4%
63 1
1.4%
62 1
1.4%
61 1
1.4%
60 1
1.4%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
광주광역시 북구
69 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주광역시 북구
2nd row광주광역시 북구
3rd row광주광역시 북구
4th row광주광역시 북구
5th row광주광역시 북구

Common Values

ValueCountFrequency (%)
광주광역시 북구 69
100.0%

Length

2024-04-30T08:04:03.763328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:04:03.851918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 69
50.0%
북구 69
50.0%
Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
대부업
51 
대부중개업
18 

Length

Max length5
Median length3
Mean length3.5217391
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대부업
2nd row대부업
3rd row대부업
4th row대부중개업
5th row대부업

Common Values

ValueCountFrequency (%)
대부업 51
73.9%
대부중개업 18
 
26.1%

Length

2024-04-30T08:04:03.946930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:04:04.055360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대부업 51
73.9%
대부중개업 18
 
26.1%

영업구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
영업중
69 

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 (%)
영업중 69
100.0%

Length

2024-04-30T08:04:04.147809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:04:04.238411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 69
100.0%

상호명
Text

UNIQUE 

Distinct69
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-04-30T08:04:04.409707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length13
Mean length8.1304348
Min length3

Characters and Unicode

Total characters561
Distinct characters153
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique69 ?
Unique (%)100.0%

Sample

1st row라이프대부
2nd row유한회사 골드인베스트먼트대부
3rd row제이원 대부
4th rowSS론 대부중개
5th row오케이대부
ValueCountFrequency (%)
주식회사 12
 
13.8%
유한회사 3
 
3.4%
수지컨설팅대부 1
 
1.1%
양심대부 1
 
1.1%
공명정대부 1
 
1.1%
공명정대부중개 1
 
1.1%
sk파이낸셜대부 1
 
1.1%
yt대부 1
 
1.1%
정민산업대부 1
 
1.1%
수지컨설팅대부중개 1
 
1.1%
Other values (64) 64
73.6%
2024-04-30T08:04:04.779048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
69
 
12.3%
68
 
12.1%
18
 
3.2%
18
 
3.2%
18
 
3.2%
17
 
3.0%
15
 
2.7%
14
 
2.5%
12
 
2.1%
12
 
2.1%
Other values (143) 300
53.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 516
92.0%
Uppercase Letter 20
 
3.6%
Space Separator 18
 
3.2%
Lowercase Letter 3
 
0.5%
Open Punctuation 2
 
0.4%
Close Punctuation 2
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
69
 
13.4%
68
 
13.2%
18
 
3.5%
18
 
3.5%
17
 
3.3%
15
 
2.9%
14
 
2.7%
12
 
2.3%
12
 
2.3%
10
 
1.9%
Other values (127) 263
51.0%
Uppercase Letter
ValueCountFrequency (%)
S 5
25.0%
T 4
20.0%
J 2
 
10.0%
K 2
 
10.0%
Y 2
 
10.0%
L 1
 
5.0%
A 1
 
5.0%
I 1
 
5.0%
R 1
 
5.0%
D 1
 
5.0%
Lowercase Letter
ValueCountFrequency (%)
i 1
33.3%
n 1
33.3%
g 1
33.3%
Space Separator
ValueCountFrequency (%)
18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 516
92.0%
Latin 23
 
4.1%
Common 22
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
69
 
13.4%
68
 
13.2%
18
 
3.5%
18
 
3.5%
17
 
3.3%
15
 
2.9%
14
 
2.7%
12
 
2.3%
12
 
2.3%
10
 
1.9%
Other values (127) 263
51.0%
Latin
ValueCountFrequency (%)
S 5
21.7%
T 4
17.4%
J 2
 
8.7%
K 2
 
8.7%
Y 2
 
8.7%
L 1
 
4.3%
A 1
 
4.3%
I 1
 
4.3%
i 1
 
4.3%
n 1
 
4.3%
Other values (3) 3
13.0%
Common
ValueCountFrequency (%)
18
81.8%
( 2
 
9.1%
) 2
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 516
92.0%
ASCII 45
 
8.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
69
 
13.4%
68
 
13.2%
18
 
3.5%
18
 
3.5%
17
 
3.3%
15
 
2.9%
14
 
2.7%
12
 
2.3%
12
 
2.3%
10
 
1.9%
Other values (127) 263
51.0%
ASCII
ValueCountFrequency (%)
18
40.0%
S 5
 
11.1%
T 4
 
8.9%
( 2
 
4.4%
J 2
 
4.4%
K 2
 
4.4%
Y 2
 
4.4%
) 2
 
4.4%
L 1
 
2.2%
A 1
 
2.2%
Other values (6) 6
 
13.3%

법인여부
Categorical

Distinct2
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
개인
52 
법인
17 

Length

Max length3
Median length3
Mean length2.7536232
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row법인
3rd row개인
4th row개인
5th row개인

Common Values

ValueCountFrequency (%)
개인 52
75.4%
법인 17
 
24.6%

Length

2024-04-30T08:04:04.996786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:04:05.119982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 52
75.4%
법인 17
 
24.6%

주소
Text

Distinct59
Distinct (%)85.5%
Missing0
Missing (%)0.0%
Memory size684.0 B
2024-04-30T08:04:05.382772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length35
Mean length29.318841
Min length20

Characters and Unicode

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

Unique

Unique49 ?
Unique (%)71.0%

Sample

1st row광주광역시 북구 풍동길 9 (풍향동)
2nd row광주광역시 북구 태봉로 84-1 3층 (신안동)
3rd row광주광역시 북구 비엔날레로 54-18 404호 (운암동)
4th row광주광역시 북구 하남대로 625 3층 (동림동)
5th row광주광역시 북구 송해로 10 1층 (삼각동)
ValueCountFrequency (%)
광주광역시 69
 
16.2%
북구 69
 
16.2%
3층 14
 
3.3%
신안동 14
 
3.3%
운암동 12
 
2.8%
중흥로83번길 9
 
2.1%
용봉동 7
 
1.6%
7-7 7
 
1.6%
1층 7
 
1.6%
2층 6
 
1.4%
Other values (130) 212
49.8%
2024-04-30T08:04:05.807710image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
357
 
17.6%
138
 
6.8%
1 77
 
3.8%
73
 
3.6%
70
 
3.5%
69
 
3.4%
69
 
3.4%
69
 
3.4%
69
 
3.4%
) 69
 
3.4%
Other values (95) 963
47.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1123
55.5%
Decimal Number 377
 
18.6%
Space Separator 357
 
17.6%
Close Punctuation 69
 
3.4%
Open Punctuation 69
 
3.4%
Dash Punctuation 28
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
138
 
12.3%
73
 
6.5%
70
 
6.2%
69
 
6.1%
69
 
6.1%
69
 
6.1%
69
 
6.1%
67
 
6.0%
34
 
3.0%
32
 
2.8%
Other values (81) 433
38.6%
Decimal Number
ValueCountFrequency (%)
1 77
20.4%
0 51
13.5%
3 44
11.7%
2 41
10.9%
5 37
9.8%
4 34
9.0%
7 30
 
8.0%
8 30
 
8.0%
6 23
 
6.1%
9 10
 
2.7%
Space Separator
ValueCountFrequency (%)
357
100.0%
Close Punctuation
ValueCountFrequency (%)
) 69
100.0%
Open Punctuation
ValueCountFrequency (%)
( 69
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 28
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1123
55.5%
Common 900
44.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
138
 
12.3%
73
 
6.5%
70
 
6.2%
69
 
6.1%
69
 
6.1%
69
 
6.1%
69
 
6.1%
67
 
6.0%
34
 
3.0%
32
 
2.8%
Other values (81) 433
38.6%
Common
ValueCountFrequency (%)
357
39.7%
1 77
 
8.6%
) 69
 
7.7%
( 69
 
7.7%
0 51
 
5.7%
3 44
 
4.9%
2 41
 
4.6%
5 37
 
4.1%
4 34
 
3.8%
7 30
 
3.3%
Other values (4) 91
 
10.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1123
55.5%
ASCII 900
44.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
357
39.7%
1 77
 
8.6%
) 69
 
7.7%
( 69
 
7.7%
0 51
 
5.7%
3 44
 
4.9%
2 41
 
4.6%
5 37
 
4.1%
4 34
 
3.8%
7 30
 
3.3%
Other values (4) 91
 
10.1%
Hangul
ValueCountFrequency (%)
138
 
12.3%
73
 
6.5%
70
 
6.2%
69
 
6.1%
69
 
6.1%
69
 
6.1%
69
 
6.1%
67
 
6.0%
34
 
3.0%
32
 
2.8%
Other values (81) 433
38.6%
Distinct51
Distinct (%)73.9%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2021-05-14 00:00:00
Maximum2024-03-29 00:00:00
2024-04-30T08:04:05.943356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T08:04:06.071038image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

본점여부
Categorical

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
본점
69 

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 (%)
본점 69
100.0%

Length

2024-04-30T08:04:06.205133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-30T08:04:06.300260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
본점 69
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size684.0 B
Minimum2024-04-23 00:00:00
Maximum2024-04-23 00:00:00
2024-04-30T08:04:06.373499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-30T08:04:06.458557image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-30T08:04:02.871677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-30T08:04:06.529356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번등록신청사업상호명법인여부주소등록일자
연번1.0000.0001.0000.0000.9960.989
등록신청사업0.0001.0001.0000.0000.0000.000
상호명1.0001.0001.0001.0001.0001.000
법인여부0.0000.0001.0001.0001.0000.929
주소0.9960.0001.0001.0001.0001.000
등록일자0.9890.0001.0000.9291.0001.000
2024-04-30T08:04:06.626548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
법인여부등록신청사업
법인여부1.0000.000
등록신청사업0.0001.000
2024-04-30T08:04:06.713000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번등록신청사업법인여부
연번1.0000.0000.000
등록신청사업0.0001.0000.000
법인여부0.0000.0001.000

Missing values

2024-04-30T08:04:03.084548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-30T08:04:03.249099image/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광주광역시 북구대부업영업중라이프대부개인광주광역시 북구 풍동길 9 (풍향동)2021-05-14본점2024-04-23
12광주광역시 북구대부업영업중유한회사 골드인베스트먼트대부법인광주광역시 북구 태봉로 84-1 3층 (신안동)2021-06-08본점2024-04-23
23광주광역시 북구대부업영업중제이원 대부개인광주광역시 북구 비엔날레로 54-18 404호 (운암동)2021-06-25본점2024-04-23
34광주광역시 북구대부중개업영업중SS론 대부중개개인광주광역시 북구 하남대로 625 3층 (동림동)2021-07-27본점2024-04-23
45광주광역시 북구대부업영업중오케이대부개인광주광역시 북구 송해로 10 1층 (삼각동)2021-12-14본점2024-04-23
56광주광역시 북구대부중개업영업중탑파이낸셜대부중개개인광주광역시 북구 무등로180번길 6 5층 (신안동)2022-01-14본점2024-04-23
67광주광역시 북구대부업영업중샤인전당포대부개인광주광역시 북구 금호로 35 1층 (운암동)2022-01-15본점2024-04-23
78광주광역시 북구대부업영업중부성전당포대부개인광주광역시 북구 중흥로 121 (신안동)2022-02-22본점2024-04-23
89광주광역시 북구대부업영업중위너대부개인광주광역시 북구 하남대로 793 503호 (운암동)2022-02-28본점2024-04-23
910광주광역시 북구대부업영업중늘푸른플러스대부개인광주광역시 북구 면앙로 210 3층 (두암동)2022-03-02본점2024-04-23
연번시군구명등록신청사업영업구분상호명법인여부주소등록일자본점여부데이터기준일자
5960광주광역시 북구대부업영업중이룸금융센터대부개인광주광역시 북구 대자로 46 오피스봄 3층 105호 (운암동)2023-10-31본점2024-04-23
6061광주광역시 북구대부중개업영업중이룸금융센터대부중개개인광주광역시 북구 대자로 46 오피스봄 3층 105호 (운암동)2023-10-31본점2024-04-23
6162광주광역시 북구대부업영업중전남대부개인광주광역시 북구 독립로 405-5 401호 (우산동)2023-11-02본점2024-04-23
6263광주광역시 북구대부업영업중큰대부개인광주광역시 북구 설죽로 258 4층 (용봉동)2023-11-17본점2024-04-23
6364광주광역시 북구대부업영업중토종대부개인광주광역시 북구 저불로 47-10 3층 (용봉동)2023-11-22본점2024-04-23
6465광주광역시 북구대부업영업중마주대부개인광주광역시 북구 독립로 363 2층 (중흥동)2023-11-29본점2024-04-23
6566광주광역시 북구대부업영업중모란대부개인광주광역시 북구 하남대로 733-6 402호 (운암동)2023-12-29본점2024-04-23
6667광주광역시 북구대부중개업영업중바로컨설팅대부중개개인광주광역시 북구 우치로 236 201호 (오치동)2024-01-02본점2024-04-23
6768광주광역시 북구대부업영업중SD대부개인광주광역시 북구 무등로180번길 12 제일오피스텔 1227호 (신안동)2024-01-11본점2024-04-23
6869광주광역시 북구대부업영업중유한회사 솔미자산관리대부법인광주광역시 북구 본촌마을길 114 (본촌동)2024-03-29본점2024-04-23