Python Forum
Repost isinstance not outputting any statements
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Repost isinstance not outputting any statements
#1
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? For this output statement, nothing occurs
From Bus #: {}\tTo Bus #: {}\tTo Bus #: {}\t Area Station: {}\t VMIN: {} pu\tVMAX: {} pu\t
FOR SOME REASON I CAN'T ATTACH EXCEL FILE: I DON'T HAVE OPTION UNDER TEXT EDITOR TO CLICK ON ATTACHMENTS


  
 
 
    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
#2
Why did you feel the need to repost the same thread? You could have just added the comment to the original one.
If it ain't broke, I just haven't gotten to it yet.
OS: Windows 10, openSuse 42.3, freeBSD 11, Raspian "Stretch"
Python 3.6.5, IDE: PyCharm 2018 Community Edition


Possibly Related Threads…
Thread Author Replies Views Last Post
  Trying to understand how isinstance(values, collections.Iterable) work. quazirfan 7 4,098 Aug-10-2021, 08:10 AM
Last Post: snippsat
  Reading a directory and outputting as sound loungeroom 0 1,201 Jul-30-2021, 09:26 PM
Last Post: loungeroom
  basic question isinstance tames 5 2,773 Nov-23-2020, 07:20 AM
Last Post: tames
  Opening file and outputting its text content example leodavinci1990 1 1,849 Oct-12-2020, 05:33 AM
Last Post: buran
  Help with isinstance command (very simple code) Laplace12 2 1,967 Jul-30-2020, 05:26 AM
Last Post: Laplace12
  isinstance() always return true for object type check Yoki91 2 2,503 Jul-22-2020, 06:52 PM
Last Post: Yoki91
  Outputting Sorted Text files Help charlieroberrts 1 1,687 Jul-05-2020, 08:37 PM
Last Post: menator01
  Outputting results into other program ancient650 1 1,830 Jun-11-2019, 02:49 PM
Last Post: gontajones
  List and isinstance Roh_80 1 2,279 Jan-14-2019, 03:52 PM
Last Post: ichabod801
  Python only outputting "101" Spuffle 4 9,108 Jan-09-2019, 10:07 AM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020