Overview

Dataset statistics

Number of variables24
Number of observations6525
Missing cells117430
Missing cells (%)75.0%
Duplicate rows155
Duplicate rows (%)2.4%
Total size in memory1.3 MiB
Average record size in memory214.0 B

Variable types

Numeric5
Categorical1
Text2
Unsupported16

Dataset

Description산림복지서비스이용권시스템에서 추출한 공지사항입니다.
Author한국산림복지진흥원
URLhttps://www.data.go.kr/data/15088981/fileData.do

Alerts

Dataset has 155 (2.4%) duplicate rowsDuplicates
발급건수(ISSUE_CNT) is highly imbalanced (99.2%)Imbalance
게시글ID(NTT_ID) has 6515 (99.8%) missing valuesMissing
첫 등록일자(FRST_REGISTER_PNTTM) has 6515 (99.8%) missing valuesMissing
최종수정일자(LAST_UPDUSR_PNTTM) has 6525 (100.0%) missing valuesMissing
만족도번호(STSFDG_NO) has 6525 (100.0%) missing valuesMissing
게시물ID(NTT_ID) has 6525 (100.0%) missing valuesMissing
게사판ID(BBS_ID) has 6525 (100.0%) missing valuesMissing
만족도(STSFDG) has 6525 (100.0%) missing valuesMissing
만족도내용(STSFDG_CN) has 6525 (100.0%) missing valuesMissing
사용여부(USE_AT) has 6525 (100.0%) missing valuesMissing
최초등록시점(FRST_REGISTER_PNTTM) has 6525 (100.0%) missing valuesMissing
최종수정시점(FRST_REGISTER_ID) has 6525 (100.0%) missing valuesMissing
댓글번호(COMMENT_NO) has 6525 (100.0%) missing valuesMissing
게시글ID(NTT_ID).1 has 6525 (100.0%) missing valuesMissing
게시판ID(BBS_ID) has 6525 (100.0%) missing valuesMissing
댓글 시리얼넘버(COMMENT_CN) has 6525 (100.0%) missing valuesMissing
사용여부(USE_AT).1 has 6525 (100.0%) missing valuesMissing
첫 등록일자(FRST_REGISTER_PNTTM).1 has 6525 (100.0%) missing valuesMissing
최종수정일자(FRST_REGISTER_ID) has 6525 (100.0%) missing valuesMissing
성공건수(SUCCESS_COUNT) is highly skewed (γ1 = 26.92890167)Skewed
실패건수(FAIL_COUNT) is highly skewed (γ1 = 80.76701267)Skewed
최종수정일자(LAST_UPDUSR_PNTTM) is an unsupported type, check if it needs cleaning or further analysisUnsupported
만족도번호(STSFDG_NO) is an unsupported type, check if it needs cleaning or further analysisUnsupported
게시물ID(NTT_ID) is an unsupported type, check if it needs cleaning or further analysisUnsupported
게사판ID(BBS_ID) is an unsupported type, check if it needs cleaning or further analysisUnsupported
만족도(STSFDG) is an unsupported type, check if it needs cleaning or further analysisUnsupported
만족도내용(STSFDG_CN) is an unsupported type, check if it needs cleaning or further analysisUnsupported
사용여부(USE_AT) is an unsupported type, check if it needs cleaning or further analysisUnsupported
최초등록시점(FRST_REGISTER_PNTTM) is an unsupported type, check if it needs cleaning or further analysisUnsupported
최종수정시점(FRST_REGISTER_ID) is an unsupported type, check if it needs cleaning or further analysisUnsupported
댓글번호(COMMENT_NO) is an unsupported type, check if it needs cleaning or further analysisUnsupported
게시글ID(NTT_ID).1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
게시판ID(BBS_ID) is an unsupported type, check if it needs cleaning or further analysisUnsupported
댓글 시리얼넘버(COMMENT_CN) is an unsupported type, check if it needs cleaning or further analysisUnsupported
사용여부(USE_AT).1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
첫 등록일자(FRST_REGISTER_PNTTM).1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
최종수정일자(FRST_REGISTER_ID) is an unsupported type, check if it needs cleaning or further analysisUnsupported
전체건수(MESSAGE_COUNT) has 4672 (71.6%) zerosZeros
성공건수(SUCCESS_COUNT) has 5258 (80.6%) zerosZeros
실패건수(FAIL_COUNT) has 6500 (99.6%) zerosZeros

Reproduction

Analysis started2023-12-12 14:28:37.100180
Analysis finished2023-12-12 14:28:37.380247
Duration0.28 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

