Overview

Dataset statistics

Number of variables23
Number of observations35
Missing cells38
Missing cells (%)4.7%
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
2018년 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
2018년 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:33.283966
Analysis finished2023-12-11 09:02:33.399615
Duration0.12 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

Common Values (Plot)

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

Distinct8
Distinct (%)22.9%
Missing0
Missing (%)0.0%
Memory size412.0 B
맑음
11 
구름 조금
9 
구름 많음
6 
<NA>
3 
흐림
3 
Other values (3)
3 

Length

Max length5
Median length4
Mean length3.4
Min length1

Unique

Unique3 ?
Unique (%)8.6%

Sample

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

Common Values

ValueCountFrequency (%)
맑음 11
31.4%
구름 조금 9
25.7%
구름 많음 6
17.1%
<NA> 3
 
8.6%
흐림 3
 
8.6%
날씨 1
 
2.9%
비 1
 
2.9%
눈 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:02:33.954897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
구름 15
30.0%
맑음 11
22.0%
조금 9
18.0%
많음 6
 
12.0%
na 3
 
6.0%
흐림 3
 
6.0%
날씨 1
 
2.0%
비 1
 
2.0%
눈 1
 
2.0%

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

2018년 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날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장무료소계총계유료소계어른청소년어린이외국인단체입장무료소계총계
32018-01-01 00:00:00월맑음168862823164016831375992094006192302550000914
42018-01-02 00:00:00화구름 조금4035859882240134215442211957897922000079
52018-01-03 00:00:00수구름 조금192502694419115322164050269310010001
62018-01-04 00:00:00목흐림165506671141631329221414886512200001820
72018-01-05 00:00:00금구름 조금189569758818814512318056775511000023
82018-01-06 00:00:00토맑음968967193525953821321002509551908151500001227
92018-01-07 00:00:00일흐림92295918812091174061110190941185211902101829
2018년 01월 매표현황 보고자료 (입장객-일별)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
252018-01-23 00:00:00화맑음67296363767489107029536200000011
262018-01-24 00:00:00수맑음1811012801816110011012800000000
272018-01-25 00:00:00목맑음2313916212323001013916200000000
282018-01-26 00:00:00금맑음50172222050311360017222200000000
292018-01-27 00:00:00토구름 조금24740865511244200301411040865232010003
302018-01-28 00:00:00일구름 조금4575059621544836430541504939419711001221
312018-01-29 00:00:00월맑음873224096877476603123990000001010
322018-01-30 00:00:00화구름 많음92034579660292029191001129097452965411000056
332018-01-31 00:00:00수구름 많음151434585121511311191204245750000001010
34월계<NA><NA>21069155223659132120939918910239151131810023152753621413010761730247377

Duplicate rows

Most frequently occurring

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