Advertisement
Venciity

Untitled

Nov 19th, 2019
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.40 KB | None | 0 0
  1. data = [["X1", "X1", "X1", "X1"],
  2.         ["X1", "X2", "X3", "X4"],
  3.         ["X1", "X1", "X2", "X2"],
  4.         ["X3", "X3", "X3", "X2"],
  5.         ["X2", "X2", "X3", "X4"],
  6.         ["X1", "X1", "X1", "X3"],
  7.         ["X2", "X2", "X1", "X1"]]
  8.  
  9. df = pd.DataFrame(data)
  10. print(df)
  11.  
  12. mode = df.mode(axis=1)
  13. print(mode)
  14.  
  15. df['majority'] = np.where(mode.isna().sum(axis=1).isin([0, 2]), 'split', mode[0])
  16. df
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement