Re: Useful heuristics for analyzing arrays of data to determine column header

...autodetect...malformed data...try...

Skip the first line. Insist on sound data/specs. Don’t waste your time. Regards, Karl

«The Crux of the Biscuit is the Apostrophe»

perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfbish")->decrypt_hex($ENV{KARL});'Help

Comment on Re: Useful heuristics for analyzing arrays of data to determine column header Download Code

Replies are listed 'Best First'.
Re^2: Useful heuristics for analyzing arrays of data to determine column header by bliako (Abbot) on Feb 15, 2019 at 23:56 UTC
I agree with you but ... if data has no clean header (which is the simplest task in data-collection) then I suspect some of the rows will not be cleaned either. For example, there might be missing fields in rows, truncated or overflowed fields (because of some weird instrument error or network error or conversion error) or formally correct fields but qualitatively wrong (I mean an uncalibrated instrument etc.). So, if (yet another) outlier detection module comes out of this, provided nysus has the time, then let it be, I say.	[reply]

Replies are listed 'Best First'.

Re^2: Useful heuristics for analyzing arrays of data to determine column header
by bliako (Abbot) on Feb 15, 2019 at 23:56 UTC

I agree with you but ... if data has no clean header (which is the simplest task in data-collection) then I suspect some of the rows will not be cleaned either. For example, there might be missing fields in rows, truncated or overflowed fields (because of some weird instrument error or network error or conversion error) or formally correct fields but qualitatively wrong (I mean an uncalibrated instrument etc.). So, if (yet another) outlier detection module comes out of this, provided nysus has the time, then let it be, I say.

[reply]