Overview

Dataset statistics

Number of variables23
Number of observations36
Missing cells99
Missing cells (%)12.0%
Duplicate rows8
Duplicate rows (%)22.2%
Total size in memory6.6 KiB
Average record size in memory187.7 B

Variable types

Unsupported21
Categorical1
Text1

Dataset

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

Alerts

Unnamed: 2 has constant value ""Constant
Dataset has 8 (22.2%) duplicate rowsDuplicates
2022년 1월 서울대공원 일별 입장객 현황 has 2 (5.6%) missing valuesMissing
Unnamed: 2 has 35 (97.2%) missing valuesMissing
Unnamed: 3 has 2 (5.6%) missing valuesMissing
Unnamed: 4 has 3 (8.3%) missing valuesMissing
Unnamed: 5 has 3 (8.3%) missing valuesMissing
Unnamed: 6 has 3 (8.3%) missing valuesMissing
Unnamed: 7 has 1 (2.8%) missing valuesMissing
Unnamed: 8 has 3 (8.3%) missing valuesMissing
Unnamed: 9 has 3 (8.3%) missing valuesMissing
Unnamed: 10 has 3 (8.3%) missing valuesMissing
Unnamed: 11 has 3 (8.3%) missing valuesMissing
Unnamed: 12 has 7 (19.4%) missing valuesMissing
Unnamed: 13 has 3 (8.3%) missing valuesMissing
Unnamed: 14 has 3 (8.3%) missing valuesMissing
Unnamed: 15 has 1 (2.8%) missing valuesMissing
Unnamed: 16 has 3 (8.3%) missing valuesMissing
Unnamed: 17 has 3 (8.3%) missing valuesMissing
Unnamed: 18 has 3 (8.3%) missing valuesMissing
Unnamed: 19 has 6 (16.7%) missing valuesMissing
Unnamed: 20 has 3 (8.3%) missing valuesMissing
Unnamed: 21 has 3 (8.3%) missing valuesMissing
Unnamed: 22 has 3 (8.3%) missing valuesMissing
2022년 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: 9 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
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 09:02:38.321153
Analysis finished2023-12-11 09:02:38.419375
Duration0.1 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2022년 1월 서울대공원 일별 입장객 현황
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.6%
Memory size420.0 B

Unnamed: 1
Categorical

Distinct9
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
토
5 
일
5 
월
5 
<NA>
4 
화
4 
Other values (4)
13 

Length

Max length4
Median length1
Mean length1.3611111
Min length1

Unique

Unique1 ?
Unique (%)2.8%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row요일
5th row<NA>

Common Values

ValueCountFrequency (%)
토 5
13.9%
일 5
13.9%
월 5
13.9%
<NA> 4
11.1%
화 4
11.1%
수 4
11.1%
목 4
11.1%
금 4
11.1%
요일 1
 
2.8%

Length

2023-12-11T18:02:38.499426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T18:02:38.635191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
토 5
13.9%
일 5
13.9%
월 5
13.9%
na 4
11.1%
화 4
11.1%
수 4
11.1%
목 4
11.1%
금 4
11.1%
요일 1
 
2.8%

Unnamed: 2
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing35
Missing (%)97.2%
Memory size420.0 B
2023-12-11T18:02:38.737611image/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-11T18:02:38.935995image/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%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.6%
Memory size420.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing7
Missing (%)19.4%
Memory size420.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)16.7%
Memory size420.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Sample

2022년 1월 서울대공원 일별 입장객 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
0NaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구 분<NA><NA>월 관람객 수NaNNaNNaN동,식물원NaNNaNNaNNaNNaNNaNNaN테마가든NaNNaNNaNNaNNaNNaNNaN
2NaN<NA><NA>NaNNaNNaNNaN유료입장(외국인, 단체 포함)NaNNaNNaN비고NaN무료입장계유료입장(외국인, 단체 포함)NaNNaNNaN비고NaN무료입장계
3날짜요일기타유료일계무료일계일합계외국인계유료계어른청소년어린이외국인단체입장NaNNaN유료계어른청소년어린이외국인단체입장NaNNaN
4월계<NA><NA>206476160268079820022155551032343596160150682509062553315772010921717
52022-01-01 00:00:00토<NA>831212104327906363811620179969413227003374
62022-01-02 00:00:00일<NA>780304108407496123710000237986312704006798
72022-01-03 00:00:00월<NA>19812632401881593260010629410622002030
82022-01-04 00:00:00화<NA>1772404170175142726001983732200004244
92022-01-05 00:00:00수<NA>1661833490166132628001633290000002020
2022년 1월 서울대공원 일별 입장객 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
262022-01-22 00:00:00토<NA>15832991882115331184512981024517785044150054104
272022-01-23 00:00:00일<NA>24613442805023621916843620025226149989370092191
282022-01-24 00:00:00월<NA>5182287460490393257200177667282314005179
292022-01-25 00:00:00화<NA>14112626701411081320001122530000001414
302022-01-26 00:00:00수<NA>35919955803502782250001775279702002231
312022-01-27 00:00:00목<NA>303173476029322718480014944210523002434
322022-01-28 00:00:00금<NA>2991274260285243162600101386141301002640
332022-01-29 00:00:00토<NA>968269123713932754331451202261158363114104379
342022-01-30 00:00:00일<NA>165729419513316291300732563302491878281909004573
352022-01-31 00:00:00월<NA>248027527551424371923964181402582695433715001760

Duplicate rows

Most frequently occurring

Unnamed: 1Unnamed: 2# duplicates
3월<NA>5
4일<NA>5
5토<NA>5
0금<NA>4
1목<NA>4
2수<NA>4
6화<NA>4
7<NA><NA>4