Advertisement
maresin

Untitled

Nov 20th, 2022
638
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.67 KB | Source Code | 0 0
  1. import pandas as pd
  2.  
  3. data = pd.read_csv ('/datasets/visits.csv', sep='\t')
  4. total_visits = len(data) #количество заездов на АЗС
  5. print('Количество заездов:', total_visits)
  6. total_stations = len(data['id'].unique())
  7. print('Количество АЗС:', total_stations)
  8. print(min(data['date_time']), max(data['date_time']))
  9. total_days = pd.to_datetime(max(data['date_time'])).day - pd.to_datetime(min(data['date_time'])).day + 1
  10. station_visits_per_day = total_visits / (total_days * total_stations)
  11. print('Количество заездов на АЗС в сутки:', station_visits_per_day)
  12. print(data['name'].value_counts().head(10))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement