Defining the monthly and daily sum of expenses

We have finally managed to import our data into R and we are ready to gain some knowledge of our financial habits. First of all, we are going to compute the daily and monthly sum of our expenses and incomes as a starting point to investigate the presence of patterns within our financial behavior.

We are going to group our dataset with the month and the day of the week as the keys of each transaction. You may have noticed that we do not actually have such information within our dataset, since only date, expenditure, and income are available. The first task we will have to accomplish will therefore be extrapolating the day and month attributes from the date column.

This can be easily done through ...

Get R Data Mining now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.