Overview

Dataset statistics

Number of variables10
Number of observations67
Missing cells66
Missing cells (%)9.9%
Duplicate rows1
Duplicate rows (%)1.5%
Total size in memory5.4 KiB
Average record size in memory82.0 B

Variable types

Unsupported3
Categorical4
Text3

Dataset

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

Alerts

Unnamed: 9 has constant value ""Constant
Dataset has 1 (1.5%) duplicate rowsDuplicates
Unnamed: 1 is highly overall correlated with Unnamed: 2 and 2 other fieldsHigh correlation
Unnamed: 2 is highly overall correlated with Unnamed: 1 and 1 other fieldsHigh correlation
Unnamed: 5 is highly overall correlated with Unnamed: 1 and 1 other fieldsHigh correlation
Unnamed: 6 is highly overall correlated with Unnamed: 1High correlation
Unnamed: 6 is highly imbalanced (77.3%)Imbalance
Unnamed: 9 has 66 (98.5%) missing valuesMissing
서울시 주말농장 현황(공영텃밭) 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: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 06:36:09.165580
Analysis finished2023-12-11 06:36:09.880225
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

서울시 주말농장 현황(공영텃밭)
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size668.0 B

Unnamed: 1
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
서울특별시
49 
경기도
17 
광역시도
 
1

Length

Max length5
Median length5
Mean length4.4776119
Min length3

Unique

Unique1 ?
Unique (%)1.5%

Sample

1st row광역시도
2nd row경기도
3rd row경기도
4th row경기도
5th row경기도

Common Values

ValueCountFrequency (%)
서울특별시 49
73.1%
경기도 17
 
25.4%
광역시도 1
 
1.5%

Length

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

Common Values (Plot)

2023-12-11T15:36:10.097771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 49
73.1%
경기도 17
 
25.4%
광역시도 1
 
1.5%

Unnamed: 2
Categorical

HIGH CORRELATION 

Distinct25
Distinct (%)37.3%
Missing0
Missing (%)0.0%
Memory size668.0 B
강동구
8 
구로구
7 
관악구
6 
광주시
5 
도봉구
4 
Other values (20)
37 

Length

Max length7
Median length3
Mean length3.1044776
Min length3

Unique

Unique12 ?
Unique (%)17.9%

Sample

1st row시군구
2nd row남양주시
3rd row남양주시
4th row양평군
5th row양평군

Common Values

ValueCountFrequency (%)
강동구 8
11.9%
구로구 7
 
10.4%
관악구 6
 
9.0%
광주시 5
 
7.5%
도봉구 4
 
6.0%
양평군 4
 
6.0%
양천구 4
 
6.0%
서초구 4
 
6.0%
광진구 3
 
4.5%
중랑구 3
 
4.5%
Other values (15) 19
28.4%

Length

2023-12-11T15:36:10.253152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
강동구 8
11.8%
구로구 7
 
10.3%
관악구 6
 
8.8%
광주시 5
 
7.4%
도봉구 4
 
5.9%
양평군 4
 
5.9%
양천구 4
 
5.9%
서초구 4
 
5.9%
고양시 4
 
5.9%
광진구 3
 
4.4%
Other values (15) 19
27.9%

Unnamed: 3
Text

Distinct47
Distinct (%)70.1%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-11T15:36:10.542000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length3
Mean length3.8059701
Min length2

Characters and Unicode

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

Unique

Unique35 ?
Unique (%)52.2%

Sample

1st row읍면동
2nd row조안면 송촌리
3rd row조안면 삼봉리
4th row양서면 부용리
5th row양서면 부용리
ValueCountFrequency (%)
궁동 7
 
8.6%
부용리 3
 
3.7%
내곡동 3
 
3.7%
신월동 3
 
3.7%
덕양구 3
 
3.7%
양서면 3
 
3.7%
창동 2
 
2.5%
남종면 2
 
2.5%
상일동 2
 
2.5%
낙성대동 2
 
