Dataset statistics
Number of variables | 9 |
---|---|
Number of observations | 149 |
Missing cells | 149 |
Missing cells (%) | 11.1% |
Duplicate rows | 1 |
Duplicate rows (%) | 0.7% |
Total size in memory | 11.5 KiB |
Average record size in memory | 78.9 B |
Variable types
Categorical | 6 |
---|---|
Unsupported | 1 |
Numeric | 2 |
Dataset
Description | Sample |
---|---|
Author | (주)넥스트이지 |
URL | https://www.bigdata-telecom.kr/invoke/SOKBP2603/?goodsCode=NXEVISITRFUSN |
제주방문 has constant value "" | Constant |
제주공항 has constant value "" | Constant |
20200825 has constant value "" | Constant |
50 has constant value "" | Constant |
Dataset has 1 (0.7%) duplicate rows | Duplicates |
00 is highly overall correlated with 322 | High correlation |
322 is highly overall correlated with 00 | High correlation |
Unnamed: 2 has 149 (100.0%) missing values | Missing |
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
00 has 27 (18.1%) zeros | Zeros |
Reproduction
Analysis started | 2023-12-10 06:37:39.429728 |
---|---|
Analysis finished | 2023-12-10 06:37:40.605630 |
Duration | 1.18 second |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
제주방문
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
제주방문 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 제주방문 |
---|---|
2nd row | 제주방문 |
3rd row | 제주방문 |
4th row | 제주방문 |
5th row | 제주방문 |
Common Values
Value | Count | Frequency (%) |
제주방문 | 149 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
제주방문 | 149 |
제주공항
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
제주공항 |
---|
Length
Max length | 4 |
---|---|
Median length | 4 |
Mean length | 4 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 제주공항 |
---|---|
2nd row | 제주공항 |
3rd row | 제주공항 |
4th row | 제주공항 |
5th row | 제주공항 |
Common Values
Value | Count | Frequency (%) |
제주공항 | 149 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
제주공항 | 149 |
Unnamed: 2
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 149 |
---|---|
Missing (%) | 100.0% |
Memory size | 1.4 KiB |
20200825
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
20200825 |
---|
Length
Max length | 8 |
---|---|
Median length | 8 |
Mean length | 8 |
Min length | 8 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 20200825 |
---|---|
2nd row | 20200825 |
3rd row | 20200825 |
4th row | 20200825 |
5th row | 20200825 |
Common Values
Value | Count | Frequency (%) |
20200825 | 149 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
20200825 | 149 |
00
Real number (ℝ)
HIGH CORRELATION
  ZEROS
 
Distinct | 6 |
---|---|
Distinct (%) | 4.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2.2147651 |
Minimum | 0 |
---|---|
Maximum | 5 |
Zeros | 27 |
Zeros (%) | 18.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.4 KiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 0 |
Q1 | 1 |
median | 2 |
Q3 | 4 |
95-th percentile | 5 |
Maximum | 5 |
Range | 5 |
Interquartile range (IQR) | 3 |
Descriptive statistics
Standard deviation | 1.5577347 |
---|---|
Coefficient of variation (CV) | 0.7033408 |
Kurtosis | -1.1407821 |
Mean | 2.2147651 |
Median Absolute Deviation (MAD) | 1 |
Skewness | 0.081787505 |
Sum | 330 |
Variance | 2.4265373 |
Monotonicity | Increasing |
Value | Count | Frequency (%) |
1 | 28 | |
2 | 28 | |
3 | 28 | |
4 | 28 | |
0 | 27 | |
5 | 10 | 6.7% |
Value | Count | Frequency (%) |
0 | 27 | |
1 | 28 | |
2 | 28 | |
3 | 28 | |
4 | 28 | |
5 | 10 | 6.7% |
Value | Count | Frequency (%) |
5 | 10 | 6.7% |
4 | 28 | |
3 | 28 | |
2 | 28 | |
1 | 28 | |
0 | 27 |
10-
Categorical
Distinct | 8 |
---|---|
Distinct (%) | 5.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
10 | |
---|---|
20 | |
30 | |
40 | |
50 | |
Other values (3) |
Length
Max length | 3 |
---|---|
Median length | 2 |
Mean length | 2.0671141 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 10 |
---|---|
2nd row | 10 |
3rd row | 20 |
4th row | 20 |
5th row | 30 |
Common Values
Value | Count | Frequency (%) |
10 | 22 | |
20 | 22 | |
30 | 22 | |
40 | 22 | |
50 | 21 | |
60 | 20 | |
70 | 10 | |
10- | 10 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
10 | 32 | |
20 | 22 | |
30 | 22 | |
40 | 22 | |
50 | 21 | |
60 | 20 | |
70 | 10 | 6.7% |
2
Categorical
Distinct | 2 |
---|---|
Distinct (%) | 1.3% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
2 | |
---|---|
1 |
Length
Max length | 1 |
---|---|
Median length | 1 |
Mean length | 1 |
Min length | 1 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2 |
---|---|
2nd row | 2 |
3rd row | 2 |
4th row | 2 |
5th row | 2 |
Common Values
Value | Count | Frequency (%) |
2 | 79 | |
1 | 70 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
2 | 79 | |
1 | 70 |
50
Categorical
CONSTANT
 
