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 lo...

Vagrant up in the cloud (DigitalOcean)

It's quick and easy to start your virtual machine in the cloud if you use vagrant. Like, 55 seconds fast. I find it especially handy for toy projects that I need on the web quickly or when I don't want another virtual machine to gobble up resources on my laptop. I'm going through the steps for DigitalOcean. It's similarly easy for Amazon Web Services (AWS), but I find their web interface somewhat discombobulated. A word on pricing : if you use the cloud for a small project it's basically free. A full day on Digital Oceans costs 16 cents. That's (hopefully) less than you tip on a cup of coffee. There are a lot of online coupons that'll get you through the first few months. AWS offers a full year for free, see http://aws.amazon.com/free/ . I'm assuming that you have vagrant installed and a Vagrantfile already written or generated with  vagrant init . Ok, let's get started! First, download the vagrant plugin. vagrant plugin install vagrant-digital...