Overview

Dataset statistics

Number of variables28
Number of observations56
Missing cells252
Missing cells (%)16.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory13.4 KiB
Average record size in memory245.4 B

Variable types

Numeric15
Categorical6
Unsupported3
Boolean2
DateTime2

Alerts

대상업체 has constant value ""Constant
행사 종료일자 has constant value ""Constant
등록 사용자종류 has constant value ""Constant
수정 사용자종류 has constant value ""Constant
상태 is highly imbalanced (50.9%)Imbalance
등급 is highly imbalanced (77.9%)Imbalance
할인비율 공개여부 is highly imbalanced (69.9%)Imbalance
게시 종료일자 has 56 (100.0%) missing valuesMissing
정상가격(KRW) has 1 (1.8%) missing valuesMissing
정상가격(USD) has 1 (1.8%) missing valuesMissing
할인가격(KRW) has 14 (25.0%) missing valuesMissing
할인가격(USD) has 13 (23.2%) missing valuesMissing
할인비율 has 36 (64.3%) missing valuesMissing
첨부파일 고유식별번호(UID) has 1 (1.8%) missing valuesMissing
에디터이미지 첨부파일 고유식별번호(UID) has 18 (32.1%) missing valuesMissing
등록 사용자그룹 has 56 (100.0%) missing valuesMissing
수정 사용자그룹 has 56 (100.0%) missing valuesMissing
고유식별번호(UID) has unique valuesUnique
게시 종료일자 is an unsupported type, check if it needs cleaning or further analysisUnsupported
등록 사용자그룹 is an unsupported type, check if it needs cleaning or further analysisUnsupported
수정 사용자그룹 is an unsupported type, check if it needs cleaning or further analysisUnsupported
조회수 has 37 (66.1%) zerosZeros

Reproduction

Analysis started2024-03-18 03:39:16.895781
Analysis finished2024-03-18 03:39:17.081120
Duration0.19 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

고유식별번호(UID)
Real number (ℝ)

UNIQUE 

Distinct56
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean42.142857
Minimum12
Maximum75
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:17.148373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile16.5
Q127.75
median41.5
Q355.25
95-th percentile71.25
Maximum75
Range63
Interquartile range (IQR)27.5

Descriptive statistics

Standard deviation17.616551
Coefficient of variation (CV)0.41801985
Kurtosis-0.98998211
Mean42.142857
Median Absolute Deviation (MAD)14
Skewness0.15188759
Sum2360
Variance310.34286
MonotonicityStrictly increasing
2024-03-18T12:39:17.393158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12 1
 
1.8%
43 1
 
1.8%
45 1
 
1.8%
46 1
 
1.8%
47 1
 
1.8%
48 1
 
1.8%
49 1
 
1.8%
50 1
 
1.8%
51 1
 
1.8%
52 1
 
1.8%
Other values (46) 46
82.1%
ValueCountFrequency (%)
12 1
1.8%
13 1
1.8%
15 1
1.8%
17 1
1.8%
18 1
1.8%
19 1
1.8%
20 1
1.8%
21 1
1.8%
22 1
1.8%
23 1
1.8%
ValueCountFrequency (%)
75 1
1.8%
73 1
1.8%
72 1
1.8%
71 1
1.8%
70 1
1.8%
69 1
1.8%
68 1
1.8%
67 1
1.8%
61 1
1.8%
60 1
1.8%

병원 식별번호
Real number (ℝ)

Distinct18
Distinct (%)32.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean68.446429
Minimum51
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:17.527439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum51
5-th percentile51
Q152
median59
Q388.25
95-th percentile98
Maximum100
Range49
Interquartile range (IQR)36.25

Descriptive statistics

Standard deviation17.831453
Coefficient of variation (CV)0.26051692
Kurtosis-1.5356964
Mean68.446429
Median Absolute Deviation (MAD)8
Skewness0.51857177
Sum3833
Variance317.96071
MonotonicityNot monotonic
2024-03-18T12:39:17.623068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
51 12
21.4%
90 6
10.7%
61 5
8.9%
59 5
8.9%
52 4
 
7.1%
86 4
 
7.1%
55 3
 
5.4%
92 3
 
5.4%
57 3
 
5.4%
88 2
 
3.6%
Other values (8) 9
16.1%
ValueCountFrequency (%)
51 12
21.4%
52 4
 
7.1%
55 3
 
5.4%
56 1
 
1.8%
57 3
 
5.4%
58 1
 
1.8%
59 5
8.9%
60 1
 
1.8%
61 5
8.9%
83 1
 
1.8%
ValueCountFrequency (%)
100 1
 
1.8%
99 1
 
1.8%
98 2
 
3.6%
92 3
5.4%
90 6
10.7%
89 1
 
1.8%
88 2
 
3.6%
86 4
7.1%
83 1
 
1.8%
61 5
8.9%

대상업체
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size580.0 B
,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,
56 

Length

Max length92
Median length92
Mean length92
Min length92

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,
2nd row,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,
3rd row,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,
4th row,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,
5th row,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,

Common Values

ValueCountFrequency (%)
,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE, 56
100.0%

Length

2024-03-18T12:39:17.724893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:17.823849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
type__mtis,type__city_hall,type__hospital,type__agency,type__health_center,type__pr_office 56
100.0%

진료과 공통코드
Real number (ℝ)

Distinct19
Distinct (%)33.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.910714
Minimum1
Maximum33
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:17.935919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q17.75
median17
Q331
95-th percentile33
Maximum33
Range32
Interquartile range (IQR)23.25

Descriptive statistics

Standard deviation11.884714
Coefficient of variation (CV)0.66355333
Kurtosis-1.5253858
Mean17.910714
Median Absolute Deviation (MAD)11.5
Skewness-0.069281391
Sum1003
Variance141.24643
MonotonicityNot monotonic
2024-03-18T12:39:18.038534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
33 10
17.9%
1 6
10.7%
24 6
10.7%
10 5
8.9%
31 5
8.9%
17 4
 
7.1%
2 3
 
5.4%
20 2
 
3.6%
3 2
 
3.6%
15 2
 
3.6%
Other values (9) 11
19.6%
ValueCountFrequency (%)
1 6
10.7%
2 3
5.4%
3 2
 
3.6%
5 1
 
1.8%
6 1
 
1.8%
7 1
 
1.8%
8 1
 
1.8%
9 2
 
3.6%
10 5
8.9%
12 1
 
1.8%
ValueCountFrequency (%)
33 10
17.9%
32 1
 
1.8%
31 5
8.9%
28 1
 
1.8%
26 2
 
3.6%
24 6
10.7%
20 2
 
3.6%
17 4
 
7.1%
15 2
 
3.6%
12 1
 
1.8%

상태
Categorical

IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
IS_OPENED
50 
IS_CLOSED
6 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowIS_OPENED
2nd rowIS_OPENED
3rd rowIS_CLOSED
4th rowIS_OPENED
5th rowIS_OPENED

Common Values

ValueCountFrequency (%)
IS_OPENED 50
89.3%
IS_CLOSED 6
 
10.7%

Length

2024-03-18T12:39:18.129327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:18.217114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
is_opened 50
89.3%
is_closed 6
 
10.7%

게시 시작일자
Real number (ℝ)

Distinct27
Distinct (%)48.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20163177
Minimum20160503
Maximum20181204
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:18.330725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20160503
5-th percentile20160753
Q120161114
median20161209
Q320161227
95-th percentile20173224
Maximum20181204
Range20701
Interquartile range (IQR)112.5

Descriptive statistics

Standard deviation5123.2282
Coefficient of variation (CV)0.00025408835
Kurtosis5.7415657
Mean20163177
Median Absolute Deviation (MAD)18
Skewness2.5436942
Sum1.1291379 × 109
Variance26247467
MonotonicityNot monotonic
2024-03-18T12:39:18.431185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
20161209 16
28.6%
20161212 6
 
10.7%
20161227 6
 
10.7%
20161021 3
 
5.4%
20161017 2
 
3.6%
20161106 2
 
3.6%
20180814 1
 
1.8%
20180109 1
 
1.8%
20170929 1
 
1.8%
20170823 1
 
1.8%
Other values (17) 17
30.4%
ValueCountFrequency (%)
20160503 1
 
1.8%
20160513 1
 
1.8%
20160520 1
 
1.8%
20160831 1
 
1.8%
20161017 2
3.6%
20161021 3
5.4%
20161101 1
 
1.8%
20161106 2
3.6%
20161109 1
 
1.8%
20161113 1
 
1.8%
ValueCountFrequency (%)
20181204 1
 
1.8%
20180814 1
 
1.8%
20180109 1
 
1.8%
20170929 1
 
1.8%
20170823 1
 
1.8%
20170522 1
 
1.8%
20170414 1
 
1.8%
20170125 1
 
1.8%
20170118 1
 
1.8%
20161227 6
10.7%

게시 종료일자
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing56
Missing (%)100.0%
Memory size636.0 B

행사 시작일자
Real number (ℝ)

Distinct27
Distinct (%)48.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20163177
Minimum20160503
Maximum20181204
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:18.539817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20160503
5-th percentile20160753
Q120161114
median20161209
Q320161227
95-th percentile20173224
Maximum20181204
Range20701
Interquartile range (IQR)112.5

Descriptive statistics

Standard deviation5123.2282
Coefficient of variation (CV)0.00025408835
Kurtosis5.7415657
Mean20163177
Median Absolute Deviation (MAD)18
Skewness2.5436942
Sum1.1291379 × 109
Variance26247467
MonotonicityNot monotonic
2024-03-18T12:39:18.654456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
20161209 16
28.6%
20161212 6
 
10.7%
20161227 6
 
10.7%
20161021 3
 
5.4%
20161017 2
 
3.6%
20161106 2
 
3.6%
20180814 1
 
1.8%
20180109 1
 
1.8%
20170929 1
 
1.8%
20170823 1
 
1.8%
Other values (17) 17
30.4%
ValueCountFrequency (%)
20160503 1
 
1.8%
20160513 1
 
1.8%
20160520 1
 
1.8%
20160831 1
 
1.8%
20161017 2
3.6%
20161021 3
5.4%
20161101 1
 
1.8%
20161106 2
3.6%
20161109 1
 
1.8%
20161113 1
 
1.8%
ValueCountFrequency (%)
20181204 1
 
1.8%
20180814 1
 
1.8%
20180109 1
 
1.8%
20170929 1
 
1.8%
20170823 1
 
1.8%
20170522 1
 
1.8%
20170414 1
 
1.8%
20170125 1
 
1.8%
20170118 1
 
1.8%
20161227 6
10.7%

행사 종료일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size580.0 B
20211231
56 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20211231
2nd row20211231
3rd row20211231
4th row20211231
5th row20211231

Common Values

ValueCountFrequency (%)
20211231 56
100.0%

Length

2024-03-18T12:39:18.766584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:18.865947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20211231 56
100.0%

등급
Categorical

IMBALANCE 

Distinct3
Distinct (%)5.4%
Missing0
Missing (%)0.0%
Memory size580.0 B
A
53 
C
 
2
B
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.8%

Sample

1st rowA
2nd rowA
3rd rowA
4th rowC
5th rowA

Common Values

ValueCountFrequency (%)
A 53
94.6%
C 2
 
3.6%
B 1
 
1.8%

Length

2024-03-18T12:39:18.959582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:19.043696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
a 53
94.6%
c 2
 
3.6%
b 1
 
1.8%

정상가격(KRW)
Real number (ℝ)

MISSING 

Distinct37
Distinct (%)67.3%
Missing1
Missing (%)1.8%
Infinite0
Infinite (%)0.0%
Mean1781611.4
Minimum44
Maximum14000000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:19.129668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum44
5-th percentile444
Q1100000
median350000
Q31925000
95-th percentile9650000
Maximum14000000
Range13999956
Interquartile range (IQR)1825000

Descriptive statistics

Standard deviation3130743.2
Coefficient of variation (CV)1.7572536
Kurtosis5.9111019
Mean1781611.4
Median Absolute Deviation (MAD)347000
Skewness2.4657994
Sum97988629
Variance9.8015527 × 1012
MonotonicityNot monotonic
2024-03-18T12:39:19.239663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
100000 7
 
12.5%
10000 4
 
7.1%
5000000 3
 
5.4%
444 2
 
3.6%
1500000 2
 
3.6%
400000 2
 
3.6%
2400000 2
 
3.6%
120000 2
 
3.6%
2000000 2
 
3.6%
1000000 2
 
3.6%
Other values (27) 27
48.2%
ValueCountFrequency (%)
44 1
 
1.8%
333 1
 
1.8%
444 2
 
3.6%
555 1
 
1.8%
3000 1
 
1.8%
10000 4
7.1%
12121 1
 
1.8%
20000 1
 
1.8%
33344 1
 
1.8%
100000 7
12.5%
ValueCountFrequency (%)
14000000 1
 
1.8%
12000000 1
 
1.8%
10000000 1
 
1.8%
9500000 1
 
1.8%
5800000 1
 
1.8%
5000000 3
5.4%
4100000 1
 
1.8%
3500000 1
 
1.8%
2400000 2
3.6%
2000000 2
3.6%

