Overview

Dataset statistics

Number of variables13
Number of observations28
Missing cells156
Missing cells (%)42.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.0 KiB
Average record size in memory108.7 B

Variable types

Text1
Unsupported12

Alerts

Unnamed: 1 has 17 (60.7%) missing valuesMissing
Unnamed: 2 has 18 (64.3%) missing valuesMissing
Unnamed: 3 has 13 (46.4%) missing valuesMissing
Unnamed: 4 has 14 (50.0%) missing valuesMissing
Unnamed: 5 has 13 (46.4%) missing valuesMissing
Unnamed: 6 has 14 (50.0%) missing valuesMissing
Unnamed: 7 has 12 (42.9%) missing valuesMissing
Unnamed: 8 has 13 (46.4%) missing valuesMissing
Unnamed: 9 has 20 (71.4%) missing valuesMissing
Unnamed: 10 has 21 (75.0%) missing valuesMissing
Unnamed: 12 has 1 (3.6%) missing valuesMissing
부안해역에서 어획된 품종별 개체수 및 현존량(2014년) 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 00:30:56.901651
Analysis finished2024-03-14 00:30:57.364636
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

부안해역에서 어획된 품종별 개체수 및 현존량(2014년)
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2024-03-14T09:30:57.522219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length26.5
Mean length21.714286
Min length2

Characters and Unicode

Total characters608
Distinct characters95
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

Unique28 ?
Unique (%)100.0%

Sample

1st row일자
2nd row구분
3rd row조피볼락(Sebastes schlegelii)
4th row쑤기미(Inimicus japonicus)
5th row일지말락쏠치(Minous monodactylus)
ValueCountFrequency (%)
일자 1
 
1.9%
꽃게(portunus 1
 
1.9%
tanakae 1
 
1.9%
어름돔(plectorhinchus 1
 
1.9%
cinctus 1
 
1.9%
수조기(nivea 1
 
1.9%
albiflora 1
 
1.9%
보구치(pennahia 1
 
1.9%
argentata 1
 
1.9%
말쥐치(thamnaconus 1
 
1.9%
Other values (44) 44
81.5%
2024-03-14T09:30:57.845852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
a 60
 
9.9%
s 38
 
6.2%
e 32
 
5.3%
u 32
 
5.3%
i 32
 
5.3%
o 31
 
5.1%
26
 
4.3%
t 26
 
4.3%
l 25
 
4.1%
) 25
 
4.1%
Other values (85) 281
46.2%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 421
69.2%
Other Letter 86
 
14.1%
Space Separator 26
 
4.3%
Close Punctuation 25
 
4.1%
Open Punctuation 25
 
4.1%
Uppercase Letter 25
 
4.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
치 7
 
8.1%
어 4
 
4.7%
미 4
 
4.7%
기 3
 
3.5%
가 3
 
3.5%
꽃 2
 
2.3%
자 2
 
2.3%
게 2
 
2.3%
돔 2
 
2.3%
참 2
 
2.3%
Other values (47) 55
64.0%
Lowercase Letter
ValueCountFrequency (%)
a 60
14.3%
s 38
 
9.0%
e 32
 
7.6%
u 32
 
7.6%
i 32
 
7.6%
o 31
 
7.4%
t 26
 
6.2%
l 25
 
5.9%
n 24
 
5.7%
r 22
 
5.2%
Other values (14) 99
23.5%
Uppercase Letter
ValueCountFrequency (%)
P 8
32.0%
S 4
16.0%
C 2
 
8.0%
O 2
 
8.0%
L 2
 
8.0%
H 2
 
8.0%
R 1
 
4.0%
T 1
 
4.0%
N 1
 
4.0%
M 1
 
4.0%
Space Separator
ValueCountFrequency (%)
26
100.0%
Close Punctuation
ValueCountFrequency (%)
) 25
100.0%
Open Punctuation
ValueCountFrequency (%)
( 25
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 446
73.4%
Hangul 86
 
14.1%
Common 76
 
12.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
치 7
 
8.1%
어 4
 
4.7%
미 4
 
4.7%
기 3
 
3.5%
가 3
 
3.5%
꽃 2
 
2.3%
자 2
 
2.3%
게 2
 
2.3%
돔 2
 
2.3%
참 2
 
2.3%
Other values (47) 55
64.0%
Latin
ValueCountFrequency (%)
a 60
13.5%
s 38
 
8.5%
e 32
 
7.2%
u 32
 
7.2%
i 32
 
7.2%
o 31
 
7.0%
t 26
 
5.8%
l 25
 
5.6%
n 24
 
5.4%
r 22
 
4.9%
Other values (25) 124
27.8%
Common
ValueCountFrequency (%)
26
34.2%
) 25
32.9%
( 25
32.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 522
85.9%
Hangul 86
 
14.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 60
 
11.5%
s 38
 
7.3%
e 32
 
6.1%
u 32
 
6.1%
i 32
 
6.1%
o 31
 
5.9%
26
 
5.0%
t 26
 
5.0%
l 25
 
4.8%
) 25
 
4.8%
Other values (28) 195
37.4%
Hangul
ValueCountFrequency (%)
치 7
 
8.1%
어 4
 
4.7%
미 4
 
4.7%
기 3
 
3.5%
가 3
 
3.5%
꽃 2
 
2.3%
자 2
 
2.3%
게 2
 
2.3%
돔 2
 
2.3%
참 2
 
2.3%
Other values (47) 55
64.0%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)60.7%
Memory size356.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)64.3%
Memory size356.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)46.4%
Memory size356.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)50.0%
Memory size356.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)46.4%
Memory size356.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)50.0%
Memory size356.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)42.9%
Memory size356.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)46.4%
Memory size356.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing20
Missing (%)71.4%
Memory size356.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing21
Missing (%)75.0%
Memory size356.0 B

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

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

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.6%
Memory size356.0 B

Missing values

2024-03-14T09:30:57.000533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:30:57.145675image/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-14T09:30:57.267953image/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

부안해역에서 어획된 품종별 개체수 및 현존량(2014년)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
0일자3월NaN5월NaN7월NaN9월NaN11월NaN합계NaN
1구분개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)개체수(마리)현존량(㎏)
2조피볼락(Sebastes schlegelii)10.1471.6551.4164.027624.710531.91
3쑤기미(Inimicus japonicus)NaNNaNNaNNaN232.92101.56NaNNaN334.48
4일지말락쏠치(Minous monodactylus)NaNNaNNaNNaNNaNNaN10.07NaNNaN10.07
5삼세기(Hemitripterus villosus)72.28NaNNaNNaNNaNNaNNaN20.792.98
6노래미(Hexagrammos agrammus)NaNNaN10.09NaNNaN20.2NaNNaN30.29
7넙치(Paralichthys olivadeus)NaNNaNNaNNaNNaNNaN113.4941.4154.89
8별넙치(Pseudorhombus cinnamoneus)NaNNaNNaNNaNNaNNaN20.2NaNNaN20.2
9문치가자미(Pleuronectes yokohamae)20.19NaNNaNNaNNaNNaNNaNNaNNaN20.19
부안해역에서 어획된 품종별 개체수 및 현존량(2014년)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
18보구치(Pennahia argentata)NaNNaN10.0710.04NaNNaNNaNNaN20.11
19말쥐치(Thamnaconus modestus)NaNNaNNaNNaN10.3NaNNaNNaNNaN10.3
20날매퉁이(Saurida elongata)NaNNaNNaNNaNNaNNaN10.45NaNNaN10.45
21꽃게(Portunus trituberculatus)10.03NaNNaN536.6223.75NaNNaN7610.38
22민꽃게(Charybdis japonica)30.13120.91674.7653.48121.415910.62
23갯가재(Oratosquilla oratoria)30.0720.0220.0210.03NaNNaN80.14
24참갑오징어(Sepia esculenta)NaNNaN10.33309.9NaNNaNNaNNaN3110.23
25주꾸미(Octopus ochellatus )NaNNaN20.09NaNNaNNaNNaNNaNNaN20.09
26피뿔고둥(Rapana venosa)132.6463.8132.850.7NaNNaN379.94
27합계3211.24378.8920431.114920.6311037.7532109.56