Create a matrix from a csv

6 Ansichten (letzte 30 Tage)
Lorant
Lorant am 6 Nov. 2018
Bearbeitet: madhan ravi am 6 Nov. 2018
Hello, I have a csv file with a structure like this (or just take a look at the csv):
  1. name11,name21,name31
  2. number,number,number
  3. number,number,number
  4. ...
  5. name21,name22,name23
  6. number,number,number
  7. number,number,number
  8. ...
  9. name31,name32,name33
  10. number,number,number
  11. ...L ist the length of the space between two names, N is the number of matrixes.I want to save every number between two names as a separate matrix, the best would be a Lx3xN.How can I do that?
  4 Kommentare
Jan
Jan am 6 Nov. 2018
There are some blank lines in addition.
How do you want to treat the date?
5 Nov 2018 11:00:00.000,6110.403876,-1714.451633,2349.558833
This does not match the pattern "number,number,number" exactly.
Lorant
Lorant am 6 Nov. 2018
Yeah, that's true, I don't need the date, just the last three numbers.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

madhan ravi
madhan ravi am 6 Nov. 2018
Bearbeitet: madhan ravi am 6 Nov. 2018
Try
readtable()
T=readtable('Testfile_1.csv');
T(:,end-2:end) %reads last three columns

Kategorien

Mehr zu Holidays / Seasons finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by