求助：如何按条件将列名赋值给值为4的单元格（批量处理）

Hey there! I get what you're trying to do—when a cell equals 4, you want to swap that value out for the column's name, and you need this to work smoothly even for hundreds of columns. Let's break down how to fix this properly.

The Core Idea #

Instead of grabbing all column names at once, we'll process each target column individually: for every cell in the column, if it's 4, replace it with the column's name; otherwise, leave it as-is. This way, we only affect the columns you care about.

Solution Code (Using Pandas) #

Assuming you're working with a pandas DataFrame (the most common tool for this kind of data manipulation), here's a clean, efficient approach:

import pandas as pd

# 1. Define your target columns (replace with your actual column list)
# If you need to process all columns, use target_cols = df.columns
target_cols = ["col1", "col2", "col3", ...]  # Add your hundreds of columns here

# 2. Apply the replacement logic to each target column
df[target_cols] = df[target_cols].apply(
    lambda column: column.where(column != 4, column.name)
)

How This Works #

• target_cols: This is the list of columns you want to modify. You can define it explicitly, or generate it programmatically (e.g., target_cols = [col for col in df.columns if col.startswith("prefix")] if you need to filter columns by a pattern).
• apply(lambda column: ...): We iterate over each column in target_cols. For each column:
  • column.where(column != 4, column.name): This keeps the original value if it's not 4. If it is 4, it replaces the value with column.name—which is exactly the column's name we want.

Example Walkthrough #

Let's say your original data looks like this:

After running the code, you'll get your desired result:

Why Your Previous Code Got All Column Names #

Chances are your original approach tried to use the full df.columns list directly in the replacement, instead of accessing the individual column name for each cell. This method fixes that by focusing on one column at a time, so each 4 only gets matched to its own column's name.

This approach is efficient even for hundreds of columns—pandas handles column-wise operations quickly, so you won't hit performance issues here.

内容的提问来源于stack exchange，提问作者Adamek