Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.36 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. def fun():
  4.     raw_data = pd.read_csv("result_total_ret.csv").dropna()
  5.     data = []
  6.     for date in raw_data['DataDate'].unique():
  7.         df = raw_data[raw_data['DataDate'] == date].sort_values(by = ['trt1y'], ascending=[False])
  8.         new_elem = {
  9.             'winners': df[:len(df)//10],
  10.             'losers': df[len(df)//10:]
  11.         }
  12.         data.append(new_elem)
  13.     return data
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement