Improving my Python programming skills and surfing on a daily basis was a dream coming true for me!

As a freelancer, it is important to analyse my monthly income and expenses. 

The culmination of my 2 months work is the above pie chart showing all my expenses during the trip. 

I used Python to automate the following steps (see below for more details):

  1. Download CSV files from bank statements using Selenium 
  2. Data analysis & categorisation of all expenses with Pandas
  3. Data visualisation with Plotly

 

Surfing:

My daily routine consisted of surfing for around 3 hours in the morning with my surf school.

On average, I surfed every other day, making a total of almost 30 surfs in two months!

 

Automated login & download of CSV files from bank statements of the following accounts: 

  • Private Giro
  • Credit Card 
  • Business Giro  
  • PayPal

using Selenium & Pyautogui

Import of CSV files & data preparation w/ Pandas 

  • categorisation of expenses via mapping dictionary & Numpy
  • Data analysis w/ ydata profiling

Further Tools: 

  • Data visualisation w/ Plotly
  • Git version control
  • a lot of help from ChatGPT :)

 

Copyright ©

All rights reserved.

Foto: robach.eu

Wir benötigen Ihre Zustimmung zum Laden der Übersetzungen

Wir nutzen einen Drittanbieter-Service, um den Inhalt der Website zu übersetzen, der möglicherweise Daten über Ihre Aktivitäten sammelt. Bitte überprüfen Sie die Details in der Datenschutzerklärung und akzeptieren Sie den Dienst, um die Übersetzungen zu sehen.