Overview

Dataset statistics

Number of variables6
Number of observations62
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory54.1 B

Variable types

Numeric4
Categorical1
DateTime1

Alerts

SEQ is highly overall correlated with MOBILE_SCCNT and 3 other fieldsHigh correlation
MOBILE_SCCNT is highly overall correlated with SEQ and 3 other fieldsHigh correlation
_PC_SCCNT is highly overall correlated with SEQ and 3 other fieldsHigh correlation
SCCNT_SM is highly overall correlated with SEQ and 3 other fieldsHigh correlation
SRCHWRD_NM is highly overall correlated with SEQ and 3 other fieldsHigh correlation
SEQ has unique valuesUnique
MOBILE_SCCNT has unique valuesUnique
SCCNT_SM has unique valuesUnique

Reproduction

Analysis started2023-12-10 09:41:14.532282
Analysis finished2023-12-10 09:41:18.012211
Duration3.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3019.5323
Minimum2928
Maximum3208
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-10T18:41:18.193714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2928
5-th percentile2931.05
Q12943.25
median3073.5
Q33088.75
95-th percentile3100.95
Maximum3208
Range280
Interquartile range (IQR)145.5

Descriptive statistics

Standard deviation77.204161
Coefficient of variation (CV)0.025568252
Kurtosis-1.5497454
Mean3019.5323
Median Absolute Deviation (MAD)73
Skewness0.10753179
Sum187211
Variance5960.4825
MonotonicityStrictly increasing
2023-12-10T18:41:18.783093image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2928 1
 
1.6%
3090 1
 
1.6%
3077 1
 
1.6%
3078 1
 
1.6%
3079 1
 
1.6%
3080 1
 
1.6%
3081 1
 
1.6%
3082 1
 
1.6%
3083 1
 
1.6%
3084 1
 
1.6%
Other values (52) 52
83.9%
ValueCountFrequency (%)
2928 1
1.6%
2929 1
1.6%
2930 1
1.6%
2931 1
1.6%
2932 1
1.6%
2933 1
1.6%
2934 1
1.6%
2935 1
1.6%
2936 1
1.6%
2937 1
1.6%
ValueCountFrequency (%)
3208 1
1.6%
3103 1
1.6%
3102 1
1.6%
3101 1
1.6%
3100 1
1.6%
3099 1
1.6%
3098 1
1.6%
3097 1
1.6%
3096 1
1.6%
3095 1
1.6%

SRCHWRD_NM
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size628.0 B
문화누리카드
31 
문화누리
31 

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 (%)
문화누리카드 31
50.0%
문화누리 31
50.0%

Length

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

Common Values (Plot)

2023-12-10T18:41:19.240138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화누리카드 31
50.0%
문화누리 31
50.0%

MOBILE_SCCNT
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2483.6935
Minimum221
Maximum5914
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-10T18:41:19.433576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum221
5-th percentile264.75
Q1340.25
median1959
Q34637
95-th percentile5613.7
Maximum5914
Range5693
Interquartile range (IQR)4296.75

Descriptive statistics

Standard deviation2213.3171
Coefficient of variation (CV)0.89113936
Kurtosis-1.8540054
Mean2483.6935
Median Absolute Deviation (MAD)1699
Skewness0.14768389
Sum153989
Variance4898772.5
MonotonicityNot monotonic
2023-12-10T18:41:19.679174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4003 1
 
1.6%
407 1
 
1.6%
419 1
 
1.6%
383 1
 
1.6%
317 1
 
1.6%
344 1
 
1.6%
411 1
 
1.6%
376 1
 
1.6%
335 1
 
1.6%
394 1
 
1.6%
Other values (52) 52
83.9%
ValueCountFrequency (%)
221 1
1.6%
246 1
1.6%
256 1
1.6%
264 1
1.6%
279 1
1.6%
288 1
1.6%
312 1
1.6%
314 1
1.6%
315 1
1.6%
317 1
1.6%
ValueCountFrequency (%)
5914 1
1.6%
5777 1
1.6%
5635 1
1.6%
5624 1
1.6%
5418 1
1.6%
5244 1
1.6%
5174 1
1.6%
5066 1
1.6%
5054 1
1.6%
5046 1
1.6%

_PC_SCCNT
Real number (ℝ)

HIGH CORRELATION 

Distinct57
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean945.5
Minimum95
Maximum2254
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-10T18:41:19.920603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum95
5-th percentile129.05
Q1249.5
median600
Q31807.5
95-th percentile2206.3
Maximum2254
Range2159
Interquartile range (IQR)1558

Descriptive statistics

Standard deviation793.43722
Coefficient of variation (CV)0.83917209
Kurtosis-1.5528236
Mean945.5
Median Absolute Deviation (MAD)466.5
Skewness0.4089577
Sum58621
Variance629542.61
MonotonicityNot monotonic
2023-12-10T18:41:20.173351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
297 2
 
3.2%
231 2
 
3.2%
885 2
 
