Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows254
Duplicate rows (%)2.5%
Total size in memory390.6 KiB
Average record size in memory40.0 B

Variable types

DateTime1
Categorical2
Boolean1

Dataset

Description충청북도 농업기술원 농가경영기록장(농가의 소득을 증진시킬 수 있는 회원전용 농가경영 관리 프로그램)의 수입지출관련 이용자 접속기록, 거래, 거래처 등의 관리시스템으로 등록일시, 로그인/로그아웃, 성공여부, 비고 등을 제공합니다.
Author충청북도
URLhttps://www.data.go.kr/data/15050323/fileData.do

Alerts

Dataset has 254 (2.5%) duplicate rowsDuplicates
로그인/로그아웃 is highly overall correlated with 비고High correlation
비고 is highly overall correlated with 로그인/로그아웃 and 1 other fieldsHigh correlation
성공여부 is highly overall correlated with 비고High correlation
성공여부 is highly imbalanced (79.9%)Imbalance
비고 is highly imbalanced (87.1%)Imbalance

Reproduction

Analysis started2023-12-12 13:30:52.005144
Analysis finished2023-12-12 13:30:52.821762
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

등록일시
Date

Distinct5657
Distinct (%)56.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-03-09 04:11:00
Maximum2017-08-21 23:26:00
2023-12-12T22:30:52.923401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T22:30:53.083143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

로그인/로그아웃
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
I
5801 
D
4143 
O
 
56

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
I 5801
58.0%
D 4143
41.4%
O 56
 
0.6%

Length

2023-12-12T22:30:53.243072image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:30:53.375405image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
i 5801
58.0%
d 4143
41.4%
o 56
 
0.6%

성공여부
Boolean

HIGH CORRELATION  IMBALANCE 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size87.9 KiB
True
9687 
False
 
313
ValueCountFrequency (%)
True 9687
96.9%
False 313
 
3.1%
2023-12-12T22:30:53.476382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

비고
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
9687 
org.springframework.security.authentication.BadCredentialsException: Bad credentials
 
309
Not approved
 
4

Length

Max length84
Median length4
Mean length6.4752
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 9687
96.9%
org.springframework.security.authentication.BadCredentialsException: Bad credentials 309
 
3.1%
Not approved 4
 
< 0.1%

Length

2023-12-12T22:30:53.626410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T22:30:53.765907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 9687
91.2%
org.springframework.security.authentication.badcredentialsexception 309
 
2.9%
bad 309
 
2.9%
credentials 309
 
2.9%
not 4
 
< 0.1%
approved 4
 
< 0.1%

Correlations

2023-12-12T22:30:53.850074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃성공여부비고
로그인/로그아웃1.0000.092NaN
성공여부0.0921.000NaN
비고NaNNaN1.000
2023-12-12T22:30:53.961518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃비고성공여부
로그인/로그아웃1.0001.0000.152
비고1.0001.0001.000
성공여부0.1521.0001.000
2023-12-12T22:30:54.094135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
로그인/로그아웃성공여부비고
로그인/로그아웃1.0000.1521.000
성공여부0.1521.0001.000
비고1.0001.0001.000

Missing values

2023-12-12T22:30:52.644881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T22:30:52.762964image/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

등록일시로그인/로그아웃성공여부비고
911852017-07-28 14:48IY<NA>
922522017-08-19 18:19IY<NA>
750702017-06-22 10:52DY<NA>
912542017-07-28 17:40IY<NA>
740742017-06-22 10:52DY<NA>
408812017-05-04 23:53IY<NA>
863952017-07-05 21:26IY<NA>
32912017-03-10 12:16DY<NA>
359692017-04-17 11:51IY<NA>
451892017-05-07 11:28IY<NA>
등록일시로그인/로그아웃성공여부비고
117732017-03-24 14:48INorg.springframework.security.authentication.BadCredentialsException: Bad credentials
219262017-03-31 09:48IY<NA>
411682017-04-22 21:15IY<NA>
14012017-03-10 12:15DY<NA>
128722017-03-23 10:32DY<NA>
227682017-03-31 18:00DY<NA>
920832017-08-18 15:36IY<NA>
558252017-05-15 09:36IY<NA>
718482017-06-16 22:41IY<NA>
923622017-08-21 07:29IY<NA>

Duplicate rows

Most frequently occurring

등록일시로그인/로그아웃성공여부비고# duplicates
2132017-06-22 10:52DY<NA>849
1432017-05-10 17:53DY<NA>740
482017-03-23 10:32DY<NA>340
1232017-04-17 14:53DY<NA>286
992017-04-10 17:15DY<NA>226
882017-04-05 10:22DY<NA>193
762017-03-31 18:00DY<NA>169
1702017-05-23 14:28DY<NA>152
1802017-05-26 11:09DY<NA>138
282017-03-13 01:59DY<NA>117