Overview

Dataset statistics

Number of variables5
Number of observations2062
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory86.7 KiB
Average record size in memory43.1 B

Variable types

Categorical2
Text1
Numeric2

Dataset

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

Alerts

일자 / 월 has constant value ""Constant
대여 건수 is highly overall correlated with 반납 건수High correlation
반납 건수 is highly overall correlated with 대여 건수High correlation
대여소 명 has unique valuesUnique

Reproduction

Analysis started2024-03-13 09:53:23.846582
Analysis finished2024-03-13 09:53:24.691138
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대여소 그룹
Categorical

Distinct26
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
송파구
 
130
강서구
 
123
서초구
 
120
강남구
 
117
영등포구
 
107
Other values (21)
1465 

Length

Max length4
Median length3
Mean length3.0940834
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row강남구
2nd row강남구
3rd row강남구
4th row강남구
5th row강남구

Common Values

ValueCountFrequency (%)
송파구 130
 
6.3%
강서구 123
 
6.0%
서초구 120
 
5.8%
강남구 117
 
5.7%
영등포구 107
 
5.2%
마포구 97
 
4.7%
종로구 93
 
4.5%
구로구 86
 
4.2%
노원구 86
 
4.2%
강동구 83
 
4.0%
Other values (16) 1020
49.5%

Length

2024-03-13T18:53:24.788465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
송파구 130
 
6.3%
강서구 123
 
6.0%
서초구 120
 
5.8%
강남구 117
 
5.7%
영등포구 107
 
5.2%
마포구 97
 
4.7%
종로구 93
 
4.5%
구로구 86
 
4.2%
노원구 86
 
4.2%
강동구 83
 
4.0%
Other values (16) 1020
49.5%

대여소 명
Text

UNIQUE 

Distinct2062
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
2024-03-13T18:53:25.115232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length31
Mean length15.327837
Min length3

Characters and Unicode

Total characters31606
Distinct characters560
Distinct categories12 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2062 ?
Unique (%)100.0%

Sample

1st row2301. 현대고등학교 건너편
2nd row2302. 교보타워 버스정류장(신논현역 3번출구 후면)
3rd row2303. 논현역 7번출구
4th row2304. 신영 ROYAL PALACE 앞
5th row2305. MCM 본사 직영점 앞
ValueCountFrequency (%)
앞 527
 
8.9%
옆 91
 
1.5%
출구 83
 
1.4%
1번출구 57
 
1.0%
입구 52
 
0.9%
사거리 46
 
0.8%
교차로 44
 
0.7%
2번출구 43
 
0.7%
뒤 41
 
0.7%
3번출구 39
 
0.7%
Other values (4069) 4904
82.7%
2024-03-13T18:53:25.501939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3865
 
12.2%
. 2062
 
6.5%
1 1715
 
5.4%
2 1388
 
4.4%
3 988
 
3.1%
5 731
 
2.3%
4 716
 
2.3%
0 703
 
2.2%
구 676
 
2.1%
6 647
 
2.0%
Other values (550) 18115
57.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 16399
51.9%
Decimal Number 8523
27.0%
Space Separator 3865
 
12.2%
Other Punctuation 2079
 
6.6%
Uppercase Letter 296
 
0.9%
Open Punctuation 198
 
0.6%
Close Punctuation 198
 
0.6%
Lowercase Letter 28
 
0.1%
Dash Punctuation 13
 
< 0.1%
Math Symbol 5
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 676
 
4.1%
앞 641
 
3.9%
역 493
 
3.0%
번 437
 
2.7%
출 430
 
2.6%
동 427
 
2.6%
교 346
 
2.1%
리 278
 
1.7%
파 264
 
1.6%
아 250
 
1.5%
Other values (492) 12157
74.1%
Uppercase Letter
ValueCountFrequency (%)
K 35
11.8%
S 32
10.8%
C 27
 
9.1%
T 27
 
9.1%
A 22
 
7.4%
L 19
 
6.4%
G 19
 
6.4%
P 16
 
5.4%
M 16
 
5.4%
D 14
 
4.7%
Other values (14) 69
23.3%
Lowercase Letter
ValueCountFrequency (%)
e 10
35.7%
k 4
 
