How I AUTOMATE my FINANCES USING PYTHON

Internet Made Coder • July 23, 2022
Video Thumbnail
Internet Made Coder Logo

Internet Made Coder

@internetmadecoder

About

I make videos about learning to code, startups & AI. 🚀 Become a Python Software Engineer with no Degree - https://academy.internetmadecoder.com/python-dev-masterclass 📧 FREE Coding Tips & Tech News in Just 4 Minutes - https://academy.internetmadecoder.com/internet-made-club 🧠 Algo University - https://academy.internetmadecoder.com/algo-uni For sponsorships: [email protected] Other: [email protected] UAE media license number: 1698306

Video Description

Thank you to Mailgun for sponsoring this video! Try Mailgun today by using my link https://mailgun.com/internetmadecoder 🚀 Zero to Software Engineer with no Degree - https://www.internetmadecoder.com/python-dev-masterclass?video=IbdgcUqWSeo Today, we will learn how you can automate your personal finances using PYTHON and Google Sheets. Make Python your (unpaid) financial manager! 📈 GOOGLE SHEETS TEMPLATE (copy this or create your own) - https://docs.google.com/spreadsheets/d/1ctduP5gPgxBh7_1uQ0F4CHBKnLthOGuqq4dflM4oaWI/copy 1. Acces your transactions as CSV files - further detail on reading CSV data in Python https://realpython.com/python-csv/ 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 - https://docs.gspread.org/en/latest/oauth2.html#enable-api-access-for-a-project 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) 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

You May Also Like

Upgrade Your Everyday Carry

AI-recommended products based on this video

Loading...
NEXPOW Car Jump Starter,Car Battery Jump Starter Pack 1500A Peak Q10S for Up to 7.0L Gas and 5.5L Diesel Engine12V Auto Battery Booster,Jumper Cables,Portable Lithium Jump Box with LED Light/USB QC3.0

NEXPOW Car Jump Starter,Car Battery Jump Starter Pack 1500A Peak Q10S for Up to 7.0L Gas and 5.5L Diesel Engine12V Auto Battery Booster,Jumper Cables,Portable Lithium Jump Box with LED Light/USB QC3.0

(4,578)
$71.99
FREE delivery Sat, Jan 3
2K+ bought in past month
Loading...
Heavy Duty Tripod Gimbal Head, Aluminum Alloy 360° Panorama Gimbal with for Arca Swiss Standard Quick Release Plate and Bubble Level, with 1/4 Inch and 3/8 Inch Screws

Heavy Duty Tripod Gimbal Head, Aluminum Alloy 360° Panorama Gimbal with for Arca Swiss Standard Quick Release Plate and Bubble Level, with 1/4 Inch and 3/8 Inch Screws

(0)
$202.00
FREE delivery Jun 27 - Jul 10
Loading...
koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

koolehaoda L Shape Camera Bracket, Video Vertical Shooting Quick Release Plate L Stand Arca Swiss Compatible for Tripod Head Ballhead DSLR Camera

(87)
$23.98
FREE delivery Thu, Jun 19 on your first order
Loading...
Ball Head Manbily Tripod Head Metal Aluminum Body 360° Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

Ball Head Manbily Tripod Head Metal Aluminum Body 360° Panoramic Monopod Head with Extra Arca Swiss Quick Release Plate, Load up to 17.6lbs/8kg,Camera Head for DSLR, Camcorder, Slider (Red)

(274)
$85.26$77.52
FREE delivery Jun 17 - 19Only 10 left in stock.
Loading...
eazpower for Magsafe Power Bank 10000mAh, Magnetic Battery Pack Wireless, 20W PD Fast Charging, Compact Portable Charger with Built-in Cables and Stand for iPhone 16/15/14/13/12/ Apple Watch/Airpods

eazpower for Magsafe Power Bank 10000mAh, Magnetic Battery Pack Wireless, 20W PD Fast Charging, Compact Portable Charger with Built-in Cables and Stand for iPhone 16/15/14/13/12/ Apple Watch/Airpods

(330)
$39.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Apple iPad Mini (A17 Pro): Apple Intelligence, 8.3-inch Liquid Retina Display, 128GB, Wi-Fi 6E, 12MP Front/12MP Back Camera, Touch ID, All-Day Battery Life — Purple

Apple iPad Mini (A17 Pro): Apple Intelligence, 8.3-inch Liquid Retina Display, 128GB, Wi-Fi 6E, 12MP Front/12MP Back Camera, Touch ID, All-Day Battery Life — Purple

(223)
$599.98$569.98
FREE delivery Sat, Sep 20
100+ bought in past month
Loading...
Metapen Air 8 Apple Pencil for iPad 2018-2025, 20H Battry Life, 2Min Fast Charging, Palm Rejection, Stylus Pen for iPad 11/10/9/8/7/6th, iPad Pro 12.9/11/13“M4, iPad Air 3/4/5/6/M2/M3, iPad mini 5/6

Metapen Air 8 Apple Pencil for iPad 2018-2025, 20H Battry Life, 2Min Fast Charging, Palm Rejection, Stylus Pen for iPad 11/10/9/8/7/6th, iPad Pro 12.9/11/13“M4, iPad Air 3/4/5/6/M2/M3, iPad mini 5/6

(1,985)
$14.22
FREE delivery Tue, Sep 9 on your first order
1K+ bought in past month
Loading...
BASESAILOR iPhone 16 15 Pro Max Charger Cord,USB to USB C Cable 6.6FT/2Pack,Type C Charging Power Cord for Apple iPad 10,Samsung Galaxy AI S25 S24 S23 S22 S20 Plus Ultra Flip,A52 A53 A54,Google Pixel

BASESAILOR iPhone 16 15 Pro Max Charger Cord,USB to USB C Cable 6.6FT/2Pack,Type C Charging Power Cord for Apple iPad 10,Samsung Galaxy AI S25 S24 S23 S22 S20 Plus Ultra Flip,A52 A53 A54,Google Pixel

(29,760)
$12.59
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones

iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones

(321)
$17.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314

(3)
$44.99
FREE delivery Thu, Jun 19
Loading...
SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with Cable Clamp, Bulit-in QR Cold Shoe NATO Rail/QR Plate for Arca, Modular Design Compatible with Original XLR Handle - 4770

(35)
$124.94
FREE delivery Thu, Jun 19
Loading...
SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with XLR Handle Extension, Wrist Strap and Cable Clamp for HDMI, QR Cold Shoe, NATO Rail/QR Plate for Arca,Titanium Gray - 4771

SmallRig FX3 / FX30 HawkLock Quick Release Camera Cage Kit for Sony with XLR Handle Extension, Wrist Strap and Cable Clamp for HDMI, QR Cold Shoe, NATO Rail/QR Plate for Arca,Titanium Gray - 4771

(72)
$174.24$162.04
FREE delivery Thu, Jun 19
Loading...
AC Power Cord Cable Fit for Sony PS5 PS4 PS3 Slim PlayStation 5 4 3, Xbox Series X/S, Xbox One X/S, TV, Printer Universal 2 Prong Supply Replacement - (ETL Listed Cable)

AC Power Cord Cable Fit for Sony PS5 PS4 PS3 Slim PlayStation 5 4 3, Xbox Series X/S, Xbox One X/S, TV, Printer Universal 2 Prong Supply Replacement - (ETL Listed Cable)

(5,351)
$8.49
Prime
500+ bought in past month