Overview

Dataset statistics

Number of variables6
Number of observations100
Missing cells5
Missing cells (%)0.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.8 KiB
Average record size in memory49.3 B

Variable types

DateTime3
Text1
Categorical2

Alerts

ingate is highly overall correlated with outgateHigh correlation
outgate is highly overall correlated with ingateHigh correlation
outdate has 5 (5.0%) missing valuesMissing
encacplate has unique valuesUnique

Reproduction

Analysis started2023-12-10 10:17:14.964189
Analysis finished2023-12-10 10:17:15.736350
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

transdate
Date

Distinct4
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2021-11-02 00:00:00
Maximum2021-11-11 00:00:00
2023-12-10T19:17:15.787418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:17:15.897929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

encacplate
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T19:17:16.148770image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length40
Median length40
Mean length40
Min length40

Characters and Unicode

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

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row012EF8EB9D6652B20E3AD4A4E96CCB10FFE2AF68
2nd row22B5EEA9F3DBBF1C313594591CE737084EBD3505
3rd rowF3A08DE79CA785A5E25BF95E73A04E2BF2D4B05D
4th rowF7FE03B87F8FF248A144EABF11AAC81F089DBC1F
5th row6950AF523E23E6011E41A93ECDBDE5711ED95595
ValueCountFrequency (%)
012ef8eb9d6652b20e3ad4a4e96ccb10ffe2af68 1
 
1.0%
db724a013ebc364aa2dab6ec5260940790f3e502 1
 
1.0%
87103556038e17e84629330c830454c0bdf547bf 1
 
1.0%
c86a1ae77fd219ba80fc6e04210cba91994c22d0 1
 
1.0%
9d18cfc5e09a49d15d2d9dbbd0a8b2504d209439 1
 
1.0%
8bab41ed958bd4c633a24662ed145c7b6eee965b 1
 
1.0%
06a5b8c74334d762adc10066be029ebc03ea2616 1
 
1.0%
6ad6aebb7930930263bd0b1557c601e5b324e5de 1
 
1.0%
116c131ed9932368f7e3c4b9dbcf81272f2c5760 1
 
1.0%
863a356cd78dfcacf9338d116b94e971fb4c427e 1
 
1.0%
Other values (90) 90
90.0%
2023-12-10T19:17:16.548676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
C 269
 
6.7%
B 266
 
6.7%
D 262
 
6.6%
3 261
 
6.5%
4 261
 
6.5%
2 257
 
6.4%
6 254
 
6.3%
8 248
 
6.2%
5 248
 
6.2%
0 246
 
6.2%
Other values (6) 1428
35.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 2490
62.3%
Uppercase Letter 1510
37.8%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
3 261
10.5%
4 261
10.5%
2 257
10.3%
6 254
10.2%
8 248
10.0%
5 248
10.0%
0 246
9.9%
9 246
9.9%
1 243
9.8%
7 226
9.1%
Uppercase Letter
ValueCountFrequency (%)
C 269
17.8%
B 266
17.6%
D 262
17.4%
E 244
16.2%
F 237
15.7%
A 232
15.4%

Most occurring scripts

ValueCountFrequency (%)
Common 2490
62.3%
Latin 1510
37.8%

Most frequent character per script

Common
ValueCountFrequency (%)
3 261
10.5%
4 261
10.5%
2 257
10.3%
6 254
10.2%
8 248
10.0%
5 248
10.0%
0 246
9.9%
9 246
9.9%
1 243
9.8%
7 226
9.1%
Latin
ValueCountFrequency (%)
C 269
17.8%
B 266
17.6%
D 262
17.4%
E 244
16.2%
F 237
15.7%
A 232
15.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
C 269
 
6.7%
B 266
 
6.7%
D 262
 
6.6%
3 261
 
6.5%
4 261
 
6.5%
2 257
 
6.4%
6 254
 
6.3%
8 248
 
6.2%
5 248
 
6.2%
0 246
 
6.2%
Other values (6) 1428
35.7%

indate
Date

Distinct91
Distinct (%)91.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2021-11-02 06:44:00
Maximum2021-11-11 21:42:00
2023-12-10T19:17:16.773348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:17:16.917696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

ingate
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
북2
38 
동2
27 
남2
20 
남4
10 
남3
5 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북2
2nd row남4
3rd row동2
4th row북2
5th row남2

Common Values

ValueCountFrequency (%)
북2 38
38.0%
동2 27
27.0%
남2 20
20.0%
남4 10
 
10.0%
남3 5
 
5.0%

Length

2023-12-10T19:17:17.051449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:17:17.157590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북2 38
38.0%
동2 27
27.0%
남2 20
20.0%
남4 10
 
10.0%
남3 5
 
5.0%

outdate
Date

MISSING 

