Dataset statistics
Number of variables | 20 |
---|---|
Number of observations | 50 |
Missing cells | 80 |
Missing cells (%) | 8.0% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 8.2 KiB |
Average record size in memory | 167.6 B |
Variable types
Numeric | 4 |
---|---|
Categorical | 14 |
Text | 1 |
Unsupported | 1 |
Dataset
Description | Sample |
---|---|
Author | 원투씨엠 |
URL | https://www.bigdata-culture.kr/bigdata/user/data_market/detail.do?id=8e487640-107e-11ec-9737-f9caa5f56514 |
SLE_CHNNEL_URL has constant value "" | Constant |
TICKET_OPTN_CD is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TRRSRT_NM is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
TURSM_COURS_CD is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
PRCHS_ID is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TICKET_USE_PLACE_NM is highly overall correlated with PRCHS_DT and 14 other fields | High correlation |
TURSM_COURS_NM is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
TICKET_SLE_BRAND_NM is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
USER_KEY_NM is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TICKET_OPTN_NM is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TRRSRT_ADDR is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TICKET_SLE_CHNNEL_NM is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
TRRSRT_CD is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
SEQ_NO is highly overall correlated with PRCHS_DT and 14 other fields | High correlation |
PRCHS_DT is highly overall correlated with SEQ_NO and 14 other fields | High correlation |
TICKET_VALID_DT is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
USE_DT is highly overall correlated with SEQ_NO and 9 other fields | High correlation |
TICKET_USGSTT_NM is highly overall correlated with SEQ_NO and 15 other fields | High correlation |
USE_DT has 30 (60.0%) missing values | Missing |
USE_CANCL_DT has 50 (100.0%) missing values | Missing |
SEQ_NO has unique values | Unique |
TICKET_ID has unique values | Unique |
USE_CANCL_DT is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2023-12-10 10:04:02.488580 |
---|---|
Analysis finished | 2023-12-10 10:04:10.210849 |
Duration | 7.72 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
SEQ_NO
Real number (ℝ)
HIGH CORRELATION
  UNIQUE
 
Distinct | 50 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 179452.5 |
Minimum | 179428 |
---|---|
Maximum | 179477 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 582.0 B |
Quantile statistics
Minimum | 179428 |
---|---|
5-th percentile | 179430.45 |
Q1 | 179440.25 |
median | 179452.5 |
Q3 | 179464.75 |
95-th percentile | 179474.55 |
Maximum | 179477 |
Range | 49 |
Interquartile range (IQR) | 24.5 |
Descriptive statistics
Standard deviation | 14.57738 |
---|---|
Coefficient of variation (CV) | 8.1232525 × 10-5 |
Kurtosis | -1.2 |
Mean | 179452.5 |
Median Absolute Deviation (MAD) | 12.5 |
Skewness | 0 |
Sum | 8972625 |
Variance | 212.5 |
Monotonicity | Strictly increasing |
Value | Count | Frequency (%) |
179428 | 1 | 2.0% |
179466 | 1 | 2.0% |
179456 | 1 | 2.0% |
179457 | 1 | 2.0% |
179458 | 1 | 2.0% |
179459 | 1 | 2.0% |
179460 | 1 | 2.0% |
179461 | 1 | 2.0% |
179462 | 1 | 2.0% |
179463 | 1 | 2.0% |
Other values (40) | 40 |
Value | Count | Frequency (%) |
179428 | 1 | |
179429 | 1 | |
179430 | 1 | |
179431 | 1 | |
179432 | 1 | |
179433 | 1 | |
179434 | 1 | |
179435 | 1 | |
179436 | 1 | |
179437 | 1 |
Value | Count | Frequency (%) |
179477 | 1 | |
179476 | 1 | |
179475 | 1 | |
179474 | 1 | |
179473 | 1 | |
179472 | 1 | |
179471 | 1 | |
179470 | 1 | |
179469 | 1 | |
179468 | 1 |
USER_KEY_NM
Categorical
HIGH CORRELATION
 
Distinct | 5 |
---|---|
Distinct (%) | 10.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | |
---|---|
1f112e73b81a9a8e386a96c410918e508244a4a3 | |
e79b6f696c4aca9bf56a24a3b34280d40362efe3 | |
e43582c2d0008590cfa43e51cacd7c0d088df5d1 | |
0f54d0222aac4123cfd4e123b02d13243c18bf8b |
Length
Max length | 40 |
---|---|
Median length | 40 |
Mean length | 40 |
Min length | 40 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | e43582c2d0008590cfa43e51cacd7c0d088df5d1 |
---|---|
2nd row | e43582c2d0008590cfa43e51cacd7c0d088df5d1 |
3rd row | e79b6f696c4aca9bf56a24a3b34280d40362efe3 |
4th row | e79b6f696c4aca9bf56a24a3b34280d40362efe3 |
5th row | e79b6f696c4aca9bf56a24a3b34280d40362efe3 |
Common Values
Value | Count | Frequency (%) |
609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | 18 | |
1f112e73b81a9a8e386a96c410918e508244a4a3 | 16 | |
e79b6f696c4aca9bf56a24a3b34280d40362efe3 | 12 | |
e43582c2d0008590cfa43e51cacd7c0d088df5d1 | 2 | 4.0% |
0f54d0222aac4123cfd4e123b02d13243c18bf8b | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | 18 | |
1f112e73b81a9a8e386a96c410918e508244a4a3 | 16 | |
e79b6f696c4aca9bf56a24a3b34280d40362efe3 | 12 | |
e43582c2d0008590cfa43e51cacd7c0d088df5d1 | 2 | 4.0% |
0f54d0222aac4123cfd4e123b02d13243c18bf8b | 2 | 4.0% |
PRCHS_ID
Categorical
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 12.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
ODTK-20200802-FCGRGJ-RNM | |
---|---|
ODTK-20200802-KQELRL-EQJ | |
ODTK-20200802-ZKJTIY-HNT | |
ODTK-20200802-OFELZH-AMA | |
ODTK-20200802-AUUVYF-DAX |
Length
Max length | 24 |
---|---|
Median length | 24 |
Mean length | 24 |
Min length | 24 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | ODTK-20200802-AUUVYF-DAX |
---|---|
2nd row | ODTK-20200802-AUUVYF-DAX |
3rd row | ODTK-20200802-ZKJTIY-HNT |
4th row | ODTK-20200802-ZKJTIY-HNT |
5th row | ODTK-20200802-ZKJTIY-HNT |
Common Values
Value | Count | Frequency (%) |
ODTK-20200802-FCGRGJ-RNM | 18 | |
ODTK-20200802-KQELRL-EQJ | 16 | |
ODTK-20200802-ZKJTIY-HNT | 6 | 12.0% |
ODTK-20200802-OFELZH-AMA | 6 | 12.0% |
ODTK-20200802-AUUVYF-DAX | 2 | 4.0% |
ODTK-20200802-BJFDLE-HAX | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
odtk-20200802-fcgrgj-rnm | 18 | |
odtk-20200802-kqelrl-eqj | 16 | |
odtk-20200802-zkjtiy-hnt | 6 | 12.0% |
odtk-20200802-ofelzh-ama | 6 | 12.0% |
odtk-20200802-auuvyf-dax | 2 | 4.0% |
odtk-20200802-bjfdle-hax | 2 | 4.0% |
TICKET_ID
Text
UNIQUE
 
Distinct | 50 |
---|---|
Distinct (%) | 100.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
Length
Max length | 20 |
---|---|
Median length | 13 |
Mean length | 13.14 |
Min length | 13 |
Characters and Unicode
Total characters | 657 |
---|---|
Distinct characters | 19 |
Distinct categories | 2 ? |
Distinct scripts | 2 ? |
Distinct blocks | 1 ? |
Unique
Unique | 50 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | 4203026669785 |
---|---|
2nd row | 7962678307545 |
3rd row | 1274996522190 |
4th row | 7927265907822 |
5th row | 2212187496448 |
Value | Count | Frequency (%) |
4203026669785 | 1 | 2.0% |
1084701383074 | 1 | 2.0% |
1882532433165 | 1 | 2.0% |
3115682770207 | 1 | 2.0% |
6073962357587 | 1 | 2.0% |
1349052009307 | 1 | 2.0% |
4843098578366 | 1 | 2.0% |
200802bjfdlehax00168 | 1 | 2.0% |
4440241441053 | 1 | 2.0% |
9971337494095 | 1 | 2.0% |
Other values (40) | 40 |
Most occurring characters
Value | Count | Frequency (%) |
4 | 73 | |
3 | 73 | |
1 | 73 | |
0 | 69 | |
7 | 64 | |
5 | 64 | |
8 | 62 | |
2 | 59 | |
6 | 57 | |
9 | 54 | |
Other values (9) | 9 | 1.4% |
Most occurring categories
Value | Count | Frequency (%) |
Decimal Number | 648 | |
Uppercase Letter | 9 | 1.4% |
Most frequent character per category
Decimal Number
Value | Count | Frequency (%) |
4 | 73 | |
3 | 73 | |
1 | 73 | |
0 | 69 | |
7 | 64 | |
5 | 64 | |
8 | 62 | |
2 | 59 | |
6 | 57 | |
9 | 54 |
Uppercase Letter
Value | Count | Frequency (%) |
B | 1 | |
J | 1 | |
F | 1 | |
D | 1 | |
L | 1 | |
E | 1 | |
H | 1 | |
A | 1 | |
X | 1 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 648 | |
Latin | 9 | 1.4% |
Most frequent character per script
Common
Value | Count | Frequency (%) |
4 | 73 | |
3 | 73 | |
1 | 73 | |
0 | 69 | |
7 | 64 | |
5 | 64 | |
8 | 62 | |
2 | 59 | |
6 | 57 | |
9 | 54 |
Latin
Value | Count | Frequency (%) |
B | 1 | |
J | 1 | |
F | 1 | |
D | 1 | |
L | 1 | |
E | 1 | |
H | 1 | |
A | 1 | |
X | 1 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 657 |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
4 | 73 | |
3 | 73 | |
1 | 73 | |
0 | 69 | |
7 | 64 | |
5 | 64 | |
8 | 62 | |
2 | 59 | |
6 | 57 | |
9 | 54 | |
Other values (9) | 9 | 1.4% |
TICKET_USGSTT_NM
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
취소 | |
---|---|
사용 | |
사용만료 |
Length
Max length | 4 |
---|---|
Median length | 2 |
Mean length | 2.4 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 취소 |
---|---|
2nd row | 취소 |
3rd row | 사용만료 |
4th row | 사용만료 |
5th row | 사용 |
Common Values
Value | Count | Frequency (%) |
취소 | 20 | |
사용 | 20 | |
사용만료 | 10 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
취소 | 20 | |
사용 | 20 | |
사용만료 | 10 |
TURSM_COURS_CD
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
PROD00000428 | |
---|---|
PROD00000076 | |
PROD00000362 | 2 |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | PROD00000428 |
---|---|
2nd row | PROD00000428 |
3rd row | PROD00000428 |
4th row | PROD00000428 |
5th row | PROD00000428 |
Common Values
Value | Count | Frequency (%) |
PROD00000428 | 30 | |
PROD00000076 | 18 | |
PROD00000362 | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
prod00000428 | 30 | |
prod00000076 | 18 | |
prod00000362 | 2 | 4.0% |
TURSM_COURS_NM
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
경북나드리 울진(덕구온천 스파월드+관광지패키지) | |
---|---|
경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | |
경북나드리 경주(경주월드+엑스포공원) | 2 |
Length
Max length | 38 |
---|---|
Median length | 26 |
Mean length | 30.08 |
Min length | 20 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 경북나드리 울진(덕구온천 스파월드+관광지패키지) |
---|---|
2nd row | 경북나드리 울진(덕구온천 스파월드+관광지패키지) |
3rd row | 경북나드리 울진(덕구온천 스파월드+관광지패키지) |
4th row | 경북나드리 울진(덕구온천 스파월드+관광지패키지) |
5th row | 경북나드리 울진(덕구온천 스파월드+관광지패키지) |
Common Values
Value | Count | Frequency (%) |
경북나드리 울진(덕구온천 스파월드+관광지패키지) | 30 | |
경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | 18 | |
경북나드리 경주(경주월드+엑스포공원) | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
경북나드리 | 50 | |
울진(덕구온천 | 30 | |
스파월드+관광지패키지 | 30 | |
상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관 | 18 | 13.8% |
경주(경주월드+엑스포공원 | 2 | 1.5% |
TICKET_OPTN_CD
Categorical
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 12.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
OPTI00001413 | |
---|---|
OPTI00001347 | |
OPTI00001344 | |
OPTI00001346 | |
OPTI00001349 |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | OPTI00001347 |
---|---|
2nd row | OPTI00001347 |
3rd row | OPTI00001347 |
4th row | OPTI00001347 |
5th row | OPTI00001347 |
Common Values
Value | Count | Frequency (%) |
OPTI00001413 | 18 | |
OPTI00001347 | 8 | |
OPTI00001344 | 8 | |
OPTI00001346 | 8 | |
OPTI00001349 | 6 | 12.0% |
OPTI00001254 | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
opti00001413 | 18 | |
opti00001347 | 8 | |
opti00001344 | 8 | |
opti00001346 | 8 | |
opti00001349 | 6 | 12.0% |
opti00001254 | 2 | 4.0% |
TICKET_OPTN_NM
Categorical
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 12.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
2.소인 | |
---|---|
2-1.성인 | |
1-1.성인 | |
1-3.소인 | |
2-3.소인 |
Length
Max length | 8 |
---|---|
Median length | 6 |
Mean length | 5.36 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2-1.성인 |
---|---|
2nd row | 2-1.성인 |
3rd row | 2-1.성인 |
4th row | 2-1.성인 |
5th row | 2-1.성인 |
Common Values
Value | Count | Frequency (%) |
2.소인 | 18 | |
2-1.성인 | 8 | |
1-1.성인 | 8 | |
1-3.소인 | 8 | |
2-3.소인 | 6 | 12.0% |
3.4시권 성인 | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2.소인 | 18 | |
2-1.성인 | 8 | |
1-1.성인 | 8 | |
1-3.소인 | 8 | |
2-3.소인 | 6 | 11.5% |
3.4시권 | 2 | 3.8% |
성인 | 2 | 3.8% |
TRRSRT_CD
Categorical
HIGH CORRELATION
 
Distinct | 15 |
---|---|
Distinct (%) | 30.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
P00000001066 | |
---|---|
P00000001007 | |
P00000001008 | |
P00000001005 | |
P00000001820 | |
Other values (10) |
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | P00000001066 |
---|---|
2nd row | P00000001066 |
3rd row | P00000001057 |
4th row | P00000001057 |
5th row | P00000001820 |
Common Values
Value | Count | Frequency (%) |
P00000001066 | 10 | |
P00000001007 | 5 | |
P00000001008 | 5 | |
P00000001005 | 5 | |
P00000001820 | 4 | 8.0% |
P00000001822 | 4 | 8.0% |
P00000001009 | 3 | 6.0% |
P00000001057 | 2 | 4.0% |
P00000001059 | 2 | 4.0% |
P00000001054 | 2 | 4.0% |
Other values (5) | 8 |
Length
Value | Count | Frequency (%) |
p00000001066 | 10 | |
p00000001007 | 5 | |
p00000001008 | 5 | |
p00000001005 | 5 | |
p00000001820 | 4 | 8.0% |
p00000001822 | 4 | 8.0% |
p00000001009 | 3 | 6.0% |
p00000001057 | 2 | 4.0% |
p00000001059 | 2 | 4.0% |
p00000001054 | 2 | 4.0% |
Other values (5) | 8 |
TRRSRT_NM
Categorical
HIGH CORRELATION
 
Distinct | 15 |
---|---|
Distinct (%) | 30.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
[울진]커피방 | |
---|---|
[상주]국립낙동강생물자원관_소인 | |
[상주]국제승마장_소인 | |
[상주]박물관_소인 | |
[울진]스파월드_성수기/성인 | |
Other values (10) |
Length
Max length | 20 |
---|---|
Median length | 17 |
Mean length | 13.06 |
Min length | 7 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | [울진]커피방 |
---|---|
2nd row | [울진]커피방 |
3rd row | [울진]과학체험관_성인 |
4th row | [울진]과학체험관_성인 |
5th row | [울진]스파월드_성수기/성인 |
Common Values
Value | Count | Frequency (%) |
[울진]커피방 | 10 | |
[상주]국립낙동강생물자원관_소인 | 5 | |
[상주]국제승마장_소인 | 5 | |
[상주]박물관_소인 | 5 | |
[울진]스파월드_성수기/성인 | 4 | 8.0% |
[울진]스파월드_성수기/소인 | 4 | 8.0% |
[상주]수상레저센터_소인 | 3 | 6.0% |
[울진]과학체험관_성인 | 2 | 4.0% |
[울진]과학체험관_소인 | 2 | 4.0% |
[울진]엑스포공원 곤충여행체험관_성인 | 2 | 4.0% |
Other values (5) | 8 |
Length
Value | Count | Frequency (%) |
울진]커피방 | 10 | |
울진]엑스포공원 | 8 | |
상주]국립낙동강생물자원관_소인 | 5 | |
상주]국제승마장_소인 | 5 | |
상주]박물관_소인 | 5 | |
울진]스파월드_성수기/성인 | 4 | 6.9% |
울진]스파월드_성수기/소인 | 4 | 6.9% |
상주]수상레저센터_소인 | 3 | 5.2% |
울진]과학체험관_성인 | 2 | 3.4% |
울진]과학체험관_소인 | 2 | 3.4% |
Other values (6) | 10 |
TRRSRT_ADDR
Categorical
HIGH CORRELATION
 