3.2%
258 2
 
3.2%
2218 2
 
3.2%
95 1
 
1.6%
238 1
 
1.6%
303 1
 
1.6%
278 1
 
1.6%
1644 1
 
1.6%
Other values (47) 47
75.8%
ValueCountFrequency (%)
95 1
1.6%
112 1
1.6%
123 1
1.6%
129 1
1.6%
130 1
1.6%
132 1
1.6%
135 1
1.6%
153 1
1.6%
167 1
1.6%
225 1
1.6%
ValueCountFrequency (%)
2254 1
1.6%
2218 2
3.2%
2208 1
1.6%
2174 1
1.6%
2158 1
1.6%
2074 1
1.6%
2017 1
1.6%
1990 1
1.6%
1981 1
1.6%
1955 1
1.6%

SCCNT_SM
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct62
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3429.1935
Minimum316
Maximum8122
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size690.0 B
2023-12-10T18:41:20.502312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum316
5-th percentile388.05
Q1603.5
median2556.5
Q36434.25
95-th percentile7777.7
Maximum8122
Range7806
Interquartile range (IQR)5830.75

Descriptive statistics

Standard deviation2992.3703
Coefficient of variation (CV)0.87261633
Kurtosis-1.7827272
Mean3429.1935
Median Absolute Deviation (MAD)2159
Skewness0.20615558
Sum212610
Variance8954279.9
MonotonicityNot monotonic
2023-12-10T18:41:20.813167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
5184 1
 
1.6%
722 1
 
1.6%
697 1
 
1.6%
608 1
 
1.6%
484 1
 
1.6%
479 1
 
1.6%
669 1
 
1.6%
644 1
 
1.6%
628 1
 
1.6%
638 1
 
1.6%
Other values (52) 52
83.9%
ValueCountFrequency (%)
316 1
1.6%
368 1
1.6%
378 1
1.6%
387 1
1.6%
408 1
1.6%
418 1
1.6%
471 1
1.6%
479 1
1.6%
484 1
1.6%
545 1
1.6%
ValueCountFrequency (%)
8122 1
1.6%
7995 1
1.6%
7889 1
1.6%
7798 1
1.6%
7392 1
1.6%
7373 1
1.6%
7261 1
1.6%
7135 1
1.6%
7110 1
1.6%
7036 1
1.6%

SCCNT_DE
Date

Distinct31
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Memory size628.0 B
Minimum2020-03-01 00:00:00
Maximum2020-03-31 00:00:00
2023-12-10T18:41:21.206317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:21.567422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)

Interactions

2023-12-10T18:41:16.891516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:14.902352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:15.714904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.361267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:17.027772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:15.112442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:15.918029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.489650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:17.180384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:15.272260image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.064099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.630003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:17.325211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:15.451020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.196026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:41:16.745920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:41:21.813014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQSRCHWRD_NMMOBILE_SCCNT_PC_SCCNTSCCNT_SMSCCNT_DE
SEQ1.0001.0000.6250.6650.6490.000
SRCHWRD_NM1.0001.0001.0001.0001.0000.000
MOBILE_SCCNT0.6251.0001.0000.9310.9890.000
_PC_SCCNT0.6651.0000.9311.0000.9260.000
SCCNT_SM0.6491.0000.9890.9261.0000.000
SCCNT_DE0.0000.0000.0000.0000.0001.000
2023-12-10T18:41:22.036643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQMOBILE_SCCNT_PC_SCCNTSCCNT_SMSRCHWRD_NM
SEQ1.000-0.848-0.806-0.8300.975
MOBILE_SCCNT-0.8481.0000.9650.9910.966
_PC_SCCNT-0.8060.9651.0000.9870.940
SCCNT_SM-0.8300.9910.9871.0000.966
SRCHWRD_NM0.9750.9660.9400.9661.000

Missing values

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

SEQSRCHWRD_NMMOBILE_SCCNT_PC_SCCNTSCCNT_SMSCCNT_DE
02928문화누리카드4003118151842020-03-01
12929문화누리카드5777221879952020-03-02
22930문화누리카드5635225478892020-03-03
32931문화누리카드5914220881222020-03-04
42932문화누리카드5624217477982020-03-05
52933문화누리카드5418195573732020-03-06
62934문화누리카드4235116954042020-03-07
72935문화누리카드4015105850732020-03-08
82936문화누리카드5244201772612020-03-09
92937문화누리카드5054198170352020-03-10
SEQSRCHWRD_NMMOBILE_SCCNT_PC_SCCNTSCCNT_SMSCCNT_DE
523095문화누리3202826022020-03-23
533096문화누리3492666152020-03-24
543097문화누리3342315652020-03-25
553098문화누리3152335482020-03-26
563099문화누리3142315452020-03-27
573100문화누리2791294082020-03-28
583101문화누리221953162020-03-29
593102문화누리3392565952020-03-30
603103문화누리3582546122020-03-31
613208문화누리카드4403164460472020-03-31