How to read specific columns of a .csv file?
5 次查看(过去 30 天)
显示 更早的评论
Dear all,
How can I read entire/specific columns of an excel file with .csvextension? Specifically if a specific column is numbers but MATLAB counts it not number.
My code is attached. I need to capture all columns and then just get the first and the third column. I also attahced the file I need to read (spc. the 1st and 3rd columns).
Another problem is I don't know how to make MATLAB to consider/read the 3rd column as numeric values. When you execute the following code, the 3rd culumn is apparently not numerical values.
DCmV1table = readtable('DCmV3.csv')
1 个评论
Adam Danz
2021-2-12
编辑:Adam Danz
2021-2-12
Read in the full file (use readtable or readcell). If the variables aren't read in correctly then there's a problem with your inputs (or your file is a lot different from the one you shared). Go through the documentation for either function, they are very flexible. If you get stuck, show us what inputs you're using and what the imported table looks like. The rest of your task is easy indexing.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!