Overview
Brought to you by YData
Dataset statistics
Number of variables | 52 |
---|---|
Number of observations | 1000098 |
Missing cells | 5067648 |
Missing cells (%) | 9.7% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 390.1 MiB |
Average record size in memory | 409.0 B |
Variable types
Numeric | 14 |
---|---|
Categorical | 27 |
Boolean | 7 |
Text | 1 |
DateTime | 1 |
Unsupported | 2 |
Language has constant value "English" | Constant |
Country has constant value "South Africa" | Constant |
ItemType has constant value "Mobility - Motor" | Constant |
CrossBorder has constant value "False" | Constant |
StatutoryClass has constant value "Commercial" | Constant |
StatutoryRiskType has constant value "IFRS Constant" | Constant |
AccountType is highly overall correlated with Converted and 2 other fields | High correlation |
Bank is highly overall correlated with Converted and 2 other fields | High correlation |
CalculatedPremiumPerTerm is highly overall correlated with Converted and 5 other fields | High correlation |
Converted is highly overall correlated with AccountType and 6 other fields | High correlation |
CoverCategory is highly overall correlated with CoverGroup and 6 other fields | High correlation |
CoverGroup is highly overall correlated with CoverCategory and 5 other fields | High correlation |
CoverType is highly overall correlated with CoverCategory and 6 other fields | High correlation |
CustomValueEstimate is highly overall correlated with Converted and 3 other fields | High correlation |
Cylinders is highly overall correlated with make | High correlation |
ExcessSelected is highly overall correlated with CoverCategory and 1 other fields | High correlation |
MainCrestaZone is highly overall correlated with PostalCode and 2 other fields | High correlation |
NumberOfDoors is highly overall correlated with bodytype and 1 other fields | High correlation |
PolicyID is highly overall correlated with UnderwrittenCoverID | High correlation |
PostalCode is highly overall correlated with MainCrestaZone and 2 other fields | High correlation |
Product is highly overall correlated with CoverCategory and 5 other fields | High correlation |
Province is highly overall correlated with MainCrestaZone and 2 other fields | High correlation |
Rebuilt is highly overall correlated with AccountType and 6 other fields | High correlation |
RegistrationYear is highly overall correlated with CustomValueEstimate | High correlation |
Section is highly overall correlated with CoverCategory and 4 other fields | High correlation |
SubCrestaZone is highly overall correlated with MainCrestaZone and 2 other fields | High correlation |
SumInsured is highly overall correlated with CoverCategory and 2 other fields | High correlation |
TermFrequency is highly overall correlated with CoverCategory and 4 other fields | High correlation |
TotalPremium is highly overall correlated with Converted and 5 other fields | High correlation |
UnderwrittenCoverID is highly overall correlated with PolicyID | High correlation |
VehicleType is highly overall correlated with CalculatedPremiumPerTerm and 4 other fields | High correlation |
WrittenOff is highly overall correlated with AccountType and 6 other fields | High correlation |
bodytype is highly overall correlated with CalculatedPremiumPerTerm and 5 other fields | High correlation |
cubiccapacity is highly overall correlated with kilowatts and 2 other fields | High correlation |
kilowatts is highly overall correlated with cubiccapacity and 2 other fields | High correlation |
make is highly overall correlated with CalculatedPremiumPerTerm and 8 other fields | High correlation |
mmcode is highly overall correlated with VehicleType and 3 other fields | High correlation |
IsVATRegistered is highly imbalanced (95.4%) | Imbalance |
Citizenship is highly imbalanced (75.3%) | Imbalance |
LegalType is highly imbalanced (82.2%) | Imbalance |
Title is highly imbalanced (81.2%) | Imbalance |
MaritalStatus is highly imbalanced (96.5%) | Imbalance |
Gender is highly imbalanced (80.1%) | Imbalance |
VehicleType is highly imbalanced (82.3%) | Imbalance |
make is highly imbalanced (74.5%) | Imbalance |
bodytype is highly imbalanced (73.6%) | Imbalance |
AlarmImmobiliser is highly imbalanced (99.7%) | Imbalance |
NewVehicle is highly imbalanced (98.0%) | Imbalance |
WrittenOff is highly imbalanced (99.9%) | Imbalance |
Rebuilt is highly imbalanced (99.9%) | Imbalance |
Converted is highly imbalanced (99.7%) | Imbalance |
TermFrequency is highly imbalanced (99.3%) | Imbalance |
ExcessSelected is highly imbalanced (69.6%) | Imbalance |
CoverGroup is highly imbalanced (72.6%) | Imbalance |
Section is highly imbalanced (67.3%) | Imbalance |
Product is highly imbalanced (77.4%) | Imbalance |
Bank has 145961 (14.6%) missing values | Missing |
AccountType has 40232 (4.0%) missing values | Missing |
CustomValueEstimate has 779642 (78.0%) missing values | Missing |
NewVehicle has 153295 (15.3%) missing values | Missing |
WrittenOff has 641901 (64.2%) missing values | Missing |
Rebuilt has 641901 (64.2%) missing values | Missing |
Converted has 641901 (64.2%) missing values | Missing |
CrossBorder has 999400 (99.9%) missing values | Missing |
NumberOfVehiclesInFleet has 1000098 (100.0%) missing values | Missing |
CustomValueEstimate is highly skewed (γ1 = 40.87051775) | Skewed |
CalculatedPremiumPerTerm is highly skewed (γ1 = 122.9745813) | Skewed |
TotalPremium is highly skewed (γ1 = 138.5964576) | Skewed |
TotalClaims is highly skewed (γ1 = 69.93311843) | Skewed |
CapitalOutstanding is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
NumberOfVehiclesInFleet is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
TotalPremium has 381634 (38.2%) zeros | Zeros |
TotalClaims has 997305 (99.7%) zeros | Zeros |
Reproduction
Analysis started | 2025-06-17 15:27:51.033481 |
---|---|
Analysis finished | 2025-06-17 15:30:53.917357 |
Duration | 3 minutes and 2.88 seconds |
Software version | ydata-profiling vv4.16.1 |
Download configuration | config.json |
Variables
UnderwrittenCoverID
Real number (ℝ)
High correlation 
Distinct | 116532 |
---|---|
Distinct (%) | 11.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 104817.55 |
Minimum | 1 |
---|---|
Maximum | 301175 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 15033 |
Q1 | 55143 |
median | 94083 |
Q3 | 139190 |
95-th percentile | 238232 |
Maximum | 301175 |
Range | 301174 |
Interquartile range (IQR) | 84047 |
Descriptive statistics
Standard deviation | 63293.708 |
---|---|
Coefficient of variation (CV) | 0.6038465 |
Kurtosis | 0.028836845 |
Mean | 104817.55 |
Median Absolute Deviation (MAD) | 41307 |
Skewness | 0.61170958 |
Sum | 1.0482782 × 1011 |
Variance | 4.0060935 × 109 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
85640 | 30 | < 0.1% |
85641 | 30 | < 0.1% |
85642 | 30 | < 0.1% |
85651 | 30 | < 0.1% |
85644 | 30 | < 0.1% |
85639 | 30 | < 0.1% |
85646 | 30 | < 0.1% |
85643 | 30 | < 0.1% |
85645 | 30 | < 0.1% |
85638 | 30 | < 0.1% |
Other values (116522) | 999798 |
Value | Count | Frequency (%) |
1 | 12 | |
2 | 12 | |
3 | 12 | |
4 | 12 | |
5 | 12 | |
6 | 12 | |
7 | 12 | |
11 | 12 | |
12 | 12 | |
13 | 12 |
Value | Count | Frequency (%) |
301175 | 2 | |
301174 | 2 | |
301173 | 2 | |
301170 | 2 | |
301169 | 2 | |
301168 | 2 | |
301167 | 2 | |
301166 | 2 | |
301165 | 2 | |
301163 | 2 |
PolicyID
Real number (ℝ)
High correlation 
Distinct | 7000 |
---|---|
Distinct (%) | 0.7% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 7956.6825 |
Minimum | 14 |
---|---|
Maximum | 23246 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 14 |
---|---|
5-th percentile | 477 |
Q1 | 4500 |
median | 7071 |
Q3 | 11077 |
95-th percentile | 20273 |
Maximum | 23246 |
Range | 23232 |
Interquartile range (IQR) | 6577 |
Descriptive statistics
Standard deviation | 5290.0385 |
---|---|
Coefficient of variation (CV) | 0.6648548 |
Kurtosis | 0.28196964 |
Mean | 7956.6825 |
Median Absolute Deviation (MAD) | 3201 |
Skewness | 0.73742825 |
Sum | 7.9574622 × 109 |
Variance | 27984507 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
3870 | 10400 | 1.0% |
698 | 4500 | 0.4% |
5351 | 3080 | 0.3% |
6924 | 2852 | 0.3% |
9774 | 2392 | 0.2% |
4641 | 2227 | 0.2% |
6653 | 2094 | 0.2% |
6641 | 2028 | 0.2% |
6643 | 2010 | 0.2% |
2137 | 1941 | 0.2% |
Other values (6990) | 966574 |
Value | Count | Frequency (%) |
14 | 216 | |
15 | 225 | |
16 | 108 | |
17 | 108 | |
18 | 108 | |
19 | 108 | |
20 | 108 | |
21 | 216 | |
22 | 108 | |
23 | 108 |
Value | Count | Frequency (%) |
23246 | 20 | |
23245 | 22 | |
23244 | 24 | |
23241 | 22 | |
23239 | 8 | < 0.1% |
23238 | 9 | < 0.1% |
23223 | 1 | < 0.1% |
23222 | 1 | < 0.1% |
23220 | 10 | < 0.1% |
23219 | 33 |
TransactionMonth
Categorical
Distinct | 23 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
2015-08-01 00:00:00 | |
---|---|
2015-07-01 00:00:00 | |
2015-06-01 00:00:00 | |
2015-05-01 00:00:00 | |
2015-04-01 00:00:00 | |
Other values (18) |
Length
Max length | 19 |
---|---|
Median length | 19 |
Mean length | 19 |
Min length | 19 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | 2015-03-01 00:00:00 |
---|---|
2nd row | 2015-05-01 00:00:00 |
3rd row | 2015-07-01 00:00:00 |
4th row | 2015-05-01 00:00:00 |
5th row | 2015-07-01 00:00:00 |
Common Values
Value | Count | Frequency (%) |
2015-08-01 00:00:00 | 106747 | |
2015-07-01 00:00:00 | 104143 | |
2015-06-01 00:00:00 | 102594 | |
2015-05-01 00:00:00 | 99898 | |
2015-04-01 00:00:00 | 96563 | |
2015-03-01 00:00:00 | 92015 | |
2015-02-01 00:00:00 | 83198 | |
2015-01-01 00:00:00 | 71576 | |
2014-12-01 00:00:00 | 62457 | |
2014-11-01 00:00:00 | 48248 | 4.8% |
Other values (13) | 132659 |
Length
Value | Count | Frequency (%) |
00:00:00 | 1000098 | |
2015-08-01 | 106747 | 5.3% |
2015-07-01 | 104143 | 5.2% |
2015-06-01 | 102594 | 5.1% |
2015-05-01 | 99898 | 5.0% |
2015-04-01 | 96563 | 4.8% |
2015-03-01 | 92015 | 4.6% |
2015-02-01 | 83198 | 4.2% |
2015-01-01 | 71576 | 3.6% |
2014-12-01 | 62457 | 3.1% |
Other values (14) | 180907 | 9.0% |
Most occurring characters
Value | Count | Frequency (%) |
0 | 8887486 | |
1 | 2270304 | 11.9% |
- | 2000196 | 10.5% |
: | 2000196 | 10.5% |
2 | 1149310 | 6.0% |
1000098 | 5.3% | |
5 | 866116 | 4.6% |
4 | 344110 | 1.8% |
8 | 126373 | 0.7% |
7 | 119050 | 0.6% |
Other values (3) | 238623 | 1.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 19001862 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
0 | 8887486 | |
1 | 2270304 | 11.9% |
- | 2000196 | 10.5% |
: | 2000196 | 10.5% |
2 | 1149310 | 6.0% |
1000098 | 5.3% | |
5 | 866116 | 4.6% |
4 | 344110 | 1.8% |
8 | 126373 | 0.7% |
7 | 119050 | 0.6% |
Other values (3) | 238623 | 1.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 19001862 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
0 | 8887486 | |
1 | 2270304 | 11.9% |
- | 2000196 | 10.5% |
: | 2000196 | 10.5% |
2 | 1149310 | 6.0% |
1000098 | 5.3% | |
5 | 866116 | 4.6% |
4 | 344110 | 1.8% |
8 | 126373 | 0.7% |
7 | 119050 | 0.6% |
Other values (3) | 238623 | 1.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 19001862 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
0 | 8887486 | |
1 | 2270304 | 11.9% |
- | 2000196 | 10.5% |
: | 2000196 | 10.5% |
2 | 1149310 | 6.0% |
1000098 | 5.3% | |
5 | 866116 | 4.6% |
4 | 344110 | 1.8% |
8 | 126373 | 0.7% |
7 | 119050 | 0.6% |
Other values (3) | 238623 | 1.3% |
IsVATRegistered
Boolean
Imbalance 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 976.8 KiB |
False | |
---|---|
True | 5023 |
Value | Count | Frequency (%) |
False | 995075 | |
True | 5023 | 0.5% |
Citizenship
Categorical
Imbalance 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
ZA | |
---|---|
ZW | 936 |
AF | 231 |
Length
Max length | 2 |
---|---|
Median length | 2 |
Mean length | 2 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | |
---|---|
2nd row | |
3rd row | |
4th row | |
5th row |
Common Values
Value | Count | Frequency (%) |
895210 | ||
ZA | 103721 | 10.4% |
ZW | 936 | 0.1% |
AF | 231 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
za | 103721 | |
zw | 936 | 0.9% |
af | 231 | 0.2% |
Most occurring characters
Value | Count | Frequency (%) |
1790420 | ||
Z | 104657 | 5.2% |
A | 103952 | 5.2% |
W | 936 | < 0.1% |
F | 231 | < 0.1% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 2000196 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
1790420 | ||
Z | 104657 | 5.2% |
A | 103952 | 5.2% |
W | 936 | < 0.1% |
F | 231 | < 0.1% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 2000196 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
1790420 | ||
Z | 104657 | 5.2% |
A | 103952 | 5.2% |
W | 936 | < 0.1% |
F | 231 | < 0.1% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 2000196 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
1790420 | ||
Z | 104657 | 5.2% |
A | 103952 | 5.2% |
W | 936 | < 0.1% |
F | 231 | < 0.1% |
LegalType
Categorical
Imbalance 
Distinct | 6 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Individual | |
---|---|
Private company | 83891 |
Close Corporation | 2459 |
Public company | 1295 |
Partnership | 331 |
Length
Max length | 17 |
---|---|
Median length | 10 |
Mean length | 10.443101 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Close Corporation |
---|---|
2nd row | Close Corporation |
3rd row | Close Corporation |
4th row | Close Corporation |
5th row | Close Corporation |
Common Values
Value | Count | Frequency (%) |
Individual | 911929 | |
Private company | 83891 | 8.4% |
Close Corporation | 2459 | 0.2% |
Public company | 1295 | 0.1% |
Partnership | 331 | < 0.1% |
Sole proprieter | 193 | < 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
individual | 911929 | |
company | 85186 | 7.8% |
private | 83891 | 7.7% |
close | 2459 | 0.2% |
corporation | 2459 | 0.2% |
public | 1295 | 0.1% |
partnership | 331 | < 0.1% |
sole | 193 | < 0.1% |
proprieter | 193 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
i | 1912027 | |
d | 1823858 | |
a | 1083796 | |
n | 999905 | |
v | 995820 | |
l | 915876 | |
u | 913224 | |
I | 911929 | |
o | 95408 | 0.9% |
r | 90050 | 0.9% |
Other values (13) | 702231 | 6.7% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 10444124 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
i | 1912027 | |
d | 1823858 | |
a | 1083796 | |
n | 999905 | |
v | 995820 | |
l | 915876 | |
u | 913224 | |
I | 911929 | |
o | 95408 | 0.9% |
r | 90050 | 0.9% |
Other values (13) | 702231 | 6.7% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 10444124 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
i | 1912027 | |
d | 1823858 | |
a | 1083796 | |
n | 999905 | |
v | 995820 | |
l | 915876 | |
u | 913224 | |
I | 911929 | |
o | 95408 | 0.9% |
r | 90050 | 0.9% |
Other values (13) | 702231 | 6.7% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 10444124 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
i | 1912027 | |
d | 1823858 | |
a | 1083796 | |
n | 999905 | |
v | 995820 | |
l | 915876 | |
u | 913224 | |
I | 911929 | |
o | 95408 | 0.9% |
r | 90050 | 0.9% |
Other values (13) | 702231 | 6.7% |
Title
Categorical
Imbalance 
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Mr | |
---|---|
Mrs | 45850 |
Ms | 13269 |
Miss | 6614 |
Dr | 810 |
Length
Max length | 4 |
---|---|
Median length | 2 |
Mean length | 2.0590722 |
Min length | 2 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Mr |
---|---|
2nd row | Mr |
3rd row | Mr |
4th row | Mr |
5th row | Mr |
Common Values
Value | Count | Frequency (%) |
Mr | 933555 | |
Mrs | 45850 | 4.6% |
Ms | 13269 | 1.3% |
Miss | 6614 | 0.7% |
Dr | 810 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
mr | 933555 | |
mrs | 45850 | 4.6% |
ms | 13269 | 1.3% |
miss | 6614 | 0.7% |
dr | 810 | 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
M | 999288 | |
r | 980215 | |
s | 72347 | 3.5% |
i | 6614 | 0.3% |
D | 810 | < 0.1% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 2059274 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
M | 999288 | |
r | 980215 | |
s | 72347 | 3.5% |
i | 6614 | 0.3% |
D | 810 | < 0.1% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 2059274 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
M | 999288 | |
r | 980215 | |
s | 72347 | 3.5% |
i | 6614 | 0.3% |
D | 810 | < 0.1% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 2059274 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
M | 999288 | |
r | 980215 | |
s | 72347 | 3.5% |
i | 6614 | 0.3% |
D | 810 | < 0.1% |
Language
Categorical
Constant 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
English |
---|
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 7 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | English |
---|---|
2nd row | English |
3rd row | English |
4th row | English |
5th row | English |
Common Values
Value | Count | Frequency (%) |
English | 1000098 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
english | 1000098 |
Most occurring characters
Value | Count | Frequency (%) |
E | 1000098 | |
n | 1000098 | |
g | 1000098 | |
l | 1000098 | |
i | 1000098 | |
s | 1000098 | |
h | 1000098 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 7000686 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
E | 1000098 | |
n | 1000098 | |
g | 1000098 | |
l | 1000098 | |
i | 1000098 | |
s | 1000098 | |
h | 1000098 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 7000686 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
E | 1000098 | |
n | 1000098 | |
g | 1000098 | |
l | 1000098 | |
i | 1000098 | |
s | 1000098 | |
h | 1000098 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 7000686 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
E | 1000098 | |
n | 1000098 | |
g | 1000098 | |
l | 1000098 | |
i | 1000098 | |
s | 1000098 | |
h | 1000098 |
Bank
Categorical
High correlation  Missing 
Distinct | 11 |
---|---|
Distinct (%) | < 0.1% |
Missing | 145961 |
Missing (%) | 14.6% |
Memory size | 7.6 MiB |
First National Bank | |
---|---|
ABSA Bank | |
Standard Bank | |
Nedbank | |
Capitec Bank | |
Other values (6) | 16499 |
Length
Max length | 22 |
---|---|
Median length | 19 |
Mean length | 12.916798 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | First National Bank |
---|---|
2nd row | First National Bank |
3rd row | First National Bank |
4th row | First National Bank |
5th row | First National Bank |
Common Values
Value | Count | Frequency (%) |
First National Bank | 260811 | |
ABSA Bank | 204954 | |
Standard Bank | 181715 | |
Nedbank | 132003 | |
Capitec Bank | 58155 | 5.8% |
RMB Private Bank | 12576 | 1.3% |
Ithala Bank | 1730 | 0.2% |
Investec Bank | 732 | 0.1% |
Old Mutual | 688 | 0.1% |
FirstRand Bank | 638 | 0.1% |
(Missing) | 145961 |
Length
Value | Count | Frequency (%) |
bank | 721446 | |
first | 260811 | 14.1% |
national | 260811 | 14.1% |
absa | 204954 | 11.1% |
standard | 181715 | 9.8% |
nedbank | 132003 | 7.1% |
capitec | 58155 | 3.1% |
rmb | 12576 | 0.7% |
private | 12576 | 0.7% |
ithala | 1730 | 0.1% |
Other values (6) | 3016 | 0.2% |
Most occurring characters
Value | Count | Frequency (%) |
a | 1814153 | |
n | 1297615 | |
995656 | ||
B | 938976 | 8.5% |
k | 853449 | 7.7% |
t | 777991 | 7.1% |
i | 593261 | 5.4% |
d | 496759 | 4.5% |
r | 455875 | 4.1% |
A | 409908 | 3.7% |
Other values (20) | 2399072 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 11032715 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
a | 1814153 | |
n | 1297615 | |
995656 | ||
B | 938976 | 8.5% |
k | 853449 | 7.7% |
t | 777991 | 7.1% |
i | 593261 | 5.4% |
d | 496759 | 4.5% |
r | 455875 | 4.1% |
A | 409908 | 3.7% |
Other values (20) | 2399072 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 11032715 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
a | 1814153 | |
n | 1297615 | |
995656 | ||
B | 938976 | 8.5% |
k | 853449 | 7.7% |
t | 777991 | 7.1% |
i | 593261 | 5.4% |
d | 496759 | 4.5% |
r | 455875 | 4.1% |
A | 409908 | 3.7% |
Other values (20) | 2399072 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 11032715 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
a | 1814153 | |
n | 1297615 | |
995656 | ||
B | 938976 | 8.5% |
k | 853449 | 7.7% |
t | 777991 | 7.1% |
i | 593261 | 5.4% |
d | 496759 | 4.5% |
r | 455875 | 4.1% |
A | 409908 | 3.7% |
Other values (20) | 2399072 |
AccountType
Categorical
High correlation  Missing 
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 40232 |
Missing (%) | 4.0% |
Memory size | 7.6 MiB |
Current account | |
---|---|
Savings account | |
Transmission account | 3721 |
Length
Max length | 20 |
---|---|
Median length | 15 |
Mean length | 15.019383 |
Min length | 15 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Current account |
---|---|
2nd row | Current account |
3rd row | Current account |
4th row | Current account |
5th row | Current account |
Common Values
Value | Count | Frequency (%) |
Current account | 597938 | |
Savings account | 358207 | |
Transmission account | 3721 | 0.4% |
(Missing) | 40232 | 4.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
account | 959866 | |
current | 597938 | |
savings | 358207 | 18.7% |
transmission | 3721 | 0.2% |
Most occurring characters
Value | Count | Frequency (%) |
n | 1923453 | |
c | 1919732 | |
t | 1557804 | |
u | 1557804 | |
a | 1321794 | |
r | 1199597 | |
o | 963587 | |
959866 | ||
C | 597938 | 4.1% |
e | 597938 | 4.1% |
Other values (7) | 1817082 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 14416595 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
n | 1923453 | |
c | 1919732 | |
t | 1557804 | |
u | 1557804 | |
a | 1321794 | |
r | 1199597 | |
o | 963587 | |
959866 | ||
C | 597938 | 4.1% |
e | 597938 | 4.1% |
Other values (7) | 1817082 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 14416595 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
n | 1923453 | |
c | 1919732 | |
t | 1557804 | |
u | 1557804 | |
a | 1321794 | |
r | 1199597 | |
o | 963587 | |
959866 | ||
C | 597938 | 4.1% |
e | 597938 | 4.1% |
Other values (7) | 1817082 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 14416595 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
n | 1923453 | |
c | 1919732 | |
t | 1557804 | |
u | 1557804 | |
a | 1321794 | |
r | 1199597 | |
o | 963587 | |
959866 | ||
C | 597938 | 4.1% |
e | 597938 | 4.1% |
Other values (7) | 1817082 |
MaritalStatus
Categorical
Imbalance 
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 8259 |
Missing (%) | 0.8% |
Memory size | 7.6 MiB |
Not specified | |
---|---|
Single | 4254 |
Married | 1377 |
Length
Max length | 13 |
---|---|
Median length | 13 |
Mean length | 12.961647 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Not specified |
---|---|
2nd row | Not specified |
3rd row | Not specified |
4th row | Not specified |
5th row | Not specified |
Common Values
Value | Count | Frequency (%) |
Not specified | 986208 | |
Single | 4254 | 0.4% |
Married | 1377 | 0.1% |
(Missing) | 8259 | 0.8% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
not | 986208 | |
specified | 986208 | |
single | 4254 | 0.2% |
married | 1377 | 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
e | 1978047 | |
i | 1978047 | |
d | 987585 | |
N | 986208 | |
o | 986208 | |
t | 986208 | |
p | 986208 | |
s | 986208 | |
c | 986208 | |
986208 | ||
Other values (8) | 1008732 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 12855867 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 1978047 | |
i | 1978047 | |
d | 987585 | |
N | 986208 | |
o | 986208 | |
t | 986208 | |
p | 986208 | |
s | 986208 | |
c | 986208 | |
986208 | ||
Other values (8) | 1008732 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 12855867 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 1978047 | |
i | 1978047 | |
d | 987585 | |
N | 986208 | |
o | 986208 | |
t | 986208 | |
p | 986208 | |
s | 986208 | |
c | 986208 | |
986208 | ||
Other values (8) | 1008732 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 12855867 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 1978047 | |
i | 1978047 | |
d | 987585 | |
N | 986208 | |
o | 986208 | |
t | 986208 | |
p | 986208 | |
s | 986208 | |
c | 986208 | |
986208 | ||
Other values (8) | 1008732 |
Gender
Categorical
Imbalance 
Distinct | 3 |
---|---|
Distinct (%) | < 0.1% |
Missing | 9536 |
Missing (%) | 1.0% |
Memory size | 7.6 MiB |
Not specified | |
---|---|
Male | 42817 |
Female | 6755 |
Length
Max length | 13 |
---|---|
Median length | 13 |
Mean length | 12.56324 |
Min length | 4 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Not specified |
---|---|
2nd row | Not specified |
3rd row | Not specified |
4th row | Not specified |
5th row | Not specified |
Common Values
Value | Count | Frequency (%) |
Not specified | 940990 | |
Male | 42817 | 4.3% |
Female | 6755 | 0.7% |
(Missing) | 9536 | 1.0% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
not | 940990 | |
specified | 940990 | |
male | 42817 | 2.2% |
female | 6755 | 0.3% |
Most occurring characters
Value | Count | Frequency (%) |
e | 1938307 | |
i | 1881980 | |
t | 940990 | |
N | 940990 | |
940990 | ||
s | 940990 | |
p | 940990 | |
o | 940990 | |
c | 940990 | |
f | 940990 | |
Other values (6) | 1096461 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 12444668 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 1938307 | |
i | 1881980 | |
t | 940990 | |
N | 940990 | |
940990 | ||
s | 940990 | |
p | 940990 | |
o | 940990 | |
c | 940990 | |
f | 940990 | |
Other values (6) | 1096461 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 12444668 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 1938307 | |
i | 1881980 | |
t | 940990 | |
N | 940990 | |
940990 | ||
s | 940990 | |
p | 940990 | |
o | 940990 | |
c | 940990 | |
f | 940990 | |
Other values (6) | 1096461 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 12444668 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 1938307 | |
i | 1881980 | |
t | 940990 | |
N | 940990 | |
940990 | ||
s | 940990 | |
p | 940990 | |
o | 940990 | |
c | 940990 | |
f | 940990 | |
Other values (6) | 1096461 |
Country
Categorical
Constant 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
South Africa |
---|
Length
Max length | 12 |
---|---|
Median length | 12 |
Mean length | 12 |
Min length | 12 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | South Africa |
---|---|
2nd row | South Africa |
3rd row | South Africa |
4th row | South Africa |
5th row | South Africa |
Common Values
Value | Count | Frequency (%) |
South Africa | 1000098 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
south | 1000098 | |
africa | 1000098 |
Most occurring characters
Value | Count | Frequency (%) |
S | 1000098 | |
o | 1000098 | |
u | 1000098 | |
t | 1000098 | |
h | 1000098 | |
1000098 | ||
A | 1000098 | |
f | 1000098 | |
r | 1000098 | |
i | 1000098 | |
Other values (2) | 2000196 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 12001176 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
S | 1000098 | |
o | 1000098 | |
u | 1000098 | |
t | 1000098 | |
h | 1000098 | |
1000098 | ||
A | 1000098 | |
f | 1000098 | |
r | 1000098 | |
i | 1000098 | |
Other values (2) | 2000196 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 12001176 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
S | 1000098 | |
o | 1000098 | |
u | 1000098 | |
t | 1000098 | |
h | 1000098 | |
1000098 | ||
A | 1000098 | |
f | 1000098 | |
r | 1000098 | |
i | 1000098 | |
Other values (2) | 2000196 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 12001176 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
S | 1000098 | |
o | 1000098 | |
u | 1000098 | |
t | 1000098 | |
h | 1000098 | |
1000098 | ||
A | 1000098 | |
f | 1000098 | |
r | 1000098 | |
i | 1000098 | |
Other values (2) | 2000196 |
Province
Categorical
High correlation 
Distinct | 9 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Gauteng | |
---|---|
Western Cape | |
KwaZulu-Natal | |
North West | |
Mpumalanga | |
Other values (4) |
Length
Max length | 13 |
---|---|
Median length | 12 |
Mean length | 9.6746759 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Gauteng |
---|---|
2nd row | Gauteng |
3rd row | Gauteng |
4th row | Gauteng |
5th row | Gauteng |
Common Values
Value | Count | Frequency (%) |
Gauteng | 393865 | |
Western Cape | 170796 | |
KwaZulu-Natal | 169781 | |
North West | 143287 | 14.3% |
Mpumalanga | 52718 | 5.3% |
Eastern Cape | 30336 | 3.0% |
Limpopo | 24836 | 2.5% |
Free State | 8099 | 0.8% |
Northern Cape | 6380 | 0.6% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
gauteng | 393865 | |
cape | 207512 | |
western | 170796 | |
kwazulu-natal | 169781 | |
north | 143287 | 10.5% |
west | 143287 | 10.5% |
mpumalanga | 52718 | 3.9% |
eastern | 30336 | 2.2% |
limpopo | 24836 | 1.8% |
free | 8099 | 0.6% |
Other values (2) | 14479 | 1.1% |
Most occurring characters
Value | Count | Frequency (%) |
a | 1307309 | |
e | 1147269 | |
t | 1073930 | 11.1% |
u | 786145 | 8.1% |
n | 654095 | 6.8% |
g | 446583 | 4.6% |
G | 393865 | 4.1% |
l | 392280 | 4.1% |
r | 365278 | 3.8% |
358898 | 3.7% | |
Other values (18) | 2749972 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 9675624 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
a | 1307309 | |
e | 1147269 | |
t | 1073930 | 11.1% |
u | 786145 | 8.1% |
n | 654095 | 6.8% |
g | 446583 | 4.6% |
G | 393865 | 4.1% |
l | 392280 | 4.1% |
r | 365278 | 3.8% |
358898 | 3.7% | |
Other values (18) | 2749972 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 9675624 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
a | 1307309 | |
e | 1147269 | |
t | 1073930 | 11.1% |
u | 786145 | 8.1% |
n | 654095 | 6.8% |
g | 446583 | 4.6% |
G | 393865 | 4.1% |
l | 392280 | 4.1% |
r | 365278 | 3.8% |
358898 | 3.7% | |
Other values (18) | 2749972 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 9675624 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
a | 1307309 | |
e | 1147269 | |
t | 1073930 | 11.1% |
u | 786145 | 8.1% |
n | 654095 | 6.8% |
g | 446583 | 4.6% |
G | 393865 | 4.1% |
l | 392280 | 4.1% |
r | 365278 | 3.8% |
358898 | 3.7% | |
Other values (18) | 2749972 |
PostalCode
Real number (ℝ)
High correlation 
Distinct | 888 |
---|---|
Distinct (%) | 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 3020.6009 |
Minimum | 1 |
---|---|
Maximum | 9870 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 1 |
---|---|
5-th percentile | 122 |
Q1 | 827 |
median | 2000 |
Q3 | 4180 |
95-th percentile | 7800 |
Maximum | 9870 |
Range | 9869 |
Interquartile range (IQR) | 3353 |
Descriptive statistics
Standard deviation | 2649.8544 |
---|---|
Coefficient of variation (CV) | 0.87726069 |
Kurtosis | -0.6360581 |
Mean | 3020.6009 |
Median Absolute Deviation (MAD) | 1698 |
Skewness | 0.79947163 |
Sum | 3.0208969 × 109 |
Variance | 7021728.4 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2000 | 133498 | 13.3% |
122 | 49171 | 4.9% |
7784 | 28585 | 2.9% |
299 | 25546 | 2.6% |
7405 | 18518 | 1.9% |
458 | 13775 | 1.4% |
8000 | 11794 | 1.2% |
2196 | 11048 | 1.1% |
470 | 10226 | 1.0% |
7100 | 10161 | 1.0% |
Other values (878) | 687776 |
Value | Count | Frequency (%) |
1 | 5341 | |
2 | 1488 | 0.1% |
4 | 77 | < 0.1% |
5 | 400 | < 0.1% |
6 | 440 | < 0.1% |
7 | 356 | < 0.1% |
8 | 1279 | 0.1% |
17 | 160 | < 0.1% |
21 | 415 | < 0.1% |
22 | 605 | 0.1% |
Value | Count | Frequency (%) |
9870 | 220 | < 0.1% |
9869 | 1415 | |
9868 | 100 | < 0.1% |
9830 | 56 | < 0.1% |
9781 | 643 | |
9762 | 212 | < 0.1% |
9756 | 132 | < 0.1% |
9752 | 120 | < 0.1% |
9750 | 400 | < 0.1% |
9745 | 45 | < 0.1% |
MainCrestaZone
Categorical
High correlation 
Distinct | 16 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Transvaal (all except Pretoria) | |
---|---|
Johannesburg | |
Transvaal (Pretoria) | |
Cape Province (Cape Town) | |
Natal | |
Other values (11) |
Length
Max length | 43 |
---|---|
Median length | 31 |
Mean length | 21.486147 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Rand East |
---|---|
2nd row | Rand East |
3rd row | Rand East |
4th row | Rand East |
5th row | Rand East |
Common Values
Value | Count | Frequency (%) |
Transvaal (all except Pretoria) | 296187 | |
Johannesburg | 176020 | |
Transvaal (Pretoria) | 100331 | 10.0% |
Cape Province (Cape Town) | 95936 | 9.6% |
Natal | 88266 | 8.8% |
Natal (Durban) | 82859 | 8.3% |
Karoo 1 (Northeast of Cape Town) | 52732 | 5.3% |
Rand East | 42168 | 4.2% |
Tembu 2, Cape Mid 2, Cape Mid West, Tembu 1 | 20191 | 2.0% |
Cape Province (East and North of Cape Town) | 19391 | 1.9% |
Other values (6) | 26017 | 2.6% |
Length
Value | Count | Frequency (%) |
transvaal | 396518 | |
pretoria | 396518 | |
cape | 332884 | |
except | 296187 | |
all | 296187 | |
johannesburg | 176020 | 5.8% |
natal | 171125 | 5.6% |
town | 168059 | 5.5% |
province | 122028 | 4.0% |
durban | 82859 | 2.7% |
Other values (21) | 592579 |
Most occurring characters
Value | Count | Frequency (%) |
a | 3075922 | |
2030866 | 9.5% | |
e | 1769922 | 8.2% |
r | 1713396 | 8.0% |
n | 1202143 | 5.6% |
l | 1164808 | 5.4% |
o | 1134075 | 5.3% |
t | 1100276 | 5.1% |
s | 719414 | 3.3% |
( | 647436 | 3.0% |
Other values (35) | 6929995 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 21488253 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
a | 3075922 | |
2030866 | 9.5% | |
e | 1769922 | 8.2% |
r | 1713396 | 8.0% |
n | 1202143 | 5.6% |
l | 1164808 | 5.4% |
o | 1134075 | 5.3% |
t | 1100276 | 5.1% |
s | 719414 | 3.3% |
( | 647436 | 3.0% |
Other values (35) | 6929995 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 21488253 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
a | 3075922 | |
2030866 | 9.5% | |
e | 1769922 | 8.2% |
r | 1713396 | 8.0% |
n | 1202143 | 5.6% |
l | 1164808 | 5.4% |
o | 1134075 | 5.3% |
t | 1100276 | 5.1% |
s | 719414 | 3.3% |
( | 647436 | 3.0% |
Other values (35) | 6929995 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 21488253 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
a | 3075922 | |
2030866 | 9.5% | |
e | 1769922 | 8.2% |
r | 1713396 | 8.0% |
n | 1202143 | 5.6% |
l | 1164808 | 5.4% |
o | 1134075 | 5.3% |
t | 1100276 | 5.1% |
s | 719414 | 3.3% |
( | 647436 | 3.0% |
Other values (35) | 6929995 |
SubCrestaZone
Categorical
High correlation 
Distinct | 45 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Johannesburg | |
---|---|
Pretoria | |
Cape Town | |
Durban | |
Transvaal North | |
Other values (40) |
Length
Max length | 20 |
---|---|
Median length | 17 |
Mean length | 11.570149 |
Min length | 5 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Rand East |
---|---|
2nd row | Rand East |
3rd row | Rand East |
4th row | Rand East |
5th row | Rand East |
Common Values
Value | Count | Frequency (%) |
Johannesburg | 176020 | |
Pretoria | 100331 | |
Cape Town | 95936 | |
Durban | 82859 | 8.3% |
Transvaal North | 75141 | 7.5% |
Transvaal North West | 72558 | 7.3% |
Northeast of CT | 51386 | 5.1% |
Transvaal East | 45729 | 4.6% |
Transvaal South | 45571 | 4.6% |
Rand East | 42168 | 4.2% |
Other values (35) | 212399 |
Length
Value | Count | Frequency (%) |
transvaal | 253447 | |
north | 198031 | |
johannesburg | 176020 | 9.9% |
east | 117229 | 6.6% |
west | 110714 | 6.2% |
cape | 105095 | 5.9% |
pretoria | 100331 | 5.6% |
town | 95936 | 5.4% |
durban | 82859 | 4.7% |
south | 72502 | 4.1% |
Other values (29) | 467784 |
Most occurring characters
Value | Count | Frequency (%) |
a | 1622753 | |
r | 978124 | 8.5% |
n | 900172 | 7.8% |
o | 840123 | 7.3% |
t | 789786 | 6.8% |
s | 783786 | 6.8% |
779850 | 6.7% | |
e | 594775 | 5.1% |
h | 524645 | 4.5% |
T | 413347 | 3.6% |
Other values (34) | 3343922 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 11571283 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
a | 1622753 | |
r | 978124 | 8.5% |
n | 900172 | 7.8% |
o | 840123 | 7.3% |
t | 789786 | 6.8% |
s | 783786 | 6.8% |
779850 | 6.7% | |
e | 594775 | 5.1% |
h | 524645 | 4.5% |
T | 413347 | 3.6% |
Other values (34) | 3343922 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 11571283 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
a | 1622753 | |
r | 978124 | 8.5% |
n | 900172 | 7.8% |
o | 840123 | 7.3% |
t | 789786 | 6.8% |
s | 783786 | 6.8% |
779850 | 6.7% | |
e | 594775 | 5.1% |
h | 524645 | 4.5% |
T | 413347 | 3.6% |
Other values (34) | 3343922 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 11571283 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
a | 1622753 | |
r | 978124 | 8.5% |
n | 900172 | 7.8% |
o | 840123 | 7.3% |
t | 789786 | 6.8% |
s | 783786 | 6.8% |
779850 | 6.7% | |
e | 594775 | 5.1% |
h | 524645 | 4.5% |
T | 413347 | 3.6% |
Other values (34) | 3343922 |
ItemType
Categorical
Constant 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Mobility - Motor |
---|
Length
Max length | 16 |
---|---|
Median length | 16 |
Mean length | 16 |
Min length | 16 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Mobility - Motor |
---|---|
2nd row | Mobility - Motor |
3rd row | Mobility - Motor |
4th row | Mobility - Motor |
5th row | Mobility - Motor |
Common Values
Value | Count | Frequency (%) |
Mobility - Motor | 1000098 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
mobility | 1000098 | |
1000098 | ||
motor | 1000098 |
Most occurring characters
Value | Count | Frequency (%) |
o | 3000294 | |
M | 2000196 | |
i | 2000196 | |
t | 2000196 | |
2000196 | ||
b | 1000098 | 6.2% |
l | 1000098 | 6.2% |
y | 1000098 | 6.2% |
- | 1000098 | 6.2% |
r | 1000098 | 6.2% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 16001568 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
o | 3000294 | |
M | 2000196 | |
i | 2000196 | |
t | 2000196 | |
2000196 | ||
b | 1000098 | 6.2% |
l | 1000098 | 6.2% |
y | 1000098 | 6.2% |
- | 1000098 | 6.2% |
r | 1000098 | 6.2% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 16001568 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
o | 3000294 | |
M | 2000196 | |
i | 2000196 | |
t | 2000196 | |
2000196 | ||
b | 1000098 | 6.2% |
l | 1000098 | 6.2% |
y | 1000098 | 6.2% |
- | 1000098 | 6.2% |
r | 1000098 | 6.2% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 16001568 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
o | 3000294 | |
M | 2000196 | |
i | 2000196 | |
t | 2000196 | |
2000196 | ||
b | 1000098 | 6.2% |
l | 1000098 | 6.2% |
y | 1000098 | 6.2% |
- | 1000098 | 6.2% |
r | 1000098 | 6.2% |
mmcode
Real number (ℝ)
High correlation 
Distinct | 427 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 54877704 |
Minimum | 4041200 |
---|---|
Maximum | 65065350 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 4041200 |
---|---|
5-th percentile | 11511100 |
Q1 | 60056925 |
median | 60058415 |
Q3 | 60058418 |
95-th percentile | 60058419 |
Maximum | 65065350 |
Range | 61024150 |
Interquartile range (IQR) | 1493 |
Descriptive statistics
Standard deviation | 13603805 |
---|---|
Coefficient of variation (CV) | 0.24789312 |
Kurtosis | 5.6156328 |
Mean | 54877704 |
Median Absolute Deviation (MAD) | 8 |
Skewness | -2.6092351 |
Sum | 5.485279 × 1013 |
Variance | 1.8506352 × 1014 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
60058419 | 186087 | |
60058418 | 165845 | |
60058415 | 137242 | |
60058407 | 99444 | |
60056925 | 79525 | 8.0% |
60056987 | 40960 | 4.1% |
60058400 | 28773 | 2.9% |
11510120 | 16821 | 1.7% |
7512100 | 11265 | 1.1% |
22840150 | 11056 | 1.1% |
Other values (417) | 222528 |
Value | Count | Frequency (%) |
4041200 | 1 | < 0.1% |
4041550 | 1 | < 0.1% |
4041640 | 1 | < 0.1% |
4042080 | 1005 | |
4042120 | 804 | |
4042130 | 552 | |
4042141 | 615 | |
4042151 | 1116 | |
4042281 | 785 | |
4042320 | 96 | < 0.1% |
Value | Count | Frequency (%) |
65065350 | 108 | |
65030720 | 99 | |
65030100 | 109 | |
64092300 | 81 | < 0.1% |
64090740 | 50 | < 0.1% |
64088650 | 80 | < 0.1% |
64088570 | 206 | |
64088515 | 160 | |
64088370 | 1 | < 0.1% |
64088260 | 142 |
VehicleType
Categorical
High correlation  Imbalance 
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Memory size | 7.6 MiB |
Passenger Vehicle | |
---|---|
Medium Commercial | 53985 |
Heavy Commercial | 7401 |
Light Commercial | 3897 |
Bus | 665 |
Length
Max length | 17 |
---|---|
Median length | 17 |
Mean length | 16.979383 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Passenger Vehicle |
---|---|
2nd row | Passenger Vehicle |
3rd row | Passenger Vehicle |
4th row | Passenger Vehicle |
5th row | Passenger Vehicle |
Common Values
Value | Count | Frequency (%) |
Passenger Vehicle | 933598 | |
Medium Commercial | 53985 | 5.4% |
Heavy Commercial | 7401 | 0.7% |
Light Commercial | 3897 | 0.4% |
Bus | 665 | 0.1% |
(Missing) | 552 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
passenger | 933598 | |
vehicle | 933598 | |
commercial | 65283 | 3.3% |
medium | 53985 | 2.7% |
heavy | 7401 | 0.4% |
light | 3897 | 0.2% |
bus | 665 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
e | 3861061 | |
s | 1867861 | |
i | 1056763 | 6.2% |
a | 1006282 | 5.9% |
998881 | 5.9% | |
c | 998881 | 5.9% |
l | 998881 | 5.9% |
r | 998881 | 5.9% |
g | 937495 | 5.5% |
h | 937495 | 5.5% |
Other values (15) | 3309193 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 16971674 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 3861061 | |
s | 1867861 | |
i | 1056763 | 6.2% |
a | 1006282 | 5.9% |
998881 | 5.9% | |
c | 998881 | 5.9% |
l | 998881 | 5.9% |
r | 998881 | 5.9% |
g | 937495 | 5.5% |
h | 937495 | 5.5% |
Other values (15) | 3309193 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 16971674 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 3861061 | |
s | 1867861 | |
i | 1056763 | 6.2% |
a | 1006282 | 5.9% |
998881 | 5.9% | |
c | 998881 | 5.9% |
l | 998881 | 5.9% |
r | 998881 | 5.9% |
g | 937495 | 5.5% |
h | 937495 | 5.5% |
Other values (15) | 3309193 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 16971674 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 3861061 | |
s | 1867861 | |
i | 1056763 | 6.2% |
a | 1006282 | 5.9% |
998881 | 5.9% | |
c | 998881 | 5.9% |
l | 998881 | 5.9% |
r | 998881 | 5.9% |
g | 937495 | 5.5% |
h | 937495 | 5.5% |
Other values (15) | 3309193 |
RegistrationYear
Real number (ℝ)
High correlation 
Distinct | 25 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2010.2254 |
Minimum | 1987 |
---|---|
Maximum | 2015 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 1987 |
---|---|
5-th percentile | 2005 |
Q1 | 2008 |
median | 2011 |
Q3 | 2013 |
95-th percentile | 2014 |
Maximum | 2015 |
Range | 28 |
Interquartile range (IQR) | 5 |
Descriptive statistics
Standard deviation | 3.2613915 |
---|---|
Coefficient of variation (CV) | 0.0016224009 |
Kurtosis | 0.60808446 |
Mean | 2010.2254 |
Median Absolute Deviation (MAD) | 2 |
Skewness | -0.79448656 |
Sum | 2.0104224 × 109 |
Variance | 10.636674 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2014 | 155889 | |
2012 | 130884 | |
2013 | 117064 | |
2008 | 106008 | |
2010 | 95579 | |
2011 | 88765 | |
2007 | 82514 | |
2009 | 72168 | |
2006 | 45111 | 4.5% |
2005 | 30901 | 3.1% |
Other values (15) | 75215 |
Value | Count | Frequency (%) |
1987 | 3 | < 0.1% |
1988 | 1 | < 0.1% |
1992 | 1 | < 0.1% |
1994 | 52 | < 0.1% |
1995 | 446 | < 0.1% |
1996 | 867 | |
1997 | 1045 | |
1998 | 1465 | |
1999 | 1862 | |
2000 | 1740 |
Value | Count | Frequency (%) |
2015 | 27589 | 2.8% |
2014 | 155889 | |
2013 | 117064 | |
2012 | 130884 | |
2011 | 88765 | |
2010 | 95579 | |
2009 | 72168 | |
2008 | 106008 | |
2007 | 82514 | |
2006 | 45111 | 4.5% |
make
Categorical
High correlation  Imbalance 
Distinct | 46 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Memory size | 7.6 MiB |
TOYOTA | |
---|---|
MERCEDES-BENZ | 41940 |
CMC | 21624 |
VOLKSWAGEN | 20929 |
C.A.M | 16171 |
Other values (41) |
Length
Max length | 35 |
---|---|
Median length | 6 |
Mean length | 6.8664734 |
Min length | 3 |
Unique
Unique | 1 ? |
---|---|
Unique (%) | < 0.1% |
Sample
1st row | MERCEDES-BENZ |
---|---|
2nd row | MERCEDES-BENZ |
3rd row | MERCEDES-BENZ |
4th row | MERCEDES-BENZ |
5th row | MERCEDES-BENZ |
Common Values
Value | Count | Frequency (%) |
TOYOTA | 813280 | |
MERCEDES-BENZ | 41940 | 4.2% |
CMC | 21624 | 2.2% |
VOLKSWAGEN | 20929 | 2.1% |
C.A.M | 16171 | 1.6% |
GOLDEN JOURNEY | 14462 | 1.4% |
NISSAN/DATSUN | 10997 | 1.1% |
JINBEI | 10374 | 1.0% |
IVECO | 8430 | 0.8% |
AUDI | 7407 | 0.7% |
Other values (36) | 33932 | 3.4% |
Length
Value | Count | Frequency (%) |
toyota | 814446 | |
mercedes-benz | 45071 | 4.4% |
cmc | 21624 | 2.1% |
volkswagen | 20929 | 2.1% |
c.a.m | 16171 | 1.6% |
golden | 14462 | 1.4% |
journey | 14462 | 1.4% |
nissan/datsun | 10997 | 1.1% |
jinbei | 10434 | 1.0% |
iveco | 8430 | 0.8% |
Other values (33) | 36982 | 3.6% |
Most occurring characters
Value | Count | Frequency (%) |
O | 1699378 | |
T | 1647668 | |
A | 896572 | |
Y | 831979 | |
413784 | 6.0% | |
E | 254722 | 3.7% |
N | 157922 | 2.3% |
C | 115881 | 1.7% |
S | 113070 | 1.6% |
M | 91422 | 1.3% |
Other values (19) | 640958 | 9.3% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 6863356 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
O | 1699378 | |
T | 1647668 | |
A | 896572 | |
Y | 831979 | |
413784 | 6.0% | |
E | 254722 | 3.7% |
N | 157922 | 2.3% |
C | 115881 | 1.7% |
S | 113070 | 1.6% |
M | 91422 | 1.3% |
Other values (19) | 640958 | 9.3% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 6863356 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
O | 1699378 | |
T | 1647668 | |
A | 896572 | |
Y | 831979 | |
413784 | 6.0% | |
E | 254722 | 3.7% |
N | 157922 | 2.3% |
C | 115881 | 1.7% |
S | 113070 | 1.6% |
M | 91422 | 1.3% |
Other values (19) | 640958 | 9.3% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 6863356 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
O | 1699378 | |
T | 1647668 | |
A | 896572 | |
Y | 831979 | |
413784 | 6.0% | |
E | 254722 | 3.7% |
N | 157922 | 2.3% |
C | 115881 | 1.7% |
S | 113070 | 1.6% |
M | 91422 | 1.3% |
Other values (19) | 640958 | 9.3% |
Model
Text
Distinct | 411 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Memory size | 7.6 MiB |
Length
Max length | 41 |
---|---|
Median length | 39 |
Mean length | 23.211208 |
Min length | 4 |
Unique
Unique | 57 ? |
---|---|
Unique (%) | < 0.1% |
Sample
1st row | E 240 |
---|---|
2nd row | E 240 |
3rd row | E 240 |
4th row | E 240 |
5th row | E 240 |
Value | Count | Frequency (%) |
quantum | 637134 | |
sesfikile | 600833 | |
2.7 | 499411 | |
16s | 289064 | 7.2% |
15s | 178421 | 4.5% |
2.5 | 151678 | 3.8% |
d-4d | 140358 | 3.5% |
14s | 137242 | 3.4% |
hiace | 121354 | 3.0% |
16 | 99332 | 2.5% |
Other values (492) | 1152240 |
Most occurring characters
Value | Count | Frequency (%) |
3014522 | 13.0% | |
E | 1606483 | 6.9% |
S | 1533773 | 6.6% |
I | 1466322 | 6.3% |
U | 1400219 | 6.0% |
A | 1188405 | 5.1% |
1 | 877516 | 3.8% |
T | 845207 | 3.6% |
F | 798309 | 3.4% |
N | 798175 | 3.4% |
Other values (48) | 9671739 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 23200670 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
3014522 | 13.0% | |
E | 1606483 | 6.9% |
S | 1533773 | 6.6% |
I | 1466322 | 6.3% |
U | 1400219 | 6.0% |
A | 1188405 | 5.1% |
1 | 877516 | 3.8% |
T | 845207 | 3.6% |
F | 798309 | 3.4% |
N | 798175 | 3.4% |
Other values (48) | 9671739 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 23200670 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
3014522 | 13.0% | |
E | 1606483 | 6.9% |
S | 1533773 | 6.6% |
I | 1466322 | 6.3% |
U | 1400219 | 6.0% |
A | 1188405 | 5.1% |
1 | 877516 | 3.8% |
T | 845207 | 3.6% |
F | 798309 | 3.4% |
N | 798175 | 3.4% |
Other values (48) | 9671739 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 23200670 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
3014522 | 13.0% | |
E | 1606483 | 6.9% |
S | 1533773 | 6.6% |
I | 1466322 | 6.3% |
U | 1400219 | 6.0% |
A | 1188405 | 5.1% |
1 | 877516 | 3.8% |
T | 845207 | 3.6% |
F | 798309 | 3.4% |
N | 798175 | 3.4% |
Other values (48) | 9671739 |
Cylinders
Real number (ℝ)
High correlation 
Distinct | 7 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4.0466422 |
Minimum | 0 |
---|---|
Maximum | 10 |
Zeros | 338 |
Zeros (%) | < 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 4 |
Q1 | 4 |
median | 4 |
Q3 | 4 |
95-th percentile | 4 |
Maximum | 10 |
Range | 10 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 0.29402012 |
---|---|
Coefficient of variation (CV) | 0.0726578 |
Kurtosis | 71.285271 |
Mean | 4.0466422 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 5.7046352 |
Sum | 4044805 |
Variance | 0.086447829 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4 | 965284 | |
5 | 20947 | 2.1% |
6 | 11982 | 1.2% |
8 | 698 | 0.1% |
0 | 338 | < 0.1% |
3 | 216 | < 0.1% |
10 | 81 | < 0.1% |
(Missing) | 552 | 0.1% |
Value | Count | Frequency (%) |
0 | 338 | < 0.1% |
3 | 216 | < 0.1% |
4 | 965284 | |
5 | 20947 | 2.1% |
6 | 11982 | 1.2% |
8 | 698 | 0.1% |
10 | 81 | < 0.1% |
Value | Count | Frequency (%) |
10 | 81 | < 0.1% |
8 | 698 | 0.1% |
6 | 11982 | 1.2% |
5 | 20947 | 2.1% |
4 | 965284 | |
3 | 216 | < 0.1% |
0 | 338 | < 0.1% |
cubiccapacity
Real number (ℝ)
High correlation 
Distinct | 122 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 2466.7433 |
Minimum | 0 |
---|---|
Maximum | 12880 |
Zeros | 3323 |
Zeros (%) | 0.3% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1495 |
Q1 | 2237 |
median | 2694 |
Q3 | 2694 |
95-th percentile | 2694 |
Maximum | 12880 |
Range | 12880 |
Interquartile range (IQR) | 457 |
Descriptive statistics
Standard deviation | 442.80064 |
---|---|
Coefficient of variation (CV) | 0.1795082 |
Kurtosis | 102.2898 |
Mean | 2466.7433 |
Median Absolute Deviation (MAD) | 6 |
Skewness | 3.5760249 |
Sum | 2.4656234 × 109 |
Variance | 196072.41 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
2694 | 497056 | |
2237 | 177976 | 17.8% |
2494 | 140287 | 14.0% |
1495 | 18693 | 1.9% |
2148 | 14722 | 1.5% |
1330 | 12507 | 1.3% |
2488 | 10805 | 1.1% |
1298 | 10185 | 1.0% |
2987 | 10067 | 1.0% |
2700 | 9917 | 1.0% |
Other values (112) | 97331 | 9.7% |
Value | Count | Frequency (%) |
0 | 3323 | 0.3% |
996 | 216 | < 0.1% |
1149 | 99 | < 0.1% |
1197 | 1 | < 0.1% |
1248 | 108 | < 0.1% |
1296 | 2729 | 0.3% |
1297 | 90 | < 0.1% |
1298 | 10185 | |
1323 | 120 | < 0.1% |
1329 | 57 | < 0.1% |
Value | Count | Frequency (%) |
12880 | 182 | < 0.1% |
11412 | 216 | < 0.1% |
7961 | 242 | < 0.1% |
5958 | 1 | < 0.1% |
5833 | 80 | < 0.1% |
5675 | 300 | |
5328 | 698 | |
4921 | 81 | < 0.1% |
4300 | 51 | < 0.1% |
4250 | 108 | < 0.1% |
kilowatts
Real number (ℝ)
High correlation 
Distinct | 82 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 97.207919 |
Minimum | 0 |
---|---|
Maximum | 309 |
Zeros | 328 |
Zeros (%) | < 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 75 |
Q1 | 75 |
median | 111 |
Q3 | 111 |
95-th percentile | 111 |
Maximum | 309 |
Range | 309 |
Interquartile range (IQR) | 36 |
Descriptive statistics
Standard deviation | 19.393256 |
---|---|
Coefficient of variation (CV) | 0.19950284 |
Kurtosis | 3.0099924 |
Mean | 97.207919 |
Median Absolute Deviation (MAD) | 1 |
Skewness | 0.24471889 |
Sum | 97163787 |
Variance | 376.09836 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
111 | 496946 | |
75 | 261777 | |
76 | 67185 | 6.7% |
80 | 19782 | 2.0% |
110 | 18505 | 1.9% |
115 | 13919 | 1.4% |
74 | 13253 | 1.3% |
108 | 11084 | 1.1% |
67 | 9856 | 1.0% |
102 | 7273 | 0.7% |
Other values (72) | 79966 | 8.0% |
Value | Count | Frequency (%) |
0 | 328 | < 0.1% |
47 | 401 | < 0.1% |
50 | 120 | < 0.1% |
51 | 216 | < 0.1% |
52 | 1 | < 0.1% |
55 | 2918 | |
58 | 97 | < 0.1% |
59 | 2 | < 0.1% |
60 | 1754 | |
61 | 207 | < 0.1% |
Value | Count | Frequency (%) |
309 | 182 | < 0.1% |
230 | 81 | < 0.1% |
228 | 9 | < 0.1% |
224 | 698 | |
200 | 73 | < 0.1% |
190 | 9 | < 0.1% |
182 | 99 | < 0.1% |
180 | 587 | |
176 | 108 | < 0.1% |
173 | 1 | < 0.1% |
bodytype
Categorical
High correlation  Imbalance 
Distinct | 13 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Memory size | 7.6 MiB |
B/S | |
---|---|
P/V | 55034 |
S/D | 41868 |
MPV | 33842 |
C/C | 8861 |
Other values (8) | 15541 |
Length
Max length | 3 |
---|---|
Median length | 3 |
Mean length | 3 |
Min length | 3 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | S/D |
---|---|
2nd row | S/D |
3rd row | S/D |
4th row | S/D |
5th row | S/D |
Common Values
Value | Count | Frequency (%) |
B/S | 844400 | |
P/V | 55034 | 5.5% |
S/D | 41868 | 4.2% |
MPV | 33842 | 3.4% |
C/C | 8861 | 0.9% |
H/B | 8400 | 0.8% |
S/W | 3100 | 0.3% |
SUV | 2049 | 0.2% |
S/C | 880 | 0.1% |
C/P | 644 | 0.1% |
Other values (3) | 468 | < 0.1% |
(Missing) | 552 | 0.1% |
Length
Value | Count | Frequency (%) |
b/s | 844400 | |
p/v | 55034 | 5.5% |
s/d | 41868 | 4.2% |
mpv | 33842 | 3.4% |
c/c | 8861 | 0.9% |
h/b | 8400 | 0.8% |
s/w | 3100 | 0.3% |
suv | 2049 | 0.2% |
s/c | 880 | 0.1% |
c/p | 644 | 0.1% |
Other values (3) | 468 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
/ | 963439 | |
S | 892417 | |
B | 852800 | |
V | 90925 | 3.0% |
P | 89520 | 3.0% |
D | 42120 | 1.4% |
M | 33842 | 1.1% |
C | 19810 | 0.7% |
H | 8400 | 0.3% |
W | 3100 | 0.1% |
Other values (2) | 2265 | 0.1% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 2998638 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
/ | 963439 | |
S | 892417 | |
B | 852800 | |
V | 90925 | 3.0% |
P | 89520 | 3.0% |
D | 42120 | 1.4% |
M | 33842 | 1.1% |
C | 19810 | 0.7% |
H | 8400 | 0.3% |
W | 3100 | 0.1% |
Other values (2) | 2265 | 0.1% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 2998638 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
/ | 963439 | |
S | 892417 | |
B | 852800 | |
V | 90925 | 3.0% |
P | 89520 | 3.0% |
D | 42120 | 1.4% |
M | 33842 | 1.1% |
C | 19810 | 0.7% |
H | 8400 | 0.3% |
W | 3100 | 0.1% |
Other values (2) | 2265 | 0.1% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 2998638 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
/ | 963439 | |
S | 892417 | |
B | 852800 | |
V | 90925 | 3.0% |
P | 89520 | 3.0% |
D | 42120 | 1.4% |
M | 33842 | 1.1% |
C | 19810 | 0.7% |
H | 8400 | 0.3% |
W | 3100 | 0.1% |
Other values (2) | 2265 | 0.1% |
NumberOfDoors
Real number (ℝ)
High correlation 
Distinct | 6 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 4.0192497 |
Minimum | 0 |
---|---|
Maximum | 6 |
Zeros | 1995 |
Zeros (%) | 0.2% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 4 |
Q1 | 4 |
median | 4 |
Q3 | 4 |
95-th percentile | 5 |
Maximum | 6 |
Range | 6 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 0.46831443 |
---|---|
Coefficient of variation (CV) | 0.11651787 |
Kurtosis | 18.833823 |
Mean | 4.0192497 |
Median Absolute Deviation (MAD) | 0 |
Skewness | -2.5313282 |
Sum | 4017425 |
Variance | 0.21931841 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
4 | 892838 | |
5 | 76599 | 7.7% |
2 | 26055 | 2.6% |
0 | 1995 | 0.2% |
6 | 1597 | 0.2% |
3 | 462 | < 0.1% |
(Missing) | 552 | 0.1% |
Value | Count | Frequency (%) |
0 | 1995 | 0.2% |
2 | 26055 | 2.6% |
3 | 462 | < 0.1% |
4 | 892838 | |
5 | 76599 | 7.7% |
6 | 1597 | 0.2% |
Value | Count | Frequency (%) |
6 | 1597 | 0.2% |
5 | 76599 | 7.7% |
4 | 892838 | |
3 | 462 | < 0.1% |
2 | 26055 | 2.6% |
0 | 1995 | 0.2% |
VehicleIntroDate
Date
Distinct | 160 |
---|---|
Distinct (%) | < 0.1% |
Missing | 552 |
Missing (%) | 0.1% |
Memory size | 7.6 MiB |
Minimum | 1977-10-01 00:00:00 |
---|---|
Maximum | 2014-09-01 00:00:00 |
Invalid dates | 0 |
Invalid dates (%) | 0.0% |
CustomValueEstimate
Real number (ℝ)
High correlation  Missing  Skewed 
Distinct | 923 |
---|---|
Distinct (%) | 0.4% |
Missing | 779642 |
Missing (%) | 78.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 225531.13 |
Minimum | 20000 |
---|---|
Maximum | 26550000 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 20000 |
---|---|
5-th percentile | 58300 |
Q1 | 135000 |
median | 220000 |
Q3 | 280000 |
95-th percentile | 360000 |
Maximum | 26550000 |
Range | 26530000 |
Interquartile range (IQR) | 145000 |
Descriptive statistics
Standard deviation | 564515.75 |
---|---|
Coefficient of variation (CV) | 2.5030502 |
Kurtosis | 1762.3216 |
Mean | 225531.13 |
Median Absolute Deviation (MAD) | 79600 |
Skewness | 40.870518 |
Sum | 4.9719691 × 1010 |
Variance | 3.1867803 × 1011 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
250000 | 4401 | 0.4% |
280000 | 4398 | 0.4% |
140000 | 4311 | 0.4% |
200000 | 3937 | 0.4% |
293300 | 3646 | 0.4% |
256900 | 3499 | 0.3% |
135600 | 3439 | 0.3% |
80000 | 3416 | 0.3% |
241200 | 2966 | 0.3% |
220000 | 2576 | 0.3% |
Other values (913) | 183867 | 18.4% |
(Missing) | 779642 |
Value | Count | Frequency (%) |
20000 | 72 | < 0.1% |
23100 | 88 | < 0.1% |
24000 | 38 | < 0.1% |
27100 | 32 | < 0.1% |
30000 | 234 | |
32000 | 117 | < 0.1% |
34000 | 94 | < 0.1% |
35000 | 456 | |
35200 | 104 | < 0.1% |
36800 | 20 | < 0.1% |
Value | Count | Frequency (%) |
26550000 | 66 | < 0.1% |
19000000 | 63 | < 0.1% |
715712 | 198 | |
691000 | 70 | < 0.1% |
654000 | 33 | < 0.1% |
647292 | 197 | |
637000 | 40 | < 0.1% |
626084 | 72 | < 0.1% |
625000 | 33 | < 0.1% |
615000 | 88 |
AlarmImmobiliser
Boolean
Imbalance 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 976.8 KiB |
True | |
---|---|
False | 237 |
Value | Count | Frequency (%) |
True | 999861 | |
False | 237 | < 0.1% |
TrackingDevice
Boolean
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 976.8 KiB |
False | |
---|---|
True |
Value | Count | Frequency (%) |
False | 656617 | |
True | 343481 |
CapitalOutstanding
Unsupported
Rejected  Unsupported 
Missing | 2 |
---|---|
Missing (%) | < 0.1% |
Memory size | 7.6 MiB |
NewVehicle
Categorical
Imbalance  Missing 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 153295 |
Missing (%) | 15.3% |
Memory size | 7.6 MiB |
More than 6 months | |
---|---|
Less than 6 months | 1580 |
Length
Max length | 18 |
---|---|
Median length | 18 |
Mean length | 18 |
Min length | 18 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | More than 6 months |
---|---|
2nd row | More than 6 months |
3rd row | More than 6 months |
4th row | More than 6 months |
5th row | More than 6 months |
Common Values
Value | Count | Frequency (%) |
More than 6 months | 845223 | |
Less than 6 months | 1580 | 0.2% |
(Missing) | 153295 | 15.3% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
than | 846803 | |
months | 846803 | |
6 | 846803 | |
more | 845223 | |
less | 1580 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
2540409 | ||
h | 1693606 | |
n | 1693606 | |
t | 1693606 | |
o | 1692026 | |
s | 849963 | 5.6% |
a | 846803 | 5.6% |
e | 846803 | 5.6% |
6 | 846803 | 5.6% |
m | 846803 | 5.6% |
Other values (3) | 1692026 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 15242454 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
2540409 | ||
h | 1693606 | |
n | 1693606 | |
t | 1693606 | |
o | 1692026 | |
s | 849963 | 5.6% |
a | 846803 | 5.6% |
e | 846803 | 5.6% |
6 | 846803 | 5.6% |
m | 846803 | 5.6% |
Other values (3) | 1692026 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 15242454 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
2540409 | ||
h | 1693606 | |
n | 1693606 | |
t | 1693606 | |
o | 1692026 | |
s | 849963 | 5.6% |
a | 846803 | 5.6% |
e | 846803 | 5.6% |
6 | 846803 | 5.6% |
m | 846803 | 5.6% |
Other values (3) | 1692026 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 15242454 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
2540409 | ||
h | 1693606 | |
n | 1693606 | |
t | 1693606 | |
o | 1692026 | |
s | 849963 | 5.6% |
a | 846803 | 5.6% |
e | 846803 | 5.6% |
6 | 846803 | 5.6% |
m | 846803 | 5.6% |
Other values (3) | 1692026 |
WrittenOff
Boolean
High correlation  Imbalance  Missing 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 641901 |
Missing (%) | 64.2% |
Memory size | 1.9 MiB |
False | |
---|---|
True | 32 |
(Missing) |
Value | Count | Frequency (%) |
False | 358165 | |
True | 32 | < 0.1% |
(Missing) | 641901 |
Rebuilt
Boolean
High correlation  Imbalance  Missing 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 641901 |
Missing (%) | 64.2% |
Memory size | 1.9 MiB |
False | |
---|---|
True | 32 |
(Missing) |
Value | Count | Frequency (%) |
False | 358165 | |
True | 32 | < 0.1% |
(Missing) | 641901 |
Converted
Boolean
High correlation  Imbalance  Missing 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 641901 |
Missing (%) | 64.2% |
Memory size | 1.9 MiB |
False | |
---|---|
True | 87 |
(Missing) |
Value | Count | Frequency (%) |
False | 358110 | |
True | 87 | < 0.1% |
(Missing) | 641901 |
CrossBorder
Boolean
Constant  Missing 
Distinct | 1 |
---|---|
Distinct (%) | 0.1% |
Missing | 999400 |
Missing (%) | 99.9% |
Memory size | 1.9 MiB |
False | 698 |
---|---|
(Missing) |
Value | Count | Frequency (%) |
False | 698 | 0.1% |
(Missing) | 999400 |
NumberOfVehiclesInFleet
Unsupported
Missing  Rejected  Unsupported 
Missing | 1000098 |
---|---|
Missing (%) | 100.0% |
Memory size | 7.6 MiB |
SumInsured
Real number (ℝ)
High correlation 
Distinct | 2186 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 604172.73 |
Minimum | 0.01 |
---|---|
Maximum | 12636200 |
Zeros | 0 |
Zeros (%) | 0.0% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0.01 |
---|---|
5-th percentile | 0.01 |
Q1 | 5000 |
median | 7500 |
Q3 | 250000 |
95-th percentile | 5000000 |
Maximum | 12636200 |
Range | 12636200 |
Interquartile range (IQR) | 245000 |
Descriptive statistics
Standard deviation | 1508331.8 |
---|---|
Coefficient of variation (CV) | 2.4965242 |
Kurtosis | 4.6451688 |
Mean | 604172.73 |
Median Absolute Deviation (MAD) | 4000 |
Skewness | 2.5485649 |
Sum | 6.0423194 × 1011 |
Variance | 2.2750649 × 1012 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
7500 | 262599 | |
0.01 | 107597 | |
5000000 | 104042 | 10.4% |
500000 | 102921 | 10.3% |
5000 | 102508 | 10.2% |
3500 | 102416 | 10.2% |
7000 | 64837 | 6.5% |
100000 | 23214 | 2.3% |
50000 | 6733 | 0.7% |
200000 | 2150 | 0.2% |
Other values (2176) | 121081 |
Value | Count | Frequency (%) |
0.01 | 107597 | |
1000 | 10 | < 0.1% |
1500 | 281 | < 0.1% |
3500 | 102416 | 10.2% |
5000 | 102508 | 10.2% |
7000 | 64837 | 6.5% |
7500 | 262599 | |
10000 | 655 | 0.1% |
16300 | 12 | < 0.1% |
17900 | 25 | < 0.1% |
Value | Count | Frequency (%) |
12636200 | 9 | < 0.1% |
12438200 | 10 | < 0.1% |
10000000 | 32 | < 0.1% |
5000000 | 104042 | |
4883300 | 10 | < 0.1% |
1500000 | 63 | < 0.1% |
715712 | 18 | < 0.1% |
689608 | 6 | < 0.1% |
675000 | 10 | < 0.1% |
670000 | 24 | < 0.1% |
TermFrequency
Categorical
High correlation  Imbalance 
Distinct | 2 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Monthly | |
---|---|
Annual | 544 |
Length
Max length | 7 |
---|---|
Median length | 7 |
Mean length | 6.9994561 |
Min length | 6 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Monthly |
---|---|
2nd row | Monthly |
3rd row | Monthly |
4th row | Monthly |
5th row | Monthly |
Common Values
Value | Count | Frequency (%) |
Monthly | 999554 | |
Annual | 544 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
monthly | 999554 | |
annual | 544 | 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
n | 1000642 | |
l | 1000098 | |
o | 999554 | |
M | 999554 | |
t | 999554 | |
h | 999554 | |
y | 999554 | |
A | 544 | < 0.1% |
u | 544 | < 0.1% |
a | 544 | < 0.1% |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 7000142 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
n | 1000642 | |
l | 1000098 | |
o | 999554 | |
M | 999554 | |
t | 999554 | |
h | 999554 | |
y | 999554 | |
A | 544 | < 0.1% |
u | 544 | < 0.1% |
a | 544 | < 0.1% |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 7000142 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
n | 1000642 | |
l | 1000098 | |
o | 999554 | |
M | 999554 | |
t | 999554 | |
h | 999554 | |
y | 999554 | |
A | 544 | < 0.1% |
u | 544 | < 0.1% |
a | 544 | < 0.1% |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 7000142 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
n | 1000642 | |
l | 1000098 | |
o | 999554 | |
M | 999554 | |
t | 999554 | |
h | 999554 | |
y | 999554 | |
A | 544 | < 0.1% |
u | 544 | < 0.1% |
a | 544 | < 0.1% |
CalculatedPremiumPerTerm
Real number (ℝ)
High correlation  Skewed 
Distinct | 19869 |
---|---|
Distinct (%) | 2.0% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 117.87569 |
Minimum | 0 |
---|---|
Maximum | 74422.168 |
Zeros | 7 |
Zeros (%) | < 0.1% |
Negative | 0 |
Negative (%) | 0.0% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | 0 |
---|---|
5-th percentile | 1.4339 |
Q1 | 3.2248 |
median | 8.4369 |
Q3 | 90 |
95-th percentile | 675.9028 |
Maximum | 74422.168 |
Range | 74422.168 |
Interquartile range (IQR) | 86.7752 |
Descriptive statistics
Standard deviation | 399.70172 |
---|---|
Coefficient of variation (CV) | 3.3908749 |
Kurtosis | 22210.702 |
Mean | 117.87569 |
Median Absolute Deviation (MAD) | 7.4572 |
Skewness | 122.97458 |
Sum | 1.1788724 × 108 |
Variance | 159761.47 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
25 | 81499 | 8.1% |
85 | 59987 | 6.0% |
90 | 53581 | 5.4% |
50 | 27508 | 2.8% |
18 | 25188 | 2.5% |
105 | 4812 | 0.5% |
110 | 4363 | 0.4% |
5.5109 | 3924 | 0.4% |
4.0413 | 3646 | 0.4% |
1.837 | 3558 | 0.4% |
Other values (19859) | 732032 |
Value | Count | Frequency (%) |
0 | 7 | < 0.1% |
0.0002 | 269 | |
0.0004 | 227 | |
0.0005 | 122 | < 0.1% |
0.0006 | 334 | |
0.0007 | 124 | < 0.1% |
0.0257 | 22 | < 0.1% |
0.0271 | 20 | < 0.1% |
0.0273 | 20 | < 0.1% |
0.0276 | 12 | < 0.1% |
Value | Count | Frequency (%) |
74422.1679 | 9 | |
73291.8087 | 10 | |
27899.6347 | 10 | |
3158.3967 | 9 | |
3110.4255 | 10 | |
3051.8211 | 7 | |
2568.9983 | 10 | |
2561.8622 | 12 | |
2383.4576 | 7 | |
2253.0115 | 12 |
ExcessSelected
Categorical
High correlation  Imbalance 
Distinct | 13 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
No excess | |
---|---|
Mobility - Windscreen | |
Mobility - Taxi with value more than R100 000 - R5 000 | 76424 |
Mobility - Taxi with value less than R100 000 - R3 000 | 15249 |
Mobility - Metered Taxis - R2000 | 6999 |
Other values (8) | 12878 |
Length
Max length | 62 |
---|---|
Median length | 9 |
Mean length | 14.851594 |
Min length | 9 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Mobility - Windscreen |
---|---|
2nd row | Mobility - Windscreen |
3rd row | Mobility - Windscreen |
4th row | Mobility - Metered Taxis - R2000 |
5th row | Mobility - Metered Taxis - R2000 |
Common Values
Value | Count | Frequency (%) |
No excess | 791235 | |
Mobility - Windscreen | 97313 | 9.7% |
Mobility - Taxi with value more than R100 000 - R5 000 | 76424 | 7.6% |
Mobility - Taxi with value less than R100 000 - R3 000 | 15249 | 1.5% |
Mobility - Metered Taxis - R2000 | 6999 | 0.7% |
Mobility - Windscreen (Feb2015) | 6450 | 0.6% |
Mobility - Taxi with value more than R100 000 - R5 000 (April) | 3022 | 0.3% |
Mobility - Metered Taxis - R5000 | 1704 | 0.2% |
Mobility - Taxi with value more than R100 000 - R10 000 | 1108 | 0.1% |
Mobility - R250 | 463 | < 0.1% |
Other values (3) | 131 | < 0.1% |
Length
Value | Count | Frequency (%) |
no | 791235 | |
excess | 791235 | |
313421 | 10.1% | |
mobility | 208863 | 6.7% |
000 | 191658 | 6.2% |
windscreen | 103763 | 3.3% |
with | 95855 | 3.1% |
taxi | 95855 | 3.1% |
value | 95855 | 3.1% |
than | 95855 | 3.1% |
Other values (18) | 323743 |
Most occurring characters
Value | Count | Frequency (%) |
2107240 | ||
e | 2014341 | |
s | 1725510 | |
o | 1080710 | 7.3% |
x | 895793 | 6.0% |
c | 895001 | 6.0% |
0 | 800918 | 5.4% |
N | 791235 | 5.3% |
i | 725000 | 4.9% |
t | 409279 | 2.8% |
Other values (28) | 3408022 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 14853049 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
2107240 | ||
e | 2014341 | |
s | 1725510 | |
o | 1080710 | 7.3% |
x | 895793 | 6.0% |
c | 895001 | 6.0% |
0 | 800918 | 5.4% |
N | 791235 | 5.3% |
i | 725000 | 4.9% |
t | 409279 | 2.8% |
Other values (28) | 3408022 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 14853049 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
2107240 | ||
e | 2014341 | |
s | 1725510 | |
o | 1080710 | 7.3% |
x | 895793 | 6.0% |
c | 895001 | 6.0% |
0 | 800918 | 5.4% |
N | 791235 | 5.3% |
i | 725000 | 4.9% |
t | 409279 | 2.8% |
Other values (28) | 3408022 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 14853049 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
2107240 | ||
e | 2014341 | |
s | 1725510 | |
o | 1080710 | 7.3% |
x | 895793 | 6.0% |
c | 895001 | 6.0% |
0 | 800918 | 5.4% |
N | 791235 | 5.3% |
i | 725000 | 4.9% |
t | 409279 | 2.8% |
Other values (28) | 3408022 |
CoverCategory
Categorical
High correlation 
Distinct | 28 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Passenger Liability | |
---|---|
Third Party | |
Keys and Alarms | |
Signage and Vehicle Wraps | |
Emergency Charges | |
Other values (23) |
Length
Max length | 51 |
---|---|
Median length | 26 |
Mean length | 18.254392 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Windscreen |
---|---|
2nd row | Windscreen |
3rd row | Windscreen |
4th row | Own damage |
5th row | Own damage |
Common Values
Value | Count | Frequency (%) |
Passenger Liability | 104158 | |
Third Party | 102825 | |
Keys and Alarms | 102428 | |
Signage and Vehicle Wraps | 102416 | |
Emergency Charges | 102416 | |
Cleaning and Removal of Accident Debris | 102414 | |
Windscreen | 97313 | |
Own Damage | 78981 | |
Income Protector | 60001 | |
Basic Excess Waiver | 53755 | |
Other values (18) | 93391 |
Length
Value | Count | Frequency (%) |
and | 307261 | 11.4% |
liability | 104702 | 3.9% |
passenger | 104702 | 3.9% |
vehicle | 104122 | 3.9% |
windscreen | 103763 | 3.9% |
third | 102888 | 3.8% |
party | 102888 | 3.8% |
damage | 102852 | 3.8% |
own | 102852 | 3.8% |
keys | 102428 | 3.8% |
Other values (43) | 1452587 |
Most occurring characters
Value | Count | Frequency (%) |
e | 2002993 | 11.0% |
1769928 | 9.7% | |
a | 1620739 | 8.9% |
n | 1350058 | 7.4% |
i | 1222879 | 6.7% |
r | 1155627 | 6.3% |
s | 1018388 | 5.6% |
c | 836848 | 4.6% |
g | 720955 | 3.9% |
d | 678865 | 3.7% |
Other values (39) | 5878901 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 18256181 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 2002993 | 11.0% |
1769928 | 9.7% | |
a | 1620739 | 8.9% |
n | 1350058 | 7.4% |
i | 1222879 | 6.7% |
r | 1155627 | 6.3% |
s | 1018388 | 5.6% |
c | 836848 | 4.6% |
g | 720955 | 3.9% |
d | 678865 | 3.7% |
Other values (39) | 5878901 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 18256181 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 2002993 | 11.0% |
1769928 | 9.7% | |
a | 1620739 | 8.9% |
n | 1350058 | 7.4% |
i | 1222879 | 6.7% |
r | 1155627 | 6.3% |
s | 1018388 | 5.6% |
c | 836848 | 4.6% |
g | 720955 | 3.9% |
d | 678865 | 3.7% |
Other values (39) | 5878901 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 18256181 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 2002993 | 11.0% |
1769928 | 9.7% | |
a | 1620739 | 8.9% |
n | 1350058 | 7.4% |
i | 1222879 | 6.7% |
r | 1155627 | 6.3% |
s | 1018388 | 5.6% |
c | 836848 | 4.6% |
g | 720955 | 3.9% |
d | 678865 | 3.7% |
Other values (39) | 5878901 |
CoverType
Categorical
High correlation 
Distinct | 22 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Own Damage | |
---|---|
Passenger Liability | |
Windscreen | |
Third Party | |
Keys and Alarms | |
Other values (17) |
Length
Max length | 51 |
---|---|
Median length | 25 |
Mean length | 18.035985 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Windscreen |
---|---|
2nd row | Windscreen |
3rd row | Windscreen |
4th row | Own Damage |
5th row | Own Damage |
Common Values
Value | Count | Frequency (%) |
Own Damage | 104183 | |
Passenger Liability | 104158 | |
Windscreen | 103763 | |
Third Party | 102825 | |
Keys and Alarms | 102428 | |
Signage and Vehicle Wraps | 102416 | |
Emergency Charges | 102416 | |
Cleaning and Removal of Accident Debris | 102414 | |
Income Protector | 64813 | |
Basic Excess Waiver | 57769 | |
Other values (12) | 52913 |
Length
Value | Count | Frequency (%) |
and | 307636 | 11.5% |
passenger | 104702 | 3.9% |
liability | 104702 | 3.9% |
own | 104183 | 3.9% |
damage | 104183 | 3.9% |
windscreen | 103763 | 3.9% |
third | 102888 | 3.8% |
party | 102888 | 3.8% |
keys | 102428 | 3.8% |
alarms | 102428 | 3.8% |
Other values (40) | 1432931 |
Most occurring characters
Value | Count | Frequency (%) |
e | 1999956 | 11.1% |
1672634 | 9.3% | |
a | 1623776 | 9.0% |
n | 1351610 | 7.5% |
i | 1221548 | 6.8% |
r | 1154296 | 6.4% |
s | 1018388 | 5.6% |
c | 835142 | 4.6% |
g | 722286 | 4.0% |
d | 670310 | 3.7% |
Other values (32) | 5767807 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 18037753 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 1999956 | 11.1% |
1672634 | 9.3% | |
a | 1623776 | 9.0% |
n | 1351610 | 7.5% |
i | 1221548 | 6.8% |
r | 1154296 | 6.4% |
s | 1018388 | 5.6% |
c | 835142 | 4.6% |
g | 722286 | 4.0% |
d | 670310 | 3.7% |
Other values (32) | 5767807 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 18037753 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 1999956 | 11.1% |
1672634 | 9.3% | |
a | 1623776 | 9.0% |
n | 1351610 | 7.5% |
i | 1221548 | 6.8% |
r | 1154296 | 6.4% |
s | 1018388 | 5.6% |
c | 835142 | 4.6% |
g | 722286 | 4.0% |
d | 670310 | 3.7% |
Other values (32) | 5767807 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 18037753 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 1999956 | 11.1% |
1672634 | 9.3% | |
a | 1623776 | 9.0% |
n | 1351610 | 7.5% |
i | 1221548 | 6.8% |
r | 1154296 | 6.4% |
s | 1018388 | 5.6% |
c | 835142 | 4.6% |
g | 722286 | 4.0% |
d | 670310 | 3.7% |
Other values (32) | 5767807 |
CoverGroup
Categorical
High correlation  Imbalance 
Distinct | 14 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Comprehensive - Taxi | |
---|---|
Income Protector | 64813 |
Basic Excess Waiver | 57769 |
Accidental Death | 27321 |
Credit Protection | 18070 |
Other values (9) | 8001 |
Length
Max length | 30 |
---|---|
Median length | 20 |
Mean length | 19.512876 |
Min length | 7 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Comprehensive - Taxi |
---|---|
2nd row | Comprehensive - Taxi |
3rd row | Comprehensive - Taxi |
4th row | Comprehensive - Taxi |
5th row | Comprehensive - Taxi |
Common Values
Value | Count | Frequency (%) |
Comprehensive - Taxi | 824124 | |
Income Protector | 64813 | 6.5% |
Basic Excess Waiver | 57769 | 5.8% |
Accidental Death | 27321 | 2.7% |
Credit Protection | 18070 | 1.8% |
Motor Comprehensive | 3941 | 0.4% |
Deposit Cover | 1299 | 0.1% |
Asset Value Preserver | 865 | 0.1% |
Fire,Theft and Third Party | 750 | 0.1% |
Standalone passenger liability | 544 | 0.1% |
Other values (4) | 602 | 0.1% |
Length
Value | Count | Frequency (%) |
comprehensive | 828065 | |
824124 | ||
taxi | 824124 | |
income | 64813 | 2.2% |
protector | 64813 | 2.2% |
basic | 57769 | 2.0% |
excess | 57769 | 2.0% |
waiver | 57769 | 2.0% |
accidental | 27321 | 0.9% |
death | 27321 | 0.9% |
Other values (20) | 50925 | 1.8% |
Most occurring characters
Value | Count | Frequency (%) |
e | 2830616 | |
1884715 | 9.7% | |
i | 1836049 | 9.4% |
o | 1069668 | 5.5% |
r | 1062507 | 5.4% |
s | 1006936 | 5.2% |
a | 1000082 | 5.1% |
n | 941005 | 4.8% |
m | 892878 | 4.6% |
v | 887998 | 4.6% |
Other values (31) | 6102334 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 19514788 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 2830616 | |
1884715 | 9.7% | |
i | 1836049 | 9.4% |
o | 1069668 | 5.5% |
r | 1062507 | 5.4% |
s | 1006936 | 5.2% |
a | 1000082 | 5.1% |
n | 941005 | 4.8% |
m | 892878 | 4.6% |
v | 887998 | 4.6% |
Other values (31) | 6102334 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 19514788 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 2830616 | |
1884715 | 9.7% | |
i | 1836049 | 9.4% |
o | 1069668 | 5.5% |
r | 1062507 | 5.4% |
s | 1006936 | 5.2% |
a | 1000082 | 5.1% |
n | 941005 | 4.8% |
m | 892878 | 4.6% |
v | 887998 | 4.6% |
Other values (31) | 6102334 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 19514788 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 2830616 | |
1884715 | 9.7% | |
i | 1836049 | 9.4% |
o | 1069668 | 5.5% |
r | 1062507 | 5.4% |
s | 1006936 | 5.2% |
a | 1000082 | 5.1% |
n | 941005 | 4.8% |
m | 892878 | 4.6% |
v | 887998 | 4.6% |
Other values (31) | 6102334 |
Section
Categorical
High correlation  Imbalance 
Distinct | 5 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Motor Comprehensive | |
---|---|
Optional Extended Covers | |
Credit Protection | 18070 |
Third party or third party, fire and theft only | 829 |
Standalone passenger liability | 544 |
Length
Max length | 47 |
---|---|
Median length | 19 |
Mean length | 19.755632 |
Min length | 17 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Motor Comprehensive |
---|---|
2nd row | Motor Comprehensive |
3rd row | Motor Comprehensive |
4th row | Motor Comprehensive |
5th row | Motor Comprehensive |
Common Values
Value | Count | Frequency (%) |
Motor Comprehensive | 828125 | |
Optional Extended Covers | 152530 | 15.3% |
Credit Protection | 18070 | 1.8% |
Third party or third party, fire and theft only | 829 | 0.1% |
Standalone passenger liability | 544 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
motor | 828125 | |
comprehensive | 828125 | |
optional | 152530 | 7.1% |
extended | 152530 | 7.1% |
covers | 152530 | 7.1% |
credit | 18070 | 0.8% |
protection | 18070 | 0.8% |
third | 1658 | 0.1% |
party | 1658 | 0.1% |
or | 829 | < 0.1% |
Other values (7) | 4948 | 0.2% |
Most occurring characters
Value | Count | Frequency (%) |
e | 2981395 | |
o | 2827777 | |
r | 1850438 | |
t | 1192628 | 6.0% |
1158975 | 5.9% | |
n | 1154545 | 5.8% |
i | 1020914 | 5.2% |
C | 998725 | 5.1% |
p | 982857 | 5.0% |
s | 981743 | 5.0% |
Other values (19) | 4607571 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 19757568 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
e | 2981395 | |
o | 2827777 | |
r | 1850438 | |
t | 1192628 | 6.0% |
1158975 | 5.9% | |
n | 1154545 | 5.8% |
i | 1020914 | 5.2% |
C | 998725 | 5.1% |
p | 982857 | 5.0% |
s | 981743 | 5.0% |
Other values (19) | 4607571 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 19757568 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
e | 2981395 | |
o | 2827777 | |
r | 1850438 | |
t | 1192628 | 6.0% |
1158975 | 5.9% | |
n | 1154545 | 5.8% |
i | 1020914 | 5.2% |
C | 998725 | 5.1% |
p | 982857 | 5.0% |
s | 981743 | 5.0% |
Other values (19) | 4607571 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 19757568 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
e | 2981395 | |
o | 2827777 | |
r | 1850438 | |
t | 1192628 | 6.0% |
1158975 | 5.9% | |
n | 1154545 | 5.8% |
i | 1020914 | 5.2% |
C | 998725 | 5.1% |
p | 982857 | 5.0% |
s | 981743 | 5.0% |
Other values (19) | 4607571 |
Product
Categorical
High correlation  Imbalance 
Distinct | 4 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Mobility Commercial Cover: Monthly | |
---|---|
Mobility Metered Taxis: Monthly | 79272 |
Bridge Taxi Finance: Monthly | 5254 |
Standalone Passenger Liability | 544 |
Length
Max length | 34 |
---|---|
Median length | 34 |
Mean length | 33.728511 |
Min length | 28 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Mobility Metered Taxis: Monthly |
---|---|
2nd row | Mobility Metered Taxis: Monthly |
3rd row | Mobility Metered Taxis: Monthly |
4th row | Mobility Metered Taxis: Monthly |
5th row | Mobility Metered Taxis: Monthly |
Common Values
Value | Count | Frequency (%) |
Mobility Commercial Cover: Monthly | 915028 | |
Mobility Metered Taxis: Monthly | 79272 | 7.9% |
Bridge Taxi Finance: Monthly | 5254 | 0.5% |
Standalone Passenger Liability | 544 | 0.1% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
monthly | 999554 | |
mobility | 994300 | |
commercial | 915028 | |
cover | 915028 | |
metered | 79272 | 2.0% |
taxis | 79272 | 2.0% |
bridge | 5254 | 0.1% |
taxi | 5254 | 0.1% |
finance | 5254 | 0.1% |
standalone | 544 | < 0.1% |
Other values (2) | 1088 | < 0.1% |
Most occurring characters
Value | Count | Frequency (%) |
o | 3824454 | |
i | 3000294 | 8.9% |
2999750 | 8.9% | |
l | 2909970 | 8.6% |
e | 2080012 | 6.2% |
t | 2074214 | 6.1% |
M | 2073126 | 6.1% |
y | 1994398 | 5.9% |
r | 1915126 | 5.7% |
m | 1830056 | 5.4% |
Other values (18) | 9030416 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 33731816 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
o | 3824454 | |
i | 3000294 | 8.9% |
2999750 | 8.9% | |
l | 2909970 | 8.6% |
e | 2080012 | 6.2% |
t | 2074214 | 6.1% |
M | 2073126 | 6.1% |
y | 1994398 | 5.9% |
r | 1915126 | 5.7% |
m | 1830056 | 5.4% |
Other values (18) | 9030416 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 33731816 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
o | 3824454 | |
i | 3000294 | 8.9% |
2999750 | 8.9% | |
l | 2909970 | 8.6% |
e | 2080012 | 6.2% |
t | 2074214 | 6.1% |
M | 2073126 | 6.1% |
y | 1994398 | 5.9% |
r | 1915126 | 5.7% |
m | 1830056 | 5.4% |
Other values (18) | 9030416 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 33731816 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
o | 3824454 | |
i | 3000294 | 8.9% |
2999750 | 8.9% | |
l | 2909970 | 8.6% |
e | 2080012 | 6.2% |
t | 2074214 | 6.1% |
M | 2073126 | 6.1% |
y | 1994398 | 5.9% |
r | 1915126 | 5.7% |
m | 1830056 | 5.4% |
Other values (18) | 9030416 |
StatutoryClass
Categorical
Constant 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
Commercial |
---|
Length
Max length | 10 |
---|---|
Median length | 10 |
Mean length | 10 |
Min length | 10 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | Commercial |
---|---|
2nd row | Commercial |
3rd row | Commercial |
4th row | Commercial |
5th row | Commercial |
Common Values
Value | Count | Frequency (%) |
Commercial | 1000098 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
commercial | 1000098 |
Most occurring characters
Value | Count | Frequency (%) |
m | 2000196 | |
C | 1000098 | |
o | 1000098 | |
e | 1000098 | |
r | 1000098 | |
c | 1000098 | |
i | 1000098 | |
a | 1000098 | |
l | 1000098 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 10000980 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
m | 2000196 | |
C | 1000098 | |
o | 1000098 | |
e | 1000098 | |
r | 1000098 | |
c | 1000098 | |
i | 1000098 | |
a | 1000098 | |
l | 1000098 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 10000980 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
m | 2000196 | |
C | 1000098 | |
o | 1000098 | |
e | 1000098 | |
r | 1000098 | |
c | 1000098 | |
i | 1000098 | |
a | 1000098 | |
l | 1000098 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 10000980 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
m | 2000196 | |
C | 1000098 | |
o | 1000098 | |
e | 1000098 | |
r | 1000098 | |
c | 1000098 | |
i | 1000098 | |
a | 1000098 | |
l | 1000098 |
StatutoryRiskType
Categorical
Constant 
Distinct | 1 |
---|---|
Distinct (%) | < 0.1% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 7.6 MiB |
IFRS Constant |
---|
Length
Max length | 13 |
---|---|
Median length | 13 |
Mean length | 13 |
Min length | 13 |
Unique
Unique | 0 ? |
---|---|
Unique (%) | 0.0% |
Sample
1st row | IFRS Constant |
---|---|
2nd row | IFRS Constant |
3rd row | IFRS Constant |
4th row | IFRS Constant |
5th row | IFRS Constant |
Common Values
Value | Count | Frequency (%) |
IFRS Constant | 1000098 |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
ifrs | 1000098 | |
constant | 1000098 |
Most occurring characters
Value | Count | Frequency (%) |
t | 2000196 | |
n | 2000196 | |
I | 1000098 | |
R | 1000098 | |
F | 1000098 | |
S | 1000098 | |
1000098 | ||
o | 1000098 | |
C | 1000098 | |
s | 1000098 |
Most occurring categories
Value | Count | Frequency (%) |
(unknown) | 13001274 |
Most frequent character per category
(unknown)
Value | Count | Frequency (%) |
t | 2000196 | |
n | 2000196 | |
I | 1000098 | |
R | 1000098 | |
F | 1000098 | |
S | 1000098 | |
1000098 | ||
o | 1000098 | |
C | 1000098 | |
s | 1000098 |
Most occurring scripts
Value | Count | Frequency (%) |
(unknown) | 13001274 |
Most frequent character per script
(unknown)
Value | Count | Frequency (%) |
t | 2000196 | |
n | 2000196 | |
I | 1000098 | |
R | 1000098 | |
F | 1000098 | |
S | 1000098 | |
1000098 | ||
o | 1000098 | |
C | 1000098 | |
s | 1000098 |
Most occurring blocks
Value | Count | Frequency (%) |
(unknown) | 13001274 |
Most frequent character per block
(unknown)
Value | Count | Frequency (%) |
t | 2000196 | |
n | 2000196 | |
I | 1000098 | |
R | 1000098 | |
F | 1000098 | |
S | 1000098 | |
1000098 | ||
o | 1000098 | |
C | 1000098 | |
s | 1000098 |
TotalPremium
Real number (ℝ)
High correlation  Skewed  Zeros 
Distinct | 38959 |
---|---|
Distinct (%) | 3.9% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 61.905496 |
Minimum | -782.57675 |
---|---|
Maximum | 65282.603 |
Zeros | 381634 |
Zeros (%) | 38.2% |
Negative | 288 |
Negative (%) | < 0.1% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | -782.57675 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 2.1783333 |
Q3 | 21.929825 |
95-th percentile | 404.87798 |
Maximum | 65282.603 |
Range | 66065.18 |
Interquartile range (IQR) | 21.929825 |
Descriptive statistics
Standard deviation | 230.28451 |
---|---|
Coefficient of variation (CV) | 3.7199365 |
Kurtosis | 37176.185 |
Mean | 61.905496 |
Median Absolute Deviation (MAD) | 2.1783333 |
Skewness | 138.59646 |
Sum | 61911563 |
Variance | 53030.957 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 381634 | |
21.92982456 | 49731 | 5.0% |
74.56140351 | 34382 | 3.4% |
78.94736842 | 30400 | 3.0% |
43.85964912 | 16919 | 1.7% |
15.78947368 | 10939 | 1.1% |
92.10526316 | 3424 | 0.3% |
96.49122807 | 2921 | 0.3% |
4.834122807 | 2443 | 0.2% |
1.933684211 | 2272 | 0.2% |
Other values (38949) | 465033 |
Value | Count | Frequency (%) |
-782.5767544 | 11 | |
-575.5796491 | 11 | |
-350.7014912 | 11 | |
-302.9329372 | 1 | < 0.1% |
-294.7868421 | 11 | |
-284.497807 | 12 | |
-222.8050255 | 1 | < 0.1% |
-135.755416 | 1 | < 0.1% |
-114.1110357 | 1 | < 0.1% |
-96.49122807 | 1 | < 0.1% |
Value | Count | Frequency (%) |
65282.60342 | 4 | < 0.1% |
64291.06026 | 1 | < 0.1% |
60143.24992 | 1 | < 0.1% |
24473.36377 | 6 | |
4211.780866 | 1 | < 0.1% |
2770.523421 | 4 | < 0.1% |
2728.443421 | 1 | < 0.1% |
2552.414813 | 1 | < 0.1% |
2253.507281 | 10 | |
1890.948684 | 6 |
TotalClaims
Real number (ℝ)
Skewed  Zeros 
Distinct | 1615 |
---|---|
Distinct (%) | 0.2% |
Missing | 0 |
Missing (%) | 0.0% |
Infinite | 0 |
Infinite (%) | 0.0% |
Mean | 64.86119 |
Minimum | -12002.412 |
---|---|
Maximum | 393092.11 |
Zeros | 997305 |
Zeros (%) | 99.7% |
Negative | 5 |
Negative (%) | < 0.1% |
Memory size | 7.6 MiB |
Quantile statistics
Minimum | -12002.412 |
---|---|
5-th percentile | 0 |
Q1 | 0 |
median | 0 |
Q3 | 0 |
95-th percentile | 0 |
Maximum | 393092.11 |
Range | 405094.52 |
Interquartile range (IQR) | 0 |
Descriptive statistics
Standard deviation | 2384.0747 |
---|---|
Coefficient of variation (CV) | 36.756567 |
Kurtosis | 6791.9262 |
Mean | 64.86119 |
Median Absolute Deviation (MAD) | 0 |
Skewness | 69.933118 |
Sum | 64867546 |
Variance | 5683812.1 |
Monotonicity | Not monotonic |
Value | Count | Frequency (%) |
0 | 997305 | |
6140.350877 | 326 | < 0.1% |
750.6491228 | 101 | < 0.1% |
1300 | 59 | < 0.1% |
850 | 51 | < 0.1% |
877.1929825 | 45 | < 0.1% |
43859.64912 | 41 | < 0.1% |
1150 | 31 | < 0.1% |
3070.175439 | 28 | < 0.1% |
815.7894737 | 24 | < 0.1% |
Other values (1605) | 2087 | 0.2% |
Value | Count | Frequency (%) |
-12002.41228 | 1 | < 0.1% |
-5690.719298 | 1 | < 0.1% |
-635.48 | 1 | < 0.1% |
-256.35 | 1 | < 0.1% |
-72 | 1 | < 0.1% |
0 | 997305 | |
139.0438596 | 2 | < 0.1% |
158.51 | 1 | < 0.1% |
170.6578947 | 2 | < 0.1% |
175.4385965 | 4 | < 0.1% |
Value | Count | Frequency (%) |
393092.1053 | 1 | |
376432.4912 | 1 | |
363343.4211 | 1 | |
304413.3947 | 1 | |
304338.6579 | 1 | |
302361.1491 | 1 | |
286686.4311 | 1 | |
276248.8596 | 1 | |
269311.9298 | 1 | |
265789.4737 | 1 |
Interactions
Correlations
AccountType | AlarmImmobiliser | Bank | CalculatedPremiumPerTerm | Citizenship | Converted | CoverCategory | CoverGroup | CoverType | CustomValueEstimate | Cylinders | ExcessSelected | Gender | IsVATRegistered | LegalType | MainCrestaZone | MaritalStatus | NewVehicle | NumberOfDoors | PolicyID | PostalCode | Product | Province | Rebuilt | RegistrationYear | Section | SubCrestaZone | SumInsured | TermFrequency | Title | TotalClaims | TotalPremium | TrackingDevice | TransactionMonth | UnderwrittenCoverID | VehicleType | WrittenOff | bodytype | cubiccapacity | kilowatts | make | mmcode | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AccountType | 1.000 | 0.012 | 0.303 | 0.003 | 0.044 | 1.000 | 0.071 | 0.066 | 0.059 | 0.015 | 0.026 | 0.035 | 0.065 | 0.056 | 0.158 | 0.155 | 0.030 | 0.006 | 0.059 | 0.103 | 0.131 | 0.085 | 0.135 | 1.000 | 0.054 | 0.053 | 0.182 | 0.006 | 0.012 | 0.034 | 0.002 | 0.001 | 0.096 | 0.056 | 0.098 | 0.027 | 1.000 | 0.088 | 0.049 | 0.057 | 0.083 | 0.064 |
AlarmImmobiliser | 0.012 | 1.000 | 0.022 | 0.000 | 0.005 | 0.000 | 0.005 | 0.004 | 0.003 | 0.000 | 0.002 | 0.005 | 0.003 | 0.000 | 0.004 | 0.121 | 0.000 | 0.000 | 0.037 | 0.039 | 0.056 | 0.004 | 0.042 | 0.000 | 0.107 | 0.004 | 0.121 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.005 | 0.008 | 0.032 | 0.099 | 0.000 | 0.210 | 0.014 | 0.082 | 0.122 | 0.044 |
Bank | 0.303 | 0.022 | 1.000 | 0.006 | 0.159 | 1.000 | 0.128 | 0.194 | 0.085 | 0.048 | 0.036 | 0.031 | 0.050 | 0.114 | 0.189 | 0.118 | 0.057 | 0.028 | 0.053 | 0.071 | 0.102 | 0.376 | 0.092 | 1.000 | 0.083 | 0.128 | 0.150 | 0.019 | 0.011 | 0.060 | 0.001 | 0.003 | 0.075 | 0.028 | 0.064 | 0.038 | 1.000 | 0.059 | 0.060 | 0.062 | 0.246 | 0.219 |
CalculatedPremiumPerTerm | 0.003 | 0.000 | 0.006 | 1.000 | 0.000 | 1.000 | 0.040 | 0.000 | 0.010 | 0.162 | 0.012 | 0.048 | 0.000 | 0.000 | 0.012 | 0.011 | 0.000 | 0.000 | -0.032 | 0.058 | 0.010 | 0.013 | 0.008 | 1.000 | 0.147 | 0.000 | 0.010 | 0.249 | 0.000 | 0.000 | 0.052 | 0.395 | 0.004 | 0.000 | 0.056 | 1.000 | 1.000 | 1.000 | 0.089 | 0.056 | 1.000 | 0.084 |
Citizenship | 0.044 | 0.005 | 0.159 | 0.000 | 1.000 | 0.006 | 0.076 | 0.105 | 0.048 | 0.003 | 0.022 | 0.032 | 0.382 | 0.024 | 0.042 | 0.105 | 0.256 | 0.006 | 0.129 | 0.243 | 0.110 | 0.142 | 0.093 | 0.003 | 0.039 | 0.022 | 0.139 | 0.005 | 0.006 | 0.059 | 0.000 | 0.000 | 0.125 | 0.160 | 0.255 | 0.025 | 0.003 | 0.103 | 0.042 | 0.034 | 0.291 | 0.131 |
Converted | 1.000 | 0.000 | 1.000 | 1.000 | 0.006 | 1.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.075 | 0.006 | 0.002 | 0.000 | 0.004 | 0.126 | 0.000 | 0.000 | 0.065 | 0.035 | 0.059 | 0.002 | 0.126 | 0.597 | 0.016 | 0.002 | 0.193 | 0.000 | 0.000 | 0.003 | 0.000 | 1.000 | 0.008 | 0.012 | 0.048 | 0.040 | 0.597 | 0.055 | 0.002 | 0.000 | 0.211 | 0.048 |
CoverCategory | 0.071 | 0.005 | 0.128 | 0.040 | 0.076 | 0.000 | 1.000 | 0.943 | 0.988 | 0.002 | 0.023 | 0.816 | 0.081 | 0.062 | 0.083 | 0.065 | 0.075 | 0.069 | 0.076 | 0.105 | 0.074 | 0.684 | 0.071 | 0.004 | 0.093 | 0.909 | 0.074 | 0.706 | 1.000 | 0.029 | 0.028 | 0.026 | 0.134 | 0.044 | 0.113 | 0.036 | 0.004 | 0.115 | 0.073 | 0.077 | 0.078 | 0.104 |
CoverGroup | 0.066 | 0.004 | 0.194 | 0.000 | 0.105 | 0.000 | 0.943 | 1.000 | 0.941 | 0.006 | 0.016 | 0.415 | 0.038 | 0.075 | 0.102 | 0.069 | 0.074 | 0.069 | 0.024 | 0.056 | 0.073 | 0.769 | 0.063 | 0.000 | 0.063 | 0.998 | 0.103 | 0.508 | 1.000 | 0.022 | 0.003 | 0.000 | 0.115 | 0.020 | 0.051 | 0.029 | 0.000 | 0.044 | 0.034 | 0.031 | 0.146 | 0.151 |
CoverType | 0.059 | 0.003 | 0.085 | 0.010 | 0.048 | 0.000 | 0.988 | 0.941 | 1.000 | 0.002 | 0.019 | 0.646 | 0.067 | 0.055 | 0.049 | 0.056 | 0.074 | 0.069 | 0.037 | 0.050 | 0.062 | 0.598 | 0.059 | 0.000 | 0.053 | 0.940 | 0.076 | 0.706 | 1.000 | 0.022 | 0.027 | 0.006 | 0.111 | 0.029 | 0.054 | 0.029 | 0.000 | 0.074 | 0.032 | 0.038 | 0.055 | 0.062 |
CustomValueEstimate | 0.015 | 0.000 | 0.048 | 0.162 | 0.003 | 1.000 | 0.002 | 0.006 | 0.002 | 1.000 | 0.049 | 0.000 | 0.000 | 0.000 | 0.001 | 0.046 | 0.000 | 0.000 | -0.023 | 0.012 | 0.029 | 0.001 | 0.036 | 1.000 | 0.893 | 0.006 | 0.061 | 0.025 | 0.000 | 0.002 | 0.004 | 0.077 | 0.019 | 0.000 | 0.049 | 0.054 | 1.000 | 0.155 | 0.255 | 0.154 | 0.068 | 0.319 |
Cylinders | 0.026 | 0.002 | 0.036 | 0.012 | 0.022 | 0.075 | 0.023 | 0.016 | 0.019 | 0.049 | 1.000 | 0.017 | 0.013 | 0.128 | 0.180 | 0.048 | 0.019 | 0.008 | -0.314 | -0.021 | -0.037 | 0.060 | 0.054 | 0.000 | -0.069 | 0.013 | 0.072 | 0.002 | 0.018 | 0.031 | -0.000 | -0.002 | 0.038 | 0.041 | -0.021 | 0.477 | 0.000 | 0.408 | 0.190 | 0.255 | 0.605 | -0.071 |
ExcessSelected | 0.035 | 0.005 | 0.031 | 0.048 | 0.032 | 0.006 | 0.816 | 0.415 | 0.646 | 0.000 | 0.017 | 1.000 | 0.051 | 0.015 | 0.046 | 0.041 | 0.049 | 0.006 | 0.070 | 0.096 | 0.041 | 0.200 | 0.041 | 0.014 | 0.075 | 0.125 | 0.056 | 0.092 | 0.011 | 0.017 | 0.031 | 0.035 | 0.073 | 0.040 | 0.107 | 0.033 | 0.014 | 0.096 | 0.064 | 0.070 | 0.070 | 0.055 |
Gender | 0.065 | 0.003 | 0.050 | 0.000 | 0.382 | 0.002 | 0.081 | 0.038 | 0.067 | 0.000 | 0.013 | 0.051 | 1.000 | 0.016 | 0.071 | 0.131 | 0.276 | 0.008 | 0.038 | 0.244 | 0.108 | 0.130 | 0.101 | 0.000 | 0.044 | 0.018 | 0.214 | 0.003 | 0.003 | 0.330 | 0.000 | 0.000 | 0.095 | 0.241 | 0.260 | 0.017 | 0.000 | 0.174 | 0.044 | 0.041 | 0.112 | 0.059 |
IsVATRegistered | 0.056 | 0.000 | 0.114 | 0.000 | 0.024 | 0.000 | 0.062 | 0.075 | 0.055 | 0.000 | 0.128 | 0.015 | 0.016 | 1.000 | 0.299 | 0.289 | 0.005 | 0.002 | 0.015 | 0.118 | 0.142 | 0.064 | 0.088 | 0.000 | 0.076 | 0.051 | 0.289 | 0.000 | 0.001 | 0.019 | 0.000 | 0.000 | 0.001 | 0.047 | 0.125 | 0.019 | 0.000 | 0.067 | 0.157 | 0.110 | 0.413 | 0.303 |
LegalType | 0.158 | 0.004 | 0.189 | 0.012 | 0.042 | 0.004 | 0.083 | 0.102 | 0.049 | 0.001 | 0.180 | 0.046 | 0.071 | 0.299 | 1.000 | 0.156 | 0.059 | 0.008 | 0.115 | 0.099 | 0.137 | 0.205 | 0.136 | 0.000 | 0.034 | 0.043 | 0.172 | 0.012 | 0.008 | 0.039 | 0.000 | 0.008 | 0.096 | 0.060 | 0.096 | 0.145 | 0.000 | 0.158 | 0.134 | 0.187 | 0.283 | 0.172 |
MainCrestaZone | 0.155 | 0.121 | 0.118 | 0.011 | 0.105 | 0.126 | 0.065 | 0.069 | 0.056 | 0.046 | 0.048 | 0.041 | 0.131 | 0.289 | 0.156 | 1.000 | 0.121 | 0.041 | 0.085 | 0.144 | 0.807 | 0.172 | 0.827 | 0.020 | 0.081 | 0.043 | 1.000 | 0.056 | 0.026 | 0.079 | 0.002 | 0.006 | 0.229 | 0.053 | 0.146 | 0.062 | 0.020 | 0.104 | 0.086 | 0.103 | 0.112 | 0.102 |
MaritalStatus | 0.030 | 0.000 | 0.057 | 0.000 | 0.256 | 0.000 | 0.075 | 0.074 | 0.074 | 0.000 | 0.019 | 0.049 | 0.276 | 0.005 | 0.059 | 0.121 | 1.000 | 0.001 | 0.022 | 0.097 | 0.118 | 0.028 | 0.104 | 0.000 | 0.029 | 0.012 | 0.144 | 0.000 | 0.001 | 0.061 | 0.000 | 0.000 | 0.048 | 0.066 | 0.080 | 0.011 | 0.000 | 0.061 | 0.018 | 0.022 | 0.102 | 0.081 |
NewVehicle | 0.006 | 0.000 | 0.028 | 0.000 | 0.006 | 0.000 | 0.069 | 0.069 | 0.069 | 0.000 | 0.008 | 0.006 | 0.008 | 0.002 | 0.008 | 0.041 | 0.001 | 1.000 | 0.010 | 0.034 | 0.046 | 0.003 | 0.038 | 0.000 | 0.055 | 0.010 | 0.117 | 0.000 | 0.000 | 0.019 | 0.000 | 0.000 | 0.017 | 0.014 | 0.053 | 0.004 | 0.000 | 0.025 | 0.025 | 0.024 | 0.146 | 0.017 |
NumberOfDoors | 0.059 | 0.037 | 0.053 | -0.032 | 0.129 | 0.065 | 0.076 | 0.024 | 0.037 | -0.023 | -0.314 | 0.070 | 0.038 | 0.015 | 0.115 | 0.085 | 0.022 | 0.010 | 1.000 | -0.066 | 0.093 | 0.258 | 0.076 | 0.000 | 0.071 | 0.020 | 0.107 | -0.005 | 0.017 | 0.022 | 0.001 | -0.033 | 0.037 | 0.035 | -0.049 | 0.399 | 0.000 | 0.510 | -0.303 | -0.193 | 0.554 | -0.171 |
PolicyID | 0.103 | 0.039 | 0.071 | 0.058 | 0.243 | 0.035 | 0.105 | 0.056 | 0.050 | 0.012 | -0.021 | 0.096 | 0.244 | 0.118 | 0.099 | 0.144 | 0.097 | 0.034 | -0.066 | 1.000 | 0.047 | 0.160 | 0.129 | 0.032 | 0.086 | 0.045 | 0.187 | 0.012 | 0.025 | 0.071 | 0.002 | 0.173 | 0.294 | 0.229 | 0.930 | 0.036 | 0.032 | 0.091 | 0.066 | -0.032 | 0.098 | 0.098 |
PostalCode | 0.131 | 0.056 | 0.102 | 0.010 | 0.110 | 0.059 | 0.074 | 0.073 | 0.062 | 0.029 | -0.037 | 0.041 | 0.108 | 0.142 | 0.137 | 0.807 | 0.118 | 0.046 | 0.093 | 0.047 | 1.000 | 0.154 | 0.746 | 0.019 | 0.013 | 0.043 | 0.944 | 0.006 | 0.027 | 0.065 | -0.006 | -0.007 | 0.218 | 0.061 | 0.060 | 0.068 | 0.019 | 0.112 | -0.152 | -0.214 | 0.129 | -0.122 |
Product | 0.085 | 0.004 | 0.376 | 0.013 | 0.142 | 0.002 | 0.684 | 0.769 | 0.598 | 0.001 | 0.060 | 0.200 | 0.130 | 0.064 | 0.205 | 0.172 | 0.028 | 0.003 | 0.258 | 0.160 | 0.154 | 1.000 | 0.137 | 0.000 | 0.100 | 0.584 | 0.181 | 0.046 | 1.000 | 0.041 | 0.001 | 0.008 | 0.063 | 0.126 | 0.143 | 0.045 | 0.000 | 0.529 | 0.185 | 0.205 | 0.438 | 0.323 |
Province | 0.135 | 0.042 | 0.092 | 0.008 | 0.093 | 0.126 | 0.071 | 0.063 | 0.059 | 0.036 | 0.054 | 0.041 | 0.101 | 0.088 | 0.136 | 0.827 | 0.104 | 0.038 | 0.076 | 0.129 | 0.746 | 0.137 | 1.000 | 0.011 | 0.074 | 0.037 | 0.945 | 0.018 | 0.025 | 0.070 | 0.002 | 0.005 | 0.201 | 0.063 | 0.125 | 0.074 | 0.011 | 0.112 | 0.082 | 0.092 | 0.123 | 0.085 |
Rebuilt | 1.000 | 0.000 | 1.000 | 1.000 | 0.003 | 0.597 | 0.004 | 0.000 | 0.000 | 1.000 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.020 | 0.000 | 0.000 | 0.000 | 0.032 | 0.019 | 0.000 | 0.011 | 1.000 | 0.012 | 0.003 | 0.018 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.007 | 0.006 | 0.030 | 0.000 | 0.984 | 0.059 | 0.009 | 0.010 | 0.338 | 0.000 |
RegistrationYear | 0.054 | 0.107 | 0.083 | 0.147 | 0.039 | 0.016 | 0.093 | 0.063 | 0.053 | 0.893 | -0.069 | 0.075 | 0.044 | 0.076 | 0.034 | 0.081 | 0.029 | 0.055 | 0.071 | 0.086 | 0.013 | 0.100 | 0.074 | 0.012 | 1.000 | 0.077 | 0.102 | 0.026 | 0.115 | 0.043 | 0.000 | 0.057 | 0.223 | 0.033 | 0.098 | 0.060 | 0.012 | 0.072 | 0.112 | 0.096 | 0.140 | 0.246 |
Section | 0.053 | 0.004 | 0.128 | 0.000 | 0.022 | 0.002 | 0.909 | 0.998 | 0.940 | 0.006 | 0.013 | 0.125 | 0.018 | 0.051 | 0.043 | 0.043 | 0.012 | 0.010 | 0.020 | 0.045 | 0.043 | 0.584 | 0.037 | 0.003 | 0.077 | 1.000 | 0.064 | 0.162 | 1.000 | 0.016 | 0.005 | 0.000 | 0.104 | 0.027 | 0.045 | 0.008 | 0.003 | 0.046 | 0.022 | 0.024 | 0.080 | 0.058 |
SubCrestaZone | 0.182 | 0.121 | 0.150 | 0.010 | 0.139 | 0.193 | 0.074 | 0.103 | 0.076 | 0.061 | 0.072 | 0.056 | 0.214 | 0.289 | 0.172 | 1.000 | 0.144 | 0.117 | 0.107 | 0.187 | 0.944 | 0.181 | 0.945 | 0.018 | 0.102 | 0.064 | 1.000 | 0.124 | 0.041 | 0.166 | 0.000 | 0.004 | 0.269 | 0.057 | 0.187 | 0.098 | 0.018 | 0.123 | 0.112 | 0.121 | 0.095 | 0.138 |
SumInsured | 0.006 | 0.000 | 0.019 | 0.249 | 0.005 | 0.000 | 0.706 | 0.508 | 0.706 | 0.025 | 0.002 | 0.092 | 0.003 | 0.000 | 0.012 | 0.056 | 0.000 | 0.000 | -0.005 | 0.012 | 0.006 | 0.046 | 0.018 | 0.000 | 0.026 | 0.162 | 0.124 | 1.000 | 0.068 | 0.000 | -0.007 | 0.101 | 0.012 | 0.003 | 0.012 | 0.010 | 0.000 | 0.015 | 0.013 | 0.004 | 0.129 | 0.010 |
TermFrequency | 0.012 | 0.000 | 0.011 | 0.000 | 0.006 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.018 | 0.011 | 0.003 | 0.001 | 0.008 | 0.026 | 0.001 | 0.000 | 0.017 | 0.025 | 0.027 | 1.000 | 0.025 | 0.000 | 0.115 | 1.000 | 0.041 | 0.068 | 1.000 | 0.004 | 0.000 | 0.000 | 0.013 | 0.019 | 0.018 | 0.004 | 0.000 | 0.014 | 0.014 | 0.017 | 0.080 | 0.009 |
Title | 0.034 | 0.004 | 0.060 | 0.000 | 0.059 | 0.003 | 0.029 | 0.022 | 0.022 | 0.002 | 0.031 | 0.017 | 0.330 | 0.019 | 0.039 | 0.079 | 0.061 | 0.019 | 0.022 | 0.071 | 0.065 | 0.041 | 0.070 | 0.000 | 0.043 | 0.016 | 0.166 | 0.000 | 0.004 | 1.000 | 0.000 | 0.000 | 0.081 | 0.040 | 0.063 | 0.013 | 0.000 | 0.074 | 0.021 | 0.029 | 0.060 | 0.038 |
TotalClaims | 0.002 | 0.000 | 0.001 | 0.052 | 0.000 | 0.000 | 0.028 | 0.003 | 0.027 | 0.004 | -0.000 | 0.031 | 0.000 | 0.000 | 0.000 | 0.002 | 0.000 | 0.000 | 0.001 | 0.002 | -0.006 | 0.001 | 0.002 | 0.000 | 0.000 | 0.005 | 0.000 | -0.007 | 0.000 | 0.000 | 1.000 | 0.063 | 0.003 | 0.002 | 0.003 | 0.003 | 0.000 | 0.006 | 0.006 | 0.006 | 0.000 | 0.005 |
TotalPremium | 0.001 | 0.000 | 0.003 | 0.395 | 0.000 | 1.000 | 0.026 | 0.000 | 0.006 | 0.077 | -0.002 | 0.035 | 0.000 | 0.000 | 0.008 | 0.006 | 0.000 | 0.000 | -0.033 | 0.173 | -0.007 | 0.008 | 0.005 | 1.000 | 0.057 | 0.000 | 0.004 | 0.101 | 0.000 | 0.000 | 0.063 | 1.000 | 0.002 | 0.000 | 0.189 | 1.000 | 1.000 | 1.000 | 0.087 | 0.048 | 1.000 | 0.079 |
TrackingDevice | 0.096 | 0.005 | 0.075 | 0.004 | 0.125 | 0.008 | 0.134 | 0.115 | 0.111 | 0.019 | 0.038 | 0.073 | 0.095 | 0.001 | 0.096 | 0.229 | 0.048 | 0.017 | 0.037 | 0.294 | 0.218 | 0.063 | 0.201 | 0.007 | 0.223 | 0.104 | 0.269 | 0.012 | 0.013 | 0.081 | 0.003 | 0.002 | 1.000 | 0.197 | 0.290 | 0.021 | 0.007 | 0.076 | 0.063 | 0.064 | 0.115 | 0.072 |
TransactionMonth | 0.056 | 0.008 | 0.028 | 0.000 | 0.160 | 0.012 | 0.044 | 0.020 | 0.029 | 0.000 | 0.041 | 0.040 | 0.241 | 0.047 | 0.060 | 0.053 | 0.066 | 0.014 | 0.035 | 0.229 | 0.061 | 0.126 | 0.063 | 0.006 | 0.033 | 0.027 | 0.057 | 0.003 | 0.019 | 0.040 | 0.002 | 0.000 | 0.197 | 1.000 | 0.255 | 0.015 | 0.006 | 0.070 | 0.040 | 0.046 | 0.043 | 0.045 |
UnderwrittenCoverID | 0.098 | 0.032 | 0.064 | 0.056 | 0.255 | 0.048 | 0.113 | 0.051 | 0.054 | 0.049 | -0.021 | 0.107 | 0.260 | 0.125 | 0.096 | 0.146 | 0.080 | 0.053 | -0.049 | 0.930 | 0.060 | 0.143 | 0.125 | 0.030 | 0.098 | 0.045 | 0.187 | 0.012 | 0.018 | 0.063 | 0.003 | 0.189 | 0.290 | 0.255 | 1.000 | 0.041 | 0.030 | 0.091 | 0.056 | -0.041 | 0.096 | 0.089 |
VehicleType | 0.027 | 0.099 | 0.038 | 1.000 | 0.025 | 0.040 | 0.036 | 0.029 | 0.029 | 0.054 | 0.477 | 0.033 | 0.017 | 0.019 | 0.145 | 0.062 | 0.011 | 0.004 | 0.399 | 0.036 | 0.068 | 0.045 | 0.074 | 0.000 | 0.060 | 0.008 | 0.098 | 0.010 | 0.004 | 0.013 | 0.003 | 1.000 | 0.021 | 0.015 | 0.041 | 1.000 | 0.000 | 0.572 | 0.260 | 0.387 | 0.801 | 0.502 |
WrittenOff | 1.000 | 0.000 | 1.000 | 1.000 | 0.003 | 0.597 | 0.004 | 0.000 | 0.000 | 1.000 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.020 | 0.000 | 0.000 | 0.000 | 0.032 | 0.019 | 0.000 | 0.011 | 0.984 | 0.012 | 0.003 | 0.018 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.007 | 0.006 | 0.030 | 0.000 | 1.000 | 0.059 | 0.009 | 0.010 | 0.338 | 0.000 |
bodytype | 0.088 | 0.210 | 0.059 | 1.000 | 0.103 | 0.055 | 0.115 | 0.044 | 0.074 | 0.155 | 0.408 | 0.096 | 0.174 | 0.067 | 0.158 | 0.104 | 0.061 | 0.025 | 0.510 | 0.091 | 0.112 | 0.529 | 0.112 | 0.059 | 0.072 | 0.046 | 0.123 | 0.015 | 0.014 | 0.074 | 0.006 | 1.000 | 0.076 | 0.070 | 0.091 | 0.572 | 0.059 | 1.000 | 0.458 | 0.402 | 0.521 | 0.296 |
cubiccapacity | 0.049 | 0.014 | 0.060 | 0.089 | 0.042 | 0.002 | 0.073 | 0.034 | 0.032 | 0.255 | 0.190 | 0.064 | 0.044 | 0.157 | 0.134 | 0.086 | 0.018 | 0.025 | -0.303 | 0.066 | -0.152 | 0.185 | 0.082 | 0.009 | 0.112 | 0.022 | 0.112 | 0.013 | 0.014 | 0.021 | 0.006 | 0.087 | 0.063 | 0.040 | 0.056 | 0.260 | 0.009 | 0.458 | 1.000 | 0.745 | 0.575 | 0.666 |
kilowatts | 0.057 | 0.082 | 0.062 | 0.056 | 0.034 | 0.000 | 0.077 | 0.031 | 0.038 | 0.154 | 0.255 | 0.070 | 0.041 | 0.110 | 0.187 | 0.103 | 0.022 | 0.024 | -0.193 | -0.032 | -0.214 | 0.205 | 0.092 | 0.010 | 0.096 | 0.024 | 0.121 | 0.004 | 0.017 | 0.029 | 0.006 | 0.048 | 0.064 | 0.046 | -0.041 | 0.387 | 0.010 | 0.402 | 0.745 | 1.000 | 0.534 | 0.540 |
make | 0.083 | 0.122 | 0.246 | 1.000 | 0.291 | 0.211 | 0.078 | 0.146 | 0.055 | 0.068 | 0.605 | 0.070 | 0.112 | 0.413 | 0.283 | 0.112 | 0.102 | 0.146 | 0.554 | 0.098 | 0.129 | 0.438 | 0.123 | 0.338 | 0.140 | 0.080 | 0.095 | 0.129 | 0.080 | 0.060 | 0.000 | 1.000 | 0.115 | 0.043 | 0.096 | 0.801 | 0.338 | 0.521 | 0.575 | 0.534 | 1.000 | 1.000 |
mmcode | 0.064 | 0.044 | 0.219 | 0.084 | 0.131 | 0.048 | 0.104 | 0.151 | 0.062 | 0.319 | -0.071 | 0.055 | 0.059 | 0.303 | 0.172 | 0.102 | 0.081 | 0.017 | -0.171 | 0.098 | -0.122 | 0.323 | 0.085 | 0.000 | 0.246 | 0.058 | 0.138 | 0.010 | 0.009 | 0.038 | 0.005 | 0.079 | 0.072 | 0.045 | 0.089 | 0.502 | 0.000 | 0.296 | 0.666 | 0.540 | 1.000 | 1.000 |
Missing values
Sample
UnderwrittenCoverID | PolicyID | TransactionMonth | IsVATRegistered | Citizenship | LegalType | Title | Language | Bank | AccountType | MaritalStatus | Gender | Country | Province | PostalCode | MainCrestaZone | SubCrestaZone | ItemType | mmcode | VehicleType | RegistrationYear | make | Model | Cylinders | cubiccapacity | kilowatts | bodytype | NumberOfDoors | VehicleIntroDate | CustomValueEstimate | AlarmImmobiliser | TrackingDevice | CapitalOutstanding | NewVehicle | WrittenOff | Rebuilt | Converted | CrossBorder | NumberOfVehiclesInFleet | SumInsured | TermFrequency | CalculatedPremiumPerTerm | ExcessSelected | CoverCategory | CoverType | CoverGroup | Section | Product | StatutoryClass | StatutoryRiskType | TotalPremium | TotalClaims | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 145249 | 12827 | 2015-03-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 0.01 | Monthly | 25.0000 | Mobility - Windscreen | Windscreen | Windscreen | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 21.929825 | 0.0 | |
1 | 145249 | 12827 | 2015-05-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 0.01 | Monthly | 25.0000 | Mobility - Windscreen | Windscreen | Windscreen | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 21.929825 | 0.0 | |
2 | 145249 | 12827 | 2015-07-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 0.01 | Monthly | 25.0000 | Mobility - Windscreen | Windscreen | Windscreen | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 0.000000 | 0.0 | |
3 | 145255 | 12827 | 2015-05-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 119300.00 | Monthly | 584.6468 | Mobility - Metered Taxis - R2000 | Own damage | Own Damage | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 512.848070 | 0.0 | |
4 | 145255 | 12827 | 2015-07-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 119300.00 | Monthly | 584.6468 | Mobility - Metered Taxis - R2000 | Own damage | Own Damage | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 0.000000 | 0.0 | |
5 | 145247 | 12827 | 2015-01-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 500000.00 | Monthly | 57.5412 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 3.256435 | 0.0 | |
6 | 145247 | 12827 | 2015-04-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 500000.00 | Monthly | 57.5412 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 50.474737 | 0.0 | |
7 | 145247 | 12827 | 2015-06-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 500000.00 | Monthly | 57.5412 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 35.332316 | 0.0 | |
8 | 145247 | 12827 | 2015-08-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 500000.00 | Monthly | 57.5412 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 0.000000 | 0.0 | |
9 | 145245 | 12827 | 2015-03-01 00:00:00 | True | Close Corporation | Mr | English | First National Bank | Current account | Not specified | Not specified | South Africa | Gauteng | 1459 | Rand East | Rand East | Mobility - Motor | 44069150.0 | Passenger Vehicle | 2004 | MERCEDES-BENZ | E 240 | 6.0 | 2597.0 | 130.0 | S/D | 4.0 | 6/2002 | 119300.0 | Yes | No | 119300 | More than 6 months | NaN | NaN | NaN | NaN | NaN | 5000000.00 | Monthly | 1.1508 | No excess | Passenger Liability | Passenger Liability | Comprehensive - Taxi | Motor Comprehensive | Mobility Metered Taxis: Monthly | Commercial | IFRS Constant | 1.009474 | 0.0 |
UnderwrittenCoverID | PolicyID | TransactionMonth | IsVATRegistered | Citizenship | LegalType | Title | Language | Bank | AccountType | MaritalStatus | Gender | Country | Province | PostalCode | MainCrestaZone | SubCrestaZone | ItemType | mmcode | VehicleType | RegistrationYear | make | Model | Cylinders | cubiccapacity | kilowatts | bodytype | NumberOfDoors | VehicleIntroDate | CustomValueEstimate | AlarmImmobiliser | TrackingDevice | CapitalOutstanding | NewVehicle | WrittenOff | Rebuilt | Converted | CrossBorder | NumberOfVehiclesInFleet | SumInsured | TermFrequency | CalculatedPremiumPerTerm | ExcessSelected | CoverCategory | CoverType | CoverGroup | Section | Product | StatutoryClass | StatutoryRiskType | TotalPremium | TotalClaims | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1000088 | 31528 | 389 | 2015-05-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 318300.0 | Monthly | 828.1121 | Mobility - Taxi with value more than R100 000 - R5 000 | Own Damage | Own Damage | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 726.414123 | 0.0 |
1000089 | 31528 | 389 | 2015-07-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 318300.0 | Monthly | 828.1121 | Mobility - Taxi with value more than R100 000 - R5 000 | Own Damage | Own Damage | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 726.414123 | 0.0 |
1000090 | 31520 | 389 | 2014-09-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000091 | 31520 | 389 | 2014-11-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000092 | 31520 | 389 | 2015-01-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000093 | 31520 | 389 | 2015-04-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000094 | 31520 | 389 | 2015-06-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000095 | 31520 | 389 | 2015-08-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 500000.0 | Monthly | 395.8481 | No excess | Third Party | Third Party | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 347.235175 | 0.0 |
1000096 | 31519 | 389 | 2014-07-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 5000000.0 | Monthly | 2.6391 | No excess | Passenger Liability | Passenger Liability | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 2.315000 | 0.0 |
1000097 | 31519 | 389 | 2015-02-01 00:00:00 | False | ZW | Individual | Mr | English | ABSA Bank | Savings account | Single | Male | South Africa | Western Cape | 7493 | Karoo 1 (Northeast of Cape Town) | Northeast of CT | Mobility - Motor | 4614100.0 | Passenger Vehicle | 2013 | B.A.W | SASUKA 2.7i (16 SEAT) | 4.0 | 2693.0 | 110.0 | B/S | 4.0 | 2013/01/01 12:00:00 AM | NaN | Yes | No | 0 | More than 6 months | No | No | No | NaN | NaN | 5000000.0 | Monthly | 2.6391 | No excess | Passenger Liability | Passenger Liability | Comprehensive - Taxi | Motor Comprehensive | Mobility Commercial Cover: Monthly | Commercial | IFRS Constant | 2.315000 | 0.0 |