Tag

#pandas

700 posts239 followers

Explore Hashnode

Alternatives

WrenTools4h ago · 8 min read

Deduplicate a lead list in Python: five ways drop_duplicates misses

Disclosure: we built and sell the Apify Actor this post compares against, Merge & Dedup Datasets, CSV, JSON & Excel Files (publisher WrenTools). The post was written with AI assistance and reviewed by

wrentools.hashnode.dev

Alper San8h ago · 9 min read

Maximum Drawdown in Python: Calculate Loss and Recovery Time

A backtest finishes 26% ahead. In the middle, its value falls from 120 to 90. The final return looks comfortable; the path includes a 25% loss from a previous high. Maximum drawdown is the largest per

siftingio-developers.hashnode.dev

Eva J Patel1d ago · 13 min read

How to Build a Simple Data Analyzer in Python with Pandas

Data analysis might sound complicated when you first encounter it. You might imagine large databases, advanced mathematics, and complicated machine learning algorithms. But many useful data analysis t

freecodecamp.org

Robert Breen3d ago · 4 min read

Python: Stack Three Monthly Exports Into One Quarter With pandas (Label, concat, groupby, No Copy-Paste)

Most small-business software exports one file per month. Sales, invoices, time sheets: July is one CSV, August is another. Then the quarterly review comes around, and someone opens all three, pastes t

stepthrough.hashnode.dev

Feasibilitypro4d ago · 9 min read

Building a Financial Scenario Analysis Engine With Python

Financial applications rarely work with a single set of assumptions. A project forecast may depend on construction costs, sales prices, delivery dates, and collection schedules, all of which can chang

feasibilitypr.hashnode.dev

Locate Next5d ago · 12 min read

Flagging absentee owners with Python and pandas by comparing situs and mailing addresses

County parcel files often hold a useful signal: the property address and the owner's mailing address don't always match. If an owner gets their tax bill somewhere other than the property, they may not

locatenext.hashnode.dev

Locate Next5d ago · 13 min read

How to Deduplicate Property Owner Records Across Multiple Lead Lists with Python and pandas

All names, addresses and IDs in the examples are fictional. Why the same owner shows up on more than one lead list Real estate teams often pull several lead lists for the same area: an absentee owner

locatenext.hashnode.dev

13F ChatOct 21 · 5 min read

Computing the Gold/Silver Ratio in Python: Alignment, Rolling Z-Scores and a Backtest Sanity Check

The gold/silver ratio is one of the oldest numbers in commodity markets: the price of one ounce of gold divided by the price of one ounce of silver. It tells you how many ounces of silver one ounce of

1 13f-insights.hashnode.dev

Real DevOct 19 · 7 min read

Pandas Basics on a Real Dataset: A Hands-On Walkthrough with Palmer Penguins

Many pandas tutorials build a five-row DataFrame from a dictionary, so the data is already clean. Real data has missing values, text where you expected numbers, and questions you have to turn into cod

realdev9868.hashnode.dev

FeasibilityproOct 19 · 12 min read

Building a Real Estate Development Cash Flow Engine With Python and Pandas

A financial model often starts with a spreadsheet containing construction budgets, sales assumptions, payment dates, and project costs. As the model grows, maintaining these assumptions across multipl