Overview

Dataset statistics

Number of variables11
Number of observations4416
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory405.5 KiB
Average record size in memory94.0 B

Variable types

Numeric5
Categorical5
DateTime1

Dataset

Description대전광역시 서구 행정동별 연령대별 유동인구현황(기준년, 기준월, 행정동코드, 행정동명, 성별코드, 성별, 연령대코드, 연령대, 유동인구수, 시간당 평균 유동인구수 등) 데이터를 제공합니다.
URLhttps://www.data.go.kr/data/15109034/fileData.do

Alerts

기준년 has constant value ""Constant
데이터생성일자 has constant value ""Constant
성별 is highly overall correlated with 성별코드High correlation
성별코드 is highly overall correlated with 성별High correlation
순번 is highly overall correlated with 기준월High correlation
기준월 is highly overall correlated with 순번High correlation
행정동코드 is highly overall correlated with 행정동명High correlation
연령대코드 is highly overall correlated with 연령대High correlation
행정동명 is highly overall correlated with 행정동코드High correlation
연령대 is highly overall correlated with 연령대코드High correlation
순번 has unique valuesUnique
연령대코드 has 552 (12.5%) zerosZeros

Reproduction

Analysis started2023-12-12 18:34:58.583863
Analysis finished2023-12-12 18:35:03.278022
Duration4.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct4416
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2208.5
Minimum1
Maximum4416
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.9 KiB
2023-12-13T03:35:03.364871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile221.75
Q11104.75
median2208.5
Q33312.25
95-th percentile4195.25
Maximum4416
Range4415
Interquartile range (IQR)2207.5

Descriptive statistics

Standard deviation1274.9337
Coefficient of variation (CV)0.57728491
Kurtosis-1.2
Mean2208.5
Median Absolute Deviation (MAD)1104
Skewness0
Sum9752736
Variance1625456
MonotonicityNot monotonic
2023-12-13T03:35:03.536203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
2944 1
 
< 0.1%
2950 1
 
< 0.1%
2949 1
 
< 0.1%
2948 1
 
< 0.1%
2947 1
 
< 0.1%
2946 1
 
< 0.1%
2945 1
 
< 0.1%
2943 1
 
< 0.1%
2935 1
 
< 0.1%
Other values (4406) 4406
99.8%
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 (%)
4416 1
< 0.1%
4415 1
< 0.1%
4414 1
< 0.1%
4413 1
< 0.1%
4412 1
< 0.1%
4411 1
< 0.1%
4410 1
< 0.1%
4409 1
< 0.1%
4408 1
< 0.1%
4407 1
< 0.1%

기준년
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
2021
4416 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021
2nd row2021
3rd row2021
4th row2021
5th row2021

Common Values

ValueCountFrequency (%)
2021 4416
100.0%

Length

2023-12-13T03:35:03.679845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:35:04.119647image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021 4416
100.0%

기준월
Real number (ℝ)

HIGH CORRELATION 

Distinct12
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.5
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.9 KiB
2023-12-13T03:35:04.239837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13.75
median6.5
Q39.25
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)5.5

Descriptive statistics

Standard deviation3.4524435
Coefficient of variation (CV)0.53114515
Kurtosis-1.2168021
Mean6.5
Median Absolute Deviation (MAD)3
Skewness0
Sum28704
Variance11.919366
MonotonicityIncreasing
2023-12-13T03:35:04.380784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 368
8.3%
2 368
8.3%
3 368
8.3%
4 368
8.3%
5 368
8.3%
6 368
8.3%
7 368
8.3%
8 368
8.3%
9 368
8.3%
10 368
8.3%
Other values (2) 736
16.7%
ValueCountFrequency (%)
1 368
8.3%
2 368
8.3%
3 368
8.3%
4 368
8.3%
5 368
8.3%
6 368
8.3%
7 368
8.3%
8 368
8.3%
9 368
8.3%
10 368
8.3%
ValueCountFrequency (%)
12 368
8.3%
11 368
8.3%
10 368
8.3%
9 368
8.3%
8 368
8.3%
7 368
8.3%
6 368
8.3%
5 368
8.3%
4 368
8.3%
3 368
8.3%

