How do I delete rows in a sframe?

User 2570 | 7/1/2016, 6:38:02 PM

I have a dataset with 1503384 rows, how do I delete a certain row completely from the dataset, let say row no 97, for example graphlab has graphlab.SFrame.remove_columns for removing a column, what about removing certain rows completely from the dataset and saving in a new SFrame

Comments

User 2570 | 7/1/2016, 6:44:43 PM

How also to Read Specific Row in a dataset using graphlab create, let say row 5, or how to read like 5 or 10 rows at a time in a dataset where you have many rows in a dataset


User 16 | 7/1/2016, 7:14:12 PM

If you have a SFrame called sf, you can read row 5 by doing: sf[5]

Removing a particular row is a little more difficult. There are a few different ways you could do it. I would do it by adding row numbers, filtering out all but that one row, then removing row numbers. sf = sf.add_row_number() sf = sf[sf['id'] != 97] del sf['id']


User 2570 | 7/2/2016, 6:38:53 AM

Thank you @Toby