Overview

Dataset statistics

Number of variables10
Number of observations33
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory85.0 B

Variable types

Numeric1
Categorical7
Text2

Dataset

Description충청북도 음성군 문화예술회관 홈페이지 내 공개 테이블인 1. 행사일정관련 2. 행사일정관련 첨부파일 테이블 목록을 공개합니다.
URLhttps://www.data.go.kr/data/15119316/fileData.do

Alerts

시스템명 has constant value ""Constant
논리데이터베이스명 has constant value ""Constant
물리데이터베이스명 has constant value ""Constant
공개여부 has constant value ""Constant
데이터기준일자 has constant value ""Constant
영문테이블명 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
한글테이블명 is highly overall correlated with 연번 and 1 other fieldsHigh correlation
연번 is highly overall correlated with 영문테이블명 and 1 other fieldsHigh correlation
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:00:49.702738
Analysis finished2023-12-12 21:00:50.165523
Duration0.46 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct33
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size429.0 B
2023-12-13T06:00:50.214415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.6
Q19
median17
Q325
95-th percentile31.4
Maximum33
Range32
Interquartile range (IQR)16

Descriptive statistics

Standard deviation9.6695398
Coefficient of variation (CV)0.56879646
Kurtosis-1.2
Mean17
Median Absolute Deviation (MAD)8
Skewness0
Sum561
Variance93.5
MonotonicityStrictly increasing
2023-12-13T06:00:50.320155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 1
 
3.0%
26 1
 
3.0%
20 1
 
3.0%
21 1
 
3.0%
22 1
 
3.0%
23 1
 
3.0%
24 1
 
3.0%
25 1
 
3.0%
27 1
 
3.0%
2 1
 
3.0%
Other values (23) 23
69.7%
ValueCountFrequency (%)
1 1
3.0%
2 1
3.0%
3 1
3.0%
4 1
3.0%
5 1
3.0%
6 1
3.0%
7 1
3.0%
8 1
3.0%
9 1
3.0%
10 1
3.0%
ValueCountFrequency (%)
33 1
3.0%
32 1
3.0%
31 1
3.0%
30 1
3.0%
29 1
3.0%
28 1
3.0%
27 1
3.0%
26 1
3.0%
25 1
3.0%
24 1
3.0%

시스템명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
음성군 문화예술회관 홈페이지
33 

Length

Max length15
Median length15
Mean length15
Min length15

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row음성군 문화예술회관 홈페이지
2nd row음성군 문화예술회관 홈페이지
3rd row음성군 문화예술회관 홈페이지
4th row음성군 문화예술회관 홈페이지
5th row음성군 문화예술회관 홈페이지

Common Values

ValueCountFrequency (%)
음성군 문화예술회관 홈페이지 33
100.0%

Length

2023-12-13T06:00:50.420852image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:50.499427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
음성군 33
33.3%
문화예술회관 33
33.3%
홈페이지 33
33.3%

논리데이터베이스명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
ESK_CULTURE
33 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowESK_CULTURE
2nd rowESK_CULTURE
3rd rowESK_CULTURE
4th rowESK_CULTURE
5th rowESK_CULTURE

Common Values

ValueCountFrequency (%)
ESK_CULTURE 33
100.0%

Length

2023-12-13T06:00:50.602412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:50.682589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
esk_culture 33
100.0%

물리데이터베이스명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
문화예술회관
33 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화예술회관
2nd row문화예술회관
3rd row문화예술회관
4th row문화예술회관
5th row문화예술회관

Common Values

ValueCountFrequency (%)
문화예술회관 33
100.0%

Length

2023-12-13T06:00:50.761156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:50.842612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
문화예술회관 33
100.0%

영문테이블명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size396.0 B
TN_SCHDUL
22 
TN_SCHDUL_ATCHMNFL
11 

Length

Max length18
Median length9
Mean length12
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowTN_SCHDUL_ATCHMNFL
2nd rowTN_SCHDUL_ATCHMNFL
3rd rowTN_SCHDUL_ATCHMNFL
4th rowTN_SCHDUL_ATCHMNFL
5th rowTN_SCHDUL_ATCHMNFL

Common Values

ValueCountFrequency (%)
TN_SCHDUL 22
66.7%
TN_SCHDUL_ATCHMNFL 11
33.3%

Length

2023-12-13T06:00:50.978344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:51.069434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
tn_schdul 22
66.7%
tn_schdul_atchmnfl 11
33.3%

