Overview

Dataset statistics

Number of variables7
Number of observations60
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.5 KiB
Average record size in memory60.2 B

Variable types

Numeric2
Categorical5

Alerts

UPPER_CTGRY_NM has constant value ""Constant
LWPRT_CTGRY_NM has constant value ""Constant
REPRSNT_KWRD_NM is highly overall correlated with SEQ_NO and 1 other fieldsHigh correlation
SRCHWRD_NM is highly overall correlated with SEQ_NO and 1 other fieldsHigh correlation
SEQ_NO is highly overall correlated with REPRSNT_KWRD_NM and 1 other fieldsHigh correlation
SEQ_NO has unique valuesUnique
KWRD_DPI_VALUE has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:08:06.843425
Analysis finished2023-12-10 10:08:08.728870
Duration1.89 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

SEQ_NO
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct60
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2742.7
Minimum2487
Maximum2965
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T19:08:08.908705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2487
5-th percentile2489.95
Q12627.75
median2752.5
Q32896.25
95-th percentile2962.05
Maximum2965
Range478
Interquartile range (IQR)268.5

Descriptive statistics

Standard deviation145.26449
Coefficient of variation (CV)0.052964047
Kurtosis-0.99159585
Mean2742.7
Median Absolute Deviation (MAD)134.5
Skewness-0.10612582
Sum164562
Variance21101.773
MonotonicityNot monotonic
2023-12-10T19:08:09.193273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2673 1
 
1.7%
2897 1
 
1.7%
2963 1
 
1.7%
2909 1
 
1.7%
2490 1
 
1.7%
2759 1
 
1.7%
2747 1
 
1.7%
2676 1
 
1.7%
2628 1
 
1.7%
2778 1
 
1.7%
Other values (50) 50
83.3%
ValueCountFrequency (%)
2487 1
1.7%
2488 1
1.7%
2489 1
1.7%
2490 1
1.7%
2491 1
1.7%
2492 1
1.7%
2583 1
1.7%
2584 1
1.7%
2585 1
1.7%
2586 1
1.7%
ValueCountFrequency (%)
2965 1
1.7%
2964 1
1.7%
2963 1
1.7%
2962 1
1.7%
2961 1
1.7%
2960 1
1.7%
2911 1
1.7%
2910 1
1.7%
2909 1
1.7%
2908 1
1.7%

UPPER_CTGRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
문화시설
60 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화시설
2nd row문화시설
3rd row문화시설
4th row문화시설
5th row문화시설

Common Values

ValueCountFrequency (%)
문화시설 60
100.0%

Length

2023-12-10T19:08:09.480640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:08:09.687600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화시설 60
100.0%

LWPRT_CTGRY_NM
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
공연장
60 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공연장
2nd row공연장
3rd row공연장
4th row공연장
5th row공연장

Common Values

ValueCountFrequency (%)
공연장 60
100.0%

Length

2023-12-10T19:08:09.893263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:08:10.082414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공연장 60
100.0%

REPRSNT_KWRD_NM
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
마포아트센터
6 
달성문화센터
6 
청주예술의전당
6 
의정부예술의전당
6 
웃는얼굴아트센터
6 
Other values (5)
30 

Length

Max length8
Median length7.5
Mean length6.5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row마포아트센터
2nd row달성문화센터
3rd row청주예술의전당
4th row의정부예술의전당
5th row웃는얼굴아트센터

Common Values

ValueCountFrequency (%)
마포아트센터 6
10.0%
달성문화센터 6
10.0%
청주예술의전당 6
10.0%
의정부예술의전당 6
10.0%
웃는얼굴아트센터 6
10.0%
아양아트센터 6
10.0%
김해문화의전당 6
10.0%
강동아트센터 6
10.0%
수성아트피아 6
10.0%
성산아트홀 6
10.0%

Length

2023-12-10T19:08:10.422359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:08:10.701782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포아트센터 6
10.0%
달성문화센터 6
10.0%
청주예술의전당 6
10.0%
의정부예술의전당 6
10.0%
웃는얼굴아트센터 6
10.0%
아양아트센터 6
10.0%
김해문화의전당 6
10.0%
강동아트센터 6
10.0%
수성아트피아 6
10.0%
성산아트홀 6
10.0%

SRCHWRD_NM
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size612.0 B
마포아트센터
6 
달성문화센터
6 
청주예술의전당
6 
의정부예술의전당
6 
웃는얼굴아트센터
6 
Other values (5)
30 

Length

Max length15
Median length8
Mean length7.4
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row마포아트센터
2nd row달성문화센터
3rd row청주예술의전당
4th row의정부예술의전당
5th row웃는얼굴아트센터

Common Values

ValueCountFrequency (%)
마포아트센터 6
10.0%
달성문화센터 6
10.0%
청주예술의전당 6
10.0%
의정부예술의전당 6
10.0%
웃는얼굴아트센터 6
10.0%
대구아양아트센터,아양아트센터 6
10.0%
김해문화의전당 6
10.0%
강동아트센터 6
10.0%
수성아트피아 6
10.0%
성산아트홀 6
10.0%

Length

2023-12-10T19:08:11.012726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:08:11.300555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포아트센터 6
10.0%
달성문화센터 6
10.0%
청주예술의전당 6
10.0%
의정부예술의전당 6
10.0%
웃는얼굴아트센터 6
10.0%
대구아양아트센터,아양아트센터 6
10.0%
김해문화의전당 6
10.0%
강동아트센터 6
10.0%
수성아트피아 6
10.0%
성산아트홀 6
10.0%

KWRD_DPI_VALUE
Real number (ℝ)

