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
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
mutateinstead ofassign. In the reading tutorial, we both create a new column and filter the data. This means that it now matters which line callsexecuteto create the pandas dataframe from the database, since students have to do that before getting access toassign. 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