mfgnik

Untitled

May 6th, 2020
1,347
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.62 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. database = pd.read_csv(input(), sep='\t')
  4.  
  5. database = database[database["wall_emoji_trace"].notnull()]
  6. database["wall_emoji_counter"] = database["wall_emoji_trace"].str.len()
  7.  
  8. database["full_name"] = database["first_name"] + " " + database["last_name"]
  9.  
  10. quantile_border = database["wall_emoji_counter"].quantile(0.95)
  11. quantile_data = database.loc[database["wall_emoji_counter"] >= quantile_border, ["full_name", "wall_emoji_counter"]]
  12. sorted_data = quantile_data.sort_values(["wall_emoji_counter", "full_name"], ascending=[False, True])
  13.  
  14. for full_name in sorted_data['full_name']:
  15.     print(full_name)
Advertisement
Add Comment
Please, Sign In to add comment