# Overview

Brought to you by YData

Dataset statistics

Number of variables | 17
Number of observations | 3501
Missing cells | 47303
Missing cells (%) | 79.5%
Duplicate rows | 0
Duplicate rows (%) | 0.0%
Total size in memory | 465.1 KiB
Average record size in memory | 136.0 B

Variable types

Text | 3
Boolean | 5
Categorical | 5
Unsupported | 3
Numeric | 1

Alerts

`solar_energy_used_for_outdoor_lighting` has constant value "Outdoor lighting" | Constant
`solar_energy_used_for_car_charging` has constant value "Agriculture equipment and systems (irrigation systems, etc)" | Constant
`aware_of_no_of_units_generated_by_solar_system` is highly overall correlated with `installed_a_solar_system_after_w1` and 1 other fields | High correlation
`capacity_of_the_solar_system` is highly overall correlated with `installed_a_solar_system_after_w1` and 2 other fields | High correlation
`had_solar_energy_when_w1_was_done` is highly overall correlated with `increased_or_decreased_no_of_panels_after_w1` and 2 other fields | High correlation
`increased_or_decreased_no_of_panels_after_w1` is highly overall correlated with `had_solar_energy_when_w1_was_done` and 1 other fields | High correlation
`installed_a_solar_system_after_w1` is highly overall correlated with `aware_of_no_of_units_generated_by_solar_system` and 5 other fields | High correlation
`solar_energy_used_for_cooking` is highly overall correlated with `capacity_of_the_solar_system` and 2 other fields | High correlation
`solar_energy_used_for_water_heating` is highly overall correlated with `installed_a_solar_system_after_w1` and 2 other fields | High correlation
`solar_system_inverter_or_non_inverter` is highly overall correlated with `installed_a_solar_system_after_w1` and 1 other fields | High correlation
`solar_system_ongrid_or_offgrid` is highly overall correlated with `installed_a_solar_system_after_w1` and 3 other fields | High correlation
`still_have_the_solar_system_from_w1` is highly overall correlated with `aware_of_no_of_units_generated_by_solar_system` and 7 other fields | High correlation
`had_solar_energy_when_w1_was_done` is highly imbalanced (58.4%) | Imbalance
`installed_a_solar_system_after_w1` is highly imbalanced (89.4%) | Imbalance
`still_have_the_solar_system_from_w1` is highly imbalanced (55.7%) | Imbalance
`increased_or_decreased_no_of_panels_after_w1` is highly imbalanced (80.6%) | Imbalance
`installed_a_solar_system_after_w1` has 294 (8.4%) missing values | Missing
`still_have_the_solar_system_from_w1` has 3207 (91.6%) missing values | Missing
`increased_or_decreased_no_of_panels_after_w1` has 3234 (92.4%) missing values | Missing
`solar_system_ongrid_or_offgrid` has 3189 (91.1%) missing values | Missing
`solar_system_inverter_or_non_inverter` has 3189 (91.1%) missing values | Missing
`solar_energy_used_for_water_heating` has 3457 (98.7%) missing values | Missing
`solar_energy_used_for_cooking` has 3489 (99.7%) missing values | Missing
`solar_energy_used_for_outdoor_lighting` has 3497 (99.9%) missing values | Missing
`solar_energy_used_for_car_charging` has 3500 (> 99.9%) missing values | Missing
`solar_energy_used_for_agricultural_systems` has 3501 (100.0%) missing values | Missing
`solar_energy_used_for_all_above` has 3501 (100.0%) missing values | Missing
`solar_energy_used_for_other_purposes` has 3501 (100.0%) missing values | Missing
`aware_of_no_of_units_generated_by_solar_system` has 3189 (91.1%) missing values | Missing
`no_of_units_generated_last_month` has 3365 (96.1%) missing values | Missing
`capacity_of_the_solar_system` has 3189 (91.1%) missing values | Missing
`solar_energy_used_for_agricultural_systems` is an unsupported type, check if it needs cleaning or further analysis | Unsupported
`solar_energy_used_for_all_above` is an unsupported type, check if it needs cleaning or further analysis | Unsupported
`solar_energy_used_for_other_purposes` is an unsupported type, check if it needs cleaning or further analysis | Unsupported
`capacity_of_the_solar_system` has 124 (3.5%) zeros | Zeros

