Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory576.2 KiB
Average record size in memory59.0 B

Variable types

Numeric2
Categorical1
Text2
DateTime1

Dataset

Description전라남도_식당이미지1~4 에 대한 설명 데이터(이미지타입, 이미지파일명, 이미지파일경로 등 6개 항목)
Author전라남도
URLhttps://www.data.go.kr/data/15076660/fileData.do

Alerts

이미지ID is highly overall correlated with 식당IDHigh correlation
식당ID is highly overall correlated with 이미지IDHigh correlation
이미지ID has unique valuesUnique
이미지파일명 has unique valuesUnique
이미지파일경로 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:20:32.758277
Analysis finished2023-12-12 22:20:33.994952
Duration1.24 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

이미지ID
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5433.1747
Minimum1
Maximum10876
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:20:34.084041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile544.95
Q12710.75
median5432.5
Q38158.25
95-th percentile10326.05
Maximum10876
Range10875
Interquartile range (IQR)5447.5

Descriptive statistics

Standard deviation3140.5193
Coefficient of variation (CV)0.57802657
Kurtosis-1.2022182
Mean5433.1747
Median Absolute Deviation (MAD)2724
Skewness-0.00026821268
Sum54331747
Variance9862861.6
MonotonicityNot monotonic
2023-12-13T07:20:34.225973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3150 1
 
< 0.1%
3268 1
 
< 0.1%
1817 1
 
< 0.1%
1478 1
 
< 0.1%
981 1
 
< 0.1%
8836 1
 
< 0.1%
2480 1
 
< 0.1%
2014 1
 
< 0.1%
6566 1
 
< 0.1%
8056 1
 
< 0.1%
Other values (9990) 9990
99.9%
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 (%)
10876 1
< 0.1%
10875 1
< 0.1%
10873 1
< 0.1%
10872 1
< 0.1%
10871 1
< 0.1%
10870 1
< 0.1%
10869 1
< 0.1%
10868 1
< 0.1%
10867 1
< 0.1%
10866 1
< 0.1%

식당ID
Real number (ℝ)

HIGH CORRELATION 

Distinct3110
Distinct (%)31.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean747722.47
Minimum2858
Maximum865303
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T07:20:34.379440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2858
5-th percentile182385
Q1857667.75
median858673
Q3859645.25
95-th percentile864246
Maximum865303
Range862445
Interquartile range (IQR)1977.5

Descriptive statistics

Standard deviation222972.64
Coefficient of variation (CV)0.29820241
Kurtosis2.0528139
Mean747722.47
Median Absolute Deviation (MAD)991
Skewness-1.842143
Sum7.4772247 × 109
Variance4.97168 × 1010
MonotonicityNot monotonic
2023-12-13T07:20:34.537552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
176788 19
 
0.2%
597064 19
 
0.2%
859231 15
 
0.1%
858364 13
 
0.1%
671136 13
 
0.1%
862277 13
 
0.1%
156723 12
 
0.1%
858437 12
 
0.1%
496448 12
 
0.1%
864478 11
 
0.1%
Other values (3100) 9861
98.6%
ValueCountFrequency (%)
2858 3
 
< 0.1%
3820 9
0.1%
4419 2
 
< 0.1%
4751 3
 
< 0.1%
5075 3
 
< 0.1%
6215 3
 
< 0.1%
10302 3
 
< 0.1%
11705 2
 
< 0.1%
12433 3
 
< 0.1%
16676 3
 
< 0.1%
ValueCountFrequency (%)
865303 2
< 0.1%
865302 3
< 0.1%
865301 3
< 0.1%
865300 3
< 0.1%
865299 3
< 0.1%
865297 3
< 0.1%
865295 2
< 0.1%
865288 3
< 0.1%
865287 4
< 0.1%
865282 3
< 0.1%

이미지타입
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
3
4296 
1
2853 
2
2851 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row2
3rd row3
4th row2
5th row2

Common Values

ValueCountFrequency (%)
3 4296
43.0%
1 2853
28.5%
2 2851
28.5%

Length

2023-12-13T07:20:34.679229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:20:34.861650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 4296
43.0%
1 2853
28.5%
2 2851
28.5%

이미지파일명
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T07:20:35.108021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length21
Mean length20.4499
Min length16

Characters and Unicode

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

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st row857810_1338589895.jpg
2nd row858536_1405571418.jpg
3rd row863675_473531803.jpg
4th row508684_1194688107.jpg
5th row858487_1216977021.jpg
ValueCountFrequency (%)
857810_1338589895.jpg 1
 
< 0.1%
604256_1128804.jpg 1
 
