Change a column name according to the file name · Biostar

This is a test version of Biostars. For the public version, visit https://www.biostars.org.

Change a column name according to the file name

I have around 52 files named like: ERR260147.genefamilies.tsv, ERR260158.genefamilies.tsv ERR275198.genefamilies.tsv, etc and each file has two columns. I want to change the second column name of each file according to the name of the file. For example, the second column name for file ERR260147.genefamilies.tsv will be named like ERR260147_Abundance-RPKs and for ERR275198.genefamilies.tsv will be ERR275198_Abundance-RPKs. Please note, part of a column name will come from the file name and a constant "_Abundance-RPKs".

Can anyone please help me.

thanks, dpc

bash

• 1,153 views • link

updated 5.8 years ago by Ram

• written 5.8 years ago by dpc

1 answer

Use awk. You'll need the variables NR, $2 and FILENAME and the function gsub. Google these and use them to assemble a mini-pipeline. This is a good learning exercise.

• 0 views • link

written 5.8 years ago by Ram

Log in to answer this question.

More posts like this

Update column on selectInput in DT data table Shiny
written 4.2 years ago by abseq •

Hi All, I want to create a data table where 1st column is "test" 2nd column is "select" and my 3rd column is "result". In …
How to move multiple files to multiple folders in linux/mac?
written 5.4 years ago by anikcropscience •

Hello, I have a folder containing *.fastq.gz files (R1 and R2) for many samples. For example, in the folder "Raw_WGS", I have several files like …
Renaming one column in multiple csv files using the filename itself.
written 5.5 years ago by pramach1 •

I have 52 files with same number of columns (5) with same titles (same headers), but different rows. I want to change one column named …
How to multiply all columns of a .csv table with a constant extracted from another table?
written 5.8 years ago by deep771992chanda •

I have 20 files where the filenames are like: `ERR260136.genefamilies.csv`, `ERR276187.genefamilies.csv`, etc. Each file has to be multiplied by one constant. The corresponding constant has …
How to extract out specific information from files within a directory?
written 5.8 years ago by deep771992chanda •

I have a around 50 files which are named in the format: ERR*.log (i.e. ERR23432.log, ERR12356.log, and so on...). From each file I want to …
bash script for catenating many paired end files
written 6.1 years ago by dpc

Hi friends!!! I have around 300 paired-end files from 150 samples (1 forward and 1 reverse read for each sample). I want to catenate respective …
cropped and incomplete "genus" stacked barplot generated with R
written 6.1 years ago by dpc

Hi friends, I am using R phyloseq software package for visualisation of data. I don't know why am I getting an incomplete stacked barplot at …
How can I bin my bed files into 500bp bins?
written 6.2 years ago by Tawny

I have several hundred bed files that will be processed by another colleague. I have been searching for a way to bin these by 500bp …
Plot graphs in R by loop and save it like jpeg
written 11.0 years ago by Korsocius

I am trying to plot graphs by loop. Input data: Tables, which have same ending `*depth.txt`, there is 2 tab delimited columns in table ``` …
How to import fasta file by using perl DBI.?
written 11.4 years ago by Krithi.S •

``` use DBI; use strict; use warning; my $textfile = "fasta.txt"; open (TEXT,"$textfile") or die "Could not open:$!"; my $dbh = DBI->connect("dbi:mysql:database=file",user,password,{RaiseError=>1}) or die "Could …