Skip to main content
 首页 » 编程设计

python之读取 csv 文件并对特定行执行公式

2025年01月19日9pander-it

我昨晚问了一个类似的问题,但我的教授对她希望如何回答这个问题做了一些澄清,这让我陷入了困境。

我有一个包含 3 列的 csv 文件。我将它们保存为字典,但我试图找到一种方法来读取 year 和 title_field 并找到特定的 title_field(占用的住房单元),将其与最早的年份(2008 年)匹配,并在那些旁边的 value 列中取数字并将其与下一个 year 匹配( 2009) 具有相同的 title_field(占用的住房单元),找到这两个值之间的差异,并打印结果并对 2009 和 2010 等执行相同的操作,如下所示:

2008-2009  795 
2009-2010  5091 
etc. 

csv 看起来像这样:

year,title_field,value 
2014,Total Housing Units,49109 
2014,Vacant Housing Units,2814 
2014,Occupied Housing Units,46295 
2013,Total Housing Units,47888 
2013,Vacant Housing Units,4215 
2013,Occupied Housing Units,43673 
2012,Total Housing Units,45121 
2012,Vacant Housing Units,3013 
2012,Occupied Housing Units,42108 
2011,Total Housing Units,44917 
2011,Vacant Housing Units,4213 
2011,Occupied Housing Units,40704 
2010,Total Housing Units,44642 
2010,Vacant Housing Units,3635 
2010,Occupied Housing Units,41007 
2009,Total Housing Units,39499 
2009,Vacant Housing Units,3583 
2009,Occupied Housing Units,35916 
2008,Total Housing Units,41194 
2008,Vacant Housing Units,4483 
2008,Occupied Housing Units,36711 

我目前的代码是:

import csv 
def process(year, field_name, value): 
    print(year, field_name, value) 
 
with open('denton_housing.csv', 'r', encoding='utf8',newline='') as f: 
    reader = csv.DictReader(f, delimiter=',') 
    housing_stats = [] 
    for row in reader: 
        year = row["year"] 
        field_name = row["title_field"] 
        value = int(row["value"]) 
        denton_dict = {"year": year, "field_name": field_name, "value": value} 
        housing_stats.append(denton_dict) 
        process(year, field_name, value) 

谢谢!我是编程新手,而且我是个老家伙。我喜欢编程社区提供的无可比拟的帮助,就好像你们都在欢迎每个人加入一个邪教(好的邪教?)。

请您参考如下方法:

你可以这样做:

  1. 创建包含目标 title_field 值的那些行 dicts 的列表。
  2. 按每个年份值排序。
  3. 为 pairwise() 使用 itertools 配方生成器处理排序后的列表中的每对行/年。

实现上述代码:

import csv 
from itertools import tee 
 
# From https://docs.python.org/3/library/itertools.html#recipes 
def pairwise(iterable): 
    "s -> (s0,s1), (s1,s2), (s2, s3), ..." 
    a, b = tee(iterable) 
    next(b, None) 
    return zip(a, b) 
 
target_title_field = 'Occupied Housing Units' 
csv_filename = 'denton_housing.csv' 
 
with open(csv_filename, 'r', encoding='utf8', newline='') as f: 
    housing_stats = [] 
    for row in csv.DictReader(f, delimiter=','): 
        if row['title_field'] == target_title_field: 
            year = int(row["year"]) 
            field_name = row["title_field"] 
            value = int(row["value"]) 
            denton_dict = {"year": year, "field_name": field_name, "value": value} 
            housing_stats.append(denton_dict) 
 
housing_stats.sort(key=lambda row: row['year']) 
 
for r1, r2 in pairwise(housing_stats): 
    print('{}-{} {:5}'.format(r1['year'], r2['year'], abs(r2['value'] - r1['value']))) 

输出:

2008-2009   795 
2009-2010  5091 
2010-2011   303 
2011-2012  1404 
2012-2013  1565 
2013-2014  2622