[megan_mcp]

Hi @karthik

I see you have received your certificate so congratulations on completing the capstone!

I’ve looked in to your comments about the sample data and there are some inaccuracies. I will make sure to have these updated for future users.

If you have any more questions please feel free to let me know!

Many thanks,

Megan 🙂

[megan_mcp]

Hi @Jonathan

If you simply run:

q) s except .Q.A
"eifehisr"

This should work fine.

[megan_mcp]

Hi @Yu

When creating your tradeContext table are selecting from the trade table or a variation of the trade table that you have created yourself?

This is how I see some people get caught out, as the format of these manually created tables are incorrect.

Let me know!

Many thanks,

Megan

[megan_mcp]

Hi @lestat-jin

If you are still receiving the init.q evaluation error, restart your kernel and this should go away.

Thanks,

Megan

[megan_mcp]

Hi Nayan,

This is an example format of how you should load in a CSV file:

t:("SFI";enlist",") 0: `$csvPath

• No spaces between the column types
• The use of ‘enlist’ which is the delimiter used to return the CSV as a table

Use this format to adjust your answer accordingly. If you have any further questions, please let me know 🙂

Thanks,

Megan

[megan_mcp]

Hi Jonathan,

Glad to see you got sorted!

If you have any further questions, please feel free to ask 🙂

Best regards,

Megan

[megan_mcp]

Hi @Jonathan

Thank you for sending the example!

Reply from @rocuinneagain

Sample data:

q)list:("wKDe arB33e on";"I a quSesGREATt!") 
q)list 
"wKDe arB33e on" 
"I a quSesGREATt!"

except cannot operate on lists of lists

q)list except .Q.A 
'type   
[0]  list except .Q.A

You can project and use each

q)except[;.Q.A] each list 
"we ar33e on" 
" a quest!"

Or to use infix notation use each left \:

q)list except\: .Q.A 
"we ar33e on" 
" a quest!"

• https://code.kx.com/q/ref/except/
• https://code.kx.com/q/ref/maps/#each
• https://code.kx.com/q/basics/application/#projection
• https://code.kx.com/q/ref/maps/#each-left-and-each-right

[megan_mcp]

Maybe I’m understanding wrong, but if it’s a list of strings:

q)list: “wKDe arB33e on”, “I a quSesGREATt!”
q)list except .Q.A, .Q.n   //remove capitals and numbers
"we are on a quest!"

Or if you meant a list of lists:

q)list1: ("TpFcIc", "endkDg", "ZORkwh"), ("SjKvBM", "ioWzYM", "Ibuyjf")
q)list1 except .Q.A
"pccendkgkwhjviozbuyjf"

Apologies if I’m not understanding correctly. If you could provide a screenshot of an example, I would be happy to help.

Megan

[megan_mcp]

Hi @Yu

Sorry my mistake .. sorting the time by ascending order wasn’t the error.

In the exercise it states “This should have two extra columns – bid and ask”

I’ve noticed you have formatted your table to have your ask column before your bid column which has resulted in the formatting being incorrect.

I’ve tested your code by swapping the two columns and the test passed.

Hope this helps.

Megan

[megan_mcp]

Hi @Yu

`time xasc select option_id, time ..

Hope this helps!

[megan_mcp]

Hi @Yu

Can you try sorting time in ascending order? I realise this may not be obvious in the question itself so I will look in to adjusting this question for future users.

Thanks,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

I see your tables edge15, edgeProfile and optProfile all select data from different versions of the trade table e.g. trade06 or tradeWithAvgEdge which means the formatting of those tables may be off.

Try using just ‘trade’ instead of the adjusted versions.

Let me know if this works.

Thanks,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

Thank you for sending that over!

Your code seems to be correct so I’ll need to take a further look. Can I ask that you download your project.md file and send it to be at mmcparland@kx.com ?

Thanks in advance.

Best regards,

Megan

[megan_mcp]

Hi @JuanpeGarcia11

Can you send me a screenshot of the meta for your edge15 table?

Also, the first 4 rows of your table should look like this – (screenshot attached)

Many thanks,

Megan

[megan_mcp]

Hi @hoffmanroni

Glad to hear you found a solution !

If you need help with any other questions, feel free to reach out 🙂

Many thanks,

Megan