Overview

Dataset statistics

Number of variables33
Number of observations34
Missing cells84
Missing cells (%)7.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.9 KiB
Average record size in memory267.9 B

Variable types

Text1
Categorical2
Unsupported30

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-11 09:01:24.303321
Analysis finished2023-12-11 09:01:24.459232
Duration0.16 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

MISSING 

Distinct33
Distinct (%)100.0%
Missing1
Missing (%)2.9%
Memory size404.0 B
2023-12-11T18:01:24.616972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length6
Mean length6.030303
Min length2

Characters and Unicode

Total characters199
Distinct characters24
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique33 ?
Unique (%)100.0%

Sample

1st row조회일자: 2015-12-21
2nd row구  분
3rd row날짜
4th row01월01일
5th row01월02일
ValueCountFrequency (%)
조회일자 1
 
2.8%
2015-12-21 1
 
2.8%
01월28일 1
 
2.8%
01월27일 1
 
2.8%
01월26일 1
 
2.8%
01월25일 1
 
2.8%
01월24일 1
 
2.8%
구 1
 
2.8%
분 1
 
2.8%
01월23일 1
 
2.8%
Other values (26) 26
72.2%
2023-12-11T18:01:25.047948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 45
22.6%
0 41
20.6%
월 30
15.1%
일 30
15.1%
2 16
 
8.0%
5 4
 
2.0%
4 3
 
1.5%
7 3
 
1.5%
8 3
 
1.5%
9 3
 
1.5%
Other values (14) 21
10.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 124
62.3%
Other Letter 68
34.2%
Space Separator 4
 
2.0%
Dash Punctuation 2
 
1.0%
Other Punctuation 1
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 45
36.3%
0 41
33.1%
2 16
 
12.9%
5 4
 
3.2%
4 3
 
2.4%
7 3
 
2.4%
8 3
 
2.4%
9 3
 
2.4%
6 3
 
2.4%
3 3
 
2.4%
Other Letter
ValueCountFrequency (%)
월 30
44.1%
일 30
44.1%
구 1
 
1.5%
짜 1
 
1.5%
분 1
 
1.5%
조 1
 
1.5%
날 1
 
1.5%
회 1
 
1.5%
자 1
 
1.5%
계 1
 
1.5%
Space Separator
ValueCountFrequency (%)
2
50.0%
  2
50.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Other Punctuation
ValueCountFrequency (%)
: 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 131
65.8%
Hangul 68
34.2%

Most frequent character per script

Common
ValueCountFrequency (%)
1 45
34.4%
0 41
31.3%
2 16
 
12.2%
5 4
 
3.1%
4 3
 
2.3%
7 3
 
2.3%
8 3
 
2.3%
9 3
 
2.3%
6 3
 
2.3%
3 3
 
2.3%
Other values (4) 7
 
5.3%
Hangul
ValueCountFrequency (%)
월 30
44.1%
일 30
44.1%
구 1
 
1.5%
짜 1
 
1.5%
분 1
 
1.5%
조 1
 
1.5%
날 1
 
1.5%
회 1
 
1.5%
자 1
 
1.5%
계 1
 
1.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 129
64.8%
Hangul 68
34.2%
None 2
 
1.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 45
34.9%
0 41
31.8%
2 16
 
12.4%
5 4
 
3.1%
4 3
 
2.3%
7 3
 
2.3%
8 3
 
2.3%
9 3
 
2.3%
6 3
 
2.3%
3 3
 
2.3%
Other values (3) 5
 
3.9%
Hangul
ValueCountFrequency (%)
월 30
44.1%
일 30
44.1%
구 1
 
1.5%
짜 1
 
1.5%
분 1
 
1.5%
조 1
 
1.5%
날 1
 
1.5%
회 1
 
1.5%
자 1
 
1.5%
계 1
 
1.5%
None
ValueCountFrequency (%)
  2
100.0%

Unnamed: 1
Categorical

