pandas/stack-then-reset-index
| Rule | stack-then-reset-index |
|---|---|
| Pack | pandas |
| Severity | info |
| Fix | none, edit by hand |
| Library versions | every version |
stack().reset_index() gives a long frame with columns named level_1 and 0. Use melt, which names the columns and was 2.9 times faster.
long = df.set_index("id").stack().reset_index()long = df.melt(id_vars="id", var_name="year", value_name="sales")What the rule reports
Section titled “What the rule reports”The rule reports df.set_index(keys).stack().reset_index(), which builds a long frame whose new columns are named level_1 and 0. On 100,000 rows with 20 columns, melt gave the same values and ran 2.9 times faster. The table shows where the two results differ.
| What differs | stack().reset_index() |
melt |
|---|---|---|
| Names of the new columns | level_1 and 0 |
variable and value, or the names passed to melt |
| Order of the values | row by row | column by column |
How to fix it
Section titled “How to fix it”xpd has no automatic fix, so make the change by hand.
Message
Section titled “Message”xpd prints this message with the issue. A name that starts with $ stands for code from your file.
This builds a long frame whose new columns are named level_1 and 0. melt names them, as in $X.melt(id_vars=$K, var_name="year", value_name="sales"), and ran 2.9 times faster. It lists the values column by column, where stack lists them row by row.Browse the other rules of the pandas pack.