How do I perform operations on a DataFrame using Pandas?

How do I perform operations on a DataFrame using Pandas?

You can perform various operations like filtering, grouping, and aggregating data in a Pandas DataFrame. What specific operation are you interested in?

I want to filter rows based on a condition.

You can use the loc method to filter rows. For example, df.loc[df['column_name'] > value] will return rows where the specified column's value is greater than a certain value.

Can you show me an example with a sample 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.loc[df['A'] > 2]
print(filtered_df)

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

Thanks! How can I group data in a DataFrame?

You can use the groupby method. For example, df.groupby('column_name').sum() will group the DataFrame by the specified column and sum the values.