Data Engineer Project: Automating a Weekly Analytics Report in Python.
Created a scipt in Python that takes in an Excel file and automates a weekly analytics report for a fictional bank loan database. The user can select any time period and the script will generate a range of useful analytics and info. Only Python's built-in modules were used to show more in-depth code and how powerful the standard data structures can be.
Simply click on the Data Engineer Project.ipynb link listed above for the code. You can also click on the Test Loan Data File.csv link above for the Excel data used in the project as well.