Overview

Dataset statistics

Number of variables12
Number of observations261
Missing cells2458
Missing cells (%)78.5%
Duplicate rows5
Duplicate rows (%)1.9%
Total size in memory24.6 KiB
Average record size in memory96.5 B

Variable types

Text4
Unsupported8

Dataset

Description마포구 관내 거주자우선주차 배정, 신청방법, 요금, 방문주차 방법, 환불 등
Author마포구시설관리공단
URLhttps://www.data.go.kr/data/15003709/fileData.do

Alerts

Dataset has 5 (1.9%) duplicate rowsDuplicates
마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보 has 249 (95.4%) missing valuesMissing
Unnamed: 1 has 70 (26.8%) missing valuesMissing
Unnamed: 2 has 183 (70.1%) missing valuesMissing
Unnamed: 3 has 198 (75.9%) missing valuesMissing
Unnamed: 4 has 203 (77.8%) missing valuesMissing
Unnamed: 5 has 205 (78.5%) missing valuesMissing
Unnamed: 6 has 204 (78.2%) missing valuesMissing
Unnamed: 7 has 216 (82.8%) missing valuesMissing
Unnamed: 8 has 218 (83.5%) missing valuesMissing
Unnamed: 9 has 230 (88.1%) missing valuesMissing
Unnamed: 10 has 239 (91.6%) missing valuesMissing
Unnamed: 11 has 243 (93.1%) missing valuesMissing
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 03:05:15.843746
Analysis finished2023-12-12 03:05:16.688301
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보
Text

MISSING 

Distinct11
Distinct (%)91.7%
Missing249
Missing (%)95.4%
Memory size2.2 KiB
2023-12-12T12:05:16.801995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length1
Mean length3.3333333
Min length1

Characters and Unicode

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

Unique

Unique10 ?
Unique (%)83.3%

Sample

1st row노
2nd row상
3rd row노
4th row외
5th row시
ValueCountFrequency (%)
노 2
 
11.1%
선 1
 
5.6%
대한 1
 
5.6%
운영방법에 1
 
5.6%
및 1
 
5.6%
배정 1
 
5.6%
거주자우선주차제 1
 
5.6%
마포구 1
 
5.6%
우 1
 
5.6%
상 1
 
5.6%
Other values (7) 7
38.9%
2023-12-12T12:05:17.090735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6
 
15.0%
주 3
 
7.5%
정 2
 
5.0%
선 2
 
5.0%
우 2
 
5.0%
자 2
 
5.0%
노 2
 
5.0%
거 2
 
5.0%
설 1
 
2.5%
한 1
 
2.5%
Other values (17) 17
42.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 34
85.0%
Space Separator 6
 
15.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 3
 
8.8%
정 2
 
5.9%
선 2
 
5.9%
우 2
 
5.9%
자 2
 
5.9%
노 2
 
5.9%
거 2
 
5.9%
설 1
 
2.9%
한 1
 
2.9%
대 1
 
2.9%
Other values (16) 16
47.1%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 34
85.0%
Common 6
 
15.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 3
 
8.8%
정 2
 
5.9%
선 2
 
5.9%
우 2
 
5.9%
자 2
 
5.9%
노 2
 
5.9%
거 2
 
5.9%
설 1
 
2.9%
한 1
 
2.9%
대 1
 
2.9%
Other values (16) 16
47.1%
Common
ValueCountFrequency (%)
6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 34
85.0%
ASCII 6
 
15.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6
100.0%
Hangul
ValueCountFrequency (%)
주 3
 
8.8%
정 2
 
5.9%
선 2
 
5.9%
우 2
 
5.9%
자 2
 
5.9%
노 2
 
5.9%
거 2
 
5.9%
설 1
 
2.9%
한 1
 
2.9%
대 1
 
2.9%
Other values (16) 16
47.1%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing70
Missing (%)26.8%
Memory size2.2 KiB

Unnamed: 2
Text

MISSING 

Distinct70
Distinct (%)89.7%
Missing183
Missing (%)70.1%
Memory size2.2 KiB
2023-12-12T12:05:17.395190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length31
Mean length8.3717949
Min length2

Characters and Unicode

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

Unique

Unique65 ?
Unique (%)83.3%

Sample