14.3%
s 3
 
10.7%
l 2
 
7.1%
t 2
 
7.1%
n 2
 
7.1%
v 1
 
3.6%
y 1
 
3.6%
m 1
 
3.6%
o 1
 
3.6%
Decimal Number
ValueCountFrequency (%)
1 1715
20.1%
2 1388
16.3%
3 988
11.6%
5 731
8.6%
4 716
8.4%
0 703
8.2%
6 647
 
7.6%
7 587
 
6.9%
8 526
 
6.2%
9 522
 
6.1%
Other Punctuation
ValueCountFrequency (%)
. 2062
99.2%
, 10
 
0.5%
& 3
 
0.1%
? 3
 
0.1%
· 1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 4
80.0%
+ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
3865
100.0%
Open Punctuation
ValueCountFrequency (%)
( 198
100.0%
Close Punctuation
ValueCountFrequency (%)
) 198
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 16400
51.9%
Common 14882
47.1%
Latin 324
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 676
 
4.1%
앞 641
 
3.9%
역 493
 
3.0%
번 437
 
2.7%
출 430
 
2.6%
동 427
 
2.6%
교 346
 
2.1%
리 278
 
1.7%
파 264
 
1.6%
아 250
 
1.5%
Other values (493) 12158
74.1%
Latin
ValueCountFrequency (%)
K 35
 
10.8%
S 32
 
9.9%
C 27
 
8.3%
T 27
 
8.3%
A 22
 
6.8%
L 19
 
5.9%
G 19
 
5.9%
P 16
 
4.9%
M 16
 
4.9%
D 14
 
4.3%
Other values (25) 97
29.9%
Common
ValueCountFrequency (%)
3865
26.0%
. 2062
13.9%
1 1715
11.5%
2 1388
 
9.3%
3 988
 
6.6%
5 731
 
4.9%
4 716
 
4.8%
0 703
 
4.7%
6 647
 
4.3%
7 587
 
3.9%
Other values (12) 1480
 
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 16399
51.9%
ASCII 15205
48.1%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3865
25.4%
. 2062
13.6%
1 1715
11.3%
2 1388
 
9.1%
3 988
 
6.5%
5 731
 
4.8%
4 716
 
4.7%
0 703
 
4.6%
6 647
 
4.3%
7 587
 
3.9%
Other values (46) 1803
11.9%
Hangul
ValueCountFrequency (%)
구 676
 
4.1%
앞 641
 
3.9%
역 493
 
3.0%
번 437
 
2.7%
출 430
 
2.6%
동 427
 
2.6%
교 346
 
2.1%
리 278
 
1.7%
파 264
 
1.6%
아 250
 
1.5%
Other values (492) 12157
74.1%
None
ValueCountFrequency (%)
· 1
50.0%
㈜ 1
50.0%

일자 / 월
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.2 KiB
202006
2062 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
202006 2062
100.0%

Length

2024-03-13T18:53:25.615988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T18:53:25.698021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
202006 2062
100.0%

대여 건수
Real number (ℝ)

HIGH CORRELATION 

Distinct1475
Distinct (%)71.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1343.7667
Minimum0
Maximum16604
Zeros1
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size18.3 KiB
2024-03-13T18:53:25.800671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile68.05
Q1436.75
median1012.5
Q31819
95-th percentile3682.25
Maximum16604
Range16604
Interquartile range (IQR)1382.25

Descriptive statistics

Standard deviation1353.8992
Coefficient of variation (CV)1.0075403
Kurtosis20.86243
Mean1343.7667
Median Absolute Deviation (MAD)660.5
Skewness3.1682413
Sum2770847
Variance1833043
MonotonicityNot monotonic
2024-03-13T18:53:25.937306image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 13
 
0.6%
74 5
 
0.2%
93 4
 
0.2%
566 4
 
0.2%
145 4
 
0.2%
372 4
 
0.2%
1146 4
 
0.2%
57 4
 
0.2%
291 4
 
0.2%
796 4
 
0.2%
Other values (1465) 2012
97.6%
ValueCountFrequency (%)
0 1
 
< 0.1%
1 13
0.6%
2 1
 
< 0.1%
3 3
 
0.1%
4 1
 