게시글ID(NTT_ID)
Real number (ℝ)

MISSING 

Distinct7
Distinct (%)70.0%
Missing6515
Missing (%)99.8%
Infinite0
Infinite (%)0.0%
Mean86
Minimum54
Maximum122
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size57.5 KiB
2023-12-12T23:28:37.486104image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum54
5-th percentile54.45
Q159.75
median72.5
Q3121.25
95-th percentile122
Maximum122
Range68
Interquartile range (IQR)61.5

Descriptive statistics

Standard deviation31.361689
Coefficient of variation (CV)0.36467081
Kurtosis-2.2203408
Mean86
Median Absolute Deviation (MAD)18
Skewness0.29712153
Sum860
Variance983.55556
MonotonicityNot monotonic
2023-12-12T23:28:37.607040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
122 3
 
< 0.1%
62 2
 
< 0.1%
83 1
 
< 0.1%
55 1
 
< 0.1%
54 1
 
< 0.1%
59 1
 
< 0.1%
119 1
 
< 0.1%
(Missing) 6515
99.8%
ValueCountFrequency (%)
54 1
 
< 0.1%
55 1
 
< 0.1%
59 1
 
< 0.1%
62 2
< 0.1%
83 1
 
< 0.1%
119 1
 
< 0.1%
122 3
< 0.1%
ValueCountFrequency (%)
122 3
< 0.1%
119 1
 
< 0.1%
83 1
 
< 0.1%
62 2
< 0.1%
59 1
 
< 0.1%
55 1
 
< 0.1%
54 1
 
< 0.1%

발급건수(ISSUE_CNT)
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size51.1 KiB
<NA>
6515 
2
 
5
4
 
3
3
 
1
1
 
1

Length

Max length4
Median length4
Mean length3.9954023
Min length1

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row2
2nd row4
3rd row3
4th row2
5th row2

Common Values

ValueCountFrequency (%)
<NA> 6515
99.8%
2 5
 
0.1%
4 3
 
< 0.1%
3 1
 
< 0.1%
1 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T23:28:38.277455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 6515
99.8%
2 5
 
0.1%
4 3
 
< 0.1%
3 1
 
< 0.1%
1 1
 
< 0.1%

첫 등록일자(FRST_REGISTER_PNTTM)
Text

MISSING 

Distinct10
Distinct (%)100.0%
Missing6515
Missing (%)99.8%
Memory size51.1 KiB
2023-12-12T23:28:38.426780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

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

Unique

Unique10 ?
Unique (%)100.0%

Sample

1st row40:43.0
2nd row49:13.0
3rd row36:08.0
4th row01:57.0
5th row31:27.0
ValueCountFrequency (%)
40:43.0 1
10.0%
49:13.0 1
10.0%
36:08.0 1
10.0%
01:57.0 1
10.0%
31:27.0 1
10.0%
50:40.0 1
10.0%
08:24.0 1
10.0%
59:43.0 1
10.0%
30:57.0 1
10.0%
56:21.0 1
10.0%
2023-12-12T23:28:38.700192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 17
24.3%
: 10
14.3%
. 10
14.3%
4 6
 
8.6%
3 6
 
8.6%
5 5
 
7.1%
1 4
 
5.7%
7 3
 
4.3%
2 3
 
4.3%
9 2
 
2.9%
Other values (2) 4
 
5.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 50
71.4%
Other Punctuation 20
 
28.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 17
34.0%
4 6
 
12.0%
3 6
 
12.0%
5 5
 
10.0%
1 4
 
8.0%
7 3
 
6.0%
2 3
 
6.0%
9 2
 
4.0%
6 2
 
4.0%
8 2
 
4.0%
Other Punctuation
ValueCountFrequency (%)
: 10
50.0%
. 10
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 70
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 17
24.3%
: 10
14.3%
. 10
14.3%
4 6
 
8.6%
3 6
 
8.6%
5 5
 
7.1%
1 4
 
5.7%
7 3
 
4.3%
2 3
 
4.3%
9 2
 
2.9%
Other values (2) 4
 
5.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 70
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 17
24.3%
: 10
14.3%
. 10
14.3%
4 6
 
8.6%
3 6
 
8.6%
5 5
 
7.1%
1 4
 
5.7%
7 3
 
4.3%
2 3
 
4.3%
9 2
 
2.9%
Other values (2) 4
 
5.7%

최종수정일자(LAST_UPDUSR_PNTTM)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

만족도번호(STSFDG_NO)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

