Set header when creating table from CSV

Question

I have a csv "pf.csv":

Jules,Winnfield  
Vincent,Vega  
Mia,Wallace  
Marsellus,Wallace

And would like to specify a list of symbols which become the header when I read the csv. Normally I would load the csv like so:

("SS";enlist ",") 0: `$"pf.csv"

but that actually sets the first row as the keys in the flipped dictionary (i.e. the header in the table)
In the documentation for 0: I read

Optionally, 0: can take a three-item list as its second argument, containing the file handle, an offset at which to begin reading, and a length to read.

But that's inconvenient as the offset has to be given in number of characters and not in lines.

Alex R. · Accepted Answer · 2018-05-21 13:56:37Z

2

The way to go about this is to specify the column names before the bit you use to load the csv.

flip`fname`surname!("SS";",")0:`:pf.csv

You will also have to drop enlist because you do not have any column headers in your csv.

Another option would be to name the columns inside your *.csv file and then you can simply use enlist in your query to specify that the first row contains the column names.

Some more details here:

http://code.kx.com/q4m3/11_IO/#1152-variable-length-records https://code.kx.com/wiki/Reference/ZeroColon#Load_Delimited_Records_.28Read_CSV.29

edited May 21, 2018 at 13:56

answered May 21, 2018 at 13:44

Alex R.

7255 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

emc211 · Accepted Answer · 2018-05-21 13:44:06Z

1

Could you try

flip `firstName`lastName!("SS";",") 0: `$"pf.csv"

answered May 21, 2018 at 13:44

emc211

1,3897 silver badges14 bronze badges

Collectives™ on Stack Overflow

Set header when creating table from CSV

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related