Dfyjkt

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.