Overview

Dataset statistics

Number of variables2
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory18.3 B

Variable types

Numeric1
Text1

Alerts

ldgs_deal_id has unique valuesUnique
property_nm has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:03:51.876906
Analysis finished2023-12-10 10:03:52.986532
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

ldgs_deal_id
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30026267
Minimum23184
Maximum1.0001173 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:03:53.187263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum23184
5-th percentile23206.95
Q123278.5
median23493
Q323619.75
95-th percentile23713.2
Maximum1.0001173 × 109
Range1.0000941 × 109
Interquartile range (IQR)341.25

Descriptive statistics

Standard deviation1.7146269 × 108
Coefficient of variation (CV)5.7104233
Kurtosis29.897775
Mean30026267
Median Absolute Deviation (MAD)172
Skewness5.5946495
Sum3.0026267 × 109
Variance2.9399456 × 1016
MonotonicityNot monotonic
2023-12-10T19:03:53.938190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
23184 1
 
1.0%
23559 1
 
1.0%
23606 1
 
1.0%
23602 1
 
1.0%
23600 1
 
1.0%
23594 1
 
1.0%
23589 1
 
1.0%
23587 1
 
1.0%
23585 1
 
1.0%
23583 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
23184 1
1.0%
23196 1
1.0%
23197 1
1.0%
23204 1
1.0%
23206 1
1.0%
23207 1
1.0%
23216 1
1.0%
23223 1
1.0%
23224 1
1.0%
23227 1
1.0%
ValueCountFrequency (%)
1000117284 1
1.0%
1000117281 1
1.0%
1000117277 1
1.0%
23720 1
1.0%
23717 1
1.0%
23713 1
1.0%
23708 1
1.0%
23707 1
1.0%
23704 1
1.0%
23701 1
1.0%

property_nm
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:03:54.562548image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length16
Mean length9.01
Min length4

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row영등포 라이프스타일 F HOTEL
2nd row양평 돌체파르니엔펜션
3rd row대전 신탄진 거기
4th row강남 렉시
5th row대전 유성 시나브로
ValueCountFrequency (%)
호텔 18
 
6.6%
hotel 7
 
2.6%
대전 6
 
2.2%
안산 5
 
1.8%
신촌 4
 
1.5%
신천 4
 
1.5%
포항 4
 
1.5%
무인텔 3
 
1.1%
대잠동 3
 
1.1%
더 3
 
1.1%
Other values (192) 214
79.0%
2023-12-10T19:03:55.438812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
171
 
19.0%
텔 28
 
3.1%
호 24
 
2.7%
천 22
 
2.4%
동 16
 
1.8%
스 16
 
1.8%
안 14
 
1.6%
대 14
 
1.6%
) 14
 
1.6%
( 14
 
1.6%
Other values (232) 568
63.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 613
68.0%
Space Separator 171
 
19.0%
Uppercase Letter 71
 
7.9%
Close Punctuation 14
 
1.6%
Open Punctuation 14
 
1.6%
Decimal Number 10
 
1.1%
Lowercase Letter 4
 
0.4%
Other Punctuation 2
 
0.2%
Dash Punctuation 1
 
0.1%
Math Symbol 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
텔 28
 
4.6%
호 24
 
3.9%
천 22
 
3.6%
동 16
 
2.6%
스 16
 
2.6%
안 14
 
2.3%
대 14
 
2.3%
주 12
 
2.0%
인 12
 
2.0%
신 12
 
2.0%
Other values (195) 443
72.3%
Uppercase Letter
ValueCountFrequency (%)
H 9
12.7%
T 8
11.3%
O 8
11.3%
M 7
9.9%
E 7
9.9%
L 7
9.9%
S 5
7.0%
A 5
7.0%
I 2
 
2.8%
U 2
 
2.8%
Other values (9) 11
15.5%
Decimal Number
ValueCountFrequency (%)
2 3
30.0%
7 2
20.0%
4 1
 
10.0%
5 1
 
10.0%
6 1
 
10.0%
3 1
 
10.0%
9 1
 
10.0%
Lowercase Letter
ValueCountFrequency (%)
l 1
25.0%
e 1
25.0%
t 1
25.0%
o 1
25.0%
Other Punctuation
ValueCountFrequency (%)
. 1
50.0%
& 1
50.0%
Space Separator
ValueCountFrequency (%)
171
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 613
68.0%
Common 213
 
23.6%
Latin 75
 
8.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
텔 28
 
4.6%
호 24
 
3.9%
천 22
 
3.6%
동 16
 
2.6%
스 16
 
2.6%
안 14
 
2.3%
대 14
 
2.3%
주 12
 
2.0%
인 12
 
2.0%
신 12
 
2.0%
Other values (195) 443
72.3%
Latin
ValueCountFrequency (%)
H 9
12.0%
T 8
10.7%
O 8
10.7%
M 7
9.3%
E 7
9.3%
L 7
9.3%
S 5
 
6.7%
A 5
 
6.7%
I 2
 
2.7%
U 2
 
2.7%
Other values (13) 15
20.0%
Common
ValueCountFrequency (%)
171
80.3%
) 14
 
6.6%
( 14
 
6.6%
2 3
 
1.4%
7 2
 
0.9%
4 1
 
0.5%
- 1
 
0.5%
5 1
 
0.5%
6 1
 
0.5%
. 1
 
0.5%
Other values (4) 4
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 613
68.0%
ASCII 288
32.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
171
59.4%
) 14
 
4.9%
( 14
 
4.9%
H 9
 
3.1%
T 8
 
2.8%
O 8
 
2.8%
M 7
 
2.4%
E 7
 
2.4%
L 7
 
2.4%
S 5
 
1.7%
Other values (27) 38
 
13.2%
Hangul
ValueCountFrequency (%)
텔 28
 
4.6%
호 24
 
3.9%
천 22
 
3.6%
동 16
 
2.6%
스 16
 
2.6%
안 14
 
2.3%
대 14
 
2.3%
주 12
 
2.0%
인 12
 
2.0%
신 12
 
2.0%
Other values (195) 443
72.3%

Interactions

2023-12-10T19:03:52.336695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:03:55.629132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ldgs_deal_idproperty_nm
ldgs_deal_id1.0001.000
property_nm1.0001.000

Missing values

2023-12-10T19:03:52.720790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:03:52.910612image/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

ldgs_deal_idproperty_nm
023184영등포 라이프스타일 F HOTEL
11000117277양평 돌체파르니엔펜션
223196대전 신탄진 거기
323197강남 렉시
423204대전 유성 시나브로
523206부천(상동) MY HOTEL
623207역삼 벤
71000117281강화도 야생화카페펜션
823216서울대입구 폭스
923223양재 호텔 신트라
ldgs_deal_idproperty_nm
9023683안산 IMT
9123686광주 곤지암 윌 무인텔
9223693광주 신안동 여기서자자
9323701부천 노블레스
9423704인천(주안) 더자자
9523707경산 러브웨이
9623708포항 영일대 포스
9723713화순 퀸 무인텔
9823717동탄 첼시
9923720김해 어방동 69