how to read data from excel file
9 ビュー (過去 30 日間)
古いコメントを表示
Dear All,
I want to understand how to read the excel data from the following code. I am a beginer in matlab. I need your help in this regard.
% data for each model.
% data = csvread('data_JNP2014.csv',1) What does 1 means is it the first sheet
% x1 = data(:, [1 3 5]);what does this line means?
x2 = data(:, [2 3 5]);
x3 = data(:, [1 2 3 5]);
x4 = data(:, [1 3 4 5 6]);
x5 = data(:, [2 3 4 5 6]);
x6 = data(:, [1 2 3 4 5 6]);
0 件のコメント
採用された回答
David Hill
2021 年 10 月 7 日
I would use readmatrix
data=readmatrix('data_JNP2014.csv');%this reads the data from csv into 316x6 matrix
x1=data(:,[2 3 5]);%this forms a matrix (316x3) with columns 2,3,5.
その他の回答 (1 件)
Mathieu NOE
2021 年 10 月 7 日
hello
your csv file has one first row wit this header (name of 6 variables : lib,pc,ir_can,ir_us,un_can,un_us)
data = csvread('data_JNP2014.csv',1)
means we skip the first line (refer to the help / doc ) because we only want the numerical data that starts at row 2
M = csvread('FILENAME',R,C) reads data from the comma separated value formatted file starting at row R and column C. R and C are zero based so that R=0 and C=0 specifies the first value in the file.
now you have data which is an array of 316 lines (time axis is vertical) by 6 columns (cf the 6 variables names in the header line)
therefore data has size 316 x 6
if you create a new variable x1 with this command :
x1 = data(:, [1 3 5])
this means we keep all rows of data array but want to have only columns 1 , 3 and 5 extracted from data array
and of course size of x1 is 316 x 3
0 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!