UNIQUE 

Distinct60
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4981.4787
Minimum1006.55
Maximum9111.24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T19:08:11.791728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1006.55
5-th percentile2144.4405
Q13685.5575
median5126.355
Q36527.8375
95-th percentile7506.6115
Maximum9111.24
Range8104.69
Interquartile range (IQR)2842.28

Descriptive statistics

Standard deviation1859.5388
Coefficient of variation (CV)0.37329053
Kurtosis-0.63269662
Mean4981.4787
Median Absolute Deviation (MAD)1411.335
Skewness-0.099549613
Sum298888.72
Variance3457884.6
MonotonicityNot monotonic
2023-12-10T19:08:12.078229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3618.11 1
 
1.7%
5107.12 1
 
1.7%
5527.4 1
 
1.7%
5029.9 1
 
1.7%
7990.57 1
 
1.7%
5093.45 1
 
1.7%
4268.65 1
 
1.7%
5145.59 1
 
1.7%
4001.05 1
 
1.7%
6651.0 1
 
1.7%
Other values (50) 50
83.3%
ValueCountFrequency (%)
1006.55 1
1.7%
1479.8 1
1.7%
1717.52 1
1.7%
2166.91 1
1.7%
2185.28 1
1.7%
2390.86 1
1.7%
2538.47 1
1.7%
2572.44 1
1.7%
2718.83 1
1.7%
2780.77 1
1.7%
ValueCountFrequency (%)
9111.24 1
1.7%
8401.0 1
1.7%
7990.57 1
1.7%
7481.14 1
1.7%
7400.05 1
1.7%
7289.52 1
1.7%
7198.97 1
1.7%
7146.59 1
1.7%
7043.96 1
1.7%
6855.32 1
1.7%

DPI_YM
Categorical

Distinct6
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
2021-01-01
10 
2021-02-01
10 
2021-03-01
10 
2021-04-01
10 
2021-05-01
10 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-01-01
2nd row2021-01-01
3rd row2021-01-01
4th row2021-01-01
5th row2021-01-01

Common Values

ValueCountFrequency (%)
2021-01-01 10
16.7%
2021-02-01 10
16.7%
2021-03-01 10
16.7%
2021-04-01 10
16.7%
2021-05-01 10
16.7%
2021-06-01 10
16.7%

Length

2023-12-10T19:08:12.356242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:08:12.542634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-01-01 10
16.7%
2021-02-01 10
16.7%
2021-03-01 10
16.7%
2021-04-01 10
16.7%
2021-05-01 10
16.7%
2021-06-01 10
16.7%

Interactions

2023-12-10T19:08:07.786708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:08:07.379083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:08:07.992602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:08:07.547604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:08:12.710979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
SEQ_NO1.0001.0001.0000.3420.000
REPRSNT_KWRD_NM1.0001.0001.0000.0000.000
SRCHWRD_NM1.0001.0001.0000.0000.000
KWRD_DPI_VALUE0.3420.0000.0001.0000.644
DPI_YM0.0000.0000.0000.6441.000
2023-12-10T19:08:12.954446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
REPRSNT_KWRD_NMSRCHWRD_NMDPI_YM
REPRSNT_KWRD_NM1.0001.0000.000
SRCHWRD_NM1.0001.0000.000
DPI_YM0.0000.0001.000
2023-12-10T19:08:13.194729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOKWRD_DPI_VALUEREPRSNT_KWRD_NMSRCHWRD_NMDPI_YM
SEQ_NO1.000-0.2470.9710.9710.000
KWRD_DPI_VALUE-0.2471.0000.0000.0000.408
REPRSNT_KWRD_NM0.9710.0001.0001.0000.000
SRCHWRD_NM0.9710.0001.0001.0000.000
DPI_YM0.0000.4080.0000.0001.000

Missing values

2023-12-10T19:08:08.323222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:08:08.635568image/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

SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
02673문화시설공연장마포아트센터마포아트센터3618.112021-01-01
12625문화시설공연장달성문화센터달성문화센터2572.442021-01-01
22960문화시설공연장청주예술의전당청주예술의전당1717.522021-01-01
32906문화시설공연장의정부예술의전당의정부예술의전당1479.82021-01-01
42894문화시설공연장웃는얼굴아트센터웃는얼굴아트센터2390.862021-01-01
52774문화시설공연장아양아트센터대구아양아트센터,아양아트센터3151.02021-01-01
62583문화시설공연장김해문화의전당김해문화의전당2780.772021-01-01
72487문화시설공연장강동아트센터강동아트센터3852.072021-01-01
82756문화시설공연장수성아트피아수성아트피아5296.852021-01-01
92744문화시설공연장성산아트홀성산아트홀1006.552021-01-01
SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
502761문화시설공연장수성아트피아수성아트피아5562.742021-06-01
512965문화시설공연장청주예술의전당청주예술의전당6838.282021-06-01
522588문화시설공연장김해문화의전당김해문화의전당9111.242021-06-01
532630문화시설공연장달성문화센터달성문화센터3951.482021-06-01
542749문화시설공연장성산아트홀성산아트홀6530.712021-06-01
552779문화시설공연장아양아트센터대구아양아트센터,아양아트센터8401.02021-06-01
562678문화시설공연장마포아트센터마포아트센터6565.92021-06-01
572899문화시설공연장웃는얼굴아트센터웃는얼굴아트센터5007.832021-06-01
582492문화시설공연장강동아트센터강동아트센터7481.142021-06-01
592911문화시설공연장의정부예술의전당의정부예술의전당5042.932021-06-01