在Python中从CSV文件读取行 [英] Reading rows from a CSV file in Python

问题描述

我有一个CSV文件，下面是它的样子：

I have a CSV file, here is a sample of what it looks like:

Year:  Dec: Jan:
1      50   60
2      25   50
3      30   30
4      40   20
5      10   10

我知道如何读取文件并打印每一列（例如 - ['Year'，'1'，'2' 3'，etc] ）。但我真正想做的是读取行，这将是这样 ['Year'，'Dec'，'Jan'] 然后 ['1'，'50'，'60'] 等。

I know how to read the file in and print each column (for ex. - ['Year', '1', '2', '3', etc]). But what I actually want to do is read the rows, which would be like this ['Year', 'Dec', 'Jan'] and then ['1', '50', '60'] and so on.

然后我想存储这些数字 ['1'，'50'，'60'] 成为变量，因此我以后可以对它们进行总计：

And then I would like to store those numbers ['1', '50', '60'] into variables so I can total them later for ex.:

Year_1 = ['50'，'60'] 。然后我可以做 sum（Year_1）= 110 。

我如何在Python 3中这样做？

How would I go about doing that in Python 3?

推荐答案

如下：

In [30]: with open("data1.txt") as f:
    lis=[line.split() for line in f]        # create a list of lists
    for i,x in enumerate(lis):              #print the list items 
        print "line{0} = {1}".format(i,x)
   ....:         
line0 = ['Year:', 'Dec:', 'Jan:']
line1 = ['1', '50', '60']
line2 = ['2', '25', '50']
line3 = ['3', '30', '30']
line4 = ['4', '40', '20']
line5 = ['5', '10', '10']

或：

In [39]: with open("data1.txt") as f:
    for i,line in enumerate(f):             
        print "line {0} = {1}".format(i,line.split())
   ....:         
line 0 = ['Year:', 'Dec:', 'Jan:']
line 1 = ['1', '50', '60']
line 2 = ['2', '25', '50']
line 3 = ['3', '30', '30']
line 4 = ['4', '40', '20']
line 5 = ['5', '10', '10']

编辑：

In [5]: with open('data1.txt') as f:
        print "{0}".format(f.readline().split())
        for x in f:
                x=x.split()
                print "{0} = {1}".format(x[0],sum(map(int,x[1:])))
   ...:         
['Year:', 'Dec:', 'Jan:']
1 = 110
2 = 75
3 = 60
4 = 60
5 = 20

这篇关于在Python中从CSV文件读取行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！