Machine Learning Lesson 2: Preparing Data (Missing Values and Text Columns)
Models only accept complete, numeric tables. Find and fill missing values with the median and turn text columns like city into 0/1 columns with…
Read article →Excel, SAP, Oracle & automation tips — plus wacky facts
Models only accept complete, numeric tables. Find and fill missing values with the median and turn text columns like city into 0/1 columns with…
Read article →What machine learning actually is, the words you need (features, target, training), installing scikit-learn, and a first model that predicts flat prices from area.
Read article →STOCKHISTORY fetches daily, weekly or monthly prices for a stock or currency pair into a spill range.
Read article →Collect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them with formulas…
Read article →Write your first Google Apps Script: open the editor, read a sheet, total by region, email yourself a summary, add a custom menu, schedule…
Read article →The Google Sheets functions that make it special: QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLETRANSLATE, SPARKLINE, SPLIT, IMAGE, GOOGLEFINANCE and checkboxes, with practical examples.
Read article →Which customers are in this month’s list but not last month’s? Compare two lists with COUNTIF, MATCH/XMATCH, FILTER and conditional formatting — in old…
Read article →Understand INDEX and MATCH separately, combine them for flexible lookups in any Excel version, look left, do two-way and multiple-criteria lookups, approximate matches, and…
Read article →Calculate weighted averages correctly — average price by quantity, weighted marks, blended interest rates — with SUMPRODUCT/SUM, weighted averages with conditions, and why plain…
Read article →VAR estimates variance from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…
Read article →Look up a value at the crossing of a row and a column — target for South in August, price for size L in…
Read article →Organise Google Drive with shared drives and folders, share safely with Viewer/Commenter/Editor, avoid “anyone with the link” leaks, transfer ownership, use filter views, and…
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.