Learn Python – Getting started + 3 Projects for Excel & Data people
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://youtu.be/5k-KpSkrROw
VBA vs. Python – Comparison for Data people – https://youtu.be/l0o7VMEf0yc
Step by Step by VBA Course by Chandoo – https://chandoo.org/wp/vba-classes/
~
😀 ALL THE BEST
#Python #DataAnalytics