Overview

Dataset statistics

Number of variables8
Number of observations30
Missing cells120
Missing cells (%)50.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.2 KiB
Average record size in memory73.4 B

Variable types

Numeric1
Categorical1
DateTime1
Text1
Unsupported4

Dataset

Description경기도 고양시 사진기록물 목록에 대한 데이터로 번호, 시군구, 촬영일자, 촬영내용(고양행주문화제, 고양시청사 전경 등)의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15119070/fileData.do

Alerts

시군구 has constant value ""Constant
Unnamed: 4 has 30 (100.0%) missing valuesMissing
Unnamed: 5 has 30 (100.0%) missing valuesMissing
Unnamed: 6 has 30 (100.0%) missing valuesMissing
Unnamed: 7 has 30 (100.0%) missing valuesMissing
번호 has unique valuesUnique
내용 has unique valuesUnique
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

Reproduction

Analysis started2023-12-12 14:42:47.928752
Analysis finished2023-12-12 14:42:48.733508
Duration0.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.5
Minimum1
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-12T23:42:48.802829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.45
Q18.25
median15.5
Q322.75
95-th percentile28.55
Maximum30
Range29
Interquartile range (IQR)14.5

Descriptive statistics

Standard deviation8.8034084
Coefficient of variation (CV)0.56796183
Kurtosis-1.2
Mean15.5
Median Absolute Deviation (MAD)7.5
Skewness0
Sum465
Variance77.5
MonotonicityStrictly increasing
2023-12-12T23:42:48.940487image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
1 1
 
3.3%
17 1
 
3.3%
30 1
 
3.3%
29 1
 
3.3%
28 1
 
3.3%
27 1
 
3.3%
26 1
 
3.3%
25 1
 
3.3%
24 1
 
3.3%
23 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1 1
3.3%
2 1
3.3%
3 1
3.3%
4 1
3.3%
5 1
3.3%
6 1
3.3%
7 1
3.3%
8 1
3.3%
9 1
3.3%
10 1
3.3%
ValueCountFrequency (%)
30 1
3.3%
29 1
3.3%
28 1
3.3%
27 1
3.3%
26 1
3.3%
25 1
3.3%
24 1
3.3%
23 1
3.3%
22 1
3.3%
21 1
3.3%

시군구
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
고양시
30 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고양시
2nd row고양시
3rd row고양시
4th row고양시
5th row고양시

Common Values

ValueCountFrequency (%)
고양시 30
100.0%

Length

2023-12-12T23:42:49.069497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:42:49.158775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고양시 30
100.0%

촬영일자
Date

Distinct22
Distinct (%)73.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2022-01-01 00:00:00
Maximum2022-12-30 00:00:00
2023-12-12T23:42:49.268874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:42:49.401692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)

내용
Text

UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
2023-12-12T23:42:49.603338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length20.5
Mean length14.8
Min length4

Characters and Unicode

Total characters444
Distinct characters119
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique30 ?
Unique (%)100.0%

Sample

1st row행주산성 일출
2nd row2022년 시무식 및 제7대 박원석 제1부시장 취임식
3rd row현충탑 참배
4th row고양특례시 출범 선포식
5th row고양특례시 표지석 제막식
ValueCountFrequency (%)
2022 7
 
7.9%
고양특례시장 4
 
4.5%
이동환 3
 
3.4%
고양특례시 2
 
2.2%
민선8기 2
 
2.2%
고양행주문화제 2
 
2.2%
고양국제꽃박람회 2
 
2.2%
개막식 2
 
2.2%
개관식 2
 
2.2%
세계태권도품새선수권대회 2
 
2.2%
Other values (54) 61
68.5%
2023-12-12T23:42:49.994011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
59
 
13.3%
2 27
 
6.1%
고 19
 
4.3%
양 18
 
4.1%
식 14
 
3.2%
제 13
 
2.9%
시 12
 
2.7%
0 9
 
2.0%
회 9
 
2.0%
무 8
 
1.8%
Other values (109) 256
57.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 328
73.9%
Space Separator 59
 
13.3%
Decimal Number 49
 
11.0%
Dash Punctuation 5
 
1.1%
Uppercase Letter 3
 
0.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
고 19
 
5.8%
양 18
 
5.5%
식 14
 
4.3%
제 13
 
4.0%
시 12
 
3.7%
회 9
 
2.7%
무 8
 
