2024-09-29 21:52:18 发布
网友
假设我有一个名为sample.csv的csv文件:
CODE AGE SEX CITY ---- --- --- ---- E101 25 M New York E102 42 F New York E103 31 M Chicago E104 67 F Chicago
我想数一数数据中的男性和女性人数。例如,对于这个问题,答案是:
M : 2 F : 2
我应该从哪里开始,如何编码
>>> import csv >>> M,F = 0,0 >>> with open('file.csv') as csvfile: ... data = csv.reader(csvfile) ... for row in data: ... M += 1 if row[2] == "M" else F += 1
您可以这样做:
import pandas as pd df = pd.read_csv("sample.csv") print(f"M : {len(df[df['SEX'] == 'M'])}") print(f"F : {len(df[df['SEX'] == 'F'])}")
import pandas as pd data = pd.read_csv('sample.csv') num_males = sum(data['SEX'] == 'M') num_females = len(data['SEX']) - num_males
您可以这样做:
相关问题 更多 >
编程相关推荐