Table "Vertical Lookup", how to do it?
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Leonardo Urbano
il 6 Apr 2015
Risposto: Leonardo Urbano
il 7 Apr 2015
Hi everybody,
I'm asking you help to discriminate a table according a precise criteria, I'm better explaining:
- I have 2 different tables got from Google Finance, one different in length to the other (i.e. a is the longer and b is the shorter). I want to make the discrimination according to the "Date" field;
- I want to looking for each value of b in a and create a matrix C with all rows of common values (e.g. if the value of the discriminant column (the Date column) is in common, then take all the row of a and copy in C, for each common value);
I have already tried to set a for statement up with a if statement within it, but my matter is that the two discriminant columns are not in the same order (one has only business days while other has all days, so 365 vs. ~250) and I can't tell Matlab to do some similar to the Vertical Lookup in Excel.
I hope to has been clear enough!
Thanks in advance to everyone
Leo
1 Commento
Risposta accettata
Più risposte (2)
Peter Perkins
il 7 Apr 2015
Modificato: Peter Perkins
il 7 Apr 2015
It's not terrible clear what you're asking for. A simple example would have helped.
It sounds like you want to do a join operation. Consider putting your data into two MATLAB tables, and using the JOIN method.
0 Commenti
Vedere anche
Categorie
Scopri di più su Financial Toolbox in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!