Outline
1. Fundamentals of PYTHON 1
1.1 Create and run a program
1.2 int, str, float, print()
1.3 Import - os, sys
Exercise: Program Development Assignment
2. Fundamentals of PYTHON 2
2.1 File operations
2.2 for, if/elif/else, lists, sys.argv
2.3 try, except
Exercise: Program Development Assignment
3. OPENPYXL
3.1 pip install, while
3.2 xlsx - open, create, read, write, save
3.3 chart, sys.argv, tkinter
Exercise: Program Development Assignment
4. PANDAS
4.1 pandas dataframe
4.2 load dataframe, output to xlsx
4.3 add, drop, columns, rows, analysis
Exercise: Program Development Assignment
5. Participant USE CASE - PART 1
5.1 Designing simple, maintainable scripts
5.2 Writing pseudo-code, functions, logical steps
5.3 Package installation, functions
Exercise: Program Development Assignment
6. Participant USE CASE - PART 2
6.1 Types of inputs
6.2 File-based, URL-based, API-based, SQL-based
6.3 Example of invoking an API
Exercise: Program Development Assignment
7. Participant USE CASE - PART 3
7.1 Analysis using python and/or pandas
7.2 Package specific implementations
7.3 Pros and Cons of approaches
Exercise: Program Development Assignment
8. Participant USE CASE - PART 4
8.1 Output the analysis from the USE CASE
8.2 Output format
8.3 Output visualizations
Exercise: Program Development Assignment
9. Participant USE CASE - Final Completion
9.1 Participant USE CASE submission
9.2 Participant USE CASE presentation
9.3 Participant USE CASE demonstration
9.4 Feedback and Wrap-up