Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. df = pd.DataFrame.from_csv(r"append_test.txt", sep='\t')
  4.  
  5. frames = []
  6. for meeting in range(len(df.T)): # iterate over recorded attendances
  7. attendees = df[df.T.iloc[meeting] == 1].index # get attendees for specific meeting
  8. frames.append(pd.DataFrame(index=attendees, columns=attendees).fillna(1)) # create frame from attendees
  9.  
  10. # sum up jointly attended meetings
  11. pd.concat(frames).fillna(0).groupby(level=0).sum().to_csv(r"jointly_attended.txt", sep='\t')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement