Nrthugu

i am getting this error. how to solve this? please help me out.

# Import pandas

import pandas as pd

import csv



# Load csv

#df = pd.read_csv("D:HarshaTradingcm14SEP2018bhav.csv")



# Read in csv file

#for row in csv.reader(open("D:HarshaTradingcm14SEP2018bhav.csv"), delimiter=','):

      #print(row)

#import csv



infile = 'H:cm09NOV2018bhav.csv'

outfile = 'H:output_cm09NOV2018bhav.csv'



wfh = open (outfile, 'w')



with open(infile, 'r') as fh:



    reader = csv.DictReader(fh, delimiter=',')

    wfh.write("{},{},{},{},{},{},{}".format("SYMBOL", "OPEN", "HIGH", "LOW", "CLOSE", "ISIN", "TOTTRDQTY", "STATUS"))

    wfh.write("n")

    for row in reader:

        symbol = row['SYMBOL']

        series = row['SERIES']

        open = row['OPEN']

        high = row['HIGH']

        low = row['LOW']

        close = row['CLOSE']

        last = row['LAST']

        prevclose = row['PREVCLOSE']

        tottrdqty = row['TOTTRDQTY']

        tottrdval = row['TOTTRDVAL']

        timestamp = row['TIMESTAMP']

        totaltrades = row['TOTALTRADES']

        isin = row['ISIN']

        print(low.rstrip())

        if float(high.rstrip()) in [9,25,49,81,121,169,225,289,301,441,529,625]:

            wfh.write("{},{},{},{},{},{},{},{}".format(symbol, open, high, low, close, isin, tottrdqty, "SELL"))

            wfh.write("n")

        elif float(low.rstrip()) in [9,25,49,81,121,169,225,289,301,441,529,625]:

            wfh.write("{},{},{},{},{},{},{},{}".format(symbol, open, high, low, close, isin, tottrdqty, "BUY"))

            wfh.write("n")

        elif float(close.rstrip()) in [9,25,49,81,121,169,225,289,301,441,529,625]:

            wfh.write("{},{},{},{},{},{},{},{}".format(symbol, open, high, low, close, isin, tottrdqty, "CLOSE PRICE"))

            wfh.write("n")

        elif float(open.rstrip()) in [9,25,49,81,121,169,225,289,301,441,529,625]:

            wfh.write("{},{},{},{},{},{},{},{}".format(symbol, open, high, low, close, isin, tottrdqty, "OPEN PRICE"))

            wfh.write("n")



#wfh._archive.close()

wfh.close()

I have not used str in my code. Why am I getting this error?

I believe when you're using format to print, you should avoid adding a string value to the format argument.

so all the code that's writing to the wfh file like these:

wfh.write("{},{},{},{},{},{},{},{}".format(symbol, open, high, low, close, isin, tottrdqty, "SELL"))

need to be changed to:

wfh.write("{},{},{},{},{},{},{},SELL".format(symbol, open, high, low, close, isin, tottrdqty))

# here 'Sell' is a part of the print argument which is already under quotes.

found it:

        open = row['OPEN']

this code re-assigns the python keyword open (which you use to open files) with the contents of row['OPEN'] that means that now when you call open you are calling a str object, not a function.

consider this:

print(type(open))

# <class 'builtin_function_or_method'>

open = 'hello, world'

print(type(open))

# print(type('hello, world'))

you can no longer 'call' open (ie open('file.txt', 'r')) because it is a string, not a function.