Forage Data@ANZ Program Task 1 - Exploratory Data Analysis

Task 1 is called Exploratory Data Analysis where we are required to segment the dataset and draw unique insights, including visualisation of the transaction volume and assessing the effect of any outliers.

In summary, ANZ is one of the big 4 banks in Australia. This program and task 1 specifically involves analysing a dataset that contains historical transactions made by 100 unique customers over a 3-month period. The goal is to understand the purchasing behaviour of those customers as well as identify any patterns or trends that occur over the 3-month period.

If you find the video helpful, please drop a like, subscribe to my channel and share my content around - that would mean the world to me.

Keep learning and I'll see you in the next one!

Timestamp
0:00 - Introduction
4:35 - Import libraries and data
7:30 - Basic checks
14:56 - Exploratory data analysis
27:30 - Feature engineering
37:18 - Deep dive
45:03 - Conclusion

Forage website

Link to my work on GitHub

Follow me

[JasonChong]

Just realised I made a mistake explaining the day of week function in Pandas. The right way to interpret it is actually Monday = 0 and Sunday = 6.


Let me know what you think of the video and which project I should work on next!

[tessie]

Hi Jason, great efforts! thanks for doing this . It's really helpful :)
I think one of the point regarding credit/debit movements is misunderstood.
Debit and credit movements are used in accounting to show increases or decreases in accounts and not credit or debit card usage . Instead of saying there has been an increase or a decrease in an account, we say there has been a debit movement or a credit movement.

[NasriddinovSalohiddin-pq]

Do you mind doing a fast explanation on how to do it on Stata or Excel?

[niranjannagabhushan]

How to save it in our directory or in Google Colab

[niranjannagabhushan]

Please Explain the last line of the code