2.5%
Other values (44) 51
63.0%
2023-12-11T15:36:10.990984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 56
22.0%
15
 
5.9%
면 11
 
4.3%
리 11
 
4.3%
궁 7
 
2.7%
성 7
 
2.7%
양 6
 
2.4%
서 6
 
2.4%
신 6
 
2.4%
곡 5
 
2.0%
Other values (65) 125
49.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 239
93.7%
Space Separator 15
 
5.9%
Decimal Number 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 56
23.4%
면 11
 
4.6%
리 11
 
4.6%
궁 7
 
2.9%
성 7
 
2.9%
양 6
 
2.5%
서 6
 
2.5%
신 6
 
2.5%
곡 5
 
2.1%
월 5
 
2.1%
Other values (63) 119
49.8%
Space Separator
ValueCountFrequency (%)
15
100.0%
Decimal Number
ValueCountFrequency (%)
3 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 239
93.7%
Common 16
 
6.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 56
23.4%
면 11
 
4.6%
리 11
 
4.6%
궁 7
 
2.9%
성 7
 
2.9%
양 6
 
2.5%
서 6
 
2.5%
신 6
 
2.5%
곡 5
 
2.1%
월 5
 
2.1%
Other values (63) 119
49.8%
Common
ValueCountFrequency (%)
15
93.8%
3 1
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 239
93.7%
ASCII 16
 
6.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 56
23.4%
면 11
 
4.6%
리 11
 
4.6%
궁 7
 
2.9%
성 7
 
2.9%
양 6
 
2.5%
서 6
 
2.5%
신 6
 
2.5%
곡 5
 
2.1%
월 5
 
2.1%
Other values (63) 119
49.8%
ASCII
ValueCountFrequency (%)
15
93.8%
3 1
 
6.2%

Unnamed: 4
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size668.0 B

Unnamed: 5
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)31.3%
Missing0
Missing (%)0.0%
Memory size668.0 B
서울시
15 
강동구
8 
구로구
7 
관악구
6 
양천구
4 
Other values (16)
27 

Length

Max length12
Median length3
Mean length3.3731343
Min length3

Unique

Unique10 ?
Unique (%)14.9%

Sample

1st row운영주체
2nd row서울시
3rd row서울시
4th row서울시
5th row서울시

Common Values

ValueCountFrequency (%)
서울시 15
22.4%
강동구 8
11.9%
구로구 7
10.4%
관악구 6
 
9.0%
양천구 4
 
6.0%
도봉구 4
 
6.0%
서초구 4
 
6.0%
광진구 3
 
4.5%
금천구 2
 
3.0%
중랑구 2
 
3.0%
Other values (11) 12
17.9%

Length

2023-12-11T15:36:11.139400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
서울시 15
21.1%
강동구 8
11.3%
구로구 7
9.9%
관악구 6
 
8.5%
양천구 4
 
5.6%
도봉구 4
 
5.6%
서초구 4
 
5.6%
광진구 3
 
4.2%
마포구 2
 
2.8%
금천구 2
 
2.8%
Other values (15) 16
22.5%

Unnamed: 6
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
공영주말농장
62 
공영주말농장(테마)
 
2
텃밭 운영방식
 
1
공영주말농장(체험, 교육, 기부용)
 
1
교육 및 체험텃밭
 
1

Length

Max length19
Median length6
Mean length6.3731343
Min length6

Unique

Unique3 ?
Unique (%)4.5%

Sample

1st row텃밭 운영방식
2nd row공영주말농장
3rd row공영주말농장
4th row공영주말농장
5th row공영주말농장

Common Values

ValueCountFrequency (%)
공영주말농장 62
92.5%
공영주말농장(테마) 2
 
3.0%
텃밭 운영방식 1
 
1.5%
공영주말농장(체험, 교육, 기부용) 1
 
1.5%
교육 및 체험텃밭 1
 
1.5%

Length

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

Common Values (Plot)

