isinstance not outputting anything

Question

My code is not outputting anything when using isinstance. This is shown at the end of the code. I tried inputting year 1 and tla_2=1, and no output occurred. Is my isinstance statement wrong. Am I for looping incorrectly?

output = 'From Bus #: {}\tTo Bus #: {}\tTo Bus #: {}\t Area Station: {}\t VMIN: {} pu\tVMAX: {} pu\t'
print(output.format(from_, to,name2, min_value, max_value,last_bus))

Excel Sheet

from __future__ import print_function
import os.path
import win32com.client

#---------------------------------------------------------------------------------------------------------------------
xlApp = win32com.client.DispatchEx('Excel.Application') # Running Excel
xlsPath = os.path.expanduser('C:\Users\RoszkowskiM\Desktop\UPDATED_LOAD_FORECAST_4.xlsm')# Reading xlsm file
wb = xlApp.Workbooks.Open(Filename=xlsPath) # Opening file
xlApp.Run('csvfile2')# Running macro---- csvfile2 is the macro name. It is under the "csv" module in the VBA editor
wb.Save()
xlApp.Quit()
#---------------------------------------------------------------------------------------------------------------------
# WHEN RUNNING THE PROGRAM, MAKE SURE THE CSV FILE IS NOT OPEN.

# THIS WILL PRODUCE AN ERROR WITH READING AND RUNNING THE MACRO.

# THE EXCEL WORKBOOK CAN BE OPEN WHEN RUNNING THE PROGRAM


import os, sys
#--------------------------------------------------------------------------
#PSSE_LOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" #Locating PSSE
#sys.path.append(PSSE_LOCATION)
#os.environ['PATH'] = os.environ['PATH'] + ';' + PSSE_LOCATION
#--------------------------------------------------------------------------


#----------------------------------------------------------------------------------------------------------------
#import psspy
#import redirect
import csv
#psspy.throwPsseExceptions = True
from Tkinter import *    # File Dialog
import tkFileDialog
import tkSimpleDialog
import tkMessageBox
import Tkinter as tk



#Pop up window for picking file on PSSE
#root = tk.Tk()
#root.withdraw()
#tkMessageBox.showinfo("Welcome", "Please select case: ")
#root.fileName= tkFileDialog.askopenfilename( filetypes = ( ("PSSE CASES", "*.sav"), ("PSSE CASES", "*.raw*") ) )
#STUDY_CASE=root.fileName



#psspy.psseinit(10000)  # Intialize PSSE
#psspy.case(STUDY_CASE) # Upload Case 


LOAD_GEN_DATAFILE = 'C:\Users\RM\Desktop\Data_2017.csv' # CSV File to Read

# read the entire CSV into Python.
# CSV has columns starting with  Year,busnum,busname,scaled_power,tla,location,empty,year_link,from_,to,digit,min_value,max_value,last_bus
#-------------------------------------------------------------------------------
# read the entire CSV into Python.
# CSV has columns starting with Year,busnum,busname,scaled_power,tla,location
data = list(csv.reader(open(LOAD_GEN_DATAFILE)))
mydict = {}
for row in data:
    Year,busnum,busname,scaled_power,tla,data_location,empty,year_link,from_,to,digit,name2,tla_2,min_value,max_value,last_bus = row[0:16]


    #If this is a year not seen before, add it to the dictionary
    if Year not in mydict:
        mydict[Year] = {}

    busses_in_year = mydict[Year]
    if data_location not in busses_in_year:
         busses_in_year[data_location] = []


    #Add the bus to the list of busses that stop at this location
    busses_in_year[data_location].append((busnum,busname,scaled_power))
#-------------------------------------------------------------------------------



#-------------------------------------------------------------------------------------------------------------------------------------
#User Input Statement

year = raw_input("Please Select Year of Study: ")

print("\n")

location=raw_input(" \n The list above show the TLA Pockets as well as the ID numbers assigned to them ()\n\n Please enter the ID #: ")
#psspy.prompt_output(islct = 6)
print("\n")
Year=year
data_location=location
#---------------------------------------------------------------------------------------------------------------------------------------

#-------------------------------------------------LOAD FORECASTS--------------------------------------------------------------------
if Year in mydict and data_location in mydict[Year]:  
    busses_in_year = mydict[Year]
    #print("Here are all the busses at that location for that year and the new LOAD TOTAL: ")
    #print("\n")

    #Busnum, busname,scaled_power read from excel sheet matching year and location

    for busnum,busname,scaled_power in busses_in_year[data_location]:
        scaled_power= float(scaled_power)
        busnum = int(busnum)
        output='Bus #: {}\t Area Station: {}\t New Load Total: {} MW\t'
        print(output.format(busnum,busname,scaled_power))
        #psspy.bsys(1,0,[0.0,0.0],0,[],1,[busnum],0,[],0,[])
        #psspy.scal_2(1,0,1,[0,0,0,0,0],[0.0,0.0,0.0,0.0,0.0,0.0,0.0])
        #psspy.scal_2(0,1,2,[0,1,0,1,0],[scaled_power,0.0,0,-.0,0.0,-.0,0])


else:
    exit
#-------------------------------------------------LOAD FORECASTS--------------------------------------------------------------------

