MATLAB Answers

importing csv files with readtable

2 views (last 30 days)
Mihai Milea
Mihai Milea on 11 Nov 2020
Edited: Mihai Milea on 18 Nov 2020
Hi.I have several csv files created by some pother software (Python) ..I used readtable to proces them .The first row contains some stock names while the other are some dates and prices .readtable works great just the first row is seen as "header" somehow (row starts at columns 2) so I cannot save it somehow in the structure.When opened in Excel I do not see anything specific about the first row (# or anything like it) .Before I used textread but this one seems nicer -:)).Maybe I do something wrong .

  3 Comments

Cris LaPierre
Cris LaPierre on 11 Nov 2020
Not sure there is enough information for us to help yet. Should it be possible? Yes.
Can you help us by providing more details? Better yet, can you attach your Excel file? Use the paperclip icon.
Mihai Milea
Mihai Milea on 11 Nov 2020
You are right of course .I am attaching a piece of the file
Cris LaPierre
Cris LaPierre on 11 Nov 2020
Still not clear what the error is you are seeing. What is the code you are using to save the data to a structure? What is the error message you are getting? Please share the entire error message (all the red text). It would also be helpful if you shared the relevant code.

Sign in to comment.

Accepted Answer

Mihai Milea
Mihai Milea on 18 Nov 2020
Edited: Mihai Milea on 18 Nov 2020
Ok thank you .So for a generic vector V it would be [A,ind] = stock(:,V') and A.Var1 is the dates vector .The others I have to look at the page you suggested .ind will just keep track of the place

  0 Comments

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by