Overview

Dataset statistics

Number of variables9
Number of observations102
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)1.0%
Total size in memory7.6 KiB
Average record size in memory76.3 B

Variable types

Categorical5
Numeric3
DateTime1

Dataset

Description한국남부발전(주)_홍보용품 제작현황에 대한 데이터로 제품명, 단가, 수량, 제작금액, 납품일자, 납품업체, 소재지 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15095422/fileData.do

Alerts

Dataset has 1 (1.0%) duplicate rowsDuplicates
활용목적 is highly overall correlated with 제품명 and 2 other fieldsHigh correlation
배부부서 is highly overall correlated with 제품명 and 2 other fieldsHigh correlation
단가(원) is highly overall correlated with 수량 and 1 other fieldsHigh correlation
수량 is highly overall correlated with 단가(원) and 2 other fieldsHigh correlation
제작금액(원) is highly overall correlated with 수량 and 1 other fieldsHigh correlation
제품명 is highly overall correlated with 단가(원) and 4 other fieldsHigh correlation
납품업체 is highly overall correlated with 소재지 and 2 other fieldsHigh correlation
소재지 is highly overall correlated with 납품업체 High correlation

Reproduction

Analysis started2023-12-12 09:01:00.689347
Analysis finished2023-12-12 09:01:02.638209
Duration1.95 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제품명
Categorical

HIGH CORRELATION 

Distinct46
Distinct (%)45.1%
Missing0
Missing (%)0.0%
Memory size948.0 B
핸드크림
18 
선크림
10 
우산
9 
핸드크림
 
4
쇼핑백
 
4
Other values (41)
57 

Length

Max length11
Median length8
Mean length4.7843137
Min length2

Unique

Unique28 ?
Unique (%)27.5%

Sample

1st row우산
2nd row마사지기
3rd row텀블러
4th row우산
5th row보조 배터리

Common Values

ValueCountFrequency (%)
핸드크림 18
17.6%
선크림 10
 
9.8%
우산 9
 
8.8%
핸드크림 4
 
3.9%
쇼핑백 4
 
3.9%
선크림 4
 
3.9%
쇼핑백 3
 
2.9%
화장품세트 2
 
2.0%
텀블러 2
 
2.0%
머그컵 (2개입) 2
 
2.0%
Other values (36) 44
43.1%

Length

2023-12-12T18:01:02.721373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
핸드크림 22
19.3%
선크림 14
 
12.3%
우산 11
 
9.6%
쇼핑백 7
 
6.1%
화장품세트 7
 
6.1%
세트 3
 
2.6%
보조배터리 3
 
2.6%
2개입 2
 
1.8%
손톱깎이 2
 