Reproduction

Analysis started | 2025-02-27 04:40:54.832842
Analysis finished | 2025-02-27 04:40:56.040360
Duration | 1.21 second
Software version | ydata-profiling vv4.11.0
Download configuration | config.json

# Variables

household_ID
Text

Distinct | 3500
Distinct (%) | 100.0%
Missing | 1
Missing (%) | < 0.1%
Memory size | 27.5 KiB

Length

Max length | 6
Median length | 6
Mean length | 6
Min length | 6

Characters and Unicode

Total characters | 21000
Distinct characters | 12
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 3500 ?
Unique (%) | 100.0%

Sample

1st row | ID2464
2nd row | ID0430
3rd row | ID0424
4th row | ID0528
5th row | ID0427

Value | Count | Frequency (%)
id0759 | 1 | < 0.1%
id0426 | 1 | < 0.1%
id2464 | 1 | < 0.1%
id0430 | 1 | < 0.1%
id0424 | 1 | < 0.1%
id0528 | 1 | < 0.1%
id0427 | 1 | < 0.1%
id0886 | 1 | < 0.1%
id0041 | 1 | < 0.1%
id0039 | 1 | < 0.1%
Other values (3490) | 3490 | 99.7%

#### Most occurring characters

Value | Count | Frequency (%)
I | 3500 | 16.7%
D | 3500 | 16.7%
0 | 1975 | 9.4%
3 | 1923 | 9.2%
2 | 1910 | 9.1%
1 | 1896 | 9.0%
4 | 1094 | 5.2%
9 | 1059 | 5.0%
5 | 1056 | 5.0%
6 | 1051 | 5.0%
Other values (2) | 2036 | 9.7%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 21000 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
I | 3500 | 16.7%
D | 3500 | 16.7%
0 | 1975 | 9.4%
3 | 1923 | 9.2%
2 | 1910 | 9.1%
1 | 1896 | 9.0%
4 | 1094 | 5.2%
9 | 1059 | 5.0%
5 | 1056 | 5.0%
6 | 1051 | 5.0%
Other values (2) | 2036 | 9.7%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 21000 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
I | 3500 | 16.7%
D | 3500 | 16.7%
0 | 1975 | 9.4%
3 | 1923 | 9.2%
2 | 1910 | 9.1%
1 | 1896 | 9.0%
4 | 1094 | 5.2%
9 | 1059 | 5.0%
5 | 1056 | 5.0%
6 | 1051 | 5.0%
Other values (2) | 2036 | 9.7%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 21000 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
I | 3500 | 16.7%
D | 3500 | 16.7%
0 | 1975 | 9.4%
3 | 1923 | 9.2%
2 | 1910 | 9.1%
1 | 1896 | 9.0%
4 | 1094 | 5.2%
9 | 1059 | 5.0%
5 | 1056 | 5.0%
6 | 1051 | 5.0%
Other values (2) | 2036 | 9.7%

had_solar_energy_when_w1_was_done
Boolean

High correlation Imbalance

Distinct | 2
Distinct (%) | 0.1%
Missing | 0
Missing (%) | 0.0%
Memory size | 3.5 KiB

False | 3207
True | 294

Value | Count | Frequency (%)
False | 3207 | 91.6%
True | 294 | 8.4%

installed_a_solar_system_after_w1
Boolean

High correlation Imbalance Missing

Distinct | 2
Distinct (%) | 0.1%
Missing | 294
Missing (%) | 8.4%
Memory size | 7.0 KiB

False | 3162
True | 45
(Missing) | 294

Value | Count | Frequency (%)
False | 3162 | 90.3%
True | 45 | 1.3%
(Missing) | 294 | 8.4%

still_have_the_solar_system_from_w1
Boolean

High correlation Imbalance Missing

Distinct | 2
Distinct (%) | 0.7%
Missing | 3207
Missing (%) | 91.6%
Memory size | 7.0 KiB

True | 267
False | 27
(Missing) | 3207

Value | Count | Frequency (%)
True | 267 | 7.6%
False | 27 | 0.8%
(Missing) | 3207 | 91.6%

increased_or_decreased_no_of_panels_after_w1
Categorical

High correlation Imbalance Missing

