text_html_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

df = pd.read_csv('../input/supermarket-sales/supermarket_sales - Sheet1.csv')

df.isnull().sum()

customertype_x_city = df.groupby('City')['Customer type'].value_counts()
customertype_x_city

best_payment_x_city = df.groupby('City')['Payment'].value_counts()
best_payment_x_city