Create a matrix from a csv

2018 11 6
1 个回答
更新时间：2018 11 6
17 次查看（30 天）

0 个投票

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 个评论
显示 2更早的评论 隐藏 2更早的评论

Guillaume
Guillaume 2018-11-6
编辑：Guillaume 2018-11-6
Do you know L beforehand, or is it to be determined from the file?
And can you supply a test file as it would avoid us having to make one up?
Lorant
Lorant 2018-11-6
编辑：Lorant 2018-11-6
L should be determined from the file. I als added the testfile to the original question.
Jan
Jan 2018-11-6
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 2018-11-6
Yeah, that's true, I don't need the date, just the last three numbers.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

madhan ravi
madhan ravi 2018-11-6
编辑：madhan ravi 2018-11-6

0 个投票

Try
readtable()
T=readtable('Testfile_1.csv');
T(:,end-2:end) %reads last three columns

类别

在 帮助中心 和 File Exchange 中查找有关 Holidays / Seasons 的更多信息

标签

提问:

Lorant
Lorant
2018-11-6

编辑：

madhan ravi
madhan ravi
2018-11-6

Community Treasure Hunt

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

Start Hunting!

Translated by