Untitled

From Sole Crow, 1 Year ago, written in Plain Text, viewed 479 times.
URL http://codebin.org/view/aa7adef4 Embed
Download Paste or View Raw
  1. import pandas as pd
  2.  
  3. # напишите ваш код здесь
  4. users_data = pd.read_csv('users_data.csv')
  5.  
  6. users_data['session_start_ts'] = pd.to_datetime(users_data['session_start_ts'])
  7. users_data['session_end_ts'] = pd.to_datetime(users_data['session_end_ts'])
  8.  
  9. users_data['session_year'] = users_data['session_start_ts'].dt.year
  10. users_data['session_month'] = users_data['session_start_ts'].dt.month
  11. users_data['session_week'] = users_data['session_start_ts'].dt.isocalendar().week
  12. users_data['session_date'] = users_data['session_start_ts'].dt.date
  13.  
  14. mau_total = (
  15.     users_data.groupby(['session_year', 'session_month']).agg({'id' : 'nunique'}).mean()
  16.  
  17. )
  18.  
  19. print(int(mau_total))

Replies to Untitled rss

Title Name Language When
Re: Untitled Sharp Mockingbird text 2 Months ago.

Reply to "Untitled"

Here you can reply to the paste above