Overview

Dataset statistics

Number of variables13
Number of observations7373
Missing cells7736
Missing cells (%)8.1%
Duplicate rows5
Duplicate rows (%)0.1%
Total size in memory770.5 KiB
Average record size in memory107.0 B

Variable types

Text3
DateTime3
Categorical5
Numeric1
Unsupported1

Alerts

lastupdtdt has constant value ""Constant
last_load_dttm has constant value ""Constant
Dataset has 5 (0.1%) duplicate rowsDuplicates
sttussecode is highly overall correlated with sttussecodenmHigh correlation
sttussecodenm is highly overall correlated with sttussecodeHigh correlation
ldcode is highly overall correlated with ldcodenmHigh correlation
ldcodenm is highly overall correlated with ldcodeHigh correlation
sttussecode is highly imbalanced (97.6%)Imbalance
sttussecodenm is highly imbalanced (97.6%)Imbalance
estbsbeginde has 94 (1.3%) missing valuesMissing
estbsendde has 94 (1.3%) missing valuesMissing
telnolist has 7373 (100.0%) missing valuesMissing
telnolist is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-04-17 02:16:42.780859
Analysis finished2024-04-17 02:16:44.208551
Duration1.43 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

brkrnm
Text

Distinct6092
Distinct (%)83.3%
Missing63
Missing (%)0.9%
Memory size57.7 KiB
2024-04-17T11:16:44.417960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length3
Mean length3.0032832
Min length2

Characters and Unicode

Total characters21954
Distinct characters328
Distinct categories6 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5364 ?
Unique (%)73.4%

Sample

1st row임양운
2nd row김중의
3rd row이민우
4th row김경숙
5th row김영수
ValueCountFrequency (%)
김정희 17
 
0.2%
김미경 11
 
0.2%
김영희 11
 
0.2%
이영주 11
 
0.2%
이미경 10
 
0.1%
김미숙 10
 
0.1%
김경희 10
 
0.1%
이정희 10
 
0.1%
김민정 9
 
0.1%
김현정 8
 
0.1%
Other values (6090) 7212
98.5%
2024-04-17T11:16:44.802207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 1588
 
7.2%
이 1120
 
5.1%
정 1062
 
4.8%
영 753
 
3.4%
박 651
 
3.0%
희 557
 
2.5%
경 537
 
2.4%
미 462
 
2.1%
숙 444
 
2.0%
현 400
 
1.8%
Other values (318) 14380
65.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21899
99.7%
Lowercase Letter 15
 
0.1%
Open Punctuation 12
 
0.1%
Close Punctuation 12
 
0.1%
Space Separator 10
 
< 0.1%
Uppercase Letter 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 1588
 
7.3%
이 1120
 
5.1%
정 1062
 
4.8%
영 753
 
3.4%
박 651
 
3.0%
희 557
 
2.5%
경 537
 
2.5%
미 462
 
2.1%
숙 444
 
2.0%
현 400
 
1.8%
Other values (299) 14325
65.4%
Lowercase Letter
ValueCountFrequency (%)
e 4
26.7%
y 2
13.3%
a 2
13.3%
g 1
 
6.7%
k 1
 
6.7%
i 1
 
6.7%
n 1
 
6.7%
m 1
 
6.7%
u 1
 
6.7%
s 1
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
H 1
16.7%
B 1
16.7%
A 1
16.7%
S 1
16.7%
C 1
16.7%
L 1
16.7%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Space Separator
ValueCountFrequency (%)
10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21864
99.6%
Han 35
 
0.2%
Common 34
 
0.2%
Latin 21
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 1588
 
7.3%
이 1120
 
5.1%
정 1062
 
4.9%
영 753
 
3.4%
박 651
 
3.0%
희 557
 
2.5%
경 537
 
2.5%
미 462
 
2.1%
숙 444
 
2.0%
현 400
 
1.8%
Other values (271) 14290
65.4%
Han
ValueCountFrequency (%)
金 3
 
