pandas/lambda-in-assign
| Rule | lambda-in-assign |
|---|---|
| Pack | pandas |
| Severity | info, and warning with style = "strict". A rule of the house style |
| Fix | safe, with xpd check --fix |
| Library versions | pandas 3.0 and later |
A lambda that only reads columns, as in assign(b=lambda d: d["a"] * 2), hides a simple expression. On pandas 3.1 and later write it with pd.col, which gave an equal frame.
df = df.assign(total=lambda d: d["price"] * d["units"])df = df.assign(total=pd.col("price") * pd.col("units"))What the rule reports
Section titled “What the rule reports”The rule reports a lambda in df.assign(name=lambda d: d["a"] * 2), df.loc[lambda d: d["a"] > 2] and df[lambda d: d["a"] > 2] that reads its frame only as d["name"]. On pandas 3.1.1, pd.col gave an equal frame for each kind of lambda body that the rule reports, as the table shows.
| Lambda body | Reported |
|---|---|
arithmetic, a comparison, a mask operator such as & or ~, a method, a reduction, or the str accessor |
yes |
a method that takes another column, or an earlier keyword of the same assign |
yes |
| a column of a frame renamed earlier in the chain | yes |
the frame used in another way, as in d.a or len(d) |
no |
a column passed to a function, as in f(d["a"]) |
no |
another frame read by name, as in other["x"] |
no |
How to fix it
Section titled “How to fix it”xpd check --fix applies the fix of this rule.
The safe fix writes pd.col("a") * 2. The rule runs on pandas 3.0 and later.
Message
Section titled “Message”xpd prints this message with the issue. A name that starts with $ stands for code from your file.
pd.col names a column without a lambda, so the expression reads as what it computes. Write $NEW, which gave an equal frame.Browse the other rules of the pandas pack.