Nov-06-2022, 12:04 AM
It worked, thanks for the guidance.
Was there another way I could have done this?
[('John', 2), ('Jan', 2), ('Paul', 2), ('Scott', 2), ('Kylie', 1), ('Jason', 1)]
Also is there anyway of listing the names up/down rather than left/right..
Thanks
Was there another way I could have done this?
import pandas as pd import os party = pd.read_csv('party.csv') data = party['ATTENDEES'] list = data.str.cat(sep=',').strip().split(',') print(Counter(list).most_common())Output:
[('John', 2), ('Jan', 2), ('Paul', 2), ('Scott', 2), ('Kylie', 1), ('Jason', 1)]
Also is there anyway of listing the names up/down rather than left/right..
Thanks