Overview

Dataset statistics

Number of variables7
Number of observations243
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.9 KiB
Average record size in memory58.5 B

Variable types

Numeric2
Categorical2
Text2
DateTime1

Dataset

Description전라남도 QR코드관리시스템(페이지 URL을 연결한 QR코드를 임의로 생성하여 등록 관리하는 시스템) 및 연결 에 등록된 QR코드 목록입니다.
Author전라남도
URLhttps://www.data.go.kr/data/15041897/fileData.do

Alerts

시군 is highly overall correlated with 부서High correlation
부서 is highly overall correlated with 시군High correlation
시군 is highly imbalanced (82.5%)Imbalance
연번 has unique valuesUnique
큐알코드주소(QR Code Url) has unique valuesUnique
조회수 has 65 (26.7%) zerosZeros

Reproduction

Analysis started2023-12-12 09:37:13.155336
Analysis finished2023-12-12 09:37:14.428254
Duration1.27 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct243
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean122
Minimum1
Maximum243
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-12T18:37:14.533096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile13.1
Q161.5
median122
Q3182.5
95-th percentile230.9
Maximum243
Range242
Interquartile range (IQR)121

Descriptive statistics

Standard deviation70.292247
Coefficient of variation (CV)0.57616596
Kurtosis-1.2
Mean122
Median Absolute Deviation (MAD)61
Skewness0
Sum29646
Variance4941
MonotonicityStrictly increasing
2023-12-12T18:37:14.713258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
154 1
 
0.4%
156 1
 
0.4%
157 1
 
0.4%
158 1
 
0.4%
159 1
 
0.4%
160 1
 
0.4%
161 1
 
0.4%
162 1
 
0.4%
163 1
 
0.4%
Other values (233) 233
95.9%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
243 1
0.4%
242 1
0.4%
241 1
0.4%
240 1
0.4%
239 1
0.4%
238 1
0.4%
237 1
0.4%
236 1
0.4%
235 1
0.4%
234 1
0.4%

시군
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
전라남도
229 
신안군
 
8
화순군
 
4
진도군
 
1
보성군
 
1

Length

Max length4
Median length4
Mean length3.9423868
Min length3

Unique

Unique2 ?
Unique (%)0.8%

Sample

1st row신안군
2nd row진도군
3rd row보성군
4th row신안군
5th row신안군

Common Values

ValueCountFrequency (%)
전라남도 229
94.2%
신안군 8
 
3.3%
화순군 4
 
1.6%
진도군 1
 
0.4%
보성군 1
 
0.4%

Length

2023-12-12T18:37:14.864866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:37:15.001251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라남도 229
94.2%
신안군 8
 
3.3%
화순군 4
 
1.6%
진도군 1
 
0.4%
보성군 1
 
0.4%

부서
Categorical

HIGH CORRELATION 

Distinct22
Distinct (%)9.1%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
의회
120 
대변인
75 
정보화과
 
8
<NA>
 
8
정보통신과
 
4
Other values (17)
28 

Length

Max length10
Median length9
Mean length2.8971193
Min length2

Unique

Unique9 ?
Unique (%)3.7%

Sample

1st row정보화과
2nd row행정과
3rd row관광과
4th row정보화과
5th row정보화과

Common Values

ValueCountFrequency (%)
의회 120
49.4%
대변인 75
30.9%
정보화과 8
 
3.3%
<NA> 8
 
3.3%
정보통신과 4
 
1.6%
여수소방서 3
 
1.2%
소방행정과 3
 
1.2%
경제통상과 3
 
1.2%
보건한방과 2
 
0.8%
영산호관광농업박물관 2
 
0.8%
Other values (12) 15
 
6.2%

Length

2023-12-12T18:37:15.173480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
의회 120
49.4%
대변인 75
30.9%
정보화과 8
 
3.3%
na 8
 
3.3%
정보통신과 4
 
1.6%
여수소방서 3
 
1.2%
소방행정과 3
 
1.2%
경제통상과 3
 
1.2%
식품유통과 2
 
0.8%
공공디자인과 2
 
0.8%
Other values (12) 15
 
6.2%

큐알(QR) 코드 제목
Text

Distinct204
Distinct (%)84.0%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-12T18:37:15.512149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length19
Mean length5.8312757
Min length1

Characters and Unicode

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

Unique

Unique185 ?
Unique (%)76.1%

Sample

1st row신안군 튤립축제
2nd row진도군
3rd row보성관광
4th row신안군 튤립축제
5th row신안 튤립 축제
ValueCountFrequency (%)
의원 58
 
17.3%
도정뉴스 17
 
5.1%
전라남도 5
 
1.5%
홈페이지 5
 
1.5%
득량역 4
 
1.2%
완도국제해조류박람회 4
 
1.2%
병어축제 3
 
0.9%
산나물 3
 
0.9%
기획취재뉴스 3
 
0.9%
15주 3
 
0.9%
Other values (207) 231
68.8%
2023-12-12T18:37:16.089966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
의 122
 
8.6%
원 121
 
8.5%
94
 
6.6%
도 58
 
4.1%
정 47
 
3.3%
스 35
 
2.5%
뉴 31
 
2.2%
이 27
 
1.9%
남 26
 
1.8%
전 25
 
1.8%
Other values (203) 831
58.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1266
89.3%
Space Separator 94
 
6.6%
Decimal Number 33
 
2.3%
Close Punctuation 7
 
0.5%
Open Punctuation 7
 
0.5%
Lowercase Letter 4
 
0.3%
Other Punctuation 3
 
0.2%
Dash Punctuation 2
 
0.1%
Uppercase Letter 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
의 122
 
9.6%
원 121
 
9.6%
도 58
 
4.6%
정 47
 
3.7%
스 35
 
2.8%
뉴 31
 
2.4%
이 27
 
2.1%
남 26
 
2.1%
전 25
 
2.0%
박 22
 
1.7%
Other values (184) 752
59.4%
Decimal Number
ValueCountFrequency (%)
1 8
24.2%
2 7
21.2%
6 7
21.2%
5 4
12.1%
9 2
 
6.1%
0 2
 
6.1%
8 1
 
3.0%
4 1
 
3.0%
3 1
 
3.0%
Lowercase Letter
ValueCountFrequency (%)
t 2
50.0%
s 1
25.0%
e 1
25.0%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
? 1
33.3%
Space Separator
ValueCountFrequency (%)
94
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Uppercase Letter
ValueCountFrequency (%)
F 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1266
89.3%
Common 146
 
10.3%
Latin 5
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
의 122
 
9.6%
원 121
 
9.6%
도 58
 
4.6%
정 47
 
3.7%
스 35
 
2.8%
뉴 31
 
2.4%
이 27
 
2.1%
남 26
 
2.1%
전 25
 
2.0%
박 22
 
1.7%
Other values (184) 752
59.4%
Common
ValueCountFrequency (%)
94
64.4%
1 8
 
5.5%
2 7
 
4.8%
6 7
 
4.8%
) 7
 
4.8%
( 7
 
4.8%
5 4
 
2.7%
9 2
 
1.4%
. 2
 
1.4%
0 2
 
1.4%
Other values (5) 6
 
4.1%
Latin
ValueCountFrequency (%)
t 2
40.0%
F 1
20.0%
s 1
20.0%
e 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1266
89.3%
ASCII 151
 
10.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
의 122
 
9.6%
원 121
 
9.6%
도 58
 
4.6%
정 47
 
3.7%
스 35
 
2.8%
뉴 31
 
2.4%
이 27
 
2.1%
남 26
 
2.1%
전 25
 
2.0%
박 22
 
1.7%
Other values (184) 752
59.4%
ASCII
ValueCountFrequency (%)
94
62.3%
1 8
 
5.3%
2 7
 
4.6%
6 7
 
4.6%
) 7
 
4.6%
( 7
 
4.6%
5 4
 
2.6%
9 2
 
1.3%
. 2
 
1.3%
t 2
 
1.3%
Other values (9) 11
 
7.3%

큐알코드주소(QR Code Url)
Text

UNIQUE 

Distinct243
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
2023-12-12T18:37:16.447251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length63
Mean length63
Min length63

Characters and Unicode

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

Unique243 ?
Unique (%)100.0%

Sample

1st rowhttp://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=midwvgk
2nd rowhttp://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=exufchp
3rd rowhttp://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=yazlmfk
4th rowhttp://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=ibcxalk
5th rowhttp://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=brvahwp
ValueCountFrequency (%)
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=midwvgk 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=fhnqzkx 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=mkdhpsu 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=vzmhoja 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=dvhjpel 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=osemikg 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=djoviqw 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=gfomewx 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=lsgyhev 1
 
0.4%
http://jnqr.jeonnam.go.kr/mobile/codepreview.php?qrcode=vzxrguh 1
 
0.4%
Other values (233) 233
95.9%
2023-12-12T18:37:17.029880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 1517
 
9.9%
o 1282
 
8.4%
r 1033
 
6.7%
/ 972
 
6.3%
. 972
 
6.3%
p 802
 
5.2%
n 789
 
5.2%
h 566
 
3.7%
i 561
 
3.7%
c 557
 
3.6%
Other values (22) 6258
40.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 12393
81.0%
Other Punctuation 2430
 
15.9%
Uppercase Letter 243
 
1.6%
Math Symbol 243
 
1.6%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 1517
 
12.2%
o 1282
 
10.3%
r 1033
 
8.3%
p 802
 
6.5%
n 789
 
6.4%
h 566
 
4.6%
i 561
 
4.5%
c 557
 
4.5%
m 554
 
4.5%
d 551
 
4.4%
Other values (16) 4181
33.7%
Other Punctuation
ValueCountFrequency (%)
/ 972
40.0%
. 972
40.0%
: 243
 
10.0%
? 243
 
10.0%
Uppercase Letter
ValueCountFrequency (%)
P 243
100.0%
Math Symbol
ValueCountFrequency (%)
= 243
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 12636
82.5%
Common 2673
 
17.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 1517
 
12.0%
o 1282
 
10.1%
r 1033
 
8.2%
p 802
 
6.3%
n 789
 
6.2%
h 566
 
4.5%
i 561
 
4.4%
c 557
 
4.4%
m 554
 
4.4%
d 551
 
4.4%
Other values (17) 4424
35.0%
Common
ValueCountFrequency (%)
/ 972
36.4%
. 972
36.4%
: 243
 
9.1%
? 243
 
9.1%
= 243
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15309
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 1517
 
9.9%
o 1282
 
8.4%
r 1033
 
6.7%
/ 972
 
6.3%
. 972
 
6.3%
p 802
 
5.2%
n 789
 
5.2%
h 566
 
3.7%
i 561
 
3.7%
c 557
 
3.6%
Other values (22) 6258
40.9%

조회수
Real number (ℝ)

ZEROS 

Distinct45
Distinct (%)18.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.971193
Minimum0
Maximum332
Zeros65
Zeros (%)26.7%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-12T18:37:17.234044image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median3
Q310.5
95-th percentile41.5
Maximum332
Range332
Interquartile range (IQR)10.5

Descriptive statistics

Standard deviation34.635815
Coefficient of variation (CV)2.8932633
Kurtosis52.39145
Mean11.971193
Median Absolute Deviation (MAD)3
Skewness6.7315324
Sum2909
Variance1199.6397
MonotonicityNot monotonic
2023-12-12T18:37:17.422994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=45)
ValueCountFrequency (%)
0 65
26.7%
1 33
13.6%
2 19
 
7.8%
3 11
 
4.5%
4 11
 
4.5%
5 9
 
3.7%
6 8
 
3.3%
8 7
 
2.9%
11 7
 
2.9%
7 7
 
2.9%
Other values (35) 66
27.2%
ValueCountFrequency (%)
0 65
26.7%
1 33
13.6%
2 19
 
7.8%
3 11
 
4.5%
4 11
 
4.5%
5 9
 
3.7%
6 8
 
3.3%
7 7
 
2.9%
8 7
 
2.9%
9 6
 
2.5%
ValueCountFrequency (%)
332 1
0.4%
297 1
0.4%
198 1
0.4%
140 1
0.4%
133 1
0.4%
85 1
0.4%
66 1
0.4%
64 1
0.4%
58 1
0.4%
56 1
0.4%

등록일자
Date

Distinct61
Distinct (%)25.1%
Missing0
Missing (%)0.0%
Memory size2.0 KiB
Minimum2011-12-10 00:00:00
Maximum2023-05-19 00:00:00
2023-12-12T18:37:17.615131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:37:17.851729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T18:37:13.920340image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:37:13.650898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:37:14.038840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:37:13.785937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:37:17.973841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시군부서조회수등록일자
연번1.0000.6290.7840.1870.949
시군0.6291.0001.0000.3960.962
부서0.7841.0001.0000.8290.997
조회수0.1870.3960.8291.0000.969
등록일자0.9490.9620.9970.9691.000
2023-12-12T18:37:18.091305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군부서
시군1.0000.965
부서0.9651.000
2023-12-12T18:37:18.202408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번조회수시군부서
연번1.000-0.2620.3070.420
조회수-0.2621.0000.2650.461
시군0.3070.2651.0000.965
부서0.4200.4610.9651.000

Missing values

2023-12-12T18:37:14.202675image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:37:14.362801image/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

연번시군부서큐알(QR) 코드 제목큐알코드주소(QR Code Url)조회수등록일자
01신안군정보화과신안군 튤립축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=midwvgk422011-12-10
12진도군행정과진도군http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=exufchp312011-12-11
23보성군관광과보성관광http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=yazlmfk92011-12-12
34신안군정보화과신안군 튤립축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=ibcxalk132011-12-12
45신안군정보화과신안 튤립 축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=brvahwp132011-12-12
56신안군정보화과신안 병어 축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=jxompnk142011-12-12
67신안군정보화과병어축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=origdhx122011-12-12
78신안군정보화과튤립축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=siumzqy172011-12-12
89신안군정보화과병어축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=otxijeh282011-12-13
910신안군정보화과병어축제http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=swdotfb132011-12-13
연번시군부서큐알(QR) 코드 제목큐알코드주소(QR Code Url)조회수등록일자
233234전라남도여수소방서여수소방서 홈페이지http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=zxperoq322017-01-26
234235전라남도여수소방서유해화학물질자료 - 염산(염화수소)http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=lizpefv102017-03-08
235236전라남도여수소방서연습2http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=osdjury62017-03-13
236237전라남도의회박성재http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=jzxsogw32017-04-13
237238전라남도동부총무과동부지역본부http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=hznkxma162017-07-28
238239전라남도<NA>홍경숙http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=yxizjfh22018-05-15
239240전라남도<NA>홍경숙http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=thfryqz22018-05-15
240241전라남도정보화담당관실전남도청 박미경http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=ndrizuj32018-05-15
241242화순군정보통신과설렘화순버스투어http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=ldjwzkm852019-03-06
242243전라남도전라남도도립도서관전라남도립도서관 전자도서관http://jnqr.jeonnam.go.kr/mobile/codePreview.php?qrcode=hvnrspi112023-05-19