Distinct | 2
Distinct (%) | 0.7%
Missing | 3234
Missing (%) | 92.4%
Memory size | 27.5 KiB

No, we have not done any changes to the number of panels | 259
Yes, we have increased the number of panels | 8

Length

Max length | 56
Median length | 56
Mean length | 55.610487
Min length | 43

Characters and Unicode

Total characters | 14848
Distinct characters | 25
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 0 ?
Unique (%) | 0.0%

Sample

1st row | No, we have not done any changes to the number of panels
2nd row | No, we have not done any changes to the number of panels
3rd row | No, we have not done any changes to the number of panels
4th row | No, we have not done any changes to the number of panels
5th row | No, we have not done any changes to the number of panels

#### Common Values

Value | Count | Frequency (%)
No, we have not done any changes to the number of panels | 259 | 7.4%
Yes, we have increased the number of panels | 8 | 0.2%
(Missing) | 3234 | 92.4%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
we | 267 | 8.4%
have | 267 | 8.4%
of | 267 | 8.4%
panels | 267 | 8.4%
the | 267 | 8.4%
number | 267 | 8.4%
any | 259 | 8.2%
done | 259 | 8.2%
not | 259 | 8.2%
no | 259 | 8.2%
Other values (4) | 534 | 16.8%

#### Most occurring characters

Value | Count | Frequency (%)
| 2905 | 19.6%
e | 1877 | 12.6%
n | 1578 | 10.6%
o | 1303 | 8.8%
a | 1060 | 7.1%
h | 793 | 5.3%
t | 785 | 5.3%
s | 542 | 3.7%
r | 275 | 1.9%
p | 267 | 1.8%
Other values (15) | 3463 | 23.3%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 14848 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
| 2905 | 19.6%
e | 1877 | 12.6%
n | 1578 | 10.6%
o | 1303 | 8.8%
a | 1060 | 7.1%
h | 793 | 5.3%
t | 785 | 5.3%
s | 542 | 3.7%
r | 275 | 1.9%
p | 267 | 1.8%
Other values (15) | 3463 | 23.3%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 14848 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
| 2905 | 19.6%
e | 1877 | 12.6%
n | 1578 | 10.6%
o | 1303 | 8.8%
a | 1060 | 7.1%
h | 793 | 5.3%
t | 785 | 5.3%
s | 542 | 3.7%
r | 275 | 1.9%
p | 267 | 1.8%
Other values (15) | 3463 | 23.3%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 14848 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
| 2905 | 19.6%
e | 1877 | 12.6%
n | 1578 | 10.6%
o | 1303 | 8.8%
a | 1060 | 7.1%
h | 793 | 5.3%
t | 785 | 5.3%
s | 542 | 3.7%
r | 275 | 1.9%
p | 267 | 1.8%
Other values (15) | 3463 | 23.3%

solar_system_ongrid_or_offgrid
Categorical

High correlation Missing

Distinct | 2
Distinct (%) | 0.6%
Missing | 3189
Missing (%) | 91.1%
Memory size | 27.5 KiB

On-grid | 268
Off-grid | 44

Length

Max length | 8
Median length | 7
Mean length | 7.1410256
Min length | 7

Characters and Unicode

Total characters | 2228
Distinct characters | 8
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 0 ?
Unique (%) | 0.0%

Sample

1st row | Off-grid
2nd row | Off-grid
3rd row | Off-grid
4th row | On-grid
5th row | On-grid

#### Common Values

Value | Count | Frequency (%)
On-grid | 268 | 7.7%
Off-grid | 44 | 1.3%
(Missing) | 3189 | 91.1%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
on-grid | 268 | 85.9%
off-grid | 44 | 14.1%

#### Most occurring characters

Value | Count | Frequency (%)
O | 312 | 14.0%
- | 312 | 14.0%
g | 312 | 14.0%
r | 312 | 14.0%
d | 312 | 14.0%
i | 312 | 14.0%
n | 268 | 12.0%
f | 88 | 3.9%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 2228 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
O | 312 | 14.0%
- | 312 | 14.0%
g | 312 | 14.0%
r | 312 | 14.0%
d | 312 | 14.0%
i | 312 | 14.0%
n | 268 | 12.0%
f | 88 | 3.9%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 2228 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
O | 312 | 14.0%
- | 312 | 14.0%
g | 312 | 14.0%
r | 312 | 14.0%
d | 312 | 14.0%
i | 312 | 14.0%
n | 268 | 12.0%
f | 88 | 3.9%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 2228 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
O | 312 | 14.0%
- | 312 | 14.0%
g | 312 | 14.0%
r | 312 | 14.0%
d | 312 | 14.0%
i | 312 | 14.0%
n | 268 | 12.0%
f | 88 | 3.9%