한글테이블명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size396.0 B
행사일정
22 
행사일정 첨부파일
11 

Length

Max length9
Median length7
Mean length7.6666667
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row행사일정 첨부파일
2nd row행사일정 첨부파일
3rd row행사일정 첨부파일
4th row행사일정 첨부파일
5th row행사일정 첨부파일

Common Values

ValueCountFrequency (%)
행사일정 22
66.7%
행사일정 첨부파일 11
33.3%

Length

2023-12-13T06:00:51.181603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:51.276486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
행사일정 33
75.0%
첨부파일 11
 
25.0%

영문 컬럼명
Text

Distinct28
Distinct (%)84.8%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-13T06:00:51.450764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length14
Mean length12.181818
Min length5

Characters and Unicode

Total characters402
Distinct characters26
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique23 ?
Unique (%)69.7%

Sample

1st rowATCHMNFL_NO
2nd rowFILE_EXTSN
3rd rowFILE_NM
4th rowFRST_REGISTER_ID
5th rowFRST_REGISTER_PNTTM
ValueCountFrequency (%)
frst_register_id 2
 
6.1%
last_updusr_pnttm 2
 
6.1%
schdul_no 2
 
6.1%
frst_register_pnttm 2
 
6.1%
last_updusr_id 2
 
6.1%
schdul_place 1
 
3.0%
atchmnfl_no 1
 
3.0%
schdul_mngt 1
 
3.0%
schdul_viewng 1
 
3.0%
schdul_ty 1
 
3.0%
Other values (18) 18
54.5%
2023-12-13T06:00:52.190878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
_ 43
10.7%
S 40
 
10.0%
T 36
 
9.0%
D 29
 
7.2%
L 29
 
7.2%
E 27
 
6.7%
U 27
 
6.7%
R 25
 
6.2%
C 24
 
6.0%
H 19
 
4.7%
Other values (16) 103
25.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 359
89.3%
Connector Punctuation 43
 
10.7%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
S 40
11.1%
T 36
10.0%
D 29
 
8.1%
L 29
 
8.1%
E 27
 
7.5%
U 27
 
7.5%
R 25
 
7.0%
C 24
 
6.7%
H 19
 
5.3%
I 19
 
5.3%
Other values (15) 84
23.4%
Connector Punctuation
ValueCountFrequency (%)
_ 43
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 359
89.3%
Common 43
 
10.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
S 40
11.1%
T 36
10.0%
D 29
 
8.1%
L 29
 
8.1%
E 27
 
7.5%
U 27
 
7.5%
R 25
 
7.0%
C 24
 
6.7%
H 19
 
5.3%
I 19
 
5.3%
Other values (15) 84
23.4%
Common
ValueCountFrequency (%)
_ 43
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 402
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
_ 43
10.7%
S 40
 
10.0%
T 36
 
9.0%
D 29
 
7.2%
L 29
 
7.2%
E 27
 
6.7%
U 27
 
6.7%
R 25
 
6.2%
C 24
 
6.0%
H 19
 
4.7%
Other values (16) 103
25.6%

한글 컬럼명
Text

Distinct29
Distinct (%)87.9%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-12-13T06:00:52.421568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length5
Mean length4.1515152
Min length1

Characters and Unicode

Total characters137
Distinct characters58
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique25 ?
Unique (%)75.8%

Sample

1st row첨부파일번호
2nd row파일확장자
3rd row파일명
4th row최초등록자ID
5th row최초등록시점
ValueCountFrequency (%)
최초등록자id 2
 
6.1%
최종수정시점 2
 
6.1%
최초등록시점 2
 
6.1%
최종수정자id 2
 
6.1%
공연시간 1
 
3.0%
첨부파일번호 1
 
3.0%
주최 1
 
3.0%
관람 1
 
3.0%
일정구분 1
 
3.0%
시간 1
 
3.0%
Other values (19) 19
57.6%
2023-12-13T06:00:52.842598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
최 9
 
6.6%
일 9
 
6.6%
시 7
 
5.1%
정 7
 
5.1%
종 5
 
3.6%
파 5
 
3.6%
장 5
 
3.6%
D 5
 
3.6%
I 5
 
3.6%
자 5
 
3.6%
Other values (48) 75
54.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 127
92.7%
Uppercase Letter 10
 
7.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
최 9
 
7.1%
일 9
 
