Overview

Dataset statistics

Number of variables23
Number of observations36
Missing cells92
Missing cells (%)11.1%
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
2021년 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 3 (8.3%) 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 3 (8.3%) 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
2021년 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:18.923558
Analysis finished2023-12-11 09:02:19.033021
Duration0.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2021년 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:19.432036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T18:02:19.555139image/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:19.658966image/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:19.855090image/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 

Missing3
Missing (%)8.3%
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 

Missing3
Missing (%)8.3%
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

2021년 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유료입장NaNNaNNaNNaNNaN무료입장계유료입장NaNNaNNaNNaNNaN무료입장계
3날짜요일기타유료일계무료일계일합계외국인계유료계어른청소년어린이외국인단체입장NaNNaN유료계어른청소년어린이외국인단체입장NaNNaN
4월계<NA><NA>2217970392921821205121744942726361959759482646016671478171722010912758
52021-01-01 00:00:00금<NA>4921416330459387175500121580333003002053
62021-01-02 00:00:00토<NA>65227692825964971485202288245648080048104
72021-01-03 00:00:00일<NA>4591666252421360154620143564383602002361
82021-01-04 00:00:00월<NA>8611319907466350087161121101002638
92021-01-05 00:00:00화<NA>6399162059494600811404112001822
2021년 1월 서울대공원 일별 입장객 현황Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
262021-01-22 00:00:00금<NA>230113343021416812340087301161600002642
272021-01-23 00:00:00토<NA>387767945565354530842943250576412133230502700103435
282021-01-24 00:00:00일<NA>675214758227661985384106708601300749855447786900175729
292021-01-25 00:00:00월<NA>86426811320803683151050021610196153080052113
302021-01-26 00:00:00화<NA>108110218294711220086180141400202438
312021-01-27 00:00:00수<NA>4762697450441387104400218659352915005186
322021-01-28 00:00:00목<NA>308911902623120081107440000812
332021-01-29 00:00:00금<NA>43641070433805005910200000055
342021-01-30 00:00:00토<NA>114835515031110094828124103421442483747001361
352021-01-31 00:00:00일<NA>340660140070313526686240500496363127124312700105376

Duplicate rows

Most frequently occurring

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