Effacer les filtres
Effacer les filtres

Info

Cette question est clôturée. Rouvrir pour modifier ou répondre.

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

1 vue (au cours des 30 derniers jours)
Pratik Samant
Pratik Samant le 28 Fév 2020
Clôturé : MATLAB Answer Bot le 20 Août 2021
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 commentaires
Adam
Adam le 28 Fév 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
Pratik Samant
Pratik Samant le 28 Fév 2020
Readtable did the trick! Thank you, I had not heard of this function before.

Réponses (0)

Cette question est clôturée.

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by