Can you give me some examples of using DataFrames in Pandas?

Can you give me some examples of using DataFrames in Pandas?

Sure! A DataFrame in Pandas is a 2-dimensional labeled data structure. Here's a simple example:

import pandas as pd

data = {'Name': ['Alice', 'Bob', 'Charlie'], 'Age': [25, 30, 35]}

df = pd.DataFrame(data)
print(df)

This will create a DataFrame with names and ages.

What if I want to filter the DataFrame for people older than 28?

You can filter the DataFrame using boolean indexing. Here's how:

filtered_df = df[df['Age'] > 28]
print(filtered_df)

This will return a DataFrame with only Bob and Charlie.

How can I add a new column to the DataFrame?

You can add a new column by simply assigning a list or a value to a new column name. For example:

df['City'] = ['New York', 'Los Angeles', 'Chicago']
print(df)

This adds a 'City' column to your DataFrame.

Can I group the data by a specific column?

Yes, you can group data using the groupby method. For example:

grouped = df.groupby('City').mean()
print(grouped)

This will group the data by 'City' and calculate the mean for numeric columns.