列表的问题＆＃x2026;

Question

我是Python的新手，我需要访问文件夹中的CSV文件。这不是问题：

open（'c：\ users \ Directory \ Companies.csv'）

我尝试了以下操作：

from csv import reader
# read csv file as a list of lists
with open('companies.csv', 'r') as read_obj:
# pass the file object to reader() to get the reader object
csv_reader = reader(read_obj)
# Pass reader object to list() to get a list of lists
list_of_rows = list(csv_reader)
print(list_of_rows)

输出

[['Company', 'Departments', 'Employess'],
['A', 'Marketing', '200'],
['B', 'Sales', '300’],
['C', 'HR', '15'],
['D', 'Logistics', '500'],
[‘A’, ‘Admin’, ‘15’],
[‘A’, ‘Research’, ‘30’],
[‘B’, ‘COffice’, ‘150’],
[‘C’, ‘Transporte, ‘200’],
[‘B’, ‘IT’, ‘200’],
[‘B’, ‘Gorg’, ‘12’]]

我无法获得公司“ B”部门总数和包括部门数量的新列表在拥有20多名员工的公司A中。我尝试了一下：

new_list = [x for x in companies if Company = A' and 'Departments' > 20]

def total_elements(companies):
    count = 0
    for element in companies:
        count += 1
    return count

print("the total number is: ", total_elements(new_list))

预先感谢！