Overview

Dataset statistics

Number of variables14
Number of observations1170
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory129.2 KiB
Average record size in memory113.1 B

Variable types

Numeric1
Text1
Categorical3
DateTime4
Boolean5

Dataset

Description제주관광공사 온라인면세점 관리자시스템을 통해 기획전 진행시 기획전명, 브랜드, 행사 종류 등에 대한 정보 관리하는 데이터
URLhttps://www.data.go.kr/data/15118576/fileData.do

Alerts

링크타입모바일 is highly overall correlated with 링크타입컴퓨터High correlation
링크타입컴퓨터 is highly overall correlated with 링크타입모바일High correlation
기획전아이디 is highly overall correlated with 노출여부High correlation
노출여부 is highly overall correlated with 기획전아이디High correlation
디바이스타입 is highly imbalanced (98.7%)Imbalance
노출여부 is highly imbalanced (51.2%)Imbalance
할인전 사용여부 is highly imbalanced (78.9%)Imbalance
명품관기획전여부 is highly imbalanced (99.0%)Imbalance
기획전아이디 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:50:07.155776
Analysis finished2023-12-12 14:50:08.540484
Duration1.38 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기획전아이디
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1170
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean869.82479
Minimum101
Maximum1650
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.4 KiB
2023-12-12T23:50:08.623062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum101
5-th percentile223.95
Q1535.75
median875.5
Q31197.75
95-th percentile1581.55
Maximum1650
Range1549
Interquartile range (IQR)662

Descriptive statistics

Standard deviation417.74638
Coefficient of variation (CV)0.48026497
Kurtosis-0.98202318
Mean869.82479
Median Absolute Deviation (MAD)327.5
Skewness0.043999614
Sum1017695
Variance174512.04
MonotonicityNot monotonic
2023-12-12T23:50:08.775142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
122 1
 
0.1%
1081 1
 
0.1%
1082 1
 
0.1%
1073 1
 
0.1%
1062 1
 
0.1%
1058 1
 
0.1%
1079 1
 
0.1%
1076 1
 
0.1%
1070 1
 
0.1%
1069 1
 
0.1%
Other values (1160) 1160
99.1%
ValueCountFrequency (%)
101 1
0.1%
102 1
0.1%
103 1
0.1%
104 1
0.1%
105 1
0.1%
106 1
0.1%
107 1
0.1%
108 1
0.1%
109 1
0.1%
110 1
0.1%
ValueCountFrequency (%)
1650 1
0.1%
1649 1
0.1%
1648 1
0.1%
1647 1
0.1%
1646 1
0.1%
1645 1
0.1%
1644 1
0.1%
1643 1
0.1%
1642 1
0.1%
1641 1
0.1%

성명
Text

Distinct957
Distinct (%)81.8%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2023-12-12T23:50:09.056565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length55
Median length36
Mean length14.537607
Min length1

Characters and Unicode

Total characters17009
Distinct characters566
Distinct categories16 ?
Distinct scripts4 ?
Distinct blocks7 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique838 ?
Unique (%)71.6%

Sample

1st row브루더 사은전
2nd row로사케이 사은전
3rd row엘리자베스아덴 향수 사은전
4th row마크바이제이콥스 향수 사은전
5th rowC.K 향수 사은전
ValueCountFrequency (%)
사은전 375
 
8.6%
193
 
4.4%
이벤트 179
 
4.1%
기획전 125
 
2.9%
할인전 89
 
2.0%
사은 86
 
2.0%
정관장 84
 
1.9%
할인 83
 
1.9%
특별 83
 
1.9%
구매 55
 
1.3%
Other values (900) 3009
69.0%
2023-12-12T23:50:10.000094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3274
 
19.2%
전 740
 
4.4%
사 651
 
3.8%
은 555
 
3.3%
이 374
 
2.2%
스 290
 
1.7%
트 287
 
1.7%
! 271
 
1.6%
벤 231
 
1.4%
월 227
 
1.3%
Other values (556) 10109
59.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 11314
66.5%
Space Separator 3274
 
19.2%
Decimal Number 948
 
5.6%
Other Punctuation 686
 
4.0%
Uppercase Letter 411
 
2.4%
Lowercase Letter 89
 
0.5%
Math Symbol 72
 
0.4%
Close Punctuation 55
 
0.3%
Open Punctuation 55
 
0.3%
Dash Punctuation 45
 
0.3%
Other values (6) 60
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 740
 
6.5%
사 651
 
5.8%
은 555
 
4.9%
이 374
 
3.3%
스 290
 
2.6%
트 287
 
2.5%
벤 231
 
2.0%
월 227
 
2.0%
인 218
 
1.9%
할 207
 
1.8%
Other values (477) 7534
66.6%
Uppercase Letter
ValueCountFrequency (%)
S 63
15.3%
I 57
13.9%
K 52
12.7%
E 26
 
