Wednesday, August 8, 2018




Office Python Series is an initiative of Code.Sydney to help everyday office workers be more productive and efficient at work by introducing them to some level of python programming to complement their current skill set.

You will be presented with different office scenarios showing the business requirement. Related lessons to help you satisfy the business requirement are presented in order.


Please join our Meet up Group to stay updated with our regular face-to-face meet up schedule when introducing new topics.
_________________________________________________
Beginner Excel Processing using Python

Office Scenario: You are tasked to perform some data analysis using your company's sales data collected for a period of time. Apparently, marketing is interested in understanding customer purchase patterns to answer questions like how many customer have purchased shoes but not belts, who has purchased shoes, belts and shirts and other similar questions.















  To satisfy the above requirement, just go through the series of short lessons below.
1. OP101 - Python Installation
2. OP102 - Program Logic Formulation
3. OP103 - Read Excel Files using Python
4. OP104 - Using Python Sets
____________________________________________________________________________
Process multiple PDF files and generate a report using Python

Office Scenario: Your finance team requested you to go through archived invoices which are PDF files. Your task is to gather all pertinent invoice information, sum up all invoice amount from all PDFs provided and produce a report.

















 







To satisfy the above requirement, just go through the series of short lessons below.
1. OP101 - Python Installation
2. OP102 - Program Logic Formulation
3. OP105 - Read PDF Files using Python
4. OP106 - Generate report from multiple PDF files extract


_______________________________________________________________
Create and train your own office personal assistant

Office Scenario: You are the go-to employee in the office. You are constantly interrupted with questions from colleagues during office hours and you are so kind you do not say no. =) A chatbot can be a right fit for you. 






  To satisfy the above requirement, just go through the lesson below.
  OP107 - Create and train your own office assistant