Filter
Exclude
Time range
-
Near
Messy datasets don't test your Excel skills. They test your patience, detective skills, and ability to not scream at the screen. #DataAnalytics #Excel #DataCleaning
6
With (Un)Spready’s AI formulas you can organize, tag and standardize columns from messy item lists, leaving your spreadsheet with clean sheets. Get Spready 👉 matasoft.hr/QTrendControl/in… #classification #dataenrichment #automation #spreadsheetAI #datacleaning #fiverr #upwork #AI
8
nullFill(X, Y) — Replace NULL values without mutating the original! 🛡️ nullFill(x, 0) returns a new object — the original is untouched. Pass a same-length vector as Y for position-matched fills. For in-place filling, use nullFill!. #DolphinDB #DataCleaning #DataPrep #ETL
1
mcount(X, window, [minPeriods=1]) — Count non-NULL values per rolling window! 🔢 mcount(x, 3) returns valid element count at each position. Pair with mavg/mstd to check data density before calculations. #DolphinDB #DataPrep #DataCleaning #TimeSeries
11
Data cleaning is where real analytics begins. Missing values, duplicates, inconsistent formats, outliers, and invalid records can destroy dashboards and ML models if ignored. Strong analysts spend more time preparing data than building visuals. #DataCleaning #DataAnalytics #Python #SQL #MachineLearning
4
5
38
614
part: Data Cleaning Learning to handle missing values, duplicates, and inconsistent data is what turns raw data into meaningful insights. Still building, still learning📈. @Techsphereacad @ezekiel_aleke #DataAnalytics #DataCleaning #Excel #LearningInPublic
24
• Are there duplicates? • Are there missing values? • Is the data consistent? Data cleaning isn't the exciting part, but it's often the most important. #SQL #SQLServer #DataAnalytics #DataCleaning #BuildInPublic #DataAnalyst
5
Today I practiced pasting only values to strip out messy formulas, and transposing columns into rows instantly. It’s a total lifesaver for restructuring messy reports. ​ #DataCleaning #Excel #DataAnalytics #CareerPivot
3
Ricardo Vázquez retweeted
Simple Practical Data Cleaning #Python Code Snippets for messy data: bit.ly/3hpthSD #DataCleaning Cookbook to prepare your data for analysis — PANDAS, NumPy, Matplotlib, scikit-learn, etc.: amzn.to/4c6DAWf v/ @PacktDataML ————— #DataScience #DataScientist
3
12
19
1,407