Overview

Dataset statistics

Number of variables13
Number of observations2248
Missing cells15736
Missing cells (%)53.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory248.2 KiB
Average record size in memory113.1 B

Variable types

Numeric2
DateTime1
Text1
Categorical2
Unsupported7

Dataset

Description한국방송광고진흥공사에서 관리하는 한국광고박물관의 연간 이용자 데이터로 기준월일, 이용자구분, 단체구분, 이용자수 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15037782/fileData.do

Alerts

Unnamed: 6 has 2248 (100.0%) missing valuesMissing
Unnamed: 7 has 2248 (100.0%) missing valuesMissing
Unnamed: 8 has 2248 (100.0%) missing valuesMissing
Unnamed: 9 has 2248 (100.0%) missing valuesMissing
Unnamed: 10 has 2248 (100.0%) missing valuesMissing
Unnamed: 11 has 2248 (100.0%) missing valuesMissing
Unnamed: 12 has 2248 (100.0%) missing valuesMissing
번호 has unique valuesUnique
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

Reproduction

Analysis started2023-12-12 15:24:10.925662
Analysis finished2023-12-12 15:24:11.827685
Duration0.9 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct2248
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1124.5
Minimum1
Maximum2248
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:24:11.901023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile113.35
Q1562.75
median1124.5
Q31686.25
95-th percentile2135.65
Maximum2248
Range2247
Interquartile range (IQR)1123.5

Descriptive statistics

Standard deviation649.08602
Coefficient of variation (CV)0.5772219
Kurtosis-1.2
Mean1124.5
Median Absolute Deviation (MAD)562
Skewness0
Sum2527876
Variance421312.67
MonotonicityStrictly increasing
2023-12-13T00:24:12.044925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1503 1
 
< 0.1%
1497 1
 
< 0.1%
1498 1
 
< 0.1%
1499 1
 
< 0.1%
1500 1
 
< 0.1%
1501 1
 
< 0.1%
1502 1
 
< 0.1%
1504 1
 
< 0.1%
1495 1
 
< 0.1%
Other values (2238) 2238
99.6%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2248 1
< 0.1%
2247 1
< 0.1%
2246 1
< 0.1%
2245 1
< 0.1%
2244 1
< 0.1%
2243 1
< 0.1%
2242 1
< 0.1%
2241 1
< 0.1%
2240 1
< 0.1%
2239 1
< 0.1%

기준연월
Date

Distinct105
Distinct (%)4.7%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
Minimum2014-01-01 00:00:00
Maximum2023-07-01 00:00:00
2023-12-13T00:24:12.164562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:24:12.315106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일_범위
Text

Distinct89
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
2023-12-13T00:24:12.609879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length6
Mean length6.0720641
Min length2

Characters and Unicode

Total characters13650
Distinct characters12
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3 ?
Unique (%)0.1%

Sample

1st row13일-19일
2nd row13일-19일
3rd row13일-19일
4th row13일-19일
5th row13일-19일
ValueCountFrequency (%)
18일-24일 57
 
2.5%
4일-10일 56
 
2.5%
10일-16일 56
 
2.5%
17일-23일 55
 
2.4%
11일-17일 54
 
2.4%
20일-26일 53
 
2.4%
6일-12일 53
 
2.4%
8일-14일 53
 
2.4%
15일-21일 53
 
2.4%
13일-19일 52
 
2.3%
Other values (79) 1706
75.9%
2023-12-13T00:24:13.117409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
일 3871
28.4%
- 2228
16.3%
1 2217
16.2%
2 1680
12.3%
3 782
 
5.7%
0 468
 
3.4%
4 416
 
3.0%
6 411
 
3.0%
5 395
 
2.9%
9 395
 
2.9%
Other values (2) 787
 
5.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 7551
55.3%
Other Letter 3871
28.4%
Dash Punctuation 2228
 
16.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 2217
29.4%
2 1680
22.2%
3 782
 
10.4%
0 468
 
6.2%
4 416
 
5.5%
6 411
 
5.4%
5 395
 
5.2%
9 395
 
5.2%
7 394
 
5.2%
8 393
 
5.2%
Other Letter
ValueCountFrequency (%)
일 3871
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2228
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 9779
71.6%
Hangul 3871
 
28.4%

Most frequent character per script

Common
ValueCountFrequency (%)
- 2228
22.8%
1 2217
22.7%
2 1680
17.2%
3 782
 
8.0%
0 468
 
4.8%
4 416
 
4.3%
6 411
 
4.2%
5 395
 
4.0%
9 395
 
4.0%
7 394
 
4.0%
Hangul
ValueCountFrequency (%)
일 3871
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 9779
71.6%
Hangul 3871
 
28.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
일 3871
100.0%
ASCII
ValueCountFrequency (%)
- 2228
22.8%
1 2217
22.7%
2 1680
17.2%
3 782
 
8.0%
0 468
 
4.8%
4 416
 
4.3%
6 411
 
4.2%
5 395
 
4.0%
9 395
 
4.0%
7 394
 
4.0%

이용자구분
Categorical

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
청소년
699 
어린이
548 
성인
538 
대학생
463 

Length

