Overview

Dataset statistics

Number of variables6
Number of observations605
Missing cells1209
Missing cells (%)33.3%
Duplicate rows117
Duplicate rows (%)19.3%
Total size in memory29.1 KiB
Average record size in memory49.2 B

Variable types

Text1
DateTime1
Categorical2
Boolean1
Unsupported1

Dataset

Description생산농가 패널의 경영규모, 재배기술, 투입, 산출, 비용 등 경영실태 조사분석관련 내부 관리시스템으로 사용자ID, 등록일시, 로그인/로그아웃, 성공여부, IP, 비고 등을 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/15050260/fileData.do

Alerts

사용자ID has constant value ""Constant
Dataset has 117 (19.3%) duplicate rowsDuplicates
로그인/로그아웃 is highly overall correlated with 비고High correlation
성공여부 is highly overall correlated with 비고High correlation
비고 is highly overall correlated with 로그인/로그아웃 and 1 other fieldsHigh correlation
사용자ID has 604 (99.8%) missing valuesMissing
IP has 605 (100.0%) missing valuesMissing
IP is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 07:44:45.318961
Analysis finished2023-12-12 07:44:46.143905
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

사용자ID
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing604
Missing (%)99.8%
Memory size4.9 KiB
2023-12-12T16:44:46.209682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st rowngiyoung
ValueCountFrequency (%)
ngiyoung 1
100.0%
2023-12-12T16:44:46.509976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
n 2
25.0%
g 2
25.0%
i 1
12.5%
y 1
12.5%
o 1
12.5%
u 1
12.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 8
100.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
n 2
25.0%
g 2
25.0%
i 1
12.5%
y 1
12.5%
o 1
12.5%
u 1
12.5%

Most occurring scripts

ValueCountFrequency (%)
Latin 8
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
n 2
25.0%
g 2
25.0%
i 1
12.5%
y 1
12.5%
o 1
12.5%
u 1
12.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 8
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
n 2
25.0%
g 2
25.0%
i 1
12.5%
y 1
12.5%
o 1
12.5%
u 1
12.5%

등록일시
Date

Distinct332
Distinct (%)54.9%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
Minimum2017-01-11 12:20:00
Maximum2019-08-06 12:18:00
2023-12-12T16:44:46.673357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:44:46.844631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

로그인/로그아웃
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
I
524 
O
81 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 524
86.6%
O 81
 
13.4%

Length

2023-12-12T16:44:47.029797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:44:47.167909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 524
86.6%
o 81
 
13.4%

성공여부
Boolean

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size737.0 B
False
319 
True
286 
ValueCountFrequency (%)
False 319
52.7%
True 286
47.3%
2023-12-12T16:44:47.284221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

IP
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing605
Missing (%)100.0%
Memory size5.4 KiB

비고
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size4.9 KiB
org.springframework.security.authentication.BadCredentialsException: Bad credentials
319 
<NA>
286 

Length

Max length84
Median length84
Mean length46.181818
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st roworg.springframework.security.authentication.BadCredentialsException: Bad credentials
2nd roworg.springframework.security.authentication.BadCredentialsException: Bad credentials
3rd row<NA>
4th row<NA>
5th roworg.springframework.security.authentication.BadCredentialsException: Bad credentials

Common Values

ValueCountFrequency (%)
org.springframework.security.authentication.BadCredentialsException: Bad credentials 319
52.7%
<NA> 286
47.3%

Length

2023-12-12T16:44:47.436499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:44:47.558323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
org.springframework.security.authentication.badcredentialsexception 319
25.7%
bad 319
25.7%
credentials 319
25.7%
na 286
23.0%

Correlations

2023-12-12T16:44:47.643992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃성공여부
로그인/로그아웃1.0000.599
성공여부0.5991.000
2023-12-12T16:44:47.754834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃성공여부비고
로그인/로그아웃1.0000.4091.000
성공여부0.4091.0001.000
비고1.0001.0001.000
2023-12-12T16:44:47.862442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃성공여부비고
로그인/로그아웃1.0000.4091.000
성공여부0.4091.0001.000
비고1.0001.0001.000

Missing values

2023-12-12T16:44:45.916562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:44:46.082249image/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

사용자ID등록일시로그인/로그아웃성공여부IP비고
0ngiyoung2019-03-24 11:22IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
1<NA>2019-03-24 11:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
2<NA>2019-03-29 08:55IY<NA><NA>
3<NA>2019-04-04 14:42IY<NA><NA>
4<NA>2019-04-05 09:36IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
5<NA>2019-04-05 09:36IY<NA><NA>
6<NA>2019-04-05 09:37OY<NA><NA>
7<NA>2019-04-05 09:41IY<NA><NA>
8<NA>2019-04-21 15:40IY<NA><NA>
9<NA>2019-05-08 22:06IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
사용자ID등록일시로그인/로그아웃성공여부IP비고
595<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
596<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
597<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
598<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
599<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
600<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
601<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
602<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
603<NA>2017-08-03 09:23IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials
604<NA>2017-08-03 13:02IN<NA>org.springframework.security.authentication.BadCredentialsException: Bad credentials

Duplicate rows

Most frequently occurring

사용자ID등록일시로그인/로그아웃성공여부비고# duplicates
37<NA>2017-08-03 09:23INorg.springframework.security.authentication.BadCredentialsException: Bad credentials9
67<NA>2018-03-21 09:42INorg.springframework.security.authentication.BadCredentialsException: Bad credentials9
85<NA>2018-07-23 16:50INorg.springframework.security.authentication.BadCredentialsException: Bad credentials7
54<NA>2018-03-21 09:15INorg.springframework.security.authentication.BadCredentialsException: Bad credentials6
62<NA>2018-03-21 09:30INorg.springframework.security.authentication.BadCredentialsException: Bad credentials6
8<NA>2017-01-13 17:08IY<NA>5
9<NA>2017-01-13 17:08OY<NA>5
58<NA>2018-03-21 09:22INorg.springframework.security.authentication.BadCredentialsException: Bad credentials5
94<NA>2018-10-31 18:28INorg.springframework.security.authentication.BadCredentialsException: Bad credentials5
104<NA>2019-03-24 11:21INorg.springframework.security.authentication.BadCredentialsException: Bad credentials5