How can I filter rows in a Pandas DataFrame?

How can I filter rows in a Pandas DataFrame?

You can filter rows in a Pandas DataFrame using boolean indexing. For example, df[df['column_name'] > value] will return rows where the specified column's values are greater than a certain value.

Can you show me an example with a DataFrame?

Sure! Here's a simple example:

import pandas as pd

data = {'A': [1, 2, 3, 4], 'B': [5, 6, 7, 8]}
df = pd.DataFrame(data)
filtered_df = df[df['A'] > 2]
print(filtered_df)

This will output rows where column 'A' is greater than 2.

What if I want to filter based on multiple conditions?

You can use the & operator for 'and' conditions and | for 'or' conditions. For example:

filtered_df = df[(df['A'] > 2) & (df['B'] < 8)]

This filters rows where 'A' is greater than 2 and 'B' is less than 8.

Is there a way to filter rows based on string values?

Yes! You can filter based on string values using the .str accessor. For example:

filtered_df = df[df['column_name'].str.contains('substring')]

This will return rows where 'column_name' contains the specified substring.