Max length3
Median length3
Mean length2.7606762
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row어린이
2nd row어린이
3rd row청소년
4th row청소년
5th row대학생

Common Values

ValueCountFrequency (%)
청소년 699
31.1%
어린이 548
24.4%
성인 538
23.9%
대학생 463
20.6%

Length

2023-12-13T00:24:13.318837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:24:13.452028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청소년 699
31.1%
어린이 548
24.4%
성인 538
23.9%
대학생 463
20.6%

단체구분
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size17.7 KiB
개인
1667 
단체
581 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row단체
3rd row개인
4th row단체
5th row개인

Common Values

ValueCountFrequency (%)
개인 1667
74.2%
단체 581
 
25.8%

Length

2023-12-13T00:24:13.613251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:24:13.810633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 1667
74.2%
단체 581
 
25.8%

이용자수
Real number (ℝ)

Distinct205
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31.919929
Minimum1
Maximum679
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size19.9 KiB
2023-12-13T00:24:14.030043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median13
Q333
95-th percentile133.65
Maximum679
Range678
Interquartile range (IQR)29

Descriptive statistics

Standard deviation54.467187
Coefficient of variation (CV)1.7063693
Kurtosis27.370152
Mean31.919929
Median Absolute Deviation (MAD)10
Skewness4.2399066
Sum71756
Variance2966.6745
MonotonicityNot monotonic
2023-12-13T00:24:14.271830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2 173
 
7.7%
1 153
 
6.8%
3 124
 
5.5%
4 113
 
5.0%
5 96
 
4.3%
6 93
 
4.1%
7 81
 
3.6%
8 74
 
3.3%
9 62
 
2.8%
11 52
 
2.3%
Other values (195) 1227
54.6%
ValueCountFrequency (%)
1 153
6.8%
2 173
7.7%
3 124
5.5%
4 113
5.0%
5 96
4.3%
6 93
4.1%
7 81
3.6%
8 74
3.3%
9 62
 
2.8%
10 50
 
2.2%
ValueCountFrequency (%)
679 1
< 0.1%
595 1
< 0.1%
549 1
< 0.1%
518 1
< 0.1%
394 1
< 0.1%
371 1
< 0.1%
365 1
< 0.1%
331 1
< 0.1%
330 1
< 0.1%
321 1
< 0.1%

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2248
Missing (%)100.0%
Memory size19.9 KiB

Interactions

2023-12-13T00:24:11.370265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:24:11.202935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:24:11.456513image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:24:11.280684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T00:24:14.424458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호기준일_범위이용자구분단체구분이용자수
번호1.0000.7720.0000.0140.077
기준일_범위0.7721.0000.0000.0000.000
이용자구분0.0000.0001.0000.4820.284
단체구분0.0140.0000.4821.0000.452
이용자수0.0770.0000.2840.4521.000
2023-12-13T00:24:14.554279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이용자구분단체구분
이용자구분1.0000.326
단체구분0.3261.000
2023-12-13T00:24:14.671810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호이용자수이용자구분단체구분
번호1.000-0.1650.0000.010
이용자수-0.1651.0000.1850.452
이용자구분0.0000.1851.0000.326
단체구분0.0100.4520.3261.000

Missing values

2023-12-13T00:24:11.593096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:24:11.762502image/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: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
012014-0113일-19일어린이개인86<NA><NA><NA><NA><NA><NA><NA>
122014-0113일-19일어린이단체27<NA><NA><NA><NA><NA><NA><NA>
232014-0113일-19일청소년개인13<NA><NA><NA><NA><NA><NA><NA>
342014-0113일-19일청소년단체32<NA><NA><NA><NA><NA><NA><NA>
452014-0113일-19일대학생개인5<NA><NA><NA><NA><NA><NA><NA>
562014-0113일-19일성인개인99<NA><NA><NA><NA><NA><NA><NA>
672014-0113일-19일성인단체19<NA><NA><NA><NA><NA><NA><NA>
782014-011일-5일어린이개인33<NA><NA><NA><NA><NA><NA><NA>
892014-011일-5일청소년개인18<NA><NA><NA><NA><NA><NA><NA>
9102014-011일-5일청소년단체100<NA><NA><NA><NA><NA><NA><NA>
번호기준연월기준일_범위이용자구분단체구분이용자수Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
223822392023-0717-23일청소년단체22<NA><NA><NA><NA><NA><NA><NA>
223922402023-0717-23일대학생개인2<NA><NA><NA><NA><NA><NA><NA>
224022412023-0717-23일대학생단체16<NA><NA><NA><NA><NA><NA><NA>
224122422023-0717-23일성인개인22<NA><NA><NA><NA><NA><NA><NA>
224222432023-0724-30일어린이개인69<NA><NA><NA><NA><NA><NA><NA>
224322442023-0724-30일어린이단체10<NA><NA><NA><NA><NA><NA><NA>
224422452023-0724-30일청소년개인6<NA><NA><NA><NA><NA><NA><NA>
224522462023-0724-30일대학생개인13<NA><NA><NA><NA><NA><NA><NA>
224622472023-0724-30일대학생단체24<NA><NA><NA><NA><NA><NA><NA>
224722482023-0724-30일성인개인57<NA><NA><NA><NA><NA><NA><NA>