How to read specific columns of a .csv file?
2 views (last 30 days)
Show older comments
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 Comment
Adam Danz
on 12 Feb 2021
Edited: Adam Danz
on 12 Feb 2021
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.
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!