Overview

Dataset statistics

Number of variables22
Number of observations32
Missing cells291
Missing cells (%)41.3%
Duplicate rows1
Duplicate rows (%)3.1%
Total size in memory5.7 KiB
Average record size in memory181.1 B

Variable types

Text2
Unsupported20

Dataset

Description서산시 월별 인구통계 등록현황으로 읍면동별 인구 및 세대 현황, 인구구조 현황, 연령별 인구현황 , 외국인 현황등에 대한 정보를 제공합니다.
Author충청남도 서산시
URLhttps://www.data.go.kr/data/15000826/fileData.do

Alerts

Dataset has 1 (3.1%) duplicate rowsDuplicates
인구 및 세대현황[읍·면·동 별] has 10 (31.2%) missing valuesMissing
Unnamed: 1 has 11 (34.4%) missing valuesMissing
Unnamed: 2 has 12 (37.5%) missing valuesMissing
Unnamed: 3 has 12 (37.5%) missing valuesMissing
Unnamed: 4 has 11 (34.4%) missing valuesMissing
Unnamed: 5 has 12 (37.5%) missing valuesMissing
Unnamed: 6 has 12 (37.5%) missing valuesMissing
Unnamed: 7 has 11 (34.4%) missing valuesMissing
Unnamed: 8 has 12 (37.5%) missing valuesMissing
Unnamed: 9 has 12 (37.5%) missing valuesMissing
Unnamed: 10 has 12 (37.5%) missing valuesMissing
Unnamed: 11 has 12 (37.5%) missing valuesMissing
Unnamed: 12 has 11 (34.4%) missing valuesMissing
Unnamed: 13 has 12 (37.5%) missing valuesMissing
Unnamed: 14 has 12 (37.5%) missing valuesMissing
Unnamed: 15 has 11 (34.4%) missing valuesMissing
Unnamed: 16 has 32 (100.0%) missing valuesMissing
Unnamed: 17 has 16 (50.0%) missing valuesMissing
Unnamed: 18 has 14 (43.8%) missing valuesMissing
Unnamed: 19 has 15 (46.9%) missing valuesMissing
Unnamed: 20 has 14 (43.8%) missing valuesMissing
Unnamed: 21 has 15 (46.9%) missing valuesMissing
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
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: 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

Reproduction

Analysis started2023-12-12 21:56:07.693478
Analysis finished2023-12-12 21:56:07.825298
Duration0.13 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

인구 및 세대현황[읍·면·동 별]
Text

MISSING 

Distinct22
Distinct (%)100.0%
Missing10
Missing (%)31.2%
Memory size388.0 B
2023-12-13T06:56:07.944574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length3
Mean length4.1363636
Min length2

Characters and Unicode

Total characters91
Distinct characters45
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

Unique22 ?
Unique (%)100.0%

Sample

1st row행정기관 : 충청남도 서산시
2nd row작성기준 : 2021-09-29
3rd row행정기관
4th row합계
5th row대산읍
ValueCountFrequency (%)
행정기관 2
 
7.4%
2
 
7.4%
음암면 1
 
3.7%
면계 1
 
3.7%
읍계 1
 
3.7%
석남동 1
 
3.7%
수석동 1
 
3.7%
동문2동 1
 
3.7%
동문1동 1
 
3.7%
부춘동 1
 
3.7%
Other values (15) 15
55.6%
2023-12-13T06:56:08.319800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
면 10
 
11.0%
동 8
 
8.8%
5
 
5.5%
계 4
 
4.4%
2 4
 
4.4%
기 3
 
3.3%
석 3
 
3.3%
산 3
 
3.3%
문 2
 
2.2%
부 2
 
2.2%
Other values (35) 47
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 72
79.1%
Decimal Number 10
 
11.0%
Space Separator 5
 
5.5%
Dash Punctuation 2
 
2.2%
Other Punctuation 2
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 10
 
13.9%
동 8
 
11.1%
계 4
 
5.6%
기 3
 
4.2%
석 3
 
4.2%
산 3
 
4.2%
문 2
 
2.8%
부 2
 
2.8%
지 2
 
2.8%
읍 2
 
2.8%
Other values (28) 33
45.8%
Decimal Number
ValueCountFrequency (%)
2 4
40.0%
0 2
20.0%
9 2
20.0%
1 2
20.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Other Punctuation
ValueCountFrequency (%)
: 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 72
79.1%
Common 19
 
20.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 10
 
13.9%
동 8
 
11.1%
계 4
 
5.6%
기 3
 
4.2%
석 3
 
4.2%
산 3
 
4.2%
문 2
 
2.8%
부 2
 
2.8%
지 2
 
2.8%
읍 2
 
2.8%
Other values (28) 33
45.8%
Common
ValueCountFrequency (%)
5
26.3%
2 4
21.1%
0 2
 
10.5%
9 2
 
10.5%
- 2
 
10.5%
1 2
 
10.5%
: 2
 
10.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 72
79.1%
ASCII 19
 
20.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
면 10
 
13.9%
동 8
 
