Overview

Dataset statistics

Number of variables5
Number of observations47
Missing cells46
Missing cells (%)19.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory42.8 B

Variable types

Categorical1
DateTime2
Text2

Dataset

Description세븐럭 카지노 강북 힐튼점 전자게임의 이벤트 현황에 대한 데이터로 년도, 이벤트기간, 이벤트명, 주요내용 등 데이터를 제공합니다.
Author그랜드코리아레저(주)
URLhttps://www.data.go.kr/data/15044493/fileData.do

Alerts

지점 has constant value ""Constant
주요내용 has constant value ""Constant
주요내용 has 46 (97.9%) missing valuesMissing

Reproduction

Analysis started2023-12-12 09:27:32.740388
Analysis finished2023-12-12 09:27:33.290243
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지점
Categorical

CONSTANT 

Distinct1
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size508.0 B
힐튼
47 

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
100.0%

Length

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

Common Values (Plot)

2023-12-12T18:27:33.474398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
힐튼 47
100.0%

이벤트시작일
Date

Distinct39
Distinct (%)83.0%
Missing0
Missing (%)0.0%
Memory size508.0 B
Minimum2017-01-23 00:00:00
Maximum2021-05-01 00:00:00
2023-12-12T18:27:33.597219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:27:33.789704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)

이벤트종료일
Date

Distinct39
Distinct (%)83.0%
Missing0
Missing (%)0.0%
Memory size508.0 B
Minimum2017-01-30 00:00:00
Maximum2021-08-31 00:00:00
2023-12-12T18:27:33.961614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:27:34.161365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)

이벤트명
Text

Distinct35
Distinct (%)74.5%
Missing0
Missing (%)0.0%
Memory size508.0 B
2023-12-12T18:27:34.406641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length17.319149
Min length12

Characters and Unicode

Total characters814
Distinct characters97
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)57.4%

Sample

1st row힐튼점 설맞이 사은행사(프로모션)
2nd row힐튼점 설맞이 사은행사(사은품)
3rd row힐튼점 머신 우량고객 티켓지급 행사
4th row힐튼점 세븐볼 추첨 이벤트
5th row힐튼점 신규 고객 알선자 프로모션
ValueCountFrequency (%)
힐튼점 47
25.7%
이벤트 15
 
8.2%
행사 10
 
5.5%
tax 7
 
3.8%
사은행사 6
 
3.3%
설맞이 6
 
3.3%
payback 6
 
3.3%
우량고객 5
 
2.7%
머신게임 5
 
2.7%
reward 5
 
2.7%
Other values (36) 71
38.8%
2023-12-12T18:27:34.831736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
136
 
16.7%
힐 47
 
5.8%
튼 47
 
5.8%
점 47
 
5.8%
사 41
 
5.0%
이 28
 
3.4%
A 26
 
3.2%
행 25
 
3.1%
은 16
 
2.0%
트 15
 
1.8%
Other values (87) 386
47.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 514
63.1%
Space Separator 136
 
16.7%
Uppercase Letter 122
 
15.0%
Lowercase Letter 15
 
1.8%
Close Punctuation 9
 
1.1%
Open Punctuation 9
 
1.1%
Decimal Number 9
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
힐 47
 
9.1%
튼 47
 
9.1%
점 47
 
9.1%
사 41
 
8.0%
이 28
 
5.4%
행 25
 
4.9%
은 16
 
3.1%
트 15
 
2.9%
벤 15
 
2.9%
맞 13
 
2.5%
Other values (55) 220
42.8%
Uppercase Letter
ValueCountFrequency (%)
A 26
21.3%
R 10
 
8.2%
E 10
 
8.2%
Y 9
 
7.4%
K 9
 
7.4%
P 8
 
6.6%
T 8
 
6.6%
X 7
 
5.7%
C 7
 
5.7%
D 7
 
5.7%
Other values (7) 21
17.2%
Lowercase Letter
ValueCountFrequency (%)
y 3
20.0%
a 3
20.0%
p 2
13.3%
l 2
13.3%
i 2
13.3%
r 1
 
6.7%
u 1
 
6.7%
o 1
 
6.7%
Decimal Number
ValueCountFrequency (%)
1 4
44.4%
2 2
22.2%
3 2
22.2%
4 1
 
11.1%
Space Separator
ValueCountFrequency (%)
136
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 9
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 514
63.1%
Common 163
 
20.0%
Latin 137
 
16.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
힐 47
 
9.1%
튼 47
 
9.1%
점 47
 
9.1%
사 41
 
8.0%
이 28
 
5.4%
행 25
 
4.9%
은 16
 
3.1%
트 15
 
2.9%
벤 15
 
2.9%
맞 13
 
2.5%
Other values (55) 220
42.8%
Latin
ValueCountFrequency (%)
A 26
19.0%
R 10
 
7.3%
E 10
 
7.3%
Y 9
 
6.6%
K 9
 
6.6%
P 8
 
5.8%
T 8
 
5.8%
X 7
 
5.1%
C 7
 
5.1%
D 7
 
5.1%
Other values (15) 36
26.3%
Common
ValueCountFrequency (%)
136
83.4%
) 9
 
5.5%
( 9
 
5.5%
1 4
 
2.5%
2 2
 
1.2%
3 2
 
1.2%
4 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 514
63.1%
ASCII 300
36.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
136
45.3%
A 26
 
8.7%
R 10
 
3.3%
E 10
 
3.3%
) 9
 
