Understand the idea
A column list defines both what survives and where it appears. Assign that selection to df to keep the new layout.
A small example
From name, age, weight: selecting ["weight", "name"] removes age and places weight first.
Follow the code
Apply the idea to the supplied table. Read from top to bottom; the final line displays the result.
df = df[["candy", "rating", "price"]]
dfWhat each part does
df[["candy", "rating", "price"]]- Keep exactly these three columns in the listed order.
inner [ ]- Make a list of column names; the outer brackets select from df.
df =- Store the smaller table under the name df.
Your inputs
The editable setup on the right creates df. Run executes the setup and your work from top to bottom.
| candy | flavour | price | rating | shelf |
|---|---|---|---|---|
| Gummy Bear | fruity | 1.2 | 4.1 | A |
| Choco Pop | chocolate | 2.1 | 4.6 | B |
| Mint Bite | mint | 1.5 | 3.8 | A |
| Berry Loop | fruity | 2.8 | 4.4 | B |
| Cocoa Cube | chocolate | 3.4 | 4.9 | A |
| Lemon Drop | fruity | 1.8 | 4 | B |
Your task · Follow
- Keep only candy, rating and price, in that order, in df.
- Keep the changes in df and display it.
Hint
Selecting columns also changes their order; keep all fields requested by the handoff.
Reveal solution
One way to do it. Keep any supplied setup in the editor and use this in the Your work section.
df = df[["candy", "rating", "price"]]
df