pandas/unstack-without-fill
| Rule | unstack-without-fill |
|---|---|
| Pack | pandas |
| Severity | warning |
| Fix | unsafe, with xpd check --fix --unsafe-fixes |
| Library versions | every version |
After unstack, a pair without rows becomes a missing value, which turns int64 counts into float64. Pass fill_value=0, which keeps the counts int64.
table = df.groupby(["city", "grade"]).size().unstack()table = df.groupby(["city", "grade"]).size().unstack(fill_value=0)What the rule reports
Section titled “What the rule reports”The rule reports unstack right after size, count, value_counts or nunique without fill_value. A pair without rows comes back as a missing value, and the table shows the dtype of the counts.
| Call | Cell of a pair without rows | Dtype of the counts |
|---|---|---|
unstack() |
missing value | float64 |
unstack(fill_value=0) |
0 | int64 |
The fix is unsafe, because a mean over the cells changes when the missing values become 0. The rule leaves an unstack with more than one argument alone.
How to fix it
Section titled “How to fix it”xpd check --fix --unsafe-fixes applies the fixes of this rule. Check the result, because an unsafe fix can change what the code does.
The unsafe fix writes fill_value=0.
Message
Section titled “Message”xpd prints this message with the issue. A name that starts with $ stands for code from your file.
A pair without rows comes back as a missing value, which turns the int64 counts into float64. The count of such a pair is 0. Pass fill_value=0, which kept the columns int64.Browse the other rules of the pandas pack.