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:

12: [Rec 12] SQL to Neo4j (Dec 9)
Required Reading
(12) rec12.pdf
(12) alldata.zip
Additional Material
Online Resources
Reference Books

11: [Rec 11] Python+Neo4j (Dec 2)
Required Reading
(11) Installation.Setup.Neo4j.pdf
(11) cypher_sample1.py
Additional Material
Online Resources
https://neo4j.com/download/community-edition/

https://neo4j.com/developer/movie-database/

Reference Books

10: [Rec 10] XML / XPath / XQuery (Nov 18)
Required Reading
(10) recitation10_questions.pdf

(10) recitation10_part1.xml
(10) recitation10_part2a.xml
(10) recitation10_part2b.xml

(10) recitation10.xquery
(10) recitation10_solution.pdf

Additional Material
Online Resources
Reference Books

09: [Rec 09] Python+SQL+REST (Nov 11)
Required Reading
(09) recitation9.pdf
(09) recitation9.ipynb (Jupyter Notebook)
(09) recitation9.py
Additional Material
Online Resources
Food Facility Violations
Reference Books

08: [Rec 08] SQL (Nov 4)
Required Reading
(08) recitation8.pdf
Additional Material
Online Resources
SQLite Python tutorial
Reference Books

07: [Rec 07] Python and SQL (Oct 28)
Required Reading
(07) recitation7.pdf
(07) recitation7.ipynb (Jupyter Notebook)
(07) recitation7.py
Additional Material
Online Resources
SQLite Python tutorial
Reference Books

06: [Rec 06] Python 6 (Oct 14)
Required Reading
(06) recitation6.pdf
(06) recitation6.ipynb (Jupyter Notebook)
(06) recitation6.py
Additional Material
(06) bike_share.csv
(06) titanic.csv
(06) bank-data.csv
Online Resources
Reference Books

05: [Rec 05] Python 5 (Oct 7)
Required Reading
(05) recitation5.pdf
(05) recitation5.ipynb (Jupyter Notebook)
(05) recitation5.py
Additional Material
(05) coffee-chain.csv
(05) bank-data.csv
Online Resources
Reference Books

04: [Rec 04] Python 4 (Sep 30)
Required Reading
(04) recitation4.pdf
(04) recitation4.ipynb (Jupyter Notebook)
(04) recitation4.py
Additional Material
(04) movies_example.csv
(04) movie_class_responses.csv
Online Resources
Reference Books

03: [Rec 03] Python 3 (Sep 23)
Required Reading
(03) recitation3.pdf
(03) recitation3.ipynb (Jupyter Notebook)
(03) recitation3.py
Additional Material
(03) crime_data.csv
(03) protein.csv
Online Resources
NumPy

scikit-learn
» scikit-learn/Clustering

Reference Books

02: [Rec 02] Python 2 (Sep 16)
Required Reading
(02) recitation2.pdf
(02) recitation2.ipynb (Jupyter Notebook)
(02) recitation2.py
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 (Sep 9)
Required Reading
(01) Python Setup Info
(01) Handout
Additional Material
(01) Sample Python Code
(01) task_input.txt
(01) example1.txt
Online Resources
Reference Books