Distinct90
Distinct (%)94.7%
Missing5
Missing (%)5.0%
Memory size932.0 B
Minimum2021-11-02 07:30:00
Maximum2021-11-11 22:03:00
2023-12-10T19:17:17.328961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:17:17.519275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

outgate
Categorical

HIGH CORRELATION 

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
동2
34 
북2
31 
남2
16 
남4
10 
<NA>
5 

Length

Max length4
Median length2
Mean length2.1
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북2
2nd row남4
3rd row북2
4th row북2
5th row북2

Common Values

ValueCountFrequency (%)
동2 34
34.0%
북2 31
31.0%
남2 16
16.0%
남4 10
 
10.0%
<NA> 5
 
5.0%
남3 4
 
4.0%

Length

2023-12-10T19:17:17.727638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:17:17.884074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동2 34
34.0%
북2 31
31.0%
남2 16
16.0%
남4 10
 
10.0%
na 5
 
5.0%
남3 4
 
4.0%

Correlations

2023-12-10T19:17:17.978424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
transdateencacplateindateingateoutdateoutgate
transdate1.0001.0001.0000.2641.0000.042
encacplate1.0001.0001.0001.0001.0001.000
indate1.0001.0001.0000.8520.9820.774
ingate0.2641.0000.8521.0000.7720.956
outdate1.0001.0000.9820.7721.0000.744
outgate0.0421.0000.7740.9560.7441.000
2023-12-10T19:17:18.109017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ingateoutgate
ingate1.0000.702
outgate0.7021.000
2023-12-10T19:17:18.210763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ingateoutgate
ingate1.0000.702
outgate0.7021.000

Missing values

2023-12-10T19:17:15.589011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:17:15.697924image/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

transdateencacplateindateingateoutdateoutgate
02021-11-02012EF8EB9D6652B20E3AD4A4E96CCB10FFE2AF682021-11-02 08:48:00북22021-11-02 17:45:00북2
12021-11-1122B5EEA9F3DBBF1C313594591CE737084EBD35052021-11-11 10:43:00남42021-11-11 11:09:00남4
22021-11-02F3A08DE79CA785A5E25BF95E73A04E2BF2D4B05D2021-11-02 15:51:00동22021-11-02 16:28:00북2
32021-11-02F7FE03B87F8FF248A144EABF11AAC81F089DBC1F2021-11-02 08:24:00북22021-11-02 08:26:00북2
42021-11-026950AF523E23E6011E41A93ECDBDE5711ED955952021-11-02 09:41:00남22021-11-02 17:10:00북2
52021-11-0221B3919669621F45AD455431C194512B380FF1812021-11-02 14:09:00남22021-11-02 14:15:00동2
62021-11-0281A208423661268E3223E31AAB965C6AE5A5117F2021-11-02 14:13:00동22021-11-02 16:15:00동2
72021-11-10ADFFB9C6F853F1B484A456B1984EF8834B2C58AC2021-11-10 21:52:00남3<NA><NA>
82021-11-02A10EA4F60BE86DCC12D1665959FBCFD068C505FC2021-11-02 20:09:00북22021-11-02 20:15:00남2
92021-11-021869E32E9FFD3270709EBB967DB3CC5E7BDA42DF2021-11-02 08:43:00동22021-11-02 19:20:00동2
transdateencacplateindateingateoutdateoutgate
902021-11-02E52D328C4CEECB2A3AEBD4EB67CD29B530E327F42021-11-02 09:58:00북22021-11-02 10:01:00남2
912021-11-020DD55139F86146FAAFB2D2896D73F3D9C4741FBC2021-11-02 07:27:00북22021-11-02 07:30:00남2
922021-11-03E1C8EBDBA690E27EFAFDFDB3F0EC63FD9149D8F12021-11-03 06:06:00북2<NA><NA>
932021-11-02B86EF754A9A46BED3B5C06CCF735A3EA151655322021-11-02 14:43:00남42021-11-02 17:11:00남4
942021-11-02A422BBA442E38FBEBEF1D3ABCE015CC88ABDF1502021-11-02 13:43:00북22021-11-02 15:43:00북2
952021-11-020D7F3EA29D52FC53BBD99353CAF2B708664621612021-11-02 08:43:00동2<NA><NA>
962021-11-021402BA48ABF3AF7EF59643D5A23D46B954A3454A2021-11-02 08:49:00남22021-11-02 18:11:00동2
972021-11-02557943C5DF7F7F618DFB1DA88680799CC3FA94692021-11-02 10:15:00동22021-11-02 12:00:00동2
982021-11-020B5BBAD98C94F88586F862009057BBD66D23D4D42021-11-02 07:42:00동22021-11-02 09:14:00동2
992021-11-0236583264A3DC8599500C1B27E7A0CAE782E83DCE2021-11-02 07:41:00동22021-11-02 18:35:00북2