StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POLinkind date with many folders
text
Body
copied!<p>I have a CSV folder containing the <a href="http://pastebin.com/raw.php?i=Cac4ckrb" rel="nofollow noreferrer">date</a> (from 7/8/2005 to 9/27/2013). So the csv contains only one column with the date</p> <p>I have 50 other folders containing the same structure. The columns are : </p> <ol> <li><strong>Date</strong> [structure of the date is the same as my date.csv ]</li> <li>Open</li> <li>High</li> <li>Low</li> <li><strong>Close</strong></li> <li>Volume</li> <li>Adj. Close</li> <li><strong>Symbol</strong></li> </ol> <p><em>I've bolded the columns I'm interested in to get my final output</em></p> <p>I give 2 files of those folders : </p> <ol> <li><a href="http://pastebin.com/raw.php?i=uqJkCDe5" rel="nofollow noreferrer">AI.PA.csv</a></li> <li><a href="http://pastebin.com/raw.php?i=XBGhjiHm" rel="nofollow noreferrer">ALV.DE.csv</a></li> </ol> <p>My aim (question) is to get a final new file with x column : </p> <ul> <li>Date (same structure date as date.csv)</li> <li>Symbol AI.PA</li> <li>Symbol AI.DE</li> <li>Symbol of all the other files I have</li> </ul> <p>So the column should contain the symbol as column header and the closing price if there is a closing price for the ad hoc date. And if tehre is no closing price it should contain nothing.</p> <p>I really don't know how to solve the issue. I'm open to solve my issue with any "open source" solution (ideally SQL, Python, R)</p> <p><img src="https://i.stack.imgur.com/X6IPh.png" alt="enter image description here"></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload