In my galaxy history Im currently working with multiple text tabular files but i like to add or change te headers from some of them. Its possible to change or add the header within galaxy? I looked in the forum and didnt find a solution yet
Yes, data files can be manipulated with many tools. The most commonly used are covered in this tutorial, see Data Manipulation Olympics
The idea would be to:
- Remove the existing header, if any
- Create a new file with the header you want to use instead
- “Concatenate” the two files together
If you get stuck, you can post back the first few lines of your existing file and explain what you want to replace it with. The format will be important, so just copy/paste into a block quote. But try yourself first. Learning how to do this is a core bioinformatics skill you’ll use over and over.
I got a question in this case the labels named as “Columns” from 1 to 17 by Multijoin are headers? When i download the file and open it in excel that labels seams to dissapear
Excel sometimes “tries” to interpret headers, and doesn’t always get it right.
Putting actual headers on your file inside Galaxy, then exporting that file as text will help Excel to read them in better, preserving the structure.
This is pretty easy to do, and we can show you and then it will be easier next time. Want to post back what the dataset looks like in Galaxy (eye icon) for more help? Also post back the first few lines (not just the header but also a few data lines) as a copy/paste and try to preserve the formatting by quoting the text here-- or just leave it exact from the paste and I can fix it up. Any spaces/tabs are important to keep for this.
Yes please i’ll apreciate the help because im a little bit confuse about that thank you JennaJ
|Column 1||Column 2||Column 3||Column 4||Column 5||Column 6||Column 7||Column 8||Column 9||Column 10||Column 11||Column 12||Column 13||Column 14||Column 15||Column 16||Column 17|
Ok, thanks @Nicolas_Romero_Villa
- Upload a plain text file that has nine tab separated terms. Don’t use Excel for this, instead use whatever plain text editor your OS supports. On MacOS, the app is name “text editor” and is already on your computer by default Not sure what is good for a PC but an internet search should find it.
- Use the tool Concatenate to “stack” the header-only text file on top of the current text file
- Click on the eye icon to make sure the result is Ok
Hope that helps!