solar_system_inverter_or_non_inverter
Boolean

High correlation Missing

Distinct | 2
Distinct (%) | 0.6%
Missing | 3189
Missing (%) | 91.1%
Memory size | 7.0 KiB

True | 219
False | 93
(Missing) | 3189

Value | Count | Frequency (%)
True | 219 | 6.3%
False | 93 | 2.7%
(Missing) | 3189 | 91.1%

solar_energy_used_for_water_heating
Categorical

High correlation Missing

Distinct | 5
Distinct (%) | 11.4%
Missing | 3457
Missing (%) | 98.7%
Memory size | 27.5 KiB

Water heating | 21
Outdoor lighting | 14
Other | 6
Cooking | 2
All the above | 1

Length

Max length | 16
Median length | 14.5
Mean length | 12.590909
Min length | 5

Characters and Unicode

Total characters | 554
Distinct characters | 20
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 1 ?
Unique (%) | 2.3%

Sample

1st row | All the above
2nd row | Outdoor lighting
3rd row | Outdoor lighting
4th row | Water heating
5th row | Outdoor lighting

#### Common Values

Value | Count | Frequency (%)
Water heating | 21 | 0.6%
Outdoor lighting | 14 | 0.4%
Other | 6 | 0.2%
Cooking | 2 | 0.1%
All the above | 1 | < 0.1%
(Missing) | 3457 | 98.7%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
water | 21 | 25.9%
heating | 21 | 25.9%
outdoor | 14 | 17.3%
lighting | 14 | 17.3%
other | 6 | 7.4%
cooking | 2 | 2.5%
all | 1 | 1.2%
the | 1 | 1.2%
above | 1 | 1.2%

#### Most occurring characters

Value | Count | Frequency (%)
t | 77 | 13.9%
i | 51 | 9.2%
g | 51 | 9.2%
e | 50 | 9.0%
a | 43 | 7.8%
h | 42 | 7.6%
r | 41 | 7.4%
| 37 | 6.7%
n | 37 | 6.7%
o | 33 | 6.0%
Other values (10) | 92 | 16.6%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 554 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
t | 77 | 13.9%
i | 51 | 9.2%
g | 51 | 9.2%
e | 50 | 9.0%
a | 43 | 7.8%
h | 42 | 7.6%
r | 41 | 7.4%
| 37 | 6.7%
n | 37 | 6.7%
o | 33 | 6.0%
Other values (10) | 92 | 16.6%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 554 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
t | 77 | 13.9%
i | 51 | 9.2%
g | 51 | 9.2%
e | 50 | 9.0%
a | 43 | 7.8%
h | 42 | 7.6%
r | 41 | 7.4%
| 37 | 6.7%
n | 37 | 6.7%
o | 33 | 6.0%
Other values (10) | 92 | 16.6%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 554 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
t | 77 | 13.9%
i | 51 | 9.2%
g | 51 | 9.2%
e | 50 | 9.0%
a | 43 | 7.8%
h | 42 | 7.6%
r | 41 | 7.4%
| 37 | 6.7%
n | 37 | 6.7%
o | 33 | 6.0%
Other values (10) | 92 | 16.6%

solar_energy_used_for_cooking
Categorical

High correlation Missing

Distinct | 3
Distinct (%) | 25.0%
Missing | 3489
Missing (%) | 99.7%
Memory size | 27.5 KiB

Cooking | 6
Outdoor lighting | 5
Other | 1

Length

Max length | 16
Median length | 11.5
Mean length | 10.583333
Min length | 5

Characters and Unicode

Total characters | 127
Distinct characters | 15
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 1 ?
Unique (%) | 8.3%

Sample

1st row | Cooking
2nd row | Outdoor lighting
3rd row | Cooking
4th row | Outdoor lighting
5th row | Cooking

