学习Python以实现自动化:Excel报告、股票和加密数据提取,并通过推送通知将其发送到您的手机

你会学到什么
会计数据分析(数据清理和电子表格自动化)
股票数据提取
使用应用编程接口提取加密货币数据
使用应用编程接口向您的手机发送价格提醒(股票和密码)
Python基础知识和基本原理

Python For Accountants 2022
MP4 |视频:h264,1280×720 |音频:AAC,44.1 KHz,2 Ch
语言:英语+中英文字幕(云桥网络 机译) |时长:41节课(3h 8m) |大小解压后:1.84 GB

要求
基本的计算机技能
不需要编程经验
基本的微软Excel技能是理想的,但不是必需的

描述
欢迎来到Python For Accountants 2022!

这是一个3小时的初级Python会计课程,涵盖

第一章

简单介绍一下我,以及这门课的内容。

第二章

解释基本的Python语法和基础知识——例如,你可能喜欢读小说,想写一本书,但是在你写之前,你必须学习语法、句法和风格指南——编码也是如此,这就是本章的内容——学习Python的语法、句法和风格指南。本章将介绍以下内容

-安装Python和下载课程文件,

-使用代码编辑器(空闲)和打印功能

-算术运算符,

-比较运算符,

-变量和数据类型,

-代码文档,

-如果陈述,

-F-字符串,

-列表,

-对于循环,

-打开并保存文本文件,

-自定义功能,

-标准库,

-当循环时,

-第三方库,以及

-安装熊猫。

然后,我们将应用您在基础知识中所学的知识来解决您的第一个真实案例研究——Python股票分析——具体来说,使用雅虎金融/ YFinance库将股票市场数据提取到电子表格中。

第三章

Jupyter笔记本简介。我们将代码编辑器升级到Jupyter Notebook,它比IDLE(Python附带的默认代码编辑器)更强大。

第四章

使用熊猫图书馆教授基本的数据分析技术,这对每个会计师都很重要。这是Excel自动化的一章。你会学到一些技巧,比如

-添加和删除列,

-整理数据,

-过滤,

-删除重复项,

-格式化,

-数据透视表,

-导出到CSV & Excel,以及

-位置/中频功能。

然后,我们将通过自动化2个案例研究来应用这些知识

-超市销售报告-我们将用几行代码将大量销售数据聚合到一个数据透视表中。

-关于修复不良数据的数据清理/数据争论案例研究。

第五章

原料药概述。我将解释什么是应用编程接口,如何连接到应用编程接口,以及获取和发布请求之间的区别。

我们将以币安应用编程接口为例,我将详细介绍应用编程接口的解释,这意味着您将学习如何将加密货币价格自动提取到Python脚本或Excel电子表格中。

然后,我们将通过一个案例研究来结束这一章,该案例研究结合了我们在本课程中学到的一切——我们将使用电报应用程序(安卓/ iOS)和电报应用编程接口向我们的手机发送股票市场警报、消息和推送通知。

这门课是给谁的

希望实现自动化的会计师:重复性计算机任务(例如,Excel报告)、数据分析以及股票和加密数据提取。
对编码/编程不熟悉的会计师
想快速学习Python的会计师
想要简单易懂的Python课程的会计师

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 41 lectures (3h 8m) | Size: 1.67 GB

Learn Python to automate: Excel reports, stock & crypto data extraction, and send it to your phone via Push Notification

What you’ll learn
Accounting Data Analytics (Data Cleansing & Spreadsheet Automation)
Stock Data Extraction
Use APIs to Extract Cryptocurrency Data
Use APIs to Send Price Alerts (Stock & Crypto) To Your Phone
Python Basics & Fundamentals

Requirements
Basic computer skills
No programming experience required
Basic Microsoft Excel skills ideal, but not required

Description
Welcome to Python For Accountants 2022!

This is a ~3 hour beginners Python Accounting Course that covers

Chapter 1

A quick introduction about me, and what this course covers.

Chapter 2

Explains basic Python syntax and fundamentals – for example, you might love reading novels and want to write a book, but before you write it, you have to learn grammar, syntax, and style guides – same thing goes with coding, and that’s what this chapter is about – learning the grammar, syntax, and style guides of Python. This chapter will go through the following

– Installing Python & downloading course files,

– Using the code editor (IDLE) & print function

– Arithmetic operators,

– Comparison operators,

– Variables & datatypes,

– Code documentation,

– If statements,

– F-String,

– Lists,

– For loops,

– Opening & saving text files,

– Custom functions,

– Standard libraries,

– While loops,

– Third party libraries, and

– Installing Pandas.

We’ll then apply what you’ve learnt in the basics to solve your first real world case study – Python stock analysis – specifically, extracting stock market data to a spreadsheet using the Yahoo Finance / YFinance library.

Chapter 3

An introduction to Jupyter Notebooks. We upgrade our code editor to Jupyter Notebook which is more powerful than IDLE (the default code editor that comes with Python).

Chapter 4

Teaches fundamental Data Analytics techniques using the Pandas library which is important for every Accountant to know. This is THE chapter for Excel automation. You’ll learn techniques like

– Adding & removing columns,

– Sorting data,

– Filtering,

– Removing duplicates,

– Formatting,

– Pivot tables,

– Exporting to CSV & Excel, and

– Location / If Function.

We’ll then apply those learnings by automating 2 case studies

– Supermarket sales report – we’ll aggregate loads of sales data into a pivot table with just a few lines of code.

– Data Cleaning / Data Wrangling case study which is about fixing bad data.

Chapter 5

A general overview of APIs. I’ll explain what is an API, how to connect to APIs, and the difference between a Get and Post Request.

We’ll be using the Binance API as an example as I go through the API explanation which means you’ll learn how to automatically extract cryptocurrency prices to your Python script or to an Excel spreadsheet.

We’ll then finish this chapter with a case study which combines EVERYTHING we’ve learnt in this course – we’ll use the Telegram App (Android / iOS) and Telegram API to send stock market alerts, messages, and push notifications to our phone.

Who this course is for

Accountants who want to automate: repetitive computer tasks (e.g., Excel reports), data analytics, and stock & crypto data extraction.
Accountants who are new to coding / programming
Accountants who want to learn Python quickly
Accountants who want an easy to understand Python course

隐藏内容: ********, 支付¥5下载