Overview

Dataset statistics

Number of variables9
Number of observations135
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.9 KiB
Average record size in memory74.9 B

Variable types

Categorical7
Numeric2

Dataset

Description대구광역시 북구_대부업_20230626
Author대구광역시 북구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15060096&dataSetDetailId=150600961aae1f8f550c8&provdMethod=FILE

Alerts

데이터기준일자 has constant value "2023-06-26"Constant
등록번호 has a high cardinality: 134 distinct valuesHigh cardinality
등록일자 has a high cardinality: 94 distinct valuesHigh cardinality
상호 has a high cardinality: 134 distinct valuesHigh cardinality
소재지주소 has a high cardinality: 102 distinct valuesHigh cardinality
경도 is highly overall correlated with 등록일자High correlation
등록일자 is highly overall correlated with 경도High correlation
법인여부 is highly imbalanced (70.6%)Imbalance

Reproduction

Analysis started2023-07-01 23:58:28.685740
Analysis finished2023-07-01 23:58:34.668657
Duration5.98 seconds
Software versionpandas-profiling v3.6.6
Download configurationconfig.json

Variables

유형
Categorical

Distinct2
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
대부업
91 
대부중개업
44 

Length

Max length5
Median length3
Mean length3.6518519
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
대부업 91
67.4%
대부중개업 44
32.6%

Length

2023-07-02T08:58:34.767427image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-02T08:58:34.936510image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
대부업 91
67.4%
대부중개업 44
32.6%

등록번호
Categorical

Distinct134
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2022-대구북구-0022(대부)
 
2
2023-대구북구-0017(대부)
 
1
2023-대구북구-0031(대부)
 
1
2023-대구북구-0030(대부)
 
1
2023-대구북구-0029(대부)
 
1
Other values (129)
129 

Length

Max length20
Median length18
Mean length18.022222
Min length10

Unique

Unique133 ?
Unique (%)98.5%

Sample

1st row2023-대구북구-0034(대부중개)
2nd row2023-대구북구-0033(대부중개)
3rd row2023-대구북구-0032(대부)
4th row2023-대구북구-0031(대부)
5th row2023-대구북구-0030(대부)

Common Values

ValueCountFrequency (%)
2022-대구북구-0022(대부) 2
 
1.5%
2023-대구북구-0017(대부) 1
 
0.7%
2023-대구북구-0031(대부) 1
 
0.7%
2023-대구북구-0030(대부) 1
 
0.7%
2023-대구북구-0029(대부) 1
 
0.7%
2023-대구북구-0025(대부) 1
 
0.7%
2023-대구북구-0027(대부) 1
 
0.7%
2023-대구북구-0026(대부중개) 1
 
0.7%
2023-대구북구-0028(대부중개) 1
 
0.7%
2023-대구북구-0023(대부) 1
 
0.7%
Other values (124) 124
91.9%

Length

