Overview

Dataset statistics

Number of variables3
Number of observations33
Missing cells22
Missing cells (%)22.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory924.0 B
Average record size in memory28.0 B

Variable types

Text3

Alerts

도내 상설시장 has 22 (66.7%) missing valuesMissing
Unnamed: 1 has unique valuesUnique
Unnamed: 2 has unique valuesUnique

Reproduction

Analysis started2024-03-14 01:15:35.176848
Analysis finished2024-03-14 01:15:35.392930
Duration0.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

도내 상설시장
Text

MISSING 

Distinct11
Distinct (%)100.0%
Missing22
Missing (%)66.7%
Memory size396.0 B
2024-03-14T10:15:35.471326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length9
Median length9
Mean length7.9090909
Min length4

Characters and Unicode

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

Unique

Unique11 ?
Unique (%)100.0%

Sample

1st row시 군 명
2nd row9 시군
3rd row전 주 시(6)
4th row군 산 시(7)
5th row익 산 시(7)
ValueCountFrequency (%)
군 5
 
13.2%
시 4
 
10.5%
2 3
 
7.9%
주 2
 
5.3%
산 2
 
5.3%
시(7 2
 
5.3%
1 2
 
5.3%
원 1
 
2.6%
부 1
 
2.6%
실 1
 
2.6%
Other values (15) 15
39.5%
2024-03-14T10:15:35.722502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
27
31.0%
( 9
 
10.3%
) 9
 
10.3%
시 8
 
9.2%
군 6
 
6.9%
2 3
 
3.4%
주 2
 
2.3%
1 2
 
2.3%
산 2
 
2.3%
7 2
 
2.3%
Other values (17) 17
19.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 32
36.8%
Space Separator 27
31.0%
Decimal Number 10
 
11.5%
Open Punctuation 9
 
10.3%
Close Punctuation 9
 
10.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 8
25.0%
군 6
18.8%
주 2
 
6.2%
산 2
 
6.2%
제 1
 
3.1%
완 1
 
3.1%
임 1
 
3.1%
실 1
 
3.1%
부 1
 
3.1%
김 1
 
3.1%
Other values (8) 8
25.0%
Decimal Number
ValueCountFrequency (%)
2 3
30.0%
1 2
20.0%
7 2
20.0%
3 1
 
10.0%
6 1
 
10.0%
9 1
 
10.0%
Space Separator
ValueCountFrequency (%)
27
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 55
63.2%
Hangul 32
36.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 8
25.0%
군 6
18.8%
주 2
 
6.2%
산 2
 
6.2%
제 1
 
3.1%
완 1
 
3.1%
임 1
 
3.1%
실 1
 
3.1%
부 1
 
3.1%
김 1
 
3.1%
Other values (8) 8
25.0%
Common
ValueCountFrequency (%)
27
49.1%
( 9
 
16.4%
) 9
 
16.4%
2 3
 
5.5%
1 2
 
3.6%
7 2
 
3.6%
3 1
 
1.8%
6 1
 
1.8%
9 1
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 55
63.2%
Hangul 32
36.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
27
49.1%
( 9
 
16.4%
) 9
 
16.4%
2 3
 
5.5%
1 2
 
3.6%
7 2
 
3.6%
3 1
 
1.8%
6 1
 
1.8%
9 1
 
1.8%
Hangul
ValueCountFrequency (%)
시 8
25.0%
군 6
18.8%
주 2
 
6.2%
산 2
 
6.2%
제 1
 
3.1%
완 1
 
3.1%
임 1
 
3.1%
실 1
 
3.1%
부 1
 
3.1%
김 1
 
3.1%
Other values (8) 8
25.0%

Unnamed: 1
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2024-03-14T10:15:35.888096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length4
Mean length4.4848485
Min length3

Characters and Unicode

Total characters148
Distinct characters53
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

Unique33 ?
Unique (%)100.0%

Sample

1st row시 장 명
2nd row합 계
3rd row남부 시장
4th row중앙 시장
5th row모래내 시장
ValueCountFrequency (%)
시장 5
 
12.2%
시 1
 
2.4%
용남시장 1
 
2.4%
신동시장 1
 
2.4%
서동시장 1
 
2.4%
매일시장 1
 
2.4%
북부시장 1
 
2.4%
익산구시장 1
 
2.4%
샘고을시장 1
 
2.4%
연지시장 1
 
2.4%
Other values (27) 27
65.9%
2024-03-14T10:15:36.192055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
시 31
20.9%
장 31
20.9%
8
 
5.4%
부 6
 
4.1%
산 4
 
2.7%
남 3
 
2.0%
중 3
 
2.0%
앙 3
 
2.0%
동 3
 
2.0%
합 3
 
2.0%
Other values (43) 53
35.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 140
94.6%
Space Separator 8
 
5.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
시 31
22.1%
장 31
22.1%
부 6
 
4.3%
산 4
 
2.9%
남 3
 
2.1%
중 3
 
2.1%
앙 3
 
2.1%
동 3
 
2.1%
합 3
 
2.1%
신 3
 
2.1%
Other values (42) 50
35.7%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 140
94.6%
Common 8
 
5.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
시 31
22.1%
장 31
22.1%
부 6
 
4.3%
산 4
 
2.9%
남 3
 
2.1%
중 3
 
2.1%
앙 3
 
2.1%
동 3
 
2.1%
합 3
 
2.1%
신 3
 
2.1%
Other values (42) 50
35.7%
Common
ValueCountFrequency (%)
8
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 140
94.6%
ASCII 8
 
5.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
시 31
22.1%
장 31
22.1%
부 6
 
4.3%
산 4
 
2.9%
남 3
 
2.1%
중 3
 
2.1%
앙 3
 
2.1%
동 3
 
2.1%
합 3
 
2.1%
신 3
 
2.1%
Other values (42) 50
35.7%
ASCII
ValueCountFrequency (%)
8
100.0%

Unnamed: 2
Text

UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2024-03-14T10:15:36.384543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length9.0909091
Min length5

Characters and Unicode

Total characters300
Distinct characters75
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

Unique33 ?
Unique (%)100.0%

Sample

1st row시장소재지
2nd row31개 시장
3rd row완산구 풍남문1길 19-3
4th row완산구 태평3길 70
5th row덕진구 모래내4길 8-8
ValueCountFrequency (%)
완산구 5
 
6.3%
중앙로3길 2
 
2.5%
인북로 2
 
2.5%
중앙로 2
 
2.5%
20 2
 
2.5%
18 2
 
2.5%
시장소재지 1
 
1.3%
연지시장3길 1
 
1.3%
10 1
 
1.3%
동헌길 1
 
1.3%
Other values (60) 60
75.9%
2024-03-14T10:15:36.668108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
46
 
15.3%
길 23
 
7.7%
1 21
 
7.0%
3 18
 
6.0%
2 14
 
4.7%
로 13
 
4.3%
9 8
 
2.7%
- 7
 
2.3%
8 7
 
2.3%
5 6
 
2.0%
Other values (65) 137
45.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 151
50.3%
Decimal Number 96
32.0%
Space Separator 46
 
15.3%
Dash Punctuation 7
 
2.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
길 23
 
15.2%
로 13
 
8.6%
산 6
 
4.0%
구 6
 
4.0%
동 5
 
3.3%
완 5
 
3.3%
중 4
 
2.6%
앙 4
 
2.6%
시 4
 
2.6%
평 4
 
2.6%
Other values (53) 77
51.0%
Decimal Number
ValueCountFrequency (%)
1 21
21.9%
3 18
18.8%
2 14
14.6%
9 8
 
8.3%
8 7
 
7.3%
5 6
 
6.2%
4 6
 
6.2%
6 6
 
6.2%
0 6
 
6.2%
7 4
 
4.2%
Space Separator
ValueCountFrequency (%)
46
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 151
50.3%
Common 149
49.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
길 23
 
15.2%
로 13
 
8.6%
산 6
 
4.0%
구 6
 
4.0%
동 5
 
3.3%
완 5
 
3.3%
중 4
 
2.6%
앙 4
 
2.6%
시 4
 
2.6%
평 4
 
2.6%
Other values (53) 77
51.0%
Common
ValueCountFrequency (%)
46
30.9%
1 21
14.1%
3 18
 
12.1%
2 14
 
9.4%
9 8
 
5.4%
- 7
 
4.7%
8 7
 
4.7%
5 6
 
4.0%
4 6
 
4.0%
6 6
 
4.0%
Other values (2) 10
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 151
50.3%
ASCII 149
49.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
46
30.9%
1 21
14.1%
3 18
 
12.1%
2 14
 
9.4%
9 8
 
5.4%
- 7
 
4.7%
8 7
 
4.7%
5 6
 
4.0%
4 6
 
4.0%
6 6
 
4.0%
Other values (2) 10
 
6.7%
Hangul
ValueCountFrequency (%)
길 23
 
15.2%
로 13
 
8.6%
산 6
 
4.0%
구 6
 
4.0%
동 5
 
3.3%
완 5
 
3.3%
중 4
 
2.6%
앙 4
 
2.6%
시 4
 
2.6%
평 4
 
2.6%
Other values (53) 77
51.0%

Correlations

2024-03-14T10:15:36.774278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도내 상설시장Unnamed: 1Unnamed: 2
도내 상설시장1.0001.0001.000
Unnamed: 11.0001.0001.000
Unnamed: 21.0001.0001.000

Missing values

2024-03-14T10:15:35.313972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T10:15:35.368989image/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

도내 상설시장Unnamed: 1Unnamed: 2
0시 군 명시 장 명시장소재지
19 시군합 계31개 시장
2전 주 시(6)남부 시장완산구 풍남문1길 19-3
3<NA>중앙 시장완산구 태평3길 70
4<NA>모래내 시장덕진구 모래내4길 8-8
5<NA>동부 시장완산구 충경로 109
6<NA>서부 시장완산구 효동2길 18
7<NA>신중앙시장전주시 완산구 태평5길 33
8군 산 시(7)공설시장신금길 18
9<NA>신영시장동신영길 36
도내 상설시장Unnamed: 1Unnamed: 2
23<NA>연지시장연지시장3길 50-9
24남 원 시 (1)용남시장동헌길 10
25김 제 시 (3)김제시장사정거리1길 20
26<NA>금만시장동서7길 23
27<NA>역전시장중앙로 288
28완 주 군 (2)고산시장고산면 남봉로 134
29<NA>삼례시장삼례읍 남서신길 9-19
30임 실 군 (1)오수시장오수면 오수로 156-2
31부 안 군 (2)부안시장부안읍 부풍로 47
32<NA>줄포시장줄포면 부안로 865