course | date | wk no. | session links | learning objectives | out-of-class work |
---|---|---|---|---|---|
DAT-129 | Wed 3-FEB-2021 |
1 |
Intro to course and data structure exerciseIcon project OverviewIcon project Overview |
|
|
DAT-129 | Wed 10-FEB-2021 |
2 |
SP'21 Session Recordingsgit essentails |
Implement code modularity suggestions in a peer's project |
|
DAT-129 | Wed 17-FEB-2021 |
3 |
Session RecordingFile i/o, JSON, and gitBook resources (Dietel)
|
Process a csv and compute summary statsEither building on Eric's sample with TRI Water or your own chosen CSV/tabular data set, identify a inquiry question and write a python script to iterate over each record, assembling data bits in a master data container of your own design. Prepare a somewhat clean output of your tabulations which relate to your inquiry question. Prepare to share in small groups next week. |
|
DAT-129 | Wed 24-FEB-2021 |
4 |
Session RecordingQuery spec building in JSON; advanced gitDeitel textbook: Chapter 9, special focus on 9.5 |
Clone, push to, pull from, and make pull requests to remote git repos Encode and decode JSON files in Python |
Document and Clean up workTake the week to clean up your Icon and CSV processing files and create markdown readme files to share your screen shots of the programs working with the world! |
DAT-129 | Wed 3-MAR-2021 |
5 |
Application programming interfaces 1 |
Encode a query in a URL and demonstrate its use by making a URL-encoded query against a remote API compouter Write python to make HTTP requests using the requests library |
|
DAT-129 | Wed 10-MAR-2021 |
6 |
Session RecordingApplication programming interfaces 2Prepare peer tutorial for next week |
Prepare peer tutorials |
|
DAT-129 | Wed 17-MAR-2021 |
7 |
Undertake peer teaching
|
Continue Peer ChallengesChoose one of your peer topics to test on your own by baking in one of the peer topics into an existing python project you've made so far. Wrap-up API proj
|
|
DAT-129 | Wed 24-MAR-2021 |
8 |
Share API Mini-Projects and implement peer teaching topicMop up peer teachingIf you didn't get a chance to share your peer lesson last week, please target to share this week. |
Tidy up and fully-bake API project for "formal" sharing next week before Scraping soup madness! Implement peer topic in your API projecect and push to gitChoose a topic presented by one of your peers (not your own) and make use of niftiness in your API project. Log the topic you implemented, notes about how and why you did so, and a link to a git repo that contains a pushed version of your code whose commit message contains the text "peer topic". Log your work in the sky-blue sheet/tab of the tracker spreadsheet called "API_implement_peer_topic" |
|
DAT-129 | Wed 31-APR-2021 |
- |
Spring Break! |
||
DAT-129 | Wed 7-APR-2021 |
9 |
Web fundamentals & scraping |
Use beautifulsoup4 to extract basic data from a website's HTML |
|
DAT-129 | Wed 14-APR-2021 |
10 |
Session RecordingWeb scraping project fleshout |
|
|
DAT-129 | Wed 21-APR-2021 |
11 |
RecordingsDatabase interactivity |
Practice DB inserts & selectsChoose a data source, either a CSV related to your project or from your API calls: create a table of appropriate column types, write inserts to store the data, and demonstrate that you can extract data with the cursor.extractall() function. Enjoy |
|
DAT-129 | Wed 28-APR-2020 |
12 |
Session RecordingMop Up DatabasesFinal project |
Begin your final projectMake an entry in our master tracker spreadsheet |
|
DAT-129 | Wed 5-MAY-2021 |
13 |
OS & file tree traversalsVisualization with matplotlibFinal project design |
Fully bake final project and prepare for sharingSee sample git repo with screen shots and conclusions written in markdown Use our master markdown tutorial to create a readme.md |
|
DAT-129 | Wed 12-MAY-2021 |
14 |
Session RecordingEric will have Office Hours starting at 1700h/5:00pmRest of group will start at 7:00 pm!
|
|