1.8%
화장품세트(여성 2
 
1.8%
Other values (32) 41
36.0%

단가(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct59
Distinct (%)57.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22577.24
Minimum854
Maximum43636
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T18:01:02.876527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum854
5-th percentile1272.7411
Q117000
median22727
Q326818
95-th percentile42727
Maximum43636
Range42782
Interquartile range (IQR)9818

Descriptive statistics

Standard deviation10815.405
Coefficient of variation (CV)0.47904016
Kurtosis0.065275181
Mean22577.24
Median Absolute Deviation (MAD)4636.5
Skewness-0.0073956502
Sum2302878.5
Variance1.1697298 × 108
MonotonicityNot monotonic
2023-12-12T18:01:03.096901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
22727.0 8
 
7.8%
20454.0 5
 
4.9%
16364.0 5
 
4.9%
25455.0 5
 
4.9%
43636.0 5
 
4.9%
26818.0 3
 
2.9%
22500.0 3
 
2.9%
20454.55 3
 
2.9%
17000.0 3
 
2.9%
22727.27 3
 
2.9%
Other values (49) 59
57.8%
ValueCountFrequency (%)
854.0 1
1.0%
909.0 1
1.0%
1136.0 1
1.0%
1250.0 1
1.0%
1272.7275 2
2.0%
1273.0 1
1.0%
1363.637 1
1.0%
2091.0 1
1.0%
4545.0 1
1.0%
7500.0 1
1.0%
ValueCountFrequency (%)
43636.0 5
4.9%
42727.0 2
 
2.0%
42273.0 1
 
1.0%
40909.075 1
 
1.0%
40909.0 1
 
1.0%
39090.0 1
 
1.0%
39000.0 1
 
1.0%
36364.0 1
 
1.0%
36363.64 1
 
1.0%
34909.0 1
 
1.0%

수량
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)20.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean165.14706
Minimum4
Maximum2100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T18:01:03.245165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4
5-th percentile10
Q150
median100
Q3100
95-th percentile1000
Maximum2100
Range2096
Interquartile range (IQR)50

Descriptive statistics

Standard deviation308.20366
Coefficient of variation (CV)1.8662376
Kurtosis17.218029
Mean165.14706
Median Absolute Deviation (MAD)0
Skewness3.8826892
Sum16845
Variance94989.493
MonotonicityNot monotonic
2023-12-12T18:01:03.387923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
100 54
52.9%
50 11
 
10.8%
1000 7
 
6.9%
10 5
 
4.9%
30 4
 
3.9%
20 3
 
2.9%
26 2
 
2.0%
5 2
 
2.0%
80 2
 
2.0%
250 1
 
1.0%
Other values (11) 11
 
10.8%
ValueCountFrequency (%)
4 1
 
1.0%
5 2
 
2.0%
10 5
4.9%
12 1
 
1.0%
20 3
 
2.9%
26 2
 
2.0%
30 4
 
3.9%
40 1
 
1.0%
50 11
10.8%
52 1
 
1.0%
ValueCountFrequency (%)
2100 1
 
1.0%
1000 7
 
6.9%
500 1
 
1.0%
250 1
 
1.0%
200 1
 
1.0%
105 1
 
1.0%
100 54
52.9%
80 2
 
2.0%
65 1
 
1.0%
60 1
 
1.0%

제작금액(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct60
Distinct (%)58.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1648201.2
Minimum136364
Maximum3000000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-12T18:01:03.558651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum136364
5-th percentile310908.25
Q11136364
median1700000
Q32272727
95-th percentile2545455
Maximum3000000
Range2863636
Interquartile range (IQR)1136363

Descriptive statistics

Standard deviation722022.23
Coefficient of variation (CV)0.4380668
Kurtosis-0.68163044
Mean1648201.2
Median Absolute Deviation (MAD)572727
Skewness-0.40521919
Sum1.6811652 × 108
Variance5.2131609 × 1011
MonotonicityNot monotonic
2023-12-12T18:01:03.748306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2272727.0 12
 
11.8%
2045455.0 6
 
5.9%
2545455.0 6
 
5.9%
1636364.0 5
 
4.9%
1700000.0 3
 
2.9%
2000000.0 3
 
2.9%
1909091.0 2
 
2.0%
2181818.0 2
 
2.0%
2681818.0 2
 
2.0%
345455.0 2
 
2.0%
Other values (50) 59
57.8%
ValueCountFrequency (%)
136364.0 1
1.0%
163636.0 1
1.0%
174545.0 1
1.0%
195000.0 1
1.0%
272728.0 1
1.0%
309090.0 1
1.0%
345455.0 2
2.0%
422727.0 1
1.0%
427000.0 1
1.0%
454545.0 1
1.0%
ValueCountFrequency (%)
3000000.0 2
 
2.0%
2681818.0 2
 
2.0%
2672727.0 1
 
1.0%
2545455.0 6
5.9%
2529545.0 1
 
1.0%
2500000.0 1
 
1.0%
2454545.0 2
 
2.0%
2272728.0 2
 
2.0%
2272727.0 12
11.8%
2269091.0 1
 
1.0%

납품일자
Date

Distinct75
Distinct (%)73.5%
Missing0
Missing (%)0.0%
Memory size948.0 B
Minimum2020-02-05 00:00:00
Maximum2023-06-23 00:00:00
2023-12-12T18:01:03.940336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:04.120247image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

납품업체
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)21.6%
Missing0
Missing (%)0.0%
Memory size948.0 B
주○○○○○○○
14 
우○○○
13 
그O
10 
중OOOOOOO
9 
공○○○○강원지부
8 
Other values (17)
48 

Length

Max length12
Median length10
Mean length5.8627451
Min length2

Unique

Unique5 ?
Unique (%)4.9%

Sample

1st row사○○○○○○○○○○○
2nd row주○○○○○○○○
3rd row주○○○○○○○
4th row주○○○○○○○
5th row주○○○○○○○

Common Values

ValueCountFrequency (%)
주○○○○○○○ 14
13.7%
우○○○ 13
12.7%
그O 10
9.8%
중OOOOOOO 9
8.8%
공○○○○강원지부 8
 
7.8%
우OOO 7
 
6.9%
공OOOOOOOOO 6
 
5.9%
그○○○ 5
 
4.9%
공OOOOO 5
 
4.9%
그OOO 4
 
3.9%
Other values (12) 21
20.6%

Length

2023-12-12T18:01:04.293897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
주○○○○○○○ 14
13.7%
우○○○ 13
12.7%
그o 10
9.8%
중ooooooo 9
8.8%
공○○○○강원지부 8
 
7.8%
우ooo 7
 
6.9%
공ooooooooo 6
 
5.9%
그○○○ 5
 
4.9%
공ooooo 5
 
4.9%
그ooo 4
 
3.9%
Other values (12) 21
20.6%

소재지
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Memory size948.0 B
서울
47 
울산
28 
강원
16 
부산
8 
경기
 
3

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강원
2nd row서울
3rd row서울
4th row서울
5th row서울

Common Values

ValueCountFrequency (%)
서울 47
46.1%
울산 28
27.5%
강원 16
 
15.7%
부산 8
 
7.8%
경기 3
 
2.9%

Length

2023-12-12T18:01:04.444174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:01:04.565820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울 47
46.1%
울산 28
27.5%
강원 16
 
15.7%
부산 8
 
7.8%
경기 3
 
2.9%

배부부서
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size948.0 B
전 부서
51 
전 부서
51 

Length

Max length6
Median length5
Mean length5
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전 부서
2nd row전 부서
3rd row전 부서
4th row전 부서
5th row전 부서

Common Values

ValueCountFrequency (%)
전 부서 51
50.0%
전 부서 51
50.0%

Length

2023-12-12T18:01:04.716285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:01:04.855866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전 102
50.0%
부서 102
50.0%

활용목적
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size948.0 B
기업 홍보 및 대외이미지 제고
51 
기업홍보 및 대외이미지 제고
51 

Length

Max length16
Median length15.5
Mean length15.5
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row기업 홍보 및 대외이미지 제고
2nd row기업 홍보 및 대외이미지 제고
3rd row기업 홍보 및 대외이미지 제고
4th row기업 홍보 및 대외이미지 제고
5th row기업 홍보 및 대외이미지 제고

Common Values

ValueCountFrequency (%)
기업 홍보 및 대외이미지 제고 51
50.0%
기업홍보 및 대외이미지 제고 51
50.0%

Length

2023-12-12T18:01:05.275523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:01:05.394035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
및 102
22.2%
대외이미지 102
22.2%
제고 102
22.2%
기업 51
11.1%
홍보 51
11.1%
기업홍보 51
11.1%

Interactions

2023-12-12T18:01:01.978807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.294098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.641164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:02.101213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.392121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.747601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:02.215745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.497108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:01:01.854649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:01:05.483659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제품명단가(원)수량제작금액(원)납품일자납품업체소재지배부부서활용목적
제품명1.0000.9640.9590.9390.0000.9360.6150.8810.881
단가(원)0.9641.0000.8090.8830.0000.7480.6450.0000.000
수량0.9590.8091.0000.6230.9450.3700.5010.0000.000
제작금액(원)0.9390.8830.6231.0000.8970.6810.5080.2720.272
납품일자0.0000.0000.9450.8971.0000.9890.9411.0001.000
납품업체0.9360.7480.3700.6810.9891.0000.9851.0001.000
소재지0.6150.6450.5010.5080.9410.9851.0000.2810.281
배부부서0.8810.0000.0000.2721.0001.0000.2811.0001.000
활용목적0.8810.0000.0000.2721.0001.0000.2811.0001.000
2023-12-12T18:01:05.615532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
납품업체소재지활용목적제품명배부부서
납품업체1.0000.8620.8940.4400.894
소재지0.8621.0000.3380.2470.338
활용목적0.8940.3381.0000.5600.980
제품명0.4400.2470.5601.0000.560
배부부서0.8940.3380.9800.5601.000
2023-12-12T18:01:05.734405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단가(원)수량제작금액(원)제품명납품업체소재지배부부서활용목적
단가(원)1.000-0.6720.0380.5930.3580.3000.0000.000
수량-0.6721.0000.5760.6160.1690.2060.0000.000
제작금액(원)0.0380.5761.0000.5230.3040.2250.2150.215
제품명0.5930.6160.5231.0000.4400.2470.5600.560
납품업체0.3580.1690.3040.4401.0000.8620.8940.894
소재지0.3000.2060.2250.2470.8621.0000.3380.338
배부부서0.0000.0000.2150.5600.8940.3381.0000.980
활용목적0.0000.0000.2150.5600.8940.3380.9801.000

Missing values

2023-12-12T18:01:02.386752image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:01:02.576784image/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

제품명단가(원)수량제작금액(원)납품일자납품업체소재지배부부서활용목적
0우산13636.060818182.02020-02-05사○○○○○○○○○○○강원전 부서기업 홍보 및 대외이미지 제고
1마사지기26818.0501340909.02020-03-23주○○○○○○○○서울전 부서기업 홍보 및 대외이미지 제고
2텀블러26818.01002681818.02020-05-04주○○○○○○○서울전 부서기업 홍보 및 대외이미지 제고
3우산14545.01001454545.02020-05-27주○○○○○○○서울전 부서기업 홍보 및 대외이미지 제고
4보조 배터리16364.01001636364.02020-05-27주○○○○○○○서울전 부서기업 홍보 및 대외이미지 제고
5손톱깎이 세트19091.01001909091.02020-05-27주○○○○○○○울산전 부서기업 홍보 및 대외이미지 제고
6썬크림22727.01002272727.02020-05-27주○○○○○○○울산전 부서기업 홍보 및 대외이미지 제고
7핸드크림25455.01002545455.02020-05-27주○○○○○○○울산전 부서기업 홍보 및 대외이미지 제고
8핸드크림25455.01002545455.02020-06-24주○○○○○○○울산전 부서기업 홍보 및 대외이미지 제고
9우산16364.01001636364.02020-08-05주○○○○○○○서울전 부서기업 홍보 및 대외이미지 제고
제품명단가(원)수량제작금액(원)납품일자납품업체소재지배부부서활용목적
92쇼핑백1272.727510001272727.52023-04-10공OOOOOOOOO강원전 부서기업홍보 및 대외이미지 제고
93넥밴드선풍기20818.2501040910.02023-04-17중OOOOOOO서울전 부서기업홍보 및 대외이미지 제고
94드립백(중)23636.3625801890909.02023-04-26우OOO울산전 부서기업홍보 및 대외이미지 제고
95드립백(대)40909.075401636363.02023-04-26그O서울전 부서기업홍보 및 대외이미지 제고
96선크림22727.271002272727.02023-05-10함OOOOO경기전 부서기업홍보 및 대외이미지 제고
97클렌징세트36363.64501818182.02023-05-11효OOO부산전 부서기업홍보 및 대외이미지 제고
98쇼핑백1363.63710001363637.02023-06-01공OOOOOOOOO강원전 부서기업홍보 및 대외이미지 제고
99우산17000.01001700000.02023-06-12더OO경기전 부서기업홍보 및 대외이미지 제고
100선크림22727.271002272727.02023-06-13함OOOOO경기전 부서기업홍보 및 대외이미지 제고
101핸드크림20454.551002045455.02023-06-23중OOOOOOO서울전 부서기업홍보 및 대외이미지 제고

Duplicate rows

Most frequently occurring

제품명단가(원)수량제작금액(원)납품일자납품업체소재지배부부서활용목적# duplicates
0쇼핑백1272.727510001272727.52023-04-10공OOOOOOOOO강원전 부서기업홍보 및 대외이미지 제고2