Ajay Narayan·1d agoPython Lambda, map() and filter(): Small Functions, Big ShortcutsOne-line functions, sorting by anything you like, and when a comprehension is still the better choice.
Ajay Narayan·2d agoThink in SQL: Hard Patterns — Streaks, Sessions, RetentionFind runs of consecutive days, split clicks into sessions and measure how many customers come back, using window functions you already…A response icon1A response icon1
Ajay Narayan·3d agoThink in SQL: LAG, LEAD and Running TotalsCompare each row with the one before it, add up running totals, smooth noisy numbers with moving averages, and avoid the default setting…
Ajay Narayan·3d agoBuild a Python Expense Tracker: Your First Real ProjectClasses, JSON files, error handling and clean menus, all working together in one app you’ll actually use.
Ajay Narayan·4d agoThink in SQL: Window Functions — Ranking and Top N per GroupRank rows without losing them, find the top items in every group, and keep only the latest record for each customer.
Ajay Narayan·5d agoThink in SQL: UNION, INTERSECT, EXCEPT — Compare DatasetsStack results on top of each other, find what two lists share, and check whether two datasets really match, row by row.A response icon1A response icon1
Ajay Narayan·5d agoPython pip and Virtual Environments: Install Packages the Right WayWhat PyPI is, how pip works, why every project needs its own environment, and a cleaner way to call web APIs.
Ajay Narayan·6d agoThink in SQL: CTEs — Break Hard Queries Into Steps With WITHWrite long queries that read top to bottom like a recipe, and use recursive CTEs to follow chains and fill in missing dates.A response icon1A response icon1
Ajay Narayan·Nov 15Think in SQL: Subqueries — Queries Inside QueriesUse the answer of one query inside another, check whether matching rows exist, and avoid the NOT IN trap that returns nothing at all.
Ajay Narayan·Nov 15Python JSON and Web APIs: Get Live Data From the InternetSave structured data the way websites do, then fetch real information from GitHub with a few lines of Python.