2023-07-02T08:58:35.090584image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-대구북구-0022(대부 2
 
1.5%
2021-대구북구-0027(대부중개 1
 
0.7%
2021-대구북구-0005(대부 1
 
0.7%
2021-대구북구-0006(대부중개 1
 
0.7%
2021-대구북구-0007(대부 1
 
0.7%
2021-대구북구-0012(대부 1
 
0.7%
2021-대구북구-0013(대부중개 1
 
0.7%
2021-대구북구-0016(대부 1
 
0.7%
2021-대구북구-0017(대부중개 1
 
0.7%
2021-대구북구-0018(대부 1
 
0.7%
Other values (124) 124
91.9%

등록일자
Categorical

HIGH CARDINALITY  HIGH CORRELATION 

Distinct94
Distinct (%)69.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-04-06
 
4
2023-05-23
 
4
2023-02-19
 
4
2022-09-27
 
4
2022-03-08
 
3
Other values (89)
116 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique63 ?
Unique (%)46.7%

Sample

1st row2023-06-20
2nd row2023-06-13
3rd row2023-06-09
4th row2023-06-08
5th row2023-04-04

Common Values

ValueCountFrequency (%)
2023-04-06 4
 
3.0%
2023-05-23 4
 
3.0%
2023-02-19 4
 
3.0%
2022-09-27 4
 
3.0%
2022-03-08 3
 
2.2%
2021-03-25 3
 
2.2%
2021-03-22 2
 
1.5%
2022-01-28 2
 
1.5%
2023-05-08 2
 
1.5%
2023-01-05 2
 
1.5%
Other values (84) 105
77.8%

Length

2023-07-02T08:58:35.256448image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2023-04-06 4
 
3.0%
2022-09-27 4
 
3.0%
2023-05-23 4
 
3.0%
2023-02-19 4
 
3.0%
2021-03-25 3
 
2.2%
2022-03-08 3
 
2.2%
2021-03-11 2
 
1.5%
2022-04-14 2
 
1.5%
2022-11-22 2
 
1.5%
2022-04-05 2
 
1.5%
Other values (84) 105
77.8%

상호
Categorical

Distinct134
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
에이치제이인베스트대부법인(유)
 
2
소녀대부
 
1
마우스대부
 
1
AK파이낸셜대부
 
1
ACE파이낸셜대부
 
1
Other values (129)
129 

Length

Max length16
Median length13
Mean length7.4592593
Min length3

Unique

Unique133 ?
Unique (%)98.5%

Sample

1st rowK로얄대부중개
2nd row킹스대부중개
3rd row바로솔루션대부
4th row마우스대부
5th rowAK파이낸셜대부

Common Values

ValueCountFrequency (%)
에이치제이인베스트대부법인(유) 2
 
1.5%
소녀대부 1
 
0.7%
마우스대부 1
 
0.7%
AK파이낸셜대부 1
 
0.7%
ACE파이낸셜대부 1
 
0.7%
일취월장대부 1
 
0.7%
일장춘몽대부 1
 
0.7%
일취월장대부중개 1
 
0.7%
일장춘몽대부중개 1
 
0.7%
HnK대부 1
 
0.7%
Other values (124) 124
91.9%

Length

2023-07-02T08:58:35.439188image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대부 44
 
19.8%
대부중개 20
 
9.0%
전당포 4
 
1.8%
파이낸셜 3
 
1.4%
에이치제이인베스트대부법인(유 2
 
0.9%
서민드림 2
 
0.9%
다른 2
 
0.9%
플렉스 2
 
0.9%
희망대출 2
 
0.9%
러쉬앤캐쉬 2
 
0.9%
Other values (126) 139
62.6%

법인여부
Categorical

Distinct2
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
개인
128 
법인
 
7

Length

Max length3
Median length3
Mean length2.9481481
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
개인 128
94.8%
법인 7
 
5.2%

Length

2023-07-02T08:58:35.600539image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-02T08:58:35.887998image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
개인 128
94.8%
법인 7
 
5.2%

소재지주소
Categorical

Distinct102
Distinct (%)75.6%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
대구광역시 북구 학정로109길 40, 1층 (학정동)
 
2
대구광역시 북구 대학로 69, 619호 (산격동)
 
2
대구광역시 북구 대현로9길 58, 2층 210호 (산격동)
 
2
대구광역시 북구 칠성남로26길 39, 2층 (칠성동2가)
 
2
대구광역시 북구 학정로 77, 2층 (태전동)
 
2
Other values (97)
125 

Length

Max length46
Median length42
Mean length31.466667
Min length20

Unique

Unique69 ?
Unique (%)51.1%

Sample

1st row대구광역시 북구 중앙대로 550-14, 252호 (칠성동2가)
2nd row대구광역시 북구 대현로9길 58, 5층 513호 (산격동)
3rd row대구광역시 북구 칠곡중앙대로116길 22, 2층 (읍내동)
4th row대구광역시 북구 대현로9길 58, 517호 (산격동)
5th row대구광역시 북구 중앙대로 550-14, 266호 (칠성동2가)

Common Values

ValueCountFrequency (%)
대구광역시 북구 학정로109길 40, 1층 (학정동) 2
 
1.5%
대구광역시 북구 대학로 69, 619호 (산격동) 2
 
1.5%
대구광역시 북구 대현로9길 58, 2층 210호 (산격동) 2
 
1.5%
대구광역시 북구 칠성남로26길 39, 2층 (칠성동2가) 2
 
1.5%
대구광역시 북구 학정로 77, 2층 (태전동) 2
 
1.5%
대구광역시 북구 중앙대로 550-14, 268호 (칠성동2가) 2
 
1.5%
대구광역시 북구 동변로 55, 상가 가동 105호 (동변동, 대구동서변그린빌) 2
 
1.5%
대구광역시 북구 칠곡중앙대로116길 22, 2층 (읍내동) 2
 
1.5%
대구광역시 북구 팔달로35길 117(노원동3가) 2
 
1.5%
대구광역시 북구 원대로21길 14, 3층 (노원동1가) 2
 
1.5%
Other values (92) 115
85.2%

Length

2023-07-02T08:58:36.019272image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대구광역시 135
 
15.7%
북구 135
 
15.7%
산격동 51
 
5.9%
58 30
 
3.5%
대현로9길 30
 
3.5%
칠성동2가 24
 
2.8%
중앙대로 21
 
2.4%
550-14 20
 
2.3%
태전동 17
 
2.0%
2층 16
 
1.9%
Other values (201) 379
44.2%

위도
Real number (ℝ)

Distinct54
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35.901904
Minimum35.875422
Maximum35.958572
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-07-02T08:58:36.176651image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/

Quantile statistics

Minimum35.875422
5-th percentile35.880181
Q135.888292
median35.891653
Q335.916789
95-th percentile35.946419
Maximum35.958572
Range0.083150024
Interquartile range (IQR)0.028496697

Descriptive statistics

Standard deviation0.022845918
Coefficient of variation (CV)0.00063634281
Kurtosis-0.3051181
Mean35.901904
Median Absolute Deviation (MAD)0.010118064
Skewness1.0167271
Sum4846.757
Variance0.00052193598
MonotonicityNot monotonic
2023-07-02T08:58:36.373113image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
35.8882920783 30
22.2%
35.8815350618 20
 
14.8%
35.8921711307 12
 
8.9%
35.9021683418 3
 
2.2%
35.8873858315 2
 
1.5%
35.9463205134 2
 
1.5%
35.9175299313 2
 
1.5%
35.9424975474 2
 
1.5%
35.89006153 2
 
1.5%
35.9522907055 2
 
1.5%
Other values (44) 58
43.0%
ValueCountFrequency (%)
35.8754221307 2
 
1.5%
35.8763942321 1
 
0.7%
35.8777508586 2
 
1.5%
35.8778014163 1
 
0.7%
35.87902 1
 
0.7%
35.8806790684 1
 
0.7%
35.8815350618 20
14.8%
35.88266294 1
 
0.7%
35.8869425354 1
 
0.7%
35.8873858315 2
 
1.5%
ValueCountFrequency (%)
35.9585721546 1
0.7%
35.9541107411 2
1.5%
35.9522907055 2
1.5%
35.9466476917 2
1.5%
35.9463205134 2
1.5%
35.9439728007 2
1.5%
35.9439419883 1
0.7%
35.9436172277 1
0.7%
35.9426878163 1
0.7%
35.9424975474 2
1.5%

경도
Real number (ℝ)

Distinct54
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean128.58678
Minimum128.54196
Maximum128.62572
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.3 KiB
2023-07-02T08:58:36.565441image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/

Quantile statistics

Minimum128.54196
5-th percentile128.54536
Q1128.56467
median128.59676
Q3128.60286
95-th percentile128.60806
Maximum128.62572
Range0.083756568
Interquartile range (IQR)0.038188131

Descriptive statistics

Standard deviation0.023543924
Coefficient of variation (CV)0.00018309755
Kurtosis-1.0353521
Mean128.58678
Median Absolute Deviation (MAD)0.010062821
Skewness-0.66669493
Sum17359.215
Variance0.00055431636
MonotonicityNot monotonic
2023-07-02T08:58:36.763454image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
128.6028577204 30
22.2%
128.5967630225 20
 
14.8%
128.6080600979 12
 
8.9%
128.6065326323 3
 
2.2%
128.5810155203 2
 
1.5%
128.5530981834 2
 
1.5%
128.545485136 2
 
1.5%
128.6233113912 2
 
1.5%
128.5693834891 2
 
1.5%
128.5650086817 2
 
1.5%
Other values (44) 58
43.0%
ValueCountFrequency (%)
128.5419595183 1
0.7%
128.5424575815 1
0.7%
128.5429646864 1
0.7%
128.5434402173 1
0.7%
128.5439410681 2
1.5%
128.5450569342 1
0.7%
128.545485136 2
1.5%
128.5465575161 2
1.5%
128.547845928 1
0.7%
128.5489070265 2
1.5%
ValueCountFrequency (%)
128.6257160864 1
 
0.7%
128.6233113912 2
 
1.5%
128.6215475556 1
 
0.7%
128.6148481322 1
 
0.7%
128.6128316277 1
 
0.7%
128.6080600979 12
8.9%
128.6075775686 1
 
0.7%
128.6068258436 1
 
0.7%
128.6065326323 3
 
2.2%
128.6063955717 2
 
1.5%

데이터기준일자
Categorical

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2023-06-26
135 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-06-26
2nd row2023-06-26
3rd row2023-06-26
4th row2023-06-26
5th row2023-06-26

Common Values

ValueCountFrequency (%)
2023-06-26 135
100.0%

Length

2023-07-02T08:58:36.937269image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-02T08:58:37.105066image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-26 135
100.0%

Interactions

2023-07-02T08:58:33.851334image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
2023-07-02T08:58:33.521373image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
2023-07-02T08:58:33.997482image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
2023-07-02T08:58:33.722893image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/

Correlations

2023-07-02T08:58:37.192072image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
위도경도
위도1.000-0.651
경도-0.6511.000
2023-07-02T08:58:37.324675image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
위도경도
위도1.000-0.382
경도-0.3821.000
2023-07-02T08:58:37.454037image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
위도경도
위도1.000-0.186
경도-0.1861.000
2023-07-02T08:58:37.578577image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
유형등록일자법인여부위도경도
유형1.0000.0000.0000.0000.000
등록일자0.0001.0000.8510.9850.993
법인여부0.0000.8511.0000.4370.317
위도0.0000.9850.4371.0000.909
경도0.0000.9930.3170.9091.000
2023-07-02T08:58:37.725214image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
법인여부등록일자유형
법인여부1.0000.3960.000
등록일자0.3961.0000.000
유형0.0000.0001.000
2023-07-02T08:58:37.881435image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
위도경도유형등록일자법인여부
위도1.000-0.3820.0000.4880.325
경도-0.3821.0000.0000.5230.236
유형0.0000.0001.0000.0000.000
등록일자0.4880.5230.0001.0000.396
법인여부0.3250.2360.0000.3961.000

Missing values

2023-07-02T08:58:34.241330image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
A simple visualization of nullity by column.
2023-07-02T08:58:34.512159image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

유형등록번호등록일자상호법인여부소재지주소위도경도데이터기준일자
0대부중개업2023-대구북구-0034(대부중개)2023-06-20K로얄대부중개개인대구광역시 북구 중앙대로 550-14, 252호 (칠성동2가)35.881535128.5967632023-06-26
1대부중개업2023-대구북구-0033(대부중개)2023-06-13킹스대부중개개인대구광역시 북구 대현로9길 58, 5층 513호 (산격동)35.888292128.6028582023-06-26
2대부업2023-대구북구-0032(대부)2023-06-09바로솔루션대부개인대구광역시 북구 칠곡중앙대로116길 22, 2층 (읍내동)35.946321128.5530982023-06-26
3대부업2023-대구북구-0031(대부)2023-06-08마우스대부개인대구광역시 북구 대현로9길 58, 517호 (산격동)35.888292128.6028582023-06-26
4대부업2023-대구북구-0030(대부)2023-04-04AK파이낸셜대부개인대구광역시 북구 중앙대로 550-14, 266호 (칠성동2가)35.881535128.5967632023-06-26
5대부업2023-대구북구-0029(대부)2023-06-05ACE파이낸셜대부개인대구광역시 북구 중앙대로 550-14, 275호 (칠성동2가)35.881535128.5967632023-06-26
6대부업2023-대구북구-0025(대부)2023-05-23일취월장대부개인대구광역시 북구 대현로9길 58, 5층 506-12호 (산격동)35.888292128.6028582023-06-26
7대부업2023-대구북구-0027(대부)2023-05-23일장춘몽대부개인대구광역시 북구 중앙대로 550-14, 238호 (칠성동2가)35.881535128.5967632023-06-26
8대부중개업2023-대구북구-0026(대부중개)2023-05-23일취월장대부중개개인대구광역시 북구 대현로9길 58, 5층 506-12호 (산격동)35.888292128.6028582023-06-26
9대부중개업2023-대구북구-0028(대부중개)2023-05-23일장춘몽대부중개개인대구광역시 북구 중앙대로 550-14, 238호 (칠성동2가)35.881535128.5967632023-06-26
유형등록번호등록일자상호법인여부소재지주소위도경도데이터기준일자
125대부업대구북구제1-492호2020-08-06e착한대부개인대구광역시 북구 연암로26길 8, 1층 (산격동)35.895343128.5956612023-06-26
126대부업대구북구제1-491호2020-03-17대영전당포 대부개인대구광역시 북구 칠성남로 225 (칠성동1가)35.876394128.6049232023-06-26
127대부중개업대구북구제2-478호2022-01-28에이치제이인베스트대부법인(유)법인대구광역시 북구 동암로37길 7, 1층 (국우동)35.943973128.5710752023-06-26
128대부업대구북구제1-486호2022-01-28에이치제이인베스트대부법인(유)법인대구광역시 북구 동암로37길 7, 1층 (국우동)35.943973128.5710752023-06-26
129대부업대구북구제1-477호2022-05-03클릭아이티전당포대부개인대구광역시 북구 동천로23길 36 (동천동)35.942688128.5565852023-06-26
130대부업대구북구제1-437호2023-01-19북구 전당포 대부개인대구광역시 북구 동북로 190-10 (산격동)35.897978128.6128322023-06-26
131대부업대구북구제1-404호2021-09-15진 대부개인대구광역시 북구 노원로10길 98-18 (노원동2가)35.890408128.5723282023-06-26
132대부업2018-대구북구-00022021-02-25가나 전당포 대부개인대구광역시 북구 학정로42길 3, 1층 2호 (구암동)35.924925128.5560042023-06-26
133대부업대구북구제1-22호2023-03-08신광 전당포 대부개인대구광역시 북구 대현남로2길 72 (대현동)35.877801128.6068262023-06-26
134대부업대구북구제1-33호2022-12-29원호 전당포 대부개인대구광역시 북구 팔달로 179 (노원동2가)35.888792128.5697752023-06-26