행정동코드
Real number (ℝ)

HIGH CORRELATION 

Distinct23
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.017058 × 109
Minimum3.017051 × 109
Maximum3.017066 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.9 KiB
2023-12-13T03:35:04.539637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.017051 × 109
5-th percentile3.017052 × 109
Q13.017055 × 109
median3.0170582 × 109
Q33.0170597 × 109
95-th percentile3.017065 × 109
Maximum3.017066 × 109
Range15000
Interquartile range (IQR)4700

Descriptive statistics

Standard deviation3916.4761
Coefficient of variation (CV)1.298111 × 10-6
Kurtosis-0.48048227
Mean3.017058 × 109
Median Absolute Deviation (MAD)2200
Skewness0.26146389
Sum1.3323328 × 1013
Variance15338785
MonotonicityNot monotonic
2023-12-13T03:35:04.709388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
3017051000 192
 
4.3%
3017052000 192
 
4.3%
3017066000 192
 
4.3%
3017065000 192
 
4.3%
3017064000 192
 
4.3%
3017063000 192
 
4.3%
3017060000 192
 
4.3%
3017059700 192
 
4.3%
3017059600 192
 
4.3%
3017059000 192
 
4.3%
Other values (13) 2496
56.5%
ValueCountFrequency (%)
3017051000 192
4.3%
3017052000 192
4.3%
3017053000 192
4.3%
3017053500 192
4.3%
3017054000 192
4.3%
3017055000 192
4.3%
3017055500 192
4.3%
3017056000 192
4.3%
3017057000 192
4.3%
3017057500 192
4.3%
ValueCountFrequency (%)
3017066000 192
4.3%
3017065000 192
4.3%
3017064000 192
4.3%
3017063000 192
4.3%
3017060000 192
4.3%
3017059700 192
4.3%
3017059600 192
4.3%
3017059000 192
4.3%
3017058800 192
4.3%
3017058700 192
4.3%

행정동명
Categorical

HIGH CORRELATION 

Distinct23
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
복수동
 
192
도마1동
 
192
도마2동
 
192
정림동
 
192
변동
 
192
Other values (18)
3456 

Length

Max length4
Median length4
Mean length3.4782609
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row복수동
2nd row복수동
3rd row도마1동
4th row도마1동
5th row도마2동

Common Values

ValueCountFrequency (%)
복수동 192
 
4.3%
도마1동 192
 
4.3%
도마2동 192
 
4.3%
정림동 192
 
4.3%
변동 192
 
4.3%
용문동 192
 
4.3%
탄방동 192
 
4.3%
괴정동 192
 
4.3%
가장동 192
 
4.3%
내동 192
 
4.3%
Other values (13) 2496
56.5%

Length

2023-12-13T03:35:04.873130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
복수동 192
 
4.3%
월평1동 192
 
4.3%
만년동 192
 
4.3%
둔산2동 192
 
4.3%
둔산1동 192
 
4.3%
기성동 192
 
4.3%
관저2동 192
 
4.3%
관저1동 192
 
4.3%
가수원동 192
 
4.3%
월평3동 192
 
4.3%
Other values (13) 2496
56.5%

성별코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
f
2208 
m
2208 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowf
2nd rowm
3rd rowf
4th rowm
5th rowf

Common Values

ValueCountFrequency (%)
f 2208
50.0%
m 2208
50.0%

Length

2023-12-13T03:35:05.018412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:35:05.148985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 2208
50.0%
m 2208
50.0%

성별
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
여성
2208 
남성
2208 

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 (%)
여성 2208
50.0%
남성 2208
50.0%

Length

2023-12-13T03:35:05.278930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:35:05.408434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
여성 2208
50.0%
남성 2208
50.0%

