Overview

Dataset statistics

Number of variables11
Number of observations1179
Missing cells113
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory106.1 KiB
Average record size in memory92.1 B

Variable types

Numeric3
Text4
DateTime2
Categorical2

Dataset

Description상세id,시퀀스,홈 코드,첨부파일 id,타이틀,컨텐츠,등록자,등록날짜,수정자,수정날짜,파일순서
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-22126/S/1/datasetView.do

Alerts

수정자 has a high cardinality: 51 distinct valuesHigh cardinality
수정자 is highly overall correlated with 상세id and 3 other fieldsHigh correlation
파일순서 is highly overall correlated with 상세id and 3 other fieldsHigh correlation
상세id is highly overall correlated with 시퀀스 and 2 other fieldsHigh correlation
시퀀스 is highly overall correlated with 상세id and 2 other fieldsHigh correlation
홈 코드 is highly overall correlated with 수정자 and 1 other fieldsHigh correlation
수정날짜 has 111 (9.4%) missing valuesMissing
상세id has unique valuesUnique

Reproduction

Analysis started2024-05-11 07:08:13.272046
Analysis finished2024-05-11 07:08:15.445623
Duration2.17 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상세id
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct1179
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean604.35963
Minimum1
Maximum1701
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2024-05-11T16:08:15.532581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile59.9
Q1295.5
median590
Q3886.5
95-th percentile1132.1
Maximum1701
Range1700
Interquartile range (IQR)591

Descriptive statistics

Standard deviation368.56104
Coefficient of variation (CV)0.60983729
Kurtosis-0.56136365
Mean604.35963
Median Absolute Deviation (MAD)296
Skewness0.32048653
Sum712540
Variance135837.24
MonotonicityNot monotonic
2024-05-11T16:08:15.673554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
776 1
 
0.1%
792 1
 
0.1%
791 1
 
0.1%
790 1
 
0.1%
789 1
 
0.1%
788 1
 
0.1%
787 1
 
0.1%
786 1
 
0.1%
785 1
 
0.1%
Other values (1169) 1169
99.2%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1701 1
0.1%
1661 1
0.1%
1641 1
0.1%
1582 1
0.1%
1544 1
0.1%
1543 1
0.1%
1542 1
0.1%
1541 1
0.1%
1521 1
0.1%
1501 1
0.1%

시퀀스
Real number (ℝ)

HIGH CORRELATION 

Distinct950
Distinct (%)80.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1004.8066
Minimum7
Maximum2210
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2024-05-11T16:08:15.810438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile214.9
Q1638.5
median1000
Q31462.5
95-th percentile1842.1
Maximum2210
Range2203
Interquartile range (IQR)824

Descriptive statistics

Standard deviation511.53341
Coefficient of variation (CV)0.50908643
Kurtosis-0.62192321
Mean1004.8066
Median Absolute Deviation (MAD)381
Skewness0.31898111
Sum1184667
Variance261666.43
MonotonicityNot monotonic
2024-05-11T16:08:15.950259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1000 230
 
19.5%
242 1
 
0.1%
1762 1
 
0.1%
1665 1
 
0.1%
1666 1
 
0.1%
1667 1
 
0.1%
1668 1
 
0.1%
1669 1
 
0.1%
1670 1
 
0.1%
1675 1
 
0.1%
Other values (940) 940
79.7%
ValueCountFrequency (%)
7 1
0.1%
11 1
0.1%
12 1
0.1%
84 1
0.1%
85 1
0.1%
102 1
0.1%
121 1
0.1%
122 1
0.1%
123 1
0.1%
124 1
0.1%
ValueCountFrequency (%)
2210 1
0.1%
2209 1
0.1%
2192 1
0.1%
2191 1
0.1%
2190 1
0.1%
2189 1
0.1%
2172 1
0.1%
2171 1
0.1%
2170 1
0.1%
2169 1
0.1%

홈 코드
Real number (ℝ)

HIGH CORRELATION 

Distinct296
Distinct (%)25.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15683497
Minimum10000000
Maximum20000528
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.5 KiB
2024-05-11T16:08:16.372129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10000000
5-th percentile10000702
Q110001468
median20000143
Q320000299
95-th percentile20000478
Maximum20000528
Range10000528
Interquartile range (IQR)9998831

Descriptive statistics

