Elemets to fix in data input notebook (and book)

[mwaugh0328]

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...

• [x] grabbing specific sheets from multi-sheet excel files
• [x] sperators
• [x] columns
• [x] headings
• [x] skip footer, skip headers
• [x] missing values
• [x] 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.

[Tinghao724]

The tasks regarding the notebooks are finished with the following two details to be decided:

1) how do we want the students to read the data? 2) do we want to include multiple separators in one csv file? It could be accomplished and I have found a way. But now, for simplicity, I did not include.

We can discuss them in week meeting.

[Tinghao724]

@mwaugh0328

Regarding the way to find path in mac, can we use the "Create a “Copy Path” Service for the Right-Click Menu" in this linkJust a few steps.

But once we do this, life will be much easier. It also gives mac students additional benefits. If confirmed, I will write the corresponding steps in the book.

Regarding the outside datasets links in the book, the majority of them are broken but luckily, I successfully found all of them and updated the corresponding descriptions if original they have.

[Tinghao724]

@mwaugh0328

Additionally, I fixed the issues in data api notebook as well and updating several parts, would you please take a look? Thanks!