Downloading and Cleaning BAX Data

Correction

Replace the code

asset2Ask.loc[~((asset2Ask>98.5) & (asset2Ask['2017-06-01':'2018-03-01'])].plot()

with

asset2Ask.loc[~((asset2Ask>98.5) & (asset2Ask.index.isin(asset2Ask['2017-06-01':'2018-03-01'].index)))].plot()

The former used to work when I film the video. That video was filmed in April 2020. It doesn't now, it might have something to do with a Python update since then.

Explanation of new code

Explanation of the new code can be found in Appendix 1 of the "Download BAX Data (Complete)" Jupyter Notebook.

---

Note 1: The BAX data only starts from the year 2017 even though we indicated 2000.

This either because 1) Quandl doesn't have the data or 2) it doesn't exist.

In this case we believe it is the latter.

Note 2: We did some basic data cleaning here. We will cover data cleaning principles in a later chapter.

Complete and Continue