정상가격(USD)
Real number (ℝ)

MISSING 

Distinct42
Distinct (%)76.4%
Missing1
Missing (%)1.8%
Infinite0
Infinite (%)0.0%
Mean4332.1344
Minimum30
Maximum100000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:19.355520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30
5-th percentile87.223
Q1336.5
median1000
Q33166.5
95-th percentile12036.3
Maximum100000
Range99970
Interquartile range (IQR)2830

Descriptive statistics

Standard deviation13717.24
Coefficient of variation (CV)3.166393
Kurtosis45.835298
Mean4332.1344
Median Absolute Deviation (MAD)875
Skewness6.54315
Sum238267.39
Variance1.8816267 × 108
MonotonicityNot monotonic
2024-03-18T12:39:19.464309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
1000.0 5
 
8.9%
100.0 4
 
7.1%
444.0 3
 
5.4%
5000.0 2
 
3.6%
340.0 2
 
3.6%
1280.0 2
 
3.6%
10000.0 2
 
3.6%
2000.02 1
 
1.8%
145.0 1
 
1.8%
770.0 1
 
1.8%
Other values (32) 32
57.1%
ValueCountFrequency (%)
30.0 1
 
1.8%
83.0 1
 
1.8%
85.69 1
 
1.8%
87.88 1
 
1.8%
100.0 4
7.1%
125.0 1
 
1.8%
145.0 1
 
1.8%
200.0 1
 
1.8%
220.0 1
 
1.8%
326.0 1
 
1.8%
ValueCountFrequency (%)
100000.0 1
1.8%
20000.0 1
1.8%
12121.0 1
1.8%
12000.0 1
1.8%
10000.0 2
3.6%
9000.0 1
1.8%
8000.0 1
1.8%
5000.0 2
3.6%
4500.0 1
1.8%
4289.0 1
1.8%

할인가격(KRW)
Real number (ℝ)

MISSING 

Distinct36
Distinct (%)85.7%
Missing14
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean2248187.5
Minimum44
Maximum14000000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:19.567238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum44
5-th percentile1000
Q170000
median725000
Q32925000
95-th percentile8760000
Maximum14000000
Range13999956
Interquartile range (IQR)2855000

Descriptive statistics

Standard deviation3352176.8
Coefficient of variation (CV)1.4910575
Kurtosis3.9710222
Mean2248187.5
Median Absolute Deviation (MAD)723750
Skewness2.0413445
Sum94423877
Variance1.123709 × 1013
MonotonicityNot monotonic
2024-03-18T12:39:19.673512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
1200000 2
 
3.6%
400000 2
 
3.6%
1000 2
 
3.6%
2400000 2
 
3.6%
10000 2
 
3.6%
1500000 2
 
3.6%
44 1
 
1.8%
800000 1
 
1.8%
180000 1
 
1.8%
100000 1
 
1.8%
Other values (26) 26
46.4%
(Missing) 14
25.0%
ValueCountFrequency (%)
44 1
1.8%
333 1
1.8%
1000 2
3.6%
1500 1
1.8%
5000 1
1.8%
10000 2
3.6%
40000 1
1.8%
50000 1
1.8%
60000 1
1.8%
100000 1
1.8%
ValueCountFrequency (%)
14000000 1
1.8%
12000000 1
1.8%
8800000 1
1.8%
8000000 1
1.8%
7000000 1
1.8%
5800000 1
1.8%
4500000 1
1.8%
4300000 1
1.8%
4100000 1
1.8%
4000000 1
1.8%

할인가격(USD)
Real number (ℝ)

MISSING 

Distinct39
Distinct (%)90.7%
Missing13
Missing (%)23.2%
Infinite0
Infinite (%)0.0%
Mean2112.5179
Minimum15
Maximum12000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:19.796490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum15
5-th percentile43.946
Q1276.5
median1000
Q32450
95-th percentile9750
Maximum12000
Range11985
Interquartile range (IQR)2173.5

Descriptive statistics

Standard deviation2985.4414
Coefficient of variation (CV)1.4132147
Kurtosis3.3723112
Mean2112.5179
Median Absolute Deviation (MAD)855
Skewness1.9970682
Sum90838.27
Variance8912860.2
MonotonicityNot monotonic
2024-03-18T12:39:19.966678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
1000.0 3
 
5.4%
340.0 2
 
3.6%
10000.0 2
 
3.6%
43.94 1
 
1.8%
15.0 1
 
1.8%
2100.0 1
 
1.8%
100.0 1
 
