Overview

Dataset statistics

Number of variables31
Number of observations35
Missing cells53
Missing cells (%)4.9%
Duplicate rows9
Duplicate rows (%)25.7%
Total size in memory8.6 KiB
Average record size in memory251.8 B

Variable types

Unsupported29
Categorical2

Dataset

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

Alerts

Dataset has 9 (25.7%) duplicate rowsDuplicates
2015년 01월 매표현황 보고자료 (입장객-일별) has 1 (2.9%) missing valuesMissing
Unnamed: 3 has 1 (2.9%) missing valuesMissing
Unnamed: 4 has 2 (5.7%) missing valuesMissing
Unnamed: 5 has 2 (5.7%) missing valuesMissing
Unnamed: 6 has 2 (5.7%) missing valuesMissing
Unnamed: 7 has 1 (2.9%) missing valuesMissing
Unnamed: 8 has 2 (5.7%) missing valuesMissing
Unnamed: 9 has 2 (5.7%) missing valuesMissing
Unnamed: 10 has 2 (5.7%) missing valuesMissing
Unnamed: 11 has 2 (5.7%) missing valuesMissing
Unnamed: 12 has 2 (5.7%) missing valuesMissing
Unnamed: 13 has 2 (5.7%) missing valuesMissing
Unnamed: 14 has 2 (5.7%) missing valuesMissing
Unnamed: 15 has 1 (2.9%) missing valuesMissing
Unnamed: 16 has 2 (5.7%) missing valuesMissing
Unnamed: 17 has 2 (5.7%) missing valuesMissing
Unnamed: 18 has 2 (5.7%) missing valuesMissing
Unnamed: 19 has 2 (5.7%) missing valuesMissing
Unnamed: 20 has 2 (5.7%) missing valuesMissing
Unnamed: 21 has 2 (5.7%) missing valuesMissing
Unnamed: 22 has 2 (5.7%) missing valuesMissing
Unnamed: 23 has 1 (2.9%) missing valuesMissing
Unnamed: 24 has 2 (5.7%) missing valuesMissing
Unnamed: 25 has 2 (5.7%) missing valuesMissing
Unnamed: 26 has 2 (5.7%) missing valuesMissing
Unnamed: 27 has 2 (5.7%) missing valuesMissing
Unnamed: 28 has 2 (5.7%) missing valuesMissing
Unnamed: 29 has 2 (5.7%) missing valuesMissing
Unnamed: 30 has 2 (5.7%) missing valuesMissing
2015년 01월 매표현황 보고자료 (입장객-일별) 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
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 09:02:17.180138
Analysis finished2023-12-11 09:02:17.332989
Duration0.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2015년 01월 매표현황 보고자료 (입장객-일별)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 1
Categorical

Distinct9
Distinct (%)25.7%
Missing0
Missing (%)0.0%
Memory size412.0 B
목
5 
금
5 
토
5 
일
4 
월
4 
Other values (4)
12 

Length

Max length4
Median length1
Mean length1.2857143
Min length1

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
목 5
14.3%
금 5
14.3%
토 5
14.3%
일 4
11.4%
월 4
11.4%
화 4
11.4%
수 4
11.4%
<NA> 3
8.6%
요일 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:02:17.588625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목 5
14.3%
금 5
14.3%
토 5
14.3%
일 4
11.4%
월 4
11.4%
화 4
11.4%
수 4
11.4%
na 3
8.6%
요일 1
 
2.9%

Unnamed: 2
Categorical

Distinct6
Distinct (%)17.1%
Missing0
Missing (%)0.0%
Memory size412.0 B
맑음
11 
구름 많음
10 
구름 조금
7 
<NA>
3 
흐림
3 

Length

Max length5
Median length4
Mean length3.6285714
Min length2

Unique

Unique1 ?
Unique (%)2.9%

Sample

1st row<NA>
2nd row<NA>
3rd row날씨
4th row맑음
5th row구름 많음

Common Values

ValueCountFrequency (%)
맑음 11
31.4%
구름 많음 10
28.6%
구름 조금 7
20.0%
<NA> 3
 
8.6%
흐림 3
 
8.6%
날씨 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:02:17.892379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구름 17
32.7%
맑음 11
21.2%
많음 10
19.2%
조금 7
13.5%
na 3
 
5.8%
흐림 3
 
5.8%
날씨 1
 
1.9%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.9%
Memory size412.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
Memory size412.0 B

Sample

2015년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30
0구분<NA><NA>월별입장객NaNNaNNaN동,식물원NaNNaNNaNNaNNaNNaNNaN테마가든NaNNaNNaNNaNNaNNaNNaN자연학습교실NaNNaNNaNNaNNaNNaNNaN
1NaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장무료소계총계유료소계어른청소년어린이외국인단체입장무료소계총계유료소계어른청소년어린이외국인단체입장무료소계총계
32015-01-01 00:00:00목맑음114350216455211419297114152049616372200006800000000
42015-01-02 00:00:00금구름 많음69163813294674509531120063713114202441513001300013
52015-01-03 00:00:00토구름 조금204813403388461996163410425845601318331429252211225123002300023
62015-01-04 00:00:00일구름 많음3392193553272833122763144405283018895201807406004612600000000
72015-01-05 00:00:00월구름 많음726888161445707565321104508711578540100172214001400014
82015-01-06 00:00:00화구름 조금375899127419369244477817508861255660022131900000000
92015-01-07 00:00:00수구름 조금288722101014288213522314071810060000004400000000
2015년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30
252015-01-23 00:00:00금맑음8088841692227495311071112108661615761011182552634300052
262015-01-24 00:00:00토구름 많음49102583749373478639032016826630253773238578077746131391102800039
272015-01-25 00:00:00일흐림17091155286444168413521212114201147283155002281320901100020
282015-01-26 00:00:00월흐림681721140246681491929846071813990000003300000000
292015-01-27 00:00:00화맑음55295615083454740782583409411488520300152000000000
302015-01-28 00:00:00수맑음456807126384543298738807801234220000272900000000
312015-01-29 00:00:00목구름 많음502759126132502389694432075412560000005500000000
322015-01-30 00:00:00금구름 많음2161792295320214111442057922016387892930440000371670900016
332015-01-31 00:00:00토맑음20181238325631198916211422263112512183207990000202920901100020
34월별입장객수<NA><NA>4129233020743129214048931046273667079024558325277301637934633019194938724247533460200424

Duplicate rows

Most frequently occurring

Unnamed: 1Unnamed: 2# duplicates
0금구름 많음3
1목구름 많음3
5토맑음3
8<NA><NA>3
2목맑음2
3월맑음2
4일구름 조금2
6화구름 조금2
7화맑음2