8.6%
美 2
 
5.7%
慶 2
 
5.7%
崔 2
 
5.7%
李 2
 
5.7%
順 2
 
5.7%
愛 1
 
2.9%
南 1
 
2.9%
洪 1
 
2.9%
烈 1
 
2.9%
Other values (18) 18
51.4%
Latin
ValueCountFrequency (%)
e 4
19.0%
y 2
 
9.5%
a 2
 
9.5%
H 1
 
4.8%
g 1
 
4.8%
k 1
 
4.8%
i 1
 
4.8%
B 1
 
4.8%
n 1
 
4.8%
A 1
 
4.8%
Other values (6) 6
28.6%
Common
ValueCountFrequency (%)
( 12
35.3%
) 12
35.3%
10
29.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21864
99.6%
ASCII 55
 
0.3%
CJK 33
 
0.2%
CJK Compat Ideographs 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 1588
 
7.3%
이 1120
 
5.1%
정 1062
 
4.9%
영 753
 
3.4%
박 651
 
3.0%
희 557
 
2.5%
경 537
 
2.5%
미 462
 
2.1%
숙 444
 
2.0%
현 400
 
1.8%
Other values (271) 14290
65.4%
ASCII
ValueCountFrequency (%)
( 12
21.8%
) 12
21.8%
10
18.2%
e 4
 
7.3%
y 2
 
3.6%
a 2
 
3.6%
H 1
 
1.8%
g 1
 
1.8%
k 1
 
1.8%
i 1
 
1.8%
Other values (9) 9
16.4%
CJK
ValueCountFrequency (%)
金 3
 
9.1%
美 2
 
6.1%
慶 2
 
6.1%
崔 2
 
6.1%
順 2
 
6.1%
愛 1
 
3.0%
南 1
 
3.0%
洪 1
 
3.0%
烈 1
 
3.0%
忠 1
 
3.0%
Other values (17) 17
51.5%
CJK Compat Ideographs
ValueCountFrequency (%)
李 2
100.0%

bsnmcmpnm
Text

Distinct4774
Distinct (%)65.2%
Missing56
Missing (%)0.8%
Memory size57.7 KiB
2024-04-17T11:16:44.981655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length11.298346
Min length4

Characters and Unicode

Total characters82670
Distinct characters627
Distinct categories12 ?
Distinct scripts4 ?
Distinct blocks6 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3937 ?
Unique (%)53.8%

Sample

1st row삼보공인중개사사무소
2nd row롯데부동산중개사무소
3rd row신우공인중개사사무소
4th row금호우리공인중개사사무소
5th row천지공인
ValueCountFrequency (%)
공인중개사사무소 85
 
1.1%
사무소 83
 
1.1%
현대공인중개사사무소 42
 
0.6%
삼성공인중개사사무소 36
 
0.5%
미래공인중개사사무소 35
 
0.5%
행운공인중개사사무소 33
 
0.4%
태양공인중개사사무소 30
 
0.4%
탑공인중개사사무소 27
 
0.4%
행복공인중개사사무소 26
 
0.3%
신세계공인중개사사무소 25
 
0.3%
Other values (4759) 7155
94.4%
2024-04-17T11:16:45.279069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
사 13202
16.0%
중 7344
 
8.9%
개 7330
 
8.9%
소 6915
 
8.4%
무 6876
 
8.3%
인 6421
 
7.8%
공 6238
 
7.5%
동 2762
 
3.3%
부 2508
 
3.0%
산 2459
 
3.0%
Other values (617) 20615
24.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80799
97.7%
Uppercase Letter 785
 
0.9%
Space Separator 338
 
0.4%
Decimal Number 331
 
0.4%
Lowercase Letter 166
 
0.2%
Close Punctuation 109
 
0.1%
Open Punctuation 109
 
0.1%
Other Punctuation 22
 
< 0.1%
Dash Punctuation 7
 