게시물ID(NTT_ID)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

게사판ID(BBS_ID)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

만족도(STSFDG)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

만족도내용(STSFDG_CN)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

사용여부(USE_AT)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

최초등록시점(FRST_REGISTER_PNTTM)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

최종수정시점(FRST_REGISTER_ID)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

댓글번호(COMMENT_NO)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

게시글ID(NTT_ID).1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

게시판ID(BBS_ID)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

댓글 시리얼넘버(COMMENT_CN)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

사용여부(USE_AT).1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

첫 등록일자(FRST_REGISTER_PNTTM).1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

최종수정일자(FRST_REGISTER_ID)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6525
Missing (%)100.0%
Memory size57.5 KiB

수신일자(BATCH_YMD)
Real number (ℝ)

Distinct1124
Distinct (%)17.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20180852
Minimum20161129
Maximum20200106
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size57.5 KiB
2023-12-12T23:28:38.881762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20161129
5-th percentile20170215
Q120171009
median20180719
Q320190425
95-th percentile20191115
Maximum20200106
Range38977
Interquartile range (IQR)19416

Descriptive statistics

Standard deviation8670.8923
Coefficient of variation (CV)0.00042965938
Kurtosis-1.1807016
Mean20180852
Median Absolute Deviation (MAD)9708
Skewness-0.1618614
Sum1.3168006 × 1011
Variance75184373
MonotonicityNot monotonic
2023-12-12T23:28:39.091846image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20170620 58
 
0.9%
20180716 39
 
0.6%
20170214 29
 
0.4%
20170303 18
 
0.3%
20190225 13
 
0.2%
20190715 11
 
0.2%
20190307 11
 
0.2%
20170927 9
 
0.1%
20170215 9
 
0.1%
20190619 8
 
0.1%
Other values (1114) 6320
96.9%
ValueCountFrequency (%)
20161129 4
0.1%
20161201 5
0.1%
20161202 5
0.1%
20161203 3
< 0.1%
20161204 3
< 0.1%
20161205 4
0.1%
20161206 4
0.1%
20161207 5
0.1%
20161208 5
0.1%
20161209 5
0.1%
ValueCountFrequency (%)
20200106 7
0.1%
20200105 3
 
< 0.1%
20200104 3
 
< 0.1%
20200103 8
0.1%
20200102 8
0.1%
20200101 3
 
< 0.1%
20191231 8
0.1%
20191230 8
0.1%
20191229 3
 
< 0.1%
20191228 3
 
< 0.1%

전체건수(MESSAGE_COUNT)
Real number (ℝ)

ZEROS 

Distinct324
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66.658544
Minimum0
Maximum17952
Zeros4672
Zeros (%)71.6%
Negative0
Negative (%)0.0%
Memory size57.5 KiB
2023-12-12T23:28:39.249041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile140
Maximum17952
Range17952
Interquartile range (IQR)1

Descriptive statistics

Standard deviation695.34022
Coefficient of variation (CV)10.431374
Kurtosis369.27666
Mean66.658544
Median Absolute Deviation (MAD)0
Skewness18.047799
Sum434947
Variance483498.03
MonotonicityNot monotonic
2023-12-12T23:28:39.418272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 4672
71.6%
1 457
 
7.0%
2 212
 
3.2%
3 115
 
1.8%
4 49
 
0.8%
5 45
 
0.7%
6 37
 
0.6%
21 24
 
0.4%
8 20
 
0.3%
22 19
 
0.3%
Other values (314) 875
 
13.4%
ValueCountFrequency (%)
0 4672
71.6%
1 457
 
7.0%
2 212
 
3.2%
3 115
 
1.8%
4 49
 
0.8%
5 45
 
0.7%
6 37
 
0.6%
7 15
 
0.2%
8 20
 
0.3%
9 10
 
0.2%
ValueCountFrequency (%)
17952 2
 
< 0.1%
14556 1
 
< 0.1%
14546 3
< 0.1%
14020 3
< 0.1%
13285 1
 
< 0.1%
10409 2
 
< 0.1%
9646 1
 
< 0.1%
6929 1
 
< 0.1%
5136 6
0.1%
5099 1
 
< 0.1%

성공건수(SUCCESS_COUNT)
Real number (ℝ)

SKEWED  ZEROS 

Distinct317
Distinct (%)4.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36.284598
Minimum0
Maximum17952
Zeros5258
Zeros (%)80.6%
Negative0
Negative (%)0.0%
Memory size57.5 KiB
2023-12-12T23:28:39.588271image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile114.8
Maximum17952
Range17952
Interquartile range (IQR)0

