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

Reproduction

Analysis started2023-12-10 09:52:49.119800
Analysis finished2023-12-10 09:52:50.481011
Duration1.36 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%
Mean28044.5
Minimum25625
Maximum30572
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T18:52:50.639036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum25625
5-th percentile25627.95
Q126820.75
median27886
Q329482.25
95-th percentile30569.05
Maximum30572
Range4947
Interquartile range (IQR)2661.5

Descriptive statistics

Standard deviation1644.0649
Coefficient of variation (CV)0.058623435
Kurtosis-1.1386114
Mean28044.5
Median Absolute Deviation (MAD)1331
Skewness0.18722664
Sum1682670
Variance2702949.5
MonotonicityNot monotonic
2023-12-10T18:52:50.924829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
27233 1
 
1.7%
29483 1
 
1.7%
30570 1
 
1.7%
30432 1
 
1.7%
25628 1
 
1.7%
28101 1
 
1.7%
27672 1
 
1.7%
27236 1
 
1.7%
26821 1
 
1.7%
28489 1
 
1.7%
Other values (50) 50
83.3%
ValueCountFrequency (%)
25625 1
1.7%
25626 1
1.7%
25627 1
1.7%
25628 1
1.7%
25629 1
1.7%
25630 1
1.7%
26016 1
1.7%
26017 1
1.7%
26018 1
1.7%
26019 1
1.7%
ValueCountFrequency (%)
30572 1
1.7%
30571 1
1.7%
30570 1
1.7%
30569 1
1.7%
30568 1
1.7%
30567 1
1.7%
30434 1
1.7%
30433 1
1.7%
30432 1
1.7%
30431 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:52:51.168092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

2023-12-10T18:52:51.793596image/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
동탄복합문화센터도서관
노원정보도서관
판교도서관
춘천시립도서관
은평구립도서관
Other values (5)
30 

Length

Max length13
Median length10
Mean length8.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-10T18:52:52.045568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:52:52.443475image/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
동탄복합문화센터도서관
노원정보도서관
판교도서관
춘천시립도서관
은평구립도서관
Other values (5)
30 

Length

Max length19
Median length14
Mean length11.2
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-10T18:52:52.761445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:52:53.064357image/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 (ℝ)

Distinct59
Distinct (%)98.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12046.842
Minimum8751.88
Maximum17004.73
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size672.0 B
2023-12-10T18:52:53.401398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8751.88
5-th percentile9926.8245
Q110918.067
median11783.325
Q312773.097
95-th percentile14821.703
Maximum17004.73
Range8252.85
Interquartile range (IQR)1855.03

Descriptive statistics

Standard deviation1718.5658
Coefficient of variation (CV)0.14265696
Kurtosis0.48664561
Mean12046.842
Median Absolute Deviation (MAD)932.275
Skewness0.68887841
Sum722810.49
Variance2953468.3
MonotonicityNot monotonic
2023-12-10T18:52:53.903370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
11791.0 2
 
3.3%
11700.92 1
 
1.7%
10966.06 1
 
1.7%
12756.0 1
 
1.7%
11099.8 1
 
1.7%
13841.0 1
 
1.7%
10071.0 1
 
1.7%
10240.55 1
 
1.7%
15025.07 1
 
1.7%
11141.0 1
 
1.7%
Other values (49) 49
81.7%
ValueCountFrequency (%)
8751.88 1
1.7%
8941.35 1
1.7%
9847.49 1
1.7%
9931.0 1
1.7%
9976.48 1
1.7%
10071.0 1
1.7%
10179.7 1
1.7%
10240.55 1
1.7%
10269.0 1
1.7%
10301.0 1
1.7%
ValueCountFrequency (%)
17004.73 1
1.7%
16461.4 1
1.7%
15025.07 1
1.7%
14811.0 1
1.7%
14794.46 1
1.7%
14691.0 1
1.7%
14545.23 1
1.7%
14241.0 1
1.7%
13893.6 1
1.7%
13841.0 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-10T18:52:54.317639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T18:52:54.587378image/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-10T18:52:49.786446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:52:49.520767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:52:49.937506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T18:52:49.657965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T18:52:55.309662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
SEQ_NO1.0000.9890.9890.3960.000
REPRSNT_KWRD_NM0.9891.0001.0000.5900.000
SRCHWRD_NM0.9891.0001.0000.5900.000
KWRD_DPI_VALUE0.3960.5900.5901.0000.000
DPI_YM0.0000.0000.0000.0001.000
2023-12-10T18:52:55.574660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
DPI_YMREPRSNT_KWRD_NMSRCHWRD_NM
DPI_YM1.0000.0000.000
REPRSNT_KWRD_NM0.0001.0001.000
SRCHWRD_NM0.0001.0001.000
2023-12-10T18:52:55.777915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
SEQ_NOKWRD_DPI_VALUEREPRSNT_KWRD_NMSRCHWRD_NMDPI_YM
SEQ_NO1.0000.0150.9520.9520.000
KWRD_DPI_VALUE0.0151.0000.3410.3410.000
REPRSNT_KWRD_NM0.9520.3411.0001.0000.000
SRCHWRD_NM0.9520.3411.0001.0000.000
DPI_YM0.0000.0000.0000.0001.000

Missing values

2023-12-10T18:52:50.124723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T18:52:50.380798image/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
027233문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관11700.922021-01-01
126818문화시설도서노원정보도서관노원정보도서관12461.72021-01-01
230567문화시설도서판교도서관판교도서관10179.72021-01-01
330429문화시설도서춘천시립도서관춘천시립도서관12662.332021-01-01
429480문화시설도서은평구립도서관은평구립도서관16461.42021-01-01
528485문화시설도서수성구립범어도서관수성구립범어도서관,범어도서관14811.02021-01-01
626016문화시설도서계양도서관계양도서관,인천계양도서관12441.02021-01-01
725625문화시설도서강북문화정보도서관강북문화정보도서관11443.232021-01-01
828098문화시설도서서울특별시교육청동작도서관서울특별시교육청동작도서관,동작도서관14241.02021-01-01
927669문화시설도서부산광역시립시민도서관부산광역시립시민도서관,부산시민도서관11761.02021-01-01
SEQ_NOUPPER_CTGRY_NMLWPRT_CTGRY_NMREPRSNT_KWRD_NMSRCHWRD_NMKWRD_DPI_VALUEDPI_YM
5028103문화시설도서서울특별시교육청동작도서관서울특별시교육청동작도서관,동작도서관13191.02021-06-01
5130572문화시설도서판교도서관판교도서관11156.932021-06-01
5226021문화시설도서계양도서관계양도서관,인천계양도서관12041.02021-06-01
5326823문화시설도서노원정보도서관노원정보도서관14545.232021-06-01
5427674문화시설도서부산광역시립시민도서관부산광역시립시민도서관,부산시민도서관10301.02021-06-01
5528490문화시설도서수성구립범어도서관수성구립범어도서관,범어도서관12071.02021-06-01
5627238문화시설도서동탄복합문화센터도서관동탄복합문화센터도서관8751.882021-06-01
5729485문화시설도서은평구립도서관은평구립도서관11645.562021-06-01
5825630문화시설도서강북문화정보도서관강북문화정보도서관10269.02021-06-01
5930434문화시설도서춘천시립도서관춘천시립도서관12145.562021-06-01