1.8%
544.0 1
 
1.8%
4050.0 1
 
1.8%
1280.0 1
 
1.8%
Other values (29) 29
51.8%
(Missing) 13
23.2%
ValueCountFrequency (%)
15.0 1
1.8%
34.28 1
1.8%
43.94 1
1.8%
44.0 1
1.8%
50.0 1
1.8%
83.0 1
1.8%
100.0 1
1.8%
125.0 1
1.8%
145.0 1
1.8%
180.0 1
1.8%
ValueCountFrequency (%)
12000.0 1
1.8%
10000.0 2
3.6%
7500.0 1
1.8%
7000.0 1
1.8%
5000.0 1
1.8%
4300.0 1
1.8%
4050.0 1
1.8%
3500.0 1
1.8%
3431.0 1
1.8%
2800.0 1
1.8%

할인비율
Real number (ℝ)

MISSING 

Distinct10
Distinct (%)50.0%
Missing36
Missing (%)64.3%
Infinite0
Infinite (%)0.0%
Mean22.675
Minimum3
Maximum50
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:20.140667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3.95
Q110
median20
Q328.75
95-th percentile50
Maximum50
Range47
Interquartile range (IQR)18.75

Descriptive statistics

Standard deviation16.369319
Coefficient of variation (CV)0.72191043
Kurtosis-0.76792905
Mean22.675
Median Absolute Deviation (MAD)10
Skewness0.79631334
Sum453.5
Variance267.95461
MonotonicityNot monotonic
2024-03-18T12:39:20.246355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
10.0 5
 
8.9%
50.0 4
 
7.1%
20.0 3
 
5.4%
25.0 2
 
3.6%
22.0 1
 
1.8%
3.0 1
 
1.8%
4.0 1
 
1.8%
9.5 1
 
1.8%
40.0 1
 
1.8%
15.0 1
 
1.8%
(Missing) 36
64.3%
ValueCountFrequency (%)
3.0 1
 
1.8%
4.0 1
 
1.8%
9.5 1
 
1.8%
10.0 5
8.9%
15.0 1
 
1.8%
20.0 3
5.4%
22.0 1
 
1.8%
25.0 2
 
3.6%
40.0 1
 
1.8%
50.0 4
7.1%
ValueCountFrequency (%)
50.0 4
7.1%
40.0 1
 
1.8%
25.0 2
 
3.6%
22.0 1
 
1.8%
20.0 3
5.4%
15.0 1
 
1.8%
10.0 5
8.9%
9.5 1
 
1.8%
4.0 1
 
1.8%
3.0 1
 
1.8%

할인비율 공개여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size188.0 B
False
53 
True
 
3
ValueCountFrequency (%)
False 53
94.6%
True 3
 
5.4%
2024-03-18T12:39:20.541374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

첨부파일 고유식별번호(UID)
Real number (ℝ)

MISSING 

Distinct55
Distinct (%)100.0%
Missing1
Missing (%)1.8%
Infinite0
Infinite (%)0.0%
Mean567.90909
Minimum522
Maximum614
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:20.630218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum522
5-th percentile525.4
Q1545
median569
Q3591
95-th percentile610.6
Maximum614
Range92
Interquartile range (IQR)46

Descriptive statistics

Standard deviation27.99555
Coefficient of variation (CV)0.049295831
Kurtosis-1.1673349
Mean567.90909
Median Absolute Deviation (MAD)23
Skewness-0.00059421211
Sum31235
Variance783.75084
MonotonicityStrictly increasing
2024-03-18T12:39:20.737174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
522 1
 
1.8%
523 1
 
1.8%
572 1
 
1.8%
573 1
 
1.8%
575 1
 
1.8%
577 1
 
1.8%
578 1
 
1.8%
580 1
 
1.8%
582 1
 
1.8%
584 1
 
1.8%
Other values (45) 45
80.4%
ValueCountFrequency (%)
522 1
1.8%
523 1
1.8%
524 1
1.8%
526 1
1.8%
527 1
1.8%
529 1
1.8%
531 1
1.8%
532 1
1.8%
533 1
1.8%
535 1
1.8%
ValueCountFrequency (%)
614 1
1.8%
613 1
1.8%
612 1
1.8%
610 1
1.8%
609 1
1.8%
607 1
1.8%
606 1
1.8%
604 1
1.8%
602 1
1.8%
600 1
1.8%

에디터이미지 첨부파일 고유식별번호(UID)
Real number (ℝ)

MISSING 

