R for Excel Users: Your First Data Summary in 15 Lines
Start with R using a task you know from Excel: import a spreadsheet, summarise it by group, and draw a chart — in about…
Read article →Category Archives: Coding
Start-to-finish programming for people who work with data: Python, SQL, Java, R, JavaScript, Rust and PowerShell.
Rename Hundreds of Files at Once with PowerShell
Rename Hundreds of Files at Once with PowerShell
Bulk-rename files on Windows with PowerShell: add dates, replace text, number files and preview every change safely before it happens.
Read article →Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
A gentle first step from Excel to Python: load a spreadsheet with pandas, clean it, build a pivot table and save the result —…
Read article →