3.0%
( 9
 
3.0%
Y 9
 
3.0%
K 9
 
3.0%
P 8
 
2.7%
T 8
 
2.7%
Other values (22) 66
22.0%
Hangul
ValueCountFrequency (%)
힐 47
 
9.1%
튼 47
 
9.1%
점 47
 
9.1%
사 41
 
8.0%
이 28
 
5.4%
행 25
 
4.9%
은 16
 
3.1%
트 15
 
2.9%
벤 15
 
2.9%
맞 13
 
2.5%
Other values (55) 220
42.8%

주요내용
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing46
Missing (%)97.9%
Memory size508.0 B
2023-12-12T18:27:35.070154image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length37
Median length37
Mean length37
Min length37

Characters and Unicode

Total characters37
Distinct characters31
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row잭팟 당첨고객에게 과세금액 만큼 프로모션티켓을 지급하여 재방문 유도
ValueCountFrequency (%)
잭팟 1
12.5%
당첨고객에게 1
12.5%
과세금액 1
12.5%
만큼 1
12.5%
프로모션티켓을 1
12.5%
지급하여 1
12.5%
재방문 1
12.5%
유도 1
12.5%
2023-12-12T18:27:35.443180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7
 
18.9%
잭 1
 
2.7%
로 1
 
2.7%
유 1
 
2.7%
문 1
 
2.7%
방 1
 
2.7%
재 1
 
2.7%
여 1
 
2.7%
하 1
 
2.7%
급 1
 
2.7%
Other values (21) 21
56.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 30
81.1%
Space Separator 7
 
18.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
잭 1
 
3.3%
로 1
 
3.3%
유 1
 
3.3%
문 1
 
3.3%
방 1
 
3.3%
재 1
 
3.3%
여 1
 
3.3%
하 1
 
3.3%
급 1
 
3.3%
지 1
 
3.3%
Other values (20) 20
66.7%
Space Separator
ValueCountFrequency (%)
7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 30
81.1%
Common 7
 
18.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
잭 1
 
3.3%
로 1
 
3.3%
유 1
 
3.3%
문 1
 
3.3%
방 1
 
3.3%
재 1
 
3.3%
여 1
 
3.3%
하 1
 
3.3%
급 1
 
3.3%
지 1
 
3.3%
Other values (20) 20
66.7%
Common
ValueCountFrequency (%)
7
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 30
81.1%
ASCII 7
 
18.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7
100.0%
Hangul
ValueCountFrequency (%)
잭 1
 
3.3%
로 1
 
3.3%
유 1
 
3.3%
문 1
 
3.3%
방 1
 
3.3%
재 1
 
3.3%
여 1
 
3.3%
하 1
 
3.3%
급 1
 
3.3%
지 1
 
3.3%
Other values (20) 20
66.7%

Correlations

2023-12-12T18:27:35.556644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이벤트시작일이벤트종료일이벤트명
이벤트시작일1.0000.9980.698
이벤트종료일0.9981.0000.813
이벤트명0.6980.8131.000

Missing values

2023-12-12T18:27:33.089453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:27:33.236547image/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힐튼2017-01-232017-01-30힐튼점 설맞이 사은행사(프로모션)<NA>
1힐튼2017-01-232017-01-30힐튼점 설맞이 사은행사(사은품)<NA>
2힐튼2017-01-232017-06-30힐튼점 머신 우량고객 티켓지급 행사<NA>
3힐튼2017-02-062017-03-05힐튼점 세븐볼 추첨 이벤트<NA>
4힐튼2017-03-202017-12-31힐튼점 신규 고객 알선자 프로모션<NA>
5힐튼2017-03-202017-04-15힐튼점 Happy Hour 프로모션<NA>
6힐튼2017-04-172017-05-11힐튼점 Daily 추첨 프로모션<NA>
7힐튼2017-05-222017-05-31힐튼점 11주년 고객감사 이벤트<NA>
8힐튼2017-06-262017-07-30힐튼점 잭팟프리 이벤트 1차<NA>
9힐튼2017-08-072017-08-31힐튼점 즉석스크래치복권<NA>
지점이벤트시작일이벤트종료일이벤트명주요내용
37힐튼2019-12-092019-12-29힐튼점 송년맞이 사은행사(사은품)<NA>
38힐튼2020-01-202020-02-02힐튼점 설맞이 사은행사(일일)<NA>
39힐튼2020-02-012020-06-30힐튼점 머신게임 REWARD 행사<NA>
40힐튼2020-02-102020-03-08힐튼점 TAX PAYBACK 이벤트<NA>
41힐튼2020-02-102020-03-22힐튼점 WEEKLY REWARD 이벤트<NA>
42힐튼2020-03-092020-05-31힐튼점 스크래치 복권 추첨 이벤트<NA>
43힐튼2020-09-012020-04-15힐튼점 머신게임 REWARD 행사<NA>
44힐튼2020-09-282020-10-18힐튼점 추석맞이 사은행사<NA>
45힐튼2020-10-192020-11-15힐튼점 TAX PAYBACK잭팟 당첨고객에게 과세금액 만큼 프로모션티켓을 지급하여 재방문 유도
46힐튼2021-05-012021-08-31힐튼점 머신게임 REWARD 행사<NA>