How to read specific columns of a .csv file?
7 ビュー (過去 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!