Simple .csv data import suddenly ignoring column headers.

[achim geiszlerParticipant]

Help.

Importing .csv files suddenly ignores header column.

[achim geiszlerParticipant]

… to give some background: I have two .xlsx files from a DAQ system, which basically are very similar, however do have different numbers of columns / rows. As each cell has the unit attached, I read the files into a pandas data frame and export it from this as .csv. Pandas seems to have a magic wand that removes the units and leaves the values untouched. Very nifty.

Then, I import the .csv into DataGraph. The one file works fine, as expected, the other one simply does not. It does not seem to accept the first line in the file as column headers.

I tried zapping gremlins (none), compared line endings (both LF, should be fine) and re-did the import / export thing in Python. To no avail. Sadly, DataGraph does not have a right mouse button context menu “make this line column headers”. So, I am stuck.

Thanks for any ideas (the files have 7.x and 5.y MB, I would be willing to upload them if this is not too large.

Best

Achim

[dgteamModerator]

Hi Achim,

There is a way to use a row for the column headers.  We just added a help article to explain.  Please check this out and let us know if this works for your data.

How to Set Column Headers

[achim geiszlerParticipant]

Perfect! “cntrl-click” … sorry, wasn’t intuitive for me. Works like a charm.

Thanks!

Best

Achim

[Author]

Posts