Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Semrush - keyword research tool

Create your online store today with Shopify

Turn ChatGPT, Claude, Gemini, And CoPilot Into Your Personal Assistant, Business Coach, Content Creator, And More

AFFILIATE MARKETING Your all-in-one performance engine Manage affiliates, creators, and customer referrals in one unified platform—turning every partnership into measurable growth

Secure & Reliable Web Hosting, Free Domain, Free SSL, 1-Click WordPress Install, Expert 24/7 Support

Disclosure: My content contains affiliate links.

43,227 questions

56,129 answers

573 users

How to select pandas DataFrame rows with multiple condition on single column in Python

1 Answer

0 votes
import pandas as pd

df = pd.DataFrame(
	[['Tom', 91, 80, 94],
	 ['Emmy', 98, 85, 96],
	 ['Rubeus', 87, 81, 87],
	 ['Rubeus', 87, 81, 87],
	 ['Axel', 75, 84, 90]],
	columns=['name', 'algebra', 'python', 'java'])

q = df.loc[(df['python'] >= 81) & (df['python'] <= 84)]

print(q)

 
 
 
'''
run:
 
        name  algebra  python  java
2  Rubeus       87      81    87
3  Rubeus       87      81    87
4    Axel       75      84    90

'''

 



answered Jan 6, 2021 by avibootz
...