Overview

Dataset statistics

Number of variables5
Number of observations38
Missing cells38
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.7 KiB
Average record size in memory46.5 B

Variable types

Numeric2
Text2
Unsupported1

Dataset

Description샘플 데이터
Author(재)전남정보문화산업진흥원
URLhttps://kadx.co.kr/opmk/frn/pmumkproductDetail/PMU_a6c5c6e0-eeea-45a3-82cb-ce32c8cebc70/5

Alerts

IMG_URL has 38 (100.0%) missing valuesMissing
FAMP_ID has unique valuesUnique
FMLD_ADDR has unique valuesUnique
PHT_DT has unique valuesUnique
FILE_NM has unique valuesUnique
IMG_URL is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-11 20:14:49.067877
Analysis finished2023-12-11 20:14:50.856923
Duration1.79 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

FAMP_ID
Real number (ℝ)

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7340278.7
Minimum6847675
Maximum12975139
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size474.0 B
2023-12-12T05:14:50.908321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6847675
5-th percentile6850711.8
Q16854075.5
median6856299.5
Q36859939
95-th percentile12974687
Maximum12975139
Range6127464
Interquartile range (IQR)5863.5

Descriptive statistics

Standard deviation1671806.9
Coefficient of variation (CV)0.22775796
Kurtosis9.054058
Mean7340278.7
Median Absolute Deviation (MAD)2956
Skewness3.2526019
Sum2.7893059 × 108
Variance2.7949384 × 1012
MonotonicityNot monotonic
2023-12-12T05:14:51.009403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
6855648 1
 
2.6%
6864429 1
 
2.6%
6852085 1
 
2.6%
6864611 1
 
2.6%
6858812 1
 
2.6%
12974902 1
 
2.6%
6855865 1
 
2.6%
6853125 1
 
2.6%
6858252 1
 
2.6%
6856555 1
 
2.6%
Other values (28) 28
73.7%
ValueCountFrequency (%)
6847675 1
2.6%
6850614 1
2.6%
6850729 1
2.6%
6850738 1
2.6%
6850979 1
2.6%
6851175 1
2.6%
6852085 1
2.6%
6853125 1
2.6%
6853562 1
2.6%
6854046 1
2.6%
ValueCountFrequency (%)
12975139 1
2.6%
12974902 1
2.6%
12974649 1
2.6%
6892829 1
2.6%
6865636 1
2.6%
6864611 1
2.6%
6864429 1
2.6%
6864112 1
2.6%
6863062 1
2.6%
6859970 1
2.6%

FMLD_ADDR
Text

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T05:14:51.195995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length21.947368
Min length20

Characters and Unicode

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

Unique

Unique38 ?
Unique (%)100.0%

Sample

1st row전라남도 무안군 해제면 학송리 634-0
2nd row전라남도 무안군 해제면 용학리 459-0
3rd row전라남도 무안군 해제면 유월리 150-5
4th row전라남도 무안군 해제면 광산리 348-4
5th row전라남도 무안군 해제면 덕산리 137-0
ValueCountFrequency (%)
전라남도 38
20.0%
해제면 38
20.0%
무안군 38
20.0%
석룡리 4
 
2.1%
대사리 4
 
2.1%
양월리 4
 
2.1%
학송리 4
 
2.1%
유월리 3
 
1.6%
만풍리 3
 
1.6%
용학리 2
 
1.1%
Other values (46) 52
27.4%
2023-12-12T05:14:51.480881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
152
18.2%
전 38
 
4.6%
- 38
 
4.6%
라 38
 
4.6%
리 38
 
4.6%
면 38
 
4.6%
제 38
 
4.6%
해 38
 
4.6%
군 38
 
4.6%
안 38
 
4.6%
Other values (35) 340
40.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 494
59.2%
Space Separator 152
 
18.2%
Decimal Number 150
 
18.0%
Dash Punctuation 38
 
4.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 38
 
7.7%
라 38
 
7.7%
리 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%
Decimal Number
ValueCountFrequency (%)
0 24
16.0%
1 22
14.7%
8 18
12.0%
4 17
11.3%
7 16
10.7%
3 14
9.3%
2 11
7.3%
9 11
7.3%
5 10
6.7%
6 7
 
4.7%
Space Separator
ValueCountFrequency (%)
152
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 38
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 494
59.2%
Common 340
40.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 38
 
7.7%
라 38
 
7.7%
리 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%
Common
ValueCountFrequency (%)
152
44.7%
- 38
 
11.2%
0 24
 
7.1%
1 22
 
6.5%
8 18
 
5.3%
4 17
 
5.0%
7 16
 
4.7%
3 14
 
4.1%
2 11
 
3.2%
9 11
 
3.2%
Other values (2) 17
 
5.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 494
59.2%
ASCII 340
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
152
44.7%
- 38
 
11.2%
0 24
 
7.1%
1 22
 
6.5%
8 18
 
5.3%
4 17
 
5.0%
7 16
 
4.7%
3 14
 
