Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Python for Accountants II
Rating: 4.7 out of 5(50 ratings)
3,715 students

Python for Accountants II

A Journey From Excel to Python
Created byRizwan Ahmed
Last updated 5/2021
English
English [Auto],

What you'll learn

  • Students will learn python programming language.

Explore related topics

Course content

2 sections • 7 lectures • 1h 11m total length

  • Introduction to Data Frames8:41

    Learn to use Pandas libraries to create data frames like Excel worksheets, install the library, and build frames from lists and dictionaries for data analysis.

  • Various Methods of Creating Data Frames12:29

    Create data frames from dictionaries and csv files using pandas. Explore indexing with columns and custom indices, view data with head and tail, and filter with loc and iloc.

  • Data Frame Methods - Loc vs iLoc9:50

    Explore data frame indexing with loc and iloc, learning label-based versus integer-based selection of rows and columns. Practice practical techniques for selecting, resetting the index, and renaming columns.

Requirements

  • Completion of course Python for Accountants I.

Description

This is part two of the series, Python for Accountants, 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 an hour 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 Data Frame (Excel of Python)

· How to Create a Data Frame and few methods

·Introduction to the DRY concept and Control Flow

.Functions

.Conditional Statements

.Loops


After completing this course

1. You will have an understanding of more complex concepts of python and programming in general.

2. How to create data frames and read CSV Files

3. How to automate tasks with loops and conditional statements

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

---------------------------------------------------------------------------------------------------------------------------------------------------------

Who this course is for:

  • Accounting and finance professionals, students in accounting and finance and people with general interest in python.

Report abuse