Altcademy - a Forbes magazine logo Best Coding Bootcamp 2023

How to apply a function to a column in Pandas

Understanding Functions in Pandas

Imagine you're an artist, and you have a canvas with rows of different colors. Now, you want to transform one particular color into a different shade. In programming, specifically when dealing with data in tables or spreadsheets, we often need to perform similar transformations. This is where Pandas, a powerful data manipulation library in Python, comes into play.

Pandas provides us with a tool called a DataFrame, which is like our canvas, a table where data is neatly arranged in rows and columns. Sometimes, we need to apply a specific operation or function to each element in a column, akin to changing the shade of color in each row of our canvas.

The Basics of Applying Functions

To apply a function to a column in Pandas, we use the apply() method. This method takes a function and applies it to each element in a column (or row) of a DataFrame. Think of it like using a stamp on each cell of the column, where the stamp imprints a new value based on the original one.

Here's a simple example to illustrate this:

import pandas as pd

# Create a simple DataFrame
df = pd.DataFrame({
    'numbers': [1, 2, 3, 4, 5]

# Define a function that adds 10 to a number
def add_ten(x):
    return x + 10

# Apply the function to the 'numbers' column
df['numbers_plus_ten'] = df['numbers'].apply(add_ten)


In this example, the add_ten() function is applied to each element in the 'numbers' column, resulting in a new column 'numbers_plus_ten' where each value is the original number plus ten.

Functions with Multiple Arguments

Sometimes, the function you want to apply requires more than one argument. In such cases, you can use the args parameter of the apply() method to pass additional arguments. Let's enhance our previous example with a function that can add any number, not just ten:

# Define a function that adds a specified number to another number
def add_number(x, y):
    return x + y

# Apply the function to the 'numbers' column, adding 15 this time
df['numbers_plus_fifteen'] = df['numbers'].apply(add_number, args=(15,))


Here, we pass the number 15 as an additional argument to the add_number() function using the args parameter.

Using Lambda Functions

Sometimes writing a full function for a simple operation can feel cumbersome. For such cases, Python provides a feature called lambda functions, also known as anonymous functions. These are small, unnamed functions defined on the fly, perfect for one-time use.

Let's see how we can use a lambda function with apply():

# Apply a lambda function to the 'numbers' column to double each value
df['numbers_doubled'] = df['numbers'].apply(lambda x: x * 2)


In this example, the lambda function lambda x: x * 2 doubles each value in the 'numbers' column, creating a new 'numbers_doubled' column.

Handling More Complex Transformations

What if you need to apply a more complex transformation, such as one that depends on multiple columns? No problem! The apply() method can also be used with a lambda function that takes a row of data as input.

Here's an example:

# Create a DataFrame with two columns
df = pd.DataFrame({
    'price': [1.99, 2.99, 3.99],
    'tax_rate': [0.2, 0.15, 0.1]

# Define a lambda function to calculate the total price including tax
df['total_price'] = df.apply(lambda row: row['price'] + (row['price'] * row['tax_rate']), axis=1)


In this case, we set axis=1 to indicate that the function should be applied to rows, not columns. The lambda function takes each row as input and calculates the total price by adding the tax to the base price.

Applying Functions Conditionally

Sometimes you might want to apply a function only to certain elements that meet a specific condition. You can combine the apply() method with a conditional statement to achieve this.

For example, let's apply a discount to prices over $2.99:

# Define a function to apply a discount
def apply_discount(price):
    if price > 2.99:
        return price * 0.9  # Apply a 10% discount
        return price

# Apply the function conditionally
df['discounted_price'] = df['price'].apply(apply_discount)


Here, the apply_discount() function checks if the price is greater than $2.99 and applies a discount if it is. The apply() method then applies this function to each element in the 'price' column.

Performance Considerations

When working with large datasets, performance can become an issue. The apply() method is flexible but not always the fastest. For simple operations, it might be more efficient to use vectorized operations, which are operations applied to entire columns or datasets at once, without the need for a loop or apply().

For example, instead of using apply() to add ten to each number, you can do this:

df['numbers_plus_ten'] = df['numbers'] + 10

This is much faster than using apply() because Pandas optimizes vectorized operations internally.


Applying functions to columns in Pandas is like having a magic wand that can transform your data in endless ways. Whether you're adding a constant to each value, performing complex calculations, or selectively applying transformations, the apply() method is a versatile tool in your data manipulation toolkit.

As we've seen, functions can range from simple arithmetic operations to more elaborate logic involving multiple columns. Lambda functions offer a shortcut for quick, one-off transformations, while vectorized operations provide a high-speed alternative for simpler tasks.

With these techniques, you're now equipped to paint your data canvas with the broad strokes of transformation, bringing out the patterns and insights that lie beneath the surface. The next time you face a column of data in need of change, remember these methods and let your creativity flow into your data analysis masterpiece.