read spreadsheet, delete some variables, and save the spreadsheet

I have a spreadsheet 'test.csv' with the columns

date temperature number_of_deadlines

I read this spreadsheet with readtable, then I want to delete the column of 'number_of_deadlines" and then save the spreadsheet 'test2.csv' with

date temperature

Please advise.

Answer 1

[Ameer Hamza]

Something like this

t = readtable('test.csv');
t.number_of_deadlines = [];
writetable(t, 'test2.csv')

[alpedhuez]

Thank you.

Answer 2

[madhan ravi]

T = readtable('test.csv');
writetable(T(:,1:2), 'test2.csv')

[alpedhuez]

Thank you.