< 0.1%
Letter Number 2
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
사 13202
16.3%
중 7344
 
9.1%
개 7330
 
9.1%
소 6915
 
8.6%
무 6876
 
8.5%
인 6421
 
7.9%
공 6238
 
7.7%
동 2762
 
3.4%
부 2508
 
3.1%
산 2459
 
3.0%
Other values (550) 18744
23.2%
Uppercase Letter
ValueCountFrequency (%)
K 148
18.9%
S 99
12.6%
L 66
 
8.4%
T 66
 
8.4%
C 51
 
6.5%
O 48
 
6.1%
W 39
 
5.0%
E 32
 
4.1%
H 29
 
3.7%
B 27
 
3.4%
Other values (15) 180
22.9%
Lowercase Letter
ValueCountFrequency (%)
e 72
43.4%
h 26
 
15.7%
t 14
 
8.4%
c 11
 
6.6%
k 8
 
4.8%
w 8
 
4.8%
s 7
 
4.2%
i 4
 
2.4%
o 4
 
2.4%
n 2
 
1.2%
Other values (8) 10
 
6.0%
Decimal Number
ValueCountFrequency (%)
1 144
43.5%
8 44
 
13.3%
4 39
 
11.8%
2 30
 
9.1%
3 25
 
7.6%
9 21
 
6.3%
5 11
 
3.3%
0 6
 
1.8%
6 6
 
1.8%
7 5
 
1.5%
Other Punctuation
ValueCountFrequency (%)
& 8
36.4%
. 7
31.8%
？ 2
 
9.1%
· 2
 
9.1%
# 1
 
4.5%
, 1
 
4.5%
! 1
 
4.5%
Space Separator
ValueCountFrequency (%)
338
100.0%
Close Punctuation
ValueCountFrequency (%)
) 109
100.0%
Open Punctuation
ValueCountFrequency (%)
( 109
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%
Other Symbol
ValueCountFrequency (%)
ⓡ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80786
97.7%
Latin 953
 
1.2%
Common 918
 
1.1%
Han 13
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
사 13202
16.3%
중 7344
 
9.1%
개 7330
 
9.1%
소 6915
 
8.6%
무 6876
 
8.5%
인 6421
 
7.9%
공 6238
 
7.7%
동 2762
 
3.4%
부 2508
 
3.1%
산 2459
 
3.0%
Other values (538) 18731
23.2%
Latin
ValueCountFrequency (%)
K 148
15.5%
S 99
 
10.4%
e 72
 
7.6%
L 66
 
6.9%
T 66
 
6.9%
C 51
 
5.4%
O 48
 
5.0%
W 39
 
4.1%
E 32
 
3.4%
H 29
 
3.0%
Other values (34) 303
31.8%
Common
ValueCountFrequency (%)
338
36.8%
1 144
15.7%
) 109
 
11.9%
( 109
 
11.9%
8 44
 
4.8%
4 39
 
4.2%
2 30
 
3.3%
3 25
 
2.7%
9 21
 
2.3%
5 11
 
1.2%
Other values (13) 48
 
5.2%
Han
ValueCountFrequency (%)
福 2
15.4%
秀 1
7.7%
人 1
7.7%
太 1
7.7%
利 1
7.7%
甲 1
7.7%
氷 1
7.7%
本 1
7.7%
炫 1
7.7%
堂 1
7.7%
Other values (2) 2
15.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80786
97.7%
ASCII 1864
 
2.3%
CJK 13
 
< 0.1%
None 4
 
< 0.1%
Number Forms 2
 
< 0.1%
Enclosed Alphanum 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
사 13202
16.3%
중 7344
 
9.1%
개 7330
 
9.1%
소 6915
 
8.6%
무 6876
 
8.5%
인 6421
 
7.9%
공 6238
 
7.7%
동 2762
 
3.4%
부 2508
 
3.1%
산 2459
 
3.0%
Other values (538) 18731
23.2%
ASCII
ValueCountFrequency (%)
338
18.1%
K 148
 
7.9%
1 144
 
7.7%
) 109
 
