Air Quality Profiling - Site: Takapuna

Dataset statistics

Number of variables	15
Number of observations	17359
Missing cells	25395
Missing cells (%)	9.8%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.1 MiB
Average record size in memory	310.0 B

Variable types

DateTime	1
TimeSeries	10
Unsupported	1
Categorical	3

Dataset

Description	Air Quality Data Profiling for the Research Project.
Author	Nhat Thanh, Nguyen. 🌐 Linkedin: https://www.linkedin.com/in/nnthanh
URL	https://analytics-experience.pages.dev
Copyright	(c) 🎓 AUT 🛠️ Teradata's ClearScape Analytics™ ⚡ 2024

Variable descriptions

PM10	Particulate Matter (PM10) Hourly Aggregate: µg/m³ (Micrograms per cubic metre).
PM2.5	Particulate Matter (PM2.5) Hourly Aggregate: µg/m³ (Micrograms per cubic metre).
SO2	Sulfur Dioxide (SO2) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)
NO	Nitric Oxide (NO) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)
NO2	Nitrogen Dioxide (NO2) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)
NOx	Nitrogen Oxide (NOx) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)
CO	Carbon Monoxide (CO) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)
AQI	AQI.Air Quality Index (AQI)
Wind_Speed	Wind Speed Hourly Aggregate: m/s (Metres per second)
Wind_Dir	Wind Direction Hourly Aggregate: ° (Degrees)
Air_Temp	Air Temperature Hourly Aggregate: °C (Celsius)
Rel_Humidity	Relative Humidity Hourly Aggregate: % (Percent)
Solar_Rad	Solar Radiation Hourly Aggregate: W/m² (Watts per square metre)

Timeseries statistics

Number of series	10
Time series length	17359
Starting point	2020-05-07 17:00:00
Ending point	2022-04-30 23:00:00
Period	1 hour

Original
Scaled

Alerts

