Build a pandas PDF report with reusable Python components
A monthly product report usually needs a headline, summary metrics, a ledger, and page numbers. Those pieces are useful components to reuse across r…
Последние новости
⚑ Сообщить о проблемеTech news from the best sources
Все темы
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
testing
tutorial
typescript
webdev
Export App Store and Google Play reviews to Excel and find the top complaints
Disclosure: I built the reviews scraper used in this post and earn money when people run it. The pandas part works with reviews from any source. App…
Pharmacy Sales Data: A Pandas Project
Introduction This week, I worked on a pharmacy sales dataset using pandas. The dataset had 6,150 rows and 26 columns, covering orders, products, cus…
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…
JobSpy doesn't scrape company career sites. Add Greenhouse, Lever and Workday jobs in the same DataFrame
JobSpy (speedyapply/JobSpy on GitHub) is a popular Python library for job search data (about 4,500 GitHub stars): one scrape_jobs() call returns Lin…
From Raw Hourly Data to a Validated Model: A Pandas and scikit-learn Walkthrough
Hourly time-series data rarely arrives clean. Hours go missing, timestamps repeat, sensors report impossible values, and some series start years aft…
Cohort Retention in pandas: Three Mistakes That Make Your Curve Lie
Cohort retention tables look simple: group customers by the month they started, count how many are still around each month after, divide. Then the c…
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…
The first thing I check before trusting any dataset
Every dataset I've ever received came with a description. Almost none of them matched the data. Not because anyone was lying. The person who wrote t…
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…
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…
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…
How SQL and Python Work Together in Data Analysis
Every data analyst job posting asks for SQL and Python. That raises an honest beginner question nobody seems to answer directly. If both work with d…
One Bug Hit 11 Rows. Another Hit 36 Million.
I built a predictive maintenance model on 37,164,054 telemetry records from an iron ore mine. Six months of alarms from haul trucks and excavators.…
Handling Pandas NaN Values in FastAPI JSON Responses
Handling Pandas NaN Values in FastAPI JSON Responses ===================================================== When building APIs with FastAPI and worki…
Pandas vs Polars: Which One Should You Use in 2025?
Pandas vs Polars: Which One Should You Use in 2025? You’re probably still typing df.groupby() in Pandas while your Polars-using teammate has already…
From Raw Prices to Real Signals: Financial Metrics for a Data Pipeline (Daily Return, MA, RSI, MACD, Volatility)
In this article I will share my understanding and use of some financial metrics used in my Financial Dashboard project. You can see it in this link…
# Turning Data Quality Checks into a Measurable Trust Score
Most data quality problems do not announce themselves loudly. They do not always break a pipeline. They do not always throw an exception. They do no…
Pandas vs SQL, when to use each
Pandas and SQL do a lot of the same things: filter rows, group, aggregate, join. So analysts reasonably ask which to learn and when to use which. Th…
Openpyxl's Relevance for Freelance Data Cleaning and Automation in 2023: Addressing Concerns and Solutions
Introduction: The Question of Relevance Imagine you’re a college student, fresh off mastering pandas , and you’re eyeing the freelancing market for…
Analyzing Steam Games 2025: Genres, Players and User Ratings
As part of my Master in Data Science & AI at Evolve , I worked on a data analysis project using a real Steam games dataset from 2025. The goal o…