Standard deviation4954760.7
Coefficient of variation (CV)0.31592194
Kurtosis-1.92707
Mean15683497
Median Absolute Deviation (MAD)302
Skewness-0.27604678
Sum1.8490842 × 1010
Variance2.4549654 × 1013
MonotonicityNot monotonic
2024-05-11T16:08:16.521697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20000380 20
 
1.7%
20000527 17
 
1.4%
10001001 14
 
1.2%
20000250 14
 
1.2%
20000150 13
 
1.1%
10001561 11
 
0.9%
10001286 10
 
0.8%
20000478 10
 
0.8%
10001481 10
 
0.8%
20000510 10
 
0.8%
Other values (286) 1050
89.1%
ValueCountFrequency (%)
10000000 4
0.3%
10000006 3
0.3%
10000017 3
0.3%
10000018 3
0.3%
10000404 3
0.3%
10000425 2
0.2%
10000427 2
0.2%
10000473 3
0.3%
10000474 3
0.3%
10000481 1
 
0.1%
ValueCountFrequency (%)
20000528 7
0.6%
20000527 17
1.4%
20000525 2
 
0.2%
20000522 5
 
0.4%
20000520 4
 
0.3%
20000515 2
 
0.2%
20000514 1
 
0.1%
20000512 1
 
0.1%
20000510 10
0.8%
20000508 1
 
0.1%

첨부파일 id
Text

Distinct1175
Distinct (%)99.7%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-05-11T16:08:16.770867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length20
Mean length22.473282
Min length20

Characters and Unicode

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

Unique

Unique1171 ?
Unique (%)99.3%

Sample

1st rowFILE_000000000004611
2nd rowFILE_000000000004612
3rd rowFILE_000000000001411
4th rowFILE_000000000001412
5th rowFILE_000000000001413
ValueCountFrequency (%)
01d7e58ad5e6421cba3ffdee05e7ade2 2
 
0.2%
ec67828a1c43458080f551add34f166c 2
 
0.2%
590c6a138ca84ec8b0bc885eb2cecc9e 2
 
0.2%
c91ca7b7da8a4295892184357ef9ebba 2
 
0.2%
file_000000000013709 1
 
0.1%
file_000000000013109 1
 
0.1%
file_000000000013105 1
 
0.1%
file_000000000013102 1
 
0.1%
file_000000000013094 1
 
0.1%
file_000000000012990 1
 
0.1%
Other values (1165) 1165
98.8%
2024-05-11T16:08:17.130281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 10718
40.5%
1 1372
 
5.2%
4 1154
 
4.4%
3 1052
 
4.0%
F 948
 
3.6%
E 940
 
3.5%
I 936
 
3.5%
_ 936
 
3.5%
L 936
 
3.5%
8 851
 
3.2%
Other values (15) 6653
25.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 18894
71.3%
Uppercase Letter 3793
 
14.3%
Lowercase Letter 2873
 
10.8%
Connector Punctuation 936
 
3.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 10718
56.7%
1 1372
 
7.3%
4 1154
 
6.1%
3 1052
 
5.6%
8 851
 
4.5%
9 835
 
4.4%
2 775
 
4.1%
5 754
 
4.0%
6 712
 
3.8%
7 671
 
3.6%
Uppercase Letter
ValueCountFrequency (%)
F 948
25.0%
E 940
24.8%
I 936
24.7%
L 936
24.7%
D 16
 
0.4%
A 8
 
0.2%
C 5
 
0.1%
B 4
 
0.1%
Lowercase Letter
ValueCountFrequency (%)
a 520
18.1%
c 508
17.7%
b 473
16.5%
e 464
16.2%
f 457
15.9%
d 451
15.7%
Connector Punctuation
ValueCountFrequency (%)
_ 936
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 19830
74.8%
Latin 6666
 
25.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
F 948
14.2%
E 940
14.1%
I 936
14.0%
L 936
14.0%
a 520
7.8%
c 508
7.6%
b 473
7.1%
e 464
7.0%
f 457
6.9%
d 451
6.8%
Other values (4) 33
 
0.5%
Common
ValueCountFrequency (%)
0 10718
54.0%
1 1372
 
6.9%
4 1154
 
5.8%
3 1052
 
5.3%
_ 936
 
4.7%
8 851
 
4.3%
9 835
 
4.2%
2 775
 
3.9%
5 754
 
3.8%
6 712
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 26496
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 10718
40.5%
1 1372
 
5.2%
4 1154
 
4.4%
3 1052
 
