#Usefull Linux hint
Skip the first line of a file
tail -n +2 file.log
re order columns in file (cut maintains order) tab delimited
awk -F'\t' -v OFS="\t" '{ print $2, $5 }' input.tsv > output.tsv
#Usefull Linux hint
Skip the first line of a file
tail -n +2 file.log
re order columns in file (cut maintains order) tab delimited
awk -F'\t' -v OFS="\t" '{ print $2, $5 }' input.tsv > output.tsv
| format | metric | year | number_of_records | value_actual | |
|---|---|---|---|---|---|
| CD | Units | 1973 | 1 | ||
| CD | Units | 1974 | 1 | ||
| CD | Units | 1975 | 1 | ||
| CD | Units | 1976 | 1 | ||
| CD | Units | 1977 | 1 | ||
| CD | Units | 1978 | 1 | ||
| CD | Units | 1979 | 1 | ||
| CD | Units | 1980 | 1 | ||
| CD | Units | 1981 | 1 |
| #Author: Aram Comjean Dec/ 2015 | |
| #http://stackoverflow.com/questions/6667201/how-to-define-two-dimensional-array-in-python | |
| Lookup = [[0 for x in range(50)] for x in range(50)] | |
| def alignment_paths (x,y): | |
| #if we have a 1x1 matrix or are at the left or top edge, there is one path | |
| if (x == 0 or y == 0): | |
| return 1; |
| import random | |
| from Bio import Entrez | |
| from Bio import SeqIO | |
| #Author: Aram Comjean | |
| #Date: Nov/ 2015 | |
| #Hungtington's Disease CAG count | |
| # returns random nucleotide sequence with at least the number of "cag" repeats specified |
| import random; | |
| #Author: Michael Thomas/ Aram Comjean | |
| #Date: Nov/ 2015 | |
| #Hungtington's Disease CAG count | |
| # generates random sequence with at least the number of "cag" repeats specified | |
| def generate_random_seq (number_cag_repeats): |
| #Python Problem 1 | |
| #reverseComplement.py | |
| #Introduction to Bioinformatics Assignment 2 | |
| #Purpose: reverse compliment | |
| #Your Name: Aram Comjean | |
| #Date: 10/11/2105 | |
| #s1 is the string you should use to generate a reverse complement sequence | |
| #Note that your result needs to be presented in the 5' to 3' direction |
| -- Retrieve descendants | |
| -- ==================== | |
| -- retrieve descendants of #4 | |
| SELECT c.* | |
| FROM Comments AS c | |
| JOIN TreePaths AS t ON c.comment_id = t.descendant | |
| WHERE t.ancestor = 4; | |
| -- Retrieve ancestors |
| <?php defined('SYSPATH') or die('No direct script access.'); | |
| /** | |
| * MySQL "Closure Table" for Kohana based on Bill Karwin design. | |
| * | |
| * @link http://www.slideshare.net/billkarwin/models-for-hierarchical-data | |
| * @TODO improve | |
| * | |
| * sql schema: | |
| * CREATE TABLE `closures` ( | |
| * `id` int(11) NOT NULL AUTO_INCREMENT, |