Overview

Dataset statistics

Number of variables13
Number of observations23
Missing cells6
Missing cells (%)2.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.5 KiB
Average record size in memory109.7 B

Variable types

Text1
Unsupported12

Alerts

Unnamed: 2 has 1 (4.3%) missing valuesMissing
Unnamed: 4 has 1 (4.3%) missing valuesMissing
Unnamed: 6 has 1 (4.3%) missing valuesMissing
Unnamed: 8 has 1 (4.3%) missing valuesMissing
Unnamed: 10 has 1 (4.3%) missing valuesMissing
Unnamed: 12 has 1 (4.3%) missing valuesMissing
부안해역에서 어획된 품종별 개체수 및 현존량(2016년) has unique valuesUnique
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:48:29.508111
Analysis finished2024-03-14 01:48:29.918648
Duration0.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2024-03-14T10:48:30.083954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26
Mean length21.73913
Min length2

Characters and Unicode

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

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row일자
2nd row구분
3rd row가숭어(Chelon haematocheiius)
4th row갯가재(Oratosquilla oratoria)
5th row꽃게(Portunus trituberculatus)
ValueCountFrequency (%)
일자 1
 
2.3%
참갑오징어(sepia 1
 
2.3%
어름돔(plectorhinchus 1
 
2.3%
cinctus 1
 
2.3%
점농어(lateolabrax 1
 
2.3%
maculatus 1
 
2.3%
조피볼락(sebastes 1
 
2.3%
schlegelii 1
 
2.3%
쥐노래미(hexagrammos 1
 
2.3%
otakii 1
 
2.3%
Other values (33) 33
76.7%
2024-03-14T10:48:30.430986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
a 44
 
8.8%
s 38
 
7.6%
i 33
 
6.6%
e 25
 
5.0%
o 24
 
4.8%
u 24
 
4.8%
t 24
 
4.8%
l 21
 
4.2%
20
 
4.0%
c 20
 
4.0%
Other values (79) 227
45.4%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 351
70.2%
Other Letter 69
 
13.8%
Space Separator 20
 
4.0%
Open Punctuation 20
 
4.0%
Close Punctuation 20
 
4.0%
Uppercase Letter 20
 
4.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
4
 
5.8%
3
 
4.3%
3
 
4.3%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
Other values (42) 45
65.2%
Lowercase Letter
ValueCountFrequency (%)
a 44
12.5%
s 38
10.8%
i 33
9.4%
e 25
 
7.1%
o 24
 
6.8%
u 24
 
6.8%
t 24
 
6.8%
l 21
 
6.0%
c 20
 
5.7%
h 16
 
4.6%
Other values (14) 82
23.4%
Uppercase Letter
ValueCountFrequency (%)
P 4
20.0%
S 4
20.0%
C 3
15.0%
L 2
10.0%
H 2
10.0%
R 1
 
5.0%
O 1
 
5.0%
Z 1
 
5.0%
T 1
 
5.0%
N 1
 
5.0%
Space Separator
ValueCountFrequency (%)
20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 371
74.2%
Hangul 69
 
13.8%
Common 60
 
12.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
4
 
5.8%
3
 
4.3%
3
 
4.3%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
Other values (42) 45
65.2%
Latin
ValueCountFrequency (%)
a 44
11.9%
s 38
 
10.2%
i 33
 
8.9%
e 25
 
6.7%
o 24
 
6.5%
u 24
 
6.5%
t 24
 
6.5%
l 21
 
5.7%
c 20
 
5.4%
h 16
 
4.3%
Other values (24) 102
27.5%
Common
ValueCountFrequency (%)
20
33.3%
( 20
33.3%
) 20
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 431
86.2%
Hangul 69
 
13.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 44
 
10.2%
s 38
 
8.8%
i 33
 
7.7%
e 25
 
5.8%
o 24
 
5.6%
u 24
 
5.6%
t 24
 
5.6%
l 21
 
4.9%
20
 
4.6%
c 20
 
4.6%
Other values (27) 158
36.7%
Hangul
ValueCountFrequency (%)
4
 
5.8%
3
 
4.3%
3
 
4.3%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
2
 
2.9%
Other values (42) 45
65.2%

Unnamed: 1
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Unnamed: 3
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Unnamed: 5
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Unnamed: 7
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Unnamed: 9
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size316.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.3%
Memory size316.0 B

Missing values

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

부안해역에서 어획된 품종별 개체수 및 현존량(2016년)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
0일자3월NaN5월NaN7월NaN9월NaN11월NaN합계NaN
1구분개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)
2가숭어(Chelon haematocheiius)12.5811.8522.643.89810.92
3갯가재(Oratosquilla oratoria)30.130.1
4꽃게(Portunus trituberculatus)10.1816517.8293.2450.7620021.98
5넙치(Paralichthys olivadeus)30.5210.4740.99
6노랑각시서대(Zebrias fasciatus)10.110.1
7말쥐치(Thamnaconus modestus)10.1110.11
8민꽃게(Charybdis japonica)110.43181.9520.0420.17140.75473.34
9박대(Cynoglossus semilaevis)10.5710.57
부안해역에서 어획된 품종별 개체수 및 현존량(2016년)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
13어름돔(Plectorhinchus cinctus)61.8661.86
14점농어(Lateolabrax maculatus)10.1610.16
15조피볼락(Sebastes schlegelii)41.2720.6371.6420.75154.29
16쥐노래미(Hexagrammos otakii)10.0530.3510.2550.65
17참갑오징어(Sepia esculenta)62.8562.85
18참조기(Larimichthys polyactis)251251
19풀망둑(Synechogobius hasta)50.3860.32110.7
20피뿔고둥(Rapana venosa)40.7370.7130.7620.19162.39
21해삼(Stichopus japonicus)10.0610.06
22합계297.27418.6216818.4110015.59388.5737658.46