#### Common Values

Value | Count | Frequency (%)
Cooking | 6 | 0.2%
Outdoor lighting | 5 | 0.1%
Other | 1 | < 0.1%
(Missing) | 3489 | 99.7%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
cooking | 6 | 35.3%
outdoor | 5 | 29.4%
lighting | 5 | 29.4%
other | 1 | 5.9%

#### Most occurring characters

Value | Count | Frequency (%)
o | 22 | 17.3%
g | 16 | 12.6%
i | 16 | 12.6%
n | 11 | 8.7%
t | 11 | 8.7%
k | 6 | 4.7%
C | 6 | 4.7%
O | 6 | 4.7%
r | 6 | 4.7%
h | 6 | 4.7%
Other values (5) | 21 | 16.5%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 127 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
o | 22 | 17.3%
g | 16 | 12.6%
i | 16 | 12.6%
n | 11 | 8.7%
t | 11 | 8.7%
k | 6 | 4.7%
C | 6 | 4.7%
O | 6 | 4.7%
r | 6 | 4.7%
h | 6 | 4.7%
Other values (5) | 21 | 16.5%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 127 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
o | 22 | 17.3%
g | 16 | 12.6%
i | 16 | 12.6%
n | 11 | 8.7%
t | 11 | 8.7%
k | 6 | 4.7%
C | 6 | 4.7%
O | 6 | 4.7%
r | 6 | 4.7%
h | 6 | 4.7%
Other values (5) | 21 | 16.5%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 127 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
o | 22 | 17.3%
g | 16 | 12.6%
i | 16 | 12.6%
n | 11 | 8.7%
t | 11 | 8.7%
k | 6 | 4.7%
C | 6 | 4.7%
O | 6 | 4.7%
r | 6 | 4.7%
h | 6 | 4.7%
Other values (5) | 21 | 16.5%

solar_energy_used_for_outdoor_lighting
Categorical

Constant Missing

Distinct | 1
Distinct (%) | 25.0%
Missing | 3497
Missing (%) | 99.9%
Memory size | 27.5 KiB

Outdoor lighting | 4

Length

Max length | 16
Median length | 16
Mean length | 16
Min length | 16

Characters and Unicode

Total characters | 64
Distinct characters | 12
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 0 ?
Unique (%) | 0.0%

Sample

1st row | Outdoor lighting
2nd row | Outdoor lighting
3rd row | Outdoor lighting
4th row | Outdoor lighting

#### Common Values

Value | Count | Frequency (%)
Outdoor lighting | 4 | 0.1%
(Missing) | 3497 | 99.9%

#### Length

Histogram of lengths of the category

#### Common Values (Plot)

Value | Count | Frequency (%)
outdoor | 4 | 50.0%
lighting | 4 | 50.0%

#### Most occurring characters

Value | Count | Frequency (%)
t | 8 | 12.5%
g | 8 | 12.5%
i | 8 | 12.5%
o | 8 | 12.5%
d | 4 | 6.2%
u | 4 | 6.2%
O | 4 | 6.2%
r | 4 | 6.2%
l | 4 | 6.2%
| 4 | 6.2%
Other values (2) | 8 | 12.5%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 64 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
t | 8 | 12.5%
g | 8 | 12.5%
i | 8 | 12.5%
o | 8 | 12.5%
d | 4 | 6.2%
u | 4 | 6.2%
O | 4 | 6.2%
r | 4 | 6.2%
l | 4 | 6.2%
| 4 | 6.2%
Other values (2) | 8 | 12.5%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 64 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
t | 8 | 12.5%
g | 8 | 12.5%
i | 8 | 12.5%
o | 8 | 12.5%
d | 4 | 6.2%
u | 4 | 6.2%
O | 4 | 6.2%
r | 4 | 6.2%
l | 4 | 6.2%
| 4 | 6.2%
Other values (2) | 8 | 12.5%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 64 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
t | 8 | 12.5%
g | 8 | 12.5%
i | 8 | 12.5%
o | 8 | 12.5%
d | 4 | 6.2%
u | 4 | 6.2%
O | 4 | 6.2%
r | 4 | 6.2%
l | 4 | 6.2%
| 4 | 6.2%
Other values (2) | 8 | 12.5%

solar_energy_used_for_car_charging
Text