4.1%
2 11
 
3.2%
9 11
 
3.2%
Other values (2) 17
 
5.0%
Hangul
ValueCountFrequency (%)
전 38
 
7.7%
라 38
 
7.7%
리 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%

PHT_DT
Real number (ℝ)

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0230492 × 1013
Minimum2.0230328 × 1013
Maximum2.0230608 × 1013
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size474.0 B
2023-12-12T05:14:51.591571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0230328 × 1013
5-th percentile2.0230419 × 1013
Q12.0230419 × 1013
median2.0230419 × 1013
Q32.0230607 × 1013
95-th percentile2.0230608 × 1013
Maximum2.0230608 × 1013
Range2.8001286 × 108
Interquartile range (IQR)1.8804278 × 108

Descriptive statistics

Standard deviation94263455
Coefficient of variation (CV)4.6594741 × 10-6
Kurtosis-1.7209199
Mean2.0230492 × 1013
Median Absolute Deviation (MAD)99414
Skewness0.31253989
Sum7.687587 × 1014
Variance8.8855989 × 1015
MonotonicityNot monotonic
2023-12-12T05:14:51.713195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
20230419112613 1
 
2.6%
20230419123253 1
 
2.6%
20230419094744 1
 
2.6%
20230419122628 1
 
2.6%
20230607094138 1
 
2.6%
20230419104820 1
 
2.6%
20230531033332 1
 
2.6%
20230419024102 1
 
2.6%
20230419033707 1
 
2.6%
20230419041848 1
 
2.6%
Other values (28) 28
73.7%
ValueCountFrequency (%)
20230328100836 1
2.6%
20230419014040 1
2.6%
20230419014150 1
2.6%
20230419024102 1
2.6%
20230419033707 1
2.6%
20230419034033 1
2.6%
20230419040109 1
2.6%
20230419041848 1
2.6%
20230419044639 1
2.6%
20230419051153 1
2.6%
ValueCountFrequency (%)
20230608113701 1
2.6%
20230608103737 1
2.6%
20230608103023 1
2.6%
20230608021338 1
2.6%
20230608021252 1
2.6%
20230608013729 1
2.6%
20230608013133 1
2.6%
20230608011159 1
2.6%
20230607113545 1
2.6%
20230607094250 1
2.6%

FILE_NM
Text

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T05:14:51.891036image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length48
Mean length47.947368
Min length46

Characters and Unicode

Total characters1822
Distinct characters50
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)100.0%

Sample

1st row06855648_전라남도 무안군 해제면 학송리 634-0_230419112613.jpg
2nd row06864112_전라남도 무안군 해제면 용학리 459-0_230419040109.jpg
3rd row06892829_전라남도 무안군 해제면 유월리 150-5_230419122825.jpg
4th row06859970_전라남도 무안군 해제면 광산리 348-4_230419111314.jpg
5th row06853562_전라남도 무안군 해제면 덕산리 137-0_230608113701.jpg
ValueCountFrequency (%)
해제면 38
20.0%
무안군 38
20.0%
양월리 4
 
2.1%
학송리 4
 
2.1%
석룡리 4
 
2.1%
대사리 4
 
2.1%
유월리 3
 
1.6%
만풍리 3
 
1.6%
광산리 2
 
1.1%
용학리 2
 
1.1%
Other values (83) 88
46.3%
2023-12-12T05:14:52.194501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 170
 
9.3%
152
 
8.3%
1 106
 
5.8%
2 101
 
5.5%
3 101
 
5.5%
6 89
 
4.9%
4 83
 
4.6%
8 83
 
4.6%
_ 76
 
4.2%
5 73
 
4.0%
Other values (40) 788
43.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 910
49.9%
Other Letter 494
27.1%
Space Separator 152
 
8.3%
Lowercase Letter 114
 
6.3%
Connector Punctuation 76
 
4.2%
Dash Punctuation 38
 
2.1%
Other Punctuation 38
 
2.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 38
 
7.7%
남 38
 
7.7%
전 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%
Decimal Number
ValueCountFrequency (%)
0 170
18.7%
1 106
11.6%
2 101
11.1%
3 101
11.1%
6 89
9.8%
4 83
9.1%
8 83
9.1%
5 73
8.0%
9 58
 
6.4%
7 46
 
5.1%
Lowercase Letter
ValueCountFrequency (%)
g 38
33.3%
j 38
33.3%
p 38
33.3%
Space Separator
ValueCountFrequency (%)
152
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 76
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 38
100.0%
Other Punctuation
ValueCountFrequency (%)
. 38
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1214
66.6%
Hangul 494
27.1%
Latin 114
 
6.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 38
 
7.7%
남 38
 
7.7%
전 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%
Common
ValueCountFrequency (%)
0 170
14.0%
152
12.5%
1 106
8.7%
2 101
8.3%
3 101
8.3%
6 89
7.3%
4 83
6.8%
8 83
6.8%
_ 76
6.3%
5 73
6.0%
Other values (4) 180
14.8%
Latin
ValueCountFrequency (%)
g 38
33.3%
j 38
33.3%
p 38
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1328
72.9%
Hangul 494
 