1st row주차장명
2nd row망 원
3rd row경 남
4th row연 남
5th row청기와
ValueCountFrequency (%)
거리 6
 
3.8%
차량 5
 
3.2%
5
 
3.2%
점수 4
 
2.6%
이상 4
 
2.6%
기준 4
 
2.6%
전입일 3
 
1.9%
주차장명 3
 
1.9%
등록된 3
 
1.9%
주차구획과의 2
 
1.3%
Other values (110) 117
75.0%
2023-12-12T12:05:17.885022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
78
 
11.9%
( 20
 
3.1%
) 20
 
3.1%
자 19
 
2.9%
차 17
 
2.6%
1 16
 
2.5%
0 14
 
2.1%
동 13
 
2.0%
주 13
 
2.0%
장 13
 
2.0%
Other values (147) 430
65.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 453
69.4%
Space Separator 78
 
11.9%
Decimal Number 50
 
7.7%
Open Punctuation 20
 
3.1%
Close Punctuation 20
 
3.1%
Dash Punctuation 10
 
1.5%
Other Punctuation 8
 
1.2%
Math Symbol 6
 
0.9%
Lowercase Letter 6
 
0.9%
Other Number 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
자 19
 
4.2%
차 17
 
3.8%
동 13
 
2.9%
주 13
 
2.9%
장 13
 
2.9%
거 12
 
2.6%
기 11
 
2.4%
시 11
 
2.4%
수 10
 
2.2%
점 9
 
2.0%
Other values (128) 325
71.7%
Decimal Number
ValueCountFrequency (%)
1 16
32.0%
0 14
28.0%
2 6
 
12.0%
6 4
 
8.0%
5 3
 
6.0%
4 3
 
6.0%
3 2
 
4.0%
9 2
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 5
62.5%
: 2
 
25.0%
/ 1
 
12.5%
Other Number
ValueCountFrequency (%)
② 1
50.0%
① 1
50.0%
Space Separator
ValueCountFrequency (%)
78
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%
Math Symbol
ValueCountFrequency (%)
~ 6
100.0%
Lowercase Letter
ValueCountFrequency (%)
c 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 453
69.4%
Common 194
29.7%
Latin 6
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
자 19
 
4.2%
차 17
 
3.8%
동 13
 
2.9%
주 13
 
2.9%
장 13
 
2.9%
거 12
 
2.6%
기 11
 
2.4%
시 11
 
2.4%
수 10
 
2.2%
점 9
 
2.0%
Other values (128) 325
71.7%
Common
ValueCountFrequency (%)
78
40.2%
( 20
 
10.3%
) 20
 
10.3%
1 16
 
8.2%
0 14
 
7.2%
- 10
 
5.2%
~ 6
 
3.1%
2 6
 
3.1%
, 5
 
2.6%
6 4
 
2.1%
Other values (8) 15
 
7.7%
Latin
ValueCountFrequency (%)
c 6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 453
69.4%
ASCII 198
30.3%
Enclosed Alphanum 2
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
78
39.4%
( 20
 
10.1%
) 20
 
10.1%
1 16
 
8.1%
0 14
 
7.1%
- 10
 
5.1%
~ 6
 
3.0%
2 6
 
3.0%
c 6
 
3.0%
, 5
 
2.5%
Other values (7) 17
 
8.6%
Hangul
ValueCountFrequency (%)
자 19
 
4.2%
차 17
 
3.8%
동 13
 
2.9%
주 13
 
2.9%
장 13
 
2.9%
거 12
 
2.6%
기 11
 
2.4%
시 11
 
2.4%
수 10
 
2.2%
점 9
 
2.0%
Other values (128) 325
71.7%
Enclosed Alphanum
ValueCountFrequency (%)
② 1
50.0%
① 1
50.0%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing198
Missing (%)75.9%
Memory size2.2 KiB

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing203
Missing (%)77.8%
Memory size2.2 KiB

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing205
Missing (%)78.5%
Memory size2.2 KiB

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing204
Missing (%)78.2%
Memory size2.2 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing216
Missing (%)82.8%
Memory size2.2 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing218
Missing (%)83.5%
Memory size2.2 KiB

Unnamed: 9
Text

MISSING 

Distinct16
Distinct (%)51.6%
Missing230
Missing (%)88.1%
Memory size2.2 KiB
2023-12-12T12:05:18.048046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length2.8064516
Min length1

