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
Comments are closed.