[megan_mcp]

Hi @timbs_1995

If you are still having trouble with this exercise can I ask that you download your project.md file and send it to me at mmcparland@kx.com ?

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

The \l f1 command simply loads in the lap data from disk.

You must then preform your select statement for lapTable.

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

In exercise 2.3, it asks you to define a dictionary using the logic from the table above (screenshot below). This is missing from your function and is needed to be able to complete the functional code for benchmark and chk.

Can I ask that you include this and let me know the outcome?

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

It states in the exercise that you must load the lap table from disk.

To do we use the system command:

\l

**Tip: Instead of listing each individual column, you can simply run

select from lap

To retrieve the entire lap table.

Hope this helps!

Thanks,

Megan

[megan_mcp]

Hi @masmail

For question 2.3, you must convert the code that is provided within the .f1.checkSensor function into functional form.

So instead of the following select statement:

benchmark:select benchmarkValue:avg sensorValue by sensorId from lapTab;

It must be in the following format:

Functional Select

?[ table; whereConditions; groupBy; selectedColumns]

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @masmail

I believe this error is due to the way you structured your .Q.dpft function.

If you take a look at the screenshot provided you will see that this namespace only accepts 4 arguments;

• d is a directory handle
• p is a partition of a database
• f is a field of the table named by t below
• t the name (as a symbol) of a simple table whose columns are vectors or compound lists

The first two parameters are correct [f1DbPath;2020.01.02, ..] however you need to take a look at the order of your second two.

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Can you share a screenshot of your edge15 table please ?

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Can you make sure your variable names match up with those that are given in the expected schema?

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Since you have adjusted your code to use ‘ * ‘ to read in your columns as strings, you no longed need the following cast statement:

messages: update trade_id: `$string trade_id from messages

As this is changes the format of the column from image_1 to image_2.

Let me know if this helps!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

Let me break down question 4.7 for you:

• Using your timeSeries dictionary that you created in ex 4.6, compare the correlation of edge against the correlation of qty then the correlation of edge against the correlation of numTrds. To do this you can use the keyword cor – cor – corelation coefficient | Reference | kdb+ and q documentation – Kdb+ and q documentation (kx.com)
• Store this data in a dictionary called edgeCor with the keys being edge, qty and numTrds and the values being their correlation with the edge series.

There are a few different ways this can be done but using iteration is included as a suggestion.

Let me know if you require further assistance.

Thanks,

Megan

code.kx.com

cor – corelation coefficient | Reference | kdb+ and q documentation - Kdb+ and q documentation

cor is a q keyword that calculates the correlation coefficient of two numeric lists.

[megan_mcp]

Hi @kal8na

I believe the problem is within your badTrades variable you do not provide the classifyTrades function with a parameter.

To fix this, simply pass in the tradeContext table into the function:

badTrades: select from classifyTrades[tradeContext] where exQuality = 0b;

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi @kal8na

So the question is asking for more than just joining the two tables.

– It’s looking for the last date

– It’s looking you to add two extra columns bid and ask which contain information from the nbbo table

Here is an example from the documentation to help (screenshot below).

If you have any further questions please let me know!

Thanks,

Megan

[megan_mcp]

Does it pass the tests anyway?

[megan_mcp]

Hi @timbs_1995

The table provided above is stating that there are 4 possibilities for the “mysensor” parameter: temp, tyre, wind or all.

If mysensor = temp then what should be returned are all the sensorId’s that include the word temp at the start. So tempBackLeft, tempBackRight, tempFrontLeft, tempFrontRight. The same applies for the rest.

If mysensor = all then all the sensorId’s must be returned.

You must create a dictionary that represents this logic.

Let me know if you have any further questions.

Thanks,

Megan

[megan_mcp]

Hi @timbs_1995

Sorry my mistake – you must add the name of the directory.

Which in this case is f1:

\l f1

Thanks,

Megan