Overview

Dataset statistics

Number of variables23
Number of observations35
Missing cells39
Missing cells (%)4.8%
Duplicate rows9
Duplicate rows (%)25.7%
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 9 (25.7%) duplicate rowsDuplicates
2016년 01월 매표현황 보고자료 (입장객-일별) has 2 (5.7%) 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
2016년 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:57.618402
Analysis finished2024-04-18 04:22:57.701478
Duration0.08 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

Common Values (Plot)

2024-04-18T13:22:57.891719image/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

Distinct7
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size412.0 B
구름 조금
13 
구름 많음
11 
맑음
4 
<NA>
3 
흐림
2 
Other values (2)
2 

Length

Max length5
Median length5
Mean length4.2
Min length1

Unique

Unique2 ?
Unique (%)5.7%

Sample

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

Common Values

ValueCountFrequency (%)
구름 조금 13
37.1%
구름 많음 11
31.4%
맑음 4
 
11.4%
<NA> 3
 
8.6%
흐림 2
 
5.7%
날씨 1
 
2.9%
눈 1
 
2.9%

Length

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

Common Values (Plot)

2024-04-18T13:22:58.148654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구름 24
40.7%
조금 13
22.0%
많음 11
18.6%
맑음 4
 
6.8%
na 3
 
5.1%
흐림 2
 
3.4%
날씨 1
 
1.7%
눈 1
 
1.7%

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

2016년 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날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장무료소계총계유료소계어른청소년어린이외국인단체입장무료소계총계
32016-01-01 00:00:00금구름 조금33591023438247333927821414164709994338201703002444
42016-01-02 00:00:00토구름 많음5173209272651005127432820359610011120447171464204004894
52016-01-03 00:00:00일구름 많음300815494557912940250512830791015224462686602002795
62016-01-04 00:00:00월구름 많음89080016905188659853235512237941680440000610
72016-01-05 00:00:00화구름 많음4168401256434143183561434782112352101001921
82016-01-06 00:00:00수구름 조금367807117434364274414934079111553300001619
92016-01-07 00:00:00목맑음30973510441330024123361307291029990000615
2016년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
252016-01-23 00:00:00토구름 조금2965948906296198801867159288800000022
262016-01-24 00:00:00일구름 조금128196324231261089923019432022000024
272016-01-25 00:00:00월맑음72350422572581045035042200000000
282016-01-26 00:00:00화눈150608758101491221116100599748110000910
292016-01-27 00:00:00수구름 조금39482412182938928261462908161205550000813
302016-01-28 00:00:00목구름 많음37077611469366286463490773113944000037
312016-01-29 00:00:00금흐림107470317774610746635036146571700177400000033
322016-01-30 00:00:00토구름 조금265514734128722609222614523869014464055464015302773
332016-01-31 00:00:00일구름 조금15101074258428147612745514728010482524343022002660
34NaN<NA><NA>2935624597539538562903923495167738678471980242045324331729052290393710

Duplicate rows

Most frequently occurring

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