4.0%
F 948
 
3.6%
E 940
 
3.5%
I 936
 
3.5%
_ 936
 
3.5%
L 936
 
3.5%
8 851
 
3.2%
Other values (15) 6653
25.1%

타이틀
Text

Distinct615
Distinct (%)52.2%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-05-11T16:08:17.493245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length39
Median length32
Mean length9.0050891
Min length1

Characters and Unicode

Total characters10617
Distinct characters474
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique475 ?
Unique (%)40.3%

Sample

1st row테라스(공동시설)
2nd row공용세탁실
3rd row햇살이 가득한 거실123
4th row책상괌 침대가 구비되어있는 1인실
5th row흰색으로 마감된 깨끗한 주방
ValueCountFrequency (%)
2인실 79
 
2.9%
거실 71
 
2.6%
있는 63
 
2.3%
주거공간 60
 
2.2%
공간 50
 
1.8%
커뮤니티실 48
 
1.8%
공용시설 42
 
1.5%
주방 36
 
1.3%
공동체공간 34
 
1.2%
주차장 32
 
1.2%
Other values (826) 2214
81.1%
2024-05-11T16:08:18.026609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1580
 
14.9%
실 464
 
4.4%
공 455
 
4.3%
인 277
 
2.6%
간 243
 
2.3%
주 202
 
1.9%
거 174
 
1.6%
이 157
 
1.5%
2 152
 
1.4%
용 130
 
1.2%
Other values (464) 6783
63.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8162
76.9%
Space Separator 1580
 
14.9%
Decimal Number 406
 
3.8%
Lowercase Letter 167
 
1.6%
Other Punctuation 122
 
1.1%
Uppercase Letter 81
 
0.8%
Open Punctuation 38
 
0.4%
Close Punctuation 38
 
0.4%
Dash Punctuation 13
 
0.1%
Connector Punctuation 8
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
실 464
 
5.7%
공 455
 
5.6%
인 277
 
3.4%
간 243
 
3.0%
주 202
 
2.5%
거 174
 
2.1%
이 157
 
1.9%
용 130
 
1.6%
한 124
 
1.5%
장 121
 
1.5%
Other values (409) 5815
71.2%
Lowercase Letter
ValueCountFrequency (%)
t 17
10.2%
a 16
9.6%
m 15
9.0%
j 15
9.0%
o 15
9.0%
f 15
9.0%
s 12
 
7.2%
e 11
 
6.6%
d 8
 
4.8%
i 8
 
4.8%
Other values (9) 35
21.0%
Uppercase Letter
ValueCountFrequency (%)
C 28
34.6%
T 13
16.0%
V 11
 
13.6%
S 6
 
7.4%
B 5
 
6.2%
A 5
 
6.2%
R 5
 
6.2%
E 2
 
2.5%
D 2
 
2.5%
G 1
 
1.2%
Other values (3) 3
 
3.7%
Decimal Number
ValueCountFrequency (%)
2 152
37.4%
1 120
29.6%
3 54
 
13.3%
4 29
 
7.1%
0 23
 
5.7%
6 16
 
3.9%
5 8
 
2.0%
7 3
 
0.7%
8 1
 
0.2%
Other Punctuation
ValueCountFrequency (%)
, 93
76.2%
. 13
 
10.7%
: 11
 
9.0%
% 3
 
2.5%
! 2
 
1.6%
Open Punctuation
ValueCountFrequency (%)
( 30
78.9%
[ 8
 
21.1%
Close Punctuation
ValueCountFrequency (%)
) 30
78.9%
] 8
 
21.1%
Math Symbol
ValueCountFrequency (%)
~ 1
50.0%
+ 1
50.0%
Space Separator
ValueCountFrequency (%)
1580
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8158
76.8%
Common 2207
 
20.8%
Latin 248
 
2.3%
Han 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
실 464
 
5.7%
공 455
 
5.6%
인 277
 
3.4%
간 243
 
3.0%
주 202
 
2.5%
거 174
 
2.1%
이 157
 
1.9%
용 130
 
1.6%
한 124
 
1.5%
장 121
 
1.5%
Other values (406) 5811
71.2%
Latin
ValueCountFrequency (%)
C 28
 
11.3%
t 17
 
6.9%
a 16
 
6.5%
m 15
 
6.0%
j 15
 
6.0%
o 15
 
6.0%
f 15
 
6.0%
T 13
 