Distinct | 10 |
---|---|
Distinct (%) | 20.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
경북 울진군 근남면 산포3길 162 2층 | |
---|---|
경북 울진군 북면 덕구온천로 924 | |
경북 울진군 근남면 수산리 63 | |
경상북도 상주시 도남2길 137 국립낙동강생물자원관 | |
경상북도 상주시 사벌국면 화달리 산23 상주국제승마장 | |
Other values (5) |
Length
Max length | 29 |
---|---|
Median length | 22 |
Mean length | 20.8 |
Min length | 14 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | 경북 울진군 근남면 산포3길 162 2층 |
---|---|
2nd row | 경북 울진군 근남면 산포3길 162 2층 |
3rd row | 경북 울진군 울진읍 연지길 30 |
4th row | 경북 울진군 울진읍 연지길 30 |
5th row | 경북 울진군 북면 덕구온천로 924 |
Common Values
Value | Count | Frequency (%) |
경북 울진군 근남면 산포3길 162 2층 | 10 | |
경북 울진군 북면 덕구온천로 924 | 8 | |
경북 울진군 근남면 수산리 63 | 8 | |
경상북도 상주시 도남2길 137 국립낙동강생물자원관 | 5 | |
경상북도 상주시 사벌국면 화달리 산23 상주국제승마장 | 5 | |
경상북도 상주시 사벌국면 경천로 684 | 5 | |
경북 울진군 울진읍 연지길 30 | 4 | 8.0% |
경북 상주시 용마로 366 | 3 | 6.0% |
경북 경주시 천군동 148-4 | 1 | 2.0% |
경북 경주시 천군동 191-5 | 1 | 2.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
경북 | 35 | 13.5% |
울진군 | 30 | 11.5% |
근남면 | 18 | 6.9% |
상주시 | 18 | 6.9% |
경상북도 | 15 | 5.8% |
산포3길 | 10 | 3.8% |
162 | 10 | 3.8% |
2층 | 10 | 3.8% |
사벌국면 | 10 | 3.8% |
63 | 8 | 3.1% |
Other values (21) | 96 |
TICKET_SLE_CHNNEL_NM
Categorical
HIGH CORRELATION
 
