PinnedPublished inTowards Data ScienceTranslating SQL into Python -Part 1Kind of like Google Translate, but for the language of data.Feb 3, 20228Feb 3, 20228
PinnedPublished inBetter ProgrammingMy Top 10 Pandas Functions for Preparing DataBecause I wanted to create useful, accurate analysis with as little work as possibleJan 8, 20224Jan 8, 20224
Published inTowards Data ScienceTranslating SQL into Python — Part 2Kind of like Google Translate, but for the language of ̶l̶o̶v̶e̶ dataMar 8, 2022Mar 8, 2022
Published inTowards Data ScienceFind the Difference between Two Angles using PythonBecause it’s all fun and games until the angle changes from 355 to 5 degreesFeb 23, 2022Feb 23, 2022
Published inBetter ProgrammingHow to Combine Multiple Excel Files Into One With PythonDitch the manual work and use Python to automatically create a single, error-free, structured tableJan 25, 20221Jan 25, 20221
Published inTowards Data ScienceHow Ranking Time Series Data Can Identify Abnormal BehaviourInform your maintenance strategies and prevent failure with a simple python scriptJan 13, 2022Jan 13, 2022
Published inLet’s ExcelExcel Hack: Unmerge and Fill CellsRemove merge formatting and refill empty cells automatically— no copy & pasting required. Full step-by-step guideJan 12, 20227Jan 12, 20227
Published inThe PythoneersNew to Python? 7 Tips to Up your Game FastLearn from my mistakes and go charm that snake.Jan 10, 20224Jan 10, 20224
Published inBetter ProgrammingWhy You Should Use Python Pandas Over Vlookups for Merging DataA simple introduction and template script, no python experience necessary.Jan 7, 20227Jan 7, 20227
