Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 119592 |
| Missing cells (%) | 59.8% |
| Duplicate rows | 55 |
| Duplicate rows (%) | 0.5% |
| Total size in memory | 1.6 MiB |
| Average record size in memory | 169.0 B |
Variable types
| Numeric | 1 |
|---|---|
| DateTime | 5 |
| Unsupported | 1 |
| Boolean | 1 |
| Text | 12 |
Dataset
| Description | 23~25 공공데이터 중장기 개방계획에 의한 생활민원처리시스템 DB개방자료로서 발송이력정보,생활민원처리정보,이관정보,협조부서정보 등의 테이블을 합성하여 개방함 |
|---|---|
| Author | 충청남도 아산시 |
| URL | https://www.data.go.kr/data/15122610/fileData.do |
| Dataset has 55 (0.5%) duplicate rows | Duplicates |
이관요청일시 has 5612 (56.1%) missing values | Missing |
알림예약일시 has 9535 (95.3%) missing values | Missing |
배정자부서명 has 8754 (87.5%) missing values | Missing |
배정자팀명 has 8764 (87.6%) missing values | Missing |
이관처리부서명 has 5621 (56.2%) missing values | Missing |
이관처리팀명 has 5628 (56.3%) missing values | Missing |
이관시의견 has 7862 (78.6%) missing values | Missing |
이관부서명 has 7852 (78.5%) missing values | Missing |
협조요청일시 has 9982 (99.8%) missing values | Missing |
협조부서명 has 9982 (99.8%) missing values | Missing |
협조상위부서명 has 9991 (99.9%) missing values | Missing |
협조팀명 has 9982 (99.8%) missing values | Missing |
중장기연장처리예정일 has 9996 (> 99.9%) missing values | Missing |
중장기연장처리사유 has 9996 (> 99.9%) missing values | Missing |
발송일시 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-12-12 13:10:08.038180 |
|---|---|
| Analysis finished | 2023-12-12 13:10:10.988127 |
| Duration | 2.95 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
생활민원번호
Real number (ℝ)
| Distinct | 9112 |
|---|---|
| Distinct (%) | 91.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0193706 × 1010 |
| Minimum | 2.0180427 × 1010 |
|---|---|
| Maximum | 2.0210324 × 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 166.0 KiB |
Quantile statistics
| Minimum | 2.0180427 × 1010 |
|---|---|
| 5-th percentile | 2.0180621 × 1010 |
| Q1 | 2.0190122 × 1010 |
| median | 2.0191014 × 1010 |
| Q3 | 2.020081 × 1010 |
| 95-th percentile | 2.0210218 × 1010 |
| Maximum | 2.0210324 × 1010 |
| Range | 29897058 |
| Interquartile range (IQR) | 10688042 |
Descriptive statistics
| Standard deviation | 9336613.5 |
|---|---|
| Coefficient of variation (CV) | 0.00046235264 |
| Kurtosis | -1.0194383 |
| Mean | 2.0193706 × 1010 |
| Median Absolute Deviation (MAD) | 9790014 |
| Skewness | 0.072924121 |
| Sum | 2.0193706 × 1014 |
| Variance | 8.7172353 × 1013 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20190420004 | 5 | 0.1% |
| 20190522006 | 4 | < 0.1% |
| 20180802023 | 4 | < 0.1% |
| 20190719010 | 4 | < 0.1% |
| 20210304044 | 4 | < 0.1% |
| 20200731065 | 4 | < 0.1% |
| 20190909089 | 4 | < 0.1% |
| 20200622040 | 3 | < 0.1% |
| 20190909001 | 3 | < 0.1% |
| 20180801021 | 3 | < 0.1% |
| Other values (9102) | 9962 |
| Value | Count | Frequency (%) |
| 20180427020 | 1 | |
| 20180428011 | 1 | |
| 20180428016 | 1 | |
| 20180429012 | 1 | |
| 20180430004 | 1 | |
| 20180430018 | 1 | |
| 20180430020 | 1 | |
| 20180430034 | 1 | |
| 20180502025 | 1 | |
| 20180503017 | 1 |
| Value | Count | Frequency (%) |
| 20210324078 | 1 | |
| 20210324075 | 1 | |
| 20210324072 | 1 | |
| 20210324071 | 1 | |
| 20210324069 | 1 | |
| 20210324068 | 1 | |
| 20210324064 | 2 | |
| 20210324058 | 1 | |
| 20210324041 | 1 | |
| 20210324033 | 2 |
발송요청일시
Date
| Distinct | 8732 |
|---|---|
| Distinct (%) | 87.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
| Minimum | 2018-05-07 13:12:00 |
|---|---|
| Maximum | 2021-05-20 17:42:00 |
Histogram with fixed size bins (bins=50)
발송일시
Unsupported
REJECTED UNSUPPORTED
| Missing | 16 |
|---|---|
| Missing (%) | 0.2% |
| Memory size | 156.2 KiB |
출동처리여부
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 19 |
| Missing (%) | 0.2% |
| Memory size | 97.7 KiB |
| True | |
|---|---|
| False | |
| (Missing) | 19 |
| Value | Count | Frequency (%) |
| True | 5014 | |
| False | 4967 | |
| (Missing) | 19 | 0.2% |
출동예정일시
Text
| Distinct | 3896 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 8.6765 |
| Min length | 1 |
Characters and Unicode
| Total characters | 86765 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3002 ? |
|---|---|
| Unique (%) | 30.0% |
Sample
| 1st row | 2018-09-27 11:30 |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| 10:00 | 589 | 5.8% |
| 14:00 | 532 | 5.2% |
| 15:00 | 399 | 3.9% |
| 09:00 | 355 | 3.5% |
| 11:00 | 327 | 3.2% |
| 16:00 | 280 | 2.7% |
| 13:00 | 204 | 2.0% |
| 17:00 | 181 | 1.8% |
| 10:30 | 163 | 1.6% |
| 15:30 | 141 | 1.4% |
| Other values (1022) | 7064 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 22590 | |
| 1 | 13090 | |
| 2 | 10406 | |
| - | 10230 | |
| 10000 | ||
| : | 5125 | 5.9% |
| 9 | 3280 | 3.8% |
| 8 | 2735 | 3.2% |
| 3 | 2618 | 3.0% |
| 5 | 2082 | 2.4% |
| Other values (3) | 4609 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 61410 | |
| Dash Punctuation | 10230 | 11.8% |
| Space Separator | 10000 | 11.5% |
| Other Punctuation | 5125 | 5.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 22590 | |
| 1 | 13090 | |
| 2 | 10406 | |
| 9 | 3280 | 5.3% |
| 8 | 2735 | 4.5% |
| 3 | 2618 | 4.3% |
| 5 | 2082 | 3.4% |
| 4 | 1785 | 2.9% |
| 6 | 1451 | 2.4% |
| 7 | 1373 | 2.2% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10230 |
Space Separator
| Value | Count | Frequency (%) |
| 10000 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 5125 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86765 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 22590 | |
| 1 | 13090 | |
| 2 | 10406 | |
| - | 10230 | |
| 10000 | ||
| : | 5125 | 5.9% |
| 9 | 3280 | 3.8% |
| 8 | 2735 | 3.2% |
| 3 | 2618 | 3.0% |
| 5 | 2082 | 2.4% |
| Other values (3) | 4609 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86765 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 22590 | |
| 1 | 13090 | |
| 2 | 10406 | |
| - | 10230 | |
| 10000 | ||
| : | 5125 | 5.9% |
| 9 | 3280 | 3.8% |
| 8 | 2735 | 3.2% |
| 3 | 2618 | 3.0% |
| 5 | 2082 | 2.4% |
| Other values (3) | 4609 | 5.3% |
처리완료일시
Text
| Distinct | 8918 |
|---|---|
| Distinct (%) | 89.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 156.2 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 15.97 |
| Min length | 1 |
Characters and Unicode
| Total characters | 159700 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 7947 ? |
|---|---|
| Unique (%) | 79.5% |
Sample
| 1st row | 2018-09-28 17:40 |
|---|---|
| 2nd row | 2021-01-24 19:10 |
| 3rd row | 2021-01-27 17:21 |
| 4th row | 2020-11-30 09:08 |
| 5th row | 2019-01-21 11:44 |
| Value | Count | Frequency (%) |
| 2020-08-10 | 52 | 0.3% |
| 2020-08-11 | 50 | 0.3% |
| 2020-08-18 | 46 | 0.2% |
| 2020-08-12 | 42 | 0.2% |
| 09:04 | 41 | 0.2% |
| 2021-03-24 | 40 | 0.2% |
| 2019-09-09 | 40 | 0.2% |
| 09:06 | 40 | 0.2% |
| 2019-09-02 | 37 | 0.2% |
| 09:22 | 37 | 0.2% |
| Other values (1786) | 19535 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32122 | |
| 1 | 25697 | |
| 2 | 23193 | |
| - | 19960 | |
| 10000 | 6.3% | |
| : | 9980 | 6.2% |
| 9 | 7893 | 4.9% |
| 8 | 6803 | 4.3% |
| 3 | 5779 | 3.6% |
| 5 | 5081 | 3.2% |
| Other values (3) | 13192 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 119760 | |
| Dash Punctuation | 19960 | 12.5% |
| Space Separator | 10000 | 6.3% |
| Other Punctuation | 9980 | 6.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 32122 | |
| 1 | 25697 | |
| 2 | 23193 | |
| 9 | 7893 | 6.6% |
| 8 | 6803 | 5.7% |
| 3 | 5779 | 4.8% |
| 5 | 5081 | 4.2% |
| 4 | 4687 | 3.9% |
| 7 | 4426 | 3.7% |
| 6 | 4079 | 3.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 19960 |
Space Separator
| Value | Count | Frequency (%) |
| 10000 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 9980 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 159700 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 32122 | |
| 1 | 25697 | |
| 2 | 23193 | |
| - | 19960 | |
| 10000 | 6.3% | |
| : | 9980 | 6.2% |
| 9 | 7893 | 4.9% |
| 8 | 6803 | 4.3% |
| 3 | 5779 | 3.6% |
| 5 | 5081 | 3.2% |
| Other values (3) | 13192 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 159700 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 32122 | |
| 1 | 25697 | |
| 2 | 23193 | |
| - | 19960 | |
| 10000 | 6.3% | |
| : | 9980 | 6.2% |
| 9 | 7893 | 4.9% |
| 8 | 6803 | 4.3% |
| 3 | 5779 | 3.6% |
| 5 | 5081 | 3.2% |
| Other values (3) | 13192 |
이관요청일시
Date
MISSING
| Distinct | 3934 |
|---|---|
| Distinct (%) | 89.7% |
| Missing | 5612 |
| Missing (%) | 56.1% |
| Memory size | 156.2 KiB |
| Minimum | 2019-12-31 01:02:00 |
|---|---|
| Maximum | 2021-03-25 16:57:00 |
Histogram with fixed size bins (bins=50)
알림예약일시
Date
MISSING
| Distinct | 248 |
|---|---|
| Distinct (%) | 53.3% |
| Missing | 9535 |
| Missing (%) | 95.3% |
| Memory size | 156.2 KiB |
| Minimum | 2019-12-31 09:00:00 |
|---|---|
| Maximum | 2021-03-25 09:05:00 |
Histogram with fixed size bins (bins=50)
배정자부서명
Text
MISSING
| Distinct | 63 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 8754 |
| Missing (%) | 87.5% |
| Memory size | 156.2 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 4.3908507 |
| Min length | 3 |
Characters and Unicode
| Total characters | 5471 |
|---|---|
| Distinct characters | 120 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 민원봉사과 |
|---|---|
| 2nd row | 자치행정과 |
| 3rd row | 건축과 |
| 4th row | 위생과 |
| 5th row | 회계과 |
| Value | Count | Frequency (%) |
| 민원봉사과 | 206 | 16.5% |
| 도로과 | 75 | 6.0% |
| 허가담당관 | 60 | 4.8% |
| 환경보전과 | 59 | 4.7% |
| 자원순환과 | 57 | 4.6% |
| 교통행정과 | 51 | 4.1% |
| 건설과 | 43 | 3.5% |
| 건축과 | 42 | 3.4% |
| 산림과 | 40 | 3.2% |
| 주택과 | 37 | 3.0% |
| Other values (53) | 576 |
Most occurring characters
| Value | Count | Frequency (%) |
| 과 | 1096 | 20.0% |
| 원 | 300 | 5.5% |
| 사 | 243 | 4.4% |
| 봉 | 210 | 3.8% |
| 민 | 206 | 3.8% |
| 도 | 147 | 2.7% |
| 정 | 128 | 2.3% |
| 환 | 116 | 2.1% |
| 관 | 113 | 2.1% |
| 경 | 108 | 2.0% |
| Other values (110) | 2804 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 5460 | |
| Decimal Number | 11 | 0.2% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 과 | 1096 | 20.1% |
| 원 | 300 | 5.5% |
| 사 | 243 | 4.5% |
| 봉 | 210 | 3.8% |
| 민 | 206 | 3.8% |
| 도 | 147 | 2.7% |
| 정 | 128 | 2.3% |
| 환 | 116 | 2.1% |
| 관 | 113 | 2.1% |
| 경 | 108 | 2.0% |
| Other values (105) | 2793 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 3 | |
| 5 | 3 | |
| 4 | 3 | |
| 6 | 1 | 9.1% |
| 2 | 1 | 9.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 5460 | |
| Common | 11 | 0.2% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 과 | 1096 | 20.1% |
| 원 | 300 | 5.5% |
| 사 | 243 | 4.5% |
| 봉 | 210 | 3.8% |
| 민 | 206 | 3.8% |
| 도 | 147 | 2.7% |
| 정 | 128 | 2.3% |
| 환 | 116 | 2.1% |
| 관 | 113 | 2.1% |
| 경 | 108 | 2.0% |
| Other values (105) | 2793 |
Common
| Value | Count | Frequency (%) |
| 3 | 3 | |
| 5 | 3 | |
| 4 | 3 | |
| 6 | 1 | 9.1% |
| 2 | 1 | 9.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 5460 | |
| ASCII | 11 | 0.2% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 과 | 1096 | 20.1% |
| 원 | 300 | 5.5% |
| 사 | 243 | 4.5% |
| 봉 | 210 | 3.8% |
| 민 | 206 | 3.8% |
| 도 | 147 | 2.7% |
| 정 | 128 | 2.3% |
| 환 | 116 | 2.1% |
| 관 | 113 | 2.1% |
| 경 | 108 | 2.0% |
| Other values (105) | 2793 |
ASCII
| Value | Count | Frequency (%) |
| 3 | 3 | |
| 5 | 3 | |
| 4 | 3 | |
| 6 | 1 | 9.1% |
| 2 | 1 | 9.1% |
배정자팀명
Text
MISSING
| Distinct | 165 |
|---|---|
| Distinct (%) | 13.3% |
| Missing | 8764 |
| Missing (%) | 87.6% |
| Memory size | 156.2 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 5 |
| Mean length | 5.1658576 |
| Min length | 2 |
Characters and Unicode
| Total characters | 6385 |
|---|---|
| Distinct characters | 166 |
| Distinct categories | 4 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 23 ? |
|---|---|
| Unique (%) | 1.9% |
Sample
| 1st row | 민원콜센터팀 |
|---|---|
| 2nd row | 대외협력팀 |
| 3rd row | 건축지도팀 |
| 4th row | 위생행정팀 |
| 5th row | 청렴계약팀 |
| Value | Count | Frequency (%) |
| 민원콜센터팀 | 181 | 14.6% |
| 건축지도팀 | 37 | 3.0% |
| 청소행정팀 | 35 | 2.8% |
| 도로관리팀 | 35 | 2.8% |
| 산업개발팀 | 31 | 2.5% |
| 환경지도팀 | 28 | 2.3% |
| 민원행정팀 | 24 | 1.9% |
| 주택개발팀 | 22 | 1.8% |
| 위생지도팀 | 22 | 1.8% |
| 하천관리팀 | 19 | 1.5% |
| Other values (155) | 802 |
Most occurring characters
| Value | Count | Frequency (%) |
| 팀 | 1208 | 18.9% |
| 원 | 253 | 4.0% |
| 도 | 222 | 3.5% |
| 민 | 219 | 3.4% |
| 지 | 207 | 3.2% |
| 리 | 185 | 2.9% |
| 관 | 185 | 2.9% |
| 센 | 182 | 2.9% |
| 터 | 182 | 2.9% |
| 콜 | 181 | 2.8% |
| Other values (156) | 3361 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 6344 | |
| Uppercase Letter | 18 | 0.3% |
| Decimal Number | 15 | 0.2% |
| Other Punctuation | 8 | 0.1% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 팀 | 1208 | 19.0% |
| 원 | 253 | 4.0% |
| 도 | 222 | 3.5% |
| 민 | 219 | 3.5% |
| 지 | 207 | 3.3% |
| 리 | 185 | 2.9% |
| 관 | 185 | 2.9% |
| 센 | 182 | 2.9% |
| 터 | 182 | 2.9% |
| 콜 | 181 | 2.9% |
| Other values (151) | 3320 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 10 | |
| 1 | 5 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 9 | |
| F | 9 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 8 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 6344 | |
| Common | 23 | 0.4% |
| Latin | 18 | 0.3% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 팀 | 1208 | 19.0% |
| 원 | 253 | 4.0% |
| 도 | 222 | 3.5% |
| 민 | 219 | 3.5% |
| 지 | 207 | 3.3% |
| 리 | 185 | 2.9% |
| 관 | 185 | 2.9% |
| 센 | 182 | 2.9% |
| 터 | 182 | 2.9% |
| 콜 | 181 | 2.9% |
| Other values (151) | 3320 |
Common
| Value | Count | Frequency (%) |
| 2 | 10 | |
| / | 8 | |
| 1 | 5 |
Latin
| Value | Count | Frequency (%) |
| T | 9 | |
| F | 9 |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 6344 | |
| ASCII | 41 | 0.6% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 팀 | 1208 | 19.0% |
| 원 | 253 | 4.0% |
| 도 | 222 | 3.5% |
| 민 | 219 | 3.5% |
| 지 | 207 | 3.3% |
| 리 | 185 | 2.9% |
| 관 | 185 | 2.9% |
| 센 | 182 | 2.9% |
| 터 | 182 | 2.9% |
| 콜 | 181 | 2.9% |
| Other values (151) | 3320 |
ASCII
| Value | Count | Frequency (%) |
| 2 | 10 | |
| T | 9 | |
| F | 9 | |
| / | 8 | |
| 1 | 5 |
이관처리부서명
Text
MISSING
| Distinct | 67 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 5621 |
| Missing (%) | 56.2% |
| Memory size | 156.2 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 6 |
| Mean length | 4.3749715 |
| Min length | 3 |
Characters and Unicode
| Total characters | 19158 |
|---|---|
| Distinct characters | 125 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 경로장애인과 |
|---|---|
| 2nd row | 기후변화대책과 |
| 3rd row | 대중교통과 |
| 4th row | 기후변화대책과 |
| 5th row | 배방읍 |
| Value | Count | Frequency (%) |
| 도로과 | 645 | 14.7% |
| 기후변화대책과 | 392 | 9.0% |
| 자원순환과 | 347 | 7.9% |
| 교통행정과 | 346 | 7.9% |
| 대중교통과 | 267 | 6.1% |
| 위생과 | 182 | 4.2% |
| 환경보전과 | 165 | 3.8% |
| 질병예방과 | 140 | 3.2% |
| 상수도과 | 137 | 3.1% |
| 배방읍 | 129 | 2.9% |
| Other values (57) | 1629 |
Most occurring characters
| Value | Count | Frequency (%) |
| 과 | 3788 | 19.8% |
| 도 | 1037 | 5.4% |
| 로 | 661 | 3.5% |
| 대 | 659 | 3.4% |
| 통 | 622 | 3.2% |
| 교 | 617 | 3.2% |
| 원 | 556 | 2.9% |
| 환 | 512 | 2.7% |
| 기 | 459 | 2.4% |
| 화 | 445 | 2.3% |
| Other values (115) | 9802 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 19050 | |
| Decimal Number | 108 | 0.6% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 과 | 3788 | 19.9% |
| 도 | 1037 | 5.4% |
| 로 | 661 | 3.5% |
| 대 | 659 | 3.5% |
| 통 | 622 | 3.3% |
| 교 | 617 | 3.2% |
| 원 | 556 | 2.9% |
| 환 | 512 | 2.7% |
| 기 | 459 | 2.4% |
| 화 | 445 | 2.3% |
| Other values (109) | 9694 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 33 | |
| 5 | 25 | |
| 3 | 18 | |
| 2 | 13 | 12.0% |
| 4 | 10 | 9.3% |
| 1 | 9 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 19050 | |
| Common | 108 | 0.6% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 과 | 3788 | 19.9% |
| 도 | 1037 | 5.4% |
| 로 | 661 | 3.5% |
| 대 | 659 | 3.5% |
| 통 | 622 | 3.3% |
| 교 | 617 | 3.2% |
| 원 | 556 | 2.9% |
| 환 | 512 | 2.7% |
| 기 | 459 | 2.4% |
| 화 | 445 | 2.3% |
| Other values (109) | 9694 |
Common
| Value | Count | Frequency (%) |
| 6 | 33 | |
| 5 | 25 | |
| 3 | 18 | |
| 2 | 13 | 12.0% |
| 4 | 10 | 9.3% |
| 1 | 9 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 19050 | |
| ASCII | 108 | 0.6% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 과 | 3788 | 19.9% |
| 도 | 1037 | 5.4% |
| 로 | 661 | 3.5% |
| 대 | 659 | 3.5% |
| 통 | 622 | 3.3% |
| 교 | 617 | 3.2% |
| 원 | 556 | 2.9% |
| 환 | 512 | 2.7% |
| 기 | 459 | 2.4% |
| 화 | 445 | 2.3% |
| Other values (109) | 9694 |
ASCII
| Value | Count | Frequency (%) |
| 6 | 33 | |
| 5 | 25 | |
| 3 | 18 | |
| 2 | 13 | 12.0% |
| 4 | 10 | 9.3% |
| 1 | 9 | 8.3% |
이관처리팀명
Text
MISSING
| Distinct | 164 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 5628 |
| Missing (%) | 56.3% |
| Memory size | 156.2 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 5 |
| Mean length | 5.023559 |
| Min length | 2 |
Characters and Unicode
| Total characters | 21963 |
|---|---|
| Distinct characters | 170 |
| Distinct categories | 4 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 39 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | 경로복지팀 |
|---|---|
| 2nd row | 미세먼지대책팀 |
| 3rd row | 운수지도팀 |
| 4th row | 생활환경팀 |
| 5th row | 산업개발팀 |
| Value | Count | Frequency (%) |
| 도로관리팀 | 501 | 11.5% |
| 산업개발팀 | 300 | 6.9% |
| 청소행정팀 | 296 | 6.8% |
| 생활환경팀 | 229 | 5.2% |
| 운수지도팀 | 210 | 4.8% |
| 교통지도팀 | 177 | 4.0% |
| 위생지도팀 | 171 | 3.9% |
| 미세먼지대책팀 | 160 | 3.7% |
| 교통시설팀 | 126 | 2.9% |
| 총무팀 | 123 | 2.8% |
| Other values (154) | 2079 |
Most occurring characters
| Value | Count | Frequency (%) |
| 팀 | 4347 | |
| 도 | 1396 | 6.4% |
| 지 | 1010 | 4.6% |
| 리 | 997 | 4.5% |
| 관 | 996 | 4.5% |
| 로 | 699 | 3.2% |
| 정 | 664 | 3.0% |
| 수 | 486 | 2.2% |
| 산 | 448 | 2.0% |
| 경 | 438 | 2.0% |
| Other values (160) | 10482 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 21875 | |
| Uppercase Letter | 62 | 0.3% |
| Other Punctuation | 20 | 0.1% |
| Decimal Number | 6 | < 0.1% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 팀 | 4347 | |
| 도 | 1396 | 6.4% |
| 지 | 1010 | 4.6% |
| 리 | 997 | 4.6% |
| 관 | 996 | 4.6% |
| 로 | 699 | 3.2% |
| 정 | 664 | 3.0% |
| 수 | 486 | 2.2% |
| 산 | 448 | 2.0% |
| 경 | 438 | 2.0% |
| Other values (155) | 10394 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 31 | |
| T | 31 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3 | |
| 2 | 3 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 20 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 21875 | |
| Latin | 62 | 0.3% |
| Common | 26 | 0.1% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 팀 | 4347 | |
| 도 | 1396 | 6.4% |
| 지 | 1010 | 4.6% |
| 리 | 997 | 4.6% |
| 관 | 996 | 4.6% |
| 로 | 699 | 3.2% |
| 정 | 664 | 3.0% |
| 수 | 486 | 2.2% |
| 산 | 448 | 2.0% |
| 경 | 438 | 2.0% |
| Other values (155) | 10394 |
Common
| Value | Count | Frequency (%) |
| / | 20 | |
| 1 | 3 | 11.5% |
| 2 | 3 | 11.5% |
Latin
| Value | Count | Frequency (%) |
| F | 31 | |
| T | 31 |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 21875 | |
| ASCII | 88 | 0.4% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 팀 | 4347 | |
| 도 | 1396 | 6.4% |
| 지 | 1010 | 4.6% |
| 리 | 997 | 4.6% |
| 관 | 996 | 4.6% |
| 로 | 699 | 3.2% |
| 정 | 664 | 3.0% |
| 수 | 486 | 2.2% |
| 산 | 448 | 2.0% |
| 경 | 438 | 2.0% |
| Other values (155) | 10394 |
ASCII
| Value | Count | Frequency (%) |
| F | 31 | |
| T | 31 | |
| / | 20 | |
| 1 | 3 | 3.4% |
| 2 | 3 | 3.4% |
이관시의견
Text
MISSING
| Distinct | 912 |
|---|---|
| Distinct (%) | 42.7% |
| Missing | 7862 |
| Missing (%) | 78.6% |
| Memory size | 156.2 KiB |
Length
| Max length | 111 |
|---|---|
| Median length | 81 |
| Mean length | 12.048644 |
| Min length | 1 |
Characters and Unicode
| Total characters | 25760 |
|---|---|
| Distinct characters | 483 |
| Distinct categories | 9 ? |
| Distinct scripts | 3 ? |
| Distinct blocks | 4 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 675 ? |
|---|---|
| Unique (%) | 31.6% |
Sample
| 1st row | 담당자 변경 |
|---|---|
| 2nd row | 담당자 재지정 |
| 3rd row | 담당자 배정오류 |
| 4th row | 담당자 변경 |
| 5th row | 담당부서 이관 |
| Value | Count | Frequency (%) |
| 담당자 | 523 | 8.5% |
| 변경 | 487 | 8.0% |
| 이관 | 365 | 6.0% |
| 담당부서 | 296 | 4.8% |
| 재지정 | 119 | 1.9% |
| 관련 | 96 | 1.6% |
| 담당자에게 | 83 | 1.4% |
| 담당부서로 | 60 | 1.0% |
| 담당자변경 | 59 | 1.0% |
| 소관 | 57 | 0.9% |
| Other values (1758) | 3977 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4089 | 15.9% | |
| 당 | 1266 | 4.9% |
| 담 | 1232 | 4.8% |
| 관 | 959 | 3.7% |
| 자 | 844 | 3.3% |
| 경 | 676 | 2.6% |
| 이 | 676 | 2.6% |
| 변 | 669 | 2.6% |
| 로 | 644 | 2.5% |
| 서 | 589 | 2.3% |
| Other values (473) | 14116 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 20644 | |
| Space Separator | 4089 | 15.9% |
| Decimal Number | 328 | 1.3% |
| Other Punctuation | 268 | 1.0% |
| Open Punctuation | 181 | 0.7% |
| Close Punctuation | 181 | 0.7% |
| Dash Punctuation | 37 | 0.1% |
| Uppercase Letter | 27 | 0.1% |
| Math Symbol | 5 | < 0.1% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 당 | 1266 | 6.1% |
| 담 | 1232 | 6.0% |
| 관 | 959 | 4.6% |
| 자 | 844 | 4.1% |
| 경 | 676 | 3.3% |
| 이 | 676 | 3.3% |
| 변 | 669 | 3.2% |
| 로 | 644 | 3.1% |
| 서 | 589 | 2.9% |
| 부 | 536 | 2.6% |
| Other values (439) | 12553 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 65 | |
| 2 | 58 | |
| 0 | 46 | |
| 5 | 33 | |
| 4 | 33 | |
| 3 | 27 | |
| 6 | 21 | 6.4% |
| 7 | 20 | 6.1% |
| 9 | 13 | 4.0% |
| 8 | 12 | 3.7% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 7 | |
| T | 5 | |
| L | 4 | |
| V | 3 | |
| H | 3 | |
| F | 2 | 7.4% |
| D | 1 | 3.7% |
| E | 1 | 3.7% |
| P | 1 | 3.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 201 | |
| , | 37 | 13.8% |
| : | 13 | 4.9% |
| / | 12 | 4.5% |
| ' | 2 | 0.7% |
| " | 2 | 0.7% |
| ※ | 1 | 0.4% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 180 | |
| 「 | 1 | 0.6% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 180 | |
| 」 | 1 | 0.6% |
Math Symbol
| Value | Count | Frequency (%) |
| ~ | 3 | |
| > | 2 |
Space Separator
| Value | Count | Frequency (%) |
| 4089 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 37 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 20644 | |
| Common | 5089 | 19.8% |
| Latin | 27 | 0.1% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 당 | 1266 | 6.1% |
| 담 | 1232 | 6.0% |
| 관 | 959 | 4.6% |
| 자 | 844 | 4.1% |
| 경 | 676 | 3.3% |
| 이 | 676 | 3.3% |
| 변 | 669 | 3.2% |
| 로 | 644 | 3.1% |
| 서 | 589 | 2.9% |
| 부 | 536 | 2.6% |
| Other values (439) | 12553 |
Common
| Value | Count | Frequency (%) |
| 4089 | ||
| . | 201 | 3.9% |
| ( | 180 | 3.5% |
| ) | 180 | 3.5% |
| 1 | 65 | 1.3% |
| 2 | 58 | 1.1% |
| 0 | 46 | 0.9% |
| , | 37 | 0.7% |
| - | 37 | 0.7% |
| 5 | 33 | 0.6% |
| Other values (15) | 163 | 3.2% |
Latin
| Value | Count | Frequency (%) |
| C | 7 | |
| T | 5 | |
| L | 4 | |
| V | 3 | |
| H | 3 | |
| F | 2 | 7.4% |
| D | 1 | 3.7% |
| E | 1 | 3.7% |
| P | 1 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 20644 | |
| ASCII | 5113 | 19.8% |
| None | 2 | < 0.1% |
| Punctuation | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4089 | ||
| . | 201 | 3.9% |
| ( | 180 | 3.5% |
| ) | 180 | 3.5% |
| 1 | 65 | 1.3% |
| 2 | 58 | 1.1% |
| 0 | 46 | 0.9% |
| , | 37 | 0.7% |
| - | 37 | 0.7% |
| 5 | 33 | 0.6% |
| Other values (21) | 187 | 3.7% |
Hangul
| Value | Count | Frequency (%) |
| 당 | 1266 | 6.1% |
| 담 | 1232 | 6.0% |
| 관 | 959 | 4.6% |
| 자 | 844 | 4.1% |
| 경 | 676 | 3.3% |
| 이 | 676 | 3.3% |
| 변 | 669 | 3.2% |
| 로 | 644 | 3.1% |
| 서 | 589 | 2.9% |
| 부 | 536 | 2.6% |
| Other values (439) | 12553 |
Punctuation
| Value | Count | Frequency (%) |
| ※ | 1 |
None
| Value | Count | Frequency (%) |
| 「 | 1 | |
| 」 | 1 |
이관부서명
Text
MISSING
| Distinct | 65 |
|---|---|
| Distinct (%) | 3.0% |
| Missing | 7852 |
| Missing (%) | 78.5% |
| Memory size | 156.2 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 4.4553073 |
| Min length | 3 |
Characters and Unicode
| Total characters | 9570 |
|---|---|
| Distinct characters | 118 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 민원봉사과 |
|---|---|
| 2nd row | 민원봉사과 |
| 3rd row | 공원녹지과 |
| 4th row | 민원봉사과 |
| 5th row | 위생과 |
| Value | Count | Frequency (%) |
| 민원봉사과 | 516 | |
| 도로과 | 197 | 9.2% |
| 교통행정과 | 110 | 5.1% |
| 공원녹지과 | 107 | 5.0% |
| 자원순환과 | 92 | 4.3% |
| 하수도과 | 79 | 3.7% |
| 환경보전과 | 78 | 3.6% |
| 상수도과 | 72 | 3.4% |
| 허가담당관 | 67 | 3.1% |
| 민원봉사담당관 | 65 | 3.0% |
| Other values (55) | 765 |
Most occurring characters
| Value | Count | Frequency (%) |
| 과 | 1786 | |
| 원 | 789 | 8.2% |
| 봉 | 596 | 6.2% |
| 사 | 592 | 6.2% |
| 민 | 581 | 6.1% |
| 도 | 390 | 4.1% |
| 로 | 200 | 2.1% |
| 교 | 174 | 1.8% |
| 통 | 174 | 1.8% |
| 수 | 171 | 1.8% |
| Other values (108) | 4117 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 9506 | |
| Decimal Number | 64 | 0.7% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 과 | 1786 | |
| 원 | 789 | 8.3% |
| 봉 | 596 | 6.3% |
| 사 | 592 | 6.2% |
| 민 | 581 | 6.1% |
| 도 | 390 | 4.1% |
| 로 | 200 | 2.1% |
| 교 | 174 | 1.8% |
| 통 | 174 | 1.8% |
| 수 | 171 | 1.8% |
| Other values (102) | 4053 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 17 | |
| 3 | 15 | |
| 1 | 15 | |
| 4 | 9 | |
| 5 | 6 | 9.4% |
| 2 | 2 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 9506 | |
| Common | 64 | 0.7% |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 과 | 1786 | |
| 원 | 789 | 8.3% |
| 봉 | 596 | 6.3% |
| 사 | 592 | 6.2% |
| 민 | 581 | 6.1% |
| 도 | 390 | 4.1% |
| 로 | 200 | 2.1% |
| 교 | 174 | 1.8% |
| 통 | 174 | 1.8% |
| 수 | 171 | 1.8% |
| Other values (102) | 4053 |
Common
| Value | Count | Frequency (%) |
| 6 | 17 | |
| 3 | 15 | |
| 1 | 15 | |
| 4 | 9 | |
| 5 | 6 | 9.4% |
| 2 | 2 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 9506 | |
| ASCII | 64 | 0.7% |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 과 | 1786 | |
| 원 | 789 | 8.3% |
| 봉 | 596 | 6.3% |
| 사 | 592 | 6.2% |
| 민 | 581 | 6.1% |
| 도 | 390 | 4.1% |
| 로 | 200 | 2.1% |
| 교 | 174 | 1.8% |
| 통 | 174 | 1.8% |
| 수 | 171 | 1.8% |
| Other values (102) | 4053 |
ASCII
| Value | Count | Frequency (%) |
| 6 | 17 | |
| 3 | 15 | |
| 1 | 15 | |
| 4 | 9 | |
| 5 | 6 | 9.4% |
| 2 | 2 | 3.1% |
협조요청일시
Date
MISSING
| Distinct | 15 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 9982 |
| Missing (%) | 99.8% |
| Memory size | 156.2 KiB |
| Minimum | 2018-11-20 13:11:00 |
|---|---|
| Maximum | 2021-03-23 12:51:00 |
Histogram with fixed size bins (bins=15)
협조부서명
Text
MISSING
| Distinct | 11 |
|---|---|
| Distinct (%) | 61.1% |
| Missing | 9982 |
| Missing (%) | 99.8% |
| Memory size | 156.2 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 4.3888889 |
| Min length | 3 |
Characters and Unicode
| Total characters | 79 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 38.9% |
Sample
| 1st row | 환경보전과 |
|---|---|
| 2nd row | 축수산과 |
| 3rd row | 교통행정과 |
| 4th row | 농정과 |
| 5th row | 환경보전과 |
| Value | Count | Frequency (%) |
| 환경보전과 | 4 | |
| 축수산과 | 3 | |
| 교통행정과 | 2 | |
| 도로과 | 2 | |
| 농정과 | 1 | 5.6% |
| 정보통신과 | 1 | 5.6% |
| 민원봉사담당관 | 1 | 5.6% |
| 징수과 | 1 | 5.6% |
| 주택과 | 1 | 5.6% |
| 건축과 | 1 | 5.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 과 | 17 | |
| 보 | 5 | 6.3% |
| 환 | 4 | 5.1% |
| 수 | 4 | 5.1% |
| 경 | 4 | 5.1% |
| 정 | 4 | 5.1% |
| 축 | 4 | 5.1% |
| 전 | 4 | 5.1% |
| 통 | 3 | 3.8% |
| 산 | 3 | 3.8% |
| Other values (23) | 27 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 79 |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 과 | 17 | |
| 보 | 5 | 6.3% |
| 환 | 4 | 5.1% |
| 수 | 4 | 5.1% |
| 경 | 4 | 5.1% |
| 정 | 4 | 5.1% |
| 축 | 4 | 5.1% |
| 전 | 4 | 5.1% |
| 통 | 3 | 3.8% |
| 산 | 3 | 3.8% |
| Other values (23) | 27 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 79 |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 과 | 17 | |
| 보 | 5 | 6.3% |
| 환 | 4 | 5.1% |
| 수 | 4 | 5.1% |
| 경 | 4 | 5.1% |
| 정 | 4 | 5.1% |
| 축 | 4 | 5.1% |
| 전 | 4 | 5.1% |
| 통 | 3 | 3.8% |
| 산 | 3 | 3.8% |
| Other values (23) | 27 |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 79 |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 과 | 17 | |
| 보 | 5 | 6.3% |
| 환 | 4 | 5.1% |
| 수 | 4 | 5.1% |
| 경 | 4 | 5.1% |
| 정 | 4 | 5.1% |
| 축 | 4 | 5.1% |
| 전 | 4 | 5.1% |
| 통 | 3 | 3.8% |
| 산 | 3 | 3.8% |
| Other values (23) | 27 |
협조상위부서명
Text
MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | 66.7% |
| Missing | 9991 |
| Missing (%) | 99.9% |
| Memory size | 156.2 KiB |
Length
| Max length | 7 |
|---|---|
| Median length | 5 |
| Mean length | 5.5555556 |
| Min length | 5 |
Characters and Unicode
| Total characters | 50 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 44.4% |
Sample
| 1st row | 농업기술센터 |
|---|---|
| 2nd row | 행정안전국 |
| 3rd row | 농업기술센터 |
| 4th row | 환경녹지국 |
| 5th row | 시민행복기획실 |
| Value | Count | Frequency (%) |
| 농업기술센터 | 3 | |
| 환경녹지국 | 2 | |
| 행정안전국 | 1 | 11.1% |
| 시민행복기획실 | 1 | 11.1% |
| 건설교통국 | 1 | 11.1% |
| 도시개발국 | 1 | 11.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 국 | 5 | 10.0% |
| 기 | 4 | 8.0% |
| 농 | 3 | 6.0% |
| 술 | 3 | 6.0% |
| 센 | 3 | 6.0% |
| 터 | 3 | 6.0% |
| 업 | 3 | 6.0% |
| 시 | 2 | 4.0% |
| 행 | 2 | 4.0% |
| 지 | 2 | 4.0% |
| Other values (17) | 20 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 50 |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 국 | 5 | 10.0% |
| 기 | 4 | 8.0% |
| 농 | 3 | 6.0% |
| 술 | 3 | 6.0% |
| 센 | 3 | 6.0% |
| 터 | 3 | 6.0% |
| 업 | 3 | 6.0% |
| 시 | 2 | 4.0% |
| 행 | 2 | 4.0% |
| 지 | 2 | 4.0% |
| Other values (17) | 20 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 50 |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 국 | 5 | 10.0% |
| 기 | 4 | 8.0% |
| 농 | 3 | 6.0% |
| 술 | 3 | 6.0% |
| 센 | 3 | 6.0% |
| 터 | 3 | 6.0% |
| 업 | 3 | 6.0% |
| 시 | 2 | 4.0% |
| 행 | 2 | 4.0% |
| 지 | 2 | 4.0% |
| Other values (17) | 20 |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 50 |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 국 | 5 | 10.0% |
| 기 | 4 | 8.0% |
| 농 | 3 | 6.0% |
| 술 | 3 | 6.0% |
| 센 | 3 | 6.0% |
| 터 | 3 | 6.0% |
| 업 | 3 | 6.0% |
| 시 | 2 | 4.0% |
| 행 | 2 | 4.0% |
| 지 | 2 | 4.0% |
| Other values (17) | 20 |
협조팀명
Text
MISSING
| Distinct | 14 |
|---|---|
| Distinct (%) | 77.8% |
| Missing | 9982 |
| Missing (%) | 99.8% |
| Memory size | 156.2 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.0555556 |
| Min length | 4 |
Characters and Unicode
| Total characters | 91 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 10 ? |
|---|---|
| Unique (%) | 55.6% |
Sample
| 1st row | 환경지도팀 |
|---|---|
| 2nd row | 해양수산팀 |
| 3rd row | 교통시설팀 |
| 4th row | 농촌관리 |
| 5th row | 대기관리팀 |
| Value | Count | Frequency (%) |
| 환경지도팀 | 2 | |
| 교통시설팀 | 2 | |
| 축산유통팀 | 2 | |
| 도로관리팀 | 2 | |
| 해양수산팀 | 1 | 5.6% |
| 농촌관리 | 1 | 5.6% |
| 대기관리팀 | 1 | 5.6% |
| 정보기획팀 | 1 | 5.6% |
| 실개천생태팀 | 1 | 5.6% |
| 민원콜센터팀 | 1 | 5.6% |
| Other values (4) | 4 |
Most occurring characters
| Value | Count | Frequency (%) |
| 팀 | 17 | |
| 도 | 5 | 5.5% |
| 리 | 4 | 4.4% |
| 통 | 4 | 4.4% |
| 관 | 4 | 4.4% |
| 환 | 3 | 3.3% |
| 축 | 3 | 3.3% |
| 경 | 3 | 3.3% |
| 산 | 3 | 3.3% |
| 기 | 3 | 3.3% |
| Other values (32) | 42 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 91 |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 팀 | 17 | |
| 도 | 5 | 5.5% |
| 리 | 4 | 4.4% |
| 통 | 4 | 4.4% |
| 관 | 4 | 4.4% |
| 환 | 3 | 3.3% |
| 축 | 3 | 3.3% |
| 경 | 3 | 3.3% |
| 산 | 3 | 3.3% |
| 기 | 3 | 3.3% |
| Other values (32) | 42 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 91 |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 팀 | 17 | |
| 도 | 5 | 5.5% |
| 리 | 4 | 4.4% |
| 통 | 4 | 4.4% |
| 관 | 4 | 4.4% |
| 환 | 3 | 3.3% |
| 축 | 3 | 3.3% |
| 경 | 3 | 3.3% |
| 산 | 3 | 3.3% |
| 기 | 3 | 3.3% |
| Other values (32) | 42 |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 91 |
Most frequent character per block
Hangul
| Value | Count | Frequency (%) |
| 팀 | 17 | |
| 도 | 5 | 5.5% |
| 리 | 4 | 4.4% |
| 통 | 4 | 4.4% |
| 관 | 4 | 4.4% |
| 환 | 3 | 3.3% |
| 축 | 3 | 3.3% |
| 경 | 3 | 3.3% |
| 산 | 3 | 3.3% |
| 기 | 3 | 3.3% |
| Other values (32) | 42 |
중장기연장처리예정일
Date
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 9996 |
| Missing (%) | > 99.9% |
| Memory size | 156.2 KiB |
| Minimum | 2020-04-30 00:00:00 |
|---|---|
| Maximum | 2021-03-19 00:00:00 |
Histogram with fixed size bins (bins=3)
중장기연장처리사유
Text
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 9996 |
| Missing (%) | > 99.9% |
| Memory size | 156.2 KiB |
Length
| Max length | 29 |
|---|---|
| Median length | 25.5 |
| Mean length | 15.75 |
| Min length | 6 |
Characters and Unicode
| Total characters | 63 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Sample
| 1st row | 민원처리지연 |
|---|---|
| 2nd row | 2020년 처리(2019년 예산 미확보) |
| 3rd row | 민원처리지연 |
| 4th row | 추경예산확보 후 처리예정(배방읍 박병훈 3월2일요청) |
| Value | Count | Frequency (%) |
| 민원처리지연 | 2 | |
| 2020년 | 1 | |
| 처리(2019년 | 1 | |
| 예산 | 1 | |
| 미확보 | 1 | |
| 추경예산확보 | 1 | |
| 후 | 1 | |
| 처리예정(배방읍 | 1 | |
| 박병훈 | 1 | |
| 3월2일요청 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 11.1% | |
| 처 | 4 | 6.3% |
| 리 | 4 | 6.3% |
| 2 | 4 | 6.3% |
| 예 | 3 | 4.8% |
| 0 | 3 | 4.8% |
| 민 | 2 | 3.2% |
| ) | 2 | 3.2% |
| 원 | 2 | 3.2% |
| 확 | 2 | 3.2% |
| Other values (24) | 30 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Letter | 42 | |
| Decimal Number | 10 | 15.9% |
| Space Separator | 7 | 11.1% |
| Close Punctuation | 2 | 3.2% |
| Open Punctuation | 2 | 3.2% |
Most frequent character per category
Other Letter
| Value | Count | Frequency (%) |
| 처 | 4 | 9.5% |
| 리 | 4 | 9.5% |
| 예 | 3 | 7.1% |
| 민 | 2 | 4.8% |
| 원 | 2 | 4.8% |
| 확 | 2 | 4.8% |
| 산 | 2 | 4.8% |
| 보 | 2 | 4.8% |
| 년 | 2 | 4.8% |
| 연 | 2 | 4.8% |
| Other values (16) | 17 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4 | |
| 0 | 3 | |
| 9 | 1 | 10.0% |
| 3 | 1 | 10.0% |
| 1 | 1 | 10.0% |
Space Separator
| Value | Count | Frequency (%) |
| 7 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Hangul | 42 | |
| Common | 21 |
Most frequent character per script
Hangul
| Value | Count | Frequency (%) |
| 처 | 4 | 9.5% |
| 리 | 4 | 9.5% |
| 예 | 3 | 7.1% |
| 민 | 2 | 4.8% |
| 원 | 2 | 4.8% |
| 확 | 2 | 4.8% |
| 산 | 2 | 4.8% |
| 보 | 2 | 4.8% |
| 년 | 2 | 4.8% |
| 연 | 2 | 4.8% |
| Other values (16) | 17 |
Common
| Value | Count | Frequency (%) |
| 7 | ||
| 2 | 4 | |
| 0 | 3 | |
| ) | 2 | 9.5% |
| ( | 2 | 9.5% |
| 9 | 1 | 4.8% |
| 3 | 1 | 4.8% |
| 1 | 1 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| Hangul | 42 | |
| ASCII | 21 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7 | ||
| 2 | 4 | |
| 0 | 3 | |
| ) | 2 | 9.5% |
| ( | 2 | 9.5% |
| 9 | 1 | 4.8% |
| 3 | 1 | 4.8% |
| 1 | 1 | 4.8% |
Hangul
| Value | Count | Frequency (%) |
| 처 | 4 | 9.5% |
| 리 | 4 | 9.5% |
| 예 | 3 | 7.1% |
| 민 | 2 | 4.8% |
| 원 | 2 | 4.8% |
| 확 | 2 | 4.8% |
| 산 | 2 | 4.8% |
| 보 | 2 | 4.8% |
| 년 | 2 | 4.8% |
| 연 | 2 | 4.8% |
| Other values (16) | 17 |
| 생활민원번호 | 출동처리여부 | 배정자부서명 | 이관처리부서명 | 이관부서명 | 협조요청일시 | 협조부서명 | 협조상위부서명 | 협조팀명 | 중장기연장처리예정일 | 중장기연장처리사유 | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 생활민원번호 | 1.000 | 0.257 | 0.299 | 0.263 | 0.583 | 1.000 | 0.782 | 0.671 | 0.968 | 1.000 | 1.000 |
| 출동처리여부 | 0.257 | 1.000 | 0.287 | 0.585 | 0.317 | 1.000 | 0.796 | 1.000 | 1.000 | 1.000 | 1.000 |
| 배정자부서명 | 0.299 | 0.287 | 1.000 | 0.856 | 0.995 | 0.000 | 0.000 | NaN | 0.000 | NaN | NaN |
| 이관처리부서명 | 0.263 | 0.585 | 0.856 | 1.000 | 0.977 | 1.000 | 0.873 | 1.000 | 1.000 | NaN | NaN |
| 이관부서명 | 0.583 | 0.317 | 0.995 | 0.977 | 1.000 | 1.000 | 0.767 | 1.000 | 1.000 | 0.000 | 0.000 |
| 협조요청일시 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | NaN | NaN |
| 협조부서명 | 0.782 | 0.796 | 0.000 | 0.873 | 0.767 | 1.000 | 1.000 | 1.000 | 1.000 | NaN | NaN |
| 협조상위부서명 | 0.671 | 1.000 | NaN | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | NaN | NaN |
| 협조팀명 | 0.968 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | NaN | NaN |
| 중장기연장처리예정일 | 1.000 | 1.000 | NaN | NaN | 0.000 | NaN | NaN | NaN | NaN | 1.000 | 1.000 |
| 중장기연장처리사유 | 1.000 | 1.000 | NaN | NaN | 0.000 | NaN | NaN | NaN | NaN | 1.000 | 1.000 |
| 생활민원번호 | 출동처리여부 | |
|---|---|---|
| 생활민원번호 | 1.000 | 0.171 |
| 출동처리여부 | 0.171 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| 생활민원번호 | 발송요청일시 | 발송일시 | 출동처리여부 | 출동예정일시 | 처리완료일시 | 이관요청일시 | 알림예약일시 | 배정자부서명 | 배정자팀명 | 이관처리부서명 | 이관처리팀명 | 이관시의견 | 이관부서명 | 협조요청일시 | 협조부서명 | 협조상위부서명 | 협조팀명 | 중장기연장처리예정일 | 중장기연장처리사유 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15080 | 20180927017 | 2018-09-27 13:10 | 2.02E+13 | N | 2018-09-27 11:30 | 2018-09-28 17:40 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 85524 | 20210119022 | 2021-01-24 19:11 | 20200000000000.0 | Y | 2021-01-24 19:10 | 2021-01-19 10:54 | <NA> | 민원봉사과 | 민원콜센터팀 | 경로장애인과 | 경로복지팀 | 담당자 변경 | 민원봉사과 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 85585 | 20210119059 | 2021-01-27 09:00 | 20200000000000.0 | Y | 2021-01-27 17:21 | 2021-01-19 16:46 | <NA> | <NA> | <NA> | 기후변화대책과 | 미세먼지대책팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 80941 | 20201127043 | 2020-11-27 17:54 | 20200000000000.0 | Y | 2020-11-30 09:08 | 2020-11-27 17:54 | <NA> | <NA> | <NA> | 대중교통과 | 운수지도팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 23422 | 20190118017 | 2019-01-21 09:33 | 2.02E+13 | Y | 2019-01-21 11:44 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 담당자 재지정 | 민원봉사과 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 22109 | 20181226003 | 2019-01-03 11:27 | 2.02E+13 | N | 2018-12-28 10:00 | 2019-01-03 11:27 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 57445 | 20200404008 | 2020-04-04 14:30 | 20200000000000.0 | N | 2020-04-06 15:00 | 2020-04-07 10:00 | 2020-04-04 14:30 | <NA> | <NA> | <NA> | 기후변화대책과 | 생활환경팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 49324 | 20191118006 | 2019-11-18 09:12 | 20200000000000.0 | N | 2019-11-18 14:30 | 2019-11-18 16:07 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 78853 | 20201102039 | 2020-11-02 14:42 | 20200000000000.0 | N | 2020-11-03 10:00 | 2020-11-03 11:41 | 2020-11-02 14:42 | <NA> | <NA> | <NA> | 배방읍 | 산업개발팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 74497 | 20200914062 | 2020-09-14 16:30 | 20200000000000.0 | N | 2020-09-14 17:00 | 2020-09-15 09:10 | 2020-09-14 16:30 | <NA> | <NA> | <NA> | 교통행정과 | 교통시설팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 생활민원번호 | 발송요청일시 | 발송일시 | 출동처리여부 | 출동예정일시 | 처리완료일시 | 이관요청일시 | 알림예약일시 | 배정자부서명 | 배정자팀명 | 이관처리부서명 | 이관처리팀명 | 이관시의견 | 이관부서명 | 협조요청일시 | 협조부서명 | 협조상위부서명 | 협조팀명 | 중장기연장처리예정일 | 중장기연장처리사유 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 56502 | 20200319051 | 2020-03-20 09:00 | 20200000000000.0 | Y | 2020-03-23 14:49 | 2020-03-19 20:22 | 2020-03-20 09:00 | 징수과 | 징수팀 | 공원녹지과 | 공원관리팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 24913 | 20190219020 | 2019-02-19 13:53 | 2.02E+13 | N | 2019-02-21 11:30 | 2019-02-22 09:01 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 38392 | 20190719010 | 2019-08-01 09:00 | 20200000000000.0 | Y | 2019-08-22 19:24 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 28317 | 20190405024 | 2019-04-05 13:57 | 2.02E+13 | N | 2019-04-08 10:30 | 2019-04-08 16:16 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 66662 | 20200724065 | 2020-07-24 17:43 | 20200000000000.0 | Y | 2020-08-01 16:25 | 2020-07-24 17:43 | <NA> | <NA> | <NA> | 도로과 | 도로관리팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 7061 | 20180710002 | 2018-07-10 09:05 | 2.02E+13 | Y | 2018-07-12 14:39 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 89068 | 20210226030 | 2021-03-09 09:00 | 20200000000000.0 | Y | 2021-03-05 13:00 | 2021-03-09 17:47 | 2021-02-26 14:53 | <NA> | <NA> | <NA> | 둔포면 | 산업개발팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
| 87207 | 20210205018 | 2021-02-05 10:10 | 20200000000000.0 | Y | 2021-02-09 16:02 | 2021-02-05 10:10 | <NA> | <NA> | <NA> | 기후변화대책과 | 미세먼지대책팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 55637 | 20200303020 | 2020-03-03 14:49 | 20200000000000.0 | Y | 2020-03-10 14:54 | 2020-03-03 14:49 | <NA> | <NA> | <NA> | 감사위원회 | 조사팀 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | |
| 51143 | 20191214004 | 2019-12-18 11:06 | 20200000000000.0 | Y | 2019-12-18 11:06 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
Most frequently occurring
| 생활민원번호 | 발송요청일시 | 출동처리여부 | 출동예정일시 | 처리완료일시 | 이관요청일시 | 알림예약일시 | 배정자부서명 | 배정자팀명 | 이관처리부서명 | 이관처리팀명 | 이관시의견 | 이관부서명 | 협조요청일시 | 협조부서명 | 협조상위부서명 | 협조팀명 | 중장기연장처리예정일 | 중장기연장처리사유 | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 20180516005 | 2018-05-16 08:37 | N | 2018-05-16 10:00 | 2018-05-17 08:28 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 |
| 1 | 20180520003 | 2018-05-20 10:40 | Y | 2018-05-21 13:23 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | |
| 2 | 20180627054 | 2018-06-28 09:00 | N | 2018-07-02 10:00 | 2018-07-02 10:47 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 담당자 변경 | 배방읍 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 |
| 3 | 20180718021 | 2018-07-18 12:45 | Y | 2018-07-18 13:49 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | |
| 4 | 20180811018 | 2018-08-11 15:39 | Y | 2018-08-13 14:40 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | |
| 5 | 20180911028 | 2018-09-11 12:55 | N | 2018-09-11 16:00 | 2018-09-17 09:06 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 |
| 6 | 20180916016 | 2018-09-27 09:00 | Y | 2018-09-27 21:37 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | |
| 7 | 20181011029 | 2018-10-11 18:20 | Y | 2018-10-17 09:45 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 | |
| 8 | 20181012027 | 2018-10-12 14:17 | N | 2018-10-12 14:00 | 2018-10-16 16:52 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 |
| 9 | 20181014010 | 2018-10-15 09:00 | Y | 2018-10-15 10:30 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> | 2 |