6.3%
O 24
 
5.8%
R 23
 
5.6%
L 18
 
4.4%
C 17
 
4.1%
G 16
 
3.9%
M 14
 
3.4%
Other values (15) 101
24.6%
Lowercase Letter
ValueCountFrequency (%)
i 11
12.4%
c 10
11.2%
e 8
9.0%
r 8
9.0%
s 7
 
7.9%
u 6
 
6.7%
m 6
 
6.7%
t 5
 
5.6%
a 5
 
5.6%
l 5
 
5.6%
Other values (7) 18
20.2%
Other Punctuation
ValueCountFrequency (%)
! 271
39.5%
, 168
24.5%
% 115
16.8%
. 49
 
7.1%
' 45
 
6.6%
/ 26
 
3.8%
& 6
 
0.9%
· 3
 
0.4%
: 2
 
0.3%
# 1
 
0.1%
Decimal Number
ValueCountFrequency (%)
0 217
22.9%
1 174
18.4%
2 160
16.9%
3 87
9.2%
5 78
 
8.2%
4 60
 
6.3%
9 45
 
4.7%
8 43
 
4.5%
6 42
 
4.4%
7 42
 
4.4%
Math Symbol
ValueCountFrequency (%)
~ 44
61.1%
+ 25
34.7%
> 1
 
1.4%
< 1
 
1.4%
× 1
 
1.4%
Close Punctuation
ValueCountFrequency (%)
) 54
98.2%
] 1
 
