Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- data = pd.read_csv ('/datasets/visits.csv', sep='\t')
- total_visits = len(data) #количество заездов на АЗС
- print('Количество заездов:', total_visits)
- total_stations = len(data['id'].unique())
- print('Количество АЗС:', total_stations)
- print(min(data['date_time']), max(data['date_time']))
- total_days = pd.to_datetime(max(data['date_time'])).day - pd.to_datetime(min(data['date_time'])).day + 1
- station_visits_per_day = total_visits / (total_days * total_stations)
- print('Количество заездов на АЗС в сутки:', station_visits_per_day)
- print(data['name'].value_counts().head(10))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement