Overview

Dataset statistics

Number of variables23
Number of observations36
Missing cells99
Missing cells (%)12.0%
Duplicate rows1
Duplicate rows (%)2.8%
Total size in memory6.6 KiB
Average record size in memory187.7 B

Variable types

Unsupported22
Text1

Dataset

Description부산광역시북구_주요생필품가격정보_20230817
Author부산광역시 북구
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=15062063

Alerts

Dataset has 1 (2.8%) duplicate rowsDuplicates
대형마트 등 생필품 가격동향(조사일 : 2023.08.17.) has 4 (11.1%) missing valuesMissing
Unnamed: 1 has 2 (5.6%) missing valuesMissing
Unnamed: 2 has 2 (5.6%) missing valuesMissing
Unnamed: 3 has 5 (13.9%) missing valuesMissing
Unnamed: 4 has 5 (13.9%) missing valuesMissing
Unnamed: 5 has 4 (11.1%) missing valuesMissing
Unnamed: 6 has 5 (13.9%) missing valuesMissing
Unnamed: 7 has 4 (11.1%) missing valuesMissing
Unnamed: 8 has 5 (13.9%) missing valuesMissing
Unnamed: 9 has 4 (11.1%) missing valuesMissing
Unnamed: 10 has 5 (13.9%) missing valuesMissing
Unnamed: 11 has 4 (11.1%) missing valuesMissing
Unnamed: 12 has 5 (13.9%) missing valuesMissing
Unnamed: 13 has 4 (11.1%) missing valuesMissing
Unnamed: 14 has 5 (13.9%) missing valuesMissing
Unnamed: 15 has 4 (11.1%) missing valuesMissing
Unnamed: 16 has 5 (13.9%) missing valuesMissing
Unnamed: 17 has 4 (11.1%) missing valuesMissing
Unnamed: 18 has 5 (13.9%) missing valuesMissing
Unnamed: 19 has 4 (11.1%) missing valuesMissing
Unnamed: 20 has 5 (13.9%) missing valuesMissing
Unnamed: 21 has 4 (11.1%) missing valuesMissing
Unnamed: 22 has 5 (13.9%) missing valuesMissing
대형마트 등 생필품 가격동향(조사일 : 2023.08.17.) is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-10 16:34:45.174605
Analysis finished2023-12-10 16:34:45.325434
Duration0.15 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

대형마트 등 생필품 가격동향(조사일 : 2023.08.17.)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 1
Text

MISSING 

Distinct34
Distinct (%)100.0%
Missing2
Missing (%)5.6%
Memory size420.0 B
2023-12-11T01:34:45.520625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length19
Mean length15.294118
Min length2

Characters and Unicode

Total characters520
Distinct characters157
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique34 ?
Unique (%)100.0%

Sample

1st row상승
2nd row하락
3rd row시 장 별
4th row품목(규격 및 단위) 시기
5th row쌀(정미포장미 20㎏)
ValueCountFrequency (%)
1병 4
 
5.1%
10개 3
 
3.8%
500g 3
 
3.8%
pet병 2
 
