Clear Filters
Clear Filters

Delete rows from array

3 views (last 30 days)
ariane
ariane on 13 Aug 2018
Commented: ariane on 13 Aug 2018
I have a large csv file which looks like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE"
3849094,0.00054858,-1,66.5216,-51,-3.8,-180,88.7,18160
3849095,0.00054858,-1,27.3925,30.3532,-4.07076,-177.1,41.5494,17697.2
3849096,0.00054858,-1,66.5216,-51,-3.7,-180,88.7,18160
3849097,0.00054858,-1,26.6277,31.0039,-3.91402,-177.096,40.8293,17699.4
3849098,0.00054858,-1,66.5216,-51,-3.6,-180,88.7,18160
3849099,0.00054858,-1,4.125,44.9887,-2.47517,-176.363,25.715,17711.1
To create and array with each second row I use the following command:
data(2:2:end,:) = []
My output file then looks like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE"
3849095,0.00054858,-1,27.3925,30.3532,-4.07076,-177.1,41.5494,17697.2
3849097,0.00054858,-1,26.6277,31.0039,-3.91402,-177.096,40.8293,17699.4
3849099,0.00054858,-1,4.125,44.9887,-2.47517,-176.363,25.715,17711.1
However, I wish to keep the first row and delete the second one and keep the third row and so on but the following command doesn't seem to work.
data(1:1:end, :) = []
My desired output file should look like this:
"Ion N","Mass","Charge","X","Y","Z","Azm","Elv","KE"
3849094,0.00054858,-1,66.5216,-51,-3.8,-180,88.7,18160
3849096,0.00054858,-1,66.5216,-51,-3.7,-180,88.7,18160
3849098,0.00054858,-1,66.5216,-51,-3.6,-180,88.7,18160
Could anyone advise on how I can implement this?

Accepted Answer

Adam Danz
Adam Danz on 13 Aug 2018
I'm not following your examples but does this solve your problem?
data(1:2:end, :) = []
or
data(2:2:end, :) = []
  1 Comment
ariane
ariane on 13 Aug 2018
yup, the first answer solves it. thanks

Sign in to comment.

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!