7.1%
시 7
 
5.5%
정 7
 
5.5%
종 5
 
3.9%
파 5
 
3.9%
장 5
 
3.9%
자 5
 
3.9%
점 4
 
3.1%
수 4
 
3.1%
Other values (46) 67
52.8%
Uppercase Letter
ValueCountFrequency (%)
D 5
50.0%
I 5
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 127
92.7%
Latin 10
 
7.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
최 9
 
7.1%
일 9
 
7.1%
시 7
 
5.5%
정 7
 
5.5%
종 5
 
3.9%
파 5
 
3.9%
장 5
 
3.9%
자 5
 
3.9%
점 4
 
3.1%
수 4
 
3.1%
Other values (46) 67
52.8%
Latin
ValueCountFrequency (%)
D 5
50.0%
I 5
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 127
92.7%
ASCII 10
 
7.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
최 9
 
7.1%
일 9
 
7.1%
시 7
 
5.5%
정 7
 
5.5%
종 5
 
3.9%
파 5
 
3.9%
장 5
 
3.9%
자 5
 
3.9%
점 4
 
3.1%
수 4
 
3.1%
Other values (46) 67
52.8%
ASCII
ValueCountFrequency (%)
D 5
50.0%
I 5
50.0%

공개여부
Categorical

CONSTANT 

Distinct1
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
공개
33 

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 (%)
공개 33
100.0%

Length

2023-12-13T06:00:52.981427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:53.076994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공개 33
100.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size396.0 B
2023-08-21
33 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-21
2nd row2023-08-21
3rd row2023-08-21
4th row2023-08-21
5th row2023-08-21

Common Values

ValueCountFrequency (%)
2023-08-21 33
100.0%

Length

2023-12-13T06:00:53.193398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:00:53.324821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-21 33
100.0%

Interactions

2023-12-13T06:00:49.920873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:00:53.404510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번영문테이블명한글테이블명영문 컬럼명한글 컬럼명
연번1.0000.9950.9950.2270.552
영문테이블명0.9951.0000.9940.0000.000
한글테이블명0.9950.9941.0000.0000.000
영문 컬럼명0.2270.0000.0001.0001.000
한글 컬럼명0.5520.0000.0001.0001.000
2023-12-13T06:00:53.520778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
영문테이블명한글테이블명
영문테이블명1.0000.930
한글테이블명0.9301.000
2023-12-13T06:00:53.615121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번영문테이블명한글테이블명
연번1.0000.8050.805
영문테이블명0.8051.0000.930
한글테이블명0.8050.9301.000

Missing values

2023-12-13T06:00:50.010649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:00:50.120476image/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

연번시스템명논리데이터베이스명물리데이터베이스명영문테이블명한글테이블명영문 컬럼명한글 컬럼명공개여부데이터기준일자
01음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일ATCHMNFL_NO첨부파일번호공개2023-08-21
12음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일FILE_EXTSN파일확장자공개2023-08-21
23음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일FILE_NM파일명공개2023-08-21
34음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일FRST_REGISTER_ID최초등록자ID공개2023-08-21
45음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일FRST_REGISTER_PNTTM최초등록시점공개2023-08-21
56음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일LAST_UPDUSR_ID최종수정자ID공개2023-08-21
67음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일LAST_UPDUSR_PNTTM최종수정시점공개2023-08-21
78음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일REPLC_TEXT대체텍스트공개2023-08-21
89음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일SCHDUL_NO게시물번호공개2023-08-21
910음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL_ATCHMNFL행사일정 첨부파일STORE_FILE_NM저장파일명공개2023-08-21
연번시스템명논리데이터베이스명물리데이터베이스명영문테이블명한글테이블명영문 컬럼명한글 컬럼명공개여부데이터기준일자
2324음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_PBLPRFR_TIME공연시간공개2023-08-21
2425음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_PLACE장소공개2023-08-21
2526음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_RM기공개2023-08-21
2627음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_SJ일정명공개2023-08-21
2728음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_SUPRT후원공개2023-08-21
2829음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_TICKET티켓공개2023-08-21
2930음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_TIME시간공개2023-08-21
3031음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_TY일정구분공개2023-08-21
3132음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SCHDUL_VIEWNG관람공개2023-08-21
3233음성군 문화예술회관 홈페이지ESK_CULTURE문화예술회관TN_SCHDUL행사일정SITE_ID사이트ID공개2023-08-21