5.8%
( 109
 
5.8%
S 99
 
5.3%
e 72
 
3.9%
L 66
 
3.5%
T 66
 
3.5%
C 51
 
2.7%
Other values (53) 662
35.5%
None
ValueCountFrequency (%)
？ 2
50.0%
· 2
50.0%
CJK
ValueCountFrequency (%)
福 2
15.4%
秀 1
7.7%
人 1
7.7%
太 1
7.7%
利 1
7.7%
甲 1
7.7%
氷 1
7.7%
本 1
7.7%
炫 1
7.7%
堂 1
7.7%
Other values (2) 2
15.4%
Number Forms
ValueCountFrequency (%)
Ⅱ 2
100.0%
Enclosed Alphanum
ValueCountFrequency (%)
ⓡ 1
100.0%

estbsbeginde
Date

MISSING 

Distinct532
Distinct (%)7.3%
Missing94
Missing (%)1.3%
Memory size57.7 KiB
Minimum2010-05-03 00:00:00
Maximum2021-12-04 00:00:00
2024-04-17T11:16:45.387514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T11:16:45.495963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

estbsendde
Date

MISSING 

Distinct532
Distinct (%)7.3%
Missing94
Missing (%)1.3%
Memory size57.7 KiB
Minimum2011-05-02 00:00:00
Maximum2024-11-15 00:00:00
2024-04-17T11:16:45.608605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T11:16:45.712983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

jurirno
Text

Distinct7311
Distinct (%)99.9%
Missing56
Missing (%)0.8%
Memory size57.7 KiB
2024-04-17T11:16:45.911615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length16
Mean length13.428454
Min length6

Characters and Unicode

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

Unique

Unique7305 ?
Unique (%)99.8%

Sample

1st row가-01-574
2nd row가-05-2597
3rd row가-01-579
4th row26110-2015-00020
5th row가-01-554
ValueCountFrequency (%)
26230-2017-00146 2
 
< 0.1%
26410-2016-00056 2
 
< 0.1%
가 2
 
< 0.1%
가-11-2094 2
 
< 0.1%
2
 
< 0.1%
26440-2019-00095 2
 
< 0.1%
가-14-1196 2
 
< 0.1%
26470-2015-00086 2
 
< 0.1%
26440-2020-00106 1
 
< 0.1%
26440-2020-00109 1
 
< 0.1%
Other values (7304) 7304
99.8%
2024-04-17T11:16:46.227031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 27557
28.0%
2 15498
15.8%
- 14564
14.8%
1 9885
 
10.1%
6 7637
 
7.8%
3 4178
 
4.3%
4 3856
 
3.9%
5 3679
 
3.7%
7 3171
 
3.2%
9 2999
 
3.1%
Other values (4) 5232
 
5.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 81142
82.6%
Dash Punctuation 14564
 
14.8%
Other Letter 2545
 
2.6%
Space Separator 5
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 27557
34.0%
2 15498
19.1%
1 9885
 
12.2%
6 7637
 
9.4%
3 4178
 
5.1%
4 3856
 
4.8%
5 3679
 
4.5%
7 3171
 
3.9%
9 2999
 
3.7%
8 2682
 
3.3%
Other Letter
ValueCountFrequency (%)
가 2515
98.8%
나 30
 
1.2%
Dash Punctuation
ValueCountFrequency (%)
- 14564
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 95711
97.4%
Hangul 2545
 
2.6%

Most frequent character per script

Common
ValueCountFrequency (%)
0 27557
28.8%
2 15498
16.2%
- 14564
15.2%
1 9885
 
10.3%
6 7637
 
8.0%
3 4178
 
4.4%
4 3856
 
4.0%
5 3679
 
3.8%
7 3171
 
3.3%
9 2999
 
3.1%
Other values (2) 2687
 
2.8%
Hangul
ValueCountFrequency (%)
가 2515
98.8%
나 30
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 95711
97.4%
Hangul 2545
 
2.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 27557
28.8%
2 15498
16.2%
- 14564
15.2%
1 9885
 
10.3%
6 7637
 
8.0%
3 4178
 
4.4%
4 3856
 
4.0%
5 3679
 
3.8%
7 3171
 
3.3%
9 2999
 
3.1%
Other values (2) 2687
 
2.8%
Hangul
ValueCountFrequency (%)
가 2515
98.8%
나 30
 
1.2%

lastupdtdt
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
2021-01-02
7373 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-01-02
2nd row2021-01-02
3rd row2021-01-02
4th row2021-01-02
5th row2021-01-02

Common Values

ValueCountFrequency (%)
2021-01-02 7373
100.0%

Length

2024-04-17T11:16:46.337188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T11:16:46.412924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-01-02 7373
100.0%

ldcode
Real number (ℝ)

HIGH CORRELATION 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26369.71
Minimum26110
Maximum26710
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size64.9 KiB
2024-04-17T11:16:46.486023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum26110
5-th percentile26170
Q126260
median26350
Q326470
95-th percentile26710
Maximum26710
Range600
Interquartile range (IQR)210

Descriptive statistics

Standard deviation133.86507
Coefficient of variation (CV)0.005076471
Kurtosis0.37058791
Mean26369.71
Median Absolute Deviation (MAD)90
Skewness0.60553043
Sum1.9442387 × 108
Variance17919.856
MonotonicityNot monotonic
2024-04-17T11:16:46.592301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=16)
ValueCountFrequency (%)
26350 925
12.5%
26230 836
11.3%
26260 664
9.0%
26470 602
8.2%
26440 579
7.9%
26500 536
7.3%
26410 525
7.1%
26290 522
7.1%
26380 466
 