2023-12-11T15:36:11.428223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공영주말농장 62
86.1%
공영주말농장(테마 2
 
2.8%
교육 2
 
2.8%
텃밭 1
 
1.4%
운영방식 1
 
1.4%
공영주말농장(체험 1
 
1.4%
기부용 1
 
1.4%
및 1
 
1.4%
체험텃밭 1
 
1.4%

Unnamed: 7
Text

Distinct66
Distinct (%)98.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-11T15:36:11.725063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length13
Mean length6.4626866
Min length3

Characters and Unicode

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

Unique

Unique65 ?
Unique (%)97.0%

Sample

1st row텃밭명
2nd row송촌약수터농장
3rd row삼봉리농장
4th row교동농장
5th row부용리농장
ValueCountFrequency (%)
나눔텃밭 3
 
3.6%
궁동3구역 2
 
2.4%
한마음 1
 
1.2%
신흥텃밭 1
 
1.2%
송촌약수터농장 1
 
1.2%
안골텃밭 1
 
1.2%
청룡텃밭 1
 
1.2%
삼각교육텃밭 1
 
1.2%
상암두레텃밭 1
 
1.2%
체험농장 1
 
1.2%
Other values (71) 71
84.5%
2023-12-11T15:36:12.176224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
텃 34
 
7.9%
밭 34
 
7.9%
농 24
 
5.5%
장 23
 
5.3%
동 19
 
4.4%
14
 
3.2%
공 9
 
2.1%
역 9
 
2.1%
리 9
 
2.1%
도 8
 
1.8%
Other values (118) 250
57.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 395
91.2%
Decimal Number 15
 
3.5%
Space Separator 14
 
3.2%
Control 3
 
0.7%
Open Punctuation 3
 
0.7%
Close Punctuation 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
텃 34
 
8.6%
밭 34
 
8.6%
농 24
 
6.1%
장 23
 
5.8%
동 19
 
4.8%
공 9
 
2.3%
역 9
 
2.3%
리 9
 
2.3%
도 8
 
2.0%
원 7
 
1.8%
Other values (108) 219
55.4%
Decimal Number
ValueCountFrequency (%)
1 5
33.3%
2 4
26.7%
3 3
20.0%
5 1
 
6.7%
4 1
 
6.7%
6 1
 
6.7%
Space Separator
ValueCountFrequency (%)
14
100.0%
Control
ValueCountFrequency (%)
3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 395
91.2%
Common 38
 
8.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
텃 34
 
8.6%
밭 34
 
8.6%
농 24
 
6.1%
장 23
 
5.8%
동 19
 
4.8%
공 9
 
2.3%
역 9
 
2.3%
리 9
 
2.3%
도 8
 
2.0%
원 7
 
1.8%
Other values (108) 219
55.4%
Common
ValueCountFrequency (%)
14
36.8%
1 5
 
13.2%
2 4
 
10.5%
3 3
 
7.9%
3
 
7.9%
( 3
 
7.9%
) 3
 
7.9%
5 1
 
2.6%
4 1
 
2.6%
6 1
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 395
91.2%
ASCII 38
 
8.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
텃 34
 
8.6%
밭 34
 
8.6%
농 24
 
6.1%
장 23
 
5.8%
동 19
 
4.8%
공 9
 
2.3%
역 9
 
2.3%
리 9
 
2.3%
도 8
 
2.0%
원 7
 
1.8%
Other values (108) 219
55.4%
ASCII
ValueCountFrequency (%)
14
36.8%
1 5
 
13.2%
2 4
 
10.5%
3 3
 
7.9%
3
 
7.9%
( 3
 
7.9%
) 3
 
7.9%
5 1
 
2.6%
4 1
 
2.6%
6 1
 
2.6%

Unnamed: 8
Unsupported

REJECTED  UNSUPPORTED 

Missing0
Missing (%)0.0%
Memory size668.0 B

Unnamed: 9
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing66
Missing (%)98.5%
Memory size668.0 B
2023-12-11T15:36:12.275092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length2
Median length2
Mean length2
Min length2

Characters and Unicode

Total characters2
Distinct characters2
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row기타
ValueCountFrequency (%)
기타 1
100.0%
2023-12-11T15:36:12.491858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 1
50.0%
타 1
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 1
50.0%
타 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 1
50.0%
타 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 1
50.0%
타 1
50.0%

Correlations

2023-12-11T15:36:12.581599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 5Unnamed: 6Unnamed: 7
Unnamed: 11.0001.0001.0000.9990.7081.000
Unnamed: 21.0001.0001.0000.9940.6331.000
Unnamed: 31.0001.0001.0001.0000.7871.000
Unnamed: 50.9990.9941.0001.0000.6941.000
Unnamed: 60.7080.6330.7870.6941.0001.000
Unnamed: 71.0001.0001.0001.0001.0001.000
2023-12-11T15:36:12.683429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 5Unnamed: 1Unnamed: 2Unnamed: 6
Unnamed: 51.0000.8230.8770.364
Unnamed: 10.8231.0000.8100.682
Unnamed: 20.8770.8101.0000.261
Unnamed: 60.3640.6820.2611.000
2023-12-11T15:36:12.784819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 1Unnamed: 2Unnamed: 5Unnamed: 6
Unnamed: 11.0000.8100.8230.682
Unnamed: 20.8101.0000.8770.261
Unnamed: 50.8230.8771.0000.364
Unnamed: 60.6820.2610.3641.000

Missing values

2023-12-11T15:36:09.625350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T15:36:09.816031image/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

서울시 주말농장 현황(공영텃밭)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
0일련\n번호광역시도시군구읍면동지번운영주체텃밭 운영방식텃밭명면적(㎡)기타
11경기도남양주시조안면 송촌리954-4서울시공영주말농장송촌약수터농장6600<NA>
22경기도남양주시조안면 삼봉리331-3서울시공영주말농장삼봉리농장4125<NA>
33경기도양평군양서면 부용리21서울시공영주말농장교동농장9900<NA>
44경기도양평군양서면 부용리582-1서울시공영주말농장부용리농장10725<NA>
55경기도양평군양서면 부용리647-1서울시공영주말농장양수가정농장8250<NA>
66경기도양평군서종면 수능리395-1서울시공영주말농장수능리농장9900<NA>
77경기도광주시남종면 삼성리422서울시공영주말농장삼성리농장17325<NA>
88경기도광주시남종면 귀여리393-2서울시공영주말농장귀여리농장5775<NA>
99경기도광주시퇴촌면 도마리203서울시공영주말농장도마리농장7425<NA>
서울시 주말농장 현황(공영텃밭)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9
5757서울특별시강북구수유동599 외 1강북구공영주말농장강북 도시농업 체험장9500<NA>
5858서울특별시양천구신월동산174-1양천구공영주말농장(체험, 교육, 기부용)양천도시농업공원4200<NA>
5959서울특별시양천구신월동350-35양천구공영주말농장양천1마당텃밭1800<NA>
6060서울특별시양천구신월동350-31양천구공영주말농장양천2마당텃밭5000<NA>
6161서울특별시양천구신정동310-7양천구교육 및 체험텃밭신트리공원 자원순환텃밭1400<NA>
6262경기도광명시하안동332금천구공영주말농장금천친환경주말농장1300<NA>
6363서울특별시금천구독산동719-5 좌안금천구공영주말농장안양천도시농업체험장3000<NA>
6464서울특별시중랑구신내동256-9중랑도시농업 협동조합공영주말농장중랑행복1농장 (신내1호)3461<NA>
6565서울특별시중랑구망우동423-43중랑구공영주말농장중랑행복2농장 (망우1호)1844<NA>
6666서울특별시중랑구망우동113-2중랑구공영주말농장중랑행복3농장 (망우2호)6568<NA>

Duplicate rows

Most frequently occurring

Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 9# duplicates
0서울특별시구로구궁동구로구공영주말농장궁동3구역<NA>2