Slightly sacreligious, but I would suggest reading it into Python Pandas and transposing it (possibly using the Pandas.jl interface). Julia's DataFrames doesn't support transposable tables (although there may be other ways to deal with it).
Cheers, Kevin On Wednesday, September 3, 2014, Leah Hanson <[email protected]> wrote: > So, assuming you have a CSV file that looks like this: > > ~~~ > Column One,2,3,4 > Column Two,2,5,7 > Column Three,1,9,8 > ~~~ > > But each line has a lot more numbers in it. I would like to read it into a > DataFrame, where the DataFrame would understand it as: > > ~~~ > Column One, Column Two, Column Three > 2,2,1 > 3,5,9 > 4,7,8 > ~~~ > > Is the best thing just to edit the file first into a normal format, or is > there some option I can pass into DataFrames to make it understand? (I did > not see one on the I/O page of the DataFrames docs, but that can be out of > date sometimes.) > > [I realize this is an unusual thing to want. I expect to just edit the > file to be in the right order, but I wanted to check to see if DataFrames > already handles this.] > > Thanks, > Leah >
