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
Categorical4
DateTime1

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 09:56:44.128991
Analysis finished2023-12-10 09:56:46.002555
Duration1.87 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%
Mean15990
Minimum14992
Maximum17089
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T18:56:46.163810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14992
5-th percentile14994.95
Q115387.75
median15889
Q316632.25
95-th percentile17086.05
Maximum17089
Range2097
Interquartile range (IQR)1244.5

Descriptive statistics

Standard deviation741.18753
Coefficient of variation (CV)0.046353191
Kurtosis-1.3984613
Mean15990
Median Absolute Deviation (MAD)642.5
Skewness0.21770419
Sum959400
Variance549358.95
MonotonicityNot monotonic
2023-12-10T18:56:46.658730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15397 1
 
1.7%
16633 1
 
1.7%
17087 1
 
1.7%
17057 1
 
1.7%
14995 1
 
1.7%
15904 1
 
1.7%
15875 1
 
1.7%
15400 1
 
1.7%
15388 1
 
1.7%
16432 1
 
1.7%
Other values (50) 50
83.3%
ValueCountFrequency (%)
14992 1
1.7%
14993 1
1.7%
14994 1
1.7%
14995 1
1.7%
14996 1
1.7%
14997 1
1.7%
15132 1
1.7%
15133 1
1.7%
15134 1
1.7%
15135 1
1.7%
ValueCountFrequency (%)
17089 1
1.7%
17088 1
1.7%
17087 1
1.7%
17086 1
1.7%
17085 1
1.7%
17084 1
1.7%
17059 1
1.7%
17058 1
1.7%
17057 1
1.7%
17056 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-10T18:56:47.009712image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:56:47.192303image/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 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 (%)
교육 60
100.0%

Length

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

Common Values (Plot)

2023-12-10T18:56:47.581246image/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 length15
Median length12
Mean length7.8
Min length6

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-10T18:56:47.774696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:56:48.030952image/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 length23
Median length16
Mean length8.6
Min length6

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-10T18:56:48.325912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:56:48.550545image/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%
Mean7299.9147
Minimum2773.03
Maximum15690.71
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T18:56:48.845717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2773.03
5-th percentile3690.946
Q15949.825
median7320.55
Q38509.8275
95-th percentile10707.753
Maximum15690.71
Range12917.68
Interquartile range (IQR)2560.0025

Descriptive statistics

Standard deviation2329.0988
Coefficient of variation (CV)0.31905836
Kurtosis1.8846438
Mean7299.9147
Median Absolute Deviation (MAD)1325.325
Skewness0.66376964
Sum437994.88
Variance5424701.2
MonotonicityNot monotonic
2023-12-10T18:56:49.170567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7251.06 1
 
1.7%
7034.41 1
 
1.7%
8070.86 1
 
1.7%
7833.94 1
 
1.7%
2953.3 1
 
1.7%
11906.41 1
 
1.7%
7320.1 1
 
1.7%
9682.95 1
 
1.7%
8186.06 1
 
1.7%
6941.0 1
 
1.7%
Other values (50) 50
83.3%
ValueCountFrequency (%)
2773.03 1
1.7%
2953.3 1
1.7%
3591.31 1
1.7%
3696.19 1
1.7%
3699.82 1
1.7%
4114.18 1
1.7%
4397.71 1
1.7%
4400.52 1
1.7%
4749.42 1
1.7%
4895.75 1
1.7%
ValueCountFrequency (%)
15690.71 1
1.7%
11906.41 1
1.7%
11768.01 1
1.7%
10651.95 1
1.7%
10400.32 1
1.7%
10248.33 1
1.7%
9832.98 1
1.7%
9682.95 1
1.7%
9463.51 1
1.7%
9314.37 1
1.7%

DPI_YM
Date

Distinct6
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size612.0 B
Minimum2021-01-01 00:00:00
Maximum2021-06-01 00:00:00
2023-12-10T18:56:49.659393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:56:49.935861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)

Interactions

2023-12-10T18:56:45.109797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:56:44.619648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:56:45.286070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:56:44.814299image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:56:50.109216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
SEQ_NO1.0001.0001.0000.0000.000
REPRSNT_KWRD_NM1.0001.0001.0000.4540.000
SRCHWRD_NM1.0001.0001.0000.4540.000
KWRD_DPI_VALUE0.0000.4540.4541.0000.204
DPI_YM0.0000.0000.0000.2041.000
2023-12-10T18:56:50.311779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
REPRSNT_KWRD_NMSRCHWRD_NM
REPRSNT_KWRD_NM1.0001.000
SRCHWRD_NM1.0001.000
2023-12-10T18:56:50.578953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOKWRD_DPI_VALUEREPRSNT_KWRD_NMSRCHWRD_NM
SEQ_NO1.0000.0210.9620.962
KWRD_DPI_VALUE0.0211.0000.2310.231
REPRSNT_KWRD_NM0.9620.2311.0001.000
SRCHWRD_NM0.9620.2311.0001.000

Missing values

2023-12-10T18:56:45.617126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:56:45.858800image/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
015397문화시설교육광주문화재단광주문화재단7251.062021-01-01
115385문화시설교육광주문화예술회관광주문화예술회관4749.422021-01-01
217084문화시설교육울산문화예술회관울산문화예술회관3696.192021-01-01
317054문화시설교육용인문화재단용인문화재단4895.752021-01-01
416630문화시설교육수원문화재단수원문화재단6400.842021-01-01
516428문화시설교육서울특별시교육청노원평생학습관서울특별시교육청노원평생학습관,노원평생학습관8011.02021-01-01
615132문화시설교육경기평생교육학습관경기평생교육학습관8520.052021-01-01
714992문화시설교육강남문화재단강남문화재단3591.312021-01-01
815901문화시설교육대전문화재단대전문화재단8890.52021-01-01
915872문화시설교육대구문화예술회관대구문화예술회관4400.522021-01-01
SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
5015906문화시설교육대전문화재단대전문화재단5548.882021-06-01
5117089문화시설교육울산문화예술회관울산문화예술회관9832.982021-06-01
5215137문화시설교육경기평생교육학습관경기평생교육학습관7563.622021-06-01
5315390문화시설교육광주문화예술회관광주문화예술회관8015.982021-06-01
5415877문화시설교육대구문화예술회관대구문화예술회관5838.722021-06-01
5516433문화시설교육서울특별시교육청노원평생학습관서울특별시교육청노원평생학습관,노원평생학습관7321.02021-06-01
5615402문화시설교육광주문화재단광주문화재단6026.62021-06-01
5716635문화시설교육수원문화재단수원문화재단9059.082021-06-01
5814997문화시설교육강남문화재단강남문화재단4114.182021-06-01
5917059문화시설교육용인문화재단용인문화재단9463.512021-06-01