megan_mcp
Forum Replies Created
-
Hi @jervischionh,
For exercise 1.3 can you make sure that if you are selecting a column from a table that you use backticks (Tables in kdb+ | Language | kdb+ and q documentation – kdb+ and q documentation (kx.com). E.g. When selecting time and endTime from the window table, instead of this:
window: (t[time];t[endTime]);
We would write it as this:
window: t `time`endTime;
This goes for the rest of the columns in your code.
For exercise 2.3 can you create a dictionary mapping the mysensor options as seen in the table below.
If you have any questions, please feel free to reach out.
Many thanks,
Megan
-
Hi @jervischionh,
For exercise 1.3 can you make sure that if you are selecting a column from a table that you use backticks (Tables in kdb+ | Language | kdb+ and q documentation – kdb+ and q documentation (kx.com). E.g. When selecting time and endTime from the window table, instead of this:
window: (t[time];t[endTime]);
We would write it as this:
window: t `time`endTime;
This goes for the rest of the columns in your code.
For exercise 2.3 can you create a dictionary mapping the mysensor options as seen in the table below.
If you have any questions, please feel free to reach out.
Many thanks,
Megan
-
Hi @Saidharsan
Can you send me your exact code for exercise 2.2 please?
For exercise 2.4 can you make sure to create a dictionary mapping the mysensor inputs, as seen in the table below.
Thanks,
Megan
-
Hi Joe,
Is it okay if I access your server to see where the problem lies?
Thanks,
Megan
-
-
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 🙂
-
Can you send me a screenshot of your updated .f1.checkSensor function? This will allow me to assist you better🙂
-
Can you make sure this dictionary exists within your .f1.checkSensor function.
-
Hi @Joe
I believe the error was that badTrades.csv was saved to the wrong directory. I removed it from your database and the code seems to be running fine now.
Let me know if you have any further issues.
Thanks,
Megan
-
-
Hi @bell
I’ve made a few adjustments. Can you try launching the capstone sandbox one more time? https://learninghub.kx.com/courses/kdb-developer-level-3/lessons/kdb-developer-level-3-capstone-project/
Remembering to run ./setup.sh in the terminal.
-
I suggest you launch a fresh instance of the course.
If you have made any progress make sure to download your project.md file before completing the following steps:
Return to the terminal and run:
cd ..
Then run:
rm -rf course-advanced-capstone
Return here kdb Developer Level 3 Capstone Project – KX Learning Hub and click ‘Launch Capstone Sandbox’. Continue by following the README instructions again.
Let me know if this works!
Thanks,
Megan
-
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
-
Hi Jonathan,
Glad to see you got sorted!
If you have any further questions, please feel free to ask 🙂
Best regards,
Megan
-
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!"