Characters and Unicode

Total characters87
Distinct characters26
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique8 ?
Unique (%)25.8%

Sample

1st row정기권(원/월)
2nd row10만
3rd row15만
4th row15만
5th row12만
ValueCountFrequency (%)
8
25.8%
12만 3
 
9.7%
5만 3
 
9.7%
정기권(원/월 2
 
6.5%
20점 2
 
6.5%
15만 2
 
6.5%
10년 2
 
6.5%
이상 2
 
6.5%
12ㆍ24만 1
 
3.2%
3만6천 1
 
3.2%
Other values (5) 5
16.1%
2023-12-12T12:05:18.380065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
만 14
16.1%
1 11
12.6%
- 8
 
9.2%
2 8
 
9.2%
0 5
 
5.7%
5 5
 
5.7%
3 3
 
3.4%
천 2
 
2.3%
6 2
 
2.3%
상 2
 
2.3%
Other values (16) 27
31.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 37
42.5%
Decimal Number 35
40.2%
Dash Punctuation 8
 
9.2%
Close Punctuation 2
 
2.3%
Other Punctuation 2
 
2.3%
Open Punctuation 2
 
2.3%
Space Separator 1
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
만 14
37.8%
천 2
 
5.4%
상 2
 
5.4%
이 2
 
5.4%
년 2
 
5.4%
점 2
 
5.4%
월 2
 
5.4%
원 2
 
5.4%
권 2
 
5.4%
기 2
 
5.4%
Other values (4) 5
 
13.5%
Decimal Number
ValueCountFrequency (%)
1 11
31.4%
2 8
22.9%
0 5
14.3%
5 5
14.3%
3 3
 
8.6%
6 2
 
5.7%
4 1
 
2.9%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 50
57.5%
Hangul 37
42.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
만 14
37.8%
천 2
 
5.4%
상 2
 
5.4%
이 2
 
5.4%
년 2
 
5.4%
점 2
 
5.4%
월 2
 
5.4%
원 2
 
5.4%
권 2
 
5.4%
기 2
 
5.4%
Other values (4) 5
 
13.5%
Common
ValueCountFrequency (%)
1 11
22.0%
- 8
16.0%
2 8
16.0%
0 5
10.0%
5 5
10.0%
3 3
 
6.0%
6 2
 
4.0%
) 2
 
4.0%
/ 2
 
4.0%
( 2
 
4.0%
Other values (2) 2
 
4.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 50
57.5%
Hangul 36
41.4%
Compat Jamo 1
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
만 14
38.9%
천 2
 
5.6%
상 2
 
5.6%
이 2
 
5.6%
년 2
 
5.6%
점 2
 
5.6%
월 2
 
5.6%
원 2
 
5.6%
권 2
 
5.6%
기 2
 
5.6%
Other values (3) 4
 
11.1%
ASCII
ValueCountFrequency (%)
1 11
22.0%
- 8
16.0%
2 8
16.0%
0 5
10.0%
5 5
10.0%
3 3
 
6.0%
6 2
 
4.0%
) 2
 
4.0%
/ 2
 