1.8%
Open Punctuation
ValueCountFrequency (%)
( 54
98.2%
[ 1
 
1.8%
Space Separator
ValueCountFrequency (%)
3274
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 45
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 25
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 21
100.0%
Control
ValueCountFrequency (%)
8
100.0%
Initial Punctuation
ValueCountFrequency (%)
‘ 2
100.0%
Final Punctuation
ValueCountFrequency (%)
’ 2
100.0%
Other Symbol
ValueCountFrequency (%)
° 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 11297
66.4%
Common 5170
30.4%
Latin 525
 
3.1%
Han 17
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 740
 
6.6%
사 651
 
5.8%
은 555
 
4.9%
이 374
 
3.3%
스 290
 
2.6%
트 287
 
2.5%
벤 231
 
2.0%
월 227
 
2.0%
인 218
 
1.9%
할 207
 
1.8%
Other values (473) 7517
66.5%
Latin
ValueCountFrequency (%)
S 63
 
12.0%
I 57
 
10.9%
K 52
 
9.9%
E 26
 
5.0%
Ⅱ 25
 
4.8%
O 24
 
4.6%
R 23
 
4.4%
L 18
 
3.4%
C 17
 
3.2%
G 16
 
3.0%
Other values (33) 204
38.9%
Common
ValueCountFrequency (%)
3274
63.3%
! 271
 
5.2%
0 217
 
4.2%
1 174
 
3.4%
, 168
 
3.2%
2 160
 
3.1%
% 115
 
2.2%
3 87
 
1.7%
5 78
 
1.5%
4 60
 
1.2%
Other values (26) 566
 
10.9%
Han
ValueCountFrequency (%)
無 10
58.8%
多 5
29.4%
福 1
 
5.9%
三 1
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 11291
66.4%
ASCII 5660
33.3%
Number Forms 25
 
0.1%
CJK 17
 
0.1%
Compat Jamo 6
 
< 0.1%
None 6
 
< 0.1%
Punctuation 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3274
57.8%
! 271
 
4.8%
0 217
 
3.8%
1 174
 
3.1%
, 168
 
3.0%
2 160
 
2.8%
% 115
 
2.0%
3 87
 
1.5%
5 78
 
1.4%
S 63
 
1.1%
Other values (63) 1053
 
18.6%
Hangul
ValueCountFrequency (%)
전 740
 
6.6%
사 651
 
5.8%
은 555
 
4.9%
이 374
 
3.3%
스 290
 
2.6%
트 287
 
2.5%
벤 231
 
2.0%
월 227
 
2.0%
인 218
 
1.9%
할 207
 
1.8%
Other values (472) 7511
66.5%
Number Forms
ValueCountFrequency (%)
Ⅱ 25
100.0%
CJK
ValueCountFrequency (%)
無 10
58.8%
多 5
29.4%
福 1
 
5.9%
三 1
 
5.9%
Compat Jamo
ValueCountFrequency (%)
ㅎ 6
100.0%
None
ValueCountFrequency (%)
· 3
50.0%
° 2
33.3%
× 1
 
16.7%
Punctuation
ValueCountFrequency (%)
‘ 2
50.0%
’ 2
50.0%

디바이스타입
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
all
1168 
mobile
 
1
pc
 
1

Length

Max length6
Median length3
Mean length3.0017094
Min length2

Unique

Unique2 ?
Unique (%)0.2%

Sample

1st rowall
2nd rowall
3rd rowall
4th rowall
5th rowall

Common Values

ValueCountFrequency (%)
all 1168
99.8%
mobile 1
 
0.1%
pc 1
 
0.1%

Length

2023-12-12T23:50:10.193152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:50:10.372636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
all 1168
99.8%
mobile 1
 
0.1%
pc 1
 
0.1%

시작일자
Date

Distinct572
Distinct (%)48.9%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2018-03-20 00:00:00
Maximum2023-08-04 00:00:00
2023-12-12T23:50:10.548718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:50:10.721143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

종료일시
Date

Distinct556
Distinct (%)47.5%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2018-03-21 00:00:00
Maximum2023-12-31 23:59:00
2023-12-12T23:50:10.871503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:50:11.050546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

노출여부
Boolean

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
1046 
True
124 
ValueCountFrequency (%)
False 1046
89.4%
True 124
 
10.6%
2023-12-12T23:50:11.199726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

링크타입컴퓨터
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
noLink
830 
script
335 
link
 
5

Length

Max length6
Median length6
Mean length5.991453
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rownoLink
2nd rownoLink
3rd rownoLink
4th rownoLink
5th rownoLink

Common Values

ValueCountFrequency (%)
noLink 830
70.9%
script 335
28.6%
link 5
 
0.4%

Length

2023-12-12T23:50:11.340638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:50:11.471933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
nolink 830
70.9%
script 335
28.6%
link 5
 
0.4%

링크타입모바일
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
noLink
832 
script
333 
link
 
5

Length

Max length6
Median length6
Mean length5.991453
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rownoLink
2nd rownoLink
3rd rownoLink
4th rownoLink
5th rownoLink

Common Values

ValueCountFrequency (%)
noLink 832
71.1%
script 333
28.5%
link 5
 
0.4%

Length

2023-12-12T23:50:11.646452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:50:11.786543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
nolink 832
71.1%
script 333
28.5%
link 5
 
0.4%

할인전 사용여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
1131 
True
 
39
ValueCountFrequency (%)
False 1131
96.7%
True 39
 
3.3%
2023-12-12T23:50:11.884699image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

전관 사용여부
Boolean

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
1010 
True
160 
ValueCountFrequency (%)
False 1010
86.3%
True 160
 
13.7%
2023-12-12T23:50:11.962969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

앵커 사용여부
Boolean

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
965 
True
205 
ValueCountFrequency (%)
False 965
82.5%
True 205
 
17.5%
2023-12-12T23:50:12.054090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록일자
Date

Distinct1163
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2018-03-19 13:23:00
Maximum2023-08-03 12:46:00
2023-12-12T23:50:12.173262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:50:12.348231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정일자
Date

Distinct402
Distinct (%)34.4%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2018-03-20 15:50:00
Maximum2023-08-06 10:09:00
2023-12-12T23:50:12.540817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:50:12.714252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

명품관기획전여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
False
1169 
True
 
1
ValueCountFrequency (%)
False 1169
99.9%
True 1
 
0.1%
2023-12-12T23:50:12.850688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Interactions

2023-12-12T23:50:08.106522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:50:12.951547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기획전아이디디바이스타입노출여부링크타입컴퓨터링크타입모바일할인전 사용여부전관 사용여부앵커 사용여부명품관기획전여부
기획전아이디1.0000.0000.9310.3320.3350.2410.1850.1650.039
디바이스타입0.0001.0000.0000.0000.0000.0000.0000.0300.000
노출여부0.9310.0001.0000.0020.0000.0750.0000.0000.037
링크타입컴퓨터0.3320.0000.0021.0001.0000.0460.0420.0280.000
링크타입모바일0.3350.0000.0001.0001.0000.0460.0430.0270.000
할인전 사용여부0.2410.0000.0750.0460.0461.0000.0950.0000.000
전관 사용여부0.1850.0000.0000.0420.0430.0951.0000.2760.000
앵커 사용여부0.1650.0300.0000.0280.0270.0000.2761.0000.000
명품관기획전여부0.0390.0000.0370.0000.0000.0000.0000.0001.000
2023-12-12T23:50:13.129717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
명품관기획전여부앵커 사용여부링크타입모바일노출여부전관 사용여부할인전 사용여부링크타입컴퓨터디바이스타입
명품관기획전여부1.0000.0000.0000.0230.0000.0000.0000.000
앵커 사용여부0.0001.0000.0450.0000.1780.0000.0470.050
링크타입모바일0.0000.0451.0000.0000.0720.0760.9980.000
노출여부0.0230.0000.0001.0000.0000.0480.0030.000
전관 사용여부0.0000.1780.0720.0001.0000.0600.0700.000
할인전 사용여부0.0000.0000.0760.0480.0601.0000.0770.000
링크타입컴퓨터0.0000.0470.9980.0030.0700.0771.0000.000
디바이스타입0.0000.0500.0000.0000.0000.0000.0001.000
2023-12-12T23:50:13.273626image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기획전아이디디바이스타입노출여부링크타입컴퓨터링크타입모바일할인전 사용여부전관 사용여부앵커 사용여부명품관기획전여부
기획전아이디1.0000.0000.7760.2110.2120.1840.1420.1260.030
디바이스타입0.0001.0000.0000.0000.0000.0000.0000.0500.000
노출여부0.7760.0001.0000.0030.0000.0480.0000.0000.023
링크타입컴퓨터0.2110.0000.0031.0000.9980.0770.0700.0470.000
링크타입모바일0.2120.0000.0000.9981.0000.0760.0720.0450.000
할인전 사용여부0.1840.0000.0480.0770.0761.0000.0600.0000.000
전관 사용여부0.1420.0000.0000.0700.0720.0601.0000.1780.000
앵커 사용여부0.1260.0500.0000.0470.0450.0000.1781.0000.000
명품관기획전여부0.0300.0000.0230.0000.0000.0000.0000.0001.000

Missing values

2023-12-12T23:50:08.245461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:50:08.455330image/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

기획전아이디성명디바이스타입시작일자종료일시노출여부링크타입컴퓨터링크타입모바일할인전 사용여부전관 사용여부앵커 사용여부등록일자수정일자명품관기획전여부
0122브루더 사은전all2018-03-202018-04-12nnoLinknoLinknnn2018-03-19 14:282018-04-13 12:31n
1123로사케이 사은전all2018-03-202018-05-06nnoLinknoLinknnn2018-03-19 14:292020-05-18 18:21n
2124엘리자베스아덴 향수 사은전all2018-03-202018-04-08nnoLinknoLinknnn2018-03-19 14:312020-05-18 18:21n
3125마크바이제이콥스 향수 사은전all2018-03-202018-05-07nnoLinknoLinknnn2018-03-19 14:312018-05-08 13:23n
4126C.K 향수 사은전all2018-03-202018-05-08nnoLinknoLinknny2018-03-19 14:332020-05-18 18:21n
5127폴스미스 사은전all2018-03-202018-04-14nnoLinknoLinknny2018-03-19 14:522020-05-18 18:21n
6128구찌 향수 사은전all2018-03-202018-05-07nnoLinknoLinknny2018-03-19 14:532018-05-08 13:22n
7129록시땅 사은전all2018-03-202018-05-09nnoLinknoLinknny2018-03-19 14:572020-05-18 18:21n
81401all2018-03-212018-03-21nnoLinknoLinknnn2018-03-20 15:372018-03-20 15:50n
9218SKⅡ 4월 사은전all2018-03-302018-04-30nnoLinknoLinknny2018-03-29 14:112020-05-18 18:21n
기획전아이디성명디바이스타입시작일자종료일시노출여부링크타입컴퓨터링크타입모바일할인전 사용여부전관 사용여부앵커 사용여부등록일자수정일자명품관기획전여부
11601632디네치 추천전_취소all2023-07-012023-07-01 23:59nnoLinknoLinknnn2023-06-28 10:402023-06-28 15:50n
11611633디네치 추천전all2023-06-292023-12-31 23:59ynoLinknoLinknnn2023-06-28 15:492023-07-28 13:52n
11621648레스포색, 브릭스 30% 할인전all2023-08-042023-08-31 23:59ynoLinknoLinknny2023-08-03 12:282023-08-03 18:34n
11631649판도라 30% 할인전all2023-08-042023-08-31 23:59ynoLinknoLinknnn2023-08-03 12:402023-08-03 18:41n
11641650시계 30% 할인전(Gc., BRISTON, Olivia Burton)all2023-08-042023-08-31 23:59ynoLinknoLinknny2023-08-03 12:462023-08-03 18:33n
11651647제주관광공사 면세점 인턴의 여름 여행 추천템all2023-07-292023-08-31 23:59ynoLinknoLinknnn2023-07-28 11:502023-07-28 13:00n
11661646닥스 추천전all2023-07-272023-09-30 23:59ynoLinknoLinknnn2023-07-26 13:122023-07-26 13:12n
11671643로즈몽 시계 증정 이벤트all2023-07-272023-08-31 23:59ynoLinknoLinknnn2023-07-26 10:522023-08-01 14:29n
11681644시티즌 시계 증정 이벤트all2023-07-272023-08-31 23:59ynoLinknoLinknnn2023-07-26 10:542023-08-01 14:28n
11691645SU:M37°/ 숨 사은이벤트all2023-07-272023-09-30 23:59ynoLinknoLinknnn2023-07-26 12:122023-08-06 10:08n