Distinct | 4 |
---|---|
Distinct (%) | 8.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
쿠팡 | |
---|---|
옥션 | |
티몬 | 2 |
G마켓 | 2 |
Length
Max length | 3 |
---|---|
Median length | 2 |
Mean length | 2.04 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 티몬 |
---|---|
2nd row | 티몬 |
3rd row | 쿠팡 |
4th row | 쿠팡 |
5th row | 쿠팡 |
Common Values
Value | Count | Frequency (%) |
쿠팡 | 30 | |
옥션 | 16 | |
티몬 | 2 | 4.0% |
G마켓 | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
쿠팡 | 30 | |
옥션 | 16 | |
티몬 | 2 | 4.0% |
g마켓 | 2 | 4.0% |
SLE_CHNNEL_URL
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
- |
---|
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | - |
---|---|
2nd row | - |
3rd row | - |
4th row | - |
5th row | - |
Common Values
Value | Count | Frequency (%) |
- | 50 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
50 |
PRCHS_DT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 6 |
---|---|
Distinct (%) | 12.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0200802 × 1013 |
Minimum | 2.0200802 × 1013 |
---|---|
Maximum | 2.0200802 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 582.0 B |
Quantile statistics
Minimum | 2.0200802 × 1013 |
---|---|
5-th percentile | 2.0200802 × 1013 |
Q1 | 2.0200802 × 1013 |
median | 2.0200802 × 1013 |
Q3 | 2.0200802 × 1013 |
95-th percentile | 2.0200802 × 1013 |
Maximum | 2.0200802 × 1013 |
Range | 1785 |
Interquartile range (IQR) | 1662 |
Descriptive statistics
Standard deviation | 757.89467 |
---|---|
Coefficient of variation (CV) | 3.7518049 × 10-11 |
Kurtosis | -1.7010728 |
Mean | 2.0200802 × 1013 |
Median Absolute Deviation (MAD) | 342 |
Skewness | 0.44986937 |
Sum | 1.0100401 × 1015 |
Variance | 574404.34 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
20200802095620 | 18 | |
20200802094200 | 16 | |
20200802093858 | 6 | 12.0% |
20200802093958 | 6 | 12.0% |
20200802093835 | 2 | 4.0% |
20200802094700 | 2 | 4.0% |
Value | Count | Frequency (%) |
20200802093835 | 2 | 4.0% |
20200802093858 | 6 | 12.0% |
20200802093958 | 6 | 12.0% |
20200802094200 | 16 | |
20200802094700 | 2 | 4.0% |
20200802095620 | 18 |
Value | Count | Frequency (%) |
20200802095620 | 18 | |
20200802094700 | 2 | 4.0% |
20200802094200 | 16 | |
20200802093958 | 6 | 12.0% |
20200802093858 | 6 | 12.0% |
20200802093835 | 2 | 4.0% |
TICKET_VALID_DT
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 7 |
---|---|
Distinct (%) | 14.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0200928 × 1013 |
Minimum | 2.0200812 × 1013 |
---|---|
Maximum | 2.020113 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 582.0 B |
Quantile statistics
Minimum | 2.0200812 × 1013 |
---|---|
5-th percentile | 2.0200812 × 1013 |
Q1 | 2.0200812 × 1013 |
median | 2.0200814 × 1013 |
Q3 | 2.020113 × 1013 |
95-th percentile | 2.020113 × 1013 |
Maximum | 2.020113 × 1013 |
Range | 3.1811406 × 108 |
Interquartile range (IQR) | 3.181053 × 108 |
Descriptive statistics
Standard deviation | 1.5317632 × 108 |
---|---|
Coefficient of variation (CV) | 7.5826378 × 10-6 |
Kurtosis | -1.7079671 |
Mean | 2.0200928 × 1013 |
Median Absolute Deviation (MAD) | 1982209 |
Skewness | 0.6004653 |
Sum | 1.0100464 × 1015 |
Variance | 2.3462985 × 1016 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20201130235959 | 18 | |
20200814104109 | 7 | 14.0% |
20200814104110 | 7 | 14.0% |
20200812121901 | 6 | 12.0% |
20200812122123 | 6 | 12.0% |
20200823235959 | 4 | 8.0% |
20200812130659 | 2 | 4.0% |
Value | Count | Frequency (%) |
20200812121901 | 6 | 12.0% |
20200812122123 | 6 | 12.0% |
20200812130659 | 2 | 4.0% |
20200814104109 | 7 | 14.0% |
20200814104110 | 7 | 14.0% |
20200823235959 | 4 | 8.0% |
20201130235959 | 18 |
Value | Count | Frequency (%) |
20201130235959 | 18 | |
20200823235959 | 4 | 8.0% |
20200814104110 | 7 | 14.0% |
20200814104109 | 7 | 14.0% |
20200812130659 | 2 | 4.0% |
20200812122123 | 6 | 12.0% |
20200812121901 | 6 | 12.0% |
USE_DT
Real number (ℝ)
HIGH CORRELATION
  MISSING
 
Distinct | 9 |
---|---|
Distinct (%) | 45.0% |
Missing | 30 |
Missing (%) | 60.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.0200805 × 1013 |
Minimum | 2.0200802 × 1013 |
---|---|
Maximum | 2.0200807 × 1013 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 582.0 B |
Quantile statistics
Minimum | 2.0200802 × 1013 |
---|---|
5-th percentile | 2.0200802 × 1013 |
Q1 | 2.0200802 × 1013 |
median | 2.0200806 × 1013 |
Q3 | 2.0200807 × 1013 |
95-th percentile | 2.0200807 × 1013 |
Maximum | 2.0200807 × 1013 |
Range | 5009002 |
Interquartile range (IQR) | 4958755 |
Descriptive statistics
Standard deviation | 2264628.5 |
---|---|
Coefficient of variation (CV) | 1.1210585 × 10-7 |
Kurtosis | -1.850897 |
Mean | 2.0200805 × 1013 |
Median Absolute Deviation (MAD) | 1510174 |
Skewness | -0.27855763 |
Sum | 4.040161 × 1014 |
Variance | 5.1285422 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
20200807105020 | 4 | 8.0% |
20200807113239 | 4 | 8.0% |
20200804101110 | 3 | 6.0% |
20200802114901 | 2 | 4.0% |
20200802115123 | 2 | 4.0% |
20200807123903 | 2 | 4.0% |
20200804101109 | 1 | 2.0% |
20200802123659 | 1 | 2.0% |
20200802164759 | 1 | 2.0% |
(Missing) | 30 |
Value | Count | Frequency (%) |
20200802114901 | 2 | |
20200802115123 | 2 | |
20200802123659 | 1 | 2.0% |
20200802164759 | 1 | 2.0% |
20200804101109 | 1 | 2.0% |
20200804101110 | 3 | |
20200807105020 | 4 | |
20200807113239 | 4 | |
20200807123903 | 2 |
Value | Count | Frequency (%) |
20200807123903 | 2 | |
20200807113239 | 4 | |
20200807105020 | 4 | |
20200804101110 | 3 | |
20200804101109 | 1 | 2.0% |
20200802164759 | 1 | 2.0% |
20200802123659 | 1 | 2.0% |
20200802115123 | 2 | |
20200802114901 | 2 |
USE_CANCL_DT
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 50 |
---|---|
Missing (%) | 100.0% |
Memory size | 582.0 B |
TICKET_SLE_BRAND_NM
Categorical
HIGH CORRELATION
 
Distinct | 3 |
---|---|
Distinct (%) | 6.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
울진 e누리 | |
---|---|
상주 e누리 | |
경주 e누리 | 2 |
Length
Max length | 6 |
---|---|
Median length | 6 |
Mean length | 6 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 울진 e누리 |
---|---|
2nd row | 울진 e누리 |
3rd row | 울진 e누리 |
4th row | 울진 e누리 |
5th row | 울진 e누리 |
Common Values
Value | Count | Frequency (%) |
울진 e누리 | 30 | |
상주 e누리 | 18 | |
경주 e누리 | 2 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
e누리 | 50 | |
울진 | 30 | |
상주 | 18 | 18.0% |
경주 | 2 | 2.0% |
TICKET_USE_PLACE_NM
Categorical
HIGH CORRELATION
 
Distinct | 8 |
---|---|
Distinct (%) | 16.0% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 532.0 B |
- | |
---|---|
[울진] 덕구온천 | |
[울진] 커피방 | |
[울진] 과학 체험관 | |
[울진] 엑스포공원 곤충체험여행관 | |
Other values (3) |
Length
Max length | 18 |
---|---|
Median length | 16 |
Mean length | 7.1 |
Min length | 1 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 4.0% |
Sample
1st row | - |
---|---|
2nd row | - |
3rd row | [울진] 과학 체험관 |
4th row | [울진] 과학 체험관 |
5th row | [울진] 덕구온천 |
Common Values
Value | Count | Frequency (%) |
- | 20 | |
[울진] 덕구온천 | 8 | 16.0% |
[울진] 커피방 | 8 | 16.0% |
[울진] 과학 체험관 | 4 | 8.0% |
[울진] 엑스포공원 곤충체험여행관 | 4 | 8.0% |
[울진] 엑스포공원 아쿠아리움 | 4 | 8.0% |
[경주] 엑스포공원 | 1 | 2.0% |
[경주] 경주월드 | 1 | 2.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
울진 | 28 | |
20 | ||
엑스포공원 | 9 | 9.8% |
덕구온천 | 8 | 8.7% |
커피방 | 8 | 8.7% |
과학 | 4 | 4.3% |
체험관 | 4 | 4.3% |
곤충체험여행관 | 4 | 4.3% |
아쿠아리움 | 4 | 4.3% |
경주 | 2 | 2.2% |
SEQ_NO | USER_KEY_NM | PRCHS_ID | TICKET_ID | TICKET_USGSTT_NM | TURSM_COURS_CD | TURSM_COURS_NM | TICKET_OPTN_CD | TICKET_OPTN_NM | TRRSRT_CD | TRRSRT_NM | TRRSRT_ADDR | TICKET_SLE_CHNNEL_NM | PRCHS_DT | TICKET_VALID_DT | USE_DT | TICKET_SLE_BRAND_NM | TICKET_USE_PLACE_NM | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 0.957 | 0.866 | 1.000 | 0.821 | 0.851 | 0.851 | 0.861 | 0.861 | 0.903 | 0.903 | 0.921 | 0.801 | 0.923 | 0.993 | 0.726 | 0.851 | 0.768 |
USER_KEY_NM | 0.957 | 1.000 | 1.000 | 1.000 | 0.785 | 1.000 | 1.000 | 0.915 | 0.915 | 0.948 | 0.948 | 0.967 | 1.000 | 1.000 | 1.000 | 0.923 | 1.000 | 0.848 |
PRCHS_ID | 0.866 | 1.000 | 1.000 | 1.000 | 0.972 | 1.000 | 1.000 | 0.994 | 0.994 | 0.892 | 0.892 | 0.833 | 1.000 | 1.000 | 1.000 | 0.923 | 1.000 | 0.815 |
TICKET_ID | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
TICKET_USGSTT_NM | 0.821 | 0.785 | 0.972 | 1.000 | 1.000 | 0.916 | 0.916 | 0.959 | 0.959 | 0.983 | 0.983 | 0.910 | 0.513 | 0.754 | 0.643 | NaN | 0.916 | 0.930 |
TURSM_COURS_CD | 0.851 | 1.000 | 1.000 | 1.000 | 0.916 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.760 | 1.000 | 1.000 | 0.383 | 1.000 | 0.943 |
TURSM_COURS_NM | 0.851 | 1.000 | 1.000 | 1.000 | 0.916 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.760 | 1.000 | 1.000 | 0.383 | 1.000 | 0.943 |
TICKET_OPTN_CD | 0.861 | 0.915 | 0.994 | 1.000 | 0.959 | 1.000 | 1.000 | 1.000 | 1.000 | 0.931 | 0.931 | 0.816 | 0.940 | 1.000 | 1.000 | 0.618 | 1.000 | 0.794 |
TICKET_OPTN_NM | 0.861 | 0.915 | 0.994 | 1.000 | 0.959 | 1.000 | 1.000 | 1.000 | 1.000 | 0.931 | 0.931 | 0.816 | 0.940 | 1.000 | 1.000 | 0.618 | 1.000 | 0.794 |
TRRSRT_CD | 0.903 | 0.948 | 0.892 | 1.000 | 0.983 | 1.000 | 1.000 | 0.931 | 0.931 | 1.000 | 1.000 | 1.000 | 0.840 | 0.941 | 1.000 | 0.952 | 1.000 | 0.993 |
TRRSRT_NM | 0.903 | 0.948 | 0.892 | 1.000 | 0.983 | 1.000 | 1.000 | 0.931 | 0.931 | 1.000 | 1.000 | 1.000 | 0.840 | 0.941 | 1.000 | 0.952 | 1.000 | 0.993 |
TRRSRT_ADDR | 0.921 | 0.967 | 0.833 | 1.000 | 0.910 | 1.000 | 1.000 | 0.816 | 0.816 | 1.000 | 1.000 | 1.000 | 0.858 | 0.948 | 1.000 | 0.754 | 1.000 | 0.962 |
TICKET_SLE_CHNNEL_NM | 0.801 | 1.000 | 1.000 | 1.000 | 0.513 | 0.760 | 0.760 | 0.940 | 0.940 | 0.840 | 0.840 | 0.858 | 1.000 | 1.000 | 0.917 | 0.923 | 0.760 | 0.945 |
PRCHS_DT | 0.923 | 1.000 | 1.000 | 1.000 | 0.754 | 1.000 | 1.000 | 1.000 | 1.000 | 0.941 | 0.941 | 0.948 | 1.000 | 1.000 | 1.000 | 0.923 | 1.000 | 0.992 |
TICKET_VALID_DT | 0.993 | 1.000 | 1.000 | 1.000 | 0.643 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.917 | 1.000 | 1.000 | NaN | 1.000 | 0.986 |
USE_DT | 0.726 | 0.923 | 0.923 | 1.000 | NaN | 0.383 | 0.383 | 0.618 | 0.618 | 0.952 | 0.952 | 0.754 | 0.923 | 0.923 | NaN | 1.000 | 0.383 | 0.952 |
TICKET_SLE_BRAND_NM | 0.851 | 1.000 | 1.000 | 1.000 | 0.916 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.760 | 1.000 | 1.000 | 0.383 | 1.000 | 0.943 |
TICKET_USE_PLACE_NM | 0.768 | 0.848 | 0.815 | 1.000 | 0.930 | 0.943 | 0.943 | 0.794 | 0.794 | 0.993 | 0.993 | 0.962 | 0.945 | 0.992 | 0.986 | 0.952 | 0.943 | 1.000 |
TICKET_OPTN_CD | TRRSRT_NM | TURSM_COURS_CD | PRCHS_ID | TICKET_USE_PLACE_NM | TURSM_COURS_NM | TICKET_SLE_BRAND_NM | USER_KEY_NM | TICKET_USGSTT_NM | TICKET_OPTN_NM | TRRSRT_ADDR | TICKET_SLE_CHNNEL_NM | TRRSRT_CD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TICKET_OPTN_CD | 1.000 | 0.678 | 0.968 | 0.882 | 0.586 | 0.968 | 0.968 | 0.860 | 0.730 | 1.000 | 0.580 | 0.820 | 0.678 |
TRRSRT_NM | 0.678 | 1.000 | 0.863 | 0.602 | 0.887 | 0.863 | 0.863 | 0.621 | 0.732 | 0.678 | 0.935 | 0.572 | 1.000 |
TURSM_COURS_CD | 0.968 | 0.863 | 1.000 | 0.968 | 0.900 | 1.000 | 1.000 | 0.978 | 0.645 | 0.968 | 0.923 | 0.803 | 0.863 |
PRCHS_ID | 0.882 | 0.602 | 0.968 | 1.000 | 0.616 | 0.968 | 0.968 | 0.989 | 0.769 | 0.882 | 0.604 | 0.978 | 0.602 |
TICKET_USE_PLACE_NM | 0.586 | 0.887 | 0.900 | 0.616 | 1.000 | 0.900 | 0.900 | 0.709 | 0.881 | 0.586 | 0.860 | 0.660 | 0.887 |
TURSM_COURS_NM | 0.968 | 0.863 | 1.000 | 0.968 | 0.900 | 1.000 | 1.000 | 0.978 | 0.645 | 0.968 | 0.923 | 0.803 | 0.863 |
TICKET_SLE_BRAND_NM | 0.968 | 0.863 | 1.000 | 0.968 | 0.900 | 1.000 | 1.000 | 0.978 | 0.645 | 0.968 | 0.923 | 0.803 | 0.863 |
USER_KEY_NM | 0.860 | 0.621 | 0.978 | 0.989 | 0.709 | 0.978 | 0.978 | 1.000 | 0.782 | 0.860 | 0.705 | 0.989 | 0.621 |
TICKET_USGSTT_NM | 0.730 | 0.732 | 0.645 | 0.769 | 0.881 | 0.645 | 0.645 | 0.782 | 1.000 | 0.730 | 0.802 | 0.508 | 0.732 |
TICKET_OPTN_NM | 1.000 | 0.678 | 0.968 | 0.882 | 0.586 | 0.968 | 0.968 | 0.860 | 0.730 | 1.000 | 0.580 | 0.820 | 0.678 |
TRRSRT_ADDR | 0.580 | 0.935 | 0.923 | 0.604 | 0.860 | 0.923 | 0.923 | 0.705 | 0.802 | 0.580 | 1.000 | 0.660 | 0.935 |
TICKET_SLE_CHNNEL_NM | 0.820 | 0.572 | 0.803 | 0.978 | 0.660 | 0.803 | 0.803 | 0.989 | 0.508 | 0.820 | 0.660 | 1.000 | 0.572 |
TRRSRT_CD | 0.678 | 1.000 | 0.863 | 0.602 | 0.887 | 0.863 | 0.863 | 0.621 | 0.732 | 0.678 | 0.935 | 0.572 | 1.000 |
SEQ_NO | PRCHS_DT | TICKET_VALID_DT | USE_DT | USER_KEY_NM | PRCHS_ID | TICKET_USGSTT_NM | TURSM_COURS_CD | TURSM_COURS_NM | TICKET_OPTN_CD | TICKET_OPTN_NM | TRRSRT_CD | TRRSRT_NM | TRRSRT_ADDR | TICKET_SLE_CHNNEL_NM | TICKET_SLE_BRAND_NM | TICKET_USE_PLACE_NM | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SEQ_NO | 1.000 | 0.958 | 0.820 | 0.649 | 0.696 | 0.673 | 0.651 | 0.710 | 0.710 | 0.656 | 0.656 | 0.565 | 0.565 | 0.537 | 0.623 | 0.710 | 0.482 |
PRCHS_DT | 0.958 | 1.000 | 0.861 | 0.398 | 0.989 | 0.978 | 0.738 | 0.989 | 0.989 | 0.978 | 0.978 | 0.743 | 0.743 | 0.813 | 0.822 | 0.989 | 0.801 |
TICKET_VALID_DT | 0.820 | 0.861 | 1.000 | 0.545 | 0.968 | 0.957 | 0.905 | 0.990 | 0.990 | 0.957 | 0.957 | 0.854 | 0.854 | 0.913 | 0.566 | 0.990 | 0.846 |
USE_DT | 0.649 | 0.398 | 0.545 | 1.000 | 0.664 | 0.618 | 1.000 | 0.403 | 0.403 | 0.573 | 0.573 | 0.426 | 0.426 | 0.645 | 0.664 | 0.403 | 0.598 |
USER_KEY_NM | 0.696 | 0.989 | 0.968 | 0.664 | 1.000 | 0.989 | 0.782 | 0.978 | 0.978 | 0.860 | 0.860 | 0.621 | 0.621 | 0.705 | 0.989 | 0.978 | 0.709 |
PRCHS_ID | 0.673 | 0.978 | 0.957 | 0.618 | 0.989 | 1.000 | 0.769 | 0.968 | 0.968 | 0.882 | 0.882 | 0.602 | 0.602 | 0.604 | 0.978 | 0.968 | 0.616 |
TICKET_USGSTT_NM | 0.651 | 0.738 | 0.905 | 1.000 | 0.782 | 0.769 | 1.000 | 0.645 | 0.645 | 0.730 | 0.730 | 0.732 | 0.732 | 0.802 | 0.508 | 0.645 | 0.881 |
TURSM_COURS_CD | 0.710 | 0.989 | 0.990 | 0.403 | 0.978 | 0.968 | 0.645 | 1.000 | 1.000 | 0.968 | 0.968 | 0.863 | 0.863 | 0.923 | 0.803 | 1.000 | 0.900 |
TURSM_COURS_NM | 0.710 | 0.989 | 0.990 | 0.403 | 0.978 | 0.968 | 0.645 | 1.000 | 1.000 | 0.968 | 0.968 | 0.863 | 0.863 | 0.923 | 0.803 | 1.000 | 0.900 |
TICKET_OPTN_CD | 0.656 | 0.978 | 0.957 | 0.573 | 0.860 | 0.882 | 0.730 | 0.968 | 0.968 | 1.000 | 1.000 | 0.678 | 0.678 | 0.580 | 0.820 | 0.968 | 0.586 |
TICKET_OPTN_NM | 0.656 | 0.978 | 0.957 | 0.573 | 0.860 | 0.882 | 0.730 | 0.968 | 0.968 | 1.000 | 1.000 | 0.678 | 0.678 | 0.580 | 0.820 | 0.968 | 0.586 |
TRRSRT_CD | 0.565 | 0.743 | 0.854 | 0.426 | 0.621 | 0.602 | 0.732 | 0.863 | 0.863 | 0.678 | 0.678 | 1.000 | 1.000 | 0.935 | 0.572 | 0.863 | 0.887 |
TRRSRT_NM | 0.565 | 0.743 | 0.854 | 0.426 | 0.621 | 0.602 | 0.732 | 0.863 | 0.863 | 0.678 | 0.678 | 1.000 | 1.000 | 0.935 | 0.572 | 0.863 | 0.887 |
TRRSRT_ADDR | 0.537 | 0.813 | 0.913 | 0.645 | 0.705 | 0.604 | 0.802 | 0.923 | 0.923 | 0.580 | 0.580 | 0.935 | 0.935 | 1.000 | 0.660 | 0.923 | 0.860 |
TICKET_SLE_CHNNEL_NM | 0.623 | 0.822 | 0.566 | 0.664 | 0.989 | 0.978 | 0.508 | 0.803 | 0.803 | 0.820 | 0.820 | 0.572 | 0.572 | 0.660 | 1.000 | 0.803 | 0.660 |
TICKET_SLE_BRAND_NM | 0.710 | 0.989 | 0.990 | 0.403 | 0.978 | 0.968 | 0.645 | 1.000 | 1.000 | 0.968 | 0.968 | 0.863 | 0.863 | 0.923 | 0.803 | 1.000 | 0.900 |
TICKET_USE_PLACE_NM | 0.482 | 0.801 | 0.846 | 0.598 | 0.709 | 0.616 | 0.881 | 0.900 | 0.900 | 0.586 | 0.586 | 0.887 | 0.887 | 0.860 | 0.660 | 0.900 | 1.000 |
SEQ_NO | USER_KEY_NM | PRCHS_ID | TICKET_ID | TICKET_USGSTT_NM | TURSM_COURS_CD | TURSM_COURS_NM | TICKET_OPTN_CD | TICKET_OPTN_NM | TRRSRT_CD | TRRSRT_NM | TRRSRT_ADDR | TICKET_SLE_CHNNEL_NM | SLE_CHNNEL_URL | PRCHS_DT | TICKET_VALID_DT | USE_DT | USE_CANCL_DT | TICKET_SLE_BRAND_NM | TICKET_USE_PLACE_NM | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 179428 | e43582c2d0008590cfa43e51cacd7c0d088df5d1 | ODTK-20200802-AUUVYF-DAX | 4203026669785 | 취소 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001066 | [울진]커피방 | 경북 울진군 근남면 산포3길 162 2층 | 티몬 | - | 20200802093835 | 20200823235959 | <NA> | <NA> | 울진 e누리 | - |
1 | 179429 | e43582c2d0008590cfa43e51cacd7c0d088df5d1 | ODTK-20200802-AUUVYF-DAX | 7962678307545 | 취소 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001066 | [울진]커피방 | 경북 울진군 근남면 산포3길 162 2층 | 티몬 | - | 20200802093835 | 20200823235959 | <NA> | <NA> | 울진 e누리 | - |
2 | 179430 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 1274996522190 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001057 | [울진]과학체험관_성인 | 경북 울진군 울진읍 연지길 30 | 쿠팡 | - | 20200802093858 | 20200812121901 | <NA> | <NA> | 울진 e누리 | [울진] 과학 체험관 |
3 | 179431 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 7927265907822 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001057 | [울진]과학체험관_성인 | 경북 울진군 울진읍 연지길 30 | 쿠팡 | - | 20200802093858 | 20200812121901 | <NA> | <NA> | 울진 e누리 | [울진] 과학 체험관 |
4 | 179432 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 2212187496448 | 사용 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001820 | [울진]스파월드_성수기/성인 | 경북 울진군 북면 덕구온천로 924 | 쿠팡 | - | 20200802093858 | 20200812121901 | 20200802114901 | <NA> | 울진 e누리 | [울진] 덕구온천 |
5 | 179433 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 0311192912405 | 사용 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001820 | [울진]스파월드_성수기/성인 | 경북 울진군 북면 덕구온천로 924 | 쿠팡 | - | 20200802093858 | 20200812121901 | 20200802114901 | <NA> | 울진 e누리 | [울진] 덕구온천 |
6 | 179434 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 7585469631647 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001066 | [울진]커피방 | 경북 울진군 근남면 산포3길 162 2층 | 쿠팡 | - | 20200802093858 | 20200812121901 | <NA> | <NA> | 울진 e누리 | [울진] 커피방 |
7 | 179435 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-ZKJTIY-HNT | 9324154365682 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001347 | 2-1.성인 | P00000001066 | [울진]커피방 | 경북 울진군 근남면 산포3길 162 2층 | 쿠팡 | - | 20200802093858 | 20200812121901 | <NA> | <NA> | 울진 e누리 | [울진] 커피방 |
8 | 179436 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-OFELZH-AMA | 3014255338832 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001349 | 2-3.소인 | P00000001059 | [울진]과학체험관_소인 | 경북 울진군 울진읍 연지길 30 | 쿠팡 | - | 20200802093958 | 20200812122123 | <NA> | <NA> | 울진 e누리 | [울진] 과학 체험관 |
9 | 179437 | e79b6f696c4aca9bf56a24a3b34280d40362efe3 | ODTK-20200802-OFELZH-AMA | 0333215476596 | 사용만료 | PROD00000428 | 경북나드리 울진(덕구온천 스파월드+관광지패키지) | OPTI00001349 | 2-3.소인 | P00000001059 | [울진]과학체험관_소인 | 경북 울진군 울진읍 연지길 30 | 쿠팡 | - | 20200802093958 | 20200812122123 | <NA> | <NA> | 울진 e누리 | [울진] 과학 체험관 |
SEQ_NO | USER_KEY_NM | PRCHS_ID | TICKET_ID | TICKET_USGSTT_NM | TURSM_COURS_CD | TURSM_COURS_NM | TICKET_OPTN_CD | TICKET_OPTN_NM | TRRSRT_CD | TRRSRT_NM | TRRSRT_ADDR | TICKET_SLE_CHNNEL_NM | SLE_CHNNEL_URL | PRCHS_DT | TICKET_VALID_DT | USE_DT | USE_CANCL_DT | TICKET_SLE_BRAND_NM | TICKET_USE_PLACE_NM | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40 | 179468 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 4577844959314 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001008 | [상주]국제승마장_소인 | 경상북도 상주시 사벌국면 화달리 산23 상주국제승마장 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
41 | 179469 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 6800258208533 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001008 | [상주]국제승마장_소인 | 경상북도 상주시 사벌국면 화달리 산23 상주국제승마장 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
42 | 179470 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 0242103757767 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001005 | [상주]박물관_소인 | 경상북도 상주시 사벌국면 경천로 684 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
43 | 179471 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 9935401157713 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001005 | [상주]박물관_소인 | 경상북도 상주시 사벌국면 경천로 684 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
44 | 179472 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 0138184005397 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001005 | [상주]박물관_소인 | 경상북도 상주시 사벌국면 경천로 684 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
45 | 179473 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 8819258347998 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001005 | [상주]박물관_소인 | 경상북도 상주시 사벌국면 경천로 684 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
46 | 179474 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 4438367437446 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001005 | [상주]박물관_소인 | 경상북도 상주시 사벌국면 경천로 684 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
47 | 179475 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 4307030655363 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001009 | [상주]수상레저센터_소인 | 경북 상주시 용마로 366 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
48 | 179476 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 1882532433165 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001009 | [상주]수상레저센터_소인 | 경북 상주시 용마로 366 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |
49 | 179477 | 609ddbe4d4e19e0e831d9e763ec0a226f9fe6db7 | ODTK-20200802-FCGRGJ-RNM | 8196173215151 | 취소 | PROD00000076 | 경북나드리 상주(승마체험+수상레저+생물자원관+자전거박물관+상주박물관) | OPTI00001413 | 2.소인 | P00000001009 | [상주]수상레저센터_소인 | 경북 상주시 용마로 366 | 쿠팡 | - | 20200802095620 | 20201130235959 | <NA> | <NA> | 상주 e누리 | - |