연령대코드
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean35
Minimum0
Maximum70
Zeros552
Zeros (%)12.5%
Negative0
Negative (%)0.0%
Memory size38.9 KiB
2023-12-13T03:35:05.527924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q117.5
median35
Q352.5
95-th percentile70
Maximum70
Range70
Interquartile range (IQR)35

Descriptive statistics

Standard deviation22.915473
Coefficient of variation (CV)0.65472781
Kurtosis-1.2381383
Mean35
Median Absolute Deviation (MAD)20
Skewness0
Sum154560
Variance525.11891
MonotonicityNot monotonic
2023-12-13T03:35:05.675921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
0 552
12.5%
10 552
12.5%
20 552
12.5%
30 552
12.5%
40 552
12.5%
50 552
12.5%
60 552
12.5%
70 552
12.5%
ValueCountFrequency (%)
0 552
12.5%
10 552
12.5%
20 552
12.5%
30 552
12.5%
40 552
12.5%
50 552
12.5%
60 552
12.5%
70 552
12.5%
ValueCountFrequency (%)
70 552
12.5%
60 552
12.5%
50 552
12.5%
40 552
12.5%
30 552
12.5%
20 552
12.5%
10 552
12.5%
0 552
12.5%

연령대
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
9세이하
552 
10대
552 
20대
552 
30대
552 
40대
552 
Other values (3)
1656 

Length

Max length5
Median length3
Mean length3.375
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row9세이하
2nd row9세이하
3rd row9세이하
4th row9세이하
5th row9세이하

Common Values

ValueCountFrequency (%)
9세이하 552
12.5%
10대 552
12.5%
20대 552
12.5%
30대 552
12.5%
40대 552
12.5%
50대 552
12.5%
60대 552
12.5%
70세이상 552
12.5%

Length

2023-12-13T03:35:05.853552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:35:06.008980image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
9세이하 552
12.5%
10대 552
12.5%
20대 552
12.5%
30대 552
12.5%
40대 552
12.5%
50대 552
12.5%
60대 552
12.5%
70세이상 552
12.5%

비율
Real number (ℝ)

Distinct1559
Distinct (%)35.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50
Minimum27.53
Maximum72.47
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.9 KiB
2023-12-13T03:35:06.195563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum27.53
5-th percentile43.4875
Q147.45
median50
Q352.55
95-th percentile56.5125
Maximum72.47
Range44.94
Interquartile range (IQR)5.1

Descriptive statistics

Standard deviation4.340761
Coefficient of variation (CV)0.086815219
Kurtosis2.0641122
Mean50
Median Absolute Deviation (MAD)2.55
Skewness-4.7246524 × 10-17
Sum220800
Variance18.842206
MonotonicityNot monotonic
2023-12-13T03:35:06.363210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
50.6 12
 
0.3%
49.4 12
 
0.3%
50.26 11
 
0.2%
49.74 11
 
0.2%
49.05 10
 
0.2%
50.95 10
 
0.2%
51.75 10
 
0.2%
48.25 10
 
0.2%
50.11 9
 
0.2%
50.61 9
 
0.2%
Other values (1549) 4312
97.6%
ValueCountFrequency (%)
27.53 1
< 0.1%
30.51 1
< 0.1%
30.65 1
< 0.1%
31.55 1
< 0.1%
31.56 1
< 0.1%
32.2 1
< 0.1%
32.31 1
< 0.1%
32.73 1
< 0.1%
32.78 1
< 0.1%
33.07 1
< 0.1%
ValueCountFrequency (%)
72.47 1
< 0.1%
69.49 1
< 0.1%
69.35 1
< 0.1%
68.45 1
< 0.1%
68.44 1
< 0.1%
67.8 1
< 0.1%
67.69 1
< 0.1%
67.27 1
< 0.1%
67.22 1
< 0.1%
66.93 1
< 0.1%