5.2%
s 12
 
4.8%
V 11
 
4.4%
Other values (22) 91
36.7%
Common
ValueCountFrequency (%)
1580
71.6%
2 152
 
6.9%
1 120
 
5.4%
, 93
 
4.2%
3 54
 
2.4%
( 30
 
1.4%
) 30
 
1.4%
4 29
 
1.3%
0 23
 
1.0%
6 16
 
0.7%
Other values (13) 80
 
3.6%
Han
ValueCountFrequency (%)
一 2
50.0%
食 1
25.0%
月 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8154
76.8%
ASCII 2455
 
23.1%
CJK 4
 
< 0.1%
Compat Jamo 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1580
64.4%
2 152
 
6.2%
1 120
 
4.9%
, 93
 
3.8%
3 54
 
2.2%
( 30
 
1.2%
) 30
 
1.2%
4 29
 
1.2%
C 28
 
1.1%
0 23
 
0.9%
Other values (45) 316
 
12.9%
Hangul
ValueCountFrequency (%)
실 464
 
5.7%
공 455
 
5.6%
인 277
 
3.4%
간 243
 
3.0%
주 202
 
2.5%
거 174
 
2.1%
이 157
 
1.9%
용 130
 
1.6%
한 124
 
1.5%
장 121
 
1.5%
Other values (403) 5807
71.2%
CJK
ValueCountFrequency (%)
一 2
50.0%
食 1
25.0%
月 1
25.0%
Compat Jamo
ValueCountFrequency (%)
ㅇ 2
50.0%
ㄷ 1
25.0%
ㄱ 1
25.0%

컨텐츠
Text

Distinct860
Distinct (%)72.9%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
2024-05-11T16:08:18.301999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length319
Median length165
Mean length51.872774
Min length1

Characters and Unicode

Total characters61158
Distinct characters871
Distinct categories16 ?
Distinct scripts3 ?
Distinct blocks9 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique733 ?
Unique (%)62.2%

Sample

1st row자연과 어우러진 도심풍경도 아름답고 마음이 활짝 열리는 공간 테라스에서 기숙사 학우들과 차를 마시며 멋진 커뮤니티활동도 해보시고 하고 싶은 일들을 만들어 보세요. 미래의 멋진 주인공이 되실거에요.
2nd row공용세탁실에 세탁건조기도 있어요. 빨래와 건조는 우리 공용세탁실에서 다~ 해결해 드려요. 학교생활을 조금 더 알차고 행복하게 하는 게 저희 공용세탁실의 임무랍니다.
3rd row조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.
4th row조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.
5th row조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.
ValueCountFrequency (%)
수 315
 
2.2%
있습니다 247
 
1.8%
함께 191
 
1.4%
있는 186
 
1.3%
83
 
0.6%
등 79
 
0.6%
더 77
 
0.5%
있어 73
 
0.5%
공간 72
 
0.5%
넓은 61
 
0.4%
Other values (4813) 12685
90.2%
2024-05-11T16:08:18.776129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13400
 
21.9%
. 1239
 
2.0%
이 1137
 
1.9%
다 1069
 
1.7%
니 959
 
1.6%
하 845
 
1.4%
공 827
 
1.4%
는 814
 
1.3%
있 789
 
1.3%
어 752
 
1.2%
Other values (861) 39327
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 44078
72.1%
Space Separator 13400
 
21.9%
Other Punctuation 2060
 
3.4%
Decimal Number 664
 
1.1%
Lowercase Letter 419
 
0.7%
Uppercase Letter 248
 
0.4%
Math Symbol 90
 
0.1%
Close Punctuation 61
 
0.1%
Open Punctuation 60
 
0.1%
Dash Punctuation 42
 
0.1%
Other values (6) 36
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 1137
 
2.6%
다 1069
 
2.4%
니 959
 
2.2%
하 845
 
1.9%
공 827
 
1.9%
는 814
 
1.8%
있 789
 
1.8%
어 752
 
1.7%
실 697
 
1.6%
가 693
 
1.6%
Other values (774) 35496
80.5%
Uppercase Letter
ValueCountFrequency (%)
C 50
20.2%
T 40
16.1%
V 30
12.1%
O 16
 
6.5%
E 13
 
5.2%
M 12
 
4.8%
A 12
 
4.8%
L 12
 
4.8%
B 11
 
4.4%
S 9
 
