Overview

Dataset statistics

Number of variables23
Number of observations35
Missing cells59
Missing cells (%)7.3%
Duplicate rows8
Duplicate rows (%)22.9%
Total size in memory6.4 KiB
Average record size in memory187.8 B

Variable types

Unsupported21
Categorical2

Dataset

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

Alerts

Dataset has 8 (22.9%) duplicate rowsDuplicates
2020년 01월 매표현황 보고자료 (입장객-일별) has 2 (5.7%) missing valuesMissing
Unnamed: 3 has 2 (5.7%) missing valuesMissing
Unnamed: 4 has 3 (8.6%) missing valuesMissing
Unnamed: 5 has 3 (8.6%) missing valuesMissing
Unnamed: 6 has 3 (8.6%) missing valuesMissing
Unnamed: 7 has 2 (5.7%) missing valuesMissing
Unnamed: 8 has 3 (8.6%) missing valuesMissing
Unnamed: 9 has 3 (8.6%) missing valuesMissing
Unnamed: 10 has 3 (8.6%) missing valuesMissing
Unnamed: 11 has 3 (8.6%) missing valuesMissing
Unnamed: 12 has 3 (8.6%) missing valuesMissing
Unnamed: 13 has 3 (8.6%) missing valuesMissing
Unnamed: 14 has 3 (8.6%) missing valuesMissing
Unnamed: 15 has 2 (5.7%) missing valuesMissing
Unnamed: 16 has 3 (8.6%) missing valuesMissing
Unnamed: 17 has 3 (8.6%) missing valuesMissing
Unnamed: 18 has 3 (8.6%) missing valuesMissing
Unnamed: 19 has 3 (8.6%) missing valuesMissing
Unnamed: 20 has 3 (8.6%) missing valuesMissing
Unnamed: 21 has 3 (8.6%) missing valuesMissing
Unnamed: 22 has 3 (8.6%) missing valuesMissing
2020년 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

Reproduction

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

Variables

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

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.7%
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<NA>
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:23.195868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T18:02:23.310556image/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
맑음
18 
구름 많음
6 
흐림
5 
<NA>
3 
비
2 

Length

Max length5
Median length2
Mean length2.6285714
Min length1

Unique

Unique1 ?
Unique (%)2.9%

Sample

1st row<NA>
2nd row<NA>
3rd row날씨
4th row<NA>
5th row흐림

Common Values

ValueCountFrequency (%)
맑음 18
51.4%
구름 많음 6
 
17.1%
흐림 5
 
14.3%
<NA> 3
 
8.6%
비 2
 
5.7%
날씨 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:02:23.562992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
맑음 18
43.9%
구름 6
 
14.6%
많음 6
 
14.6%
흐림 5
 
12.2%
na 3
 
7.3%
비 2
 
4.9%
날씨 1
 
2.4%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.6%
Memory size412.0 B

Sample

2020년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
0구분<NA><NA>월별입장객 현황NaNNaNNaN동,식물원NaNNaNNaNNaNNaNNaNNaN테마가든NaNNaNNaNNaNNaNNaNNaN
1NaN<NA><NA>유료합계무료합계총계외국인계NaNNaNNaNNaNNaNNaN무료소계총계NaNNaNNaNNaNNaNNaN무료소계총계
2날짜요일날씨NaNNaNNaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN
3NaN<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
42020-01-01 00:00:00수흐림77446512397727676503087764045212197601801320
52020-01-02 00:00:00목맑음316550866772315279112576405288431001802223
62020-01-03 00:00:00금맑음321491812772318264223276404397573201805255
72020-01-04 00:00:00토맑음1128931205977211179354214076409152032111100801627
82020-01-05 00:00:00일맑음1520120127217721500128130189764011672667201802803454
92020-01-06 00:00:00월비99367466772998577764173514500000801616
2020년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
252020-01-22 00:00:00수구름 많음2944867807722942491530764048077400008066
262020-01-23 00:00:00목맑음401408809772397315315176403877844400802125
272020-01-24 00:00:00금맑음14595822041772144612096916876405712017131300801124
282020-01-25 00:00:00토맑음293186938007722871241612333276408393710605019803090
292020-01-26 00:00:00일맑음362597245977723569300810146076409364505564808803692
302020-01-27 00:00:00월흐림1353883223677213431141531497640857220010802802636
312020-01-28 00:00:00화흐림393532925772391301157576405159062200801719
322020-01-29 00:00:00수흐림274483757772273225183076404567291100802728
332020-01-30 00:00:00목구름 많음1530483201377215191002324857641212466198511803801728
342020-01-31 00:00:00금구름 많음232396628772227195122076403866135500801015

Duplicate rows

Most frequently occurring

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