This is example how to iterate over CSV file in python

This simple  example does not use csv module.
IT could be used for example to set DB connections

<code>
import sys

CSVFile=’/var/tmp/your_file.csv’

def processRow(row):
    args=row.split(‘,’)
    (DatabaseName,DatabaseUserName,HostName,DatasourceName,Port,MaxConn)=args[4:10]

    print row
    print ” DBName = ” + DatabaseName +\
“\n DatabaseUserName = ” + DatabaseUserName +\
“\n Hostname = ” + HostName +\
“\n DSName = ” +  DatasourceName +\
“\n Port = ” + Port +\
“\n MaxConn = ” +  MaxConn

    # PUT YOUR CODE HERE
   
    # END OF CODE

# END OF PROCEDURE

print ‘Reading ‘+CSVFile
f=open(CSVFile,’r')
print f
firstrow=f.readline()
row=firstrow

print “First Row is [" + firstrow + "]“

#
# MAIN LOOP
#
while 1:
    row=f.readline()
    if row==”":
        break
    processRow(row)
f.close
</code>

Dodaj komentarz

Wprowadź swoje dane lub kliknij jedną z tych ikon, aby się zalogować:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Zmień )

Twitter picture

You are commenting using your Twitter account. Log Out / Zmień )

Facebook photo

You are commenting using your Facebook account. Log Out / Zmień )

Connecting to %s

Follow

Otrzymuj każdy nowy wpis na swoją skrzynkę e-mail.