Overview

Dataset statistics

Number of variables4
Number of observations333
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.2 KiB
Average record size in memory34.4 B

Variable types

Numeric2
Categorical1
Text1

Dataset

Description동물번호,사진종류,사진번호,사진URL
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-21089/S/1/datasetView.do

Alerts

사진URL has unique valuesUnique

Reproduction

Analysis started2024-05-11 05:22:34.798859
Analysis finished2024-05-11 05:22:35.636167
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

동물번호
Real number (ℝ)

Distinct37
Distinct (%)11.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3247.8108
Minimum1121
Maximum3841
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2024-05-11T14:22:35.961051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1121
5-th percentile1142
Q13083
median3541
Q33683
95-th percentile3824
Maximum3841
Range2720
Interquartile range (IQR)600

Descriptive statistics

Standard deviation710.5942
Coefficient of variation (CV)0.21879175
Kurtosis2.6371595
Mean3247.8108
Median Absolute Deviation (MAD)218
Skewness-1.8602358
Sum1081521
Variance504944.12
MonotonicityNot monotonic
2024-05-11T14:22:36.288707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
3823 9
 
2.7%
2704 9
 
2.7%
3685 9
 
2.7%
3682 9
 
2.7%
3681 9
 
2.7%
3643 9
 
2.7%
3441 9
 
2.7%
3841 9
 
2.7%
3361 9
 
2.7%
3821 9
 
2.7%
Other values (27) 243
73.0%
ValueCountFrequency (%)
1121 9
2.7%
1142 9
2.7%
1602 9
2.7%
1864 9
2.7%
2703 9
2.7%
2704 9
2.7%
2862 9
2.7%
3061 9
2.7%
3081 9
2.7%
3083 9
2.7%
ValueCountFrequency (%)
3841 9
2.7%
3824 9
2.7%
3823 9
2.7%
3822 9
2.7%
3821 9
2.7%
3761 9
2.7%
3703 9
2.7%
3702 9
2.7%
3685 9
2.7%
3683 9
2.7%

사진종류
Categorical

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
IMG
296 
THUMB
37 

Length

Max length5
Median length3
Mean length3.2222222
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowTHUMB
2nd rowIMG
3rd rowIMG
4th rowIMG
5th rowIMG

Common Values

ValueCountFrequency (%)
IMG 296
88.9%
THUMB 37
 
11.1%

Length

2024-05-11T14:22:36.579551image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T14:22:36.787033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
img 296
88.9%
thumb 37
 
11.1%

사진번호
Real number (ℝ)

Distinct33
Distinct (%)9.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean9.7687688
Minimum1
Maximum46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.1 KiB
2024-05-11T14:22:36.979108image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median7
Q315
95-th percentile23
Maximum46
Range45
Interquartile range (IQR)12

Descriptive statistics

Standard deviation8.467371
Coefficient of variation (CV)0.86677975
Kurtosis3.4102993
Mean9.7687688
Median Absolute Deviation (MAD)5
Skewness1.5729824
Sum3253
Variance71.696371
MonotonicityNot monotonic
2024-05-11T14:22:37.194531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=33)
ValueCountFrequency (%)
1 34
 
10.2%
2 28
 
8.4%
4 26
 
7.8%
3 24
 
7.2%
5 22
 
6.6%
6 21
 
6.3%
8 21
 
6.3%
7 20
 
6.0%
17 12
 
3.6%
19 10
 
3.0%
Other values (23) 115
34.5%
ValueCountFrequency (%)
1 34
10.2%
2 28
8.4%
3 24
7.2%
4 26
7.8%
5 22
6.6%
6 21
6.3%
7 20
6.0%
8 21
6.3%
9 7
 
2.1%
10 8
 
2.4%
ValueCountFrequency (%)
46 1
 
0.3%
45 1
 
0.3%
44 1
 
0.3%
43 1
 
0.3%
42 1
 
0.3%
41 1
 
0.3%
40 1
 
0.3%
39 1
 
0.3%
25 1
 
0.3%
24 4
1.2%

사진URL
Text

UNIQUE 

Distinct333
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.7 KiB
2024-05-11T14:22:37.700085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length96
Median length93
Mean length93.612613
Min length93

Characters and Unicode

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

Unique

Unique333 ?
Unique (%)100.0%

Sample

1st rowanimal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTTHUMB&fileNo=1&thumbTy=L
2nd rowanimal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=1&thumbTy=L
3rd rowanimal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=2&thumbTy=L
4th rowanimal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=3&thumbTy=L
5th rowanimal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=4&thumbTy=L
ValueCountFrequency (%)
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3823&filety=adoptthumb&fileno=1&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3681&filety=adoptimg&fileno=2&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3441&filety=adoptimg&fileno=12&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3441&filety=adoptimg&fileno=11&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3441&filety=adoptthumb&fileno=3&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3643&filety=adoptimg&fileno=19&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3643&filety=adoptimg&fileno=18&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3643&filety=adoptimg&fileno=17&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3643&filety=adoptimg&fileno=15&thumbty=l 1
 
