how to get range of index of pandas dataframe

Question

What is the most efficient way to get the range of indices for which the corresponding column content satisfy a condition .. like rows starting with tag and ending with "body" tag.

for e.g the data frame looks like this

I want to get the row index 1-3

Can anyone suggest the most pythonic way to achieve this?

import pandas as pd

df=pd.DataFrame([['This is also a interesting topic',2],['<body> the valley of flowers ...',1],['found in the hilly terrain',5],
             ['we must preserve it </body>',6]],columns=['description','count'])

print(df.head())

Please don't post images of code or data. “Can someone help me?” not an actual question?. — wwii
– wwii, Commented Nov 28, 2017 at 19:34

Evan · Accepted Answer · 2017-11-28 21:06:37Z

1

What condition are you looking to satisfy?

import pandas as pd

df=pd.DataFrame([['This is also a interesting topic',2],['<body> the valley of flowers ...',1],['found in the hilly terrain',5],
             ['we must preserve it </body>',6]],columns=['description','count'])
print(df)
print(len(df[df['count'] != 2].index))

Here, df['count'] != 2 subsets the df, and len(df.index) returns the length of the index.

Updated; note that I used str.contains(), rather than explicitly looking for starting or ending strings.

df2 = df[(df.description.str.contains('<body>') | (df.description.str.contains('</body>')))]
print(df2)
print(len(df2.index))

help from: Check if string is in a pandas dataframe

edited Nov 28, 2017 at 21:06

answered Nov 28, 2017 at 19:43

Evan

2,17116 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user765160 Over a year ago

Apologies, I forgot to add the condition in the question.. well the condition that I am looking is rows starting and ending with <body>, </body> tag

Shahir Ansari · Accepted Answer · 2019-12-04 05:47:24Z

0

You can also find the index of start and end row then add the rows in between them to get all contents in between

start_index = df[df['description'].str.contains("<body>")==True].index[0]
end_index = df[df['description'].str.contains("</body>")==True].index[0]

print(df["description"][start_index:end_index+1].sum())

answered Dec 4, 2019 at 5:47

Shahir Ansari

1,86818 silver badges21 bronze badges

Collectives™ on Stack Overflow

how to get range of index of pandas dataframe

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related