Pairing inter-account transfers across bank statements with pandas
To pair inter-account transfers across bank statements, match each outflow to an inflow of the same absolute amount , in a different account , withi…
AI & ML
⚑ Сообщить о проблемеПоследние новости AI & ML от Tech News
Все темы
AI
News
Tech
agents
ai
api
architecture
automation
backend
beginners
career
claude
database
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
Building an Interactive Excel Dashboard for E-commerce Product Analysis: A Case Study of Jumia Products
Data Cleaning & Preparation Data Cleaning This is the process of finding and fixing mistakes, duplicates, or missing information in a given data…
What I Found Exploring Superstore Sales Data with Python (and What I'd Do Differently)
I recently finished an exploratory data analysis (EDA) project on the Superstore sales dataset as part of the Nexgen Analytics Internship. The brief…
Net Present Value (NPV): How to Discount Cash Flows and Read the Answer
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can take a project that costs money now and pays money late…
Current Ratio vs Quick Ratio, and Debt to Equity
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can look at a balance sheet and answer two questions a lend…
Gross vs Operating vs Net Margin: What Each One Tells You
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can look at an income statement and say, in one sentence, w…
Contribution Margin and Break-Even: The Fixed Cost That Does Not Belong in the Unit
By Michael Nocito , data analyst · Published August 11, 2026 By the end of this page you can answer three questions that come up constantly and get…
SUM vs SUMX in DAX: Why a Row-by-Row Calculation Needs an Iterator
By Michael Nocito , data analyst · Published August 10, 2026 By the end of this page you can look at any DAX aggregation and say which of the two it…
Tableau Dashboard Extensions: What They Add, and What They Can Read
By Michael Nocito , data analyst · Published August 9, 2026 By the end of this page you can add an extension to a dashboard, tell the two hosting ki…
Percentiles, the IQR and the 1.5 Outlier Rule: How to Flag a Bad Row
By Michael Nocito , data analyst · Published August 9, 2026 By the end of this page you can compute quartiles by hand, build the standard outlier fe…
What Is a P-Value? Worked by Shuffling Nine Real Orders 126 Ways
By Michael Nocito , data analyst · Published August 9, 2026 By the end of this page you can say what a p-value measures in one sentence, compute one…
Moving Averages: Smoothing a Series Without Smoothing Away the Truth
By Michael Nocito , data analyst · Published August 9, 2026 By the end of this page you can build a moving average by hand, choose a window length o…
pandas read_csv: Your First DataFrame, and What It Guessed
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can load a CSV into pandas, find out in twenty seconds what…
pandas pct_change and cumsum: Percent Change and Running Totals
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can turn transactions into a monthly series, add period-on-p…
pandas merge: Left Join, Inner Join, and the One That Doubled the Revenue
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can attach columns from one DataFrame to another on a shared…
Handling Missing Values in pandas: dropna, fillna and What Each One Claims
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can count what is missing and where, choose between dropping…
Where to Find Free Datasets to Practice With (And How to Pick One)
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you will have a shortlist of places that hold millions of free d…
Excel Tables vs Ranges: What Ctrl+T Actually Changes
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can turn a list into a real Excel table, write formulas that…
Excel Dynamic Arrays: FILTER, UNIQUE and SORT in One Formula
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can pull a distinct list out of a column, extract every row…
Excel Drop Down Lists and Data Validation, and the Paste That Removes Them
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you can put a dropdown on a column in about a minute, keep its l…
How to Connect Python to a SQL Database (Straight Into a DataFrame)
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page you will run a SQL query from Python and get back a pandas DataF…
How to Connect Excel to a SQL Database (And Stop Pasting)
By Michael Nocito , data analyst · Published August 8, 2026 By the end of this page your spreadsheet will pull its numbers straight from a database,…
How to Review AI-Generated SQL Before You Trust the Number
An AI assistant will write you a query in ten seconds, the query will run, and the number that comes back will look completely reasonable. This page…
pandas GroupBy: How to Summarize a DataFrame Without Losing Track of Your Rows
By Michael Nocito , data analyst · Published August 7, 2026 By the end of this page you can take a DataFrame, summarize it by any column or combinat…
Excel Just Summed Your ID Numbers and Said Nothing
By Michael Nocito , data analyst · Published August 7, 2026 This article gives you the test that catches the most common beginner mistake in pivot t…
Your Tableau Dashboard Needs Two or Three Views, Not Eight
By the end of this page you can look at a folder of eight finished sheets and say which two or three belong on the dashboard, which one goes in the…
What Is Data Analysis?
By the end of this page you will have done a real piece of data analysis. It is a small one, on paper, with arithmetic you can do in your head. You…
How to Verify an AI Agent Actually Did the Work
An AI agent tells you the work is done. Here are five checks that show whether it is. Each check takes a minute or two. Each one looks at the thing…
How to Build a Tableau Dashboard and Story
By the end of this guide you will have a published Tableau dashboard and a three-point story, built on a real dataset. It lives on a public URL you…
Technical Tenacity: What to Do When the Tools Fight Back
This guide gives you a repeatable loop for the days when nothing works, and four true stories showing it used on real problems. Here is what a worki…