0.3%
animal.seoul.go.kr/comm/getimage?srvcid=media&upperno=3643&filety=adoptimg&fileno=13&thumbty=l 1
 
0.3%
Other values (323) 323
97.0%
2024-05-11T14:22:38.357750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 1998
 
6.4%
m 1665
 
5.3%
= 1665
 
5.3%
o 1665
 
5.3%
& 1332
 
4.3%
l 1332
 
4.3%
I 1295
 
4.2%
T 1036
 
3.3%
g 999
 
3.2%
r 999
 
3.2%
Other values (40) 17187
55.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 17649
56.6%
Uppercase Letter 6734
 
21.6%
Other Punctuation 3330
 
10.7%
Decimal Number 1795
 
5.8%
Math Symbol 1665
 
5.3%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 1998
 
11.3%
m 1665
 
9.4%
o 1665
 
9.4%
l 1332
 
7.5%
g 999
 
5.7%
r 999
 
5.7%
a 999
 
5.7%
u 999
 
5.7%
i 999
 
5.7%
p 666
 
3.8%
Other values (11) 5328
30.2%
Uppercase Letter
ValueCountFrequency (%)
I 1295
19.2%
T 1036
15.4%
N 666
9.9%
A 666
9.9%
D 666
9.9%
M 666
9.9%
P 333
 
4.9%
O 333
 
4.9%
L 333
 
4.9%
E 333
 
4.9%
Other values (4) 407
 
6.0%
Decimal Number
ValueCountFrequency (%)
3 418
23.3%
1 318
17.7%
2 249
13.9%
6 192
10.7%
8 174
9.7%
4 162
 
9.0%
0 108
 
6.0%
5 79
 
4.4%
7 77
 
4.3%
9 18
 
1.0%
Other Punctuation
ValueCountFrequency (%)
& 1332
40.0%
. 999
30.0%
/ 666
20.0%
? 333
 
10.0%
Math Symbol
ValueCountFrequency (%)
= 1665
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 24383
78.2%
Common 6790
 
21.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 1998
 
8.2%
m 1665
 
6.8%
o 1665
 
6.8%
l 1332
 
5.5%
I 1295
 
5.3%
T 1036
 
4.2%
g 999
 
4.1%
r 999
 
4.1%
a 999
 
4.1%
u 999
 
4.1%
Other values (25) 11396
46.7%
Common
ValueCountFrequency (%)
= 1665
24.5%
& 1332
19.6%
. 999
14.7%
/ 666
 
9.8%
3 418
 
6.2%
? 333
 
4.9%
1 318
 
4.7%
2 249
 
3.7%
6 192
 
2.8%
8 174
 
2.6%
Other values (5) 444
 
6.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 31173
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 1998
 
6.4%
m 1665
 
5.3%
= 1665
 
5.3%
o 1665
 
5.3%
& 1332
 
4.3%
l 1332
 
4.3%
I 1295
 
4.2%
T 1036
 
3.3%
g 999
 
3.2%
r 999
 
3.2%
Other values (40) 17187
55.1%

Interactions

2024-05-11T14:22:35.138642image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:34.945106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:35.239147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T14:22:35.035467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T14:22:38.499179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동물번호사진종류사진번호
동물번호1.0000.0000.822
사진종류0.0001.0000.463
사진번호0.8220.4631.000
2024-05-11T14:22:38.625219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
동물번호사진번호사진종류
동물번호1.000-0.4360.000
사진번호-0.4361.0000.345
사진종류0.0000.3451.000

Missing values

2024-05-11T14:22:35.385324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T14:22:35.511803image/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

동물번호사진종류사진번호사진URL
03823THUMB1animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTTHUMB&fileNo=1&thumbTy=L
13823IMG1animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=1&thumbTy=L
23823IMG2animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=2&thumbTy=L
33823IMG3animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=3&thumbTy=L
43823IMG4animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=4&thumbTy=L
53823IMG5animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=5&thumbTy=L
63823IMG6animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=6&thumbTy=L
73823IMG7animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=7&thumbTy=L
83823IMG8animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=3823&fileTy=ADOPTIMG&fileNo=8&thumbTy=L
91864THUMB6animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1864&fileTy=ADOPTTHUMB&fileNo=6&thumbTy=L
동물번호사진종류사진번호사진URL
3231142IMG46animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1142&fileTy=ADOPTIMG&fileNo=46&thumbTy=L
3241121THUMB1animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTTHUMB&fileNo=1&thumbTy=L
3251121IMG1animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=1&thumbTy=L
3261121IMG2animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=2&thumbTy=L
3271121IMG3animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=3&thumbTy=L
3281121IMG4animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=4&thumbTy=L
3291121IMG5animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=5&thumbTy=L
3301121IMG6animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=6&thumbTy=L
3311121IMG7animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=7&thumbTy=L
3321121IMG8animal.seoul.go.kr/comm/getImage?srvcId=MEDIA&upperNo=1121&fileTy=ADOPTIMG&fileNo=8&thumbTy=L