Info

이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

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

조회 수: 3 (최근 30일)
Pratik Samant
Pratik Samant 2020년 2월 28일
마감: MATLAB Answer Bot 2021년 8월 20일
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
Adam
Adam 2020년 2월 28일
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 2020년 2월 28일
Readtable did the trick! Thank you, I had not heard of this function before.

답변 (0개)

이 질문은 마감되었습니다.

태그

Community Treasure Hunt

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

Start Hunting!

Translated by