Overview

Dataset statistics

Number of variables8
Number of observations77
Missing cells0
Missing cells (%)0.0%
Duplicate rows2
Duplicate rows (%)2.6%
Total size in memory5.0 KiB
Average record size in memory66.7 B

Variable types

Numeric1
Categorical2
DateTime4
Text1

Dataset

Description수원도시공사 내 장안구민회관에서 보유중인 대관에 대한 데이터로 접수번호 가용목적 대관시작일 대관종료일 사용시설 신청일 신청팀의 항목을 반기별로 제공합니다.
Author수원도시공사
URLhttps://www.data.go.kr/data/15074627/fileData.do

Alerts

테이터기준일자 has constant value ""Constant
Dataset has 2 (2.6%) duplicate rowsDuplicates
사용목적 is highly overall correlated with 사용시설High correlation
사용시설 is highly overall correlated with 사용목적High correlation

Reproduction

Analysis started2024-04-21 07:03:24.225935
Analysis finished2024-04-21 07:03:28.525222
Duration4.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

접수번호
Real number (ℝ)

Distinct75
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20230131
Minimum20230066
Maximum20230186
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size821.0 B
2024-04-21T16:03:28.727961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20230066
5-th percentile20230089
Q120230109
median20230131
Q320230152
95-th percentile20230178
Maximum20230186
Range120
Interquartile range (IQR)43

Descriptive statistics

Standard deviation28.625561
Coefficient of variation (CV)1.4149963 × 10-6
Kurtosis-0.78344109
Mean20230131
Median Absolute Deviation (MAD)22
Skewness0.018160175
Sum1.5577201 × 109
Variance819.42276
MonotonicityIncreasing
2024-04-21T16:03:29.174898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20230151 2
 
2.6%
20230092 2
 
2.6%
20230066 1
 
1.3%
20230143 1
 
1.3%
20230152 1
 
1.3%
20230150 1
 
1.3%
20230148 1
 
1.3%
20230147 1
 
1.3%
20230146 1
 
1.3%
20230144 1
 
1.3%
Other values (65) 65
84.4%
ValueCountFrequency (%)
20230066 1
1.3%
20230080 1
1.3%
20230083 1
1.3%
20230087 1
1.3%
20230089 1
1.3%
20230090 1
1.3%
20230092 2
2.6%
20230096 1
1.3%
20230097 1
1.3%
20230098 1
1.3%
ValueCountFrequency (%)
20230186 1
1.3%
20230183 1
1.3%
20230181 1
1.3%
20230180 1
1.3%
20230178 1
1.3%
20230176 1
1.3%
20230175 1
1.3%
20230174 1
1.3%
20230173 1
1.3%
20230167 1
1.3%

사용목적
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Memory size744.0 B
기타
32 
전시회
13 
뮤지컬
13 
연주회
8 
발표회
5 
Other values (3)
6 

Length

Max length3
Median length3
Mean length2.5194805
Min length2

Unique

Unique1 ?
Unique (%)1.3%

Sample

1st row기타
2nd row전시회
3rd row연주회
4th row전시회
5th row뮤지컬

Common Values

ValueCountFrequency (%)
기타 32
41.6%
전시회 13
16.9%
뮤지컬 13
16.9%
연주회 8
 
10.4%
발표회 5
 
6.5%
연극 3
 
3.9%
무용 2
 
2.6%
콘서트 1
 
1.3%

Length

2024-04-21T16:03:29.596919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T16:03:29.951598image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
기타 32
41.6%
전시회 13
16.9%
뮤지컬 13
16.9%
연주회 8
 
10.4%
발표회 5
 
6.5%
연극 3
 
3.9%
무용 2
 
2.6%
콘서트 1
 
1.3%

대관시작일
Date

Distinct67
Distinct (%)87.0%
Missing0
Missing (%)0.0%
Memory size744.0 B
Minimum2023-06-28 00:00:00
Maximum2023-11-30 00:00:00
2024-04-21T16:03:30.370898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T16:03:30.786606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

대관종료일
Date

Distinct66
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Memory size744.0 B
Minimum2023-07-02 00:00:00
Maximum2023-12-02 00:00:00
2024-04-21T16:03:31.203099image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T16:03:31.659876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사용시설
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.9%
Missing0
Missing (%)0.0%
Memory size744.0 B
한누리아트홀
62 
노송갤러리
13 
참사랑방
 
2

Length

