Overview

Dataset statistics

Number of variables38
Number of observations64
Missing cells146
Missing cells (%)6.0%
Duplicate rows4
Duplicate rows (%)6.2%
Total size in memory19.1 KiB
Average record size in memory306.1 B

Variable types

Categorical3
Text1
Unsupported34

Dataset

Description생활폐기물발생현황엑셀
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=203086

Alerts

Dataset has 4 (6.2%) duplicate rowsDuplicates
Unnamed: 1 has 48 (75.0%) missing valuesMissing
Unnamed: 4 has 3 (4.7%) missing valuesMissing
Unnamed: 5 has 2 (3.1%) missing valuesMissing
Unnamed: 6 has 2 (3.1%) missing valuesMissing
Unnamed: 7 has 3 (4.7%) missing valuesMissing
Unnamed: 8 has 3 (4.7%) missing valuesMissing
Unnamed: 9 has 3 (4.7%) missing valuesMissing
Unnamed: 10 has 3 (4.7%) missing valuesMissing
Unnamed: 11 has 3 (4.7%) missing valuesMissing
Unnamed: 12 has 3 (4.7%) missing valuesMissing
Unnamed: 13 has 2 (3.1%) missing valuesMissing
Unnamed: 14 has 3 (4.7%) missing valuesMissing
Unnamed: 15 has 3 (4.7%) missing valuesMissing
Unnamed: 16 has 3 (4.7%) missing valuesMissing
Unnamed: 17 has 3 (4.7%) missing valuesMissing
Unnamed: 18 has 3 (4.7%) missing valuesMissing
Unnamed: 19 has 2 (3.1%) missing valuesMissing
Unnamed: 20 has 3 (4.7%) missing valuesMissing
Unnamed: 21 has 3 (4.7%) missing valuesMissing
Unnamed: 22 has 3 (4.7%) missing valuesMissing
Unnamed: 23 has 3 (4.7%) missing valuesMissing
Unnamed: 24 has 3 (4.7%) missing valuesMissing
Unnamed: 25 has 3 (4.7%) missing valuesMissing
Unnamed: 26 has 3 (4.7%) missing valuesMissing
Unnamed: 27 has 3 (4.7%) missing valuesMissing
Unnamed: 28 has 3 (4.7%) missing valuesMissing
Unnamed: 29 has 3 (4.7%) missing valuesMissing
Unnamed: 30 has 3 (4.7%) missing valuesMissing
Unnamed: 31 has 3 (4.7%) missing valuesMissing
Unnamed: 32 has 3 (4.7%) missing valuesMissing
Unnamed: 33 has 3 (4.7%) missing valuesMissing
Unnamed: 34 has 3 (4.7%) missing valuesMissing
Unnamed: 35 has 3 (4.7%) missing valuesMissing
Unnamed: 36 has 3 (4.7%) missing valuesMissing
Unnamed: 37 has 3 (4.7%) missing valuesMissing
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
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 30 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 31 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 32 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 33 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 34 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 35 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 36 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 37 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:11:20.176372
Analysis finished2024-03-14 01:11:20.316883
Duration0.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

생활 폐기물 발생 및 처리현황 (2017년 말 기준)
Categorical

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
<NA>
47 
전북
15 
구분
 
1
시도
 
1

Length

Max length4
Median length4
Mean length3.46875
Min length2

Unique

Unique2 ?
Unique (%)3.1%

Sample

1st row<NA>
2nd row구분
3rd row<NA>
4th row시도
5th row전북

Common Values

ValueCountFrequency (%)
<NA> 47
73.4%
전북 15
 
23.4%
구분 1
 
1.6%
시도 1
 
1.6%

Length

2024-03-14T10:11:20.617540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:11:20.704379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 47
73.4%
전북 15
 
23.4%
구분 1
 
1.6%
시도 1
 
1.6%

Unnamed: 1
Text

MISSING 

Distinct16
Distinct (%)100.0%
Missing48
Missing (%)75.0%
Memory size644.0 B
2024-03-14T10:11:20.829281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9375
Min length2

Characters and Unicode

Total characters47
Distinct characters27
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16 ?
Unique (%)100.0%

Sample

1st row시군구
2nd row소계
3rd row전주시
4th row군산시
5th row익산시
ValueCountFrequency (%)
시군구 1
 
6.2%
소계 1
 
6.2%
전주시 1
 
6.2%
군산시 1
 
6.2%
익산시 1
 
6.2%
정읍시 1
 
6.2%
남원시 1
 
6.2%
김제시 1
 
6.2%
완주군 1
 
6.2%
진안군 1
 
6.2%
Other values (6) 6
37.5%
2024-03-14T10:11:21.066354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 10
21.3%
시 7
14.9%
주 3
 
6.4%
창 2
 
4.3%
산 2
 
4.3%
안 2
 
4.3%
완 1
 
2.1%
고 1
 
2.1%
순 1
 
2.1%
실 1
 
2.1%
Other values (17) 17
36.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 47
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 10
21.3%
시 7
14.9%
주 3
 
6.4%
창 2
 
4.3%
산 2
 
4.3%
안 2
 
4.3%
완 1
 
2.1%
고 1
 
2.1%
순 1
 
2.1%
실 1
 
2.1%
Other values (17) 17
36.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 47
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 10
21.3%
시 7
14.9%
주 3
 
6.4%
창 2
 
4.3%
산 2
 
4.3%
안 2
 
4.3%
완 1
 
2.1%
고 1
 
2.1%
순 1
 
