In This Issue
Upcoming Events
3 for 2 ticket Offer - Tech Summit 2019
it@cork Skillnet
Scrum Product Owner
Kanban Work Visualisation Workshop
Automating with Python
Other Industry Events
Renaissance Cyber Expo Ireland 2019 Roadshow 30th April - Radisson Blu, Little Island, Cork
Ministry of Testing  Cork April Meetup
Survey
Brightwater IT Talent Shortage in Munster Survey
Employment Opportunities
Senior Data Warehouse Engineer
SAP Security Consultant
Head of Unit Digital Transformation Cork
Network Operations Engineer
Member Spotlight
Career And Interview Success
TechBrew Cork “Addressing Growth Challenges”
March Tech Talk "Grand Challenges for LifeScience and Healthcare”
Contact Us

Sarah Walsh admin@itcork.ie


Automating with Python

To register your interest in this course please email Annette Coburn at skillnet@itcork.ie

Course Description

This course entitled Automation with Python will teach you how to create Python programs to:

  • Search for text in a file or across multiple files
  • Create, update, move, and rename files and folders
  • Search the Web and download online content
  • Update and format data in Excel spreadsheets of any size
  • Split, merge, watermark, and encrypt PDFs
  • Send reminder emails and text notifications
  • Fill out online forms

Course Outline

Day-1

  • Python Basics
  • Flow Control
  • Functions
  • Lists
  • Dictionaries and Structuring Data
  • Manipulating Strings

Day-2

  • Pattern Matching with Regular Expressions
  • Reading and Writing Files
  • Organizing Files
  • Debugging
  • Web Scraping

Day-3

  • Working with Excel Spreadsheets
  • Working with PDF and Word Documents
  • Working with CSV Files and JSON Data
  • Keeping Time, Scheduling Tasks, and Launching Programs
  • Sending Email and Text Messages

Target Audience

This course is designed for anyone who needs to learn how to write programs in Python. Students should have taken the Software Development for Non-Programmers course or have some experience with at least one programming language.

Course Pre-requisites

  • Basic Python programming knowledge.
  • Content creating, editing text files and moving between directories at a command line
  • Basic Web Browsing experience

Course Content

  1. Python Basics
  • Using the Interactive shell
  • Errors are OK
  • Math Operators: (precedence high to low)
  • Brackets to control Precedence
  • Common Data Types
  • String Concatenation & Replication
  • Assignment Statements
  • Valid and Invalid variable names
  • Your First Program
  • str(), int() & float() Functions
  • Text and number equivalence
  1. Flow Control
  • Flow Charts
  • Boolean Values
  • Comparison Operators
  • Operating Application
  • Binary Boolean Operators
  • Operators Evaluation
  • Code Blocks
  • Flow control if else elif
  • while loop
  • break statement
  • continue statement
  • for loops & range
  • Importing Modules
  • Sys.exit ()

>>> Workshop

 

  1. Functions
  • def statement
  • return values
  • None value
  • Keyword Arguments and print()
  • Scope: Global can’t access local
  • Scope: local can’t use other local
  • Local and Global Variables with the Same Name
  • Exception Handling
  • try & except

>>> Workshop

  1. Lists
  • List data type
  • Multi-dimensional lists
  • Sub-lists with Slices
  • Changing values with indexes
  • List Concatenation and List Replication
  • Removing Values from Lists with del
  • Working with lists
  • Using for Loops with Lists
  • in and not in Operators
  • Multiple Assignment idiom
  • Methods
  • Value in a List with the index() Method
  • append(), insert() & remove() Method
  • sort() Method
  • Exceptions in Indentation
  • tuples immutable Lists
  • tuples Conversion
  • References
  • Passing References
  • copy Module’s copy() and deepcopy()

>>> Workshop

  1. Structuring Data with Dictionaries
  • Dictionary Data Type
  • keys() values() & items()
  • In the Dictionary
  • get() in Dictionaries
  • setdefault
  • Modelling the Real World
  • Tic-Tac-Toe
  • Shall we play a game ?
  • Nested Dictionaries

>>> Workshop

  1. Manipulating Strings
  • String Literals
  • Comments
  • Slicing strings
  • in strings
  • Useful string functions
  • isX String
  • startswith() & endswith()
  • join() & split()
  • rjust(), ljust() & center()
  • strip() rstrip() & lstrip()
  • Project: Password Locker
  • Project: Adding Bullets to wiki Markup

>>> Workshop

  1. Pattern Matching with Regular Expressions
  • Creating regex Objects
  • Multiple Matching Groups with |
  • zero or one match ?
  • zero or more match *
  • one or more +
  • Repetitions {}
  • Greedy Matches & findall
  • Character Classes
  • Matching Newlines re.DOTALL
  • Review of regex Symbols
  • Substituting Strings with the sub()

>>> Workshop

  1. Reading and Writing Files
  • Path names
  • file Names
  • File Size and Folder Contents
  • Path Validity
  • Reading From Files
  • Writing to files
  • Saving Variables with Shelve
  • Pretty Printing

>>> Workshop

  1. Organising Files
  • shutil Module and File Copies
  • Deletion
  • Walking the tree
  • Playing with zip files
  • Extracting from zips
  • Creating zip files

>>>Workshops

  1. Debugging
  • Debugging
  • Exceptions
  • Traceback
  • Assertions
  • logging
  • Logging Levels
  • Disabling Logging
  • IDLE Debugger

>>> Workshop

  1. Web Scraping
  • Web Scraping
  • webbrowser module
  • requests module
  • Missing Pages
  • Saving Pages
  • HTML
  • HTML Anchors
  • Chrome Developer Tools
  • BeautifulSoup
  • CSS Selectors
  • Finding an Element with the select() Method
  • Getting data from an Element’s Attributes
  • Controlling your browser with Selenium
  • Clicking the Page
  • Filling in Forms
  • Clicking on buttons

>>> Workshop

 

  1. Working with Excel
  • Working with Excel
  • example.xlsx
  • Getting Sheets from the Workbook
  • Getting Cells from the Sheets
  • Getting Rows and Columns from Sheets
  • Writing Excel Documents
  • Playing with Fonts
  • Dimensions
  • Merging Cells
  • Formulas
  • Freeze panes
  • Building Charts
  • Building Charts

>>> Workshop

  1. Working with PDF & word documents
  • Working with .pdf & .docx
  • Extracting Text from PDFs
  • Rotating PDFs
  • Reading Word Documents
  • Driving the styles
  • Writing Word Documents

>>> Workshop

  1. Working with CSV and JSON
  • Working with CSV and JSON
  • Extracting Text from CSV files
  • Reader Objects in a for Loop
  • Writer Objects
  • Delimiters and line terminators
  • Reading JSON with loads()
  • Writing JSON with the dumps()
  • REST APIs and JSON
  • REST API returns

>>> Workshop

  1. Keeping Time, Scheduling Task & Launching Programs
  • time Module
  • datetime Module
  • timedelta
  • datetime conversion to strings
  • strings to datetime objects
  • Threading
  • Threading

>>> Workshop

  1. Sending Email & text messages
  • smtplib Module
  • imapclient Module
  • pyzmail Module
  • Seaching Email
  • twilio
  • Seaching Email

 

To register your interest in this course please email Annette Coburn at skillnet@itcork.ie

Facebook Twitter LinkedIn