You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
util_constant_for_children_party_shopping_tour,Constant for Children Party/ Shopping Tour,@(df.purpose1==5)*(df.party1==2)+(df.purpose2==5)*(df.party2==2),coef_constant_for_children_party_shopping_tour
This expression is summarized as (bool * bool) + (bool * bool). The two parenthetical terms each neatly and correctly resolves to a binary value regardless of whether the operands are treated as literal boolean values or their (0,1) numerical equivalent. However, + operator is not so clean; if both operands are True, we could arrive at different results:
Interpret as numeric, so1 + 1 = 2, or
Interpret as boolean, so True + True = True.
The numexpr engine of pandas.eval will (with arguably good reason) punt on solving this, throwing a NotImplementedError. Pandas can fall back to numpy logic, which will solve the expression based on the logic (2) and get True. Sharrow converts the booleans to numbers, using logic (1).
It would be better to write expressions so they are less ambiguous, and (obviously) so they resolve the same with or without sharrow. Based on context clues from the rest of the spec, it appears the intention of these expressions is following logic (1). @dhensle can you (or whomever at RSG crafted this spec) confirm the preferred interpretation?
The text was updated successfully, but these errors were encountered:
I can answer this since I worked on the initial conversion of joint tour frequency composition model.
This is what's coded in the BayDAG CT-RAMP UEC for the joint tour frequency composition model:
In CT-RAMP, expressions are returned in numeric. A==B returns either numeric 1 or 0, which means this expression should return 0, 1, or 2.
So this expression should be rewritten to follow logic (1).
@dhensle do you agree? If we correct the expressions, it will cause abm3 results to change in the sharrow off mode, perhaps slightly, depending on how many 2+ joint tour households are there.
In the joint tour frequency and composition component, we have (for example):
sandag-abm3-example/configs/resident/joint_tour_frequency_composition.csv
Line 56 in 85c1ecb
This expression is summarized as
(bool * bool) + (bool * bool)
. The two parenthetical terms each neatly and correctly resolves to a binary value regardless of whether the operands are treated as literal boolean values or their (0,1) numerical equivalent. However,+
operator is not so clean; if both operands areTrue
, we could arrive at different results:1 + 1 = 2
, orTrue + True = True
.The
numexpr
engine ofpandas.eval
will (with arguably good reason) punt on solving this, throwing aNotImplementedError
. Pandas can fall back to numpy logic, which will solve the expression based on the logic (2) and getTrue
. Sharrow converts the booleans to numbers, using logic (1).It would be better to write expressions so they are less ambiguous, and (obviously) so they resolve the same with or without sharrow. Based on context clues from the rest of the spec, it appears the intention of these expressions is following logic (1). @dhensle can you (or whomever at RSG crafted this spec) confirm the preferred interpretation?
The text was updated successfully, but these errors were encountered: