Overview

Dataset statistics

Number of variables4
Number of observations2632
Missing cells5
Missing cells (%)< 0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory82.4 KiB
Average record size in memory32.1 B

Variable types

Categorical2
Text2

Dataset

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

Alerts

대여소별 대여내역 is highly overall correlated with Unnamed: 1High correlation
Unnamed: 1 is highly overall correlated with 대여소별 대여내역High correlation

Reproduction

Analysis started2024-03-13 09:54:26.441334
Analysis finished2024-03-13 09:54:27.056438
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대여소별 대여내역
Categorical

HIGH CORRELATION 

Distinct30
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
송파구
209 
강서구
182 
강남구
 
154
영등포구
 
144
서초구
 
141
Other values (25)
1802 

Length

Max length7
Median length3
Mean length3.0851064
Min length2

Unique

Unique5 ?
Unique (%)0.2%

Sample

1st row<NA>
2nd row구분
3rd row조회구분
4th row총 2627건
5th row대여소 그룹

Common Values

ValueCountFrequency (%)
송파구 209
 
7.9%
강서구 182
 
6.9%
강남구 154
 
5.9%
영등포구 144
 
5.5%
서초구 141
 
5.4%
노원구 126
 
4.8%
마포구 122
 
4.6%
강동구 119
 
4.5%
양천구 107
 
4.1%
종로구 105
 
4.0%
Other values (20) 1223
46.5%

Length

2024-03-13T18:54:27.129255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
송파구 209
 
7.9%
강서구 182
 
6.9%
강남구 154
 
5.8%
영등포구 144
 
5.5%
서초구 141
 
5.4%
노원구 126
 
4.8%
마포구 122
 
4.6%
강동구 119
 
4.5%
양천구 107
 
4.1%
종로구 105
 
4.0%
Other values (22) 1225
46.5%

Unnamed: 1
Categorical

HIGH CORRELATION 

Distinct39
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size20.7 KiB
상암1팀
 
152
학여울2팀
 
126
천호1팀
 
124
천호2팀
 
115
학여울1팀
 
98
Other values (34)
2017 

Length

Max length6
Median length4
Mean length4.2705167
Min length1

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row<NA>
2nd row월
3rd row대여소별
4th row<NA>
5th row팀명

Common Values

ValueCountFrequency (%)
상암1팀 152
 
5.8%
학여울2팀 126
 
4.8%
천호1팀 124
 
4.7%
천호2팀 115
 
4.4%
학여울1팀 98
 
3.7%
중랑3팀 94
 
3.6%
영남3팀 90
 
3.4%
중랑2팀 88
 
3.3%
이수3팀 86
 
3.3%
중랑1팀 85
 
3.2%
Other values (29) 1574
59.8%

Length

2024-03-13T18:54:27.255815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
상암1팀 152
 
5.7%
학여울2팀 126
 
4.7%
천호1팀 124
 
4.6%
천호2팀 115
 
4.3%
학여울1팀 98
 
3.6%
중랑3팀 94
 
3.5%
영남3팀 90
 
3.4%
중랑2팀 88
 
3.3%
이수3팀 86
 
3.2%
중랑1팀 85
 
3.2%
Other values (30) 1627
60.6%

Unnamed: 2
Text

Distinct2630
Distinct (%)100.0%
Missing2
Missing (%)0.1%
Memory size20.7 KiB
2024-03-13T18:54:27.535057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length32
Mean length15.575665
Min length3

Characters and Unicode

Total characters40964
Distinct characters592
Distinct categories13 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique2630 ?
Unique (%)100.0%

Sample

1st row일/월
2nd row대여소
3rd row대여소 명
4th row2391. 구룡터널 입구(개포1단지아파트)
5th row5082. 가양역 7번출구
ValueCountFrequency (%)
앞 696
 
9.1%
출구 104
 
1.4%
옆 102
 
1.3%
입구 70
 
0.9%
교차로 62
 
0.8%
1번출구 62
 
0.8%
사거리 58
 
0.8%
2번출구 48
 
0.6%
3번출구 45
 
0.6%
뒤 43
 
0.6%
Other values (5246) 6371
83.2%
2024-03-13T18:54:27.972652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5031
 
12.3%
. 2637
 
6.4%
1 1971
 
4.8%
2 1604
 
3.9%
3 1322
 
3.2%
4 1295
 
3.2%
5 971
 
2.4%
0 938
 
2.3%
6 907
 
2.2%
앞 823
 
2.0%
Other values (582) 23465
57.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 21154
51.6%
Decimal Number 11245
27.5%
Space Separator 5031
 