#------------------------------------------------VOLTAGE ENVLOPES---------------------------------------------------------------------------------------------------------------------------------   

for row in data:
    year_link, from_,to,digit,name2,tla_2,min_value,max_value,last_bus = row[7:16]
    output = 'From Bus #: {}\tTo Bus #: {}\t Area Station: {}\t VMIN: {} pu\tVMAX: {} pu\t'
    if year_link == year and tla_2==location:
        from_=int(from_)
        to=int(to)
        min_value=float(min_value)
        max_value=float(max_value)
        digit=int(digit)

        print(output.format(from_, to,name2, min_value, max_value))
        #_c=psspy.getdefaultchar()
        #_i=psspy.getdefaultint()
        #_f=psspy.getdefaultreal()
        #psspy.two_winding_chng_4(from_,to,'%d'% digit,[_i,_i,_i,_i,_i,_i,_i,_i,_i,_i,_i,_i,_i,_i,_i],[_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f,_f, max_value, min_value,_f,_f,_f],[])
    else:
        exit
for row in data:
     year_link, from_,to,digit,name2,tla_2,min_value,max_value,last_bus = row[7:16]
     if year_link==year and tla_2==location and isinstance(last_bus, int):
        output = 'From Bus #: {}\tTo Bus #: {}\tLast Bus #: {}\t Area Station: {}\t VMIN: {} pu\tVMAX: {} pu\t'
        print(output.format(from_, to,name2, min_value, max_value,last_bus))
        min_value=float(min_value)
        max_value=float(max_value)
        #psspy.three_wnd_winding_data_3(from_,to,last_bus,r"""1""",1,[_i,_i,_i,_i,_i],[_f,_f,_f,_f,_f,_f,_f,_f, max_value, min_value,_f,_f,_f]) 
     else:
        exit

    #------------------------------------------------VOLTAGE ENVLOPES----------------------------------------------------------------------------------------------------------------------------------         

os.remove(LOAD_GEN_DATAFILE)

Welcome to SO. Please provide a minimal sample to demonstrate the error and tell us about the outcome you expect from it. — yacc, Aug 31 '17 at 00:35
If you read the comment, it says `tla_2=1` and `year=1`. Then I said nothing outputted. There's your example — Michael Roszkowski, Aug 31 '17 at 12:42

Jean-François Fabre · Answer 1 · 2017-08-31T15:47:39.927

1

csv.writer is able to write any data (integers, floats, strings...) to a csv. But csv.reader doesn't perform the inverse operation.

last_bus is a data directly coming from csv.reader iterator. So it has to be a string.

So, your isinstance method cannot return True.

There are several methods to check if a string is actually an integer. I won't explain them here, it would be redundant with a lot of already answered questions, but check this Q&A (which has links to other Q&As) to implement one of your choice: How can I check if a string has a numeric value in it in Python?

Once you have determined that the string holds an integer, just do int(last_bus) to convert to integer.

edited Aug 31 '17 at 15:47

answered Aug 30 '17 at 19:21

Jean-François Fabre

137,073
23
153
219

but it is not a string. Its an integer. Why do I want to write data? I'm trying to read data – Michael Roszkowski Aug 31 '17 at 15:44
1

it _is_ a string. It has just a value that can be converted to an integer. – Jean-François Fabre Aug 31 '17 at 15:45
so what do I do then, declare as variable, how would I do that? – Michael Roszkowski Aug 31 '17 at 15:46
once you checked that it is indeed an integer (by following the link), just do `int(last_bus)` to convert it. – Jean-François Fabre Aug 31 '17 at 15:47
so I did this `isinstance(last_bus,str)`. It works, I don't know it will hold valid though – Michael Roszkowski Aug 31 '17 at 15:53
sorry for annoying you. I want to ask another question where I switch one part of the code and put it in front of the other. So `Voltage Envelopes` in front of `Load Forecasts`. I tried doing that but I get an infinite output statement for the `Load Forecasts` PART – Michael Roszkowski Aug 31 '17 at 15:59

score 0 · Answer 2 · answered Aug 31 '17 at 18:09

Ok so i did what you said. It's outputting correctly, but its not outputting into the psspy function.

for row in data:
     year_link, from_,to,digit,name2,tla_2,min_value,max_value,last_bus = row[7:16]
     if isinstance(last_bus, str) and year_link==year and tla_2==location and last_bus.isdigit() is True:
         min_value=float(min_value)
         max_value=float(max_value)
         last_bus=int(last_bus)
         output = 'From Bus #: {}\tTo Bus #: {}\tLast Bus #: {}\t Area Station: {}\t VMIN: {} pu\tVMAX: {} pu\t'
         print(output.format(from_, to,last_bus,name2, min_value, max_value))
         print("\n")
         psspy.three_wnd_winding_data_3(from_,to,last_bus=int(last_bus),r"""1""",1,[_i,_i,_i,_i,_i],[_f,_f,_f,_f,_f,_f,_f,_f, max_value, min_value,_f,_f,_f]) 
     else:
         exit

@Jean-François Fabre it still says integer error – Michael Roszkowski Aug 31 '17 at 18:10 — Michael Roszkowski, Aug 31 '17 at 18:10

isinstance not outputting anything

2 Answers2