Constant Missing

Distinct | 1
Distinct (%) | 100.0%
Missing | 3500
Missing (%) | > 99.9%
Memory size | 27.5 KiB

Length

Max length | 59
Median length | 59
Mean length | 59
Min length | 59

Characters and Unicode

Total characters | 59
Distinct characters | 22
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 1 ?
Unique (%) | 100.0%

Sample

1st row | Agriculture equipment and systems (irrigation systems, etc)

Value | Count | Frequency (%)
systems | 2 | 28.6%
agriculture | 1 | 14.3%
equipment | 1 | 14.3%
and | 1 | 14.3%
irrigation | 1 | 14.3%
etc | 1 | 14.3%

#### Most occurring characters

Value | Count | Frequency (%)
e | 6 | 10.2%
t | 6 | 10.2%
s | 6 | 10.2%
| 6 | 10.2%
i | 5 | 8.5%
r | 4 | 6.8%
m | 3 | 5.1%
n | 3 | 5.1%
u | 3 | 5.1%
g | 2 | 3.4%
Other values (12) | 15 | 25.4%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 59 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
e | 6 | 10.2%
t | 6 | 10.2%
s | 6 | 10.2%
| 6 | 10.2%
i | 5 | 8.5%
r | 4 | 6.8%
m | 3 | 5.1%
n | 3 | 5.1%
u | 3 | 5.1%
g | 2 | 3.4%
Other values (12) | 15 | 25.4%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 59 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
e | 6 | 10.2%
t | 6 | 10.2%
s | 6 | 10.2%
| 6 | 10.2%
i | 5 | 8.5%
r | 4 | 6.8%
m | 3 | 5.1%
n | 3 | 5.1%
u | 3 | 5.1%
g | 2 | 3.4%
Other values (12) | 15 | 25.4%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 59 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
e | 6 | 10.2%
t | 6 | 10.2%
s | 6 | 10.2%
| 6 | 10.2%
i | 5 | 8.5%
r | 4 | 6.8%
m | 3 | 5.1%
n | 3 | 5.1%
u | 3 | 5.1%
g | 2 | 3.4%
Other values (12) | 15 | 25.4%

solar_energy_used_for_agricultural_systems
Unsupported

Missing Rejected Unsupported

Missing | 3501
Missing (%) | 100.0%
Memory size | 27.5 KiB

solar_energy_used_for_all_above
Unsupported

Missing Rejected Unsupported

Missing | 3501
Missing (%) | 100.0%
Memory size | 27.5 KiB

solar_energy_used_for_other_purposes
Unsupported

Missing Rejected Unsupported

Missing | 3501
Missing (%) | 100.0%
Memory size | 27.5 KiB

aware_of_no_of_units_generated_by_solar_system
Boolean

High correlation Missing

Distinct | 2
Distinct (%) | 0.6%
Missing | 3189
Missing (%) | 91.1%
Memory size | 7.0 KiB

False | 176
True | 136
(Missing) | 3189

Value | Count | Frequency (%)
False | 176 | 5.0%
True | 136 | 3.9%
(Missing) | 3189 | 91.1%

no_of_units_generated_last_month
Text

Missing

Distinct | 74
Distinct (%) | 54.4%
Missing | 3365
Missing (%) | 96.1%
Memory size | 27.5 KiB

Length

Max length | 10
Median length | 5
Mean length | 5.5661765
Min length | 4

Characters and Unicode

Total characters | 757
Distinct characters | 19
Distinct categories | 1 ?
Distinct scripts | 1 ?
Distinct blocks | 1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique | 56 ?
Unique (%) | 41.2%

Sample

1st row | 300.0
2nd row | 180.0
3rd row | 390.0
4th row | 525.0
5th row | 800.0

Value | Count | Frequency (%)
cannot | 16 | 10.5%
say | 16 | 10.5%
450.0 | 8 | 5.3%
600.0 | 8 | 5.3%
500.0 | 7 | 4.6%
300.0 | 5 | 3.3%
700.0 | 5 | 3.3%
800.0 | 5 | 3.3%
400.0 | 3 | 2.0%
550.0 | 3 | 2.0%
Other values (65) | 76 | 50.0%

#### Most occurring characters

Value | Count | Frequency (%)
0 | 235 | 31.0%
. | 120 | 15.9%
5 | 55 | 7.3%
3 | 37 | 4.9%
a | 32 | 4.2%
n | 32 | 4.2%
4 | 29 | 3.8%
2 | 27 | 3.6%
7 | 26 | 3.4%
6 | 22 | 2.9%
Other values (9) | 142 | 18.8%

#### Most occurring categories

Value | Count | Frequency (%)
(unknown) | 757 | 100.0%

#### Most frequent character per category

##### (unknown)

Value | Count | Frequency (%)
0 | 235 | 31.0%
. | 120 | 15.9%
5 | 55 | 7.3%
3 | 37 | 4.9%
a | 32 | 4.2%
n | 32 | 4.2%
4 | 29 | 3.8%
2 | 27 | 3.6%
7 | 26 | 3.4%
6 | 22 | 2.9%
Other values (9) | 142 | 18.8%

#### Most occurring scripts

Value | Count | Frequency (%)
(unknown) | 757 | 100.0%

#### Most frequent character per script

##### (unknown)

Value | Count | Frequency (%)
0 | 235 | 31.0%
. | 120 | 15.9%
5 | 55 | 7.3%
3 | 37 | 4.9%
a | 32 | 4.2%
n | 32 | 4.2%
4 | 29 | 3.8%
2 | 27 | 3.6%
7 | 26 | 3.4%
6 | 22 | 2.9%
Other values (9) | 142 | 18.8%

#### Most occurring blocks

Value | Count | Frequency (%)
(unknown) | 757 | 100.0%

#### Most frequent character per block

##### (unknown)

Value | Count | Frequency (%)
0 | 235 | 31.0%
. | 120 | 15.9%
5 | 55 | 7.3%
3 | 37 | 4.9%
a | 32 | 4.2%
n | 32 | 4.2%
4 | 29 | 3.8%
2 | 27 | 3.6%
7 | 26 | 3.4%
6 | 22 | 2.9%
Other values (9) | 142 | 18.8%

capacity_of_the_solar_system
Real number (ℝ)

High correlation Missing Zeros

Distinct | 47
Distinct (%) | 15.1%
Missing | 3189
Missing (%) | 91.1%
Infinite | 0
Infinite (%) | 0.0%
Mean | 629.54487

Minimum | 0
Maximum | 10000
Zeros | 124
Zeros (%) | 3.5%
Negative | 0
Negative (%) | 0.0%
Memory size | 27.5 KiB

Quantile statistics

Minimum | 0
5-th percentile | 0
Q1 | 0
median | 5
Q3 | 10
95-th percentile | 5000
Maximum | 10000
Range | 10000
Interquartile range (IQR) | 10

Descriptive statistics

Standard deviation | 1967.9852
Coefficient of variation (CV) | 3.1260444
Kurtosis | 10.849204
Mean | 629.54487
Median Absolute Deviation (MAD) | 5
Skewness | 3.4002332
Sum | 196418
Variance | 3872965.8
Monotonicity | Not monotonic

Histogram with fixed size bins (bins=47)

Value | Count | Frequency (%)
0 | 124 | 3.5%
5 | 56 | 1.6%
6 | 19 | 0.5%
3 | 16 | 0.5%
5000 | 11 | 0.3%
7 | 8 | 0.2%
10 | 6 | 0.2%
10000 | 4 | 0.1%
99 | 4 | 0.1%
2 | 4 | 0.1%
Other values (37) | 60 | 1.7%
(Missing) | 3189 | 91.1%

Value | Count | Frequency (%)
0 | 124 | 3.5%
2 | 4 | 0.1%
3 | 16 | 0.5%
5 | 56 | 1.6%
6 | 19 | 0.5%
7 | 8 | 0.2%
8 | 2 | 0.1%
9 | 2 | 0.1%
10 | 6 | 0.2%
12 | 2 | 0.1%

Value | Count | Frequency (%)
10000 | 4 | 0.1%
9000 | 3 | 0.1%
8000 | 3 | 0.1%
7000 | 1 | < 0.1%
6000 | 4 | 0.1%
5000 | 11 | 0.3%
3300 | 1 | < 0.1%
2000 | 2 | 0.1%
999 | 1 | < 0.1%
850 | 1 | < 0.1%

