search

jtablesaw / tablesaw

Java dataframe and visualization library
https://jtablesaw.github.io/tablesaw/
Apache License 2.0
3.56k stars 645 forks source link

read table with two header rows #1204

Closed tischi closed 1 year ago

tischi commented 1 year ago

Hi,

I have a table that looks like this:

Image, Image
Count1, Count2
100, 100
150, 170
... , ...

I would need to open it with column names: Image_Count1, Image_Count2 That is concatenate the first two rows into one header.

Is that possible?

Thanks!

aadrian commented 1 year ago

@tischi for this you need to do two steps. In the first one just get the raw data and transform it. Than in step two only use from the new format.

tischi commented 1 year ago

just get the raw data and transform it

Thanks! You mean opening the whole file as one big String or is there something in tablesaw that I could use?

lwhite1 commented 1 year ago

I would read it line by line and just combine the first two lines when you write

On Fri, Apr 21, 2023 at 8:47 AM Christian Tischer @.***> wrote:

just get the raw data and transform it

Thanks! You mean opening the whole file as one big String or is there something in tablesaw that I could use?

— Reply to this email directly, view it on GitHub https://github.com/jtablesaw/tablesaw/issues/1204#issuecomment-1517784769, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2FPARKCDDMRLCNNFUOWY3XCJ6U3ANCNFSM6AAAAAAXFEVSDI . You are receiving this because you are subscribed to this thread.Message ID: @.***>