3.6%
Other values (13) 43
17.3%
Lowercase Letter
ValueCountFrequency (%)
f 159
37.9%
a 35
 
8.4%
e 24
 
5.7%
t 23
 
5.5%
s 22
 
5.3%
d 18
 
4.3%
m 17
 
4.1%
o 15
 
3.6%
u 14
 
3.3%
n 14
 
3.3%
Other values (12) 78
18.6%
Other Punctuation
ValueCountFrequency (%)
. 1239
60.1%
, 613
29.8%
! 74
 
3.6%
/ 52
 
2.5%
? 36
 
1.7%
: 24
 
1.2%
' 10
 
0.5%
% 5
 
0.2%
@ 4
 
0.2%
？ 1
 
< 0.1%
Other values (2) 2
 
0.1%
Decimal Number
ValueCountFrequency (%)
2 221
33.3%
1 174
26.2%
3 74
 
11.1%
4 56
 
8.4%
0 31
 
4.7%
5 30
 
4.5%
6 24
 
3.6%
8 23
 
3.5%
7 16
 
2.4%
9 15
 
2.3%
Other Symbol
ValueCountFrequency (%)
○ 5
62.5%
☎ 1
 
12.5%
● 1
 
12.5%
㎡ 1
 
12.5%
Math Symbol
ValueCountFrequency (%)
~ 89
98.9%
+ 1
 
1.1%
Close Punctuation
ValueCountFrequency (%)
) 59
96.7%
] 2
 
