It looks like you are trying to use the inverted Table format but with a
header row.
load 'tables/dsv general/misc/inverted'
({. ,: ifa@:}.) ',' readdsv 'test.csv'
┌──────┬──────────┬──────────┐
│deptno│dname │location │
├──────┼──────────┼──────────┤
│10 │Accounting│"New York"│
│20 │Research │Dallas │
│30 │Sales │Chicago │
│40 │Operations│Boston │
└──────┴──────────┴──────────┘
For working with this format you may find the following addon useful:
https://github.com/tikkanz/jdataframe
On Thu, Aug 18, 2022 at 2:28 AM Raul Miller <[email protected]> wrote:
> ({.,:,each/@:(,:each)@}.) ',' readdsv 'dept.csv'
> ┌──────┬──────────┬──────────┐
> │deptno│dname │location │
> ├──────┼──────────┼──────────┤
> │10 │Accounting│"New York"│
> │20 │Research │Dallas │
> │30 │Sales │Chicago │
> │40 │Operations│Boston │
> └──────┴──────────┴──────────┘
>
> ,each/,:each }. ',' readdsv 'dept.csv'
> ┌──┬──────────┬──────────┐
> │10│Accounting│"New York"│
> │20│Research │Dallas │
> │30│Sales │Chicago │
> │40│Operations│Boston │
> └──┴──────────┴──────────┘
>
> (Though I would recommend using the jd addon, instead, if your data
> volumes are especially large.)
>
> I hope this helps,
>
> --
> Raul
>
> On Wed, Aug 17, 2022 at 7:48 AM Pawel Jakubas <[email protected]>
> wrote:
> >
> > Dear J enthusiasts,
> >
> > Let's say I have the following csv file
> > $ cat dept.csv
> > deptno,dname,location
> > 10,Accounting,"New York"
> > 20,Research,Dallas
> > 30,Sales,Chicago
> > 40,Operations,Boston
> >
> > Now I read it using dsv addon:
> > load 'tables/dsv'
> > readdsv jpath './dept.csv'
> > ┌──────────────────────┐
> > │deptno,dname,location │
> > ├──────────────────────┤
> > │10,Accounting,New York│
> > ├──────────────────────┤
> > │20,Research,Dallas │
> > ├──────────────────────┤
> > │30,Sales,Chicago │
> > ├──────────────────────┤
> > │40,Operations,Boston │
> > └──────────────────────┘
> > ',' readdsv jpath './dept.csv'
> > ┌──────┬──────────┬──────────┐
> > │deptno│dname │location │
> > ├──────┼──────────┼──────────┤
> > │10 │Accounting│"New York"│
> > ├──────┼──────────┼──────────┤
> > │20 │Research │Dallas │
> > ├──────┼──────────┼──────────┤
> > │30 │Sales │Chicago │
> > ├──────┼──────────┼──────────┤
> > │40 │Operations│Boston │
> > └──────┴──────────┴──────────┘
> >
> > Questions:
> > 1. How to read the file to get:
> >
> > ┌──────┬──────────┬────────┐
> > │deptno│dname │location│
> > ├──────┼──────────┼────────┤
> > │10 │Accounting│New York│
> > │20 │Research │Dallas │
> > │30 │Sales │Chicago │
> > │40 │Operations│Boston │
> > └──────┴──────────┴────────┘
> >
> > 2. How to omit header upon reading?
> >
> > Also the link in line does not work (I bet it should point to
> > https://github.com/jsoftware/tables_dsv/blob/master/test/test_dsv.ijs)
> >
> > To see more examples of usage, open and inspect the test_dsv.ijs
> > <http://www.jsoftware.com/wsvn/addons/trunk/> script.
> >
> > Thanks and cheers,
> >
> > Pawel
> > ----------------------------------------------------------------------
> > For information about J forums see http://www.jsoftware.com/forums.htm
> ----------------------------------------------------------------------
> For information about J forums see http://www.jsoftware.com/forums.htm
>
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