2.6%
사과(300g정도 1
 
1.3%
1.5ℓ 1
 
1.3%
부엌용세제(참그린1.4㎏1봉리필용 1
 
1.3%
리필용 1
 
1.3%
커피크림(동서 1
 
1.3%
100t 1
 
1.3%
Other values (60) 60
76.9%
2023-12-11T01:34:46.100991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
57
 
11.0%
0 39
 
7.5%
( 34
 
6.5%
) 32
 
6.2%
1 27
 
5.2%
. 12
 
2.3%
g 11
 
2.1%
㎏ 9
 
1.7%
기 9
 
1.7%
2 8
 
1.5%
Other values (147) 282
54.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 246
47.3%
Decimal Number 97
 
18.7%
Space Separator 57
 
11.0%
Open Punctuation 34
 
6.5%
Close Punctuation 32
 
6.2%
Lowercase Letter 17
 
3.3%
Other Punctuation 14
 
2.7%
Other Symbol 14
 
2.7%
Uppercase Letter 8
 
1.5%
Dash Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 9
 
3.7%
정 7
 
2.8%
부 6
 
2.4%
병 6
 
2.4%
용 6
 
2.4%
개 5
 
2.0%
장 5
 
2.0%
도 5
 
2.0%
고 5
 
2.0%
등 4
 
1.6%
Other values (121) 188
76.4%
Decimal Number
ValueCountFrequency (%)
0 39
40.2%
1 27
27.8%
2 8
 
8.2%
5 8
 
8.2%
3 7
 
7.2%
6 3
 
3.1%
8 2
 
2.1%
4 2
 
2.1%
9 1
 
1.0%
Lowercase Letter
ValueCountFrequency (%)
g 11
64.7%
ℓ 4
 
23.5%
m 1
 
5.9%
k 1
 
5.9%
Uppercase Letter
ValueCountFrequency (%)
T 3
37.5%
E 2
25.0%
P 2
25.0%
X 1
 
12.5%
Other Symbol
ValueCountFrequency (%)
㎏ 9
64.3%
㎖ 4
28.6%
㎝ 1
 
7.1%
Other Punctuation
ValueCountFrequency (%)
. 12
85.7%
, 2
 
14.3%
Space Separator
ValueCountFrequency (%)
57
100.0%
Open Punctuation
ValueCountFrequency (%)
( 34
100.0%
Close Punctuation
ValueCountFrequency (%)
) 32
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 253
48.7%
Hangul 246
47.3%
Latin 21
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 9
 
3.7%
정 7
 
2.8%
부 6
 
2.4%
병 6
 
2.4%
용 6
 
2.4%
개 5
 
2.0%
장 5
 
2.0%
도 5
 
2.0%
고 5
 
2.0%
등 4
 
1.6%
Other values (121) 188
76.4%
Common
ValueCountFrequency (%)
57
22.5%
0 39
15.4%
( 34
13.4%
) 32
12.6%
1 27
10.7%
. 12
 
4.7%
㎏ 9
 
3.6%
2 8
 
3.2%
5 8
 
3.2%
3 7
 
2.8%
Other values (9) 20
 
7.9%
Latin
ValueCountFrequency (%)
g 11
52.4%
T 3
 
14.3%
E 2
 
9.5%
P 2
 
9.5%
X 1
 
4.8%
m 1
 
4.8%
k 1
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 256
49.2%
Hangul 246
47.3%
CJK Compat 14
 
2.7%
Letterlike Symbols 4
 
0.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
57
22.3%
0 39
15.2%
( 34
13.3%
) 32
12.5%
1 27
10.5%
. 12
 
4.7%
g 11
 
4.3%
2 8
 
3.1%
5 8
 
3.1%
3 7
 
2.7%
Other values (12) 21
 
8.2%
CJK Compat
ValueCountFrequency (%)
㎏ 9
64.3%
㎖ 4
28.6%
㎝ 1
 
7.1%
Hangul
ValueCountFrequency (%)
기 9
 
3.7%
정 7
 
2.8%
부 6
 
2.4%
병 6
 
2.4%
용 6
 
2.4%
개 5
 
2.0%
장 5
 
2.0%
도 5
 
2.0%
고 5
 
2.0%
등 4
 
1.6%
Other values (121) 188
76.4%
Letterlike Symbols
ValueCountFrequency (%)
ℓ 4
100.0%

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)5.6%
Memory size420.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing4
Missing (%)11.1%
Memory size420.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing5
Missing (%)13.9%
Memory size420.0 B

Sample

대형마트 등 생필품 가격동향(조사일 : 2023.08.17.)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
0NaN상승17 품목NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1NaN하락9 품목NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2NaN<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
3연번시 장 별평균가격NaN전주대비\n증감률탑마트 구포점NaN롯데슈퍼(수정점)NaN북부산농협 \n하나로마트(덕천점)NaN메가마트NaN두배로마트\n(덕천시장 내)NaNGS슈퍼(만덕)NaN홈플러스(금곡점)NaN농협하나로클럽NaN롯데마트NaN
4NaN품목(규격 및 단위) 시기8월2주8월3주NaN8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주8월2주8월3주
51쌀(정미포장미 20㎏)52077.77777852655.5555560.011095438004380052900499005200052000549005490054900549005780057800569005690048800488004990054900
62무(2.0㎏ 1개)3255.5555563343.3333330.026962298029802990299028003200399039903900390034803590299019903980450021902950
73배추(2.0㎏ 1포기)5042.2222225856.6666670.161525598059803990699049004900799059604980598049805980499049904980598044905950
84양파(1.0㎏-잎없는것)3404.44444434500.013381268022403000375030003500296029603000320034803380399039903580358049504450
95대파(1.0㎏(흙대파)3057.7777783333.3333330.090116298029803110499030003500349034903000290024802480399044901980198034903190
대형마트 등 생필품 가격동향(조사일 : 2023.08.17.)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22
2622화장지(뽀삐플러스 35mX30롤)24444.44444423600-0.034545249002490024900249001550014900239002690024500245002150021500359002590014900149003400034000
2723부엌용세제(참그린1.4㎏1봉리필용)5171.1111115161.111111-0.001934461046103490349033904250790079004000400076007600590059004250425054004450
2824간장(오복왕표 0.9ℓ 1병)7358.8888897314.444444-0.00604750075007990799079007500750075008550855075007500599059907500750058005800
2925두부(포장두부 420g(부침용) 1모)2962.2222223228.8888890.090023155015502890289015803980180018001400140029802980499049903980398054905490
3026라면(신라면 120g 1봉지)790804.4444440.018284780780780880750780820820820820820820780780780780780780
3127밀가루(백설표 중력분1등2.5㎏)46204636.6666670.003608535053505350535046004750498049804980498049804980199019904750475046004600
3228설탕(백설표 정백당 1㎏)2387.7777782432.2222220.018613238023802320232019802380248024802400240021802180299029902380238023802380
3329식용유(백설표콩기름1.8ℓ)8422.2222228477.7777780.006596848084809430943069807480798079809500950084808480899089907480748084808480
3430참기름(오뚜기 320㎖ 1병)9173.3333339451.1111110.03028186808680607060706180868010600106001100011000109801098011690116908680868086808680
35※ 농·수·축산물은 규격 및 품질이 다소 다를 수 있습니다 (물가모니터 조사자료입니다)<NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN

Duplicate rows

Most frequently occurring

Unnamed: 1# duplicates
0<NA>2