Read CSV file by python

, , ,
1

HI, I am trying to read data of csv file by using python but It’s not working with me.

this my code on python script.

import clr
clr.AddReference(‘ProtoGeometry’)
from Autodesk.DesignScript.Geometry import *

clr.AddReference(‘RevitNodes’)
from System.IO import FileInfo

import sys
sys.path.append(“C:\Program Files (x86)\IronPython 2.7\Lib”)

import csv
from System.IO import FileInfo

code
file = FileInfo(IN[0])

cr = csv.reader(response)
data =
for cr in file:
for row in cr:
data.append(row)

Assign your output to the OUT variable.

OUT = data

3

@Deniz_Maral @dzarur @d.sellam Can you help me to solve this?

when I use this code the out = path but I want get the data as string no just the path

import sys
sys.path.append(‘C:\Program Files (x86)\IronPython 2.7\Lib’)
import csv
import StringIO

csv_in = IN[0]
data =

source = StringIO.StringIO(csv_in)
csv_out = csv.reader(source, dialect=csv.excel)
for row in csv_out:
data.append(row)

OUT = data

5

use r‘C:\Program Files (x86)\IronPython 2.7\Lib’

What data are you talking about?

6

the same

Capture
Capture961×480 38 KB

7

Why do you need Python for that? You can use Data.ImportCSV node to get data.

8

You need to open the file first then use the CSV.reader line.

with open(inputfile) as csv_file:
    csv_reader = csv.reader(csv_file, delimiter=',')
    for row in csv_reader:
        output.append(row)

You could just read it as a text file in Dynamo then use a string split node to split by “,” as a secondary option

1 Like
9

no I need it from python

10

image
image861×470 32.5 KB

11

maybe a problem with the inputfile? we need get the path of file (not file), don’t forget the raw string if necessary
or a problem with file’s permission?

12

What says the error message?
Can you try to open(inputfile[0])?

13

ok , now when I use it’s working but I have one problem, that is when I make update in csv file there is no change in dynamo I need to double check on node input to refresh … can i add something to the code to make it refresh automatic or maybe I should make input file as file from path not just file.

with open(inputfile) as csv_file:
csv_reader = csv.reader(csv_file, delimiter=’,’)
for row in csv_reader:
output.append(row)

14

It’s working but not updated please read the last reply from me

15

I will explain my problem to you deniz that in dynamo nodes when I use import\read excel or read from text node I can add file from path as a input but when I use import csv I can’t add file from path as it needs file directly so when I make edit on csv file there is no change in list

16

@MAIA17112
if your csv file is updated you need relaunch the script or use the Periodic Run Mode

17

file_ref
file_ref1184×604 34.1 KB 

path = IN[0]
z=[]



with open(path) as csv_file:
	csv_reader = csv_file.readlines()
	for row in csv_reader:
		z.append(row)
			

OUT = z
1 Like
19

Do like I did. Use Passtrough node from Clockwork and it will work.

20

yes thanks deniz it’s a perfect solution but I have a question… how I can make list “II” like list “I”

image
image525×536 34 KB

21

You can use String.TrimWhiteSpace node.

or in Python

z.append(row.strip())
22

result is null!

image
image897×522 42 KB

23 
path = IN[0]
z=[]



with open(path) as csv_file:
	csv_reader = csv_file.readlines()
	for row in csv_reader:
		z.append(row.strip())
			

OUT = z
2 Likes