Overview

Dataset statistics

Number of variables6
Number of observations30
Missing cells60
Missing cells (%)33.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory55.4 B

Variable types

Numeric1
Unsupported2
DateTime1
Categorical2

Dataset

Description샘플 데이터
Author경기도일자리재단
URLhttps://www.bigdata-region.kr/#/dataset/bbc50331-bea0-4977-8033-e2be4cf5099b

Alerts

상담코칭정보번호 is highly overall correlated with 수정일시 and 1 other fieldsHigh correlation
수정일시 is highly overall correlated with 상담코칭정보번호High correlation
데이터기준일자 is highly overall correlated with 상담코칭정보번호High correlation
상담코칭제목 has 30 (100.0%) missing valuesMissing
상담코칭내용 has 30 (100.0%) missing valuesMissing
상담코칭정보번호 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

Reproduction

Analysis started2023-12-10 14:13:14.705144
Analysis finished2023-12-10 14:13:15.292344
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상담코칭정보번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49063.467
Minimum49008
Maximum49120
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:13:15.396804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum49008
5-th percentile49011.25
Q149022.25
median49062.5
Q349097.75
95-th percentile49118.55
Maximum49120
Range112
Interquartile range (IQR)75.5

Descriptive statistics

Standard deviation38.196166
Coefficient of variation (CV)0.00077850525
Kurtosis-1.3615396
Mean49063.467
Median Absolute Deviation (MAD)40
Skewness0.041106403
Sum1471904
Variance1458.9471
MonotonicityStrictly increasing
2023-12-10T23:13:15.620656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
49008 1
 
3.3%
49069 1
 
3.3%
49120 1
 
3.3%
49119 1
 
3.3%
49118 1
 
3.3%
49115 1
 
3.3%
49114 1
 
3.3%
49108 1
 
3.3%
49107 1
 
3.3%
49099 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
49008 1
3.3%
49009 1
3.3%
49014 1
3.3%
49016 1
3.3%
49017 1
3.3%
49020 1
3.3%
49021 1
3.3%
49022 1
3.3%
49023 1
3.3%
49041 1
3.3%
ValueCountFrequency (%)
49120 1
3.3%
49119 1
3.3%
49118 1
3.3%
49115 1
3.3%
49114 1
3.3%
49108 1
3.3%
49107 1
3.3%
49099 1
3.3%
49094 1
3.3%
49082 1
3.3%

상담코칭제목
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

상담코칭내용
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing30
Missing (%)100.0%
Memory size402.0 B

등록일시
Date

Distinct29
Distinct (%)96.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2015-01-29 06:53:00
Maximum2015-02-02 11:17:00
2023-12-10T23:13:15.829953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:13:16.019523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)

수정일시
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)46.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2015-02-10 08:12
4 
2015-02-10 08:11
3 
2015-02-10 08:08
3 
2015-02-10 08:14
3 
2015-02-10 08:16
3 
Other values (9)
14 

Length

Max length16
Median length16
Mean length16
Min length16

Unique

Unique4 ?
Unique (%)13.3%

Sample

1st row2015-02-10 08:04
2nd row2015-02-10 08:04
3rd row2015-02-10 08:10
4th row2015-02-10 08:05
5th row2015-02-10 08:11

Common Values

ValueCountFrequency (%)
2015-02-10 08:12 4
13.3%
2015-02-10 08:11 3
10.0%
2015-02-10 08:08 3
10.0%
2015-02-10 08:14 3
10.0%
2015-02-10 08:16 3
10.0%
2015-02-10 08:04 2
6.7%
2015-02-10 08:10 2
6.7%
2015-02-10 08:05 2
6.7%
2015-02-10 08:13 2
6.7%
2015-02-10 08:17 2
6.7%
Other values (4) 4
13.3%

Length

2023-12-10T23:13:16.233520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2015-02-10 30
50.0%
08:12 4
 
6.7%
08:11 3
 
5.0%
08:08 3
 
5.0%
08:14 3
 
5.0%
08:16 3
 
5.0%
08:04 2
 
3.3%
08:10 2
 
3.3%
08:05 2
 
3.3%
08:13 2
 
3.3%
Other values (5) 6
 
10.0%

데이터기준일자
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2015-02-02
11 
2015-01-29
9 
2015-01-30
8 
2015-01-31
 
1
2015-02-01
 
1

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique2 ?
Unique (%)6.7%

Sample

1st row2015-01-29
2nd row2015-01-29
3rd row2015-01-29
4th row2015-01-29
5th row2015-01-29

Common Values

ValueCountFrequency (%)
2015-02-02 11
36.7%
2015-01-29 9
30.0%
2015-01-30 8
26.7%
2015-01-31 1
 
3.3%
2015-02-01 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:13:16.633975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2015-02-02 11
36.7%
2015-01-29 9
30.0%
2015-01-30 8
26.7%
2015-01-31 1
 
3.3%
2015-02-01 1
 
3.3%

Interactions

2023-12-10T23:13:14.896382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:13:16.799530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상담코칭정보번호등록일시수정일시데이터기준일자
상담코칭정보번호1.0001.0000.8500.951
등록일시1.0001.0001.0001.000
수정일시0.8501.0001.0000.823
데이터기준일자0.9511.0000.8231.000
2023-12-10T23:13:16.959932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터기준일자수정일시
데이터기준일자1.0000.478
수정일시0.4781.000
2023-12-10T23:13:17.103865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상담코칭정보번호수정일시데이터기준일자
상담코칭정보번호1.0000.5150.624
수정일시0.5151.0000.478
데이터기준일자0.6240.4781.000

Missing values

2023-12-10T23:13:15.071881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:13:15.230275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

상담코칭정보번호상담코칭제목상담코칭내용등록일시수정일시데이터기준일자
049008<NA><NA>2015-01-29 06:532015-02-10 08:042015-01-29
149009<NA><NA>2015-01-29 06:532015-02-10 08:042015-01-29
249014<NA><NA>2015-01-29 07:542015-02-10 08:102015-01-29
349016<NA><NA>2015-01-29 07:572015-02-10 08:052015-01-29
449017<NA><NA>2015-01-29 08:002015-02-10 08:112015-01-29
549020<NA><NA>2015-01-29 09:152015-02-10 08:052015-01-29
649021<NA><NA>2015-01-29 11:452015-02-10 08:122015-01-29
749022<NA><NA>2015-01-29 11:472015-02-10 08:062015-01-29
849023<NA><NA>2015-01-29 11:532015-02-10 08:122015-01-29
949041<NA><NA>2015-01-30 02:562015-02-10 08:132015-01-30
상담코칭정보번호상담코칭제목상담코칭내용등록일시수정일시데이터기준일자
2049082<NA><NA>2015-02-02 00:502015-02-10 08:132015-02-02
2149094<NA><NA>2015-02-02 03:102015-02-10 08:192015-02-02
2249099<NA><NA>2015-02-02 03:422015-02-10 08:142015-02-02
2349107<NA><NA>2015-02-02 05:452015-02-10 08:142015-02-02
2449108<NA><NA>2015-02-02 06:502015-02-10 08:142015-02-02
2549114<NA><NA>2015-02-02 07:442015-02-10 08:152015-02-02
2649115<NA><NA>2015-02-02 07:422015-02-10 08:162015-02-02
2749118<NA><NA>2015-02-02 08:212015-02-10 08:162015-02-02
2849119<NA><NA>2015-02-02 09:052015-02-10 08:162015-02-02
2949120<NA><NA>2015-02-02 11:172015-02-10 08:172015-02-02