3.3%
Open Punctuation
ValueCountFrequency (%)
( 58
96.7%
[ 2
 
3.3%
Initial Punctuation
ValueCountFrequency (%)
‘ 6
75.0%
“ 2
 
25.0%
Final Punctuation
ValueCountFrequency (%)
’ 6
75.0%
” 2
 
25.0%
Other Number
ValueCountFrequency (%)
② 1
50.0%
① 1
50.0%
Space Separator
ValueCountFrequency (%)
13400
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 42
100.0%
Modifier Symbol
ValueCountFrequency (%)
^ 8
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 44078
72.1%
Common 16413
 
26.8%
Latin 667
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 1137
 
2.6%
다 1069
 
2.4%
니 959
 
2.2%
하 845
 
1.9%
공 827
 
1.9%
는 814
 
1.8%
있 789
 
1.8%
어 752
 
1.7%
실 697
 
1.6%
가 693
 
1.6%
Other values (774) 35496
80.5%
Latin
ValueCountFrequency (%)
f 159
23.8%
C 50
 
7.5%
T 40
 
6.0%
a 35
 
5.2%
V 30
 
4.5%
e 24
 
3.6%
t 23
 
3.4%
s 22
 
3.3%
d 18
 
2.7%
m 17
 
2.5%
Other values (35) 249
37.3%
Common
ValueCountFrequency (%)
13400
81.6%
. 1239
 
7.5%
, 613
 
3.7%
2 221
 
1.3%
1 174
 
1.1%
~ 89
 
0.5%
! 74
 
0.5%
3 74
 
0.5%
) 59
 
0.4%
( 58
 
0.4%
Other values (32) 412
 
2.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 44072
72.1%
ASCII 17053
 
27.9%
Punctuation 16
 
< 0.1%
Geometric Shapes 6
 
< 0.1%
Compat Jamo 6
 
< 0.1%
Enclosed Alphanum 2
 
< 0.1%
Misc Symbols 1
 
< 0.1%
CJK Compat 1
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13400
78.6%
. 1239
 
7.3%
, 613
 
3.6%
2 221
 
1.3%
1 174
 
1.0%
f 159
 
0.9%
~ 89
 
0.5%
! 74
 
0.4%
3 74
 
0.4%
) 59
 
0.3%
Other values (66) 951
 
5.6%
Hangul
ValueCountFrequency (%)
이 1137
 
2.6%
다 1069
 
2.4%
니 959
 
2.2%
하 845
 
1.9%
공 827
 
1.9%
는 814
 
1.8%
있 789
 
1.8%
어 752
 
1.7%
실 697
 
1.6%
가 693
 
1.6%
Other values (770) 35490
80.5%
Punctuation
ValueCountFrequency (%)
‘ 6
37.5%
’ 6
37.5%
” 2
 
12.5%
“ 2
 
12.5%
Geometric Shapes
ValueCountFrequency (%)
○ 5
83.3%
● 1
 
16.7%
Compat Jamo
ValueCountFrequency (%)
ㅎ 2
33.3%
ㅇ 2
33.3%
ㅅ 1
16.7%
ㅛ 1
16.7%
Misc Symbols
ValueCountFrequency (%)
☎ 1
100.0%
Enclosed Alphanum
ValueCountFrequency (%)
② 1
50.0%
① 1
50.0%
CJK Compat
ValueCountFrequency (%)
㎡ 1
100.0%
None
ValueCountFrequency (%)
？ 1
100.0%

등록자
Text

Distinct87
Distinct (%)7.4%
Missing2
Missing (%)0.2%
Memory size9.3 KiB
2024-05-11T16:08:19.034911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length19.304163
Min length5

Characters and Unicode

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

Unique

Unique11 ?
Unique (%)0.9%

Sample

1st rowUSRCNFRM_00000000669
2nd rowUSRCNFRM_00000000669
3rd rowUSRCNFRM_00000000144
4th rowUSRCNFRM_00000000144
5th rowUSRCNFRM_00000000144
ValueCountFrequency (%)
usrcnfrm_00000001041 258
21.9%
usrcnfrm_00000004015 133
 
11.3%
usrcnfrm_00000000669 122
 
10.4%
usrcnfrm_00000003531 58
 
4.9%
usrcnfrm_00000000836 52
 
4.4%
youth 40
 
3.4%
usrcnfrm_00000003552 40
 
3.4%
usrcnfrm_00000003727 30
 
2.5%
usrcnfrm_00000005654 21
 
1.8%
usrcnfrm_00000011421 20
 
1.7%
Other values (77) 403
34.2%
2024-05-11T16:08:19.436185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 8537
37.6%
R 2244
 
9.9%
M 1122
 
4.9%
S 1122
 
4.9%
_ 1122
 
4.9%
U 1122
 
4.9%
F 1122
 
4.9%
N 1122
 
4.9%
C 1122
 
4.9%
1 1034
 
4.6%
Other values (21) 3052
 
13.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 12342
54.3%
Uppercase Letter 8976
39.5%
Connector Punctuation 1122
 
4.9%
Lowercase Letter 281
 
1.2%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 46
16.4%
u 43
15.3%
h 43
15.3%
t 40
14.2%
y 40
14.2%
a 12
 
4.3%
d 12
 
4.3%
m 12
 
4.3%
i 12
 
4.3%
n 12
 
4.3%
Other values (3) 9
 
3.2%
Decimal Number
ValueCountFrequency (%)
0 8537
69.2%
1 1034
 
8.4%
4 563
 
4.6%
6 542
 
4.4%
5 460
 
3.7%
3 418
 
3.4%
9 238
 
1.9%
2 220
 
1.8%
7 199
 
1.6%
8 131
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
R 2244
25.0%
M 1122
12.5%
S 1122
12.5%
U 1122
12.5%
F 1122
12.5%
N 1122
12.5%
C 1122
12.5%
Connector Punctuation
ValueCountFrequency (%)
_ 1122
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 13464
59.3%
Latin 9257
40.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
R 2244
24.2%
M 1122
12.1%
S 1122
12.1%
U 1122
12.1%
F 1122
12.1%
N 1122
12.1%
C 1122
12.1%
o 46
 
0.5%
u 43
 
0.5%
h 43
 
0.5%
Other values (10) 149
 
1.6%
Common
ValueCountFrequency (%)
0 8537
63.4%
_ 1122
 
8.3%
1 1034
 
7.7%
4 563
 
4.2%
6 542
 
4.0%
5 460
 
3.4%
3 418
 
3.1%
9 238
 
1.8%
2 220
 
1.6%
7 199
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 22721
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 8537
37.6%
R 2244
 
9.9%
M 1122
 
4.9%
S 1122
 
4.9%
_ 1122
 
4.9%
U 1122
 
4.9%
F 1122
 
4.9%
N 1122
 
4.9%
C 1122
 
4.9%
1 1034
 
4.6%
Other values (21) 3052
 
13.4%

등록날짜
Date

Distinct477
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
Minimum2017-05-22 17:05:25
Maximum2024-03-27 15:34:09
2024-05-11T16:08:19.574149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:19.701338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정자
Categorical

HIGH CARDINALITY  HIGH CORRELATION 

Distinct51
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
<NA>
247 
USRCNFRM_00000000836
150 
USRCNFRM_00000004015
133 
USRCNFRM_00000001314
117 
USRCNFRM_00000000669
108 
Other values (46)
424 

Length

Max length20
Median length20
Mean length16.648007
Min length4

Unique

Unique4 ?
Unique (%)0.3%

Sample

1st rowUSRCNFRM_00000003727
2nd rowUSRCNFRM_00000003727
3rd rowUSRCNFRM_00000000144
4th rowUSRCNFRM_00000000144
5th rowUSRCNFRM_00000000144

Common Values

ValueCountFrequency (%)
<NA> 247
20.9%
USRCNFRM_00000000836 150
12.7%
USRCNFRM_00000004015 133
11.3%
USRCNFRM_00000001314 117
9.9%
USRCNFRM_00000000669 108
9.2%
USRCNFRM_00000003531 58
 
4.9%
USRCNFRM_00000003552 36
 
3.1%
USRCNFRM_00000001309 35
 
3.0%
USRCNFRM_00000003727 33
 
2.8%
USRCNFRM_00000001170 17
 
1.4%
Other values (41) 245
20.8%

Length

2024-05-11T16:08:19.847468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 247
20.9%
usrcnfrm_00000000836 150
12.7%
usrcnfrm_00000004015 133
11.3%
usrcnfrm_00000001314 117
9.9%
usrcnfrm_00000000669 108
9.2%
usrcnfrm_00000003531 58
 
4.9%
usrcnfrm_00000003552 36
 
3.1%
usrcnfrm_00000001309 35
 
3.0%
usrcnfrm_00000003727 33
 
2.8%
usrcnfrm_00000001170 17
 
1.4%
Other values (41) 245
20.8%

수정날짜
Date

MISSING 

Distinct320
Distinct (%)30.0%
Missing111
Missing (%)9.4%
Memory size9.3 KiB
Minimum2017-07-06 14:37:56
Maximum2024-03-27 15:34:09
2024-05-11T16:08:19.967684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:20.099287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

파일순서
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size9.3 KiB
0
936 
<NA>
243 

Length

Max length4
Median length1
Mean length1.6183206
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
0 936
79.4%
<NA> 243
 
20.6%

Length

2024-05-11T16:08:20.223627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T16:08:20.315354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0 936
79.4%
na 243
 
20.6%

Interactions

2024-05-11T16:08:14.794322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.174293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.490997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.888655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.266433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.617165image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.971540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.358249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T16:08:14.704401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T16:08:20.375933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상세id시퀀스홈 코드등록자수정자
상세id1.0000.8610.7270.9350.844
시퀀스0.8611.0000.9270.9640.965
홈 코드0.7270.9271.0000.9830.982
등록자0.9350.9640.9831.0000.998
수정자0.8440.9650.9820.9981.000
2024-05-11T16:08:20.472371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
수정자파일순서
수정자1.0001.000
파일순서1.0001.000
2024-05-11T16:08:20.566272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상세id시퀀스홈 코드수정자파일순서
상세id1.0000.5920.2900.5431.000
시퀀스0.5921.000-0.2750.7141.000
홈 코드0.290-0.2751.0000.8841.000
수정자0.5430.7140.8841.0001.000
파일순서1.0001.0001.0001.0001.000

Missing values

2024-05-11T16:08:15.094834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T16:08:15.261586image/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.
2024-05-11T16:08:15.381459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

상세id시퀀스홈 코드첨부파일 id타이틀컨텐츠등록자등록날짜수정자수정날짜파일순서
0124220000312FILE_000000000004611테라스(공동시설)자연과 어우러진 도심풍경도 아름답고 마음이 활짝 열리는 공간 테라스에서 기숙사 학우들과 차를 마시며 멋진 커뮤니티활동도 해보시고 하고 싶은 일들을 만들어 보세요. 미래의 멋진 주인공이 되실거에요.USRCNFRM_000000006692017-07-29 09:47:52.0USRCNFRM_000000037272019-09-04 14:50:33.00
1224320000312FILE_000000000004612공용세탁실공용세탁실에 세탁건조기도 있어요. 빨래와 건조는 우리 공용세탁실에서 다~ 해결해 드려요. 학교생활을 조금 더 알차고 행복하게 하는 게 저희 공용세탁실의 임무랍니다.USRCNFRM_000000006692017-07-29 09:47:52.0USRCNFRM_000000037272019-09-04 14:50:33.00
23710000017FILE_000000000001411햇살이 가득한 거실123조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.USRCNFRM_000000001442017-05-22 17:05:25.0USRCNFRM_00000000144<NA>0
341110000017FILE_000000000001412책상괌 침대가 구비되어있는 1인실조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.USRCNFRM_000000001442017-05-22 17:29:07.0USRCNFRM_00000000144<NA>0
451210000017FILE_000000000001413흰색으로 마감된 깨끗한 주방조금 작지만 햇살이 잘 드는 아늑한 공간으로 흰색 벽마감과 붙박이 쇼파를 배치하여 수납공간으로 활용하여 공간 깨끗하게 공유할 수 있습니다.USRCNFRM_000000001442017-05-22 17:36:25.0USRCNFRM_00000000144<NA>0
5614820000298FILE_000000000003830현관문암호화된 비밀번호로 안전한 보안시스템 가동되니 외부인 출입금지로 안전한 대학생 기숙사 보금자리랍니다. 외부인 절대 노노 안전한 보금자리 행복한 기숙사생활이 되겠죠~USRCNFRM_000000008212017-07-20 13:46:13.0USRCNFRM_00000000669<NA>0
6714620000298FILE_000000000003824커뮤니티실과제와 발표준비 또는 미래비젼을 토론할 수 있는 열린 장소 커뮤니티실입니다. 맘껏 상상의 나래를 펼쳐보세요. 나와 우리들이 밝은 미래를 꿈꿔보세요. 커뮤니티실은 여러분들의 공간으로 24시간 환영합니다.USRCNFRM_000000008212017-07-20 13:46:13.0USRCNFRM_00000000669<NA>0
7814720000298FILE_000000000003825공용휴게실문제가 안풀리거나 생각이 복잡할 때는 휴게실로 고고하세요. 여러 학우님들의 자유공간 휴게실에서 쉬어가세요~ 휴게실은 언제든지 여러분을 기다리고 있습니다.USRCNFRM_000000008212017-07-20 13:46:13.0USRCNFRM_00000000669<NA>0
8914920000298FILE_000000000003827공용세탁실빨래는 모아모아 주세요. 드럼세탁기가 여러분의 세탁을 깨까시 빨아서 몸을 상쾌하게 해드려요. 우리는 여러 학우님들의 세탁에 언제나 책임을 지는 드럼세탁기입니다.USRCNFRM_000000008212017-07-20 13:46:13.0USRCNFRM_00000000669<NA>0
91017310000473FILE_000000000003963깔끔한 부엌과 식탁깔끔한 부엌과 식탁USRCNFRM_000000002442017-07-21 14:05:21.0USRCNFRM_000000002442017-07-21 14:05:21.00
상세id시퀀스홈 코드첨부파일 id타이틀컨텐츠등록자등록날짜수정자수정날짜파일순서
11691139100020000371e87e1e45473e4f67a22460ffdbd46980코인세탁실코인세탁실youth2023-06-08 15:21:31.0<NA>2023-06-08 15:21:31.0<NA>
11701661100020000528d0dc08b140f64116b2efff3208d9e452쌍문생활 상세 공고문문의사항은 urbanup@urbanup.co.kr 메일 혹은 담당자 연락처 010-3293-9037 로 문의 바랍니다. (평일 9시 - 18시 중 답변)USRCNFRM_000000202362024-02-15 13:21:14.0<NA>2024-02-15 13:21:14.0<NA>
11711241100020000515f119ad785ea34a52aee35950bca456ea테스트 한글 파일 입니다.테스트 한글 파일 입니다.USRCNFRM_000000113612023-09-26 09:42:51.0<NA>2023-09-26 09:42:51.0<NA>
11721491100020000527675d71ac1a9744b79221099ffc43f593주방주방USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
117314921000200005272285183daa8e4dd8b257871b666ac983욕실욕실USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
117414931000200005277752ec5be0e84308a8d13c43043f1221세탁기세탁기USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
11751494100020000527eb2bdd094c624a02bc9d4f11a8453af6인덕션인덕션USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
11761495100020000527741531f4d9d84cabbc940363d20082f6냉장고냉장고USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
117714961000200005273d61e5190547430fa6c5f78a1608b595에어컨에어컨USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>
11781497100020000527427009e449c94de4b2fed532e0bfed7d붙박이장붙박이장USRCNFRM_000000056542023-12-13 17:38:42.0<NA>2023-12-13 17:38:42.0<NA>