
A brief introduction to how python opens new ways of analysing data.
A description of what areas we will learn in this course. The course is designed for accounting professionals. Therefore, areas that are most beneficial to accountants are included in it.
Programming translates human instructions into a computer's actions using precise syntax, grammar, and a sequence of steps processed as zeros and ones.
Explore how Python, an open source, free, high level, general purpose language, powers web, data analytics, ai, and blockchain, and serves as the first step toward next generation career paths.
Explain writing code with text editors and IDEs, showing how to run html in a browser and Python, and introduce cloud-based Jupyter notebook via Colab for easy access.
Learn to set up and use Google Colab for Python programming, with notebooks, code and text cells, markdown, and exporting professional PDFs for data science tasks.
Explore the three data structures—structured, unstructured, and semi-structured—through Excel layouts, social media text, and HTML and JSON formats, and see their role in financial data, sentiment analysis, and Netflix-style recommendations.
You have the option to either download the file and upload it into your Google Colab or a link to the practice file is added to my GitHub repository. You will see the option of "Open in Colab". Click it and practice.
Learn how variables are created and named in Python, and why keywords cannot be used as identifiers; explore common keywords like and, is, break, continue, for, and from.
You have the option to either download the file and upload it into your Google Colab or a link to the practice file is added to my GitHub repository. You will see the option of "Open in Colab". Click it and practice.
You have the option to either download the file and upload it into your Google Colab or a link to the practice file is added to my GitHub repository. You will see the option of "Open in Colab". Click it and practice.
Explore Python operators and their use in arithmetic, comparison, and assignment, with simple examples, and note that operators are categorized into groups to be explored later.
You have the option to either download the file and upload it into your Google Colab or a link to the practice file is added to my GitHub repository. You will see the option of "Open in Colab". Click it and practice.
explore Python arithmetic operators, including plus, minus, multiplication with the asterisk, division with slash, exponentiation with two stars, and modulo and integer division, noting the bitwise operator is not covered.
Learn how assignment operators work in Python, including the equal sign and plus-equals, to update variables like year-to-date sales efficiently. Explore other operators beyond plus and minus.
Explore logical operators in Python for accountants, including and, or, and not, and how they evaluate booleans to guide a buy decision.
Master python membership operators in and not in to check if an invoice number exists in a dataset, retrieve related invoice details, and interpret true or false results.
Master string concatenation with the plus operator by combining string variables, such as 'revenue for the year is', and convert numbers to strings to avoid unsupported type errors.
Learn how functions and methods operate on data with parentheses inputs and dot notation, and distinguish them from operators. Explore string methods like upper, title, and count.
Explore how Python lists organize stocks and data in accounting, a versatile built-in data structure. Access items by index, slice subsets, and use zero-based and negative indexing.
Explore list methods in Python, including append and insert to add elements, and len, min, max to analyze lists, with in and not in checks on a portfolio list.
Explore how dictionaries store data with keys and values, access entries by key, and use the get method to avoid key errors, including nested lists as values.
This is a beginner level course designed specifically for accounting and business professionals who have no prior knowledge of computer programming.
Python is gaining popularity in the accounting and finance field. Despite professional willingness to learn it, most courses available online are more centric to IT background professionals.
It is a 1 hour and 18 minutes short course for accountants, auditors, and other finance professionals to learn python taking small steps at a time. The aim is to avoid technical jargon and setup complexities so the accountants can get straight to learning rather than frustrating installing software and setting up environments.
Practice exercises use Google Colab Notebook, so you don’t need to install anything on your computer. Google Colab is a cloud-based software that allows you to write your code online. All you need is just a google account.
Class notebooks are attached to either download or linked to open in Google Colab directly.
What we cover in this course:
· Introduction to Programming
· Introduction to Python
· Syntax or Grammar of Programming
· Variables
· Data Formats (Structured Data, Unstructured Data etc.)
· Data Types (String, Numbers, Dates, Boolean etc.)
· Operators(>, =, /, ==, & etc.)
· Conditional Statements (if, else, etc.)
· Loops (For, While)
· Functions
· Data Structures in Python (Lists, Dictionaries, Data Frames )
After completing this course
1. You will have an understanding of computer programming
2. Various Data Structures
3. Write basic Python syntax
4. Familiarity with a notebook, so you know where to write your code.
See you in Class!
-----------------------------------------------------------------------------------------------------------------------------------------------------
I want to credit the following resources in making this course.
Music:
Track: We Were Young — Vendredi [Audio Library Release]
Music provided by Audio Library Plus
Available at YouTube
Videos and Images:
Pixabay
Pexels
Videezy
---------------------------------------------------------------------------------------------------------------------------------------------------------