diff options
| -rw-r--r-- | gn3/computations/correlations.py | 3 | ||||
| -rw-r--r-- | sql/update/metadata_audit.sql | 2 |
2 files changed, 3 insertions, 2 deletions
diff --git a/gn3/computations/correlations.py b/gn3/computations/correlations.py index bc738a7..56f483c 100644 --- a/gn3/computations/correlations.py +++ b/gn3/computations/correlations.py @@ -1,4 +1,5 @@ """module contains code for correlations""" +import math import multiprocessing from typing import List @@ -90,7 +91,7 @@ def compute_sample_r_correlation(trait_name, corr_method, trait_vals, target_values=sanitized_target_vals, corr_method=corr_method) - if corr_coefficient is not None: + if corr_coefficient is not None and not math.isnan(corr_coefficient): return (trait_name, corr_coefficient, p_value, num_overlap) return None diff --git a/sql/update/metadata_audit.sql b/sql/update/metadata_audit.sql index 514a2fc..5055666 100644 --- a/sql/update/metadata_audit.sql +++ b/sql/update/metadata_audit.sql @@ -26,4 +26,4 @@ CREATE TABLE metadata_audit ( json_diff_data VARCHAR(2048) NOT NULL, time_stamp timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CHECK (JSON_VALID(json_diff_data)) -); +) CHARACTER SET 'utf8mb4'; |