search

jadenthem / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

Please add 'transpose data' import option #173

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
For data that is transposed (i.e. rows are columns / columns are rows), you 
cannot manipulate the data.

It'd be great if you could check a box to transpose the data on import to avoid 
having to do this manually before creating a new project.

Original issue reported on code.google.com by moog...@gmail.com on 30 Oct 2010 at 9:01

GoogleCodeExporter commented 8 years ago 
We have two Transpose commands in the upcoming version 2.0. You can apply them 
after you import your data. Could you provide some sample data that you need to 
transpose, so that we can tell whether the new Transpose commands can answer 
your needs?

Original comment by dfhu...@gmail.com on 30 Oct 2010 at 9:08

GoogleCodeExporter commented 8 years ago 
Sure, below.  The result of the transpose should be four columns with headings 
"Label", "Min", "Avg", "Max".

Label,"host1","host2","host3","host4","host5","host6","host7","host8","host9","h
ost10","host11","host12","host13","host14","host15","host16","host17","host18","
host19","host21","host22","host23","host25","host26","host27","host29","host30",
"host31","host32","host41","host42","host43","host44","host45","host46"
Min,8024,632,816,112,328,876,056,2748,0676,3704,3176,444,720,528,000,2412,2392,8
352,6464,,1236,5692,844,340,0796,2320,360,752,092,680,836,664,4832,432,312
Avg,8244,6767,1966,5515,9523,9250,8674,9335,070057549858,4782,1023,0674,7215,941
3,9805,6900,4739,0924,0768,,7094,8598,7173,9638,5399,7911,3961,5059,1257,2204,24
92,2083,1747,4622,3279
Max,1248,1216,9600,0760,5432,3712,2700,9596,2136,4692,0276,6308,9300,2176,8984,9
692,2224,9964,3524,,4652,5296,1332,6652,5796,0336,0236,4516,8740,7268,3372,6400,
1808,4844,5044

Original comment by moog...@gmail.com on 30 Oct 2010 at 9:36

GoogleCodeExporter commented 8 years ago 
Currently, it's do-able, but not convenient. I'll think about how to support 
transposing better.

Original comment by dfhu...@gmail.com on 31 Oct 2010 at 9:29

GoogleCodeExporter commented 8 years ago

Original comment by tfmorris on 16 Nov 2010 at 6:10

GoogleCodeExporter commented 8 years ago 
I think this is fixed now :)

Original comment by danpaulsmith on 10 Jan 2012 at 4:23

GoogleCodeExporter commented 8 years ago 
We've got the two transpose commands that David mentioned for 2.0, but, unless 
I'm missing something (entirely possible), I don't think they handle this case 
easily.

Original comment by tfmorris on 11 Jan 2012 at 6:14

GoogleCodeExporter commented 8 years ago 
It doesn't sound to me like those two commands would handle this case, either.

The problem here is how to preview this data. Previewing right now would parse 
only some limited amount of data at the beginning of the file to render the 
first 100 rows or so. But with this horizontal format, that approach cannot get 
to all of the columns unless we parse most of the file already (we read into 
some part of the last line in the file).

Original comment by dfhu...@gmail.com on 11 Jan 2012 at 7:10

GoogleCodeExporter commented 8 years ago 
Why not display a limited amount of horizontal columns as well as rows.  I 
think it'd be acceptable to show the first 100 rows only, which means you could 
continue to just read the first 100 lines from the input.

Original comment by moog...@gmail.com on 11 Jan 2012 at 10:32