2.4%
인 7
 
2.1%
특 7
 
2.1%
례 7
 
2.1%
Other values (96) 214
65.2%
Decimal Number
ValueCountFrequency (%)
2 27
55.1%
0 9
 
18.4%
7 3
 
6.1%
6 2
 
4.1%
8 2
 
4.1%
3 2
 
4.1%
4 2
 
4.1%
1 2
 
4.1%
Uppercase Letter
ValueCountFrequency (%)
M 1
33.3%
B 1
33.3%
N 1
33.3%
Space Separator
ValueCountFrequency (%)
59
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 328
73.9%
Common 113
 
25.5%
Latin 3
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
고 19
 
5.8%
양 18
 
5.5%
식 14
 
4.3%
제 13
 
4.0%
시 12
 
3.7%
회 9
 
2.7%
무 8
 
2.4%
인 7
 
2.1%
특 7
 
2.1%
례 7
 
2.1%
Other values (96) 214
65.2%
Common
ValueCountFrequency (%)
59
52.2%
2 27
23.9%
0 9
 
8.0%
- 5
 
4.4%
7 3
 
2.7%
6 2
 
1.8%
8 2
 
1.8%
3 2
 
1.8%
4 2
 
1.8%
1 2
 
1.8%
Latin
ValueCountFrequency (%)
M 1
33.3%
B 1
33.3%
N 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 328
73.9%
ASCII 116
 
26.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
59
50.9%
2 27
23.3%
0 9
 
7.8%
- 5
 
4.3%
7 3
 
2.6%
6 2
 
1.7%
8 2
 
1.7%
3 2
 
1.7%
4 2
 
1.7%
1 2
 
1.7%
Other values (3) 3
 
2.6%
Hangul
ValueCountFrequency (%)
고 19
 
5.8%
양 18
 
5.5%
식 14
 
4.3%
제 13
 
4.0%
시 12
 
3.7%
회 9
 
2.7%
무 8
 
2.4%
인 7
 
2.1%
특 7
 
2.1%
례 7
 
2.1%
Other values (96) 214
65.2%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

Interactions

2023-12-12T23:42:48.101867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:42:50.126897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호촬영일자내용
번호1.0000.9761.000
촬영일자0.9761.0001.000
내용1.0001.0001.000

Missing values

2023-12-12T23:42:48.542966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:42:48.678991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

번호시군구촬영일자내용Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7
01고양시2022-01-01행주산성 일출<NA><NA><NA><NA>
12고양시2022-01-032022년 시무식 및 제7대 박원석 제1부시장 취임식<NA><NA><NA><NA>
23고양시2022-01-03현충탑 참배<NA><NA><NA><NA>
34고양시2022-01-13고양특례시 출범 선포식<NA><NA><NA><NA>
45고양시2022-01-13고양특례시 표지석 제막식<NA><NA><NA><NA>
56고양시2022-02-032022 고양 세계태권도품새선수권대회 고양시 행정지원단 발대식<NA><NA><NA><NA>
67고양시2022-03-17고양시 고봉동 커뮤니티센터 개관식<NA><NA><NA><NA>
78고양시2022-03-19행주가 예술이야<NA><NA><NA><NA>
89고양시2022-04-212022 고양 세계태권도품새선수권대회 개막식<NA><NA><NA><NA>
910고양시2022-04-212022 고양국제꽃박람회<NA><NA><NA><NA>
번호시군구촬영일자내용Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7
2021고양시2022-07-20삼송 MBN 스튜디오 개관식<NA><NA><NA><NA>
2122고양시2022-09-28행주대교-무인항공촬영<NA><NA><NA><NA>
2223고양시2022-09-29대화동-무인항공촬영<NA><NA><NA><NA>
2324고양시2022-09-302022 고양가을꽃축제<NA><NA><NA><NA>
2425고양시2022-10-012022 고양가을꽃축제-무인항공촬영<NA><NA><NA><NA>
2526고양시2022-10-012022 고양특례시민의 날 기념식<NA><NA><NA><NA>
2627고양시2022-10-12서삼릉-무인항공촬영<NA><NA><NA><NA>
2728고양시2022-10-12서오릉-무인항공촬영<NA><NA><NA><NA>
2829고양시2022-12-14간부회의<NA><NA><NA><NA>
2930고양시2022-12-302022년 종무식<NA><NA><NA><NA>