Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- database = pd.read_csv(input(), sep='\t')
- database = database[database["wall_emoji_trace"].notnull()]
- database["wall_emoji_counter"] = database["wall_emoji_trace"].str.len()
- database["full_name"] = database["first_name"] + " " + database["last_name"]
- quantile_border = database["wall_emoji_counter"].quantile(0.95)
- quantile_data = database.loc[database["wall_emoji_counter"] >= quantile_border, ["full_name", "wall_emoji_counter"]]
- sorted_data = quantile_data.sort_values(["wall_emoji_counter", "full_name"], ascending=[False, True])
- for full_name in sorted_data['full_name']:
- print(full_name)
Advertisement
Add Comment
Please, Sign In to add comment