Overview

Dataset statistics

Number of variables13
Number of observations21
Missing cells36
Missing cells (%)13.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory110.3 B

Variable types

Text1
Unsupported12

Dataset

Description시도별이동전화위치정보조회신고처리현황20158
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202562

Alerts

Unnamed: 1 has 1 (4.8%) missing valuesMissing
Unnamed: 2 has 1 (4.8%) missing valuesMissing
Unnamed: 3 has 1 (4.8%) missing valuesMissing
Unnamed: 4 has 2 (9.5%) missing valuesMissing
Unnamed: 5 has 2 (9.5%) missing valuesMissing
Unnamed: 6 has 2 (9.5%) missing valuesMissing
Unnamed: 7 has 1 (4.8%) missing valuesMissing
Unnamed: 8 has 2 (9.5%) missing valuesMissing
Unnamed: 9 has 3 (14.3%) missing valuesMissing
Unnamed: 10 has 1 (4.8%) missing valuesMissing
Unnamed: 11 has 1 (4.8%) missing valuesMissing
Unnamed: 12 has 19 (90.5%) missing valuesMissing
이동전화 위치정보 조회 신고 처리실적('15년 8월말 기준) has unique valuesUnique
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 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

Reproduction

Analysis started2024-03-13 23:57:12.569474
Analysis finished2024-03-13 23:57:13.051150
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
2024-03-14T08:57:13.137477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length2
Mean length3.1904762
Min length1

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)100.0%

Sample

1st row기 간 : 2015. 1. 1 ~ 8. 31.
2nd row구분
3rd row
4th row서울
5th row부산
ValueCountFrequency (%)
2
 
6.9%
1 2
 
6.9%
1
 
3.4%
울산 1
 
3.4%
제주 1
 
3.4%
경남 1
 
3.4%
경북 1
 
3.4%
전남 1
 
3.4%
전북 1
 
3.4%
충남 1
 
3.4%
Other values (17) 17
58.6%
2024-03-14T08:57:13.374544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11
 
16.4%
1 4
 
6.0%
. 4
 
6.0%
3
 
4.5%
3
 
4.5%
3
 
4.5%
3
 
4.5%
2
 
3.0%
2
 
3.0%
2
 
3.0%
Other values (25) 30
44.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 41
61.2%
Space Separator 11
 
16.4%
Decimal Number 9
 
13.4%
Other Punctuation 5
 
7.5%
Math Symbol 1
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3
 
7.3%
3
 
7.3%
3
 
7.3%
3
 
7.3%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
Other values (15) 17
41.5%
Decimal Number
ValueCountFrequency (%)
1 4
44.4%
3 1
 
11.1%
8 1
 
11.1%
5 1
 
11.1%
0 1
 
11.1%
2 1
 
11.1%
Other Punctuation
ValueCountFrequency (%)
. 4
80.0%
: 1
 
20.0%
Space Separator
ValueCountFrequency (%)
11
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 41
61.2%
Common 26
38.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3
 
7.3%
3
 
7.3%
3
 
7.3%
3
 
7.3%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
Other values (15) 17
41.5%
Common
ValueCountFrequency (%)
11
42.3%
1 4
 
15.4%
. 4
 
15.4%
3 1
 
3.8%
8 1
 
3.8%
~ 1
 
3.8%
5 1
 
3.8%
0 1
 
3.8%
2 1
 
3.8%
: 1
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 41
61.2%
ASCII 26
38.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11
42.3%
1 4
 
15.4%
. 4
 
15.4%
3 1
 
3.8%
8 1
 
3.8%
~ 1
 
3.8%
5 1
 
3.8%
0 1
 
3.8%
2 1
 
3.8%
: 1
 
3.8%
Hangul
ValueCountFrequency (%)
3
 
7.3%
3
 
7.3%
3
 
7.3%
3
 
7.3%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
2
 
4.9%
Other values (15) 17
41.5%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)9.5%
Memory size300.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)9.5%
Memory size300.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)9.5%
Memory size300.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)9.5%
Memory size300.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)14.3%
Memory size300.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)4.8%
Memory size300.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing19
Missing (%)90.5%
Memory size300.0 B

Missing values

2024-03-14T08:57:12.663037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T08:57:12.792906image/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.
2024-03-14T08:57:12.935502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

이동전화 위치정보 조회 신고 처리실적('15년 8월말 기준)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
0기 간 : 2015. 1. 1 ~ 8. 31.NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구분구조사체발견수색중\n연락됨자체귀가타기관\n인계가족발견\n(가족연락)미 발견신고취소\n(구조거부)조회실패기타전년도 동기간 처리건수(계)
2170951273681298728190742834161628207042790
3서울439916334601981766813333694671162NaN
4부산17494858361922775881174420NaN
5대구713222335710010124121352NaN
6인천543372462212210861911782NaN
7광주37182NaN823418NaN49259NaN
8대전7943631223541272093113205NaN
9울산4111832014181848161210NaN
이동전화 위치정보 조회 신고 처리실적('15년 8월말 기준)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12
11경기30692682120217072817286102232530NaN
12강원104918841535100901434672356NaN
13충북62092685381069632076125NaN
14충남9107736612129166129129388NaN
15전북526561216544644852238NaN
16전남59679530191932090012634NaN
17경북6289438128516207181112NaN
18경남201333191521113174345NaN
19제주2241218NaNNaN10NaNNaN19174NaN
20창원224361379144583863NaN