Recitation Notes

Notes: 1. please visit this page frequently, as it will be updated constantly during the term
2. Items under Required Material are considered mandatory reading and will be tested in the exams.
3. Items under Additional Material should be useful in helping you understand the Required Material.
4. Items in the third column (Online Resources and Reference Books) are provided for reference and in order to help you explore the different topics further.
5. Links to O'Reilly's Safari Online Bookshelf are only available within pitt.edu or from outside pitt.edu using the University's VPN service (https://sremote.pitt.edu). Please remember to sign out once you finished reading -- the University has a very limited number of concurrent user licenses.

Shortcuts:

11: [Rec 11] Cypher+Neo4j+Python (Apr 19)
Required Reading
(11) recitation11.ipynb
(11) recitation11.py
(11) recitation11.pdf
(11) recitation11_solution.ipynb
Additional Material
(11) Setup Neo4j Linux
(11) Setup Neo4j Windows
(11) cypher_sample1.py
Online Resources
Neo4j Community Edition
Movie Database
Reference Books

10: [Rec 10] SQL via Data API (Apr 4)
Required Reading
(10) recitation10.ipynb
(10) recitation10.py
(10) recitation10.pdf
(10) recitation10_solution.ipynb
Additional Material
(10) attribs.png
Online Resources
Reference Books

09: [Rec 09] SQL in Python (Mar 22)
Required Reading
(09) recitation9.ipynb
(09) recitation9.py
(09) recitation9.pdf
(09) recitation9_solution.ipynb
Additional Material
Online Resources
Reference Books

08: [Rec 08] Advanced SQL (Mar 15)
Required Reading
(08) recitation8.pdf
(08) recitation8_solution.pdf
Additional Material
Online Resources
Reference Books

07: [Rec 07] Regression and Decision Trees (Mar 1)
Required Reading
(07) recitation7.ipynb
(07) recitation7.py
(07) recitation7.pdf
(07) recitation7_solution.ipynb
Additional Material
(07) bike_share.csv
(07) titanic.csv
(07) bank-data.csv
Online Resources
Reference Books

06: [Rec 06] Collaborative Filtering and Similarity Metrics (Feb 15)
Required Reading
(06) recitation6.ipynb
(06) recitation6.py
(06) recitation6.pdf
(06) recitation6_solution.ipynb
Additional Material
(06) movies_example.csv
(06) movie_class_responses.csv
Online Resources
Reference Books

05: [Rec 05] Data Analysis with Pandas (Feb 8)
Required Reading
(05) recitation5.ipynb
(05) recitation5.py
(05) recitation5.pdf
(05) recitation5_solution.ipynb
Additional Material
(05) bank-data.csv
(05) coffee-chain.csv
Online Resources
Reference Books

04: [Rec 04] Clustering (Feb 1)
Required Reading
(04) recitation4.ipynb
(04) recitation4.py
(04) recitation4.pdf
(04) recitation4_solution.ipynb
Additional Material
(04) crime_data.csv
(04) protein.csv
Online Resources
Reference Books

03: [Rec 03] Data Mining (Jan 25)
Required Reading
(03) handout
(03) solutions
Additional Material
Online Resources
Reference Books

02: [Rec 02] Python 2 (Jan 18)
Required Reading
(02) recitation2.ipynb
(02) recitation2.py
(02) recitation2.pdf
(02) recitation2_solution.ipynb
Additional Material
(02) top12cities.csv
Online Resources
Jupyter Notebook
» How to install
» Download Anaconda

pandas

pandas tutorial

pandas DataFrames tutorial

matplotlib

Reference Books

01: [Rec 01] Python 1 (Jan 11)
Required Reading
(01) Python Setup Info
(01) Handout
Additional Material
(01) Sample hours.json file
(01) Sample Python Code
(01) example1.txt
(01) Sample Python Code (Solutions)
Online Resources
Reference Books