Overview

Dataset statistics

Number of variables8
Number of observations79
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.2 KiB
Average record size in memory67.7 B

Variable types

Boolean1
Categorical4
DateTime1
Numeric2

Dataset

Description부산광역시_국제수산물유통시설관리사업소_상장예외거래현황_20240111
Author부산광역시
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15040458

Alerts

법인여부 has constant value ""Constant
법인명 has constant value ""Constant
등급품질명 has constant value ""Constant
수량 is highly overall correlated with 금액 and 2 other fieldsHigh correlation
금액 is highly overall correlated with 수량 High correlation
품목명 is highly overall correlated with 수량 and 1 other fieldsHigh correlation
산지명 is highly overall correlated with 수량 and 1 other fieldsHigh correlation

Reproduction

Analysis started2024-03-13 13:16:19.524963
Analysis finished2024-03-13 13:16:20.400881
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

법인여부
Boolean

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size211.0 B
True
79 
ValueCountFrequency (%)
True 79
100.0%
2024-03-13T22:16:20.502295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

법인명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
상장예외중도매인
79 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row상장예외중도매인
2nd row상장예외중도매인
3rd row상장예외중도매인
4th row상장예외중도매인
5th row상장예외중도매인

Common Values

ValueCountFrequency (%)
상장예외중도매인 79
100.0%

Length

2024-03-13T22:16:20.654524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:16:20.779885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
상장예외중도매인 79
100.0%
Distinct45
Distinct (%)57.0%
Missing0
Missing (%)0.0%
Memory size764.0 B
Minimum2023-01-25 00:00:00
Maximum2023-12-28 00:00:00
2024-03-13T22:16:20.891134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:16:21.062021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)

품목명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)21.5%
Missing0
Missing (%)0.0%
Memory size764.0 B
(냉)파나고니아이빨고기
12 
(냉)긴가이석태
11 
(냉)각시가자미
11 
(냉)흰오징어
10 
(냉)명태포
Other values (12)
26 

Length

Max length12
Median length11
Mean length8.1012658
Min length5

Unique

Unique6 ?
Unique (%)7.6%

Sample

1st row(냉)각시가자미
2nd row(냉)긴가이석태
3rd row(냉)동태
4th row(냉)각시가자미
5th row(건)밴댕이(일반)

Common Values

ValueCountFrequency (%)
(냉)파나고니아이빨고기 12
15.2%
(냉)긴가이석태 11
13.9%
(냉)각시가자미 11
13.9%
(냉)흰오징어 10
12.7%
(냉)명태포 9
11.4%
(건)밴댕이(일반) 7
8.9%
(냉)먹갈치 4
 
5.1%
(냉)갈고등어 3
 
3.8%
(건)소멸치 2
 
2.5%
(건)가오리포(일반) 2
 
2.5%
Other values (7) 8
10.1%

Length

2024-03-13T22:16:21.233530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
냉)파나고니아이빨고기 12
15.2%
냉)각시가자미 11
13.9%
냉)긴가이석태 11
13.9%
냉)흰오징어 10
12.7%
냉)명태포 9
11.4%
건)밴댕이(일반 7
8.9%
냉)먹갈치 4
 
5.1%
냉)갈고등어 3
 
3.8%
냉)은갈치 2
 
2.5%
건)소멸치 2
 
2.5%
Other values (7) 8
10.1%

등급품질명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
자연산 상품
79 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row자연산 상품
2nd row자연산 상품
3rd row자연산 상품
4th row자연산 상품
5th row자연산 상품

Common Values

ValueCountFrequency (%)
자연산 상품 79
100.0%

Length

2024-03-13T22:16:21.352836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:16:21.472587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자연산 79
50.0%
상품 79
50.0%

산지명
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)16.5%
Missing0
Missing (%)0.0%
Memory size764.0 B
원양산
22 
러시아
11 
미국
10 
베트남
국내
Other values (8)
23 

Length

Max length7
Median length3
Mean length2.9620253
Min length2

Unique

Unique3 ?
Unique (%)3.8%

Sample

1st row미국
2nd row파푸아뉴기니아
3rd row러시아
4th row러시아
5th row베트남

Common Values

ValueCountFrequency (%)
원양산 22
27.8%
러시아 11
13.9%
미국 10
12.7%
베트남 7
 
8.9%
국내 6
 
7.6%
세네갈 6
 
7.6%
파푸아뉴기니 5
 
6.3%
기니 5
 
6.3%
노르웨이 2
 
2.5%
대만 2
 
2.5%
Other values (3) 3
 
3.8%

Length

2024-03-13T22:16:21.590243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
원양산 22
27.8%
러시아 11
13.9%
미국 10
12.7%
베트남 7
 
8.9%
국내 6
 
7.6%
세네갈 6
 
7.6%
파푸아뉴기니 5
 
6.3%
기니 5
 
6.3%
노르웨이 2
 
2.5%
대만 2
 
2.5%
Other values (3) 3
 
3.8%

수량
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)22.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean105
Minimum10
Maximum650
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2024-03-13T22:16:21.700973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile10
Q120
median50
Q3150.5
95-th percentile341
Maximum650
Range640
Interquartile range (IQR)130.5

Descriptive statistics

Standard deviation124.36516
Coefficient of variation (CV)1.1844301
Kurtosis4.1096747
Mean105
Median Absolute Deviation (MAD)30
Skewness1.9251303
Sum8295
Variance15466.692
MonotonicityNot monotonic
2024-03-13T22:16:21.843007image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
20 16
20.3%
50 15
19.0%
30 8
10.1%
100 8
10.1%
10 8
10.1%
190 7
8.9%
320 3
 
3.8%
300 2
 
2.5%
340 2
 
2.5%
200 2
 
2.5%
Other values (8) 8
10.1%
ValueCountFrequency (%)
10 8
10.1%
20 16
20.3%
30 8
10.1%
40 1
 
1.3%
50 15
19.0%
92 1
 
1.3%
96 1
 
1.3%
100 8
10.1%
111 1
 
1.3%
190 7
8.9%
ValueCountFrequency (%)
650 1
 
1.3%
420 1
 
1.3%
376 1
 
1.3%
350 1
 
1.3%
340 2
 
2.5%
320 3
3.8%
300 2
 
2.5%
200 2
 
2.5%
190 7
8.9%
111 1
 
1.3%

금액
Real number (ℝ)

HIGH CORRELATION 

Distinct32
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8108289.2
Minimum464000
Maximum42840000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2024-03-13T22:16:22.018718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum464000
5-th percentile700000
Q11100000
median2000000
Q33423000
95-th percentile42267750
Maximum42840000
Range42376000
Interquartile range (IQR)2323000

Descriptive statistics

Standard deviation14378590
Coefficient of variation (CV)1.7733198
Kurtosis1.9249467
Mean8108289.2
Median Absolute Deviation (MAD)1000000
Skewness1.9549075
Sum6.4055485 × 108
Variance2.0674384 × 1014
MonotonicityNot monotonic
2024-03-13T22:16:22.168755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=32)
ValueCountFrequency (%)
3000000 11
 
13.9%
1900000 7
 
8.9%
1100000 6
 
7.6%
800000 6
 
7.6%
700000 5
 
6.3%
1050000 4
 
5.1%
2000000 4
 
5.1%
1600000 3
 
3.8%
2400000 3
 
3.8%
1650000 2
 
2.5%
Other values (22) 28
35.4%
ValueCountFrequency (%)
464000 1
 
1.3%
550000 2
 
2.5%
700000 5
6.3%
800000 6
7.6%
1050000 4
5.1%
1100000 6
7.6%
1600000 3
3.8%
1650000 2
 
2.5%
1750000 1
 
1.3%
1900000 7
8.9%
ValueCountFrequency (%)
42840000 1
1.3%
42777000 1
1.3%
42315000 2
2.5%
42262500 1
1.3%
42052500 1
1.3%
42000000 2
2.5%
41942250 1
1.3%
41055000 2
2.5%
38295600 1
1.3%
6000000 2
2.5%

Interactions

2024-03-13T22:16:19.924788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:16:19.751342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:16:20.019969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:16:19.837431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:16:22.256731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
경매일자품목명산지명수량금액
경매일자1.0000.6290.0000.9390.590
품목명0.6291.0000.9750.8610.769
산지명0.0000.9751.0000.7950.490
수량0.9390.8610.7951.0000.711
금액0.5900.7690.4900.7111.000
2024-03-13T22:16:22.366302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
품목명산지명
품목명1.0000.826
산지명0.8261.000
2024-03-13T22:16:22.450213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수량금액품목명산지명
수량1.0000.7960.5740.506
금액0.7961.0000.4120.203
품목명0.5740.4121.0000.826
산지명0.5060.2030.8261.000

Missing values

2024-03-13T22:16:20.155682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:16:20.313339image/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

법인여부법인명경매일자품목명등급품질명산지명수량금액
0Y상장예외중도매인2023-01-25(냉)각시가자미자연산 상품미국201100000
1Y상장예외중도매인2023-01-25(냉)긴가이석태자연산 상품파푸아뉴기니아302400000
2Y상장예외중도매인2023-01-25(냉)동태자연산 상품러시아501750000
3Y상장예외중도매인2023-01-27(냉)각시가자미자연산 상품러시아1003800000
4Y상장예외중도매인2023-01-30(건)밴댕이(일반)자연산 상품베트남1901900000
5Y상장예외중도매인2023-01-31(냉)갈고등어자연산 상품노르웨이2042315000
6Y상장예외중도매인2023-01-31(냉)파나고니아이빨고기자연산 상품원양산502400000
7Y상장예외중도매인2023-02-23(냉)각시가자미자연산 상품미국201100000
8Y상장예외중도매인2023-02-23(냉)긴가이석태자연산 상품파푸아뉴기니201600000
9Y상장예외중도매인2023-02-23(냉)명태포자연산 상품러시아301050000
법인여부법인명경매일자품목명등급품질명산지명수량금액
69Y상장예외중도매인2023-10-31(냉)장문볼락자연산 상품스페인503350000
70Y상장예외중도매인2023-11-23(냉)긴가이석태자연산 상품파푸아뉴기니10800000
71Y상장예외중도매인2023-11-24(건)밴댕이(일반)자연산 상품베트남1901900000
72Y상장예외중도매인2023-11-27(냉)흰오징어자연산 상품원양산32042000000
73Y상장예외중도매인2023-11-30(냉)파나고니아이빨고기자연산 상품원양산503000000
74Y상장예외중도매인2023-12-18(냉)먹갈치자연산 상품세네갈1004800000
75Y상장예외중도매인2023-12-22(냉)명태포자연산 상품러시아20700000
76Y상장예외중도매인2023-12-28(건)밴댕이(일반)자연산 상품베트남1901900000
77Y상장예외중도매인2023-12-28(냉)파나고니아이빨고기자연산 상품원양산503000000
78Y상장예외중도매인2023-12-28(냉)흰오징어자연산 상품원양산32042000000