import pandas as pd

# Creating a DataFrame with 'Category' as a normal column
df = pd.DataFrame({
    'Category': ['A', 'A', 'B', 'B', 'C'],
    'Value': [10, 20, 30, 40, 50]
})

print("Original DataFrame:")
print(df)

# Grouping by 'Category' column
grouped_by_column = df.groupby(level=0).sum()

print("\nAfter Grouping by 'Category' Column:")
print(grouped_by_column)

Leave a Reply

Your email address will not be published. Required fields are marked *