Manipulate a csv file using ipython notebook

edit

Thank you so much for your reply. I used this code:

import csv
ifile  = open('circuit.csv')
read = csv.reader(ifile)
for row in read :
    print (row)

I got the same output as you got. But after that I stuck to run the for loop. Is it a problem that I did not mention about delimiter?

What you did will output the follwing:

['Branch       Ra   L       C        Rb']
[' 1           1    10      1        1']
['  2           13   100     15       6']

So, for each row, you get a list with a single element that is a big string. So you do not use the fact that your file is structured with rows and columns. What you need is to split each row according to the space, which is a delimiter.

To be more precise, with the proposed solution you can do something like:

sage: with open('/tmp/plop.csv', 'rb') as my_file:
....:    reader = csv.reader(my_file, delimiter=' ', skipinitialspace=True)
....:    for row in reader:
....:        print row
....:        for column in row:
....:            print column
....:            
Branch
Ra
L
C
Rb
1
1
10
1
1
2
13
100
15
6