Python is an excellent programming language to learn for people in data professions. In this in-depth video, learn how to get started with Python and use it for practical situations. You will also learn how to build 3 projects (2 mini-projects and one big project). If you have been on the lookout for a thorough & easy explanation on how to write Python code, this is the video for you. Please set aside 2 hours of time to learn and practice. Let's GO!!! 📚What is covered in the video ========================= ◉ Getting started with Python ◉ Working with variables in Python ◉ IF condition, indentation in Python ◉ While loop in Python ◉ Building a simple expense calculator with Python ◉ Working with Lists in Python ◉ Using For loop when navigating a list ◉ Generating list of values with loops ◉ List comprehension in Python ◉ How to access an item or a part of list in Python ◉ Creating a multiplication table with Python lists ◉ Building an enhanced expense calculator with Python ◉ Working with CSV & Datetime libraries in Python ◉ How to execute Python code from command line ◉ How to learn more – My top 6 tips 👨🏾‍💻📘Code Samples ================= Download ZIP file with all code samples from here 👉 https://chandoo.org/wp/python-for-excel-people/ More on the files, installation instructions - https://chandoo.org/wp/python-for-excel-people/ ⚙🛠 INSTALL PYTHON & VS CODE Download Python - https://www.python.org/downloads/ Download Visual Studio (VS) Code - https://code.visualstudio.com/ Python Setup Instructions - https://docs.python.org/3.10/using/index.html ⏱Video Timestamps ================== 0:00 - Why Python? 2:08 - Our first Python program 6:10 - Python concepts with a mind-map 15:00 - Variables in Python 20:59 - IF conditions in Python 24:00 - Mini-project #1 - Expense Calculator in Python 26:08 - Loops in Python 32:13 - Python Lists 38:16 - Lists & For Loops 40:18 - Generating a list with loops 43:00 - List comprehension in Python 46:37 - Accessing items in a lists 50:41 - Mini-project #2 - Multiplication Table 56:29 - f Expressions in Python 58:48 - Project - Expense Calc app with Python 1:01:00 - Libraries in Python (for CSV, Datetime) 1:01:47 - Working with dates in Python 1:03:01 - Working with CSV files in Python 1:09:47 - Putting everything together for our project 1:16:18 - Running Python files from command line 1:18:04 - How to learn more - My top 6 tips 💡 PYTHON BOOKS & RESOURCES ============================= 📚 My book recommendations: 📘 Python Crash Course 2nd Edition by Eric Matthes - https://amzn.to/3PBzYRK This is the book we all (Jo, kids & I) read and really loved it. The explanations and examples are easy enough to get started. There is enough variety to please everyone. Pictured aside is my son with the book 🙂 📘 Automate boring stuff with Python - https://amzn.to/3Py5T5w More practical if you want to get things done with Python. I read it a few times and really like the practicality of the book. Python Data Science Handbook - https://amzn.to/3MFKOUK Python is particularly useful for doing data science & building machine learning models. This is an area of focus for me in the next months. I suggest getting the Python Data Science book once you have strong foundation in the language. 💻 Python Course Recommendations: I recommend Coding 101: Python for Beginners by Alvin Wan on SkillShare. It is a concise and practical course that should give you enough confidence to build more powerful code. Check out the class here - https://skl.sh/3kIP4Xt (you get 1 month free access to SkillShare when you join with my link) ~ Note about the book & course links: If you purchase the course or books using my links, I receive a small commission. My recommendation is based purely on the merit of them rather than the pay-out. 👨🏾‍💻👨‍💻 MY VIDEOS ON CODING ========================= Check out below videos for more on coding for Data folks. Getting started with VBA (2 part series) - https://www.youtube.com/watch?v=5k-KpSkrROw VBA vs. Python - Comparison for Data people - https://www.youtube.com/watch?v=l0o7VMEf0yc Step by Step by VBA Course by Chandoo - https://chandoo.org/wp/vba-classes/ ~ 😀 ALL THE BEST #Python #DataAnalytics