27.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 170
12.8%
152
11.4%
1 106
 
8.0%
2 101
 
7.6%
3 101
 
7.6%
6 89
 
6.7%
4 83
 
6.2%
8 83
 
6.2%
_ 76
 
5.7%
5 73
 
5.5%
Other values (7) 294
22.1%
Hangul
ValueCountFrequency (%)
리 38
 
7.7%
남 38
 
7.7%
전 38
 
7.7%
면 38
 
7.7%
제 38
 
7.7%
해 38
 
7.7%
군 38
 
7.7%
안 38
 
7.7%
무 38
 
7.7%
도 38
 
7.7%
Other values (23) 114
23.1%

IMG_URL
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing38
Missing (%)100.0%
Memory size474.0 B

Interactions

2023-12-12T05:14:50.587075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:14:50.201588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:14:50.654170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:14:50.522468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:14:52.276016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
FAMP_IDFMLD_ADDRPHT_DTFILE_NM
FAMP_ID1.0001.0000.0001.000
FMLD_ADDR1.0001.0001.0001.000
PHT_DT0.0001.0001.0001.000
FILE_NM1.0001.0001.0001.000
2023-12-12T05:14:52.359210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
FAMP_IDPHT_DT
FAMP_ID1.000-0.326
PHT_DT-0.3261.000

Missing values

2023-12-12T05:14:50.742948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T05:14:50.824285image/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

FAMP_IDFMLD_ADDRPHT_DTFILE_NMIMG_URL
06855648전라남도 무안군 해제면 학송리 634-02023041911261306855648_전라남도 무안군 해제면 학송리 634-0_230419112613.jpg<NA>
16864112전라남도 무안군 해제면 용학리 459-02023041904010906864112_전라남도 무안군 해제면 용학리 459-0_230419040109.jpg<NA>
26892829전라남도 무안군 해제면 유월리 150-52023041912282506892829_전라남도 무안군 해제면 유월리 150-5_230419122825.jpg<NA>
36859970전라남도 무안군 해제면 광산리 348-42023041911131406859970_전라남도 무안군 해제면 광산리 348-4_230419111314.jpg<NA>
46853562전라남도 무안군 해제면 덕산리 137-02023060811370106853562_전라남도 무안군 해제면 덕산리 137-0_230608113701.jpg<NA>
512975139전라남도 무안군 해제면 만풍리 180-22023032810083612975139_전라남도 무안군 해제면 만풍리 180-2_230328100836.jpg<NA>
612974649전라남도 무안군 해제면 신정리 984-02023041910244612974649_전라남도 무안군 해제면 신정리 984-0_230419102446.jpg<NA>
76855435전라남도 무안군 해제면 학송리 539-32023041911445206855435_전라남도 무안군 해제면 학송리 539-3_230419114452.jpg<NA>
86855335전라남도 무안군 해제면 석룡리 274-42023060801313306855335_전라남도 무안군 해제면 석룡리 274-4_230608013133.jpg<NA>
96850614전라남도 무안군 해제면 산길리 678-22023060702422306850614_전라남도 무안군 해제면 산길리 678-2_230607024223.jpg<NA>
FAMP_IDFMLD_ADDRPHT_DTFILE_NMIMG_URL
286858252전라남도 무안군 해제면 양매리 432-02023041903370706858252_전라남도 무안군 해제면 양매리 432-0_230419033707.jpg<NA>
296864429전라남도 무안군 해제면 용학리 94-12023041912325306864429_전라남도 무안군 해제면 용학리 94-1_230419123253.jpg<NA>
306856555전라남도 무안군 해제면 만풍리 227-12023041904184806856555_전라남도 무안군 해제면 만풍리 227-1_230419041848.jpg<NA>
316850979전라남도 무안군 해제면 천장리 850-302023060711354506850979_전라남도 무안군 해제면 천장리 850-30_230607113545.jpg<NA>
326857641전라남도 무안군 해제면 송석리 888-62023041905230206857641_전라남도 무안군 해제면 송석리 888-6_230419052302.jpg<NA>
336854633전라남도 무안군 해제면 석룡리 741-02023041910395206854633_전라남도 무안군 해제면 석룡리 741-0_230419103952.jpg<NA>
346854171전라남도 무안군 해제면 대사리 278-02023041901404006854171_전라남도 무안군 해제면 대사리 278-0_230419014040.jpg<NA>
356857612전라남도 무안군 해제면 송석리 893-32023041905115306857612_전라남도 무안군 해제면 송석리 893-3_230419051153.jpg<NA>
366850729전라남도 무안군 해제면 양월리 817-192023060702290806850729_전라남도 무안군 해제면 양월리 817-19_230607022908.jpg<NA>
376859846전라남도 무안군 해제면 광산리 803-32023060702061706859846_전라남도 무안군 해제면 광산리 803-3_230607020617.jpg<NA>