Overview

Dataset statistics

Number of variables4
Number of observations58
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.0 KiB
Average record size in memory35.3 B

Variable types

Numeric1
Text2
Categorical1

Dataset

Description경상남도 사천시 석유판매업 주유소 현황 자료입니다.(연번, 상호명, 도로명주소), 2023년 6월 1일 기준으로 총 58개 업소
URLhttps://www.data.go.kr/data/15114251/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
상호 has unique valuesUnique
소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:45:04.285820
Analysis finished2023-12-12 14:45:04.704218
Duration0.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean29.5
Minimum1
Maximum58
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size654.0 B
2023-12-12T23:45:04.788777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.85
Q115.25
median29.5
Q343.75
95-th percentile55.15
Maximum58
Range57
Interquartile range (IQR)28.5

Descriptive statistics

Standard deviation16.886879
Coefficient of variation (CV)0.57243656
Kurtosis-1.2
Mean29.5
Median Absolute Deviation (MAD)14.5
Skewness0
Sum1711
Variance285.16667
MonotonicityStrictly increasing
2023-12-12T23:45:04.951450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.7%
45 1
 
1.7%
33 1
 
1.7%
34 1
 
1.7%
35 1
 
1.7%
36 1
 
1.7%
37 1
 
1.7%
38 1
 
1.7%
39 1
 
1.7%
40 1
 
1.7%
Other values (48) 48
82.8%
ValueCountFrequency (%)
1 1
1.7%
2 1
1.7%
3 1
1.7%
4 1
1.7%
5 1
1.7%
6 1
1.7%
7 1
1.7%
8 1
1.7%
9 1
1.7%
10 1
1.7%
ValueCountFrequency (%)
58 1
1.7%
57 1
1.7%
56 1
1.7%
55 1
1.7%
54 1
1.7%
53 1
1.7%
52 1
1.7%
51 1
1.7%
50 1
1.7%
49 1
1.7%

상호
Text

UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-12-12T23:45:05.192040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length17.5
Mean length7.4655172
Min length5

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)100.0%

Sample

1st row정동농협주유소
2nd row노랑주유소
3rd row동백제3주유소
4th row사천신흥주유소
5th row효천산업개발(주) 사천대로주유소
ValueCountFrequency (%)
사천주유소 2
 