12.3%
Other Punctuation 2670
 
6.5%
Uppercase Letter 339
 
0.8%
Close Punctuation 226
 
0.6%
Open Punctuation 226
 
0.6%
Lowercase Letter 46
 
0.1%
Dash Punctuation 18
 
< 0.1%
Math Symbol 4
 
< 0.1%
Other values (3) 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
앞 823
 
3.9%
구 799
 
3.8%
역 585
 
2.8%
동 583
 
2.8%
번 508
 
2.4%
출 496
 
2.3%
교 440
 
2.1%
파 387
 
1.8%
아 371
 
1.8%
리 350
 
1.7%
Other values (517) 15812
74.7%
Uppercase Letter
ValueCountFrequency (%)
K 41
12.1%
S 40
11.8%
T 33
9.7%
C 31
 
9.1%
A 24
 
7.1%
D 21
 
6.2%
G 20
 
5.9%
M 17
 
5.0%
P 17
 
5.0%
B 17
 
5.0%
Other values (13) 78
23.0%
Lowercase Letter
ValueCountFrequency (%)
e 15
32.6%
k 7
15.2%
s 7
15.2%
t 3
 
6.5%
n 2
 
4.3%
l 2
 
4.3%
v 1
 
2.2%
y 1
 
2.2%
m 1
 
2.2%
o 1
 
2.2%
Other values (6) 6
 
13.0%
Decimal Number
ValueCountFrequency (%)
1 1971
17.5%
2 1604
14.3%
3 1322
11.8%
4 1295
11.5%
5 971
8.6%
0 938
8.3%
6 907
8.1%
7 821
7.3%
8 767
 
6.8%
9 649
 
5.8%
Other Punctuation
ValueCountFrequency (%)
. 2637
98.8%
, 17
 
0.6%
& 8
 
0.3%
· 4
 
0.1%
? 3
 
0.1%
/ 1
 
< 0.1%
Math Symbol
ValueCountFrequency (%)
~ 3
75.0%
+ 1
 