2.1%
실 1
 
2.1%
Other values (17) 17
36.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 47
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 10
21.3%
시 7
14.9%
주 3
 
6.4%
창 2
 
4.3%
산 2
 
4.3%
안 2
 
4.3%
완 1
 
2.1%
고 1
 
2.1%
순 1
 
2.1%
실 1
 
2.1%
Other values (17) 17
36.2%

Unnamed: 2
Categorical

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
<NA>
33 
발생량
15 
처리방법
15 
발생량 및 처리현황
 
1

Length

Max length10
Median length4
Mean length3.859375
Min length3

Unique

Unique1 ?
Unique (%)1.6%

Sample

1st row<NA>
2nd row발생량 및 처리현황
3rd row<NA>
4th row<NA>
5th row발생량

Common Values

ValueCountFrequency (%)
<NA> 33
51.6%
발생량 15
23.4%
처리방법 15
23.4%
발생량 및 처리현황 1
 
1.6%

Length

2024-03-14T10:11:21.239625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:11:21.325130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 33
50.0%
발생량 16
24.2%
처리방법 15
22.7%
및 1
 
1.5%
처리현황 1
 
1.5%

Unnamed: 3
Categorical

Distinct4
Distinct (%)6.2%
Missing0
Missing (%)0.0%
Memory size644.0 B
<NA>
19 
매립
15 
소각
15 
재활용
15 

Length

Max length4
Median length3
Mean length2.828125
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 19
29.7%
매립 15
23.4%
소각 15
23.4%
재활용 15
23.4%

Length

2024-03-14T10:11:21.420596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T10:11:21.540017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 19
29.7%
매립 15
23.4%
소각 15
23.4%
재활용 15
23.4%

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)3.1%
Memory size644.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)3.1%
Memory size644.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)3.1%
Memory size644.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)3.1%
Memory size644.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 30
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 31
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 32
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 33
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 34
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 35
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 36
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Unnamed: 37
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)4.7%
Memory size644.0 B

Sample

생활 폐기물 발생 및 처리현황 (2017년 말 기준)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37
0<NA><NA><NA><NA>NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1구분<NA>발생량 및 처리현황<NA>총계종량제 방식에 의한 혼합배출NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN재활용가능자원 분리배출NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN음식물류\n폐기물\n분리배출
2<NA><NA><NA><NA>NaN소계가연성NaNNaNNaNNaNNaNNaN불연성NaNNaNNaNNaN기타\n(배출불명등)소계종이류유리병류캔류합성\n수지류플라\n스틱류발포\n수지류전자제품전지류타이어윤활유형광등고철류의류영농\n폐기물가구류폐식용유기타NaN
3시도시군구<NA><NA>NaNNaN소계음식물\n채소류종이류나무류고무 피혁류플라 스틱류기타소계유리류금속류토사류기타NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
4전북소계발생량<NA>1615.6731.8592.549.521020.717.4148.8146.1115.735.427.713.63923.6305.896.324.15.719.262.52.440.40.602.811.62.93918.5015.8578
5<NA><NA>처리방법매립353.9348.9230.113.371.47.39.255.473.5112.63426.813.438.46.20000000000000000005
6<NA><NA><NA>소각352.5352.2332.134.6128.311.46.985.9652.71.10.80.20.617.40000000000000000000.3
7<NA><NA><NA>재활용909.230.730.31.610.321.37.57.60.40.30.1000305.896.324.15.719.262.52.440.40.602.811.62.93918.5015.8572.7
8전북전주시발생량<NA>641.3215.2134.117.1562.51.734.921.961.924.819.87.49.919.2155.676.56.71.25.346.40.70.40.1000.51.12.10.21.8012.6270.5
9<NA><NA>처리방법매립63.963.9000000061.924.819.87.49.920000000000000000000
생활 폐기물 발생 및 처리현황 (2017년 말 기준)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29Unnamed: 30Unnamed: 31Unnamed: 32Unnamed: 33Unnamed: 34Unnamed: 35Unnamed: 36Unnamed: 37
54<NA><NA><NA>소각4.54.54.5010.20.11.41.80000000000000000000000000
55<NA><NA><NA>재활용6.9000000000000002.900.20.10.30000000001.40.9004
56전북고창군발생량<NA>50.115.914.13.34.90.10.15.40.3100.900.10.819.50.10.90.20.60.400.400.10000160.80014.7
57<NA><NA>처리방법매립15.915.914.13.34.90.10.15.40.3100.900.10.80000000000000000000
58<NA><NA><NA>소각0000000000000000000000000000000000
59<NA><NA><NA>재활용34.20000000000000019.50.10.90.20.60.400.400.10000160.80014.7
60전북부안군발생량<NA>44.331.218.70.76.81.61.23.94.59.31.51.42.63.83.260.41.30.20.11.60.1000000.102.1000.17.1
61<NA><NA>처리방법매립13.112.500000009.31.51.42.63.83.20000000000000000000.6
62<NA><NA><NA>소각0000000000000000000000000000000000
63<NA><NA><NA>재활용31.218.718.70.76.81.61.23.94.500000060.41.30.20.11.60.1000000.102.1000.16.5

Duplicate rows

Most frequently occurring

생활 폐기물 발생 및 처리현황 (2017년 말 기준)Unnamed: 1Unnamed: 2Unnamed: 3# duplicates
0<NA><NA>처리방법매립15
1<NA><NA><NA>소각15
2<NA><NA><NA>재활용15
3<NA><NA><NA><NA>2