Borrar filtros
Borrar filtros

Delete rows from array

3 visualizaciones (últimos 30 días)
ariane
ariane el 13 de Ag. de 2018
Comentada: ariane el 13 de Ag. de 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?

Respuesta aceptada

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

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Matrices and Arrays en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by