Overview

Dataset statistics

Number of variables6
Number of observations23
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory56.6 B

Variable types

Text1
Numeric3
Categorical2

Dataset

Description대구광역시 달서구_노인인구 현황_20230131
Author대구광역시 달서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=3074876&dataSetDetailId=30748761c107f232692a&provdMethod=FILE

Alerts

담당부서 has constant value ""Constant
기준일자 has constant value ""Constant
계 is highly overall correlated with 남 and 1 other fieldsHigh correlation
남 is highly overall correlated with 계 and 1 other fieldsHigh correlation
여 is highly overall correlated with 계 and 1 other fieldsHigh correlation
동명 has unique valuesUnique
계 has unique valuesUnique
여 has unique valuesUnique

Reproduction

Analysis started2024-04-20 23:48:34.687234
Analysis finished2024-04-20 23:48:37.771752
Duration3.08 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

동명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size312.0 B
2024-04-21T08:48:38.326175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length4
Mean length3.6086957
Min length2

Characters and Unicode

Total characters83
Distinct characters32
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

Unique23 ?
Unique (%)100.0%

Sample

1st row성당동
2nd row두류1.2동
3rd row두류3동
4th row본리동
5th row감삼동
ValueCountFrequency (%)
성당동 1
 
4.3%
월성1동 1
 
4.3%
송현2동 1
 
4.3%
송현1동 1
 
4.3%
도원동 1
 
4.3%
상인3동 1
 
4.3%
상인2동 1
 
4.3%
상인1동 1
 
4.3%
유천동 1
 
4.3%
진천동 1
 
4.3%
Other values (13) 13
56.5%
2024-04-21T08:48:39.204064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 23
27.7%
1 6
 
7.2%
2 6
 
7.2%
성 3
 
3.6%
인 3
 
3.6%
상 3
 
3.6%
당 2
 
2.4%
송 2
 
2.4%
천 2
 
2.4%
월 2
 
2.4%
Other values (22) 31
37.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68
81.9%
Decimal Number 14
 
16.9%
Other Punctuation 1
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 23
33.8%
성 3
 
4.4%
인 3
 
4.4%
상 3
 
4.4%
당 2
 
2.9%
송 2
 
2.9%
천 2
 
2.9%
월 2
 
2.9%
곡 2
 
2.9%
이 2
 
2.9%
Other values (18) 24
35.3%
Decimal Number
ValueCountFrequency (%)
1 6
42.9%
2 6
42.9%
3 2
 
14.3%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68
81.9%
Common 15
 
18.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 23
33.8%
성 3
 
4.4%
인 3
 
4.4%
상 3
 
4.4%
당 2
 
2.9%
송 2
 
2.9%
천 2
 
2.9%
월 2
 
2.9%
곡 2
 
2.9%
이 2
 
2.9%
Other values (18) 24
35.3%
Common
ValueCountFrequency (%)
1 6
40.0%
2 6
40.0%
3 2
 
13.3%
. 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68
81.9%
ASCII 15
 
18.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 23
33.8%
성 3
 
4.4%
인 3
 
4.4%
상 3
 
4.4%
당 2
 
2.9%
송 2
 
2.9%
천 2
 
2.9%
월 2
 
2.9%
곡 2
 
2.9%
이 2
 
2.9%
Other values (18) 24
35.3%
ASCII
ValueCountFrequency (%)
1 6
40.0%
2 6
40.0%
3 2
 
13.3%
. 1
 
6.7%

계
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3897.1739
Minimum1915
Maximum8293
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.0 B
2024-04-21T08:48:39.409615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1915
5-th percentile2085.6
Q12766
median3651
Q34691.5
95-th percentile6389.2
Maximum8293
Range6378
Interquartile range (IQR)1925.5

Descriptive statistics

Standard deviation1505.2108
Coefficient of variation (CV)0.38623135
Kurtosis2.0316802
Mean3897.1739
Median Absolute Deviation (MAD)998
Skewness1.2472591
Sum89635
Variance2265659.4
MonotonicityNot monotonic
2024-04-21T08:48:39.835270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
5006 1
 
4.3%
3468 1
 
4.3%
2771 1
 
4.3%
4678 1
 
4.3%
4326 1
 
4.3%
6467 1
 
4.3%
3651 1
 
4.3%
3359 1
 
4.3%
5689 1
 
4.3%
1915 1
 
4.3%
Other values (13) 13
56.5%
ValueCountFrequency (%)
1915 1
4.3%
2047 1
4.3%
2433 1
4.3%
2624 1
4.3%
2653 1
4.3%
2761 1
4.3%
2771 1
4.3%
2938 1
4.3%
3275 1
4.3%
3359 1
4.3%
ValueCountFrequency (%)
8293 1
4.3%
6467 1
4.3%
5689 1
4.3%
5006 1
4.3%
4845 1
4.3%
4705 1
4.3%
4678 1
4.3%
4326 1
4.3%
4021 1
4.3%
4010 1
4.3%

남
Real number (ℝ)

HIGH CORRELATION 

Distinct22
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1696.6087
Minimum839
Maximum3627
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.0 B
2024-04-21T08:48:40.041137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum839
5-th percentile892.8
Q11260.5
median1519
Q31933
95-th percentile2854.2
Maximum3627
Range2788
Interquartile range (IQR)672.5

Descriptive statistics

Standard deviation656.84997
Coefficient of variation (CV)0.38715467
Kurtosis2.3024203
Mean1696.6087
Median Absolute Deviation (MAD)373
Skewness1.3368076
Sum39022
Variance431451.89
MonotonicityNot monotonic
2024-04-21T08:48:40.241590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=22)
ValueCountFrequency (%)
1476 2
 
