MATLAB: HOW TO DELETE A LINE FROM A CREATING FILE

commanddelete rowfilewritetable

Hello, I have a question. I am creating a .csv file in MATLAB using the commands:

T = cell2table

writetable(T,'file.csv')

. I would like to delete from this file the 2nd row only, and keeping all the other rows. How could I make it?

Thanks

Best Answer

writetable(T(2:end, :),'file.csv')

This assumes that you want to write out the variable names but skip the first row of the matrix

Related Solutions

MATLAB: Concatenate two columns of a csv file using horzcat with same variable name

In MATLAB, two columns of a table cannot have the same variable name. Also, it might not make sense to have identical column names in a CSV file. However, you can do this using cell arrays instead of tables. Something like this

files = dir('*.csv');
A = readtable(files(1).name);
A = [A.Properties.VariableNames; table2cell(A)];
numfiles = length(files);
for k=2:numfiles
filename = files(k).name;
T = readtable(filename,"ReadVariableNames",true,"PreserveVariableNames",true); 
A = horzcat(A, [T.Properties.VariableNames(3); num2cell(T{:,3})]);
end
writecell(A, 'mergedCols.csv');

MATLAB: Deleted questions

The current question ID is 32421 and the number of existing questions is 28586. It seems like 3835 questions have been deleted. The rate of 12% is higher than I expect.

Best Answer

Related Solutions

MATLAB: Concatenate two columns of a csv file using horzcat with same variable name

MATLAB: Deleted questions

Related Question