Installation
- Install Python for Windows
- Add Python to Environment Variables (Checked)
- Install VSCode for Windows
- From Extensions, install the following:
- Python
- Jupyter
- From Extensions, install the following:
Setup
- Create a Working Directory (Documents > FOQA)
- Open Working Directory from VSCode
- File > Open Folder > Select Folder
- If prompted, Trust the folder
- Download pySara from Teams > FOQA > Files > Python > pysara.zip and extract to your new working directory
- From the pysara folder extracted to your working directory, double click on Getting Started.ipynb. It should open in VSCode
- To install required libraries:
- Terminal menu > New Terminal
- pip install pandas seaborn numpy requests plotly
Jupyter Introduction
- Cell Types: Code and Markup
- Shortcuts (hit escape to enter command mode)
- Shift Enter: Execute Cell
- A: Add Cell Above
- B: Add Cell Below
- DD: Delete Cell
- F: Find/Find and Replace
- Enter: Enter edit mode
- Markdown
- Headers
- Lists
Python Introduction
- Good Tutorial
- Open https://github.com/jvdkwast/Python3_Jupyter_Notebook
- Click Code > Download ZIP
- Download to your working directory and Extract
- Double click on PythonIntro.ipynb
- Python Runthrough
- imports & libraries
- Variables (numbers, strings, lists, tuples, dictionaries, objects)
- functions
- looping
- if, elif, else
Pandas and Data Manipulation
- Pivot Tables