Accounting Data Analytics with Python
About this Course
This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data). The first half of the course picks up where Introduction to Accounting Data Analytics and Visualization left off: using in an integrated development environment to automate data analytic tasks. We discuss how to manage code and share results within Jupyter Notebook, a popular development environment for data analytic software like Python and R. We then review some fundamental programming skills, such as mathematical operators, functions, conditional statements and loops using Python software. The second half of the course focuses on assembling data for machine learning purposes. We introduce students to Pandas dataframes and Numpy for structuring and manipulating data. We then analyze the data using visualizations and linear regression. Finally, we explain how to use Python for interacting with SQL data.Created by: University of Illinois Urbana-Champaign
Related Online Courses
By the end of this project, you will be able to set up a Facebook Ads campaign. Throughout the project, you will be able to create a Business Manager account and an Ad account. We will also be able... more
By the end of this course, a learner will have a solid understanding of Large Language Models running locally. You\'ll be able to setup a local environment using powerful tooling to run different... more
Learn how to identify the enablers and barriers to learning transfer. Use your own experience to categorise the processes and activities involved in learning and transferring that learning into... more
Seventy percent of kids drop out of sports before their high school graduation. Only 15% leave because they feel they are not good enough. Almost 70% leave because they were not having fun, or due... more
This specialization is developed for seniors and fresh graduate students to understand fundamental network architecture concepts and their impacts on cyber security, to develop skills and... more