Overview

Dataset statistics

Number of variables13
Number of observations25
Missing cells126
Missing cells (%)38.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory109.3 B

Variable types

Text1
Unsupported12

Alerts

Unnamed: 1 has 17 (68.0%) missing valuesMissing
Unnamed: 2 has 18 (72.0%) missing valuesMissing
Unnamed: 3 has 13 (52.0%) missing valuesMissing
Unnamed: 4 has 14 (56.0%) missing valuesMissing
Unnamed: 5 has 13 (52.0%) missing valuesMissing
Unnamed: 6 has 14 (56.0%) missing valuesMissing
Unnamed: 7 has 7 (28.0%) missing valuesMissing
Unnamed: 8 has 8 (32.0%) missing valuesMissing
Unnamed: 9 has 10 (40.0%) missing valuesMissing
Unnamed: 10 has 11 (44.0%) missing valuesMissing
Unnamed: 12 has 1 (4.0%) 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 02:49:51.913725
Analysis finished2024-03-14 02:49:52.445102
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2024-03-14T11:49:52.612586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length28
Mean length22.08
Min length2

Characters and Unicode

Total characters552
Distinct characters86
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

Unique25 ?
Unique (%)100.0%

Sample

1st row일자
2nd row구분
3rd row조피볼락(Sebastes schlegelii)
4th row황해볼락(Sebastes koreanus)
5th row삼세기(Hemitripterus villosus)
ValueCountFrequency (%)
일자 1
 
2.1%
japonicus 1
 
2.1%
보구치(pennahia 1
 
2.1%
argentata 1
 
2.1%
삼치(scomberomorus 1
 
2.1%
niphomius 1
 
2.1%
참돔(pagrus 1
 
2.1%
major 1
 
2.1%
꼼치(liparis 1
 
2.1%
tanakae 1
 
2.1%
Other values (37) 37
78.7%
2024-03-14T11:49:52.906903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
a 49
 
8.9%
s 43
 
7.8%
e 35
 
6.3%
o 29
 
5.3%
u 29
 
5.3%
i 29
 
5.3%
r 24
 
4.3%
22
 
4.0%
( 22
 
4.0%
) 22
 
4.0%
Other values (76) 248
44.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 390
70.7%
Other Letter 74
 
13.4%
Space Separator 22
 
4.0%
Open Punctuation 22
 
4.0%
Close Punctuation 22
 
4.0%
Uppercase Letter 22
 
4.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
8
 
10.8%
3
 
4.1%
3
 
4.1%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
Other values (40) 46
62.2%
Lowercase Letter
ValueCountFrequency (%)
a 49
12.6%
s 43
11.0%
e 35
 
9.0%
o 29
 
7.4%
u 29
 
7.4%
i 29
 
7.4%
r 24
 
6.2%
n 21
 
5.4%
t 21
 
5.4%
l 18
 
4.6%
Other values (14) 92
23.6%
Uppercase Letter
ValueCountFrequency (%)
P 8
36.4%
S 4
18.2%
C 3
 
13.6%
H 2
 
9.1%
E 1
 
4.5%
L 1
 
4.5%
O 1
 
4.5%
R 1
 
4.5%
Z 1
 
4.5%
Space Separator
ValueCountFrequency (%)
22
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 412
74.6%
Hangul 74
 
13.4%
Common 66
 
12.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
8
 
10.8%
3
 
4.1%
3
 
4.1%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
Other values (40) 46
62.2%
Latin
ValueCountFrequency (%)
a 49
11.9%
s 43
 
10.4%
e 35
 
8.5%
o 29
 
7.0%
u 29
 
7.0%
i 29
 
7.0%
r 24
 
5.8%
n 21
 
5.1%
t 21
 
5.1%
l 18
 
4.4%
Other values (23) 114
27.7%
Common
ValueCountFrequency (%)
22
33.3%
( 22
33.3%
) 22
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 478
86.6%
Hangul 74
 
13.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 49
 
10.3%
s 43
 
9.0%
e 35
 
7.3%
o 29
 
6.1%
u 29
 
6.1%
i 29
 
6.1%
r 24
 
5.0%
22
 
4.6%
( 22
 
4.6%
) 22
 
4.6%
Other values (26) 174
36.4%
Hangul
ValueCountFrequency (%)
8
 
10.8%
3
 
4.1%
3
 
4.1%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
2
 
2.7%
Other values (40) 46
62.2%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing17
Missing (%)68.0%
Memory size332.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing18
Missing (%)72.0%
Memory size332.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)52.0%
Memory size332.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)56.0%
Memory size332.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing13
Missing (%)52.0%
Memory size332.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)56.0%
Memory size332.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing7
Missing (%)28.0%
Memory size332.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing8
Missing (%)32.0%
Memory size332.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing10
Missing (%)40.0%
Memory size332.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)44.0%
Memory size332.0 B

Unnamed: 11
Unsupported

REJECTED  UNSUPPORTED 

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

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.0%
Memory size332.0 B

Missing values

2024-03-14T11:49:52.027011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T11:49:52.197093image/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-14T11:49:52.331904image/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)NaNNaNNaNNaNNaNNaN81.02164.5245.52
3황해볼락(Sebastes koreanus)NaNNaN10.01NaNNaNNaNNaN30.140.11
4삼세기(Hemitripterus villosus)41.32NaNNaNNaNNaNNaNNaNNaNNaN41.32
5노래미(Hexagrammos agrammus)10.1410.0210.05NaNNaN20.350.51
6넙치(Paralichthys olivadeus)NaNNaNNaNNaNNaNNaN10.4511.822.25
7문치가자미(Pleuronectes yokohamae)40.95NaNNaN21.210.1830.8103.13
8별넙치(Pseudorhombus cinnamoneus)NaNNaNNaNNaNNaNNaN20.24NaNNaN20.24
9점넙치(Pseudorhombus pentophthalmus)NaNNaNNaNNaNNaNNaN10.1NaNNaN10.1
군산해역에서 어획된 품종별 개체수 및 현존량(2014년)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
15삼치(Scomberomorus niphomius)NaNNaNNaNNaNNaNNaN10.2NaNNaN10.2
16참돔(Pagrus major)NaNNaNNaNNaNNaNNaN40.17NaNNaN40.17
17꼼치(Liparis tanakae)NaNNaNNaNNaNNaNNaNNaNNaN41.341.3
18멸치(Engraulis japonicus)NaNNaN10.01NaNNaN300.02NaNNaN310.03
19꽃게(Portunus trituberculatus)10.04NaNNaN347.991.910.34510.14
20민꽃게(Charybdis japonica)NaNNaN10.1130.8141.1150.8332.81
21갯가재(Oratosquilla oratoria)NaNNaN10.01130.4520.0510.1170.61
22참갑오징어(Sepia esculenta)NaNNaN41.46134.4NaNNaNNaNNaN175.86
23피뿔고둥(Rapana venosa)10.150.74112.240.7820.2234.02
24합계112.55162.399217.81119.86948.129880.64