Overview

Dataset statistics

Number of variables23
Number of observations35
Missing cells38
Missing cells (%)4.7%
Duplicate rows11
Duplicate rows (%)31.4%
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 11 (31.4%) duplicate rowsDuplicates
2019년 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
2019년 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 started2024-04-18 04:22:56.015530
Analysis finished2024-04-18 04:22:56.128454
Duration0.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2019년 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

2024-04-18T13:22:56.204462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T13:22:56.348084image/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
<NA>
15 
맑음
8 
구름 조금
5 
구름 많음
5 
날씨
 
1

Length

Max length5
Median length4
Mean length3.7142857
Min length2

Unique

Unique2 ?
Unique (%)5.7%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 15
42.9%
맑음 8
22.9%
구름 조금 5
 
14.3%
구름 많음 5
 
14.3%
날씨 1
 
2.9%
흐림 1
 
2.9%

Length

2024-04-18T13:22:56.508954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T13:22:56.635388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 15
33.3%
구름 10
22.2%
맑음 8
17.8%
조금 5
 
11.1%
많음 5
 
11.1%
날씨 1
 
2.2%
흐림 1
 
2.2%

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

Sample

2019년 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>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장무료소계총계유료소계어른청소년어린이외국인단체입장무료소계총계
32019-01-01 00:00:00화구름 조금919605152454912770489454058114937601002431
42019-01-02 00:00:00수맑음1754596341117514714141104466210000001313
52019-01-03 00:00:00목맑음182595777161821538211605797610000001616
62019-01-04 00:00:00금구름 많음18150969031761391423304846605500002530
72019-01-05 00:00:00토<NA>740861160116734615328716084215766600001925
82019-01-06 00:00:00일<NA>101310442057179918213413617010232014222101002143
92019-01-07 00:00:00월<NA>213560773262091548472605507594400001014
2019년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
252019-01-23 00:00:00수맑음2135437561121117011301105207312200002325
262019-01-24 00:00:00목구름 조금290720101042812241146406899709711003140
272019-01-25 00:00:00금<NA>2566268821625619825331605908460000003636
282019-01-26 00:00:00토<NA>885113820231186471935110117311171981211704002142
292019-01-27 00:00:00일<NA>140099123913213761174421603209582334242301003357
302019-01-28 00:00:00월<NA>22348070372231911220704696920000001111
312019-01-29 00:00:00화구름 조금313625938223122662026220616928110000910
322019-01-30 00:00:00수구름 많음2155017161021317124181004917042200001012
332019-01-31 00:00:00목구름 많음10895351624111087886291721193450915962200002628
34월계<NA><NA>1445720314347714671427311752678184346613991962633899184167611138688872

Duplicate rows

Most frequently occurring

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