View the step-by-step solution to:

Question

<pre class="ql-syntax"><span class="hljs-comment">#What you need to do is to

transform the file Mkt_data_test.txt</span> <span class="hljs-comment">#to the format like in file in the screenshot</span> <span class="hljs-comment">#</span> <span class="hljs-comment">#Your steps to get there:</span> <span class="hljs-comment">#1.Create a header line with following columns: Time;BidAsk;Price;Volume. NOTE NO SPACES</span> <span class="hljs-comment">#2.Remove all of the timestamp lines, i.e ======== Data: .....</span> <span class="hljs-comment">#3.Remove the 1900-01-01 from the timestamp but leave the time itself</span> <span class="hljs-comment">#4.Get rid of all spaces and empty lines</span> <span class="hljs-comment">#5.Replace 0 or 1 in the second position with Bid or Ask, Bid for 0, Ask for 1</span> <span class="hljs-comment">#6.Save the header line and propely formatted lines to the COMMA-SEPARATED csv file named mktDataFormat.csv</span> <span class="hljs-comment">#</span> </pre>

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes