How to read specific columns of a .csv file?

14 visualizaciones (últimos 30 días)
Alireza Babaei
Alireza Babaei el 11 de Feb. de 2021
Editada: Adam Danz el 12 de Feb. de 2021
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 comentario
Adam Danz
Adam Danz el 12 de Feb. de 2021
Editada: Adam Danz el 12 de Feb. de 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.

Iniciar sesión para comentar.

Respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by