Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Removing rows from array
#1
Hello, I want to replicate this Matlab code into Python

FILE(1:985,:) = [ ];

FILE is an nx2 array. n si quite large but it's not important. If I understand correctly, the code should remove from the FILE array all rows from first to 985th.

This is what I've come up with in Python

FILE = np.delete(FILE, FILE[0:985,...].astype('int'), axis = 0)
However it doesn't seem to work as I want, it removes only 19 rows from the array.

Why is that?

Here you can find the FILE array: https://pastebin.com/ it's a 40.001 x 2

The resulting FILE at the end should be 39.016 x 2 but I get 39.982 x 2
Reply
#2
If you want to drop first 985 rows, just do:
FILE = FILE[985:, ...]
If you want to drop first 985 rows and convert the array to integer type do:
FILE = FILE[985:, ...].astype(int)  # maybe astype(np.int64), astype(np.int16) choose appropriate one.
If you still want to use delete, you can do the same as follows:
FILE = np.delete(FILE, range(985), axis=0)
Note, that the second argument is an array of row numbers to delete.
Finally, it is not pep8-compliant to use capitalized letters for variable names.
Reply
#3
Thank you.

Can you please explain why my second argument

FILE[0:985,...]
is not the same as yours
range(985)
?
Reply
#4
(Sep-18-2020, 01:50 PM)claw91 Wrote: Can you please explain why my second argument

Python Code: (Double-click to select all)
1
FILE[0:985,...]
is not the same as yours
Python Code: (Double-click to select all)
1
range(985)
?

You passed FILE[0:985,...].astype('int'), that are values of the first column converted to ints, but you need to pass row numbers which you want to be deleted, range(985) stands (approx.) for [0, 1, ..., 984] - these are row numbers.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,625 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  Calculate next rows based on previous values of array divon 0 1,760 Nov-23-2021, 04:44 AM
Last Post: divon
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,107 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,098 Mar-02-2021, 01:54 AM
Last Post: Jeremy7
Question Dataframe Manipulation Coping Rows and Removing Dates ashleysnl 1 1,773 Feb-26-2021, 10:00 PM
Last Post: nilamo
  Removing some elements from array based on a condition claw91 0 1,506 Oct-27-2020, 03:42 PM
Last Post: claw91

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020