Hello, so I want to browse and analyse all my creditcard bill expenses I kind of started but I can’t continue due my lack os skills.
I was taking the pandas class to analyse data but can’t do it alone.
So I have a csv with my expenses and these categories: date, category, title, amount.
I could see the whole amount I’ve spent using bill this code on jupyter notebook:
import pandas as pd bill = pd.read_csv('creditcard.csv') bill.amount.sum()
But how can I use the sum() function to find out the total sum of each category (transport, services, taxes…) ? I really would like to know how can I get how much money I spent on each category so later I’ll try to plot a pie chart to understand it better.
Thank you all!