Max length6
Median length6
Mean length5.7792208
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row한누리아트홀
2nd row노송갤러리
3rd row한누리아트홀
4th row노송갤러리
5th row한누리아트홀

Common Values

ValueCountFrequency (%)
한누리아트홀 62
80.5%
노송갤러리 13
 
16.9%
참사랑방 2
 
2.6%

Length

2024-04-21T16:03:32.088016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T16:03:32.326428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
한누리아트홀 62
80.5%
노송갤러리 13
 
16.9%
참사랑방 2
 
2.6%

신청일
Date

Distinct42
Distinct (%)54.5%
Missing0
Missing (%)0.0%
Memory size744.0 B
Minimum2023-03-20 00:00:00
Maximum2023-11-14 00:00:00
2024-04-21T16:03:32.547224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T16:03:32.779125image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)

신청팀
Text

Distinct66
Distinct (%)85.7%
Missing0
Missing (%)0.0%
Memory size744.0 B
2024-04-21T16:03:33.817367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length12
Mean length6.9220779
Min length3

Characters and Unicode

Total characters533
Distinct characters200
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique56 ?
Unique (%)72.7%

Sample

1st row최해리가
2nd row이사금오정찬사진전시회
3rd row박윤정
4th row놀작그림놀이터
5th row극단 곰수니
ValueCountFrequency (%)
즐겨찾기 3
 
3.2%
극단 3
 
3.2%
극단이후 2
 
2.1%
중앙음악신문사 2
 
2.1%
장정희무용단 2
 
2.1%
케빈스튜디오 2
 
2.1%
안녕컴퍼니 2
 
2.1%
기산영재어린이집 2
 
2.1%
조이컬쳐 2
 
2.1%
근로복지공단수원어린이집 2
 
2.1%
Other values (72) 73
76.8%
2024-04-21T16:03:34.995632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 20
 
3.8%
18
 
3.4%
원 15
 
2.8%
단 13
 
2.4%
수 12
 
2.3%
사 11
 
2.1%
기 9
 
1.7%
극 9
 
1.7%
회 8
 
1.5%
지 7
 
1.3%
Other values (190) 411
77.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 488
91.6%
Space Separator 18
 
3.4%
Lowercase Letter 9
 
1.7%
Close Punctuation 5
 
0.9%
Decimal Number 5
 
0.9%
Open Punctuation 4
 
0.8%
Uppercase Letter 4
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 20
 
4.1%
원 15
 
3.1%
단 13
 
2.7%
수 12
 
2.5%
사 11
 
2.3%
기 9
 
1.8%
극 9
 
1.8%
회 8
 
1.6%
지 7
 
1.4%
정 7
 
1.4%
Other values (172) 377
77.3%
Lowercase Letter
ValueCountFrequency (%)
k 2
22.2%
c 1
11.1%
j 1
11.1%
l 1
11.1%
i 1
11.1%
p 1
11.1%
u 1
11.1%
s 1
11.1%
Uppercase Letter
ValueCountFrequency (%)
Y 1
25.0%
A 1
25.0%
L 1
25.0%
P 1
25.0%
Decimal Number
ValueCountFrequency (%)
1 3
60.0%
2 1
 
20.0%
5 1
 
20.0%
Space Separator
ValueCountFrequency (%)
18
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 488
91.6%
Common 32
 
6.0%
Latin 13
 
2.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 20
 
4.1%
원 15
 
3.1%
단 13
 
2.7%
수 12
 
2.5%
사 11
 
2.3%
기 9
 
1.8%
극 9
 
1.8%
회 8
 
1.6%
지 7
 
1.4%
정 7
 
1.4%
Other values (172) 377
77.3%
Latin
ValueCountFrequency (%)
k 2
15.4%
c 1
7.7%
j 1
7.7%
l 1
7.7%
i 1
7.7%
p 1
7.7%
u 1
7.7%
s 1
7.7%
Y 1
7.7%
A 1
7.7%
Other values (2) 2
15.4%
Common
ValueCountFrequency (%)
18
56.2%
) 5
 
15.6%
( 4
 
12.5%
1 3
 
9.4%
2 1
 
3.1%
5 1
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 488
91.6%
ASCII 45
 
8.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 20
 
4.1%
원 15
 
3.1%
단 13
 
2.7%
수 12
 
2.5%
사 11
 
2.3%
기 9
 
1.8%
극 9
 
1.8%
회 8
 
1.6%
지 7
 
1.4%
정 7
 
1.4%
Other values (172) 377
77.3%
ASCII
ValueCountFrequency (%)
18
40.0%
) 5
 
