Overview

Dataset statistics

Number of variables5
Number of observations86
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.6 KiB
Average record size in memory42.5 B

Variable types

Categorical4
Numeric1

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15241/S/1/datasetView.do

Alerts

'사용자코드' has constant value ""Constant

Reproduction

Analysis started2024-05-11 08:54:49.282109
Analysis finished2024-05-11 08:54:50.686562
Duration1.4 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

'대여일자'
Categorical

Distinct6
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size820.0 B
'201805'
15 
'201806'
15 
'201801'
14 
'201802'
14 
'201803'
14 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row'201801'
2nd row'201801'
3rd row'201801'
4th row'201801'
5th row'201801'

Common Values

ValueCountFrequency (%)
'201805' 15
17.4%
'201806' 15
17.4%
'201801' 14
16.3%
'201802' 14
16.3%
'201803' 14
16.3%
'201804' 14
16.3%

Length

2024-05-11T08:54:50.930304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T08:54:51.305089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
201805 15
17.4%
201806 15
17.4%
201801 14
16.3%
201802 14
16.3%
201803 14
16.3%
201804 14
16.3%

'사용자코드'
Categorical

CONSTANT 

Distinct1
Distinct (%)1.2%
Missing0
Missing (%)0.0%
Memory size820.0 B
'회원-내국인'
86 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row'회원-내국인'
2nd row'회원-내국인'
3rd row'회원-내국인'
4th row'회원-내국인'
5th row'회원-내국인'

Common Values

ValueCountFrequency (%)
'회원-내국인' 86
100.0%

Length

2024-05-11T08:54:51.757366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T08:54:52.038542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
회원-내국인 86
100.0%

'성별'
Categorical

Distinct3
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size820.0 B
'F'
42 
'M'
42 
''
 
2

Length

Max length3
Median length3
Mean length2.9767442
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row'F'
2nd row'M'
3rd row'F'
4th row'M'
5th row'F'

Common Values

ValueCountFrequency (%)
'F' 42
48.8%
'M' 42
48.8%
'' 2
 
2.3%

Length

2024-05-11T08:54:52.331141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T08:54:52.747515image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 42
48.8%
m 42
48.8%
2
 
2.3%

'연령대코드'
Categorical

Distinct7
Distinct (%)8.1%
Missing0
Missing (%)0.0%
Memory size820.0 B
'70대~'
14 
'~10대'
12 
'20대'
12 
'30대'
12 
'40대'
12 
Other values (2)
24 

Length

Max length6
Median length5
Mean length5.3023256
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row'~10대'
2nd row'~10대'
3rd row'20대'
4th row'20대'
5th row'30대'

Common Values

ValueCountFrequency (%)
'70대~' 14
16.3%
'~10대' 12
14.0%
'20대' 12
14.0%
'30대' 12
14.0%
'40대' 12
14.0%
'50대' 12
14.0%
'60대' 12
14.0%

Length

2024-05-11T08:54:53.156999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T08:54:53.534104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
70대 14
16.3%
10대 12
14.0%
20대 12
14.0%
30대 12
14.0%
40대 12
14.0%
50대 12
14.0%
60대 12
14.0%

'신규가입자수'
Real number (ℝ)

Distinct83
Distinct (%)96.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2617.907
Minimum3
Maximum28601
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size906.0 B
2024-05-11T08:54:54.314503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile17
Q1156.75
median689.5
Q32265.25
95-th percentile12920
Maximum28601
Range28598
Interquartile range (IQR)2108.5

Descriptive statistics

Standard deviation4782.8907
Coefficient of variation (CV)1.8269903
Kurtosis11.342996
Mean2617.907
Median Absolute Deviation (MAD)613.5
Skewness3.0853375
Sum225140
Variance22876044
MonotonicityNot monotonic
2024-05-11T08:54:54.953144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
74 2
 
2.3%
15 2
 
2.3%
90 2
 
2.3%
102 1
 
1.2%
1335 1
 
1.2%
3147 1
 
1.2%
8212 1
 
1.2%
6889 1
 
1.2%
14923 1
 
1.2%
18746 1
 
1.2%
Other values (73) 73
84.9%
ValueCountFrequency (%)
3 1
1.2%
8 1
1.2%
11 1
1.2%
15 2
2.3%
23 1
1.2%
40 1
1.2%
47 1
1.2%
54 1
1.2%
72 1
1.2%
74 2
2.3%
ValueCountFrequency (%)
28601 1
1.2%
18746 1
1.2%
14923 1
1.2%
14916 1
1.2%
13434 1
1.2%
11378 1
1.2%
11074 1
1.2%
8720 1
1.2%
8212 1
1.2%
6889 1
1.2%

Interactions

2024-05-11T08:54:49.713313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T08:54:55.344575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'대여일자''성별''연령대코드''신규가입자수'
'대여일자'1.0000.0000.0000.000
'성별'0.0001.0000.0000.590
'연령대코드'0.0000.0001.0000.547
'신규가입자수'0.0000.5900.5471.000
2024-05-11T08:54:55.693640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'연령대코드''성별''대여일자'
'연령대코드'1.0000.0000.000
'성별'0.0001.0000.000
'대여일자'0.0000.0001.000
2024-05-11T08:54:56.000890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'신규가입자수''대여일자''성별''연령대코드'
'신규가입자수'1.0000.0000.4430.329
'대여일자'0.0001.0000.0000.000
'성별'0.4430.0001.0000.000
'연령대코드'0.3290.0000.0001.000

Missing values

2024-05-11T08:54:50.143369image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T08:54:50.497154image/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

'대여일자''사용자코드''성별''연령대코드''신규가입자수'
0'201801''회원-내국인''F''~10대'102
1'201801''회원-내국인''M''~10대'109
2'201801''회원-내국인''F''20대'965
3'201801''회원-내국인''M''20대'1163
4'201801''회원-내국인''F''30대'387
5'201801''회원-내국인''M''30대'651
6'201801''회원-내국인''F''40대'225
7'201801''회원-내국인''M''40대'489
8'201801''회원-내국인''F''50대'119
9'201801''회원-내국인''M''50대'222
'대여일자''사용자코드''성별''연령대코드''신규가입자수'
76'201806''회원-내국인''M''30대'6479
77'201806''회원-내국인''F''40대'2182
78'201806''회원-내국인''M''40대'3226
79'201806''회원-내국인''F''50대'998
80'201806''회원-내국인''M''50대'1180
81'201806''회원-내국인''F''60대'187
82'201806''회원-내국인''M''60대'278
83'201806''회원-내국인''''70대~'28601
84'201806''회원-내국인''F''70대~'90
85'201806''회원-내국인''M''70대~'79