string - R pattern matching multiple combinations of rows in columns for replacement? -


i'm trying figure out how identify instances of strings 1 column of dataframe on column in same dataframe in order replace. in case have forum postings i've pulled in people reference other users name , want rid of names analyses otherwise count high quantity words. below dput data frame:

structure(list(uber_name = structure(c(9l, 2l, 1l, 2l, 3l, 10l,  3l, 9l, 11l), .label = c("aluber1968", "bigdreamslittlemoney",  "fubernyc", "jamesm", "jonnyplastic", "justdre", "king d", "klimarov",  "nycgirl705", "shumacker", "spike69", "theitalian", "uberman8263",  "ez2dj", "manhmptn", "nycdriver", "staytune", "ubs", "ubured",  "jme10", "lennyyellowcab", "mir", "eagle88", "ibuys4730", "nousername",  "bathotrask", "douglas", "lgc", "jakeinny098", "rustyshackelford",  "shabbyroch", "ubershiza", "drbrkln", "elys123", "bossdriver",  "herbyherb", "jim1985", "malik38", "stidriver", "vxlon7", "waqar",  "tohunt4me", "dogpound", "sulib", "albrklyn", "john cunningham",  "mreeves", "pinkfoot", "alextheboss", "luisannalui", "censoredbythefcc",  "kony", "cieru", "jorlev", "smooth954", "marcusguber", "nyc321",  "tony new jersey", "vanstaal", "bkrah", "brunoamat2", "gebbels6",  "kevin7889", "uanic", "uber og", "uberkilledmymarriage", "ya mon me",  "hunkawestchester", "mr affinito", "ninja warrior", "nononsense",  "notacabdriver", "notauberhater", "twofiddymile", "bilyvh", "cybertec69",  "johnnyblanco", "sobe", "ubernyc"), class = "factor"), uber_write = c("i see people post getting w",  "you have 2 choices either drive", "more year ago didnt drive ",  "yeah stopped driving them for", "ive been getting promotions la",  "fubernyc saidive been getting ", "shumacker saidand feel importan",  "fubernyc saidive been getting ", "they start coming after few months " ), uber_date = structure(c(1l, 1l, 1l, 1l, 1l, 1l, 1l, 1l, 1l ), .label = c("jan 19, 2017", "mar 30, 2017", "jan 23, 2017",  "jan 12, 2017", "jan 9, 2017", "jan 1, 2017", "dec 31, 2016",  "nov 26, 2016", "nov 3, 2016", "dec 22, 2016", "dec 13, 2016",  "dec 2, 2016", "nov 15, 2016", "oct 31, 2016", "oct 20, 2016",  "mar 14, 2017", "sep 1, 2016", "jul 26, 2016", "mar 1, 2017",  "feb 25, 2017", "sep 8, 2016", "sep 9, 2016", "apr 21, 2015"), class = "factor")), .names = c("uber_name",  "uber_write", "uber_date"), class = c("data.table", "data.frame" ), row.names = c(na, -9l), .internal.selfref = <pointer: 0x0000000000220788>)

i've used gsub before can't figure out how apply instance. want take names in "uber_names" column , removes these users of "uber_writes" postings.

you make vector uber_names of user names in data.table (dt) , generate regular expression (name1|name2|name3) replace matching user names "", like:

library(data.table) uber_names <- dt$uber_name dt[, uber_write_filtered := gsub(     pattern = paste0("(", paste(uber_names, collapse = "|"), ")"),     replacement = "", uber_write)]

Comments

Post a Comment

Popular posts from this blog

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more