3.0%
ym21유통(주 2
 
3.0%
효천산업개발(주 2
 
3.0%
정동농협주유소 1
 
1.5%
서포농협주유소 1
 
1.5%
하남주유소 1
 
1.5%
sk에너지(주)사천역사주유소 1
 
1.5%
삼광주유소 1
 
1.5%
곤명농협곤양지점주유소 1
 
1.5%
인성주유소 1
 
1.5%
Other values (53) 53
80.3%
2023-12-12T23:45:05.608296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 72
16.6%
유 61
 
14.1%
소 57
 
13.2%
) 14
 
3.2%
천 14
 
3.2%
( 14
 
3.2%
사 14
 
3.2%
8
 
1.8%
농 7
 
1.6%
협 7
 
1.6%
Other values (98) 165
38.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 386
89.1%
Close Punctuation 14
 
3.2%
Open Punctuation 14
 
3.2%
Space Separator 8
 
1.8%
Uppercase Letter 6
 
1.4%
Decimal Number 5
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 72
18.7%
유 61
15.8%
소 57
14.8%
천 14
 
3.6%
사 14
 
3.6%
농 7
 
1.8%
협 7
 
1.8%
남 7
 
1.8%
포 6
 
1.6%
동 5
 
1.3%
Other values (88) 136
35.2%
Uppercase Letter
ValueCountFrequency (%)
Y 2
33.3%
M 2
33.3%
S 1
16.7%
K 1
16.7%
Decimal Number
ValueCountFrequency (%)
2 2
40.0%
1 2
40.0%
3 1
20.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Space Separator
ValueCountFrequency (%)
8
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 386
89.1%
Common 41
 
9.5%
Latin 6
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 72
18.7%
유 61
15.8%
소 57
14.8%
천 14
 
3.6%
사 14
 
3.6%
농 7
 
1.8%
협 7
 
1.8%
남 7
 
1.8%
포 6
 
1.6%
동 5
 
1.3%
Other values (88) 136
35.2%
Common
ValueCountFrequency (%)
) 14
34.1%
( 14
34.1%
8
19.5%
2 2
 
4.9%
1 2
 
4.9%
3 1
 
2.4%
Latin
ValueCountFrequency (%)
Y 2
33.3%
M 2
33.3%
S 1
16.7%
K 1
16.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 386
89.1%
ASCII 47
 
10.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 72
18.7%
유 61
15.8%
소 57
14.8%
천 14
 
3.6%
사 14
 
3.6%
농 7
 
1.8%
협 7
 
1.8%
남 7
 
1.8%
포 6
 
1.6%
동 5
 
1.3%
Other values (88) 136
35.2%
ASCII
ValueCountFrequency (%)
) 14
29.8%
( 14
29.8%
8
17.0%
Y 2
 
4.3%
M 2
 
4.3%
2 2
 
4.3%
1 2
 
4.3%
S 1
 
2.1%
K 1
 
2.1%
3 1
 
2.1%

소재지
Text

UNIQUE 

Distinct58
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-12-12T23:45:05.925986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length21.948276
Min length18

Characters and Unicode

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

Unique

Unique58 ?
Unique (%)100.0%

Sample

1st row경상남도 사천시 정동면 상정대로 2540-27
2nd row경상남도 사천시 서포면 서포로 438
3rd row경상남도 사천시 각산로 114 (대방동)
4th row경상남도 사천시 용현면 진삼로 585
5th row경상남도 사천시 사천읍 사천대로 1813
ValueCountFrequency (%)
경상남도 58
20.0%
사천시 58
20.0%
삼천포대교로 12
 
4.1%
사천대로 12
 
4.1%
사천읍 9
 
3.1%
송포동 6
 
2.1%
진삼로 6
 
2.1%
용현면 5
 
1.7%
서포면 4
 
1.4%
서포로 4
 
1.4%
Other values (86) 116
40.0%
2023-12-12T23:45:06.402253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
232
18.2%
천 91
 
7.1%
사 82
 
6.4%
남 66
 
5.2%
상 63
 
4.9%
경 61
 
4.8%
도 58
 
4.6%
시 58
 
4.6%
로 57
 
4.5%
1 41
 
3.2%
Other values (55) 464
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 807
63.4%
Space Separator 232
 
18.2%
Decimal Number 186
 
14.6%
Close Punctuation 23
 
1.8%
Open Punctuation 23
 
1.8%
Dash Punctuation 2
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 91
11.3%
사 82
 
10.2%
남 66
 
8.2%
상 63
 
7.8%
경 61
 
7.6%
도 58
 
7.2%
시 58
 
7.2%
로 57
 
7.1%
동 33
 
4.1%
대 30
 
3.7%
Other values (41) 208
25.8%
Decimal Number
ValueCountFrequency (%)
1 41
22.0%
8 21
11.3%
6 20
10.8%
4 20
10.8%
3 18
9.7%
2 16
 
8.6%
9 16
 
8.6%
7 13
 
7.0%
0 11
 
5.9%
5 10
 
5.4%
Space Separator
ValueCountFrequency (%)
232
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 807
63.4%
Common 466
36.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 91
11.3%
사 82
 
10.2%
남 66
 
8.2%
상 63
 
7.8%
경 61
 
7.6%
도 58
 
7.2%
시 58
 
7.2%
로 57
 
7.1%
동 33
 
4.1%
대 30
 
3.7%
Other values (41) 208
25.8%
Common
ValueCountFrequency (%)
232
49.8%
1 41
 
8.8%
) 23
 
4.9%
( 23
 
4.9%
8 21
 
4.5%
6 20
 
4.3%
4 20
 
4.3%
3 18
 
3.9%
2 16
 
3.4%
9 16
 
3.4%
Other values (4) 36
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 807
63.4%
ASCII 466
36.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
232
49.8%
1 41
 
8.8%
) 23
 
4.9%
( 23
 
4.9%
8 21
 
4.5%
6 20
 
4.3%
4 20
 
4.3%
3 18
 
3.9%
2 16
 
3.4%
9 16
 
3.4%
Other values (4) 36
 
7.7%
Hangul
ValueCountFrequency (%)
천 91
11.3%
사 82
 
10.2%
남 66
 
8.2%
상 63
 
7.8%
경 61
 
7.6%
도 58
 
7.2%
시 58
 
7.2%
로 57
 
7.1%
동 33
 
4.1%
대 30
 
3.7%
Other values (41) 208
25.8%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size596.0 B
2023-06-01
58 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023-06-01 58
100.0%

Length

2023-12-12T23:45:06.558018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:45:06.675421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-06-01 58
100.0%

Interactions

2023-12-12T23:45:04.487895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:45:06.737365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호소재지
연번1.0001.0001.000
상호1.0001.0001.000
소재지1.0001.0001.000

Missing values

2023-12-12T23:45:04.597072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:45:04.673016image/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

연번상호소재지데이터기준일자
01정동농협주유소경상남도 사천시 정동면 상정대로 2540-272023-06-01
12노랑주유소경상남도 사천시 서포면 서포로 4382023-06-01
23동백제3주유소경상남도 사천시 각산로 114 (대방동)2023-06-01
34사천신흥주유소경상남도 사천시 용현면 진삼로 5852023-06-01
45효천산업개발(주) 사천대로주유소경상남도 사천시 사천읍 사천대로 18132023-06-01
56스카이셀프주유소경상남도 사천시 사천읍 사천대로 17972023-06-01
67축동주유소경상남도 사천시 축동면 서삼로 12422023-06-01
78효천산업개발(주) 사천주유소경상남도 사천시 축동면 서삼로 14682023-06-01
89주식회사 승일배춘주유소경상남도 사천시 축동면 두량로 662023-06-01
910용현농협주유소경상남도 사천시 용현면 진삼로 6402023-06-01
연번상호소재지데이터기준일자
4849남일주유소경상남도 사천시 남일로 214 (향촌동)2023-06-01
4950청양주유소경상남도 사천시 남일로 128 (향촌동)2023-06-01
5051사천도매주유소경상남도 사천시 사천읍 사천대로 19862023-06-01
5152삼일주유소경상남도 사천시 삼천포대교로 588 (좌룡동)2023-06-01
5253경서대로주유소경상남도 사천시 곤명면 경서대로 36432023-06-01
5354용장군주유소경상남도 사천시 용현면 사천대로 9362023-06-01
5455(주)월성주유소경상남도 사천시 사남면 사천대로 16542023-06-01
5556목화주유소경상남도 사천시 용현면 사천대로 9162023-06-01
5657남척주유소경상남도 사천시 삼천포대교로 890 (송포동)2023-06-01
5758곤양주유소경상남도 사천시 곤양면 곤양로 942023-06-01