|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-guide-to-automation-with-r-in-2021/
课程评论：没有评论
课程名称：使用 R 语言和 RStudio 的编程自动化 - 完整指南 课程概述： 本课程将教你如何利用 R 编程语言和 RStudio 自动化各类办公和商业任务。学员将全面了解一套工具和包，可以帮助你轻松处理日常的工作流程。课程不会涉及分析或数据科学内容，也不包括统计或机器学习的学习；我们的重点在于通过 R 编程让你的生活更轻松，从而节省时间和为公司节省开支。 在完成本课程后，你将能够： - 使用 R 和 RStudio 安排任何重复任务。 - 动态读取和写入各种来源（本地驱动器、网络、Google 表格、Dropbox、亚马逊等）的文件。 - 使用各类 R 包存储结果，而无需复杂的 SQL 数据库。 - 解析电子邮件及附件，以进行进一步处理。 - 从 R 脚本生成自定义的 Excel、PowerPoint 和 Word 文档。 - 通过电子邮件发送结果和附件文件。 - 将你的脚本导出到云端，安排自动运行或按需运行。 - 创建云仪表板以控制 R 自动化任务。 该课程是网上最完整的自动化课程，讲师将不断更新课程内容以涵盖新的编程技能和特性。 讲师经验： 讲师在银行工作的经历使他能编写数以百计的自动邮件报告，从而高效跟踪股市信息和投资组合表现。他目前作为顾问，帮助公司自动化重复任务，节省每月数百小时的手动工作。讲师每天教授 R、C# 和 Excel/VBA，对于学习编程的人所需的工具有着深刻见解。 课程使用的语言与工具： R 是一种简单易学的编程语言，特别适合数据操作，RStudio 被认为是最佳的 IDE。截止 2023 年底，R 和 RStudio 拥有庞大的用户基础，并且 R 包下载量在持续增长。 课程内容将涵盖的包包括： - dplyr：用户友好的数据操作。 - tidyr：数据清理和去重。 - stringr：字符串和正则表达式处理。 - lubridate：处理日期对象。 - pdftools：解析 PDF 文件内容。 - htmltab：解析网页中的 HTML 表格。 - gsheet：下载 Google 表格文件。 - mRpostman 和 emayili：处理电子邮件。 - openxlsx、officer 和 flextable：读取和写入 Excel、Word 和 PowerPoint 文档。 通过本课程，你将获得必要的编程自动化技能，提升工作效率。
Learn how to Automate every Office and Business task with R programming language and RStudio!This course will give you a complete overview of a set of tools and packages that can help you automate any office and business task with the R programming language.With Udemy's 30-day money-back guarantee in place, there's no need to worry if the class doesn't meet your expectations.The learning material does not contain any analytics or data science lessons. We will not study statistics or machine learning. We will not write complex algorithms and solve coding puzzles.Instead, we focus on how to make your life easier and save time for yourself and money for your company.This course is the most complete automation course you will find onlineAfter completing this course you will be able to schedule any repetitive task with R and RStudioread and write files dynamically from various sources (local drive, web, Google Sheets, dropbox, amazon)store results without complex SQL databases using various R packagesparse emails and attachments for further manipulations with R programmingproduce custom Excel, PowerPoint, and Word documents from R scriptssend results by email and files as attachmentsexport your scripts to the cloud, schedule automatic runs or on-demandcreate a cloud dashboard to control R automated tasksAutomation is a very dynamic skill and I am learning new skills every day. This course will be updated with new programming skills, packages and features.My experienceDuring my banking career, I had to program hundreds of automatic mailing reports to track stock market information and portfolio performance on daily basis. By automating these tasks I became very efficient with my time.Currently, as a consultant, I help dozens of companies to automate their recurring tasks. Often hundreds of hours of manual work per month are saved once a complex recurring task is automated. I teach R, C# and Excel/VBA on a daily basis and after 1,200 mentoring sessions, I know precisely which tools are necessary for most of the people who learn programming.As a consultant, you can very quickly acquire new clients who desperately need to improve their business.Why R, RStudio, and Posit?R is one of the simplest programming languages to learn and is very friendly with data manipulation.R is open source and is part of a large community of developers that create and maintain packages we will explore during this course.RStudio is probably the best IDE for programmers (also supports C++, Python, SQL, and other languages).As of the end of 2023, R is rocking it with these cool numbers:RStudio has an active user base of 3.5 million.Posit cloud has a 65,000 userbase.Over the year, an impressive 2 billion R packages were downloaded.Which Packages will be covered?Base R functions will be covered as much as possible however they are very limited. Therefore we will learn a set of packages necessary for the programming automation tasks.dplyr: R data manipulation with very user-friendly syntax tidyr: data clean-up, remove duplicates, NA's etc.stringr: string and regex manipulationlubridate: work with Date class objectspdftools: parse content from PDF fileshtmltab: parse html tables from webgsheet: download files from Google SheetsmRpostman: connect to email box and read data from Emailsemayili: connect to email box and send emailstableHTML: create custom format HTML tablesopenxlsxl: read and write Excel filesofficer: read and write Word and PowerPoint documentsflextable: create formated tables as content for officerrdrop2: connect to dropbox as cloud source using R and RStudio
