Task: Weekly Coffee Sales Report
Swipe to start coding
At CafΓ© Pandasia, the baristas have been keeping track of how many cups of each coffee drink were sold over the past week.
Now, the manager wants to see the data stored in a DataFrame to get a quick overview of performance and use it later for analysis.
Youβve been given the sales numbers for three drinks across five days (Monday to Friday):
| Coffee | Monday | Tuesday | Wednesday | Thursday | Friday |
|---|---|---|---|---|---|
| Espresso | 45 | 38 | 50 | 42 | 55 |
| Latte | 60 | 65 | 62 | 58 | 70 |
| Cappuccino | 30 | 28 | 35 | 40 | 38 |
- Use the Dictionary of Lists method to create a pandas DataFrame with the data given above.
- Set the index list of the DataFrame to be the coffee drink names:
Espresso,LatteandCappuccinorespectively.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 2.7Task: Weekly Coffee Sales Report
Swipe to show menu
Swipe to start coding
At CafΓ© Pandasia, the baristas have been keeping track of how many cups of each coffee drink were sold over the past week.
Now, the manager wants to see the data stored in a DataFrame to get a quick overview of performance and use it later for analysis.
Youβve been given the sales numbers for three drinks across five days (Monday to Friday):
| Coffee | Monday | Tuesday | Wednesday | Thursday | Friday |
|---|---|---|---|---|---|
| Espresso | 45 | 38 | 50 | 42 | 55 |
| Latte | 60 | 65 | 62 | 58 | 70 |
| Cappuccino | 30 | 28 | 35 | 40 | 38 |
- Use the Dictionary of Lists method to create a pandas DataFrame with the data given above.
- Set the index list of the DataFrame to be the coffee drink names:
Espresso,LatteandCappuccinorespectively.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
