DataQualityFrameworkGovernance 0.0.10.5

Data Quality Framework Governance is a structured approach to assessing, monitoring, and improving the quality of data.

Data Quality Framework Governance (DQFG)

Data Quality Framework Governance is a structured approach to assessing, monitoring, and improving the quality of data. An effective Data Quality Framework considers these dimensions and integrates them into a structured approach to ensure that data serves its intended purpose, supports informed decision-making, and maintains the trust of users and stakeholders.

Data Quality is an ongoing process that requires continuous monitoring, assessment, and improvement to adapt to changing data requirements and evolving business needs.

Example: To call functions from the library.

from DataQualityFrameworkGovernance import Uniqueness as uq
print(uq.duplicate_rows(dataframe))

Library structure

---

Accuracy

accuracy_tolerance_numeric

Calculating data quality accuracy of a set of values (base values) by comparing them to a known correct value (lookup value) by setting a user-defined tolerance percentage, applicable for numeric values.

from  DataQualityFrameworkGovernance  import  Accuracy as ac
print(ac.accuracy_tolerance_numeric(dataframe, 'base_column', 'lookup_column', tolerance_percentage))

email_pattern

Validating accuracy of email addresses in a dataset by verifying that they follow a valid email format.

from  DataQualityFrameworkGovernance  import  Accuracy as ac
print(ac.email_pattern(dataframe,'email_column_name'))

filter_number_range

Number range ensures that data values are accurate and conform to expected values or constraints. It is applicable to a variety of contexts, including exam scores, weather conditions, pricing, stock prices, age, income, speed limits for vehicles, water levels, and numerous other scenarios.

from  DataQualityFrameworkGovernance  import  Accuracy as ac
print(ac.filter_number_range(dataframe, 'range_column_name', lower_bound, upper_bound))

filter_datetime_range

The datetime range filter guarantees the accuracy and adherence of data values to predetermined criteria or constraints. It is applicable to a variety of contexts, including capturing outliers in date of birth, age and many more.

from  DataQualityFrameworkGovernance  import  Accuracy as ac
print(ac.filter_datetime_range(Dataframe, 'range_column_name', 'from_date', 'to_date', 'date_format'))

Example:
print(ac.filter_datetime_range(df, 'Date', '2023-01-15', '2023-03-01', '%Y-%m-%d'))

Important: Specify date format in '%Y-%m-%d %H:%M:%S.%f' (It can be specified in any format, parameter value to be aligned appropriately).

Completeness

missing_values

Summary of missing values in each column.

from  DataQualityFrameworkGovernance  import  Completeness as cp
print(cp.missing_values(dataframe))

overall_completeness_percentage

Percentage of missing values in a DataFrame.

from  DataQualityFrameworkGovernance  import  Completeness as cp
print(cp.overall_completeness_percentage(dataframe))

Consistency

start_end_date_consistency

If data in two columns is consistent, check if the "Start Date" and "End Date" column are in the correct chronological order.

from  DataQualityFrameworkGovernance  import  Consistency as ct
print(ct.start_end_date_consistency(dataframe, 'start_date_column_name', 'end_date_column_name', 'date_format'))

Important: Specify date format in '%Y-%m-%d %H:%M:%S.%f' (It can be specified in any format, parameter value to be aligned appropriately).

count_start_end_date_consistency

Count of data in two columns is consistent, check if the "Start Date" and "End Date" column are in the correct chronological order.

from  DataQualityFrameworkGovernance  import  Consistency as ct
print(ct.count_start_end_date_consistency(dataframe, 'start_date_column_name', 'end_date_column_name', 'date_format'))

Important: Specify date format in '%Y-%m-%d %H:%M:%S.%f' (It can be specified in any format, parameter value to be aligned appropriately).

Uniqueness

duplicate_rows

Identify and display duplicate rows in a dataset.

from  DataQualityFrameworkGovernance  import  Uniqueness as uq
print(uq.duplicate_rows(dataframe))

unique_column_values

Display unique column values in a dataset.

from  DataQualityFrameworkGovernance  import  Uniqueness as uq
print(uq.unique_column_values(dataframe, 'column_name'))

unique_column_count

Count unique column values in a dataset.

from  DataQualityFrameworkGovernance  import  Uniqueness as uq
print(uq.unique_column_count(dataframe, 'column_name'))

Validity

validate_age

Validate age based on the criteria in a dataset.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.validate_age(dataframe, 'age_column', min_age, max_age))

validate_age_count

Count age based on the criteria in a dataset.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.validate_age_count(dataframe, 'age_column', min_age, max_age))

is_within_range

If all values in a given array list are present in a specific column of a dataset then it provides a status message indicating whether all names are found or not. Array values must be within square brackets.

#Examples
#array list = ["Tom", "Jerry", "Donald"] - Text
#array list = [10, 20, 30] - Numeric
#array list = [True, False] - Boolean
#array list = [0, 1] - Flag

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_within_range(dataframe, 'column_name_to_look', [array_list]))

is_number_in_column

Examines each value in a column and appends a new column to the existing column, indicating whether the values are numeric.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_number_in_column(dataframe, 'column_name'))

is_number_in_dataset

Examines each value in a dataset and appends a new column for each existing column, indicating whether the values are numeric.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_number_in_dataset(dataframe))

#Example for specific column selection
is_number_in_dataset(dataframe[['column1','column7']])

is_text_in_column

Examines each value in a column and appends a new column to the existing column, indicating whether the values are text. Result would be false, if text or string contains number.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_text_in_column(dataframe, 'column_name'))

is_text_in_dataset

Examines each value in a dataset and appends a new column for each existing column, indicating whether the values are text. Result would be false, if text or string contains number.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_text_in_dataset(dataframe))

#Example for specific column selection
is_text_in_dataset(dataframe[['column1','column7']])

is_date_in_column

Examines each value in a column and appends a new column to the existing column, indicating whether the values are in date time, in a speciifed format.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_date_in_column(dataframe,'column_name', date_format))

Important: Specify date format in '%Y-%m-%d %H:%M:%S.%f' (It can be specified in any format, parameter value to be aligned appropriately).

is_date_in_dataset

Examines each value in a dataset and appends a new column for each existing column, indicating whether the values are in date time, in a speciifed format.

from  DataQualityFrameworkGovernance  import  Validity as vl
print(vl.is_date_in_dataset(dataframe, date_format))

#Example for specific column selection
is_date_in_dataset(dataframe[['column1','column7']], date_format='%Y-%m-%d')

Important: Specify date format in '%Y-%m-%d %H:%M:%S.%f' (It can be specified in any format, parameter value to be aligned appropriately).

Datastats

count_rows

Count the number of rows in a DataFrame.

from  DataQualityFrameworkGovernance  import  Datastats as ds
print(ds.count_rows(dataframe))

count_columns

Count the number of columns in a DataFrame.

from  DataQualityFrameworkGovernance  import  Datastats as ds
print(ds.count_columns(dataframe))

count_dataset

Count the number of rows & columns in a DataFrame.

from  DataQualityFrameworkGovernance  import  Datastats as ds
print(ds.count_dataset(dataframe))

limit_max_length

Count the number of rows & columns in a DataFrame.

from  DataQualityFrameworkGovernance  import  Datastats as ds
print(ds.limit_max_length(dataframe, column_name, start_length, length))

#Example: 'ABCDEFGH' text will return the ouput as 'ABCDE'
print(limit_max_length(df,'column_name',0,5))

---

Supporting python libraries:

• Pandas
• re

---

Homepage

Bug Tracker

Github-flavored Markdown