codebin.org

Untitled

From Mustard Giraffe, 5 Months ago, written in Plain Text, viewed 89 times.
URL http://codebin.org/view/3ada6752 Embed
Download Paste or View Raw
  1. data4_pivot = data4.pivot_table(index=['user_id', 'month'], values=['distance', 'duration', 'name', 'subscription_type'], aggfunc={'distance':'sum', 'duration':'sum', 'name':'count', 'subscription_type' : 'nunique'})
  2. data4_pivot.columns = ['total_distance', 'total_duration', 'trip_count', 'subscription_type']
  3.  
  4.  
  5.  
  6. data4_pivot['total_duration'] = round(data4_pivot['total_duration'], 0)
  7. def money(subscription_type):
  8.     if subscription_type == 'ultra':
  9.         return data4_pivot['total_duration'] * 6 + data4_pivot['subscription_type'].count() * 199
  10.     if subscription_type == 'free':
  11.         return data4_pivot['total_duration']*8 + data4_pivot['subscription_type'].count() * 50
  12. data4_pivot['money'] = data4_pivot['subscription_type'].apply(money)
  13. data4_pivot
  14.  
  15.  
  16.  

Reply to "Untitled"

Here you can reply to the paste above

codebin 2012-∞ | can't stop won't stop