How do I pivot a DataFrame in Pandas?

How do I pivot a DataFrame in Pandas?

You can use the pivot() function in Pandas to reshape your DataFrame. What specific data are you working with?

I have sales data with columns for date, product, and revenue.

You can pivot this data by setting 'date' as the index, 'product' as the columns, and 'revenue' as the values. Would you like a code example?

Yes, please provide a code example.

Sure! Here's a simple example:

import pandas as pd

# Sample DataFrame
data = {'date': ['2023-01-01', '2023-01-01', '2023-01-02'],
        'product': ['A', 'B', 'A'],
        'revenue': [100, 150, 200]}

df = pd.DataFrame(data)

# Pivoting the DataFrame
pivot_df = df.pivot(index='date', columns='product', values='revenue')
print(pivot_df)