Nov-03-2022, 08:20 AM
(This post was last modified: Nov-03-2022, 09:16 PM by Steven5055.)
(Nov-03-2022, 07:32 AM)Larz60+ Wrote: Please show what you have tried, working or not.
import pandas as pd import os party = pd.read_csv('party.csv') CountPeople=party['ATTENDEES'].str.split(pat = ',', expand = True) CountPeople=CountPeople.groupby(0).count() party CountPeopleI've also included an attachment, so you can see the outputs.
Attached Files