Overview

Dataset statistics

Number of variables5
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.2 KiB
Average record size in memory43.3 B

Variable types

Text3
Numeric1
Categorical1

Alerts

hobby_nd_lsr_goods_rnewl_de has constant value ""Constant
hobby_nd_lsr_goods_cd has unique valuesUnique

Reproduction

Analysis started2023-12-10 09:41:24.480881
Analysis finished2023-12-10 09:41:25.620460
Duration1.14 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct56
Distinct (%)56.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:41:25.850621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length6.39
Min length5

Characters and Unicode

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

Unique

Unique31 ?
Unique (%)31.0%

Sample

1st row강원 강릉시
2nd row충북 청주시
3rd row강원 춘천시
4th row강원도 강릉시
5th row강원도 춘천시
ValueCountFrequency (%)
경기 38
 
19.0%
경상북도 17
 
8.5%
대전 7
 
3.5%
부산 7
 
3.5%
경남 6
 
3.0%
경기도 6
 
3.0%
창원시 6
 
3.0%
경북 6
 
3.0%
고양시 6
 
3.0%
경주시 5
 
2.5%
Other values (48) 96
48.0%
2023-12-10T18:41:26.465675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
100
15.6%
79
 
12.4%
68
 
10.6%
44
 
6.9%
29
 
4.5%
27
 
4.2%
24
 
3.8%
19
 
3.0%
17
 
2.7%
15
 
2.3%
Other values (47) 217
34.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 539
84.4%
Space Separator 100
 
15.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
79
 
14.7%
68
 
12.6%
44
 
8.2%
29
 
5.4%
27
 
5.0%
24
 
4.5%
19
 
3.5%
17
 
3.2%
15
 
2.8%
15
 
2.8%
Other values (46) 202
37.5%
Space Separator
ValueCountFrequency (%)
100
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 539
84.4%
Common 100
 
15.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
79
 
14.7%
68
 
12.6%
44
 
8.2%
29
 
5.4%
27
 
5.0%
24
 
4.5%
19
 
3.5%
17
 
3.2%
15
 
2.8%
15
 
2.8%
Other values (46) 202
37.5%
Common
ValueCountFrequency (%)
100
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 539
84.4%
ASCII 100
 
15.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
100
100.0%
Hangul
ValueCountFrequency (%)
79
 
14.7%
68
 
12.6%
44
 
8.2%
29
 
5.4%
27
 
5.0%
24
 
4.5%
19
 
3.5%
17
 
3.2%
15
 
2.8%
15
 
2.8%
Other values (46) 202
37.5%

hobby_nd_lsr_goods_cd
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51659.96
Minimum38438
Maximum77390
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T18:41:26.710255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum38438
5-th percentile46057.7
Q147144.75
median50497.5
Q351403.75
95-th percentile77371.25
Maximum77390
Range38952
Interquartile range (IQR)4259

Descriptive statistics

Standard deviation8772.3618
Coefficient of variation (CV)0.16980969
Kurtosis3.8254457
Mean51659.96
Median Absolute Deviation (MAD)3135
Skewness2.061714
Sum5165996
Variance76954331
MonotonicityNot monotonic
2023-12-10T18:41:26.949037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
51632 1
 
1.0%
47241 1
 
1.0%
77370 1
 
1.0%
47236 1
 
1.0%
47247 1
 
1.0%
77389 1
 
1.0%
73829 1
 
1.0%
77390 1
 
1.0%
77387 1
 
1.0%
47249 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
38438 1
1.0%
38440 1
1.0%
38442 1
1.0%
39149 1
1.0%
44570 1
1.0%
46136 1
1.0%
46323 1
1.0%
46517 1
1.0%
46875 1
1.0%
46883 1
1.0%
ValueCountFrequency (%)
77390 1
1.0%
77389 1
1.0%
77387 1
1.0%
77380 1
1.0%
77376 1
1.0%
77371 1
1.0%
77370 1
1.0%
74935 1
1.0%
73829 1
1.0%
68423 1
1.0%
Distinct97
Distinct (%)97.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:41:27.661545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length34
Mean length24.59
Min length13

Characters and Unicode

Total characters2459
Distinct characters278
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique94 ?
Unique (%)94.0%

Sample

1st row[강원 강릉] 미플 피부관리샵 아미아 이마트 강릉점
2nd row[충북 청주] 미플 피부관리샵 홈플러스 성안점
3rd row[강원 춘천] 엘리시안강촌 월드스키 어린이스키강습
4th row[강원 강릉] 소돌어촌체험마을 커피 체험
5th row[강원 춘천] 동반할인! 세상에 이런 화과자는 없었다!
ValueCountFrequency (%)
경기 40
 
7.1%
미플 33
 
5.8%
피부관리샵 32
 
5.6%
경북 23
 
4.1%
포쉬네일 22
 
3.9%
홈플러스 11
 
1.9%
아미아 11
 
1.9%
가능 11
 
1.9%
예약 11
 
1.9%
이마트 10
 
1.8%
Other values (227) 363
64.0%
2023-12-10T18:41:28.641862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
468
 
19.0%
[ 100
 
4.1%
] 100
 
4.1%
76
 
3.1%
60
 
2.4%
60
 
2.4%
53
 
2.2%
52
 
2.1%
48
 
2.0%
44
 
1.8%
Other values (268) 1398
56.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1711
69.6%
Space Separator 468
 
19.0%
Open Punctuation 116
 
4.7%
Close Punctuation 116
 
4.7%
Other Punctuation 19
 
0.8%
Uppercase Letter 13
 
0.5%
Decimal Number 8
 
0.3%
Math Symbol 5
 
0.2%
Other Symbol 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
76
 
4.4%
60
 
3.5%
60
 
3.5%
53
 
3.1%
52
 
3.0%
48
 
2.8%
44
 
2.6%
39
 
2.3%
37
 
2.2%
37
 
2.2%
Other values (240) 1205
70.4%
Uppercase Letter
ValueCountFrequency (%)
K 2
15.4%
P 2
15.4%
G 2
15.4%
T 1
7.7%
S 1
7.7%
I 1
7.7%
H 1
7.7%
R 1
7.7%
O 1
7.7%
Y 1
7.7%
Decimal Number
ValueCountFrequency (%)
2 3
37.5%
9 1
 
12.5%
1 1
 
12.5%
4 1
 
12.5%
6 1
 
12.5%
8 1
 
12.5%
Other Punctuation
ValueCountFrequency (%)
& 6
31.6%
! 6
31.6%
/ 4
21.1%
, 3
15.8%
Open Punctuation
ValueCountFrequency (%)
[ 100
86.2%
( 16
 
13.8%
Close Punctuation
ValueCountFrequency (%)
] 100
86.2%
) 16
 
13.8%
Math Symbol
ValueCountFrequency (%)
+ 4
80.0%
~ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
468
100.0%
Other Symbol
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1711
69.6%
Common 735
29.9%
Latin 13
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
76
 
4.4%
60
 
3.5%
60
 
3.5%
53
 
3.1%
52
 
3.0%
48
 
2.8%
44
 
2.6%
39
 
2.3%
37
 
2.2%
37
 
2.2%
Other values (240) 1205
70.4%
Common
ValueCountFrequency (%)
468
63.7%
[ 100
 
13.6%
] 100
 
13.6%
( 16
 
2.2%
) 16
 
2.2%
& 6
 
0.8%
! 6
 
0.8%
+ 4
 
0.5%
/ 4
 
0.5%
, 3
 
0.4%
Other values (8) 12
 
1.6%
Latin
ValueCountFrequency (%)
K 2
15.4%
P 2
15.4%
G 2
15.4%
T 1
7.7%
S 1
7.7%
I 1
7.7%
H 1
7.7%
R 1
7.7%
O 1
7.7%
Y 1
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1711
69.6%
ASCII 745
30.3%
Misc Symbols 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
468
62.8%
[ 100
 
13.4%
] 100
 
