Popular recipes tagged "columns" but not "komodo"http://code.activestate.com/recipes/tags/columns-komodo/2012-05-22T18:25:21-07:00ActiveState Code RecipesWorking with Excel Indexes (Python)
2012-05-22T18:25:21-07:00Garretthttp://code.activestate.com/recipes/users/4181290/http://code.activestate.com/recipes/578142-working-with-excel-indexes/
<p style="color: grey">
Python
recipe 578142
by <a href="/recipes/users/4181290/">Garrett</a>
(<a href="/recipes/tags/column/">column</a>, <a href="/recipes/tags/columns/">columns</a>, <a href="/recipes/tags/excel/">excel</a>, <a href="/recipes/tags/python/">python</a>).
</p>
<p>I have had extensive issues working with excel indexies (i.e. 'AA100'). Here is code to convert out of and into all of the indexes.</p>
<p>There may be better ways to do this, I don't care anymore. This works.</p>
Get columns of data from text files (Python)
2010-10-28T16:18:19-07:00aliniumhttp://code.activestate.com/recipes/users/4175605/http://code.activestate.com/recipes/577444-get-columns-of-data-from-text-files/
<p style="color: grey">
Python
recipe 577444
by <a href="/recipes/users/4175605/">alinium</a>
(<a href="/recipes/tags/columns/">columns</a>, <a href="/recipes/tags/file/">file</a>, <a href="/recipes/tags/parsing/">parsing</a>).
</p>
<p>Read in a tab-delimited (or any separator-delimited like CSV) file and store each column in a list that can be referenced from a dictionary. The keys for the dictionary are the headings for the columns (if any). All data is read in as strings.</p>