如何实现：将变量值与最大值比较或判断≥10并生成标记列

Got it, let's work through this problem step by step. You need to generate a flag column for each variable where the flag is T (or TRUE/1) if the value meets either of two criteria: it's equal to the variable's maximum value, OR it's ≥10. Below are practical, easy-to-adapt solutions in two popular data manipulation tools: R (with dplyr) and Python (with pandas).

R Solution (using dplyr) #

We'll use dplyr::across() to batch-process all your target variables—this avoids repetitive code and keeps things clean.

First, let's replicate your sample data, then build the flag columns:

library(dplyr)

# Recreate your sample dataset
df <- tibble(
  ID = c("A", "B", "C", "D"),
  Var1 = c(1, 1, 2, 2),
  Var2 = c(5, 5, 5, 6),
  Var3 = c(15, 7, 15, 10)
)

# Generate the flag columns
df_with_flags <- df %>%
  # For each Var column, check if value is max OR >=10
  mutate(across(starts_with("Var"), 
                ~ .x == max(.x, na.rm = TRUE) | .x >= 10,
                .names = "{.col}_B")) %>%
  # Convert boolean values to T/F to match your expected output
  mutate(across(ends_with("_B"), ~ ifelse(.x, "T", "F")))

# View the result
df_with_flags

This will output exactly the table you shared: each VarX gets a corresponding VarX_B column with T/F flags based on your rules. If you prefer 1/0 instead of T/F, just skip the final mutate() step—R's booleans can be converted to integers directly with as.integer().

Python Solution (using pandas) #

In pandas, we can loop through each target variable, calculate the required conditions, and assign the new flag columns:

import pandas as pd

# Recreate your sample dataset
df = pd.DataFrame({
    "ID": ["A", "B", "C", "D"],
    "Var1": [1, 1, 2, 2],
    "Var2": [5, 5, 5, 6],
    "Var3": [15, 7, 15, 10]
})

# Iterate over each Var column to create flags
for col in df.columns[df.columns.str.startswith("Var")]:
    # Get the maximum value for the current column
    col_max = df[col].max()
    # Create the flag column: True if value is max OR >=10
    df[f"{col}_B"] = (df[col] == col_max) | (df[col] >= 10)
    # Convert boolean to T/F to match your expected output
    df[f"{col}_B"] = df[f"{col}_B"].map({True: "T", False: "F"})

# View the result
print(df)

This will produce the same flagged table as the R solution. If you want 1/0 instead of T/F, replace the map() line with df[f"{col}_B"] = df[f"{col}_B"].astype(int).

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