Distinct38
Distinct (%)100.0%
Missing18
Missing (%)32.1%
Infinite0
Infinite (%)0.0%
Mean568.13158
Minimum525
Maximum611
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:20.843157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum525
5-th percentile529.7
Q1545.75
median566
Q3590.5
95-th percentile605.45
Maximum611
Range86
Interquartile range (IQR)44.75

Descriptive statistics

Standard deviation25.836462
Coefficient of variation (CV)0.045476194
Kurtosis-1.3078548
Mean568.13158
Median Absolute Deviation (MAD)23
Skewness0.0040883945
Sum21589
Variance667.52276
MonotonicityStrictly increasing
2024-03-18T12:39:20.961825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
593 1
 
1.8%
579 1
 
1.8%
581 1
 
1.8%
583 1
 
1.8%
585 1
 
1.8%
587 1
 
1.8%
589 1
 
1.8%
591 1
 
1.8%
595 1
 
1.8%
574 1
 
1.8%
Other values (28) 28
50.0%
(Missing) 18
32.1%
ValueCountFrequency (%)
525 1
1.8%
528 1
1.8%
530 1
1.8%
534 1
1.8%
536 1
1.8%
538 1
1.8%
540 1
1.8%
541 1
1.8%
543 1
1.8%
545 1
1.8%
ValueCountFrequency (%)
611 1
1.8%
608 1
1.8%
605 1
1.8%
603 1
1.8%
601 1
1.8%
599 1
1.8%
597 1
1.8%
595 1
1.8%
593 1
1.8%
591 1
1.8%

조회수
Real number (ℝ)

ZEROS 

Distinct6
Distinct (%)10.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.0535714
Minimum0
Maximum14
Zeros37
Zeros (%)66.1%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:21.068876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0
Q31
95-th percentile4
Maximum14
Range14
Interquartile range (IQR)1

Descriptive statistics

Standard deviation2.2836943
Coefficient of variation (CV)2.1675743
Kurtosis18.532631
Mean1.0535714
Median Absolute Deviation (MAD)0
Skewness3.7787701
Sum59
Variance5.2152597
MonotonicityNot monotonic
2024-03-18T12:39:21.153006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
0 37
66.1%
1 8
 
14.3%
3 5
 
8.9%
4 4
 
7.1%
6 1
 
1.8%
14 1
 
1.8%
ValueCountFrequency (%)
0 37
66.1%
1 8
 
14.3%
3 5
 
8.9%
4 4
 
7.1%
6 1
 
1.8%
14 1
 
1.8%
ValueCountFrequency (%)
14 1
 
1.8%
6 1
 
1.8%
4 4
 
7.1%
3 5
 
8.9%
1 8
 
14.3%
0 37
66.1%

유효여부
Boolean

Distinct2
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size188.0 B
True
29 
False
27 
ValueCountFrequency (%)
True 29
51.8%
False 27
48.2%
2024-03-18T12:39:21.233876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

등록시각
Date

Distinct55
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size580.0 B
Minimum2016-05-03 15:53:00
Maximum2018-08-14 17:40:00
2024-03-18T12:39:21.314013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:39:21.419869image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

등록 사용자종류
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size580.0 B
MEMBER
56 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMEMBER
2nd rowMEMBER
3rd rowMEMBER
4th rowMEMBER
5th rowMEMBER

Common Values

ValueCountFrequency (%)
MEMBER 56
100.0%

Length

2024-03-18T12:39:21.521578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:21.591004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
member 56
100.0%

등록 사용자그룹
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing56
Missing (%)100.0%
Memory size636.0 B

등록 사용자 고유식별번호(UID)
Real number (ℝ)

Distinct21
Distinct (%)37.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1618.125
Minimum1451
Maximum1859
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:21.658686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1451
5-th percentile1451
Q11463
median1614
Q31727
95-th percentile1851
Maximum1859
Range408
Interquartile range (IQR)264

Descriptive statistics

Standard deviation137.45466
Coefficient of variation (CV)0.084946875
Kurtosis-1.1249814
Mean1618.125
Median Absolute Deviation (MAD)123
Skewness0.2451156
Sum90615
Variance18893.784
MonotonicityNot monotonic
2024-03-18T12:39:21.757666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1451 12
21.4%
1628 5
8.9%
1614 5
8.9%
1463 4
 
7.1%
1685 4
 
7.1%
1737 4
 
7.1%
1834 3
 
5.4%
1607 3
 
5.4%
1851 2
 
3.6%
1505 2
 
