Python Forum
Sorting a large CVS file
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Sorting a large CVS file
#2
(Oct-31-2019, 12:15 PM)DavidTheGrockle Wrote: I need to separate out all the rows with a given id.

What do you need to do? Do you need to separate out the rows with a given ID, or do you need to sort by the ID? You appear to already have the rows for a particular ID. To sort by that ID you would use sort_index:

pacto.sort_index(by = 'individual-local-identifier')
You may also want to look at the groupby method.
Craig "Ichabod" O'Brien - xenomind.com
I wish you happiness.
Recommended Tutorials: BBCode, functions, classes, text adventures
Reply


Messages In This Thread
Sorting a large CVS file - by DavidTheGrockle - Oct-31-2019, 12:15 PM
RE: Sorting a large CVS file - by ichabod801 - Oct-31-2019, 12:32 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Data Sorting and filtering(From an Excel File) PY_ALM 0 1,068 Jan-09-2023, 08:14 PM
Last Post: PY_ALM
  Reading large crapy text file in anaconda to profile data syamatunuguntla 0 843 Nov-18-2022, 06:15 PM
Last Post: syamatunuguntla
  Chunking and Sorting a large file Robotguy 1 3,613 Jul-29-2020, 12:48 AM
Last Post: Larz60+
  extracting sublist from a large multiple molecular file juliocollm 2 2,323 May-25-2020, 12:49 PM
Last Post: juliocollm
  How to filter specific rows from large data file Ariane 7 8,291 Jun-29-2018, 02:43 PM
Last Post: gontajones
  access a very large file? As an array or as a dataframe? Angelika 5 4,974 May-18-2017, 08:15 AM
Last Post: Angelika

Forum Jump:

User Panel Messages

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