Python Forum
How to filter specific rows from large data file
Thread Rating:
  • 1 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to filter specific rows from large data file
#4
That will find you the row

df[abs(df['X'] - 4.125) <= 1e-6]
Result
Output:
Ion N Mass Charge X Y Z Azm Elv KE 5 3849096 0.000549 -1 4.125 44.9887 -2.47517 -176.363 25.715 17711.1

(Jun-29-2018, 01:57 PM)Ariane Wrote: What do you mean "does not work"?

I get the following error:

TypeError: 'Series' objects are mutable, thus they cannot be hashed

In which bloody line do you get that message? Asking Python question 101 - if you have exception, show full traceback - or at least the part that contains reference to your code. In output tags, of course.
Test everything in a Python shell (iPython, Azure Notebook, etc.)
  • Someone gave you an advice you liked? Test it - maybe the advice was actually bad.
  • Someone gave you an advice you think is bad? Test it before arguing - maybe it was good.
  • You posted a claim that something you did not test works? Be prepared to eat your hat.
Reply


Messages In This Thread
RE: How to filter specific rows from large data file - by volcano63 - Jun-29-2018, 02:00 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Errors if an xlsx file has blank rows in the beginning…. tester_V 1 861 Aug-28-2023, 06:22 PM
Last Post: deanhystad
  Sorting data by specific variables using argparse Bearinabox 5 1,442 Jan-01-2023, 07:44 PM
Last Post: Bearinabox
  Counting Duplicates in large Data Set jmair 3 1,152 Dec-07-2022, 09:42 AM
Last Post: paul18fr
  Reading large crapy text file in anaconda to profile data syamatunuguntla 0 843 Nov-18-2022, 06:15 PM
Last Post: syamatunuguntla
  Training a model to identify specific SMS types and extract relevant data? lord_of_cinder 0 996 Oct-10-2022, 04:35 AM
Last Post: lord_of_cinder
  Split excel file and write output at specific row and set sheet position DSCA 0 2,023 May-12-2022, 07:29 PM
Last Post: DSCA
  Searching Module to plot large data G_rizzle 0 1,467 Dec-06-2021, 08:00 AM
Last Post: G_rizzle
  how to filter data frame dynamically with the columns psahay 0 2,421 Aug-24-2020, 01:10 PM
Last Post: psahay
  Dropping Rows From A Data Frame Based On A Variable JoeDainton123 1 2,249 Aug-03-2020, 02:05 AM
Last Post: scidam
  Chunking and Sorting a large file Robotguy 1 3,613 Jul-29-2020, 12:48 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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