Thank you to Mailgun for sponsoring this video! Try Mailgun today by using my link [ Ссылка ]

Today, we will learn how you can automate your personal finances using PYTHON and Google Sheets.

Premium Resources to Become a Software Engineer from Scratch:
🚀 Zero to Software Engineer with no Degree - [ Ссылка ]
🚀 FREE Course to Start Your Career in Software Development - [ Ссылка ]

Make Python your (unpaid) financial manager!

📈 GOOGLE SHEETS TEMPLATE (copy this or create your own) - [ Ссылка ]

1. Acces your transactions as CSV files - further detail on reading CSV data in Python [ Ссылка ]
2. Access Google Sheets using the spread library - detailed instructions for how to set up the API if I go too fast in the video - [ Ссылка ]
3. Clean up data in Python using DATA SCIENCE
4. Extract data to Google Sheets via gspread
5. Customize the financial spreadsheet to your liking and make your app categorize transactions automatically!

CHAPTERS:
0:00 What you will learn
1:00 Set up Transaction data Access
3:00 Set up Google Sheets API Access
5:15 SPONSOR: Mailgun
6:25 Clean up data in Python using Data Science Magic
8:10 Make your app INTELLIGENT
9:28 Extract data to Google Sheets (using magic)
13:30 Make your app even better (ideas)

OTHER VIDEOS
💻 How I Learned to Code in 4 MONTHS - & Got a Software Engineer Job (no CS Degree) - [ Ссылка ]
⌨️ How I'm Teaching Myself Computer Science using Notion (OSSU) - [ Ссылка ]
🖱 CS50 FULL REVIEW - Best Course to Learn Computer Science in 2022? (edX, Harvard) - [ Ссылка ]

WHO AM I?
On this channel, my aim is to give you the tools, strategies and methods to learn to code effectively - according to science! In addition, I document my life as a self-taught software engineer.

DISCLAIMER: some of the links in the description may be affiliate links. If you purchase a product or service using the links that I provide I may receive a small commission. This is no extra charge to you! Thanks for supporting Internet Made Coder :)

Tags: python automation projects, automate the boring stuff with python, learn python, python data analytics, google sheets API, python finance, python csv tutorial, python automation, automate your life, learn python fast, python fundamentals, bash scripting, learn to code, coding projets, coding project ideas, python tutorial, desktop automation, coding tutorial, python 101, how to automate tasks for beginners

свернуть