Overview

Dataset statistics

Number of variables39
Number of observations36
Missing cells100
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.1 KiB
Average record size in memory315.7 B

Variable types

Text1
Categorical2
Unsupported36

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-11 09:01:27.324440
Analysis finished2023-12-11 09:01:27.537436
Duration0.21 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

MISSING 

Distinct35
Distinct (%)100.0%
Missing1
Missing (%)2.8%
Memory size420.0 B
2023-12-11T18:01:27.720152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length6
Mean length6.0285714
Min length2

Characters and Unicode

Total characters211
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

Unique35 ?
Unique (%)100.0%

Sample

1st row조회일자: 2015-12-21
2nd row구  분
3rd row날짜
4th row01월01일
5th row01월02일
ValueCountFrequency (%)
조회일자 1
 
2.6%
01월24일 1
 
2.6%
01월23일 1
 
2.6%
01월17일 1
 
2.6%
01월18일 1
 
2.6%
01월19일 1
 
2.6%
01월20일 1
 
2.6%
01월21일 1
 
2.6%
01월22일 1
 
2.6%
01월31일 1
 
2.6%
Other values (28) 28
73.7%
2023-12-11T18:01:28.218421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 48
22.7%
0 44
20.9%
일 32
15.2%
월 32
15.2%
2 16
 
7.6%
3 5
 
2.4%
5 4
 
1.9%
9 3
 
1.4%
8 3
 
1.4%
7 3
 
1.4%
Other values (14) 21
10.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 132
62.6%
Other Letter 72
34.1%
Space Separator 4
 
1.9%
Dash Punctuation 2
 
0.9%
Other Punctuation 1
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 48
36.4%
0 44
33.3%
2 16
 
12.1%
3 5
 
3.8%
5 4
 
3.0%
9 3
 
2.3%
8 3
 
2.3%
7 3
 
2.3%
6 3
 
2.3%
4 3
 
2.3%
Other Letter
ValueCountFrequency (%)
일 32
44.4%
월 32
44.4%
짜 1
 
1.4%
조 1
 
1.4%
날 1
 
1.4%
분 1
 
1.4%
회 1
 
1.4%
구 1
 
1.4%
자 1
 
1.4%
계 1
 
1.4%
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 139
65.9%
Hangul 72
34.1%

Most frequent character per script

Common
ValueCountFrequency (%)
1 48
34.5%
0 44
31.7%
2 16
 
11.5%
3 5
 
3.6%
5 4
 
2.9%
9 3
 
2.2%
8 3
 
2.2%
7 3
 
2.2%
6 3
 
2.2%
4 3
 
2.2%
Other values (4) 7
 
5.0%
Hangul
ValueCountFrequency (%)
일 32
44.4%
월 32
44.4%
짜 1
 
1.4%
조 1
 
1.4%
날 1
 
1.4%
분 1
 
1.4%
회 1
 
1.4%
구 1
 
1.4%
자 1
 
1.4%
계 1
 
1.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 137
64.9%
Hangul 72
34.1%
None 2
 
0.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 48
35.0%
0 44
32.1%
2 16
 
11.7%
3 5
 
3.6%
5 4
 
2.9%
9 3
 
2.2%
8 3
 
2.2%
7 3
 
2.2%
6 3
 
2.2%
4 3
 
2.2%
Other values (3) 5
 
3.6%
Hangul
ValueCountFrequency (%)
일 32
44.4%
월 32
44.4%
짜 1
 
1.4%
조 1
 
1.4%
날 1
 
1.4%
분 1
 
1.4%
회 1
 
1.4%
구 1
 
1.4%
자 1
 
1.4%
계 1
 
1.4%
None
ValueCountFrequency (%)
  2
100.0%

Unnamed: 1
Categorical

Distinct9
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Memory size420.0 B
화
5 
수
5 
목
5 
<NA>
4 
금
4 
Other values (4)
13 

Length

Max length4
Median length1
Mean length1.3611111
Min length1

Unique

Unique1 ?
Unique (%)2.8%

Sample

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

Common Values

ValueCountFrequency (%)
화 5
13.9%
수 5
13.9%
목 5
13.9%
<NA> 4
11.1%
금 4
11.1%
토 4
11.1%
일 4
11.1%
월 4
11.1%
요일 1
 
2.8%

Length

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

Common Values (Plot)

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

Unnamed: 2
Categorical

Distinct6
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size420.0 B
<NA>
15 
구름 많음
8 
맑음
7 
흐림
3 
눈/비
2 

Length

Max length5
Median length4
Mean length3.5555556
Min length2

Unique

Unique1 ?
Unique (%)2.8%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 15
41.7%
구름 많음 8
22.2%
맑음 7
19.4%
흐림 3
 
8.3%
눈/비 2
 
5.6%
날씨 1
 
2.8%

Length

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

Common Values (Plot)

2023-12-11T18:01:29.194993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 15
34.1%
구름 8
18.2%
많음 8
18.2%
맑음 7
15.9%
흐림 3
 
6.8%
눈/비 2
 
4.5%
날씨 1
 
2.3%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.6%
Memory size420.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)2.8%
Memory size420.0 B

Unnamed: 32
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 33
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 34
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 35
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 36
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 37
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Unnamed: 38
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)8.3%
Memory size420.0 B

Sample

2013년 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: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38
0조회일자: 2015-12-21<NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구  분<NA><NA>월관람객수NaNNaNNaN동,식물원NaNNaNNaNNaNNaNNaNNaN돌고래쇼NaNNaNNaNNaNNaNNaNNaN테마가든NaNNaNNaNNaNNaNNaNNaN자연학습교실NaNNaNNaNNaNNaNNaNNaN
2<NA><NA><NA>NaNNaNNaNNaN유료입장NaNNaNNaNNaNNaN무료소계총  계유료입장NaNNaNNaNNaNNaN무료소계총  계유료입장NaNNaNNaNNaNNaN무료소계총  계유료입장NaNNaNNaNNaNNaN무료소계총  계
3날짜요일날씨유료합계무료합계총계외국인계유료소계어른청소년어린이외국인단체입장NaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN유료소계어른청소년어린이외국인단체입장NaNNaN
401월01일화<NA>1366731209751135510899517143059519500000801241241160500122300000000
501월02일수<NA>199474673181971621817123644564200006029292200000200000000
601월03일목<NA>1123394511611185121416031442500000024241100001200000000
701월04일금<NA>2014156161118613027297036655200004046460000003315150000015
801월05일토<NA>879109119701287671163102123098018560000001081083201003600000000
901월06일일<NA>1527143029572315091209872132301220272900000020020018170100102800000000
2013년 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: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37Unnamed: 38
2601월23일수눈/비170693863815711613288064880500000040402020005711001100011
2701월24일목흐림3689301298143372385247140843118000000086866420001725002500025
2801월25일금맑음272563835622114736386052874900000035350000000051105000051
2901월26일토맑음865991185621773610758821084616190000001431433201002589008900089
3001월27일일맑음975106420399794874277129790871181900001801901902200003525002500025
3101월28일월맑음4767991275204743047397143271111850000607878220000101200000000
3201월29일화흐림47399114642047034964571808661336000020113113330000121500000000
3301월30일수구름 많음7351121185617719578905117099717160000001211211614020031900000000
3401월31일목구름 많음14901556304636147012281271152901338280800002019719720191050214100000000
35월 계<NA><NA>2937732375617527862848322133188344677191967278545633700006204292429223218773850229461662250637000662