< 0.1%
5 1
 
< 0.1%
6 3
 
0.1%
7 2
 
0.1%
8 1
 
< 0.1%
9 1
 
< 0.1%
ValueCountFrequency (%)
16604 1
< 0.1%
16167 1
< 0.1%
11719 1
< 0.1%
11414 1
< 0.1%
9103 1
< 0.1%
8670 1
< 0.1%
8297 1
< 0.1%
8061 1
< 0.1%
7999 1
< 0.1%
7958 1
< 0.1%

반납 건수
Real number (ℝ)

HIGH CORRELATION 

Distinct1469
Distinct (%)71.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1335.5218
Minimum0
Maximum17760
Zeros3
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size18.3 KiB
2024-03-13T18:53:26.083884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile49.05
Q1382.25
median975.5
Q31812
95-th percentile3790.5
Maximum17760
Range17760
Interquartile range (IQR)1429.75

Descriptive statistics

Standard deviation1403.8587
Coefficient of variation (CV)1.0511687
Kurtosis20.980785
Mean1335.5218
Median Absolute Deviation (MAD)671
Skewness3.1767093
Sum2753846
Variance1970819.4
MonotonicityNot monotonic
2024-03-13T18:53:26.211987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 10
 
0.5%
130 5
 
0.2%
90 5
 
0.2%
10 5
 
0.2%
297 5
 
0.2%
123 5
 
0.2%
1339 4
 
0.2%
760 4
 
0.2%
35 4
 
0.2%
157 4
 
0.2%
Other values (1459) 2011
97.5%
ValueCountFrequency (%)
0 3
 
0.1%
1 10
0.5%
2 3
 
0.1%
3 2
 
0.1%
4 3
 
0.1%
5 3
 
0.1%
6 3
 
0.1%
7 2
 
0.1%
8 1
 
< 0.1%
9 2
 
0.1%
ValueCountFrequency (%)
17760 1
< 0.1%
16134 1
< 0.1%
12388 1
< 0.1%
11442 1
< 0.1%
9374 1
< 0.1%
8536 1
< 0.1%
8403 1
< 0.1%
8127 1
< 0.1%
8100 1
< 0.1%
8083 1
< 0.1%

Interactions

2024-03-13T18:53:24.364083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T18:53:24.186198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T18:53:24.460886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T18:53:24.270531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T18:53:26.302460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대여소 그룹대여 건수반납 건수
대여소 그룹1.0000.2350.217
대여 건수0.2351.0000.947
반납 건수0.2170.9471.000
2024-03-13T18:53:26.391620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대여 건수반납 건수대여소 그룹
대여 건수1.0000.9930.090
반납 건수0.9931.0000.088
대여소 그룹0.0900.0881.000

Missing values

2024-03-13T18:53:24.571149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T18:53:24.650481image/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강남구2301. 현대고등학교 건너편20200645124714
1강남구2302. 교보타워 버스정류장(신논현역 3번출구 후면)20200616501628
2강남구2303. 논현역 7번출구20200611341072
3강남구2304. 신영 ROYAL PALACE 앞202006399130
4강남구2305. MCM 본사 직영점 앞202006490475
5강남구2306. 압구정역 2번 출구 옆20200613101305
6강남구2307. 압구정 한양 3차 아파트20200619351920
7강남구2308. 압구정파출소 앞20200610541044
8강남구2309. 청담역(우리들병원 앞)202006663329
9강남구2310. 청담동 맥도날드 옆(위치)202006728700
대여소 그룹대여소 명일자 / 월대여 건수반납 건수
2052중랑구1467.sk신내 주유소앞(용마산로)2020061919
2053중랑구1468.먹골역 7번 출구202006452414
2054중랑구1469.먹골역 4번출구20200696
2055중랑구1470.중화동 우리은행 앞202006154159
2056중랑구1472.영성빌딩(PAT)202006221241
2057중랑구1473.중랑역 1번 출구(중화문화복지센터)2020068583
2058중랑구1477.면목삼익아파트 앞2020068582
2059중랑구1478.홈플러스 상봉점 앞202006322329
2060중랑구1479.면목 홈플러스 2202006150166
2061중랑구1480. 용마지구대 옆202006235243