Update single row of data frame in R

my dataframe:

So first of all, I want to check if an input matches the name in any row.

My solution for the filter so far:

# input$df <- Versicolor

import dplyr
df_table <- df_table %>%
      dplyr::filter(grepl(input$df, Name, ignore.case = TRUE))

If there is a match, I’d like to update/overwrite this row with new values, like in the following table:

The name stays the same, but only the value changes.

Do you have any advice?

>Solution :

We can use a join

library(dplyr)
df_table %>%
    left_join(input, by = c("Name")) %>%
    mutate(Value = coalesce(Value.x, Value.x), .keep = "unused")

Or with data.table

library(data.table)
setDT(df_table)[input, Value := i.Value, on = .(Name)]