25.0%
Other Number
ValueCountFrequency (%)
① 1
50.0%
② 1
50.0%
Space Separator
ValueCountFrequency (%)
5031
100.0%
Close Punctuation
ValueCountFrequency (%)
) 226
100.0%
Open Punctuation
ValueCountFrequency (%)
( 226
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 21155
51.6%
Common 19424
47.4%
Latin 385
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
앞 823
 
3.9%
구 799
 
3.8%
역 585
 
2.8%
동 583
 
2.8%
번 508
 
2.4%
출 496
 
2.3%
교 440
 
2.1%
파 387
 
1.8%
아 371
 
1.8%
리 350
 
1.7%
Other values (518) 15813
74.7%
Latin
ValueCountFrequency (%)
K 41
 
10.6%
S 40
 
10.4%
T 33
 
8.6%
C 31
 
8.1%
A 24
 
6.2%
D 21
 
5.5%
G 20
 
5.2%
M 17
 
4.4%
P 17
 
4.4%
B 17
 
4.4%
Other values (29) 124
32.2%
Common
ValueCountFrequency (%)
5031
25.9%
. 2637
13.6%
1 1971
 
10.1%
2 1604
 
8.3%
3 1322
 
6.8%
4 1295
 
6.7%
5 971
 
5.0%
0 938
 
4.8%
6 907
 
4.7%
7 821
 
4.2%
Other values (15) 1927
 
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 21154
51.6%
ASCII 19803
48.3%
None 5
 
< 0.1%
Enclosed Alphanum 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5031
25.4%
. 2637
13.3%
1 1971
 
10.0%
2 1604
 
8.1%
3 1322
 
6.7%
4 1295
 
6.5%
5 971
 
4.9%
0 938
 
4.7%
6 907
 
4.6%
7 821
 
4.1%
Other values (51) 2306
11.6%
Hangul
ValueCountFrequency (%)
앞 823
 
3.9%
구 799
 
3.8%
역 585
 
2.8%
동 583
 
2.8%
번 508
 
2.4%
출 496
 
2.3%
교 440
 
2.1%
파 387
 
1.8%
아 371
 
1.8%
리 350
 
1.7%
Other values (517) 15812
74.7%
None
ValueCountFrequency (%)
· 4
80.0%
㈜ 1
 
20.0%
Enclosed Alphanum
ValueCountFrequency (%)
① 1
50.0%
② 1
50.0%

Unnamed: 3
Text

Distinct1855
Distinct (%)70.6%
Missing3
Missing (%)0.1%
Memory size20.7 KiB
2024-03-13T18:54:28.296037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length4
Mean length3.5971852
Min length1

Characters and Unicode

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

Unique

Unique1285 ?
Unique (%)48.9%

Sample

1st row202206 ~ 202206
2nd row대여 건수
3rd row4
4th row5
5th row24
ValueCountFrequency (%)
1095 6
 
0.2%
973 6
 
0.2%
1125 6
 
0.2%
1317 5
 
0.2%
287 5
 
0.2%
590 5
 
0.2%
715 5
 
0.2%
383 5
 
0.2%
806 5
 
0.2%
634 5
 
0.2%
Other values (1847) 2579
98.0%
2024-03-13T18:54:28.731116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 1634
17.3%
2 1278
13.5%
3 970
10.3%
5 876
9.3%
4 861
9.1%
6 815
8.6%
7 784
8.3%
9 748
7.9%
0 747
7.9%
8 736
7.8%
Other values (6) 8
 
0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 9449
99.9%
Other Letter 4
 
< 0.1%
Space Separator 3
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 1634
17.3%
2 1278
13.5%
3 970
10.3%
5 876
9.3%
4 861
9.1%
6 815
8.6%
7 784
8.3%
9 748
7.9%
0 747
7.9%
8 736
7.8%
Other Letter
ValueCountFrequency (%)
대 1
25.0%
여 1
25.0%
건 1
25.0%
수 1
25.0%
Space Separator
ValueCountFrequency (%)
3
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9453
> 99.9%
Hangul 4
 
< 0.1%

Most frequent character per script

Common
ValueCountFrequency (%)
1 1634
17.3%
2 1278
13.5%
3 970
10.3%
5 876
9.3%
4 861
9.1%
6 815
8.6%
7 784
8.3%
9 748
7.9%
0 747
7.9%
8 736
7.8%
Other values (2) 4
 
< 0.1%
Hangul
ValueCountFrequency (%)
대 1
25.0%
여 1
25.0%
건 1
25.0%
수 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 9453
> 99.9%
Hangul 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 1634
17.3%
2 1278
13.5%
3 970
10.3%
5 876
9.3%
4 861
9.1%
6 815
8.6%
7 784
8.3%
9 748
7.9%
0 747
7.9%
8 736
7.8%
Other values (2) 4
 
< 0.1%
Hangul
ValueCountFrequency (%)
대 1
25.0%
여 1
25.0%
건 1
25.0%
수 1
25.0%

Correlations

2024-03-13T18:54:28.818420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대여소별 대여내역Unnamed: 1
대여소별 대여내역1.0000.996
Unnamed: 10.9961.000
2024-03-13T18:54:28.893408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대여소별 대여내역Unnamed: 1
대여소별 대여내역1.0000.905
Unnamed: 10.9051.000
2024-03-13T18:54:28.978301image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
대여소별 대여내역Unnamed: 1
대여소별 대여내역1.0000.905
Unnamed: 10.9051.000

Missing values

2024-03-13T18:54:26.831885image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T18:54:26.907658image/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-03-13T18:54:26.991360image/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

대여소별 대여내역Unnamed: 1Unnamed: 2Unnamed: 3
0<NA><NA><NA><NA>
1구분월일/월202206 ~ 202206
2조회구분대여소별대여소<NA>
3총 2627건<NA><NA><NA>
4대여소 그룹팀명대여소 명대여 건수
5강남구학여울1팀2391. 구룡터널 입구(개포1단지아파트)4
6강서구개화3팀5082. 가양역 7번출구5
7종로구세종로1팀4719. 종로문화원 건너편24
8성동구중랑2팀3527. 왕십리 자이아파트25
9서초구이수1팀4314. 탑성마을 버스정거장 옆29
대여소별 대여내역Unnamed: 1Unnamed: 2Unnamed: 3
2622강서구개화1팀1153. 발산역 1번, 9번 인근 대여소9456
2623강서구개화1팀2701. 마곡나루역 5번출구 뒤편9721
2624관악구영남2팀2177. 신대방역 2번 출구10009
2625구로구천왕2팀1911. 구로디지털단지역 앞10373
2626송파구천호2팀1210. 롯데월드타워(잠실역2번출구 쪽)11780
2627영등포구영남3팀207. 여의나루역 1번출구 앞13595
2628관악구영남2팀2102. 봉림교 교통섬13722
2629광진구중랑1팀502. 뚝섬유원지역 1번출구 앞14125
2630마포구상암1팀4217. 한강공원 망원나들목15417
2631강서구개화1팀2715.마곡나루역 2번 출구16498