Cannot read csv file with pyq

[unix9999]

Questions

• [ ] Which operating system are you using (if Linux, please provide flavour of it, i.e RedHat, CentOS or Ubuntu), is it 32-bit, or 64-bit?

  Linux 64-bit, Ubuntu

• [ ] Which version of PyQ are you running? Please provide output of pyq --versions, if PyQ isn't operational, please provide Python interpreter version and PyQ version python -V; python3 -V; pip list | grep pyq:

  PYQ 4.1.4; python 3.5.2

• [ ] Which version of kdb+ are you using, is it 32-bit or 64-bit?

  64-bit; kdb+ 3.6

  • [ ] If on 64-bit, is your QLIC set? Please provide output env | grep QLIC on linux/macOS, or set|grep QLIC on Windows.

    Not set.

• [ ] Did you use virtual environment to install PyQ? If not, why?

  • Yes

• [ ] Where is your QHOME? Please provide output env | grep QHOME on linux/macOS, or set|grep QHOME on Windows.

  QHOME=/home/robert/Downloads/kdb

• [ ] Do you use Conda? If so, what version?

  No

Steps to reproduce the issue

q("table1: ("SSFFFIFFI"; enlist ",") 0:`data_fin.csv")

Expected result

Read the table successfully

Actual result

q("table1: ("SSFFFIFFI"; enlist ",") 0:`data_fin.csv")
                         ^
SyntaxError: invalid syntax

(The data can be read in q successfully: q)table1: ("SSFFFIFFI"; enlist ",") 0:`data_fin.csv)

[abalkin]

When you have double quotes inside a q query, you need to use single quotes to surround it:

q('table1: ("SSFFFIFFI"; enlist ",") 0:`data_fin.csv')