6.3%
26710 428
 
5.8%
Other values (6) 1290
17.5%
ValueCountFrequency (%)
26110 126
 
1.7%
26140 155
 
2.1%
26170 159
 
2.2%
26200 128
 
1.7%
26230 836
11.3%
26260 664
9.0%
26290 522
7.1%
26320 414
5.6%
26350 925
12.5%
26380 466
6.3%
ValueCountFrequency (%)
26710 428
5.8%
26530 308
 
4.2%
26500 536
7.3%
26470 602
8.2%
26440 579
7.9%
26410 525
7.1%
26380 466
6.3%
26350 925
12.5%
26320 414
5.6%
26290 522
7.1%

ldcodenm
Categorical

HIGH CORRELATION 

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
부산광역시 해운대구
925 
부산광역시 부산진구
836 
부산광역시 동래구
664 
부산광역시 연제구
602 
부산광역시 강서구
579 
Other values (11)
3767 

Length

Max length10
Median length9
Mean length9.0522176
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row부산광역시 중구
2nd row부산광역시 중구
3rd row부산광역시 중구
4th row부산광역시 중구
5th row부산광역시 중구

Common Values

ValueCountFrequency (%)
부산광역시 해운대구 925
12.5%
부산광역시 부산진구 836
11.3%
부산광역시 동래구 664
9.0%
부산광역시 연제구 602
8.2%
부산광역시 강서구 579
7.9%
부산광역시 수영구 536
7.3%
부산광역시 금정구 525
7.1%
부산광역시 남구 522
7.1%
부산광역시 사하구 466
 
6.3%
부산광역시 기장군 428
 
5.8%
Other values (6) 1290
17.5%

Length

2024-04-17T11:16:46.696877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부산광역시 7373
50.0%
해운대구 925
 
6.3%
부산진구 836
 
5.7%
동래구 664
 
4.5%
연제구 602
 
4.1%
강서구 579
 
3.9%
수영구 536
 
3.6%
금정구 525
 
3.6%
남구 522
 
3.5%
사하구 466
 