Descriptive statistics

Standard deviation458.40581
Coefficient of variation (CV)12.63362
Kurtosis835.84587
Mean36.284598
Median Absolute Deviation (MAD)0
Skewness26.928902
Sum236757
Variance210135.89
MonotonicityNot monotonic
2023-12-12T23:28:39.750141image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5258
80.6%
1 235
 
3.6%
2 116
 
1.8%
3 69
 
1.1%
4 29
 
0.4%
5 27
 
0.4%
6 22
 
0.3%
8 15
 
0.2%
21 14
 
0.2%
7 11
 
0.2%
Other values (307) 729
 
11.2%
ValueCountFrequency (%)
0 5258
80.6%
1 235
 
3.6%
2 116
 
1.8%
3 69
 
1.1%
4 29
 
0.4%
5 27
 
0.4%
6 22
 
0.3%
7 11
 
0.2%
8 15
 
0.2%
9 8
 
0.1%
ValueCountFrequency (%)
17952 1
< 0.1%
14546 1
< 0.1%
14020 1
< 0.1%
13285 1
< 0.1%
10409 1
< 0.1%
9646 1
< 0.1%
6929 1
< 0.1%
4638 1
< 0.1%
4063 1
< 0.1%
4000 1
< 0.1%

실패건수(FAIL_COUNT)
Real number (ℝ)

SKEWED  ZEROS 

Distinct14
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.2764751
Minimum0
Maximum14546
Zeros6500
Zeros (%)99.6%
Negative0
Negative (%)0.0%
Memory size57.5 KiB
2023-12-12T23:28:39.867969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q30
95-th percentile0
Maximum14546
Range14546
Interquartile range (IQR)0

Descriptive statistics

Standard deviation180.08218
Coefficient of variation (CV)79.105709
Kurtosis6523.8688
Mean2.2764751
Median Absolute Deviation (MAD)0
Skewness80.767013
Sum14854
Variance32429.59
MonotonicityNot monotonic
2023-12-12T23:28:40.002400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0 6500
99.6%
1 10
 
0.2%
3 3
 
< 0.1%
5 2
 
< 0.1%
25 1
 
< 0.1%
2 1
 
< 0.1%
13 1
 
< 0.1%
6 1
 
< 0.1%
28 1
 
< 0.1%
4 1
 
< 0.1%
Other values (4) 4
 
0.1%
ValueCountFrequency (%)
0 6500
99.6%
1 10
 
0.2%
2 1
 
< 0.1%
3 3
 
< 0.1%
4 1
 
< 0.1%
5 2
 
< 0.1%
6 1
 
< 0.1%
13 1
 
< 0.1%
25 1
 
< 0.1%
28 1
 
< 0.1%
ValueCountFrequency (%)
14546 1
< 0.1%
109 1
< 0.1%
62 1
< 0.1%
30 1
< 0.1%
28 1
< 0.1%
25 1
< 0.1%
13 1
< 0.1%
6 1
< 0.1%
5 2
< 0.1%
4 1
< 0.1%

등록일자(REG_DATE)
Text

Distinct534
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size51.1 KiB
2023-12-12T23:28:40.374835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length7
Mean length7
Min length7

Characters and Unicode

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

Unique

Unique196 ?
Unique (%)3.0%

Sample

1st row19:37.0
2nd row00:20.0
3rd row00:08.0
4th row00:10.0
5th row00:12.0
ValueCountFrequency (%)
00:59.0 93
 
1.4%
01:00.0 86
 
1.3%
00:53.0 83
 
1.3%
00:54.0 81
 
1.2%
00:57.0 79
 
1.2%
00:46.0 78
 
1.2%
00:33.0 78
 
1.2%
00:20.0 76
 
1.2%
00:55.0 76
 
1.2%
00:52.0 76
 
1.2%
Other values (524) 5719
87.6%
2023-12-12T23:28:40.898391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 17683
38.7%
: 6525
 
14.3%
. 6525
 
14.3%
1 3923
 
8.6%
2 2622
 
5.7%
5 1926
 
4.2%
3 1775
 
3.9%
4 1770
 
3.9%
9 849
 
1.9%
8 749
 
1.6%
Other values (2) 1328
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 32625
71.4%
Other Punctuation 13050
 
28.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 17683
54.2%
1 3923
 
12.0%
2 2622
 
8.0%
5 1926
 
5.9%
3 1775
 
5.4%
4 1770
 
