How to read an excel /csv files with columns that have both text and numbers?
5 次查看(过去 30 天)
显示 更早的评论
Everytime I try to use readcell , readtable.. I get one or alll of the following problems:
- Numeric columns get merged into one cell array ex : {1.5,2.5} vs them being in two unique cells
- Additional columns that dont exist in my csv/xlsx files with 1x1 missing filled in
- Nan for string entries
I saw online that a column with text and numeric values dont mix well. Anyone have any suggestions?
I am also trying to find a specific string value index (xdist_mm,Power_watts) for each file to then import the data under each of these headers into a seperate array for analysis. I tried strfind and contains without much sucess)
Thank you
0 个评论
采纳的回答
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!