Activity 1.01 – comparing sales data for two stores

ABC Corporation is a retail company with two big stores for grocery and stationery products. The company is planning to create an ambitious marketing campaign next year. As a data analyst, your task is to derive the following insights from the data and relay those insights to the sales team so that they can plan the campaign effectively:

• Which store has greater sales for the quarter?
• Which store has the highest sales for grocery products?
• Which store has the highest sales for March?
• For how many days were the sales of stationery products greater in store 1 than in store 2?

In this activity, you will create the datasets for the two stores and use all the methods you have learned so far to answer the preceding questions. The following steps will help you complete this activity:

1. Open a new Jupyter notebook.
2. Load the data that corresponds to the two stores (Store1.csv and Store2.csv). These datasets are available in this book's GitHub repository at https://github.com/PacktWorkshops/The-Pandas-Workshop/tree/master/Chapter01/Datasets.
3. Use the different methods you have learned about in this chapter to answer the questions.
4. Print the resulting DataFrames. Note that the DataFrames you create should be in the following format:

Figure 1.63 – Final output

With that, we have covered everything you need to know to get started with pandas.

Note

You can find the solution for this activity in the Appendix.