rtidyversestringr
Remove part of a string from a data.frame column
I'm working with a data.frame that contains one character column. I would like to make changes to some of the rows. For instance, on row 54 I would like to remove ", Energy Transport System Operators (ELIA, RTE)"
I tried:
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")
but it didn't work. I also tried:
funding$x11_funding_sources<-gsub(", Energy Transport System Operators (Elia, RTE)", "", funding$x11_funding_sources)
but it also failed.
What am I doing wrong?
Data
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"
))
Solution
By default the pattern supplied to str_replace is assumed to be a regular expression. In regular expressions, ( and ) have special meanings. To match a literal stirng, use the fixed() function. For example
str_replace(funding$x11_funding_sources,
fixed("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")
- Test whether one factor is nested in another
- Renaming columns in the global environment
- How can I use a character containing the DB instead of the connectin in R?
- Identifying all columns shared in common by a set of files and then vertically stack them
- curly-curly braces - why won't this function accept an unquoted variable
- Concatenate columns from Excel file based on sheet name and column's name
- Conditioning previous values within groups in R
- Finding out which columns are same in different files
- Rcpp error, learning Rcpp and C++ on mac
- How can I subset a list, based on list element details, using sapply?
- Reactively pull data from list objects in Shiny
- read_xml not recognizing the contents inside the nodes and returning charater[0]
- Saving plots in multiple columns using ggsave() cuts 2/3 of output
- Replacing NA's within a set of similar values
- Hide initially displayed code from shiny modularized app after clicking actionButton
- edit plot attributes manually and redraw
- Reformat data to include 2 minute time intervals
- ggsurvplot not displaying number at risk for time 0
- Change width of callout-block in Quarto dashboard
- Is there a R function to pair elements from two columns of a data.frame to make a new data.frame
- Question about glm family in R
- How to flatten a list of lists?
- Is there a fast/clever way to return a logical vector if elements of a vector are in at least one interval?
- how can I combine three tables - 2 separate questionnaires used on the same cohort and one table with blood results
- Modify pop-up message in leaflet map
- Conditional bslib tooltip
- How to specify column parameters programmatically?
- Complex subsetting in R for case-control study
- Set CMU Sans Serif font on pdf quarto
- How to remove string before a certain delimiter in R?