Open
Description
Currently, in the textbook we show how to filter data using Ibis, but we don't show how to create new columns. Filtering the data looks the same as in pandas, but creating a new columns uses mutate
instead of assign
. In the reading tutorial, we both create a new column and filter the data. This means that it now matters which line calls execute
to create the pandas dataframe from the database, since students have to do that before getting access to assign
. We are solving this now by calling execute up front, but this is teaching students a bad habit since it creates an unnecessarily big data frame and negates many of the benefits with working with a database and ibis. Also see https://github.ubc.ca/UBC-DSCI/dsci-100-instructor/issues/836