I have many files in my directory of the below format:

name,sex,count
xyz,M,231
abc,F,654
...

i am trying to get the sum of count(3rd coloumn) for all files and store them in a list.

total = []
result = 0
for filename in os.listdir(direc):if filename.endswith('.txt'):file = open(direc + '/' + filename, 'r')for line in file:line = line.strip()name, sex, count = line.split(',')if sex == 'F':result += int(count)total.append(result)

Any tips as to why my code doesn't work?

trying to get:

[sum(file1), sum(file2)...]

EDIT:

INPUT :

file1:
xyz,M,231
abc,F,654file2:
wee,M,231
pol,F,654
bgt,M,434
der,F,543file3:
wer,F,432
uio,M,124
poy,F,783

Here's code that works with the absolute bare minimum of modifications (that is, no style fixes were made):

total = []
for filename in os.listdir(direc):result = 0if filename.endswith('.txt'):file = open(direc + '/' + filename, 'r')for line in file:line = line.strip()try:name, sex, count = line.split(',')except ValueError:continueif sex == 'F':result += int(count)total.append(result)

The following had to be fixed:

1. The result variable was set to zero only once, not once per file, so each new file read kept adding to the previous file's total. By my understanding you are trying to add the result from each file to the total list, so I moved this line to make that variable have the correct result.
2. The line name, sex, count = line.split(',') is very fragile, whenever a line has a line without 2 commas in it (including the closing newlines), it would throw an error. I wrapped it in a try…except block that catches these errors and moves on to the next line when needed.
3. The result was appended to the total list on every line read, not per file.

If I misinterpreted your intentions and you just wanted to keep a running total in the total variable for reference, you only need to make modification #2.