# Interactions

# Correlations

| aware_of_no_of_units_generated_by_solar_system | capacity_of_the_solar_system | had_solar_energy_when_w1_was_done | increased_or_decreased_no_of_panels_after_w1 | installed_a_solar_system_after_w1 | solar_energy_used_for_cooking | solar_energy_used_for_water_heating | solar_system_inverter_or_non_inverter | solar_system_ongrid_or_offgrid | still_have_the_solar_system_from_w1
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
aware_of_no_of_units_generated_by_solar_system | 1.000 | 0.062 | 0.000 | 0.116 | 1.000 | 0.000 | 0.278 | 0.205 | 0.229 | 1.000
capacity_of_the_solar_system | 0.062 | 1.000 | 0.047 | 0.000 | 1.000 | 0.949 | 0.000 | 0.252 | 0.167 | 1.000
had_solar_energy_when_w1_was_done | 0.000 | 0.047 | 1.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000
increased_or_decreased_no_of_panels_after_w1 | 0.116 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.063 | 0.000 | 1.000
installed_a_solar_system_after_w1 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | NaN | 1.000 | 1.000 | 1.000 | 0.000
solar_energy_used_for_cooking | 0.000 | 0.949 | 0.000 | 0.000 | NaN | 1.000 | 0.329 | 0.329 | 1.000 | 1.000
solar_energy_used_for_water_heating | 0.278 | 0.000 | 0.000 | 0.000 | 1.000 | 0.329 | 1.000 | 0.000 | 1.000 | 1.000
solar_system_inverter_or_non_inverter | 0.205 | 0.252 | 0.000 | 0.063 | 1.000 | 0.329 | 0.000 | 1.000 | 0.159 | 1.000
solar_system_ongrid_or_offgrid | 0.229 | 0.167 | 0.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.159 | 1.000 | 1.000
still_have_the_solar_system_from_w1 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000

# Missing values

A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

# Sample

| household_ID | had_solar_energy_when_w1_was_done | installed_a_solar_system_after_w1 | still_have_the_solar_system_from_w1 | increased_or_decreased_no_of_panels_after_w1 | solar_system_ongrid_or_offgrid | solar_system_inverter_or_non_inverter | solar_energy_used_for_water_heating | solar_energy_used_for_cooking | solar_energy_used_for_outdoor_lighting | solar_energy_used_for_car_charging | solar_energy_used_for_agricultural_systems | solar_energy_used_for_all_above | solar_energy_used_for_other_purposes | aware_of_no_of_units_generated_by_solar_system | no_of_units_generated_last_month | capacity_of_the_solar_system
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
0 | ID2464 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
1 | ID0430 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
2 | ID0424 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3 | ID0528 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
4 | ID0427 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
5 | ID0886 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
6 | ID0041 | Yes | NaN | Yes | No, we have not done any changes to the number of panels | Off-grid | Yes | All the above | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | 5.0
7 | ID0039 | Yes | NaN | Yes | No, we have not done any changes to the number of panels | Off-grid | Yes | Outdoor lighting | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | 5.0
8 | ID0017 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
9 | ID0033 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN

| household_ID | had_solar_energy_when_w1_was_done | installed_a_solar_system_after_w1 | still_have_the_solar_system_from_w1 | increased_or_decreased_no_of_panels_after_w1 | solar_system_ongrid_or_offgrid | solar_system_inverter_or_non_inverter | solar_energy_used_for_water_heating | solar_energy_used_for_cooking | solar_energy_used_for_outdoor_lighting | solar_energy_used_for_car_charging | solar_energy_used_for_agricultural_systems | solar_energy_used_for_all_above | solar_energy_used_for_other_purposes | aware_of_no_of_units_generated_by_solar_system | no_of_units_generated_last_month | capacity_of_the_solar_system
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
3491 | ID1084 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3492 | ID0752 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3493 | ID4061 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3494 | ID2496 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3495 | ID0320 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3496 | ID0373 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3497 | ID0160 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3498 | ID1667 | Yes | NaN | Yes | No, we have not done any changes to the number of panels | On-grid | Yes | NaN | NaN | NaN | NaN | NaN | NaN | NaN | No | NaN | 0.0
3499 | ID0589 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN
3500 | ID0426 | No | No | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN