I Have column "Counts" that has a true false count and I want to get just the counts of the True values
SubmitDate_NoTime ResolvedDate_NoTime Count
0 2021-01-01 2021-01-03 0 True 1 True 2 True 3 Fals...
1 2021-01-01 2021-01-02 0 True 1 True 2 True 3 Fals...
2 2021-01-01 2021-01-06 0 True 1 True 2 True 3 Fals..
This is an example of one row list each row has a list similar to this.
0 True
1 True
2 True
3 False
4 False
5 False
6 False
7 False
8 False
9 False
10 False
11 False
12 False
13 False
14 False
15 False
16 False
17 False
18 False
19 False
20 False
I have tried
df['Counts'] = tickets['Counts'].sum()
df['Counts'] = df[df['Counts']==True].count().sum()
Neither have worked
I want the df to look like df['Counts'][1] = 3 in this case.