import pandas as pd

# Reading the dataset
df = pd.read_excel('/content/Regina Gas Stations.xlsx')
df

print(df.to_string())

df = df.drop(0)
df

df.info()

# This is to check if any white space is appended to the column names
print(df.columns.tolist())

print(df['Location'].value_counts())

Location_count = df.groupby("Location")["Name"].count()
Location_count

Location_count.plot.bar(stacked=True, figsize = (15, 4))