11.1%
계 4
 
5.6%
기 3
 
4.2%
석 3
 
4.2%
산 3
 
4.2%
문 2
 
2.8%
부 2
 
2.8%
지 2
 
2.8%
읍 2
 
2.8%
Other values (28) 33
45.8%
ASCII
ValueCountFrequency (%)
5
26.3%
2 4
21.1%
0 2
 
10.5%
9 2
 
10.5%
- 2
 
10.5%
1 2
 
10.5%
: 2
 
10.5%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)34.4%
Memory size388.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)34.4%
Memory size388.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)34.4%
Memory size388.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)34.4%
Memory size388.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing12
Missing (%)37.5%
Memory size388.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing11
Missing (%)34.4%
Memory size388.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing32
Missing (%)100.0%
Memory size420.0 B

Unnamed: 17
Text

MISSING 

Distinct16
Distinct (%)100.0%
Missing16
Missing (%)50.0%
Memory size388.0 B
2023-12-13T06:56:08.513471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length3.0625
Min length2

Characters and Unicode

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

Unique

Unique16 ?
Unique (%)100.0%

Sample

1st row합계
2nd row대산읍
3rd row인지면
4th row부석면
5th row팔봉면
ValueCountFrequency (%)
합계 1
 
6.2%
대산읍 1
 
6.2%
인지면 1
 
6.2%
부석면 1
 
6.2%
팔봉면 1
 
6.2%
지곡면 1
 
6.2%
성연면 1
 
6.2%
음암면 1
 
6.2%
운산면 1
 
6.2%
해미면 1
 
6.2%
Other values (6) 6
37.5%
2023-12-13T06:56:08.859654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
면 9
18.4%
동 7
 
14.3%
석 3
 
6.1%
부 2
 
4.1%
산 2
 
4.1%
지 2
 
4.1%
문 2
 
4.1%
미 1
 
2.0%
고 1
 
2.0%
북 1
 
2.0%
Other values (19) 19
38.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 47
95.9%
Decimal Number 2
 
4.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 9
19.1%
동 7
14.9%
석 3
 
6.4%
부 2
 
4.3%
산 2
 
4.3%
지 2
 
4.3%
문 2
 
4.3%
미 1
 
2.1%
고 1
 
2.1%
북 1
 
2.1%
Other values (17) 17
36.2%
Decimal Number
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 47
95.9%
Common 2
 
4.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 9
19.1%
동 7
14.9%
석 3
 
6.4%
부 2
 
4.3%
산 2
 
4.3%
지 2
 
4.3%
문 2
 
4.3%
미 1
 
2.1%
고 1
 
2.1%
북 1
 
2.1%
Other values (17) 17
36.2%
Common
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 47
95.9%
ASCII 2
 
4.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
면 9
19.1%
동 7
14.9%
석 3
 
6.4%
부 2
 
4.3%
산 2
 
4.3%
지 2
 
4.3%
문 2
 
4.3%
미 1
 
2.1%
고 1
 
2.1%
북 1
 
2.1%
Other values (17) 17
36.2%
ASCII
ValueCountFrequency (%)
1 1
50.0%
2 1
50.0%

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)43.8%
Memory size388.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing15
Missing (%)46.9%
Memory size388.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing14
Missing (%)43.8%
Memory size388.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing15
Missing (%)46.9%
Memory size388.0 B

Sample

인구 및 세대현황[읍·면·동 별]Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
0<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
1<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
2<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
3<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
4<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
5<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
6<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
7행정기관 : 충청남도 서산시NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
8작성기준 : 2021-09-29NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN(단위: 세대, 명)<NA><NA>NaNNaNNaNNaN
9행정기관총계(내국인+외국인)NaNNaN내국인NaNNaN외국인NaNNaN세대수세대당\n인구전월대비 인구,세대수 증감 현황NaNNaNNaN<NA><NA>내국인NaN외국인NaN
인구 및 세대현황[읍·면·동 별]Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21
22부춘동200871037697111961610145947147123124087792.23-4520132118768<NA>부춘동19646-30491-20
23동문1동196891023994501920710009919848223025277652.47-3319722-97774<NA>동문1동19245-38484-2
24동문2동93354740459590324574445830316613743972.05-289363-54402<NA>동문2동9057-25305-2
25수석동1668884478241163278235809236121214971832.273116657187165<NA>수석동1629136367-6
26석남동298191522114598295151509914416304122182116722.53-1029829311669<NA>석남동29524-93004
27<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
28<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN<NA><NA>NaNNaNNaNNaN
29읍계140308029600113838794858901928111169451.9925136513965686877<NA><NA>NaNNaNNaNNaN
30면계69656362153344167589349503263920671265802315242.1440491466951011631408<NA><NA>NaNNaNNaNNaN
31동계9561849023465959369748062456351921961960397962.354433-85957031839778<NA><NA>NaNNaNNaNNaN

Duplicate rows

Most frequently occurring

인구 및 세대현황[읍·면·동 별]Unnamed: 17# duplicates
0<NA><NA>10