3.2%
Other values (7) 1718
 
11.7%

registde
Date

Distinct3177
Distinct (%)43.1%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
Minimum1984-04-24 00:00:00
Maximum2020-12-29 00:00:00
2024-04-17T11:16:46.824443image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T11:16:46.943156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

sttussecode
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
1
7338 
2
 
27
8
 
4
3
 
4

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 7338
99.5%
2 27
 
0.4%
8 4
 
0.1%
3 4
 
0.1%

Length

2024-04-17T11:16:47.046880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T11:16:47.127225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 7338
99.5%
2 27
 
0.4%
8 4
 
0.1%
3 4
 
0.1%

sttussecodenm
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct4
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
영업중
7338 
휴업
 
27
업무정지
 
4
휴업연장
 
4

Length

Max length4
Median length3
Mean length2.997423
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 7338
99.5%
휴업 27
 
0.4%
업무정지 4
 
0.1%
휴업연장 4
 
0.1%

Length

2024-04-17T11:16:47.248646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T11:16:47.362282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 7338
99.5%
휴업 27
 
0.4%
업무정지 4
 
0.1%
휴업연장 4
 
0.1%

telnolist
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing7373
Missing (%)100.0%
Memory size64.9 KiB

last_load_dttm
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size57.7 KiB
2021-01-06 13:36:16
7373 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-01-06 13:36:16
2nd row2021-01-06 13:36:16
3rd row2021-01-06 13:36:16
4th row2021-01-06 13:36:16
5th row2021-01-06 13:36:16

Common Values

ValueCountFrequency (%)
2021-01-06 13:36:16 7373
100.0%

Length

2024-04-17T11:16:47.447329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T11:16:47.522910image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-01-06 7373
50.0%
13:36:16 7373
50.0%

Interactions

2024-04-17T11:16:43.783030image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T11:16:47.570758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ldcodeldcodenmsttussecodesttussecodenm
ldcode1.0001.0000.0570.057
ldcodenm1.0001.0000.0780.078
sttussecode0.0570.0781.0001.000
sttussecodenm0.0570.0781.0001.000
2024-04-17T11:16:47.642925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
sttussecodeldcodenmsttussecodenm
sttussecode1.0000.0371.000
ldcodenm0.0371.0000.037
sttussecodenm1.0000.0371.000
2024-04-17T11:16:47.715724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ldcodeldcodenmsttussecodesttussecodenm
ldcode1.0000.9990.0230.023
ldcodenm0.9991.0000.0370.037
sttussecode0.0230.0371.0001.000
sttussecodenm0.0230.0371.0001.000

Missing values

2024-04-17T11:16:43.889602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T11:16:44.028563image/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.
2024-04-17T11:16:44.141825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

