Python Forum
How get row index of matching row in column 0
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How get row index of matching row in column 0
#4
One way is to take advantage of iterator protocol. This is based on list, but file objects are also iterable and therefore might give some ideas.

s = ['inter value,70',
     'time interval[min],20',               
     'dose_trigger value,-23',              
     'warning_linit1,36',               
     'warning limit2,15',               
     'cooling time [hrs],2',                
     'cooling number[#],30',                
     'Trail_number,initila,final,middle,max,min',
     'Trial_20157832,1,23,14,28,1',
     'Standard,0,5,2.6,5,0',
     'Trial_20037924, 2,13,17,20,0',
     'Trial_20637924,6,18,19,17,3']

first = list()
second = list()

rows = iter(s)                          # create iterator

for row in rows:
    if row.startswith('Trail_number'):  # consume iterator until sentinel and break
        second.append(row)
        break
    else:
        first.append(row)

for row in rows:                         # consume remaining iterator
    second.append(row)

# first
['inter value,70',
 'time interval[min],20',
 'dose_trigger value,-23',
 'warning_linit1,36',
 'warning limit2,15',
 'cooling time [hrs],2',
 'cooling number[#],30']

# second
['Trail_number,initila,final,middle,max,min',
 'Trial_20157832,1,23,14,28,1',
 'Standard,0,5,2.6,5,0',
 'Trial_20037924, 2,13,17,20,0',
 'Trial_20637924,6,18,19,17,3']
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Da Bishop: There's a dead bishop on the landing. I don't know who keeps bringing them in here. ....but society is to blame.
Reply


Messages In This Thread
RE: How get row index of matching row in column 0 - by perfringo - Apr-09-2019, 03:20 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Removing the index column from df bnadir55 7 3,226 Apr-05-2022, 02:49 PM
Last Post: snippsat
  pandas pivot table: How to find count for each group in Index and Column JaneTan 0 3,386 Oct-23-2021, 04:35 AM
Last Post: JaneTan
  Index error - columns vs non-column Vinny 3 4,986 Aug-09-2021, 04:46 PM
Last Post: snippsat
Question Matching variable to a list index Gilush 17 6,032 Nov-30-2020, 01:06 AM
Last Post: Larz60+
  How to define index column name using df.to_csv SriRajesh 0 1,793 Feb-13-2020, 03:45 PM
Last Post: SriRajesh
  How to get row row index of matching row SriRajesh 0 1,285 Feb-13-2020, 02:35 PM
Last Post: SriRajesh
  How to ger matching rows data based on index columns SriRajesh 1 2,267 Mar-08-2019, 11:05 AM
Last Post: scidam

Forum Jump:

User Panel Messages

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