8.7%
2164 1
 
4.3%
1416 1
 
4.3%
1126 1
 
4.3%
1961 1
 
4.3%
1915 1
 
4.3%
2888 1
 
4.3%
1519 1
 
4.3%
2550 1
 
4.3%
839 1
 
4.3%
Other values (12) 12
52.2%
ValueCountFrequency (%)
839 1
4.3%
873 1
4.3%
1071 1
4.3%
1126 1
4.3%
1146 1
4.3%
1247 1
4.3%
1274 1
4.3%
1329 1
4.3%
1416 1
4.3%
1476 2
8.7%
ValueCountFrequency (%)
3627 1
4.3%
2888 1
4.3%
2550 1
4.3%
2164 1
4.3%
1961 1
4.3%
1951 1
4.3%
1915 1
4.3%
1871 1
4.3%
1819 1
4.3%
1813 1
4.3%

여
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2200.5652
Minimum1076
Maximum4666
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size335.0 B
2024-04-21T08:48:40.442103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1076
5-th percentile1192.8
Q11558
median2029
Q32735.5
95-th percentile3535
Maximum4666
Range3590
Interquartile range (IQR)1177.5

Descriptive statistics

Standard deviation856.26222
Coefficient of variation (CV)0.38911013
Kurtosis1.7022632
Mean2200.5652
Median Absolute Deviation (MAD)542
Skewness1.1625575
Sum50613
Variance733184.98
MonotonicityNot monotonic
2024-04-21T08:48:40.655342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
2842 1
 
4.3%
1992 1
 
4.3%
1645 1
 
4.3%
2717 1
 
4.3%
2411 1
 
4.3%
3579 1
 
4.3%
2132 1
 
4.3%
1883 1
 
4.3%
3139 1
 
4.3%
1076 1
 
4.3%
Other values (13) 13
56.5%
ValueCountFrequency (%)
1076 1
4.3%
1174 1
4.3%
1362 1
4.3%
1377 1
4.3%
1487 1
4.3%
1507 1
4.3%
1609 1
4.3%
1645 1
4.3%
1859 1
4.3%
1883 1
4.3%
ValueCountFrequency (%)
4666 1
4.3%
3579 1
4.3%
3139 1
4.3%
2974 1
4.3%
2842 1
4.3%
2754 1
4.3%
2717 1
4.3%
2411 1
4.3%
2208 1
4.3%
2191 1
4.3%

담당부서
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size312.0 B
대구광역시 달서구 어르신장애인과
23 

Length

Max length17
Median length17
Mean length17
Min length17

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구광역시 달서구 어르신장애인과
2nd row대구광역시 달서구 어르신장애인과
3rd row대구광역시 달서구 어르신장애인과
4th row대구광역시 달서구 어르신장애인과
5th row대구광역시 달서구 어르신장애인과

Common Values

ValueCountFrequency (%)
대구광역시 달서구 어르신장애인과 23
100.0%

Length

2024-04-21T08:48:40.874903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T08:48:41.027266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구광역시 23
33.3%
달서구 23
33.3%
어르신장애인과 23
33.3%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size312.0 B
2023-01-31
23 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-01-31
2nd row2023-01-31
3rd row2023-01-31
4th row2023-01-31
5th row2023-01-31

Common Values

ValueCountFrequency (%)
2023-01-31 23
100.0%

Length

2024-04-21T08:48:41.185701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T08:48:41.333393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-01-31 23
100.0%

Interactions

2024-04-21T08:48:36.465004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:34.920452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:35.737130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:36.717795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:35.177491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:35.980083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:36.959481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:35.475578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T08:48:36.215956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T08:48:41.432323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동명계남여
동명1.0001.0001.0001.000
계1.0001.0000.9980.995
남1.0000.9981.0000.989
여1.0000.9950.9891.000
2024-04-21T08:48:41.682444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
계남여
계1.0000.9850.996
남0.9851.0000.974
여0.9960.9741.000

Missing values

2024-04-21T08:48:37.300622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T08:48:37.642473image/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

동명계남여담당부서기준일자
0성당동500621642842대구광역시 달서구 어르신장애인과2023-01-31
1두류1.2동346814761992대구광역시 달서구 어르신장애인과2023-01-31
2두류3동20478731174대구광역시 달서구 어르신장애인과2023-01-31
3본리동276112741487대구광역시 달서구 어르신장애인과2023-01-31
4감삼동401018192191대구광역시 달서구 어르신장애인과2023-01-31
5죽전동243310711362대구광역시 달서구 어르신장애인과2023-01-31
6장기동265311461507대구광역시 달서구 어르신장애인과2023-01-31
7용산1동402118132208대구광역시 달서구 어르신장애인과2023-01-31
8용산2동370016712029대구광역시 달서구 어르신장애인과2023-01-31
9이곡1동293813291609대구광역시 달서구 어르신장애인과2023-01-31
동명계남여담당부서기준일자
13월성2동484518712974대구광역시 달서구 어르신장애인과2023-01-31
14진천동829336274666대구광역시 달서구 어르신장애인과2023-01-31
15유천동19158391076대구광역시 달서구 어르신장애인과2023-01-31
16상인1동568925503139대구광역시 달서구 어르신장애인과2023-01-31
17상인2동335914761883대구광역시 달서구 어르신장애인과2023-01-31
18상인3동365115192132대구광역시 달서구 어르신장애인과2023-01-31
19도원동646728883579대구광역시 달서구 어르신장애인과2023-01-31
20송현1동432619152411대구광역시 달서구 어르신장애인과2023-01-31
21송현2동467819612717대구광역시 달서구 어르신장애인과2023-01-31
22본동277111261645대구광역시 달서구 어르신장애인과2023-01-31