Advertisement
Guest User

Untitled

a guest
Mar 30th, 2020
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. import pandas as pd
  2. data = pd.read_csv ('/datasets/visits.csv', sep='\t')
  3. total_visits = len(data)
  4. print("Количество заездов:", total_visits)
  5. total_stations = len(data['id'].unique())
  6. print('Количество АЗС:', total_stations)
  7. print(data['date_time'].min(), data['date_time'].max())
  8. total_days = 7
  9. station_visits_per_day = (total_visits / total_stations) / total_days
  10. print('Количество заездов на АЗС в сутки:', station_visits_per_day)
  11. print(data['name'].value_counts())
  12. print(data.sort_values(by = 'name', ascending=False).head(10))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement