levisrum23
/ Locale_Aware_Type_Conversion.pq
Created
January 24, 2026 07:11
Ensuring numerical precision in CSV imports by applying English (United States) locale settings to protect decimal points.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Prevents "Data Decay" where decimals are stripped during import. | |
| Critical for pH (7.5 vs 75) and Conductivity readings. | |
| */ | |
| #"Changed Type with Locale" = Table.TransformColumnTypes( | |
| #"Promoted Headers", | |
| { | |
| {"ph", type number}, | |
| {"Hardness", type number}, | |
| {"Solids", type number}, |
levisrum23
/ Dynamic_Mean_Imputation_PowerQuery.pq
Created
January 24, 2026 07:04
A reusable M-code function to identify and replace null values with column-specific averages across multiple parameters.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Author: [Your Name] | |
| Purpose: Industrial Data Cleaning - Handling missing sensor data | |
| Technique: List.Accumulate (Functional Programming in M) | |
| */ | |
| let | |
| // Define columns requiring imputation (e.g., pH, Sulfate, etc.) | |
| ColsToFix = {"ph", "Sulfate", "Trihalomethanes"}, | |
| // Recursive loop to replace nulls with calculated mean per column |