Overview

Dataset statistics

Number of variables5
Number of observations5825
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory233.4 KiB
Average record size in memory41.0 B

Variable types

DateTime1
Categorical3
Numeric1

Dataset

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

Reproduction

Analysis started2023-12-11 06:24:41.197844
Analysis finished2023-12-11 06:24:41.725478
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

'대여일자'
Date

Distinct364
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
Minimum2017-01-01 00:00:00
Maximum2017-12-31 00:00:00
2023-12-11T15:24:41.784057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T15:24:41.932057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

'사용자코드'
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
'회원-내국인'
4709 
'회원-외국인관광객'
1116 

Length

Max length11
Median length8
Mean length8.5747639
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
'회원-내국인' 4709
80.8%
'회원-외국인관광객' 1116
 
19.2%

Length

2023-12-11T15:24:42.087695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T15:24:42.191835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
회원-내국인 4709
80.8%
회원-외국인관광객 1116
 
19.2%

'성별'
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
'M'
2935 
'F'
2890 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
'M' 2935
50.4%
'F' 2890
49.6%

Length

2023-12-11T15:24:42.292164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T15:24:42.383449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 2935
50.4%
f 2890
49.6%

'연령대코드'
Categorical

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size45.6 KiB
'20대'
1060 
'30대'
1025 
'40대'
939 
'50대'
826 
'~10대'
824 
Other values (2)
1151 

Length

Max length6
Median length5
Mean length5.2288412
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 (%)
'20대' 1060
18.2%
'30대' 1025
17.6%
'40대' 939
16.1%
'50대' 826
14.2%
'~10대' 824
14.1%
'60대' 642
11.0%
'70대~' 509
8.7%

Length

2023-12-11T15:24:42.487521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T15:24:42.586754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20대 1060
18.2%
30대 1025
17.6%
40대 939
16.1%
50대 826
14.2%
10대 824
14.1%
60대 642
11.0%
70대 509
8.7%

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

Distinct523
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66.3703
Minimum1
Maximum1415
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size51.3 KiB
2023-12-11T15:24:42.735538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median13
Q356
95-th percentile325
Maximum1415
Range1414
Interquartile range (IQR)53

Descriptive statistics

Standard deviation138.72197
Coefficient of variation (CV)2.0901212
Kurtosis21.201959
Mean66.3703
Median Absolute Deviation (MAD)12
Skewness4.0400256
Sum386607
Variance19243.785
MonotonicityNot monotonic
2023-12-11T15:24:42.878262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 756
 
13.0%
2 497
 
8.5%
3 338
 
5.8%
4 258
 
4.4%
5 210
 
3.6%
6 188
 
3.2%
7 154
 
2.6%
8 137
 
2.4%
10 95
 
1.6%
11 94
 
1.6%
Other values (513) 3098
53.2%
ValueCountFrequency (%)
1 756
13.0%
2 497
8.5%
3 338
5.8%
4 258
 
4.4%
5 210
 
3.6%
6 188
 
3.2%
7 154
 
2.6%
8 137
 
2.4%
9 88
 
1.5%
10 95
 
1.6%
ValueCountFrequency (%)
1415 1
< 0.1%
1414 1
< 0.1%
1345 1
< 0.1%
1294 1
< 0.1%
1282 1
< 0.1%
1270 1
< 0.1%
1251 1
< 0.1%
1158 1
< 0.1%
1123 1
< 0.1%
1077 1
< 0.1%

Interactions

2023-12-11T15:24:41.469640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T15:24:42.986439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'사용자코드''성별''연령대코드''신규가입자수'
'사용자코드'1.0000.0000.2400.245
'성별'0.0001.0000.0180.083
'연령대코드'0.2400.0181.0000.401
'신규가입자수'0.2450.0830.4011.000
2023-12-11T15:24:43.088815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'연령대코드''사용자코드''성별'
'연령대코드'1.0000.2570.019
'사용자코드'0.2571.0000.000
'성별'0.0190.0001.000
2023-12-11T15:24:43.175965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
'신규가입자수''사용자코드''성별''연령대코드'
'신규가입자수'1.0000.1870.0640.216
'사용자코드'0.1871.0000.0000.257
'성별'0.0640.0001.0000.019
'연령대코드'0.2160.2570.0191.000

Missing values

2023-12-11T15:24:41.593291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T15:24:41.687631image/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'2017-01-01''회원-내국인''F''~10대'3
1'2017-01-01''회원-내국인''M''~10대'3
2'2017-01-01''회원-내국인''F''20대'53
3'2017-01-01''회원-내국인''M''20대'58
4'2017-01-01''회원-내국인''F''30대'16
5'2017-01-01''회원-내국인''M''30대'36
6'2017-01-01''회원-내국인''F''40대'11
7'2017-01-01''회원-내국인''M''40대'19
8'2017-01-01''회원-내국인''F''50대'5
9'2017-01-01''회원-내국인''M''50대'6
'대여일자''사용자코드''성별''연령대코드''신규가입자수'
5815'2017-12-31''회원-내국인''F''20대'36
5816'2017-12-31''회원-내국인''M''20대'52
5817'2017-12-31''회원-내국인''F''30대'17
5818'2017-12-31''회원-내국인''M''30대'34
5819'2017-12-31''회원-내국인''F''40대'2
5820'2017-12-31''회원-내국인''M''40대'23
5821'2017-12-31''회원-내국인''F''50대'7
5822'2017-12-31''회원-내국인''M''50대'11
5823'2017-12-31''회원-내국인''F''60대'1
5824'2017-12-31''회원-내국인''M''60대'4