Clear Filters
Clear Filters

Info

This question is closed. Reopen it to edit or answer.

Is it possible to import both the text and the numerical data in a csv file?

1 view (last 30 days)
I have a csv file that looks like this
where I have some data that is a string and some data that is numerical. I would like to import this data into MATLAB. In python I can easily do this with a pandas dataframe, but is there a way to load this data into matlab such that both the strings and numbers are read? I would prefer not to have to access the numerical colums separately from the string columns but if this is the only way that is fine. I have tried readMatrix but this labels all the strings as NaN and does away with them.
Thanks in advance
  2 Comments
Adam
Adam on 28 Feb 2020
Does
doc readtable
not do this? I don't work with Excel spreadsheets in Matlab so I don't know, but this seems to be the obvious choice amongst the recommended alternatives to
doc xlsread

Answers (0)

This question is closed.

Tags

Community Treasure Hunt

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

Start Hunting!