`Site` has constant value ""	Constant
`Site_Class` has constant value ""	Constant
`Country` has constant value ""	Constant
`PM10` has 780 (4.5%) missing values	Missing
`PM2.5` has 1552 (8.9%) missing values	Missing
`SO2` has 17359 (100.0%) missing values	Missing
`NO` has 1172 (6.8%) missing values	Missing
`NO2` has 1174 (6.8%) missing values	Missing
`NOx` has 1172 (6.8%) missing values	Missing
`Wind_Speed` has 586 (3.4%) missing values	Missing
`Wind_Dir` has 588 (3.4%) missing values	Missing
`Air_Temp` has 574 (3.3%) missing values	Missing
`Rel_Humidity` has 438 (2.5%) missing values	Missing
`AQI` is non stationary	Non stationary
`PM10` is non stationary	Non stationary
`PM2.5` is non stationary	Non stationary
`NO` is non stationary	Non stationary
`NO2` is non stationary	Non stationary
`NOx` is non stationary	Non stationary
`Wind_Speed` is non stationary	Non stationary
`Wind_Dir` is non stationary	Non stationary
`Air_Temp` is non stationary	Non stationary
`Rel_Humidity` is non stationary	Non stationary
`AQI` is seasonal	Seasonal
`PM10` is seasonal	Seasonal
`PM2.5` is seasonal	Seasonal
`NO` is seasonal	Seasonal
`NO2` is seasonal	Seasonal
`NOx` is seasonal	Seasonal
`Wind_Speed` is seasonal	Seasonal
`Wind_Dir` is seasonal	Seasonal
`Air_Temp` is seasonal	Seasonal
`Rel_Humidity` is seasonal	Seasonal
`Timestamp` has unique values	Unique
`SO2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2024-05-02 03:33:14.217676
Analysis finished	2024-05-02 03:34:13.147928
Duration	58.93 seconds
Software version	ydata-profiling vv4.7.0
Download configuration	config.json

Timestamp
Date

UNIQUE

Distinct	17359
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	271.2 KiB

Minimum	2020-05-07 17:00:00
Maximum	2022-04-30 23:00:00

Histogram

Histogram with fixed size bins (bins=50)

AQI
Numeric time series

NON STATIONARY SEASONAL

AQI.Air Quality Index (AQI)

Distinct	101
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	25.152947
Minimum	-13
Maximum	318
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	-13
5-th percentile	12
Q1	19
median	24
Q3	30
95-th percentile	43
Maximum	318
Range	331
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	10.637321
Coefficient of variation (CV)	0.42290558
Kurtosis	41.399932
Mean	25.152947
Median Absolute Deviation (MAD)	5
Skewness	2.9534942
Sum	436630
Variance	113.15261
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	2.844388657 × 10^-23

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	0
min	0
max	0
mean	0
std	0

Value	Count	Frequency (%)
24	978	5.6%
21	964	5.6%
23	961	5.5%
22	942	5.4%
19	880	5.1%
20	869	5.0%
25	805	4.6%
26	794	4.6%
27	771	4.4%
18	713	4.1%
Other values (91)	8682	50.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13	1	< 0.1%
1	4	< 0.1%
2	21	0.1%
3	47	0.3%
4	253	1.5%
5	28	0.2%
6	31	0.2%
7	31	0.2%
8	25	0.1%
9	66	0.4%

Value	Count	Frequency (%)
318	1	< 0.1%
107	8	< 0.1%
106	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
103	2	< 0.1%
102	4	< 0.1%
101	5	< 0.1%
100	5	< 0.1%
99	6	< 0.1%

ACF and PACF

PM10
Numeric time series

MISSING NON STATIONARY SEASONAL

Particulate Matter (PM10) Hourly Aggregate: µg/m³ (Micrograms per cubic metre).

Distinct	751
Distinct (%)	4.5%
Missing	780
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%

Mean	11.590983
Minimum	-3.8
Maximum	437.25
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	-3.8
5-th percentile	3.65
Q1	7.4
median	10.65
Q3	14.5
95-th percentile	21.9
Maximum	437.25
Range	441.05
Interquartile range (IQR)	7.1

Descriptive statistics

Standard deviation	7.9112508
Coefficient of variation (CV)	0.68253496
Kurtosis	653.26835
Mean	11.590983
Median Absolute Deviation (MAD)	3.5
Skewness	15.863146
Sum	192166.9
Variance	62.587889
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	2.738818348 × 10^-26

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	191
min	3 hours
max	1 week, 3 days and 8 hours
mean	5 hours, 5 minutes and 2.14 seconds
std	17 hours, 55 minutes and 51.9 seconds

Value	Count	Frequency (%)
10.8	81	0.5%
10.15	80	0.5%
11.2	79	0.5%
8.25	78	0.4%
10.35	78	0.4%
11.45	77	0.4%
11	76	0.4%
8.2	75	0.4%
9.35	74	0.4%
8.45	74	0.4%
Other values (741)	15807	91.1%
(Missing)	780	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3.8	1	< 0.1%
-3	1	< 0.1%
-2.8	1	< 0.1%
-2.55	1	< 0.1%
-2.25	1	< 0.1%
-2	1	< 0.1%
-1.95	1	< 0.1%
-1.85	1	< 0.1%
-1.8	1	< 0.1%
-1.6	2	< 0.1%

Value	Count	Frequency (%)
437.25	1	< 0.1%
251	1	< 0.1%
250.3	1	< 0.1%
200.4	1	< 0.1%
161.7	1	< 0.1%
156.5	1	< 0.1%
151.9	1	< 0.1%
110.75	1	< 0.1%
110.25	1	< 0.1%
107.95	1	< 0.1%

ACF and PACF

PM2.5
Numeric time series

MISSING NON STATIONARY SEASONAL

Particulate Matter (PM2.5) Hourly Aggregate: µg/m³ (Micrograms per cubic metre).

Distinct	495
Distinct (%)	3.1%
Missing	1552
Missing (%)	8.9%
Infinite	0
Infinite (%)	0.0%

Mean	6.2512748
Minimum	0.45
Maximum	52.3
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	0.45
5-th percentile	2.7
Q1	4.25
median	5.55
Q3	7.35
95-th percentile	11.735
Maximum	52.3
Range	51.85
Interquartile range (IQR)	3.1

Descriptive statistics

Standard deviation	3.5070778
Coefficient of variation (CV)	0.56101803
Kurtosis	25.249437
Mean	6.2512748
Median Absolute Deviation (MAD)	1.5
Skewness	3.6247507
Sum	98813.9
Variance	12.299595
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	5.108370382 × 10^-21

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	51
min	3 hours
max	4 weeks and 17 hours
mean	1 day, 7 hours and 25 minutes
std	4 days, 5 hours and 40 minutes

Value	Count	Frequency (%)
4.95	178	1.0%
5.4	176	1.0%
4.5	172	1.0%
4.55	171	1.0%
4.9	171	1.0%
3.9	168	1.0%
4.7	167	1.0%
4.35	163	0.9%
5.45	163	0.9%
4.4	163	0.9%
Other values (485)	14115	81.3%
(Missing)	1552	8.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.45	1	< 0.1%
0.55	2	< 0.1%
0.6	3	< 0.1%
0.65	2	< 0.1%
0.7	2	< 0.1%
0.75	1	< 0.1%
0.8	3	< 0.1%
0.85	4	< 0.1%
0.9	2	< 0.1%
0.95	8	< 0.1%

Value	Count	Frequency (%)
52.3	1	< 0.1%
51.9	1	< 0.1%
50.15	1	< 0.1%
49.05	1	< 0.1%
47.45	1	< 0.1%
46.5	1	< 0.1%
45.65	1	< 0.1%
44.75	1	< 0.1%
42.05	1	< 0.1%
41.9	1	< 0.1%

ACF and PACF

SO2
Unsupported

MISSING REJECTED UNSUPPORTED

Sulfur Dioxide (SO2) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)

Missing	17359
Missing (%)	100.0%
Memory size	271.2 KiB

NO
Numeric time series

MISSING NON STATIONARY SEASONAL

Nitric Oxide (NO) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)

Distinct	1481
Distinct (%)	9.1%
Missing	1172
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%

Mean	12.005912
Minimum	-0.8
Maximum	352.45
Zeros	44
Zeros (%)	0.3%
Memory size	271.2 KiB

Quantile statistics

Minimum	-0.8
5-th percentile	0.45
Q1	2.45
median	5.85
Q3	12.2
95-th percentile	43.205
Maximum	352.45
Range	353.25
Interquartile range (IQR)	9.75

Descriptive statistics

Standard deviation	22.592626
Coefficient of variation (CV)	1.8817917
Kurtosis	50.006018
Mean	12.005912
Median Absolute Deviation (MAD)	4.1
Skewness	5.9781124
Sum	194339.7
Variance	510.42674
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	1.553145987 × 10^-22

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	394
min	3 hours
max	6 days and 13 hours
mean	3 hours, 58 minutes and 29.26 seconds
std	9 hours, 18 minutes and 28.29 seconds

Value	Count	Frequency (%)
0.55	102	0.6%
0.65	97	0.6%
1.5	94	0.5%
1.65	90	0.5%
0.75	88	0.5%
1.1	87	0.5%
0.85	87	0.5%
2.4	87	0.5%
1.6	87	0.5%
2.2	87	0.5%
Other values (1471)	15281	88.0%
(Missing)	1172	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.8	1	< 0.1%
-0.65	1	< 0.1%
-0.6	2	< 0.1%
-0.5	8	< 0.1%
-0.45	8	< 0.1%
-0.4	7	< 0.1%
-0.35	13	0.1%
-0.3	17	0.1%
-0.25	23	0.1%
-0.2	22	0.1%

Value	Count	Frequency (%)
352.45	1	< 0.1%
344.1	1	< 0.1%
321.25	1	< 0.1%
321.05	1	< 0.1%
310.3	1	< 0.1%
302.05	1	< 0.1%
283.65	1	< 0.1%
274.5	1	< 0.1%
273.2	1	< 0.1%
267.1	1	< 0.1%

ACF and PACF

NO2
Numeric time series

MISSING NON STATIONARY SEASONAL

Nitrogen Dioxide (NO2) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)

Distinct	1037
Distinct (%)	6.4%
Missing	1174
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%

Mean	0.012416345
Minimum	-0.0005
Maximum	0.0721
Zeros	41
Zeros (%)	0.2%
Memory size	271.2 KiB

Quantile statistics

Minimum	-0.0005
5-th percentile	0.00095
Q1	0.004
median	0.0091
Q3	0.0177
95-th percentile	0.03525
Maximum	0.0721
Range	0.0726
Interquartile range (IQR)	0.0137

Descriptive statistics

Standard deviation	0.010950926
Coefficient of variation (CV)	0.88197658
Kurtosis	1.5221271
Mean	0.012416345
Median Absolute Deviation (MAD)	0.006
Skewness	1.3192932
Sum	200.95855
Variance	0.00011992278
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	2.337068916 × 10^-15

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	395
min	3 hours
max	6 days and 13 hours
mean	3 hours, 58 minutes and 20.49 seconds
std	9 hours, 17 minutes and 46.12 seconds

Value	Count	Frequency (%)
0.00255	73	0.4%
0.00315	72	0.4%
0.00285	65	0.4%
0.00245	64	0.4%
0.00345	64	0.4%
0.0025	62	0.4%
0.00235	62	0.4%
0.006	62	0.4%
0.0016	61	0.4%
0.00295	61	0.4%
Other values (1027)	15539	89.5%
(Missing)	1174	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.0005	1	< 0.1%
-0.00045	1	< 0.1%
-0.0004	4	< 0.1%
-0.00035	3	< 0.1%
-0.0003	5	< 0.1%
-0.00025	14	0.1%
-0.0002	27	0.2%
-0.00015	35	0.2%
-0.0001	40	0.2%
-5 × 10^-5	49	0.3%

Value	Count	Frequency (%)
0.0721	1	< 0.1%
0.06845	1	< 0.1%
0.06095	1	< 0.1%
0.0609	1	< 0.1%
0.06085	1	< 0.1%
0.06035	1	< 0.1%
0.0602	1	< 0.1%
0.0596	1	< 0.1%
0.05925	1	< 0.1%
0.0589	1	< 0.1%

ACF and PACF

NOx
Numeric time series

MISSING NON STATIONARY SEASONAL

Nitrogen Oxide (NOx) Hourly Aggregate: µg/m³ (Micrograms per cubic metre)

Distinct	2094
Distinct (%)	12.9%
Missing	1172
Missing (%)	6.8%
Infinite	0
Infinite (%)	0.0%

Mean	24.203614
Minimum	-0.7
Maximum	401.95
Zeros	26
Zeros (%)	0.1%
Memory size	271.2 KiB

Quantile statistics

Minimum	-0.7
5-th percentile	1.55
Q1	7.05
median	15.1
Q3	29.4
95-th percentile	76.15
Maximum	401.95
Range	402.65
Interquartile range (IQR)	22.35

Descriptive statistics

Standard deviation	30.662867
Coefficient of variation (CV)	1.2668714
Kurtosis	25.087571
Mean	24.203614
Median Absolute Deviation (MAD)	9.75
Skewness	4.0051517
Sum	391783.9
Variance	940.21142
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	7.145833349 × 10^-19

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	394
min	3 hours
max	6 days and 13 hours
mean	3 hours, 58 minutes and 29.26 seconds
std	9 hours, 18 minutes and 28.29 seconds

Value	Count	Frequency (%)
5.75	45	0.3%
2.05	41	0.2%
2.55	41	0.2%
8.55	40	0.2%
8.15	39	0.2%
3.2	39	0.2%
3	38	0.2%
3.55	38	0.2%
3.3	38	0.2%
2.95	38	0.2%
Other values (2084)	15790	91.0%
(Missing)	1172	6.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.7	1	< 0.1%
-0.55	1	< 0.1%
-0.5	1	< 0.1%
-0.45	7	< 0.1%
-0.4	5	< 0.1%
-0.35	9	0.1%
-0.3	12	0.1%
-0.25	11	0.1%
-0.2	17	0.1%
-0.15	20	0.1%

Value	Count	Frequency (%)
401.95	1	< 0.1%
380.85	1	< 0.1%
373.25	1	< 0.1%
371.2	1	< 0.1%
362.4	1	< 0.1%
359.45	1	< 0.1%
325.85	1	< 0.1%
317.75	1	< 0.1%
312.95	1	< 0.1%
311.15	1	< 0.1%

ACF and PACF

Wind_Speed
Numeric time series

MISSING NON STATIONARY SEASONAL

Wind Speed Hourly Aggregate: m/s (Metres per second)

Distinct	149
Distinct (%)	0.9%
Missing	586
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%

Mean	2.5017916
Minimum	0.2
Maximum	7.8
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	0.2
5-th percentile	0.6
Q1	1.25
median	2.3
Q3	3.5
95-th percentile	5.25
Maximum	7.8
Range	7.6
Interquartile range (IQR)	2.25

Descriptive statistics

Standard deviation	1.4684648
Coefficient of variation (CV)	0.58696528
Kurtosis	-0.20594329
Mean	2.5017916
Median Absolute Deviation (MAD)	1.1
Skewness	0.63330244
Sum	41962.55
Variance	2.1563888
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	3.892911556 × 10^-23

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	44
min	3 hours
max	1 week, 3 days and 8 hours
mean	14 hours, 19 minutes and 5.91 seconds
std	1 day, 17 hours and 36 minutes

Value	Count	Frequency (%)
0.7	283	1.6%
0.8	277	1.6%
0.75	275	1.6%
0.85	270	1.6%
1	264	1.5%
0.95	259	1.5%
0.9	258	1.5%
1.05	252	1.5%
0.6	242	1.4%
0.65	242	1.4%
Other values (139)	14151	81.5%
(Missing)	586	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2	3	< 0.1%
0.25	16	0.1%
0.3	40	0.2%
0.35	83	0.5%
0.4	106	0.6%
0.45	149	0.9%
0.5	184	1.1%
0.55	204	1.2%
0.6	242	1.4%
0.65	242	1.4%

Value	Count	Frequency (%)
7.8	1	< 0.1%
7.6	1	< 0.1%
7.5	1	< 0.1%
7.45	3	< 0.1%
7.4	3	< 0.1%
7.35	2	< 0.1%
7.3	1	< 0.1%
7.25	4	< 0.1%
7.2	8	< 0.1%
7.15	4	< 0.1%

ACF and PACF

Wind_Dir
Numeric time series

MISSING NON STATIONARY SEASONAL

Wind Direction Hourly Aggregate: ° (Degrees)

Distinct	656
Distinct (%)	3.9%
Missing	588
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%

Mean	176.33513
Minimum	5.5
Maximum	346.5
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	5.5
5-th percentile	36.25
Q1	75.5
median	205
Q3	261
95-th percentile	293
Maximum	346.5
Range	341
Interquartile range (IQR)	185.5

Descriptive statistics

Standard deviation	93.196025
Coefficient of variation (CV)	0.52851649
Kurtosis	-1.4897823
Mean	176.33513
Median Absolute Deviation (MAD)	72
Skewness	-0.27770661
Sum	2957316.5
Variance	8685.4991
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	5.523234394 × 10^-21

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	45
min	3 hours
max	1 week, 3 days and 8 hours
mean	14 hours and 4 minutes
std	1 day, 17 hours and 9 minutes

Value	Count	Frequency (%)
266.5	84	0.5%
268.5	83	0.5%
267	80	0.5%
263	80	0.5%
265	78	0.4%
273	78	0.4%
257	77	0.4%
265.5	76	0.4%
261	74	0.4%
266	72	0.4%
Other values (646)	15989	92.1%
(Missing)	588	3.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.5	1	< 0.1%
6.5	1	< 0.1%
7	1	< 0.1%
7.5	1	< 0.1%
8	2	< 0.1%
8.5	1	< 0.1%
9.5	1	< 0.1%
10	5	< 0.1%
10.5	3	< 0.1%
11	4	< 0.1%

Value	Count	Frequency (%)
346.5	1	< 0.1%
340.5	1	< 0.1%
339.5	1	< 0.1%
336.5	2	< 0.1%
336	1	< 0.1%
335.5	1	< 0.1%
335	1	< 0.1%
334.5	3	< 0.1%
331.5	3	< 0.1%
331	2	< 0.1%

ACF and PACF

Air_Temp
Numeric time series

MISSING NON STATIONARY SEASONAL

Air Temperature Hourly Aggregate: °C (Celsius)

Distinct	48
Distinct (%)	0.3%
Missing	574
Missing (%)	3.3%
Infinite	0
Infinite (%)	0.0%

Mean	16.280548
Minimum	3.5
Maximum	27
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	3.5
5-th percentile	9.6
Q1	13.5
median	16
Q3	19.5
95-th percentile	22.5
Maximum	27
Range	23.5
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.9599618
Coefficient of variation (CV)	0.24323271
Kurtosis	-0.44748261
Mean	16.280548
Median Absolute Deviation (MAD)	3
Skewness	-0.14746909
Sum	273269
Variance	15.681298
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	0.0002585377706

Histogram with fixed size bins (bins=48)

Gap statistics

number of gaps	41
min	3 hours
max	1 week, 3 days and 8 hours
mean	15 hours
std	1 day, 19 hours and 3 minutes

Value	Count	Frequency (%)
15	1017	5.9%
14	1012	5.8%
20	905	5.2%
16	854	4.9%
19	820	4.7%
13	775	4.5%
17	769	4.4%
18	765	4.4%
21	637	3.7%
15.5	618	3.6%
Other values (38)	8613	49.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.5	1	< 0.1%
4	22	0.1%
4.5	11	0.1%
5	24	0.1%
5.5	15	0.1%
6	30	0.2%
6.5	31	0.2%
7	70	0.4%
7.5	60	0.3%
8	102	0.6%

Value	Count	Frequency (%)
27	2	< 0.1%
26.5	2	< 0.1%
26	14	0.1%
25.5	26	0.1%
25	47	0.3%
24.5	58	0.3%
24	142	0.8%
23.5	127	0.7%
23	313	1.8%
22.5	236	1.4%

ACF and PACF

Rel_Humidity
Numeric time series

MISSING NON STATIONARY SEASONAL

Relative Humidity Hourly Aggregate: % (Percent)

Distinct	1036
Distinct (%)	6.1%
Missing	438
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%

Mean	69.909931
Minimum	30.4
Maximum	90.35
Zeros	0
Zeros (%)	0.0%
Memory size	271.2 KiB

Quantile statistics

Minimum	30.4
5-th percentile	48.9
Q1	61.25
median	71.05
Q3	79.85
95-th percentile	86.55
Maximum	90.35
Range	59.95
Interquartile range (IQR)	18.6

Descriptive statistics

Standard deviation	11.804317
Coefficient of variation (CV)	0.16885036
Kurtosis	-0.70954466
Mean	69.909931
Median Absolute Deviation (MAD)	9.2
Skewness	-0.3925148
Sum	1182945.9
Variance	139.34191
Monotonicity	Not monotonic
Augmented Dickey-Fuller test p-value	3.099069947 × 10^-17

Histogram with fixed size bins (bins=50)

Gap statistics

number of gaps	37
min	3 hours
max	1 week, 3 days and 8 hours
mean	12 hours, 50 minutes and 16.43 seconds
std	1 day, 16 hours and 51 minutes

Value	Count	Frequency (%)
84.2	39	0.2%
79.95	36	0.2%
81.65	36	0.2%
80.3	36	0.2%
77.75	35	0.2%
82.55	35	0.2%
74	34	0.2%
84.15	34	0.2%
82.7	34	0.2%
81	34	0.2%
Other values (1026)	16568	95.4%
(Missing)	438	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30.4	1	< 0.1%
32	1	< 0.1%
32.05	1	< 0.1%
32.65	1	< 0.1%
33.15	1	< 0.1%
34.4	1	< 0.1%
34.8	1	< 0.1%
35.45	1	< 0.1%
35.6	1	< 0.1%
36.2	1	< 0.1%

Value	Count	Frequency (%)
90.35	1	< 0.1%
90.15	2	< 0.1%
89.95	1	< 0.1%
89.9	1	< 0.1%
89.85	4	< 0.1%
89.8	3	< 0.1%
89.75	4	< 0.1%
89.7	3	< 0.1%
89.65	2	< 0.1%
89.6	4	< 0.1%

ACF and PACF

Site
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

Takapuna	17359

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	138872
Distinct characters	6
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	Takapuna
2nd row	Takapuna
3rd row	Takapuna
4th row	Takapuna
5th row	Takapuna

Common Values

Value	Count	Frequency (%)
Takapuna	17359	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
takapuna	17359	100.0%

Most occurring characters

Value	Count	Frequency (%)
a	52077	37.5%
T	17359	12.5%
k	17359	12.5%
p	17359	12.5%
u	17359	12.5%
n	17359	12.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	138872	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	52077	37.5%
T	17359	12.5%
k	17359	12.5%
p	17359	12.5%
u	17359	12.5%
n	17359	12.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	138872	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	52077	37.5%
T	17359	12.5%
k	17359	12.5%
p	17359	12.5%
u	17359	12.5%
n	17359	12.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	138872	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	52077	37.5%
T	17359	12.5%
k	17359	12.5%
p	17359	12.5%
u	17359	12.5%
n	17359	12.5%

Site_Class
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

Urban Background	17359

Length

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

Characters and Unicode

Total characters	277744
Distinct characters	13
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	Urban Background
2nd row	Urban Background
3rd row	Urban Background
4th row	Urban Background
5th row	Urban Background

Common Values

Value	Count	Frequency (%)
Urban Background	17359	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
urban	17359	50.0%
background	17359	50.0%

Most occurring characters

Value	Count	Frequency (%)
r	34718	12.5%
a	34718	12.5%
n	34718	12.5%
U	17359	6.2%
b	17359	6.2%
	17359	6.2%
B	17359	6.2%
c	17359	6.2%
k	17359	6.2%
g	17359	6.2%
Other values (3)	52077	18.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	277744	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
r	34718	12.5%
a	34718	12.5%
n	34718	12.5%
U	17359	6.2%
b	17359	6.2%
	17359	6.2%
B	17359	6.2%
c	17359	6.2%
k	17359	6.2%
g	17359	6.2%
Other values (3)	52077	18.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	277744	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
r	34718	12.5%
a	34718	12.5%
n	34718	12.5%
U	17359	6.2%
b	17359	6.2%
	17359	6.2%
B	17359	6.2%
c	17359	6.2%
k	17359	6.2%
g	17359	6.2%
Other values (3)	52077	18.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	277744	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
r	34718	12.5%
a	34718	12.5%
n	34718	12.5%
U	17359	6.2%
b	17359	6.2%
	17359	6.2%
B	17359	6.2%
c	17359	6.2%
k	17359	6.2%
g	17359	6.2%
Other values (3)	52077	18.8%

Country
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

New Zealand	17359

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	190949
Distinct characters	9
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	New Zealand
2nd row	New Zealand
3rd row	New Zealand
4th row	New Zealand
5th row	New Zealand

Common Values

Value	Count	Frequency (%)
New Zealand	17359	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
new	17359	50.0%
zealand	17359	50.0%

Most occurring characters

Value	Count	Frequency (%)
e	34718	18.2%
a	34718	18.2%
N	17359	9.1%
w	17359	9.1%
	17359	9.1%
Z	17359	9.1%
l	17359	9.1%
n	17359	9.1%
d	17359	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	190949	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	34718	18.2%
a	34718	18.2%
N	17359	9.1%
w	17359	9.1%
	17359	9.1%
Z	17359	9.1%
l	17359	9.1%
n	17359	9.1%
d	17359	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	190949	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	34718	18.2%
a	34718	18.2%
N	17359	9.1%
w	17359	9.1%
	17359	9.1%
Z	17359	9.1%
l	17359	9.1%
n	17359	9.1%
d	17359	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	190949	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	34718	18.2%
a	34718	18.2%
N	17359	9.1%
w	17359	9.1%
	17359	9.1%
Z	17359	9.1%
l	17359	9.1%
n	17359	9.1%
d	17359	9.1%

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.

First rows
Last rows

	Timestamp	AQI	PM10	PM2.5	SO2	NO	NO2	NOx	Wind_Speed	Wind_Dir	Air_Temp	Rel_Humidity	Site	Site_Class	Country
2020-05-07 17:00:00	2020-05-07 17:00:00	21.0	5.95	4.15	NaN	10.90	0.01715	28.00	2.50	242.0	15.5	68.15	Takapuna	Urban Background	New Zealand
2020-05-07 18:00:00	2020-05-07 18:00:00	21.0	5.65	5.10	NaN	8.20	0.01655	24.70	2.20	239.5	15.5	61.75	Takapuna	Urban Background	New Zealand
2020-05-07 19:00:00	2020-05-07 19:00:00	21.0	7.70	5.45	NaN	5.75	0.01325	19.00	2.10	244.0	15.0	59.45	Takapuna	Urban Background	New Zealand
2020-05-07 20:00:00	2020-05-07 20:00:00	21.0	8.20	5.45	NaN	3.50	0.00870	12.20	2.25	251.0	15.0	59.25	Takapuna	Urban Background	New Zealand
2020-05-07 21:00:00	2020-05-07 21:00:00	21.0	11.80	5.80	NaN	3.55	0.00930	12.90	2.10	261.0	15.0	61.75	Takapuna	Urban Background	New Zealand
2020-05-07 22:00:00	2020-05-07 22:00:00	20.0	11.05	5.95	NaN	3.75	0.01095	14.80	2.05	274.0	15.0	63.40	Takapuna	Urban Background	New Zealand
2020-05-07 23:00:00	2020-05-07 23:00:00	19.0	9.10	5.30	NaN	3.00	0.01000	13.05	1.85	273.0	14.5	63.95	Takapuna	Urban Background	New Zealand
2020-05-08 00:00:00	2020-05-08 00:00:00	19.0	12.05	4.20	NaN	1.90	0.00585	7.75	1.90	258.0	14.0	67.35	Takapuna	Urban Background	New Zealand
2020-05-08 01:00:00	2020-05-08 01:00:00	19.0	12.65	2.90	NaN	1.00	0.00275	3.75	2.30	253.5	14.0	74.65	Takapuna	Urban Background	New Zealand
2020-05-08 02:00:00	2020-05-08 02:00:00	18.0	6.00	2.50	NaN	1.35	0.00260	3.95	2.50	260.0	14.0	79.10	Takapuna	Urban Background	New Zealand

	Timestamp	AQI	PM10	PM2.5	SO2	NO	NO2	NOx	Wind_Speed	Wind_Dir	Air_Temp	Rel_Humidity	Site	Site_Class	Country
2022-04-30 14:00:00	2022-04-30 14:00:00	15.0	7.55	3.00	NaN	1.10	0.00325	4.45	3.85	117.5	18.0	65.35	Takapuna	Urban Background	New Zealand
2022-04-30 15:00:00	2022-04-30 15:00:00	15.0	8.30	2.70	NaN	1.10	0.00325	4.40	3.85	117.5	17.5	68.30	Takapuna	Urban Background	New Zealand
2022-04-30 16:00:00	2022-04-30 16:00:00	14.0	5.35	2.55	NaN	1.20	0.00390	5.10	3.40	115.0	17.0	70.15	Takapuna	Urban Background	New Zealand
2022-04-30 17:00:00	2022-04-30 17:00:00	14.0	5.85	2.85	NaN	1.05	0.00470	5.70	3.10	117.0	16.5	72.45	Takapuna	Urban Background	New Zealand
2022-04-30 18:00:00	2022-04-30 18:00:00	14.0	5.90	3.25	NaN	0.75	0.00505	5.75	2.80	119.5	16.0	76.05	Takapuna	Urban Background	New Zealand
2022-04-30 19:00:00	2022-04-30 19:00:00	14.0	4.75	3.30	NaN	0.60	0.00440	5.00	2.55	109.5	16.0	76.05	Takapuna	Urban Background	New Zealand
2022-04-30 20:00:00	2022-04-30 20:00:00	14.0	6.35	3.15	NaN	0.50	0.00365	4.15	2.45	105.5	16.0	74.50	Takapuna	Urban Background	New Zealand
2022-04-30 21:00:00	2022-04-30 21:00:00	14.0	6.05	2.80	NaN	0.40	0.00480	5.20	2.35	115.5	16.0	74.15	Takapuna	Urban Background	New Zealand
2022-04-30 22:00:00	2022-04-30 22:00:00	13.0	4.20	2.60	NaN	0.40	0.00555	5.90	1.95	122.5	16.0	75.95	Takapuna	Urban Background	New Zealand
2022-04-30 23:00:00	2022-04-30 23:00:00	13.0	5.00	2.80	NaN	0.35	0.00405	4.30	1.95	119.0	16.0	78.00	Takapuna	Urban Background	New Zealand

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Missing values

Sample