清空筛选条件
清空筛选条件

How to delete columns from something that isn't a matrix

3 次查看（过去 30 天）
William Campbell
William Campbell 2019-1-15
编辑： madhan ravi 2019-1-15
I've got some data that I need columns deleting from, specificially 3,4,5,9,10,12,13,14 but whenever I try the following code, with data set A, I get the answer "Deletion requires an existing variable."
A(:,[3 4 5 9 10 12 13 14])=[];
Is this because my data is not technically a matrix?
Below is some of my data
2018-01-01T00:00 273.450 2.350 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
2018-01-01T01:00 273.250 1.570 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
2018-01-01T02:00 273.350 0.510 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
2018-01-01T03:00 273.250 1.420 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
2018-01-01T04:00 273.350 0.140 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
2018-01-01T05:00 275.550 0.700 -999.000 -999.000 -999.000 -999.000 -999.000 -1.000 -999.000 -999.000 0.000 -999.000 -999.000 -999.000
Thanks!
  2 个评论
Adam
Adam 2019-1-15
What does
whos
show when run on command line? The text of the error message suggests that A does not exist at all rather than anything to do with what type of variable it is.

请先登录，再进行评论。

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

采纳的回答

madhan ravi
madhan ravi 2019-1-15
编辑：madhan ravi 2019-1-15
EDITED
T=readtable('sample.txt'); % your filename
T(:,[3 4 5 9 10 12 13 14])=[]
Gives:
T =
6×7 table
Var1 Var2 Var6 Var7 Var8 Var11 Var15
__________________ ______ ____ ____ ____ _____ _____
'2018-01-01T00:00' 273.45 -999 -999 -999 -999 -999
'2018-01-01T01:00' 273.25 -999 -999 -999 -999 -999
'2018-01-01T02:00' 273.35 -999 -999 -999 -999 -999
'2018-01-01T03:00' 273.25 -999 -999 -999 -999 -999
'2018-01-01T04:00' 273.35 -999 -999 -999 -999 -999
'2018-01-01T05:00' 275.55 -999 -999 -999 -999 -999
Note: Download the attached document and try my code.
  12 个评论
显示 10更早的评论
William Campbell
William Campbell 2019-1-15
Thanks
But there are still " marks around the date?
"2018-01-01T00:00 " 273.45 2.35 -999 -999 -1 0
"2018-01-01T01:00 " 273.25 1.57 -999 -999 -1 0
"2018-01-01T02:00 " 273.35 0.51 -999 -999 -1 0
"2018-01-01T03:00 " 273.25 1.42 -999 -999 -1 0
madhan ravi
madhan ravi 2019-1-15
编辑：madhan ravi 2019-1-15
T=readtable('sample.txt'); % your rawdata filename
T(:,[3 4 5 9 10 12 13 14])=[];
T.Var1=datetime(T.Var1,'Format','yyyy-MM-dd''T''mm:ss')
writetable(T,'sample1.txt','Delimiter',' ','WriteVariableNames',0) % I don't see any strings around date

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by