Row 6122

Row ID: 6122 | Dataset Entry | Axioma AXP Content Repository

Content Data

This page contains data entry 6122 from the Axioma AXP content repository. The structured data below represents the complete record for this entry.

So have received a take home exercise for a job interview that I am currently in the final stages of, and would really like to nail. The task is fairly simple and having eyeballed it I already know what I intend to do. However the task has provided me with a number of csv files to use in my analysis and subsequent presentation. However they have mentioned that I would be judged on my sql code. Granted I could probably do this faster in excel i.e. vlookups to simulate the joins I need to make to create the 'end table' etc however it seems like I will need to use the sql and will be getting partially judged on the cleanliness and integrity of my code. This too is not a problem and in my mind I already know what I would like to do. However all my experience is working in IDE's that my work has paid for. To complete this exercise I would need to load these csv files into a open source SQL IDE of some sort (or at least so I think). However I have no idea whats out there and what I should use. also I would ideally like to present this notebook style and sop suggestions where I could run commentary and code side by side a la colab that may be fit for purpose would be greatly appreciated. Do not have much time on the task but am ironically stumped where to start (even though I know exactly how to answer the question at hand)

any suggestions would be much appreciated

FieldValue
text So have received a take home exercise for a job interview that I am currently in the final stages of, and would really like to nail. The task is fairly simple and having eyeballed it I already know what I intend to do. However the task has provided me with a number of csv files to use in my analysis and subsequent presentation. However they have mentioned that I would be judged on my sql code. Granted I could probably do this faster in excel i.e. vlookups to simulate the joins I need to make to …
label r/datascience
dataType post
communityName r/datascience
datetime 2024-05-07
username_encoded Z0FBQUFBQm5LakwyS3J6WDNKbnhWbUxRdUdoT3hxa1ZCcGJIY1hZS0xOWFdzbzFIWUFyRHUzZXJRTC1wT1h5VFIxbHZ0bzlxdjlTNmtOYmdtc0M1SGJUc2xTT2F1Vi1fdkE9PQ==
url_encoded Z0FBQUFBQm5Lak9HbnVvWTJNVnU4MDlVNHQ0TlJCMXlFb29DYkR4RU8yY292d3dDMzJxU1ZRbVNXeXNDa0hNTHE0Y1ZQZFcyd0kzRzJxSHRIRi1pT0doMEhiQU5KUW9iNS16OTFDSW9FXzhabkw3Rjh2UkhYWW9NeF9UOXJPVzhyN25TNi1pOGFQaW5ITkRVVjZNbTdlcTh5S09neWg3X05uWHF5UHRsX1Z4MTdZX3lPVFFfd1ZoMERSdC12bVV0ZmFlMlctdXpReDZn

Raw Record

{
  "text": "\nSo have received a take home exercise for a job interview that I am currently in the final stages of, and would really like to nail. The task is fairly simple and having eyeballed it I already know what I intend to do. However the task has provided me with a number of csv files to use in my analysis and subsequent presentation. However they have mentioned that I would be judged on my sql code. Granted I could probably do this faster in excel i.e. vlookups to simulate the joins I need to make to create the 'end table' etc however it seems like I will need to use the sql and will be getting partially judged on the cleanliness and integrity of my code. This too is not a problem and in my mind I already know what I would like to do. However all my experience is working in IDE's that my work has paid for. To complete this exercise I would need to load these csv files into a open source SQL IDE of some sort (or at least so I think). However I have no idea whats out there and what I should use. also I would ideally like to present this notebook style and sop suggestions where I could run commentary and code side by side a la colab that may be fit for purpose would be greatly appreciated. Do not have much time on the task but am ironically stumped where to start (even though I know exactly how to answer the question at hand)\n\nany suggestions would be much appreciated\n\n",
  "label": "r/datascience",
  "dataType": "post",
  "communityName": "r/datascience",
  "datetime": "2024-05-07",
  "username_encoded": "Z0FBQUFBQm5LakwyS3J6WDNKbnhWbUxRdUdoT3hxa1ZCcGJIY1hZS0xOWFdzbzFIWUFyRHUzZXJRTC1wT1h5VFIxbHZ0bzlxdjlTNmtOYmdtc0M1SGJUc2xTT2F1Vi1fdkE9PQ==",
  "url_encoded": "Z0FBQUFBQm5Lak9HbnVvWTJNVnU4MDlVNHQ0TlJCMXlFb29DYkR4RU8yY292d3dDMzJxU1ZRbVNXeXNDa0hNTHE0Y1ZQZFcyd0kzRzJxSHRIRi1pT0doMEhiQU5KUW9iNS16OTFDSW9FXzhabkw3Rjh2UkhYWW9NeF9UOXJPVzhyN25TNi1pOGFQaW5ITkRVVjZNbTdlcTh5S09neWg3X05uWHF5UHRsX1Z4MTdZX3lPVFFfd1ZoMERSdC12bVV0ZmFlMlctdXpReDZn"
}
Explore Dataset Explore Row

Entry Information