Why apply() on rows (axis=1) in Pandas? - Purpose & Use Cases

The Big Idea

What if you could instantly apply any custom calculation to every row without tedious copying or errors?

The Scenario

Imagine you have a table of sales data for different products and you want to calculate a custom score for each sale by combining multiple columns. Doing this by hand or with separate commands for each row feels like filling out a huge spreadsheet cell by cell.

The Problem

Manually calculating values row by row is slow and boring. It's easy to make mistakes copying formulas or mixing up columns. If the data changes, you have to redo everything. This wastes time and causes frustration.

The Solution

The apply() function with axis=1 lets you run a custom function on each row automatically. It's like having a helper who quickly goes through every row and applies your logic perfectly, saving you time and avoiding errors.

Before vs After

✗ Before

for i in range(len(df)):
    df.loc[i, 'score'] = df.loc[i, 'price'] * df.loc[i, 'quantity']

✓ After

df['score'] = df.apply(lambda row: row['price'] * row['quantity'], axis=1)

What It Enables

You can easily create new insights by combining multiple columns row-wise, making your data smarter and your analysis faster.

Real Life Example

A store manager wants to calculate total revenue per transaction by multiplying price and quantity for each row in a sales report. Using apply() on rows makes this quick and error-free.

Key Takeaways

Manual row-by-row calculations are slow and error-prone.

apply() with axis=1 automates row-wise operations.

This method saves time and reduces mistakes in data analysis.