5.4%
9 849
 
2.6%
8 749
 
2.3%
6 693
 
2.1%
7 635
 
1.9%
Other Punctuation
ValueCountFrequency (%)
: 6525
50.0%
. 6525
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 45675
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 17683
38.7%
: 6525
 
14.3%
. 6525
 
14.3%
1 3923
 
8.6%
2 2622
 
5.7%
5 1926
 
4.2%
3 1775
 
3.9%
4 1770
 
3.9%
9 849
 
1.9%
8 749
 
1.6%
Other values (2) 1328
 
2.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 45675
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 17683
38.7%
: 6525
 
14.3%
. 6525
 
14.3%
1 3923
 
8.6%
2 2622
 
5.7%
5 1926
 
4.2%
3 1775
 
3.9%
4 1770
 
3.9%
9 849
 
1.9%
8 749
 
1.6%
Other values (2) 1328
 
2.9%

Sample

게시글ID(NTT_ID)발급건수(ISSUE_CNT)첫 등록일자(FRST_REGISTER_PNTTM)최종수정일자(LAST_UPDUSR_PNTTM)만족도번호(STSFDG_NO)게시물ID(NTT_ID)게사판ID(BBS_ID)만족도(STSFDG)만족도내용(STSFDG_CN)사용여부(USE_AT)최초등록시점(FRST_REGISTER_PNTTM)최종수정시점(FRST_REGISTER_ID)댓글번호(COMMENT_NO)게시글ID(NTT_ID).1게시판ID(BBS_ID)댓글 시리얼넘버(COMMENT_CN)사용여부(USE_AT).1첫 등록일자(FRST_REGISTER_PNTTM).1최종수정일자(FRST_REGISTER_ID)수신일자(BATCH_YMD)전체건수(MESSAGE_COUNT)성공건수(SUCCESS_COUNT)실패건수(FAIL_COUNT)등록일자(REG_DATE)
083240:43.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016121677019:37.0
1122449:13.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016122400000:20.0
2122336:08.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016122900000:08.0
355201:57.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016122900000:10.0
462231:27.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016122900000:12.0
5122450:40.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016123000000:06.0
654108:24.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016123000000:08.0
759259:43.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2016123100000:18.0
862230:57.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>201701023535019:31.0
9119456:21.0<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2017010600000:55.0
게시글ID(NTT_ID)발급건수(ISSUE_CNT)첫 등록일자(FRST_REGISTER_PNTTM)최종수정일자(LAST_UPDUSR_PNTTM)만족도번호(STSFDG_NO)게시물ID(NTT_ID)게사판ID(BBS_ID)만족도(STSFDG)만족도내용(STSFDG_CN)사용여부(USE_AT)최초등록시점(FRST_REGISTER_PNTTM)최종수정시점(FRST_REGISTER_ID)댓글번호(COMMENT_NO)게시글ID(NTT_ID).1게시판ID(BBS_ID)댓글 시리얼넘버(COMMENT_CN)사용여부(USE_AT).1첫 등록일자(FRST_REGISTER_PNTTM).1최종수정일자(FRST_REGISTER_ID)수신일자(BATCH_YMD)전체건수(MESSAGE_COUNT)성공건수(SUCCESS_COUNT)실패건수(FAIL_COUNT)등록일자(REG_DATE)
6515<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121200001:46.0
6516<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121300000:17.0
6517<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121310000:29.0
6518<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121300000:31.0
6519<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121300000:53.0
6520<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121311000:55.0
6521<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019121400000:38.0
6522<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019122100000:12.0
6523<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019122120000:15.0
6524<NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA><NA>2019122100000:17.0

Duplicate rows

Most frequently occurring

게시글ID(NTT_ID)발급건수(ISSUE_CNT)첫 등록일자(FRST_REGISTER_PNTTM)수신일자(BATCH_YMD)전체건수(MESSAGE_COUNT)성공건수(SUCCESS_COUNT)실패건수(FAIL_COUNT)등록일자(REG_DATE)# duplicates
42<NA><NA><NA>2019042200001:16.03
43<NA><NA><NA>2019042300001:23.03
47<NA><NA><NA>2019050200001:23.03
53<NA><NA><NA>2019052000001:25.03
66<NA><NA><NA>2019062500001:31.03
74<NA><NA><NA>2019071100001:21.03
78<NA><NA><NA>2019072300000:48.03
80<NA><NA><NA>2019080600001:24.03
84<NA><NA><NA>2019081300001:11.03
113<NA><NA><NA>2019102100000:58.03