nyusterndatabootcamp / notebooks

jupyter notebooks for course and book

NYU Stern IPython Notebooks

This repository contains IPython (Jupyter) notebooks associated with the teaching on Data Bootcamp. This repository is organized in the following way:

• book_notebooks
  This folder contains the notebooks which are aligned with the chapters in the book.

• advanced_material
  Contains notebooks with material that we deem as advanced and may or may not be covered at the end of the course.

notebooks's Issues

Elemets to fix in data input notebook (and book)

In the data input notebook @Tinghao724 do the following in the data input notebook:

After the basics, but before the exercises we talk about data input options...

• grabbing specific sheets from multi-sheet excel files
• sperators
• columns
• headings
• skip footer, skip headers
• missing values
• discussion about encoding

For some of this we create simple data sets to illustrate the options. Maybe its one excel file with multiple sheets illustrating the points. Push to dataset folder.

intro to pandas notebook

Todo list for @Tinghao724 the intro pandas section...

• In dataframe section this we have separate section on specifics about columns and index. Talk through what this means
• After basics of dataframe, we have stuff about grabbing columns.
• Then we have discussion about grabbing rows. We talk about two approaches (i) .iloc and relate this as how it is like numpy indexing (also indexes for lists?) and then (ii) Recommended approach is use .set_index with .loc. When discussing set_index, discussion about inplace = true, and reset_index
• Stuff about deleting columns and rows.
• Make sure one or two exercises on .set_index .loc approach Use the pwt_df grab country or year, conditional selection
• Talk about conditional selection

Fix pyfun one notebook

• Create an outline at the top of the notebook emphasizing key stuff we are doing. Could just copy and past stuff from the book.

• Create a warmup to the Jupyter notebook/markdown.

• Clear the cells for the exercises.

• Look through the text and make sure it makes sense. If not, edit as deemed appropriate.

• At end notebook create a summary. Maybe use the stuff from python fundamentals two to do so.

• Swap out (in notebook) objects and methods with dictionaries. Mike will help on edingint this.

• Better separate sections, use "---" to delaminate new area. Make the titling a bit bigger.

intro to pandas notebook

Several things todo:

• Same generic tasks in other notebooks
• In introducing pandas, talk about the two core objects, series and dataframe. Not much space needs to be dedicated to a series, but a connection with numpy array and how it connects with a dataframe is important.
• After basic properites about dataframe, discuss the idea that its a spreadsheet with named rows and columns. How do you grab the columns, talk through that, grab multiple columns, change the name etc. Next, is about the rows. We talk about the index, how it is indexed, how we can change the index. Then how to grab elements/rows from the datafram by using .loc and .iloc Later excercises in computation on a dataframe practice this.
• Understand and describe the axis what it means, how to use it, e.g. sum across rows, how?

Matplotlib

Ok @bzweig we think about how to reorganize the matplotlib chapter. In the archives repository, I have my notebooks that I have used to help this out. Also maybe an outline of types of charts that are common and then code to create.