Skip to main content

Merging multiple files columnwise

Here's a little parser script, to merge multiple files. Each file has a header and a time course. I need all time courses in a single file, next to each other.

basedir = "./MassSpectrum/"

allData = [] # ms data from all files

filelist = Dir.new(basedir).entries
filelist.each {|f|
  if f !~ /\.txt/ # f is not a data file
    next
  end

  data = [] # ms data from this files
  massToCharge = 50
  readData = false # set to true once we are reading in ms data
  File.open( basedir+f).each { |line|
    case line
    when /^SPECTRUM/
      next
    when /raw/
      data.push line.chop.rstrip
      puts ":#{line.chop.rstrip}:"
      next
    when /^Mass/
      puts "starting"
      readData= true
      next
    end

    if readData # we are reading ms data, should go from 50 to 650
      arr = line.split
      while arr.first.to_i != massToCharge # a mass to charge ratio was skipped
        data.push 0
        massToCharge = massToCharge + 1
      end
      data.push arr.last
      massToCharge = massToCharge + 1
    end
  }
  allData.push data
}
open("results.xls","w") { |out|
  for i in 0..allData.first.size do
    allData.each{ |l|
      out << l[i]
      out << "\t"
    }
    out << "\n"
  end
}

Comments

Popular posts from this blog

Uploading a file with JQuery

You can easily submit data in an html form via jQuery's $.post. But you need to do a little more to upload a file. I suggest the jQuery Form Plugin . Here is the HTML form: <html> <head> <title>Title</title> </head> <body> <form action="/test.cgi" enctype="multipart/form-data" method="post"> <input name="myFile" type="file" /> <div id="results"> </div> </form> </body> </html> This is the Javascript file myFrom.js: $(document).ready(function() { $('form').ajaxForm( { beforeSubmit: function() { $('#results').html('Submitting...'); }, success: function(data) { var $out = $('#results'); $out.html('Your results:'); $out.append('<div><pre>'+ data +'</pre></div>');

Latex: Centering table larger than textwidth

Usually, you can center tables with \center. But when the table is longer than the \textwidth, it will be align with the left side margin. You can temporarily adjust the textwidth. % allows for temporary adjustment of side margins \usepackage{chngpage} \begin{table}     \begin{adjustwidth}{-.5in}{-.5in}          \begin{center}         \begin{tabular}{|c|}             \hline And here comes a very long line. And here comes a very long line. And here comes a very long line.  \\             \hline         \end{tabular}         \caption{This Table is longer than the text width. And its caption is really long, too. This Table is longer than the text width. And its caption is really long, too. This Table is longer than the text width. And its caption is really long, too. This Table is longer than the text width. }         \label{myTable}         \end{center}     \end{adjustwidth} \end{table}

Academic Job Search: Writing a good CV, research statement, and teaching statement

I won't give you boring details of how you should format your CV, there's enough resources out there that give you much better advise than I ever could, instead I will tell you what you can and should do during graduate school, to generate the content for your CV and statements. Please keep in mind that I was specifically looking for post doctoral research positions in mathematical biology . If you want to land a teaching or tenure position, some rules might be different. Job Application Timeline Academic Jobs beginning fall 2011 (June – September) Deadlines for postdocs : as early as November 2010 Asked for letters: September 2010 CV, Research Statement, Preprint/publications/thesis Draft of Research Statement August/September 2010 CV: first version in 2008, career services, periodically updated Jobs are advertised on https://www.mathjobs.org/ http://notable.math.ucdavis.edu/wiki/Mathematics_Jobs_Wiki Discussed everything with my advisor, proof-read by a