Leadership wants a quick comparison of the two store formats.
Join sales.csv to stores.csv, and store one row per store_format with these columns:
sales: the number of sale rowsunits: total unitsrevenue: total of units * unit_price, rounded to 2 decimalsExpected answer
Store your answer in result.
Hints, the later steps and the answer come with Pro.
import pandas as pd
sales = pd.read_csv("sales.csv")
stores = pd.read_csv("stores.csv")
result = ...