import pandas as pd

data = pd.read_csv('/datasets/visits_eng.csv', sep='t')
total_visits = data.shape[0]
print('Number of visits:', total_visits) 
total_stations = len(data['id'].unique())
print('Number of gas stations:', total_stations)
print(data["date_time"].min(), data["date_time"].max()) 
total_days = 7
station_visits_per_day = total_visits / total_stations / total_days  
print('Number of visits per gas station per day:', station_visits_per_day)

new_data=[]
new_data['name']=data['name'].unique()
new_data['visits']=data['name'].value_counts()

print(new_data.sort_values('visits', ascending=False).head(10))