reading csv file into matrices

8 ビュー (過去 30 日間)
Pawan G
Pawan G 2019 年 4 月 11 日
コメント済み: Walter Roberson 2019 年 4 月 15 日
I want to read a .csv file into matricies (n*8). The csv file is semicolon seperated and decimal is comma (German format). In the beginning,the csvfile has statements but i am only interested from a11 to end. Could anyone help me to read this file. thanks in advance.

採用された回答

Walter Roberson
Walter Roberson 2019 年 4 月 12 日
filename = '270219etc.CSV';
S = fileread(filename);
NLpos = find(S == sprintf('\n'));;
S(1:NLpos(10)) = []; %delete first 10 lines
S(S==',') = '.';
fmt = repmat('%f', 1, 8);
data = cell2mat( textscan(S, fmt, 'Delimiter', ';'));
  2 件のコメント
Pawan G
Pawan G 2019 年 4 月 15 日
Hello Walter, could please explain me what does the line 3 in the code NLpos does? Thank you
Walter Roberson
Walter Roberson 2019 年 4 月 15 日
NLpos is the position of all of the newlines in the input file. Indexing at 10 gives you the position of the end of the 10th line of input. You then remove everything from the beginning to there which removes the first 10 lines from the string.

サインインしてコメントする。

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeSpreadsheets についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by