4.0%
( 2
 
4.0%
Other values (2) 2
 
4.0%
Compat Jamo
ValueCountFrequency (%)
ㆍ 1
100.0%

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing239
Missing (%)91.6%
Memory size2.2 KiB

Unnamed: 11
Text

MISSING 

Distinct11
Distinct (%)61.1%
Missing243
Missing (%)93.1%
Memory size2.2 KiB
2023-12-12T12:05:18.568612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6.5
Mean length4.7777778
Min length2

Characters and Unicode

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

Unique

Unique8 ?
Unique (%)44.4%

Sample

1st row확인방법
2nd row주민등록
3rd row참조
4th row거주자
5th row프로그램 적용
ValueCountFrequency (%)
참조 7
29.2%
자동차등록증 3
12.5%
주민등록 3
12.5%
확인방법 1
 
4.2%
거주자 1
 
4.2%
프로그램 1
 
4.2%
적용 1
 
4.2%
입증 1
 
4.2%
서류 1
 
4.2%
첨부 1
 
4.2%
Other values (4) 4
16.7%
2023-12-12T12:05:18.975282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
참 7
 
8.1%
조 7
 
8.1%
등 7
 
8.1%
록 7
 
8.1%
증 6
 
7.0%
6
 
7.0%
자 5
 
5.8%
주 4
 
4.7%
동 3
 
3.5%
차 3
 
3.5%
Other values (28) 31
36.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80
93.0%
Space Separator 6
 
7.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
참 7
 
8.8%
조 7
 
8.8%
등 7
 
8.8%
록 7
 
8.8%
증 6
 
7.5%
자 5
 
6.2%
주 4
 
5.0%
동 3
 
3.8%
차 3
 
3.8%
민 3
 
3.8%
Other values (27) 28
35.0%
Space Separator
ValueCountFrequency (%)
6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80
93.0%
Common 6
 
7.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
참 7
 
8.8%
조 7
 
8.8%
등 7
 
8.8%
록 7
 
8.8%
증 6
 
7.5%
자 5
 
6.2%
주 4
 
5.0%
동 3
 
3.8%
차 3
 
3.8%
민 3
 
3.8%
Other values (27) 28
35.0%
Common
ValueCountFrequency (%)
6
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80
93.0%
ASCII 6
 
7.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
참 7
 
8.8%
조 7
 
8.8%
등 7
 
8.8%
록 7
 
8.8%
증 6
 
7.5%
자 5
 
6.2%
주 4
 
5.0%
동 3
 
3.8%
차 3
 
3.8%
민 3
 
3.8%
Other values (27) 28
35.0%
ASCII
ValueCountFrequency (%)
6
100.0%

Correlations

2023-12-12T12:05:19.068981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보Unnamed: 2Unnamed: 9Unnamed: 11
마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보1.0001.0001.000NaN
Unnamed: 21.0001.0001.0000.917
Unnamed: 91.0001.0001.0000.000
Unnamed: 11NaN0.9170.0001.000

Missing values

2023-12-12T12:05:16.136158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:05:16.340605image/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.
2023-12-12T12:05:16.514546image/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: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11
0<NA>NaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
1노연번주차장명위치유료 운영시간유료운영일면수급지요금(원/5분)정기권(원/월)NaN<NA>
2상1망 원희우정로 10길 14 일대09:00~19:00평일92315010만NaN<NA>
3<NA>2경 남월드컵북로 1길 6 일대11:00~21:00평일,토요일22225015만NaN<NA>
4<NA>3연 남동교로 276 일대09:00~19:00평일,토요일74225015만NaN<NA>
5<NA>4청기와잔다리로 276 일대09:00~19:00평일86225012만NaN<NA>
6<NA>5당 인독막로 42 일대09:00~19:00평일47225012만NaN<NA>
7<NA>6합 정양화로 6길 13 일대12:00~23:00평일,토·일요일232300-NaN<NA>
8<NA>7홍대서측양화로 6길 33 일대12:00~23:00평일,토·일요일1722300-NaN<NA>
9<NA>8어울마당홍익로 19 일대12:00~23:00평일112300-NaN<NA>
마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11
251<NA>신청자 계좌입금(공단접수일 기준 7일이내 단,공휴일 미산입)<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
252<NA>NaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
253<NA>구비서류<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
254<NA>환불신청서(공단사무실, 공단홈페이지에서 출력 다운로드)<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
255<NA>주차권(내방불가시 주차권 미반납사유서 작성 첨부 제출)<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
256<NA>통장사본(배정받은 차량의 본인명의 입출금통장)<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
257<NA>NaN<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
258<NA>문의<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
259<NA>주차사업팀 - Tel:02-300-5042~45, Fax:02-376-4068<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>
260<NA>※ 신청서 팩스 송부 시 반드시 확인전화를 하셔서 접수 확인을 받으시길 바랍니다.<NA>NaNNaNNaNNaNNaNNaN<NA>NaN<NA>

Duplicate rows

Most frequently occurring

마포구 공영주차장 주차요금/정기권주차요금/운영시간/주차장위치 정보Unnamed: 2Unnamed: 9Unnamed: 11# duplicates
4<NA><NA><NA><NA>178
0노주차장명정기권(원/월)<NA>2
1<NA>비거주자<NA><NA>2
2<NA>점수20점<NA>2
3<NA>점수<NA><NA>2