3.6%
Other values (11) 12
21.4%
ValueCountFrequency (%)
1451 12
21.4%
1463 4
 
7.1%
1487 1
 
1.8%
1505 2
 
3.6%
1515 1
 
1.8%
1607 3
 
5.4%
1612 1
 
1.8%
1614 5
8.9%
1626 1
 
1.8%
1628 5
8.9%
ValueCountFrequency (%)
1859 1
 
1.8%
1855 1
 
1.8%
1851 2
3.6%
1834 3
5.4%
1822 2
3.6%
1737 4
7.1%
1733 1
 
1.8%
1725 1
 
1.8%
1701 1
 
1.8%
1685 4
7.1%

수정시각
Date

Distinct53
Distinct (%)94.6%
Missing0
Missing (%)0.0%
Memory size580.0 B
Minimum2016-08-25 16:14:00
Maximum2019-01-12 00:00:00
2024-03-18T12:39:21.870900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T12:39:21.993347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수정 사용자종류
Categorical

CONSTANT 

Distinct1
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Memory size580.0 B
MEMBER
56 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowMEMBER
2nd rowMEMBER
3rd rowMEMBER
4th rowMEMBER
5th rowMEMBER

Common Values

ValueCountFrequency (%)
MEMBER 56
100.0%

Length

2024-03-18T12:39:22.101970image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T12:39:22.179527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
member 56
100.0%

수정 사용자그룹
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing56
Missing (%)100.0%
Memory size636.0 B

수정 사용자 고유식별번호(UID)
Real number (ℝ)

Distinct21
Distinct (%)37.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1616.9464
Minimum1451
Maximum1859
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size636.0 B
2024-03-18T12:39:22.276073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1451
5-th percentile1451
Q11463
median1614
Q31727
95-th percentile1851
Maximum1859
Range408
Interquartile range (IQR)264

Descriptive statistics

Standard deviation135.32928
Coefficient of variation (CV)0.083694353
Kurtosis-1.0853251
Mean1616.9464
Median Absolute Deviation (MAD)123
Skewness0.23839386
Sum90549
Variance18314.015
MonotonicityNot monotonic
2024-03-18T12:39:22.435854image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
1451 12
21.4%
1614 5
8.9%
1737 5
8.9%
1463 4
 
7.1%
1685 4
 
7.1%
1628 4
 
7.1%
1834 3
 
5.4%
1607 3
 
5.4%
1505 3
 
5.4%
1851 2
 
3.6%
Other values (11) 11
19.6%
ValueCountFrequency (%)
1451 12
21.4%
1463 4
 
7.1%
1505 3
 
5.4%
1515 1
 
1.8%
1607 3
 
5.4%
1612 1
 
1.8%
1614 5
8.9%
1626 1
 
1.8%
1628 4
 
7.1%
1629 1
 
1.8%
ValueCountFrequency (%)
1859 1
 
1.8%
1855 1
 
1.8%
1851 2
 
3.6%
1834 3
5.4%
1822 1
 
1.8%
1737 5
8.9%
1733 1
 
1.8%
1725 1
 
1.8%
1701 1
 
1.8%
1685 4
7.1%

Sample

