Chapter 3 using SQL: where does dataset come from?

[maggomor]

In Chapter 3 of the book for learning how to access Postgres from within Python with SQL language, we frequently use a table called "yen_tbl". I have no clue how to find this one though? It does not seem to be given in the datasets-section of the repo?

[tatwan]

Hi @maggomor,

Chapters 3 and 5 do not have a Dataset folder on GitHub. Both chapters deal with databases. For Ch3 specifically, data was not included to avoid issues with readers who may not know how to upload such files into their database given the variety of installation options (some readers would install the DB locally, some as a Docker container, while others use a SaaS/Cloud service instead).

The goal of Ch3 was to introduce the technique to read data from these databases into a pandas DataFrame for further analysis. Any data can be used to follow along.

What I will do, is generate the datasets used in Ch3 and upload them as CSV files. Possibly, maybe as INSERT statements as well (SQL Script).

I will update this ticket once this is done. Thank you for the feedback.