데이터생성일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size34.6 KiB
Minimum2023-05-10 00:00:00
Maximum2023-05-10 00:00:00
2023-12-13T03:35:06.497429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:06.629477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T03:35:02.472921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:34:59.555006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.352937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.144567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.835169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.564927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:34:59.701305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.508946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.291166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.953572image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.671806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:34:59.833608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.651085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.433015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.091530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.781649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.009126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.812128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.591423image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.200605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.877214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:00.181528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.007796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:01.727253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:35:02.307963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T03:35:06.752373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번기준월행정동코드행정동명성별코드성별연령대코드연령대비율
순번1.0000.9820.0000.0000.0000.0000.2060.2060.000
기준월0.9821.0000.0000.0000.0000.0000.0000.0000.000
행정동코드0.0000.0001.0001.0000.0000.0000.0000.0000.184
행정동명0.0000.0001.0001.0000.0000.0000.0000.0000.479
성별코드0.0000.0000.0000.0001.0001.0000.0000.0000.211
성별0.0000.0000.0000.0001.0001.0000.0000.0000.211
연령대코드0.2060.0000.0000.0000.0000.0001.0001.0000.175
연령대0.2060.0000.0000.0000.0000.0001.0001.0000.175
비율0.0000.0000.1840.4790.2110.2110.1750.1751.000
2023-12-13T03:35:06.894320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별연령대행정동명성별코드
성별1.0000.0000.0001.000
연령대0.0001.0000.0000.000
행정동명0.0000.0001.0000.000
성별코드1.0000.0000.0001.000
2023-12-13T03:35:07.046235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번기준월행정동코드연령대코드비율행정동명성별코드성별연령대
순번1.0000.9970.0100.083-0.0000.0000.0000.0000.099
기준월0.9971.0000.0000.0000.0000.0000.0000.0000.000
행정동코드0.0100.0001.0000.0000.0000.9980.0000.0000.000
연령대코드0.0830.0000.0001.0000.0000.0000.0000.0001.000
비율-0.0000.0000.0000.0001.0000.1980.1620.1620.084
행정동명0.0000.0000.9980.0000.1981.0000.0000.0000.000
성별코드0.0000.0000.0000.0000.1620.0001.0001.0000.000
성별0.0000.0000.0000.0000.1620.0001.0001.0000.000
연령대0.0990.0000.0001.0000.0840.0000.0000.0001.000

Missing values

2023-12-13T03:35:03.054737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:35:03.215702image/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

순번기준년기준월행정동코드행정동명성별코드성별연령대코드연령대비율데이터생성일자
01202113017051000복수동f여성09세이하51.212023-05-10
12202113017051000복수동m남성09세이하48.792023-05-10
23202113017052000도마1동f여성09세이하48.82023-05-10
34202113017052000도마1동m남성09세이하51.22023-05-10
45202113017053000도마2동f여성09세이하51.292023-05-10
56202113017053000도마2동m남성09세이하48.712023-05-10
67202113017053500정림동f여성09세이하51.162023-05-10
78202113017053500정림동m남성09세이하48.842023-05-10
89202113017054000변동f여성09세이하47.532023-05-10
910202113017054000변동m남성09세이하52.472023-05-10
순번기준년기준월행정동코드행정동명성별코드성별연령대코드연령대비율데이터생성일자
440644072021123017060000기성동f여성7070세이상41.512023-05-10
440744082021123017060000기성동m남성7070세이상58.492023-05-10
440844092021123017063000둔산1동f여성7070세이상44.532023-05-10
440944102021123017063000둔산1동m남성7070세이상55.472023-05-10
441044112021123017064000둔산2동f여성7070세이상50.142023-05-10
441144122021123017064000둔산2동m남성7070세이상49.862023-05-10
441244132021123017065000만년동f여성7070세이상49.392023-05-10
441344142021123017065000만년동m남성7070세이상50.612023-05-10
441444152021123017066000둔산3동f여성7070세이상54.022023-05-10
441544162021123017066000둔산3동m남성7070세이상45.982023-05-10