How do you read a column from a csv file that has commas?

1 visualización (últimos 30 días)
tng
tng el 31 de Mzo. de 2021
Editada: tng el 31 de Mzo. de 2021
I want to read column 19 of the table (surface elevation) into MATLAB but I get a table with characters rather than numbers when I write this:
tidedata1 = readtable('Newhaven_19820101_19871231.csv');
When I check tidetdata1(:,19), it has character showing as '-99.000',
How do you get rid of the 3 commas and convert the column to numbers so that I can use it for calculations? I'd highly appreciate an example using my file (for this column if possible).

Respuesta aceptada

tng
tng el 31 de Mzo. de 2021
Editada: tng el 31 de Mzo. de 2021
B = readtable('Newhaven_19820101_19871231.csv', 'Delimiter', ',');
B = B(:,11);
B = table2array(B);
Actually this seems to work.

Más respuestas (0)

Categorías

Más información sobre Logical en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by