Distinct9
Distinct (%)26.5%
Missing0
Missing (%)0.0%
Memory size404.0 B
수
5 
<NA>
4 
목
4 
금
4 
토
4 
Other values (4)
13 

Length

Max length4
Median length1
Mean length1.3823529
Min length1

Unique

Unique1 ?
Unique (%)2.9%

Sample

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

Common Values

ValueCountFrequency (%)
수 5
14.7%
<NA> 4
11.8%
목 4
11.8%
금 4
11.8%
토 4
11.8%
일 4
11.8%
월 4
11.8%
화 4
11.8%
요일 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:01:25.320257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수 5
14.7%
na 4
11.8%
목 4
11.8%
금 4
11.8%
토 4
11.8%
일 4
11.8%
월 4
11.8%
화 4
11.8%
요일 1
 
2.9%

Unnamed: 2
Categorical

Distinct8
Distinct (%)23.5%
Missing0
Missing (%)0.0%
Memory size404.0 B
맑음
14 
구름 많음
9 
<NA>
4 
구름 조금
3 
날씨
 
1
Other values (3)
3 

Length

Max length5
Median length4
Mean length3.2352941
Min length1

Unique

Unique4 ?
Unique (%)11.8%

Sample

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

Common Values

ValueCountFrequency (%)
맑음 14
41.2%
구름 많음 9
26.5%
<NA> 4
 
11.8%
구름 조금 3
 
8.8%
날씨 1
 
2.9%
흐림 1
 
2.9%
눈 1
 
2.9%
비 1
 
2.9%

Length

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

Common Values (Plot)

2023-12-11T18:01:25.635216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
맑음 14
30.4%
구름 12
26.1%
많음 9
19.6%
na 4
 
8.7%
조금 3
 
6.5%
날씨 1
 
2.2%
흐림 1
 
2.2%
눈 1
 
2.2%
비 1
 
2.2%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.9%
Memory size404.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

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

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Unnamed: 32
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.8%
Memory size404.0 B

Sample

2014년 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: 30Unnamed: 31Unnamed: 32
0조회일자: 2015-12-21<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구  분<NA><NA>월관람객수NaNNaNNaN동,식물원NaNNaNNaNNaNNaNNaNNaNNaNNaN테마가든NaNNaNNaNNaNNaNNaNNaN자연학습교실NaNNaNNaNNaNNaNNaNNaN
2<NA><NA><NA>NaNNaNNaNNaN유료입장NaNNaNNaNNaNNaN무료소계총  계무료소계총  계유료입장NaNNaNNaNNaNNaN무료소계총  계유료입장NaNNaNNaNNaNNaN무료소계총  계
3날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장NaNNaNNaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN
401월01일수구름 조금4249235366021054233350420352610501481571485585516120400173300000000
501월02일목맑음1235150527402812049689514128771246245024224231260500174800000000
601월03일금구름 많음138716112998801351103411320480361194254540340314110300142822002200022
701월04일토맑음41803379755980409333521505918041247265658608606751313004711420200000020
801월05일일구름 많음43513182753396427935521955329402255653490090072640820279900000000
901월06일월맑음85713102167238376587510423010291866264264961200172611001100011
2014년 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: 30Unnamed: 31Unnamed: 32
2401월21일화구름 많음28259687817258190402817054880641411100007823002300023
2501월22일수맑음40997313821238931648251208271216136136220000101218001800018
2601월23일목구름 조금914119921132087556552258203361099197496964301004835003500035
2701월24일금구름 많음807108518921875056373114180872162220120110100000122247404300047
2801월25일토비715109218079654550356993097416281091090000009961006100061
2901월26일일맑음3327247358001033290282715131210301755504568268237303400367300000000
3001월27일월맑음6701025169522665530567922081014752122120000003350050005
3101월28일화구름 많음5491039158824547418913824089214391421422110005700000000
3201월29일수맑음789108818772678666566552630835162124424433000091200000000
33월 계<NA><NA>4272941890846191073416813321226555814106629903254874229896189613863258537038176766293155540150662