13.4%
( 16
 
2.1%
) 16
 
2.1%
& 6
 
0.8%
! 6
 
0.8%
+ 4
 
0.5%
/ 4
 
0.5%
, 3
 
0.4%
Other values (17) 22
 
3.0%
Hangul
ValueCountFrequency (%)
76
 
4.4%
60
 
3.5%
60
 
3.5%
53
 
3.1%
52
 
3.0%
48
 
2.8%
44
 
2.6%
39
 
2.3%
37
 
2.2%
37
 
2.2%
Other values (240) 1205
70.4%
Misc Symbols
ValueCountFrequency (%)
3
100.0%
Distinct90
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T18:41:29.098493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length51
Median length34
Mean length19.93
Min length12

Characters and Unicode

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

Unique

Unique81 ?
Unique (%)81.0%

Sample

1st row강원 강릉시 송정동 612-11
2nd row충북 청주시 상당구 사직대로 346
3rd row강원 춘천시 남산면 서백길 75
4th row강원도 강릉시 주문진읍 해안로 1960
5th row강원도 춘천시 춘천로146번길 8, 1층 라비앙로즈
ValueCountFrequency (%)
경기 38
 
7.7%
경상북도 17
 
3.4%
부산 7
 
1.4%
대전 7
 
1.4%
고양시 6
 
1.2%
경기도 6
 
1.2%
경남 6
 
1.2%
창원시 6
 
1.2%
경북 6
 
1.2%
남구 5
 
1.0%
Other values (290) 390
78.9%
2023-12-10T18:41:29.904619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
394
 
19.8%
85
 
4.3%
81
 
4.1%
1 77
 
3.9%
71
 
3.6%
57
 
2.9%
48
 
2.4%
2 44
 
2.2%
41
 
2.1%
3 37
 
1.9%
Other values (197) 1058
53.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1232
61.8%
Space Separator 394
 
19.8%
Decimal Number 333
 
16.7%
Other Punctuation 17
 
0.9%
Dash Punctuation 13
 
0.7%
Close Punctuation 2
 
0.1%
Open Punctuation 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
85
 
6.9%
81
 
6.6%
71
 
5.8%
57
 
4.6%
48
 
3.9%
41
 
3.3%
37
 
3.0%
31
 
2.5%
30
 
2.4%
27
 
2.2%
Other values (181) 724
58.8%
Decimal Number
ValueCountFrequency (%)
1 77
23.1%
2 44
13.2%
3 37
11.1%
7 34
10.2%
4 30
 
9.0%
8 29
 
8.7%
0 24
 
7.2%
5 23
 
6.9%
6 19
 
5.7%
9 16
 
4.8%
Other Punctuation
ValueCountFrequency (%)
, 15
88.2%
. 2
 
11.8%
Space Separator
ValueCountFrequency (%)
394
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1232
61.8%
Common 761
38.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
85
 
6.9%
81
 
6.6%
71
 
5.8%
57
 
4.6%
48
 
3.9%
41
 
3.3%
37
 
3.0%
31
 
2.5%
30
 
2.4%
27
 
2.2%
Other values (181) 724
58.8%
Common
ValueCountFrequency (%)
394
51.8%
1 77
 
10.1%
2 44
 
5.8%
3 37
 
4.9%
7 34
 
4.5%
4 30
 
3.9%
8 29
 
3.8%
0 24
 
3.2%
5 23
 
3.0%
6 19
 
2.5%
Other values (6) 50
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1232
61.8%
ASCII 761
38.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
394
51.8%
1 77
 
10.1%
2 44
 
5.8%
3 37
 
4.9%
7 34
 
4.5%
4 30
 
3.9%
8 29
 
3.8%
0 24
 
3.2%
5 23
 
3.0%
6 19
 
2.5%
Other values (6) 50
 
6.6%
Hangul
ValueCountFrequency (%)
85
 
6.9%
81
 
6.6%
71
 
5.8%
57
 
4.6%
48
 
3.9%
41
 
