import pandas as pd data = pd.read_csv ('/datasets/visits.csv', sep='\t') #total_visits = data.shape[0] total_visits = len(data.index) print('Количество заездов:',total_visits)#количество заездов на АЗС total_stations = len(data['id'].unique()) print('Количество АЗС:',total_stations) print(data['date_time'].min(), data['date_time'].max()) data['date_time'] = pd.to_datetime(data['date_time'], format='%Y-%m-%dT%H:%M:%S') total_days = len(pd.DatetimeIndex(data['date_time']).day.unique()) station_visits_per_day = total_visits/total_stations/total_days print('Количество заездов на АЗС в сутки:', station_visits_per_day)