11.1%
( 4
 
8.9%
1 3
 
6.7%
k 2
 
4.4%
c 1
 
2.2%
2 1
 
2.2%
5 1
 
2.2%
j 1
 
2.2%
l 1
 
2.2%
Other values (8) 8
17.8%

테이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size744.0 B
Minimum2023-11-30 00:00:00
Maximum2023-11-30 00:00:00
2024-04-21T16:03:35.295594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T16:03:35.592895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-21T16:03:27.521503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T16:03:35.814963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
접수번호사용목적대관시작일대관종료일사용시설신청일신청팀
접수번호1.0000.3060.9470.9050.3080.8900.895
사용목적0.3061.0000.9220.8950.7720.8201.000
대관시작일0.9470.9221.0000.9940.0000.9900.974
대관종료일0.9050.8950.9941.0000.0000.9890.993
사용시설0.3080.7720.0000.0001.0000.6451.000
신청일0.8900.8200.9900.9890.6451.0000.987
신청팀0.8951.0000.9740.9931.0000.9871.000
2024-04-21T16:03:36.109226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
사용목적사용시설
사용목적1.0000.660
사용시설0.6601.000
2024-04-21T16:03:36.342406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
접수번호사용목적사용시설
접수번호1.0000.1070.080
사용목적0.1071.0000.660
사용시설0.0800.6601.000

Missing values

2024-04-21T16:03:27.900801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T16:03:28.345411image/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

접수번호사용목적대관시작일대관종료일사용시설신청일신청팀테이터기준일자
020230066기타2023-10-082023-10-08한누리아트홀2023-03-28최해리가2023-11-30
120230080전시회2023-07-242023-08-06노송갤러리2023-05-10이사금오정찬사진전시회2023-11-30
220230083연주회2023-09-172023-09-17한누리아트홀2023-05-19박윤정2023-11-30
320230087전시회2023-06-282023-07-02노송갤러리2023-05-20놀작그림놀이터2023-11-30
420230089뮤지컬2023-08-142023-08-15한누리아트홀2023-05-26극단 곰수니2023-11-30
520230090전시회2023-08-142023-08-19노송갤러리2023-05-26여성미술동인 줌2023-11-30
620230092기타2023-08-202023-08-20한누리아트홀2023-05-26케빈스튜디오2023-11-30
720230092기타2023-08-202023-08-20한누리아트홀2023-05-26케빈스튜디오2023-11-30
820230096기타2023-07-042023-07-04한누리아트홀2023-06-08주식회사 에듀넷2023-11-30
920230097전시회2023-08-202023-08-31노송갤러리2023-06-13유은화2023-11-30
접수번호사용목적대관시작일대관종료일사용시설신청일신청팀테이터기준일자
6720230167뮤지컬2023-10-252023-10-25한누리아트홀2023-10-24즐겨찾기2023-11-30
6820230173기타2023-11-242023-11-24한누리아트홀2023-10-27수원115의 12구역 주택재건축 정비사업조합2023-11-30
6920230174전시회2023-11-272023-12-02노송갤러리2023-11-01수원화성사진클럽2023-11-30
7020230175연극2023-11-302023-11-30한누리아트홀2023-11-01극단중원극회2023-11-30
7120230176기타2023-11-302023-11-30한누리아트홀2023-11-01(사)경기도생활연구협회2023-11-30
7220230178기타2023-11-142023-11-14한누리아트홀2023-11-02경주김씨상촌공파종중2023-11-30
7320230180기타2023-11-092023-11-09한누리아트홀2023-11-03수원시어린이집연합회2023-11-30
7420230181기타2023-11-222023-11-23한누리아트홀2023-11-07조승관(두레자연고등학교)2023-11-30
7520230183기타2023-11-202023-11-20한누리아트홀2023-11-09법무부 청소년 범죄예방위원 장안지구위원회2023-11-30
7620230186뮤지컬2023-11-272023-11-29한누리아트홀2023-11-14주)티비이엔티2023-11-30

Duplicate rows

Most frequently occurring

접수번호사용목적대관시작일대관종료일사용시설신청일신청팀테이터기준일자# duplicates
020230092기타2023-08-202023-08-20한누리아트홀2023-05-26케빈스튜디오2023-11-302
120230151발표회2023-11-032023-11-03한누리아트홀2023-03-21기산영재어린이집2023-11-302