I have a dataframe with the followign column names: NewYork_10 NewYork_20 NewYork3_10 NewYork3_20 NewYork4_10 NewYork4_20 HongKong_10 HongKong_20 SanFrancisco_10 SanFrancisco_20 And I have a vector: list <- c("NewYork", "SanFrancisco") I want a script that creates a new dataframe, selecting those columns that have the exact same string before the underscore. In the example given above, you… Read More How to select the columns of a dataframe based on a vector of strings, matching for exact coincidence?

I have a file which contains relative paths like so: # source.txt ./somefile1 ./somefile2 .. what id like to do is replace the ./ with the base dir like so: # result.txt /home/foo/bar/somefile1 /home/foo/bar/somefile2 source.txt has some 15 million entries and Id like to replace all the ./ at the start to have the base… Read More search and replace string with backslash

Storing grep output with spaces. I wanted to store the output of grep command (with spacing) into variable or array and print it out with the spacing as well. File containing: ### Invoked at: Wed Dec 7 22:24:35 2022 ### Code: my $date = qx(grep -oP "\bInvoked at: \\K[^#]*\d" $file); print "Date: $date\n"; Expected output:… Read More perl store and print grep output with spacing

Hi All can you please help me I am trying to get the following output so basically I have 2 input files and we need only the common :names from both the input files along with there the lines below them the .name/of/file lines. Till now I have tried: awk ‘FNR==NR { a[$1]; next }NF<=1… Read More How to get only the first occurrence of the pattern in bash script

Suppose I have a dataset "df" as below How to delete all rows except those belonging to groups "b" and "d" (or those belonging to any combination of two or three groups)? I know how to do it if I had to keep only one group, but cannot figure out how to keep more than… Read More How to delete all rows except those belonging to more than one group

for example when typing the following command in terminal egrep (cs)*449 hi.txt gives the result -bash: syntax error near unexpected token `cs’ >Solution : Maybe you can add double quote like this: egrep "(cs)*449" hi.txt I hope it’s help for you

I am using grep to find any files that contain the word "hello" in the current directory: grep -l ‘hello’ * Given these files: test1 hello hi how are you stuff test2 welcome hello etc test3 hey there hello The output is: test1 test2 test3 However, I want to search these files for the word… Read More How can I skip the first and last line while using grep?

I am trying to search for the file/script with a specific keyword in all the sub-directories beginning from the root or home directory. My search yielded so many files, but I want to search only .js, .py types. I want to know the file name containing this matching word. grep -name ‘*.js’ -rl "matching word"… Read More Linux search subdirectories and among .js .py files for a specific keyword

I have a matrix(about 10,000×10,000), and I want to find the column number that contains ‘0’. Matrix (test.txt) : 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1… Read More Output all column numbers for a particular character

Is it possible to grep lines only if containing 2 specific strings in it? I have logs like this and I would like to grep only lines containing strings "13/Dec/2022:11" AND "GET /fr/test" access.log:site.ch 111.222.333.444 – – [13/Dec/2022:11:40:00 +0100] "GET /fr/test HTTP/1.1" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36" >Solution… Read More Grep lines only if containing 2 specific strings