移除data.frame字符列指定字符串失败，求排查解决方法

我正在处理一个包含字符列的data.frame，想要修改部分行的内容，例如移除第54行中的", Energy Transport System Operators (Elia, RTE)"。我尝试了以下两种方法均未成功：

funding$x11_funding_sources <- str_replace(funding$x11_funding_sources,
            "Nature conservation funds from National and/or Regional administrations, LIFE programme, Energy Transport System Operators (Elia, RTE)", 
            "Nature conservation funds from National and/or Regional administrations, LIFE programme")

以及：

funding$x11_funding_sources<-gsub(", Energy Transport System Operators (Elia, RTE)", "", funding$x11_funding_sources)

请问我哪里操作出错了？

附数据：

funding<-structure(list(x11_funding_sources = c("Nature conservation funds from National and/or Regional administrations", 
                                                "Nature conservation funds from National and/or Regional administrations, LIFE programme", 
                                                "Nature conservation funds from National and/or Regional administrations, Development funds from National and/or Regional administrations, European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc), Private funds, Different funds and also small donations used in the last 16 years", 
                                                "Private funds", "Nature conservation funds from National and/or Regional administrations, National and/or regional Research & Innovation funds", 
                                                "National and/or regional Research & Innovation funds", "National and/or regional Research & Innovation funds, Cohesion funds", 
                                                "National and/or regional Research & Innovation funds", "LIFE programme", 
                                                "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "National and/or regional Research & Innovation funds, European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "Iceland, Liechtenstein, Norway EEA Grants", "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "Nature conservation funds from National and/or Regional administrations, Private funds", 
                                                "Nature conservation funds from National and/or Regional administrations", 
                                                "Private funds", "Private funds", "Ministry for environment and the Croatian motorway enterprise", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "Nature conservation funds from National and/or Regional administrations, Development funds from National and/or Regional administrations, Biodiversity offsets, Private funds", 
                                                "Nature conservation funds from National and/or Regional administrations", 
                                                "Private funds", "Nature conservation funds from National and/or Regional administrations, LIFE programme", 
                                                "Nature conservation funds from National and/or Regional administrations", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "Private funds", "Cohesion funds", "National Strategic Reference Framework (NSRF 2014–2020) - Sectoral Program \"Transport Infrastructure, Environment and Sustainable Development\"", 
                                                "National and/or regional Research & Innovation funds", "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "LIFE programme, Private funds", "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "Private funds", "National and/or regional Research & Innovation funds", 
                                                "LIFE programme", "LIFE programme, Private funds", "LIFE programme", 
                                                "LIFE programme", "LIFE programme", "Nature conservation funds from National and/or Regional administrations, European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "LIFE programme", "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "LIFE programme", "European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "Nature conservation funds from National and/or Regional administrations, LIFE programme", 
                                                "Nature conservation funds from National and/or Regional administrations, LIFE programme, Energy Transport System Operators (Elia, RTE)", 
                                                "LIFE programme", "Nature conservation funds from National and/or Regional administrations, FEDER", 
                                                "Nature conservation funds from National and/or Regional administrations", 
                                                "Nature conservation funds from National and/or Regional administrations, Development funds from National and/or Regional administrations, Private funds", 
                                                "LIFE programme", "Nature conservation funds from National and/or Regional administrations, European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "Nature conservation funds from National and/or Regional administrations, National and/or regional Research & Innovation funds, Development funds from National and/or Regional administrations, LIFE programme, European research & innovation funds (E.g., Horizon, Biodiversa, etc.), European funds associated to other sustainability policies (e.g., climate, agriculture, Interreg, etc), Cohesion funds, Biodiversity offsets, Private funds", 
                                                "Nature conservation funds from National and/or Regional administrations, National and/or regional Research & Innovation funds", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)", 
                                                "European research & innovation funds (E.g., Horizon, Biodiversa, etc.)"
)), row.names = c(NA, -64L), class = c("tbl_df", "tbl", "data.frame"
))

你的问题出在正则表达式的特殊字符未处理：字符串里的(和)是正则表达式中的特殊元字符，用于表示分组，直接写的话会被解析成正则语法，而不是普通字符，导致匹配失败。

有两种修正方法：

方法1：使用fixed=TRUE关闭正则解析 #

gsub和str_replace默认会把匹配字符串当作正则处理，加上fixed=TRUE后会按普通文本查找替换，不需要转义特殊字符：

# 用gsub全局替换（如果有多行匹配的话）
funding$x11_funding_sources <- gsub(", Energy Transport System Operators (Elia, RTE)", "", funding$x11_funding_sources, fixed = TRUE)

# 或者用str_replace（只替换第一个匹配项）
library(stringr)
funding$x11_funding_sources <- str_replace(funding$x11_funding_sources, ", Energy Transport System Operators (Elia, RTE)", "", fixed = TRUE)

方法2：转义正则特殊字符 #

把(和)前面加上反斜杠\，但在R字符串里需要写两个反斜杠\\来表示一个实际的反斜杠：

funding$x11_funding_sources <- gsub(", Energy Transport System Operators \\(Elia, RTE\\)", "", funding$x11_funding_sources)

更精准：只修改第54行 #

如果只有第54行需要修改，直接定位该行操作更高效，避免全局替换可能带来的意外：

# 直接截取字符串到目标部分
funding$x11_funding_sources[54] <- "Nature conservation funds from National and/or Regional administrations, LIFE programme"

# 或者用字符串替换只针对该行
funding$x11_funding_sources[54] <- str_remove(funding$x11_funding_sources[54], ", Energy Transport System Operators \\(Elia, RTE\\)")

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