Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Life Purpose Meditation Personal Transformation Neuroscience Emotional Intelligence
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Software Engineering Python

Python Automation Course : Automate Mundane tasks in Python

openpyxl pypdf2, Web scraping, selenium, Beautifulsoup, regular expression, send email, GUI automate , Python Automation
Rating: 4.4 out of 54.4 (115 ratings)
4,963 students
Created by Ankit Mistry
Last updated 11/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Learn how to import excel workbook in python
  • Learn to create and delete worksheet
  • Read, write individual shell in worksheet
  • Learn how to manipulate excel functionality through automation
  • Learn to add image, formula and chart in excel through programming
  • Manipulate Microsoft word file with docx python module
  • Read, Parse and write PDF file from python PyPDF2
  • Learn webscraping with python Beautiful Soup library
  • Learn reading and writing file, filepath

Course content

50 sections • 186 lectures • 21h 7m total length

  • IMPORTANT NOTES
    00:05

  • Preview03:56
  • Course FAQ
    00:22

  • Preview14:23
  • Python Installation
    06:51
  • 3. Download and Install Anaconda
    03:33
  • 4. Getting started with Spyder IDE
    07:14
  • Python 2 vs Python 3
    06:08
  • Print & Input function
    06:54
  • 7. Python programming Introduction
    07:27
  • Python version
    1 question

  • Code Download
    00:02

  • 8. Python data Types
    04:29
  • 9. Python Numbers
    06:59
  • 10. Operator precedence
    08:22
  • 11. Python Help
    02:47
  • 12. Python Variable
    08:25
  • 13. Variable Operations
    06:16

  • 14. Introduction to String
    08:03
  • 15. String concatenation and Formatting
    08:31
  • 16. String Methods
    04:22
  • 17. String Indexing - Slicing
    10:42
  • 18. String immutability
    03:12

  • 19. Python Boolean Datatype
    03:29
  • 20. Python Built in Functions
    04:47
  • 21. Python DataType Conversion
    04:01
  • Convert DataType
    1 question
  • 22. Python bin(), hex(), Oct() Number System Conversion
    02:05

  • 23. Define List DataType
    05:41
  • 24. List Indexing - Slicing
    05:05
  • 25. List Methods
    07:44
  • 26. More about List
    03:14
  • 27. Python Tuples
    04:22
  • 28. Python Sets
    09:40
  • 29. Define Python Dictionary
    06:10
  • 30. More on Dictionary
    10:26

  • Preview02:26
  • 33. Python truthiness
    04:51
  • 31. Conditional Logic
    11:19
  • 34. Mathematical & Logical Operator
    07:31
  • 35. == vs is in Python
    07:21
  • 36. Introduction to Functions
    07:16

  • 38. Default Argument and Keyword Argument
    10:24
  • 37. Define Function in Python
    09:15
  • 39. Return in Function
    06:56
  • 40. Function DocString Help
    04:06
  • 41. Varible Scope - Global
    11:31

Requirements

  • High School Mathematics

Description

==============================================

What previous students have said: 

"The entire course was very well explained.

Accessing Excel, word, pdfs using Python was a lot of fun.

The Web scraping session was extremely very well explained.

Ankit was very responsive to my questions.

I would highly recommend any course he teaches."


"thank you, Ankit. I learned a lot!"

" The content is great and is guide that anyone with little python and Jupyter experience can follow. However, the instructor takes some shortcuts that might make it confusing for a beginner."

"Excellent short and sweet explanation by Ankit"

==============================================

Whole world is moving towards automation. We human build machine to make task automatically.Computer science are mainly the field of automation engineer. And We deal with Excel,Word, PDF file in daily routine. So, do you find any  task mundane or boring and want to automate by writing some programming script.Then this course is for you.
 
In this course, 

  • Learn Python Excel - openpyxl library tutorial for beginners and advanced to make your excel related task automated from python. 

  • This course teaches you how to read workbook  and read and write Excel file in particular cell of worksheet. 

  • How to create new workbook and worksheet. How to add chart, formula, image to excel sheet.

  • How manipulate Microsoft word and .pdf file from python docx, PyPDF2 library

  • How to download webpage and extract content out it with BeautifulSoup library

  • Webscraping mini project, count YouTube video views.

  • Play with files and folder, copying and moving file.

  • Browser automation with selenium

  • Module concept in Python

  • GUI automation with mouse and keyboard

  • Handling error and exception

  • Regular expression

  • Python basics and advanced module


This course provides techniques to deal with MS Excel files from Python, PDF file from python and many task to be automated with python library. This course  is for those  who want make daily routine excel related task automatically.

Who this course is for:

  • anyone who knows python programming want automate excel, word, pdf related task from python
  • anyone who want to learn openpyxl, docx, PyPDF2 python library
  • anyone who is intersted to enter in world of automation

Instructor

Ankit Mistry
Software Developer | I want to Improve your life & Income.
Ankit Mistry
  • 4.2 Instructor Rating
  • 2,250 Reviews
  • 44,714 Students
  • 17 Courses

I am Ankit Mistry, completed my master from IIT Kharagpur in area of machine learning, Artificial intelligence.Now working as Software Developer, Big Data Engineer in one of leading private investment bank with 8+ years of experience in software industry. 
Over the time I developed interest related to data discipline and  learned about data analysis, machine learning model development.

Created course in area of Python, Data Science, Data analysis, Machine Learning.

I am so excited to be on Udemy online learning platform and want to make big impact on your software career.

I hope you will like my course offering.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.