From 47962ee624efeaec469473a5569b59bfd230babf Mon Sep 17 00:00:00 2001 From: Tibor Frank Date: Thu, 24 Mar 2022 08:43:32 +0100 Subject: UTI: PoC - Read data from parquets Change-Id: Ie53954b2b8695ed9e5415ea604a8f3b229552489 Signed-off-by: Tibor Frank --- resources/tools/dash/app/pal/data/data.py | 202 ++++++++++++++++++++++++++++ resources/tools/dash/app/pal/data/data.yaml | 182 +++++++++++++++++++++++++ 2 files changed, 384 insertions(+) create mode 100644 resources/tools/dash/app/pal/data/data.py create mode 100644 resources/tools/dash/app/pal/data/data.yaml (limited to 'resources/tools/dash/app/pal/data') diff --git a/resources/tools/dash/app/pal/data/data.py b/resources/tools/dash/app/pal/data/data.py new file mode 100644 index 0000000000..9ce09e7f8b --- /dev/null +++ b/resources/tools/dash/app/pal/data/data.py @@ -0,0 +1,202 @@ +# Copyright (c) 2022 Cisco and/or its affiliates. +# Licensed under the Apache License, Version 2.0 (the "License"); +# you may not use this file except in compliance with the License. +# You may obtain a copy of the License at: +# +# http://www.apache.org/licenses/LICENSE-2.0 +# +# Unless required by applicable law or agreed to in writing, software +# distributed under the License is distributed on an "AS IS" BASIS, +# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +# See the License for the specific language governing permissions and +# limitations under the License. + +"""Prepare data for Plotly Dash.""" + +import logging +from time import time + +import awswrangler as wr + +from yaml import load, FullLoader, YAMLError +from awswrangler.exceptions import EmptyDataFrame, NoFilesFound + + +class Data: + """ + """ + + def __init__(self, data_spec_file, debug=False): + """ + """ + + # Inputs: + self._data_spec_file = data_spec_file + self._debug = debug + + # Specification of data to be read from parquets: + self._data_spec = None + + # Data frame to keep the data: + self._data = None + + # Read from files: + try: + with open(self._data_spec_file, "r") as file_read: + self._data_spec = load(file_read, Loader=FullLoader) + except IOError as err: + raise RuntimeError( + f"Not possible to open the file {self._data_spec_file,}\n{err}" + ) + except YAMLError as err: + raise RuntimeError( + f"An error occurred while parsing the specification file " + f"{self._data_spec_file,}\n" + f"{err}" + ) + + @property + def data(self): + return self._data + + def _get_columns(self, parquet): + try: + return self._data_spec[parquet]["columns"] + except KeyError as err: + raise RuntimeError( + f"The parquet {parquet} is not defined in the specification " + f"file {self._data_spec_file} or it does not have any columns " + f"specified.\n{err}" + ) + + def _get_path(self, parquet): + try: + return self._data_spec[parquet]["path"] + except KeyError as err: + raise RuntimeError( + f"The parquet {parquet} is not defined in the specification " + f"file {self._data_spec_file} or it does not have the path " + f"specified.\n{err}" + ) + + def _create_dataframe_from_parquet(self, + path, partition_filter=None, columns=None, + validate_schema=False, last_modified_begin=None, + last_modified_end=None): + """Read parquet stored in S3 compatible storage and returns Pandas + Dataframe. + + :param path: S3 prefix (accepts Unix shell-style wildcards) + (e.g. s3://bucket/prefix) or list of S3 objects paths + (e.g. [s3://bucket/key0, s3://bucket/key1]). + :param partition_filter: Callback Function filters to apply on PARTITION + columns (PUSH-DOWN filter). This function MUST receive a single + argument (Dict[str, str]) where keys are partitions names and values + are partitions values. Partitions values will be always strings + extracted from S3. This function MUST return a bool, True to read + the partition or False to ignore it. Ignored if dataset=False. + :param columns: Names of columns to read from the file(s). + :param validate_schema: Check that individual file schemas are all the + same / compatible. Schemas within a folder prefix should all be the + same. Disable if you have schemas that are different and want to + disable this check. + :param last_modified_begin: Filter the s3 files by the Last modified + date of the object. The filter is applied only after list all s3 + files. + :param last_modified_end: Filter the s3 files by the Last modified date + of the object. The filter is applied only after list all s3 files. + :type path: Union[str, List[str]] + :type partition_filter: Callable[[Dict[str, str]], bool], optional + :type columns: List[str], optional + :type validate_schema: bool, optional + :type last_modified_begin: datetime, optional + :type last_modified_end: datetime, optional + :returns: Pandas DataFrame or None if DataFrame cannot be fetched. + :rtype: DataFrame + """ + df = None + start = time() + try: + df = wr.s3.read_parquet( + path=path, + path_suffix="parquet", + ignore_empty=True, + validate_schema=validate_schema, + use_threads=True, + dataset=True, + columns=columns, + partition_filter=partition_filter, + last_modified_begin=last_modified_begin, + last_modified_end=last_modified_end + ) + if self._debug: + df.info(verbose=True, memory_usage='deep') + logging.info( + u"\n" + f"Creation of dataframe {path} took: {time() - start}" + u"\n" + f"{df}" + u"\n" + ) + except NoFilesFound as err: + logging.error(f"No parquets found.\n{err}") + except EmptyDataFrame as err: + logging.error(f"No data.\n{err}") + + self._data = df + return df + + def read_stats(self): + """Read Suite Result Analysis data partition from parquet. + """ + lambda_f = lambda part: True if part["stats_type"] == "sra" else False + + return self._create_dataframe_from_parquet( + path=self._get_path("statistics"), + partition_filter=lambda_f, + columns=None # Get all columns. + ) + + def read_trending_mrr(self): + """Read MRR data partition from parquet. + """ + lambda_f = lambda part: True if part["test_type"] == "mrr" else False + + return self._create_dataframe_from_parquet( + path=self._get_path("trending-mrr"), + partition_filter=lambda_f, + columns=self._get_columns("trending-mrr") + ) + + def read_trending_ndrpdr(self): + """Read NDRPDR data partition from iterative parquet. + """ + lambda_f = lambda part: True if part["test_type"] == "ndrpdr" else False + + return self._create_dataframe_from_parquet( + path=self._get_path("trending-ndrpdr"), + partition_filter=lambda_f, + columns=self._get_columns("trending-ndrpdr") + ) + + def read_iterative_mrr(self): + """Read MRR data partition from iterative parquet. + """ + lambda_f = lambda part: True if part["test_type"] == "mrr" else False + + return self._create_dataframe_from_parquet( + path=self._get_path("iterative-mrr"), + partition_filter=lambda_f, + columns=self._get_columns("iterative-mrr") + ) + + def read_iterative_ndrpdr(self): + """Read NDRPDR data partition from parquet. + """ + lambda_f = lambda part: True if part["test_type"] == "ndrpdr" else False + + return self._create_dataframe_from_parquet( + path=self._get_path("iterative-ndrpdr"), + partition_filter=lambda_f, + columns=self._get_columns("iterative-ndrpdr") + ) diff --git a/resources/tools/dash/app/pal/data/data.yaml b/resources/tools/dash/app/pal/data/data.yaml new file mode 100644 index 0000000000..45e7f6b7ed --- /dev/null +++ b/resources/tools/dash/app/pal/data/data.yaml @@ -0,0 +1,182 @@ +statistics: + path: s3://fdio-docs-s3-cloudfront-index/csit/parquet/stats +trending-mrr: + path: s3://fdio-docs-s3-cloudfront-index/csit/parquet/trending + columns: + - job + - build + - dut_type + - dut_version + - hosts + - start_time + - passed + - test_id + - test_name_long + - test_name_short + - version + - result_receive_rate_rate_avg + - result_receive_rate_rate_stdev + - result_receive_rate_rate_unit + - result_receive_rate_rate_values +trending-ndrpdr: + path: s3://fdio-docs-s3-cloudfront-index/csit/parquet/trending + columns: + - job + - build + - dut_type + - dut_version + - hosts + - start_time + - passed + - test_id + - test_name_long + - test_name_short + - version + - result_pdr_upper_rate_unit + - result_pdr_upper_rate_value + - result_pdr_upper_bandwidth_unit + - result_pdr_upper_bandwidth_value + - result_pdr_lower_rate_unit + - result_pdr_lower_rate_value + - result_pdr_lower_bandwidth_unit + - result_pdr_lower_bandwidth_value + - result_ndr_upper_rate_unit + - result_ndr_upper_rate_value + - result_ndr_upper_bandwidth_unit + - result_ndr_upper_bandwidth_value + - result_ndr_lower_rate_unit + - result_ndr_lower_rate_value + - result_ndr_lower_bandwidth_unit + - result_ndr_lower_bandwidth_value + - result_latency_reverse_pdr_90_avg + - result_latency_reverse_pdr_90_hdrh + - result_latency_reverse_pdr_90_max + - result_latency_reverse_pdr_90_min + - result_latency_reverse_pdr_90_unit + - result_latency_reverse_pdr_50_avg + - result_latency_reverse_pdr_50_hdrh + - result_latency_reverse_pdr_50_max + - result_latency_reverse_pdr_50_min + - result_latency_reverse_pdr_50_unit + - result_latency_reverse_pdr_10_avg + - result_latency_reverse_pdr_10_hdrh + - result_latency_reverse_pdr_10_max + - result_latency_reverse_pdr_10_min + - result_latency_reverse_pdr_10_unit + - result_latency_reverse_pdr_0_avg + - result_latency_reverse_pdr_0_hdrh + - result_latency_reverse_pdr_0_max + - result_latency_reverse_pdr_0_min + - result_latency_reverse_pdr_0_unit + - result_latency_forward_pdr_90_avg + - result_latency_forward_pdr_90_hdrh + - result_latency_forward_pdr_90_max + - result_latency_forward_pdr_90_min + - result_latency_forward_pdr_90_unit + - result_latency_forward_pdr_50_avg + - result_latency_forward_pdr_50_hdrh + - result_latency_forward_pdr_50_max + - result_latency_forward_pdr_50_min + - result_latency_forward_pdr_50_unit + - result_latency_forward_pdr_10_avg + - result_latency_forward_pdr_10_hdrh + - result_latency_forward_pdr_10_max + - result_latency_forward_pdr_10_min + - result_latency_forward_pdr_10_unit + - result_latency_forward_pdr_0_avg + - result_latency_forward_pdr_0_hdrh + - result_latency_forward_pdr_0_max + - result_latency_forward_pdr_0_min + - result_latency_forward_pdr_0_unit +iterative-mrr: + path: s3://fdio-docs-s3-cloudfront-index/csit/parquet/iterative_rls2202 + columns: + - job + - build + - dut_type + - dut_version + - hosts + - start_time + - passed + - test_id + - test_name_long + - test_name_short + - version + - result_receive_rate_rate_avg + - result_receive_rate_rate_stdev + - result_receive_rate_rate_unit + - result_receive_rate_rate_values +iterative-ndrpdr: + path: s3://fdio-docs-s3-cloudfront-index/csit/parquet/iterative_rls2202 + columns: + - job + - build + - dut_type + - dut_version + - hosts + - start_time + - passed + - test_id + - test_name_long + - test_name_short + - version + - result_pdr_upper_rate_unit + - result_pdr_upper_rate_value + - result_pdr_upper_bandwidth_unit + - result_pdr_upper_bandwidth_value + - result_pdr_lower_rate_unit + - result_pdr_lower_rate_value + - result_pdr_lower_bandwidth_unit + - result_pdr_lower_bandwidth_value + - result_ndr_upper_rate_unit + - result_ndr_upper_rate_value + - result_ndr_upper_bandwidth_unit + - result_ndr_upper_bandwidth_value + - result_ndr_lower_rate_unit + - result_ndr_lower_rate_value + - result_ndr_lower_bandwidth_unit + - result_ndr_lower_bandwidth_value + - result_latency_reverse_pdr_90_avg + - result_latency_reverse_pdr_90_hdrh + - result_latency_reverse_pdr_90_max + - result_latency_reverse_pdr_90_min + - result_latency_reverse_pdr_90_unit + - result_latency_reverse_pdr_50_avg + - result_latency_reverse_pdr_50_hdrh + - result_latency_reverse_pdr_50_max + - result_latency_reverse_pdr_50_min + - result_latency_reverse_pdr_50_unit + - result_latency_reverse_pdr_10_avg + - result_latency_reverse_pdr_10_hdrh + - result_latency_reverse_pdr_10_max + - result_latency_reverse_pdr_10_min + - result_latency_reverse_pdr_10_unit + - result_latency_reverse_pdr_0_avg + - result_latency_reverse_pdr_0_hdrh + - result_latency_reverse_pdr_0_max + - result_latency_reverse_pdr_0_min + - result_latency_reverse_pdr_0_unit + - result_latency_forward_pdr_90_avg + - result_latency_forward_pdr_90_hdrh + - result_latency_forward_pdr_90_max + - result_latency_forward_pdr_90_min + - result_latency_forward_pdr_90_unit + - result_latency_forward_pdr_50_avg + - result_latency_forward_pdr_50_hdrh + - result_latency_forward_pdr_50_max + - result_latency_forward_pdr_50_min + - result_latency_forward_pdr_50_unit + - result_latency_forward_pdr_10_avg + - result_latency_forward_pdr_10_hdrh + - result_latency_forward_pdr_10_max + - result_latency_forward_pdr_10_min + - result_latency_forward_pdr_10_unit + - result_latency_forward_pdr_0_avg + - result_latency_forward_pdr_0_hdrh + - result_latency_forward_pdr_0_max + - result_latency_forward_pdr_0_min + - result_latency_forward_pdr_0_unit +# coverage-ndrpdr: +# path: str +# columns: +# - list \ No newline at end of file -- cgit 1.2.3-korg