Distinct | 1 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 1.3 KiB |
50 |
---|
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 50 |
---|---|
2nd row | 50 |
3rd row | 50 |
4th row | 50 |
5th row | 50 |
Common Values
Value | Count | Frequency (%) |
50 | 149 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
50 | 149 |
322
Real number (ℝ)
HIGH CORRELATION
 
Distinct | 134 |
---|---|
Distinct (%) | 89.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 378.12752 |
Minimum | 9 |
---|---|
Maximum | 2237 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 1.4 KiB |
Quantile statistics
Minimum | 9 |
---|---|
5-th percentile | 26.8 |
Q1 | 97 |
median | 211 |
Q3 | 373 |
95-th percentile | 1582.4 |
Maximum | 2237 |
Range | 2228 |
Interquartile range (IQR) | 276 |
Descriptive statistics
Standard deviation | 474.22931 |
---|---|
Coefficient of variation (CV) | 1.2541518 |
Kurtosis | 4.3238596 |
Mean | 378.12752 |
Median Absolute Deviation (MAD) | 121 |
Skewness | 2.2321762 |
Sum | 56341 |
Variance | 224893.44 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
265 | 3 | 2.0% |
60 | 2 | 1.3% |
237 | 2 | 1.3% |
125 | 2 | 1.3% |
54 | 2 | 1.3% |
18 | 2 | 1.3% |
187 | 2 | 1.3% |
526 | 2 | 1.3% |
140 | 2 | 1.3% |
155 | 2 | 1.3% |
Other values (124) | 128 |
Value | Count | Frequency (%) |
9 | 1 | |
13 | 1 | |
16 | 1 | |
18 | 2 | |
19 | 1 | |
22 | 1 | |
24 | 1 | |
31 | 1 | |
46 | 1 | |
48 | 2 |
Value | Count | Frequency (%) |
2237 | 1 | |
2093 | 1 | |
1891 | 1 | |
1855 | 1 | |
1828 | 1 | |
1816 | 1 | |
1598 | 1 | |
1586 | 1 | |
1577 | 1 | |
1549 | 1 |
00 | 10- | 2 | 322 | |
---|---|---|---|---|
00 | 1.000 | 0.000 | 0.247 | 0.556 |
10- | 0.000 | 1.000 | 0.000 | 0.482 |
2 | 0.247 | 0.000 | 1.000 | 0.343 |
322 | 0.556 | 0.482 | 0.343 | 1.000 |
10- | 2 | |
---|---|---|
10- | 1.000 | 0.000 |
2 | 0.000 | 1.000 |
00 | 322 | 10- | 2 | |
---|---|---|---|---|
00 | 1.000 | -0.534 | 0.000 | 0.174 |
322 | -0.534 | 1.000 | 0.252 | 0.255 |
10- | 0.000 | 0.252 | 1.000 | 0.000 |
2 | 0.174 | 0.255 | 0.000 | 1.000 |
제주방문 | 제주공항 | Unnamed: 2 | 20200825 | 00 | 10- | 2 | 50 | 322 | |
---|---|---|---|---|---|---|---|---|---|
0 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 10 | 2 | 50 | 604 |
1 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 10 | 2 | 50 | 677 |
2 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 20 | 2 | 50 | 1855 |
3 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 20 | 2 | 50 | 2093 |
4 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 30 | 2 | 50 | 1586 |
5 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 30 | 2 | 50 | 1577 |
6 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 40 | 2 | 50 | 1343 |
7 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 40 | 2 | 50 | 1297 |
8 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 50 | 2 | 50 | 1252 |
9 | 제주방문 | 제주공항 | <NA> | 20200825 | 0 | 50 | 2 | 50 | 1080 |
제주방문 | 제주공항 | Unnamed: 2 | 20200825 | 00 | 10- | 2 | 50 | 322 | |
---|---|---|---|---|---|---|---|---|---|
139 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 10- | 2 | 50 | 19 |
140 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 10 | 2 | 50 | 60 |
141 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 10 | 2 | 50 | 87 |
142 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 20 | 2 | 50 | 268 |
143 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 20 | 2 | 50 | 303 |
144 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 30 | 2 | 50 | 231 |
145 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 30 | 2 | 50 | 210 |
146 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 40 | 2 | 50 | 197 |
147 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 40 | 2 | 50 | 193 |
148 | 제주방문 | 제주공항 | <NA> | 20200825 | 5 | 50 | 2 | 50 | 190 |
Most frequently occurring
제주방문 | 제주공항 | 20200825 | 00 | 10- | 2 | 50 | 322 | # duplicates | |
---|---|---|---|---|---|---|---|---|---|
0 | 제주방문 | 제주공항 | 20200825 | 1 | 20 | 2 | 50 | 526 | 2 |