3.3%
37
 
3.0%
31
 
2.5%
30
 
2.4%
27
 
2.2%
Other values (181) 724
58.8%

hobby_nd_lsr_goods_rnewl_de
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20211130
100 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20211130 100
100.0%

Length

2023-12-10T18:41:30.194522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:41:30.395951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20211130 100
100.0%

Interactions

2023-12-10T18:41:25.135605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:41:30.489693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
area_nmhobby_nd_lsr_goods_cdhobby_nd_lsr_goods_nmhobby_nd_lsr_goods_addr
area_nm1.0000.9211.0001.000
hobby_nd_lsr_goods_cd0.9211.0000.0000.913
hobby_nd_lsr_goods_nm1.0000.0001.0001.000
hobby_nd_lsr_goods_addr1.0000.9131.0001.000

Missing values

2023-12-10T18:41:25.347290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:41:25.544358image/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

area_nmhobby_nd_lsr_goods_cdhobby_nd_lsr_goods_nmhobby_nd_lsr_goods_addrhobby_nd_lsr_goods_rnewl_de
0강원 강릉시51632[강원 강릉] 미플 피부관리샵 아미아 이마트 강릉점강원 강릉시 송정동 612-1120211130
1충북 청주시51388[충북 청주] 미플 피부관리샵 홈플러스 성안점충북 청주시 상당구 사직대로 34620211130
2강원 춘천시50031[강원 춘천] 엘리시안강촌 월드스키 어린이스키강습강원 춘천시 남산면 서백길 7520211130
3강원도 강릉시68423[강원 강릉] 소돌어촌체험마을 커피 체험강원도 강릉시 주문진읍 해안로 196020211130
4강원도 춘천시48321[강원 춘천] 동반할인! 세상에 이런 화과자는 없었다!강원도 춘천시 춘천로146번길 8, 1층 라비앙로즈20211130
5경기 고양시38442[경기 일산] 반지대학 커플링만들기경기 고양시 일산동구 정발산로 3920211130
6경기 고양시47155[경기 고양] 포쉬네일 홈플러스킨텍스점경기 고양시 일산서구 호수로 81720211130
7충북 충주시51170[충북 충주] 미플 마사지&피부관리샵 충주칠금점충북 충주시 봉계1길 5820211130
8경기 고양시51402[경기 고양] 미플 피부관리샵 주엽점경기 고양시 일산서구 강선로 4920211130
9경기 고양시51417[경기 고양] 미플 피부관리샵 아미아 이마트 킨텍스점경기 고양시 일산서구 킨텍스로 17120211130
area_nmhobby_nd_lsr_goods_cdhobby_nd_lsr_goods_nmhobby_nd_lsr_goods_addrhobby_nd_lsr_goods_rnewl_de
90대전 중구46956[대전] 포쉬네일 문화점대전 중구 계백로 169020211130
91대전 중구47138[대전 중구] 포쉬네일 중앙로역점대전 중구 중앙로 14120211130
92대전 중구50992[대전 중구] 미플 피부관리샵 문화점대전 중구 계백로 171520211130
93부산 금정구50978[부산] 미플 피부관리샵 롯데마트 금정점부산 금정구 중앙대로 173120211130
94부산 남구47106[부산 남구] 포쉬네일 스파 부산본점부산 남구 수영로 32420211130
95부산 동래구48291[부산 금정] 동반할인! 내 맘대로 카드지갑, 여권지갑, 키링 만들기부산 동래구 아시아드대로181번길 32 1층 베르데가죽공방20211130
96부산 부산진구46883[부산 부산진구] 포쉬네일 가야점부산 부산진구 가야대로 50620211130
97부산 부산진구51156[부산 진구] 미플 피부관리샵 홈플러스 서면점부산 부산진구 전포1동20211130
98부산 부산진구51358[부산 진구] 피부관리샵 홈플러스 가야점부산 부산진구 가야대로 50620211130
99부산 북구46903[부산] 포쉬네일 덕천점부산 북구 만덕대로 2320211130