Merging the filename with tsv files for master file · Biostar

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

Merging the filename with tsv files for master file

Hi all,

I have a query. I have a file named as hCoV-19_USA_TN-SPHL-2527_2022_orf.tsv and merged.tsv in the same folder. I want to take the filename for eg, hCoV-19_USA_TN-SPHL-2527_2022 from orf.tsv file and add it to same merged.tsv file which are present in the same folder as column named as Virus_name. Can anyone please let me know how to do it? I tried using python but it is not giving me the correct output. Input: hCoV-19_USA_TN-SPHL-2527_2022_orf.tsv -> hCoV-19_USA_TN-SPHL-2527_2022

Output: merged.tsv -> hCoV-19_USA_TN-SPHL-2527_2022 - Virus_name as column and print as per the number of rows

Please help me regarding this.

genomics

• 896 views • link

updated 2.9 years ago by barslmn •

• written 2.9 years ago by smrutimayipanda •

Could you add samples from your files and your expected output.

• 0 views • link

written 2.9 years ago by barslmn •

0 answers

No answers yet.

Log in to answer this question.

More posts like this

scRNAseq error source a custom function
written 3.1 years ago by camillab. •

Hi, Apologies if it is a stupid error/common knowledge! I am trying to integrate two scRNAseq datasets and I am following [this tutorial][1] and I …
STRING API
written 3.8 years ago by kamalika •

Hi, I am using the Stringdb api to retrieve all the interaction partners of the given input proteins. I am giving a list of input …
Change rows of two different files into columns and paste them alternatively in a new file in shell…
written 4.2 years ago by Sarah •

I have 2 files, both with 10144 rows and 105 columns. Two matrices with sequencing TPM values for 105 samples with first column as gene …
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 …
mapping of drug names of excel sheet and tsv files
written 5.9 years ago by smrutimayipanda •

I have an excel sheet in which two sheets are available. I want the 2nd sheet to be compared with my drug tsv file. My …
Add filename as column headers in file
written 6.0 years ago by smrutimayipanda •

I have a combined file consisting of gene columns and its respective logFC values. I have used this R code for making this combined file. …
file handling in R
written 6.0 years ago by smrutimayipanda •

i want to extract gene column (2nd column of every file) from multiple text files and merge them to get unique gene list. But in …
paired-end sequence alignment
written 7.2 years ago by evelyn

I am trying to run `bwa` for multiple paired end fastq files, located in a folder named `sample_data`. I am using this code to get …
Solve the problem of Hisat2:Align reads to genome
written 7.4 years ago by Kanoo •

Firstly, I set an index through Hisat2. When I use Hisat2 to alignment, there appears an error-- `Error:could not open alignment output file`. But I …
Problem with R package QuasR: qAlign function does not work
written 9.7 years ago by biomagician

Dear all, I am trying to use QuasR to analyse my RNA seq data. > sampleFile <- "output/genome/ref/seq/samples_rna_single.txt" > genomeFile <- "output/genome/ref/seq/celegans.fa" > proj2 <- …