Speed Up Pandas String Manipulations
Last Updated on August 22, 2023 by Editorial Team
Author(s): Dr. Mandar Karhade, MD. PhD.
Originally published on Towards AI.
This tutorial focuses on speeding up string manipulations.

This member-only story is on us. Upgrade to access all of Medium.
I got bored and decided to benchmark string manipulation methods and how they affect the performance of a pandas data frame. As it is well-known, Pandas data frames act weirdly once they grow beyond a certain limit. Mostly dependent on the memory pressure and also some overhead when elements from various rows are to be manipulated at once.
So, here is the experiment.
I created a data frame using Faker. The base data is the fake data of 100,000 rows.
!pip install fakerimport pandas as pdimport numpy as npdef gen_data(x): from faker… Read the full blog for free on Medium.
Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.
Published via Towards AI
Towards AI Academy
We Build Enterprise-Grade AI. We'll Teach You to Master It Too.
15 engineers. 100,000+ students. Towards AI Academy teaches what actually survives production.
Start free — no commitment:
→ 6-Day Agentic AI Engineering Email Guide — one practical lesson per day
→ Agents Architecture Cheatsheet — 3 years of architecture decisions in 6 pages
Our courses:
→ AI Engineering Certification — 90+ lessons from project selection to deployed product. The most comprehensive practical LLM course out there.
→ Agent Engineering Course — Hands on with production agent architectures, memory, routing, and eval frameworks — built from real enterprise engagements.
→ AI for Work — Understand, evaluate, and apply AI for complex work tasks.
Note: Article content contains the views of the contributing authors and not Towards AI.