< 0.1%
857696_1758231153.jpg 1
 
< 0.1%
858135_386631225.jpg 1
 
< 0.1%
528843_746037693.jpg 1
 
< 0.1%
372145_1444485873.jpg 1
 
< 0.1%
351677_1625263592.jpg 1
 
< 0.1%
861925_1673968702.jpg 1
 
< 0.1%
711201_1905698133.jpg 1
 
< 0.1%
857854_265083791.jpg 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-13T07:20:35.515943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8 22575
11.0%
5 18405
 
9.0%
1 17788
 
8.7%
6 14959
 
7.3%
9 14474
 
7.1%
7 13916
 
6.8%
3 13652
 
6.7%
2 13646
 
6.7%
4 12810
 
6.3%
0 12274
 
6.0%
Other values (5) 50000
24.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 154499
75.6%
Lowercase Letter 30000
 
14.7%
Connector Punctuation 10000
 
4.9%
Other Punctuation 10000
 
4.9%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
8 22575
14.6%
5 18405
11.9%
1 17788
11.5%
6 14959
9.7%
9 14474
9.4%
7 13916
9.0%
3 13652
8.8%
2 13646
8.8%
4 12810
8.3%
0 12274
7.9%
Lowercase Letter
ValueCountFrequency (%)
j 10000
33.3%
p 10000
33.3%
g 10000
33.3%
Connector Punctuation
ValueCountFrequency (%)
_ 10000
100.0%
Other Punctuation
ValueCountFrequency (%)
. 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 174499
85.3%
Latin 30000
 
14.7%

Most frequent character per script

Common
ValueCountFrequency (%)
8 22575
12.9%
5 18405
10.5%
1 17788
10.2%
6 14959
8.6%
9 14474
8.3%
7 13916
8.0%
3 13652
7.8%
2 13646
7.8%
4 12810
7.3%
0 12274
7.0%
Other values (2) 20000
11.5%
Latin
ValueCountFrequency (%)
j 10000
33.3%
p 10000
33.3%
g 10000
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 204499
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8 22575
11.0%
5 18405
 
9.0%
1 17788
 
8.7%
6 14959
 
7.3%
9 14474
 
7.1%
7 13916
 
6.8%
3 13652
 
6.7%
2 13646
 
6.7%
4 12810
 
6.3%
0 12274
 
6.0%
Other values (5) 50000
24.4%

이미지파일경로
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T07:20:35.773753image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length39
Mean length38.1611
Min length33

Characters and Unicode

Total characters381611
Distinct characters25
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

Unique10000 ?
Unique (%)100.0%

Sample

1st row2020-11/restaurant/857810_1338589895.jpg
2nd row2020-11/restaurant/858536_1405571418.jpg
3rd row2020-11/menupan/863675_473531803.jpg
4th row2020-11/restaurant/508684_1194688107.jpg
5th row2020-10/restaurant/858487_1216977021.jpg
ValueCountFrequency (%)
2020-11/restaurant/857810_1338589895.jpg 1
 
< 0.1%
2020-11/menupan/604256_1128804.jpg 1
 
< 0.1%
2020-10/restaurant/857696_1758231153.jpg 1
 
< 0.1%
2020-10/restaurant/858135_386631225.jpg 1
 
< 0.1%
2020-10/restaurant/528843_746037693.jpg 1
 
< 0.1%
2020-11/restaurant/372145_1444485873.jpg 1
 
< 0.1%
2020-11/restaurant/351677_1625263592.jpg 1
 
< 0.1%
2020-10/menupan/861925_1673968702.jpg 1
 
< 0.1%
2020-10/menupan/711201_1905698133.jpg 1
 
< 0.1%
2020-11/menupan/857854_265083791.jpg 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-13T07:20:36.250517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 37039
 
9.7%
2 33646
 
8.8%
1 33020
 
8.7%
8 22575
 
5.9%
/ 20000
 
5.2%
5 18405
 
4.8%
a 15704
 
4.1%
6 14959
 
3.9%
9 14477
 
3.8%
n 14296
 
3.7%
Other values (15) 157490
41.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 214499
56.2%
Lowercase Letter 117112
30.7%
Other Punctuation 30000
 
7.9%
Dash Punctuation 10000
 
2.6%
Connector Punctuation 10000
 
2.6%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 15704
13.4%
n 14296
12.2%
p 14296
12.2%
r 11408
9.7%
t 11408
9.7%
u 10000
8.5%
j 10000
8.5%
g 10000
8.5%
e 10000
8.5%
s 5704
 
4.9%
Decimal Number
ValueCountFrequency (%)
0 37039
17.3%
2 33646
15.7%
1 33020
15.4%
8 22575
10.5%
5 18405
8.6%
6 14959
7.0%
9 14477
 
