Overview

Dataset statistics

Number of variables5
Number of observations146
Missing cells2
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory40.9 B

Variable types

Text1
Categorical2
DateTime2

Dataset

Description울산광역시 북구에 위치한 세대공감창의놀이터 회원의 고유아이디, 회원구분, 등록일, 최근로그인, 회원상태 정보(개인정보제외)입니다.
Author울산광역시 북구
URLhttps://www.data.go.kr/data/15090243/fileData.do

Alerts

회원구분 has constant value ""Constant
회원상태 has constant value ""Constant
최근로그인 has 2 (1.4%) missing valuesMissing
고유아이디 has unique valuesUnique

Reproduction

Analysis started2023-12-12 12:42:02.710143
Analysis finished2023-12-12 12:42:03.014758
Duration0.3 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고유아이디
Text

UNIQUE 

Distinct146
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
2023-12-12T21:42:03.219396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length20
Mean length20
Min length20

Characters and Unicode

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

Unique

Unique146 ?
Unique (%)100.0%

Sample

1st rowUSRCNFRM_00000019745
2nd rowUSRCNFRM_00000019744
3rd rowUSRCNFRM_00000019743
4th rowUSRCNFRM_00000019742
5th rowUSRCNFRM_00000019741
ValueCountFrequency (%)
usrcnfrm_00000019745 1
 
0.7%
usrcnfrm_00000019637 1
 
0.7%
usrcnfrm_00000019653 1
 
0.7%
usrcnfrm_00000019646 1
 
0.7%
usrcnfrm_00000019652 1
 
0.7%
usrcnfrm_00000019651 1
 
0.7%
usrcnfrm_00000019650 1
 
0.7%
usrcnfrm_00000019649 1
 
0.7%
usrcnfrm_00000019648 1
 
0.7%
usrcnfrm_00000019647 1
 
0.7%
Other values (136) 136
93.2%
2023-12-12T21:42:03.684402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 911
31.2%
R 292
 
10.0%
1 181
 
6.2%
9 170
 
5.8%
_ 146
 
5.0%
S 146
 
5.0%
U 146
 
5.0%
M 146
 
5.0%
F 146
 
5.0%
N 146
 
5.0%
Other values (8) 490
16.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1606
55.0%
Uppercase Letter 1168
40.0%
Connector Punctuation 146
 
5.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 911
56.7%
1 181
 
11.3%
9 170
 
10.6%
6 124
 
7.7%
7 70
 
4.4%
2 35
 
2.2%
3 35
 
2.2%
4 31
 
1.9%
5 25
 
1.6%
8 24
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
R 292
25.0%
S 146
12.5%
U 146
12.5%
M 146
12.5%
F 146
12.5%
N 146
12.5%
C 146
12.5%
Connector Punctuation
ValueCountFrequency (%)
_ 146
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1752
60.0%
Latin 1168
40.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 911
52.0%
1 181
 
10.3%
9 170
 
9.7%
_ 146
 
8.3%
6 124
 
7.1%
7 70
 
4.0%
2 35
 
2.0%
3 35
 
2.0%
4 31
 
1.8%
5 25
 
1.4%
Latin
ValueCountFrequency (%)
R 292
25.0%
S 146
12.5%
U 146
12.5%
M 146
12.5%
F 146
12.5%
N 146
12.5%
C 146
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2920
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 911
31.2%
R 292
 
10.0%
1 181
 
6.2%
9 170
 
5.8%
_ 146
 
5.0%
S 146
 
5.0%
U 146
 
5.0%
M 146
 
5.0%
F 146
 
5.0%
N 146
 
5.0%
Other values (8) 490
16.8%

회원구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
개인
146 

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 (%)
개인 146
100.0%

Length

2023-12-12T21:42:03.850218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:42:03.972861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 146
100.0%

등록일
Date

Distinct143
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
Minimum2023-02-01 00:56:00
Maximum2023-02-09 13:28:00
2023-12-12T21:42:04.095186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:42:04.264444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

최근로그인
Date

MISSING 

Distinct135
Distinct (%)93.8%
Missing2
Missing (%)1.4%
Memory size1.3 KiB
Minimum2023-02-01 00:57:00
Maximum2023-02-09 13:29:00
2023-12-12T21:42:04.445513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:42:04.653600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

회원상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.7%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
승인
146 

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 (%)
승인 146
100.0%

Length

2023-12-12T21:42:04.816167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:42:05.278295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
승인 146
100.0%

Missing values

2023-12-12T21:42:02.850681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:42:02.965702image/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

고유아이디회원구분등록일최근로그인회원상태
0USRCNFRM_00000019745개인2023-02-09 13:282023-02-09 13:29승인
1USRCNFRM_00000019744개인2023-02-09 13:052023-02-09 13:05승인
2USRCNFRM_00000019743개인2023-02-08 22:442023-02-08 23:35승인
3USRCNFRM_00000019742개인2023-02-08 22:19<NA>승인
4USRCNFRM_00000019741개인2023-02-08 22:072023-02-08 22:07승인
5USRCNFRM_00000019740개인2023-02-08 21:342023-02-08 21:34승인
6USRCNFRM_00000019739개인2023-02-08 20:052023-02-08 20:06승인
7USRCNFRM_00000019738개인2023-02-08 18:352023-02-08 18:35승인
8USRCNFRM_00000019737개인2023-02-08 16:032023-02-08 16:03승인
9USRCNFRM_00000019736개인2023-02-08 14:052023-02-08 14:05승인
고유아이디회원구분등록일최근로그인회원상태
136USRCNFRM_00000019609개인2023-02-01 14:262023-02-01 14:26승인
137USRCNFRM_00000019608개인2023-02-01 14:242023-02-06 21:39승인
138USRCNFRM_00000019607개인2023-02-01 13:352023-02-02 13:48승인
139USRCNFRM_00000019606개인2023-02-01 11:502023-02-01 11:51승인
140USRCNFRM_00000019605개인2023-02-01 11:372023-02-05 14:56승인
141USRCNFRM_00000019604개인2023-02-01 11:222023-02-02 13:54승인
142USRCNFRM_00000019603개인2023-02-01 10:502023-02-01 10:50승인
143USRCNFRM_00000019602개인2023-02-01 10:222023-02-01 14:25승인
144USRCNFRM_00000019601개인2023-02-01 09:352023-02-01 09:36승인
145USRCNFRM_00000019600개인2023-02-01 00:562023-02-01 00:57승인