brkrnmbsnmcmpnmestbsbegindeestbsenddejurirnolastupdtdtldcodeldcodenmregistdesttussecodesttussecodenmtelnolistlast_load_dttm
0임양운삼보공인중개사사무소2020-10-102021-10-09가-01-5742021-01-0226110부산광역시 중구2006-10-101영업중<NA>2021-01-06 13:36:16
1김중의롯데부동산중개사무소2020-11-212021-11-20가-05-25972021-01-0226110부산광역시 중구2006-11-281영업중<NA>2021-01-06 13:36:16
2이민우신우공인중개사사무소2019-02-202024-02-19가-01-5792021-01-0226110부산광역시 중구2007-02-201영업중<NA>2021-01-06 13:36:16
3김경숙금호우리공인중개사사무소2020-11-252021-11-2426110-2015-000202021-01-0226110부산광역시 중구2007-03-211영업중<NA>2021-01-06 13:36:16
4김영수천지공인2020-03-262021-03-25가-01-5542021-01-0226110부산광역시 중구2007-10-181영업중<NA>2021-01-06 13:36:16
5강호근OK공인중개사사무소2020-06-092021-06-08가-01-6012021-01-0226110부산광역시 중구2009-06-261영업중<NA>2021-01-06 13:36:16
6백수현굿모닝 공인중개사2020-03-092021-03-08가-01-5442021-01-0226110부산광역시 중구2004-03-221영업중<NA>2021-01-06 13:36:16
7김홍숙부원공인중개사2020-12-182021-12-17가-01-5952021-01-0226110부산광역시 중구2009-07-201영업중<NA>2021-01-06 13:36:16
8강영지신창부동산2020-09-042021-09-03가-01-5732021-01-0226110부산광역시 중구2006-09-061영업중<NA>2021-01-06 13:36:16
9정인수금터공인중개사2020-11-232021-11-22가-01-6062021-01-0226110부산광역시 중구2009-11-131영업중<NA>2021-01-06 13:36:16
brkrnmbsnmcmpnmestbsbegindeestbsenddejurirnolastupdtdtldcodeldcodenmregistdesttussecodesttussecodenmtelnolistlast_load_dttm
7363이서영일광퀸부동산공인중개사사무소2020-03-272021-03-26가16-9662021-01-0226710부산광역시 기장군2012-03-271영업중<NA>2021-01-06 13:36:16
7364하화정강남공인중개사사무소2020-05-012021-04-30가16-9722021-01-0226710부산광역시 기장군2012-04-241영업중<NA>2021-01-06 13:36:16
7365서창열부자공인중개사사무소2020-06-082021-06-07가16-9842021-01-0226710부산광역시 기장군2012-06-071영업중<NA>2021-01-06 13:36:16
7366선은미롯데캐슬부동산공인중개사사무소2020-08-162021-08-15가16-9922021-01-0226710부산광역시 기장군2012-08-161영업중<NA>2021-01-06 13:36:16
7367한성희크로바공인중개사사무소2020-12-202021-12-19가16-10142021-01-0226710부산광역시 기장군2012-12-201영업중<NA>2021-01-06 13:36:16
7368김성훈여명컨설팅공인중개사사무소2020-12-232021-12-22가16-10172021-01-0226710부산광역시 기장군2012-12-211영업중<NA>2021-01-06 13:36:16
7369윤학순기장우리들공인중개사사무소2020-01-062021-01-05가-16-10272021-01-0226710부산광역시 기장군2013-01-041영업중<NA>2021-01-06 13:36:16
7370최해정제일부동산공인중개사사무소2020-01-152021-01-14가16-10302021-01-0226710부산광역시 기장군2013-01-151영업중<NA>2021-01-06 13:36:16
7371황숙이서희스타힐스부동산공인중개사사무소2020-02-042021-02-03가16-10372021-01-0226710부산광역시 기장군2013-02-041영업중<NA>2021-01-06 13:36:16
7372최권세알파부동산공인중개사사무소2020-04-082021-04-07가16-10492021-01-0226710부산광역시 기장군2013-03-081영업중<NA>2021-01-06 13:36:16

Duplicate rows

Most frequently occurring

brkrnmbsnmcmpnmestbsbegindeestbsenddejurirnolastupdtdtldcodeldcodenmregistdesttussecodesttussecodenmlast_load_dttm# duplicates
4<NA><NA><NA><NA><NA>2021-01-0226380부산광역시 사하구2012-10-291영업중2021-01-06 13:36:166
0박성진법무공인중개사사무소2020-02-162021-02-15가-14-11962021-01-0226500부산광역시 수영구2012-01-271영업중2021-01-06 13:36:162
1<NA>삼성명가부동산중개2014-06-122015-06-11가-11-20942021-01-0226410부산광역시 금정구2013-06-121영업중2021-01-06 13:36:162
2<NA><NA><NA><NA><NA>2021-01-0226140부산광역시 서구2015-06-101영업중2021-01-06 13:36:162
3<NA><NA><NA><NA><NA>2021-01-0226170부산광역시 동구2013-08-281영업중2021-01-06 13:36:162