6.7%
7 13916
 
6.5%
3 13652
 
6.4%
4 12810
 
6.0%
Other Punctuation
ValueCountFrequency (%)
/ 20000
66.7%
. 10000
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 10000
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 264499
69.3%
Latin 117112
30.7%

Most frequent character per script

Common
ValueCountFrequency (%)
0 37039
14.0%
2 33646
12.7%
1 33020
12.5%
8 22575
8.5%
/ 20000
7.6%
5 18405
7.0%
6 14959
 
5.7%
9 14477
 
5.5%
7 13916
 
5.3%
3 13652
 
5.2%
Other values (4) 42810
16.2%
Latin
ValueCountFrequency (%)
a 15704
13.4%
n 14296
12.2%
p 14296
12.2%
r 11408
9.7%
t 11408
9.7%
u 10000
8.5%
j 10000
8.5%
g 10000
8.5%
e 10000
8.5%
s 5704
 
4.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 381611
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 37039
 
9.7%
2 33646
 
8.8%
1 33020
 
8.7%
8 22575
 
5.9%
/ 20000
 
5.2%
5 18405
 
4.8%
a 15704
 
4.1%
6 14959
 
3.9%
9 14477
 
3.8%
n 14296
 
3.7%
Other values (15) 157490
41.3%

등록일시
Date

Distinct4387
Distinct (%)43.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-09-25 14:27:00
Maximum2021-01-15 14:47:00
2023-12-13T07:20:36.429270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:20:36.578467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T07:20:33.608018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:20:33.438399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:20:33.711171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:20:33.524148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T07:20:36.687037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이미지ID식당ID이미지타입
이미지ID1.0000.8800.029
식당ID0.8801.0000.033
이미지타입0.0290.0331.000
2023-12-13T07:20:36.770845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
이미지ID식당ID이미지타입
이미지ID1.0001.0000.017
식당ID1.0001.0000.020
이미지타입0.0170.0201.000

Missing values

2023-12-13T07:20:33.838750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:20:33.946687image/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

이미지ID식당ID이미지타입이미지파일명이미지파일경로등록일시
314931508578101857810_1338589895.jpg2020-11/restaurant/857810_1338589895.jpg2020-11-11 16:21
505950608585362858536_1405571418.jpg2020-11/restaurant/858536_1405571418.jpg2020-11-04 18:33
10042100458636753863675_473531803.jpg2020-11/menupan/863675_473531803.jpg2020-11-16 14:28
176217635086842508684_1194688107.jpg2020-11/restaurant/508684_1194688107.jpg2020-11-05 16:45
491649178584872858487_1216977021.jpg2020-10/restaurant/858487_1216977021.jpg2020-10-28 10:50
707370748592342859234_395752285.jpg2020-11/restaurant/859234_395752285.jpg2020-11-16 16:01
784478458595121859512_428248251.jpg2020-11/restaurant/859512_428248251.jpg2020-11-04 17:25
827582778596972859697_2080229762.jpg2020-11/restaurant/859697_2080229762.jpg2020-11-13 13:31
301030118577652857765_1177762918.jpg2020-10/restaurant/857765_1177762918.jpg2020-10-15 9:52
436443658582903858290_1093685922.jpg2020-11/menupan/858290_1093685922.jpg2020-11-10 14:59
이미지ID식당ID이미지타입이미지파일명이미지파일경로등록일시
268026818576591857659_1397690308.jpg2020-11/restaurant/857659_1397690308.jpg2020-11-10 21:38
646764688590393859039_2032848590.jpg2020-11/menupan/859039_2032848590.jpg2020-11-19 13:25
895289558620163862016_1576654483.jpg2020-10/menupan/862016_1576654483.jpg2020-10-13 17:54
389038918581061858106_373266873.jpg2020-11/restaurant/858106_373266873.jpg2020-11-19 18:01
966696698628751862875_1105236078.jpg2020-11/restaurant/862875_1105236078.jpg2020-11-11 13:14
965496578628613862861_245686932.jpg2020-11/menupan/862861_245686932.jpg2020-11-11 11:02
506550668585382858538_764159161.jpg2020-10/restaurant/858538_764159161.jpg2020-10-08 17:08
728572868592983859298_1304346661.jpg2020-11/menupan/859298_1304346661.jpg2020-11-13 16:02
468346848583793858379_1679448907.jpg2020-10/menupan/858379_1679448907.jpg2020-10-19 15:40
408740888581853858185_775435674.jpg2020-11/menupan/858185_775435674.jpg2020-11-23 11:12