고유식별번호(UID)병원 식별번호대상업체진료과 공통코드상태게시 시작일자게시 종료일자행사 시작일자행사 종료일자등급정상가격(KRW)정상가격(USD)할인가격(KRW)할인가격(USD)할인비율할인비율 공개여부첨부파일 고유식별번호(UID)에디터이미지 첨부파일 고유식별번호(UID)조회수유효여부등록시각등록 사용자종류등록 사용자그룹등록 사용자 고유식별번호(UID)수정시각수정 사용자종류수정 사용자그룹수정 사용자 고유식별번호(UID)
01251,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,10IS_OPENED20160503<NA>2016050320211231A20000002000.0215000001500.0522.0N522<NA>0N2016-05-03 15:53MEMBER<NA>14512016-11-14 18:51MEMBER<NA>1451
11351,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,17IS_OPENED20160513<NA>2016051320211231A50000005000.043000004300.025.0N523<NA>0N2016-05-13 19:57MEMBER<NA>14512016-11-14 18:49MEMBER<NA>1451
21557,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,20IS_CLOSED20160520<NA>2016052020211231A50000004500.045000004050.010.0Y5245250N2016-05-21 1:03MEMBER<NA>16072016-11-09 14:26MEMBER<NA>1607
31798,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,33IS_OPENED20160831<NA>2016083120211231C220000220.0220000220.0<NA>N526<NA>0Y2016-08-25 16:02MEMBER<NA>18512016-08-25 16:14MEMBER<NA>1851
41892,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,31IS_OPENED20161017<NA>2016101720211231A10000087.885000043.9450.0Y5275280N2016-10-17 14:41MEMBER<NA>18342016-10-17 16:09MEMBER<NA>1834
51992,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,31IS_OPENED20161017<NA>2016101720211231A300030.0150015.020.0N5295300N2016-10-17 17:06MEMBER<NA>18342016-11-14 14:29MEMBER<NA>1834
62051,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,7IS_OPENED20161021<NA>2016102120211231A333333.0333333.03.0N531<NA>0N2016-10-21 12:47MEMBER<NA>14512016-10-21 12:47MEMBER<NA>1451
72151,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,1IS_OPENED20161021<NA>2016102120211231A44444.04444.04.0N532<NA>0N2016-10-21 12:49MEMBER<NA>14512016-10-21 12:49MEMBER<NA>1451
82251,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,1IS_CLOSED20161021<NA>2016102120211231A10000001000.0800000800.025.0N5335340N2016-10-21 13:34MEMBER<NA>14512016-11-15 13:48MEMBER<NA>1451
92358,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,31IS_OPENED20161101<NA>2016110120211231A35000003000.031000002800.09.5N5355360Y2016-11-01 10:33MEMBER<NA>16122016-12-19 11:27MEMBER<NA>1612
고유식별번호(UID)병원 식별번호대상업체진료과 공통코드상태게시 시작일자게시 종료일자행사 시작일자행사 종료일자등급정상가격(KRW)정상가격(USD)할인가격(KRW)할인가격(USD)할인비율할인비율 공개여부첨부파일 고유식별번호(UID)에디터이미지 첨부파일 고유식별번호(UID)조회수유효여부등록시각등록 사용자종류등록 사용자그룹등록 사용자 고유식별번호(UID)수정시각수정 사용자종류수정 사용자그룹수정 사용자 고유식별번호(UID)
466090,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,32IS_OPENED20161227<NA>2016122720211231B10000083.010000083.0<NA>N6006016Y2016-12-27 11:04MEMBER<NA>17372017-01-06 15:40MEMBER<NA>1737
476188,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,17IS_OPENED20161227<NA>2016122720211231A24000001990.024000001990.0<NA>N60260314Y2016-12-27 12:00MEMBER<NA>17012016-12-28 16:45MEMBER<NA>1701
486788,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,17IS_OPENED20170118<NA>2017011820211231A20000001713.8<NA><NA><NA>N6046050N2017-01-18 14:27MEMBER<NA>17252017-01-18 14:27MEMBER<NA>1725
496859,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,10IS_OPENED20170125<NA>2017012520211231A10000326.0<NA><NA><NA>N606<NA>0N2017-01-25 15:49MEMBER<NA>16142017-01-25 15:49MEMBER<NA>1614
506952,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,8IS_CLOSED20170414<NA>2017041420211231A333443333.0<NA><NA><NA>N6076080N2017-04-14 9:18MEMBER<NA>14632017-04-18 7:36MEMBER<NA>1463
517052,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,2IS_CLOSED20170522<NA>2017052220211231A1233441111.0<NA><NA><NA>N609<NA>0N2017-05-22 0:19MEMBER<NA>14632017-05-22 0:19MEMBER<NA>1463
527152,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,1IS_OPENED20170823<NA>2017082320211231A100000100000.01000010000.010.0N6106110N2017-08-23 17:23MEMBER<NA>14632017-08-23 17:24MEMBER<NA>1463
537255,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,15IS_OPENED20170929<NA>2017092920211231A200000200.0180000180.010.0N612<NA>0N2017-09-29 14:34MEMBER<NA>15052017-09-29 14:34MEMBER<NA>1505
547355,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,33IS_OPENED20180109<NA>2018010920211231A350000350.0<NA><NA><NA>N613<NA>0N2018-01-09 8:45MEMBER<NA>15052018-01-09 8:45MEMBER<NA>1505
557552,TYPE__MTIS,TYPE__CITY_HALL,TYPE__HOSPITAL,TYPE__AGENCY,TYPE__HEALTH_CENTER,TYPE__PR_OFFICE,1IS_OPENED20180814<NA>2018081420211231A1000010000.010001000.010.0N614<NA>0N2018-08-14 17:40MEMBER<NA>14632018-08-14 17:40MEMBER<NA>1463