不输出任何值

2024-09-28 22:38:01 发布

您现在位置:Python中文网/ 问答频道 /正文

我的代码似乎工作不正常。我的目标是在同一行中匹配年份和位置,并打印出与该行相关的信息。我的代码被张贴在下面,以及用于读取数据的excel表

Excel Sheet

LOAD_GEN_DATAFILE = 'C:\Users\RoszkowskiM\Desktop\Data_2016.csv' # CSV File to Read

with open(LOAD_GEN_DATAFILE) as csvfile:
     reader = csv.DictReader(csvfile)
     mydict={}
     for row in reader:
         Year=row['Year']
         Busnum=row['Busnum']
         Area=row['Area']
         Power=row['Power']
         TLA=row['TLA']
         Location=row['Location']
         Yearlink=row['Yearlink']
         From=row['From']
         To=row['To']
         Max=row['Max']
         Min=row['Min']
year = raw_input("Please Select Year of Study: ") 
print("\n")

commands = ["Millwood-Buchanan", "Astoria-East-Corona", "Bronx", "DUNWOODIE-North-Sherman_Creek",
        "Vernon", "Greenwood-StatenIsland","West_49th","East_13th","Staten_Island","East_River",
        "East_View","DUNWOODIE-SOUTH","Corona-Jamaica","Astoria-East-Corona-Jamaica",
        "Astoria-West-Queensbridge-Vernon","Astoria-West-Queensbridge"]
max_columns = 50

for index, commands in enumerate(commands):
    stars_amount = max(max_columns - len(commands), 0)
    row = "# {} {}({})".format(commands, "." * stars_amount, index + 1)
    print(row)

 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 #: ")
 print("\n")

if year==Year and location==Location:  
   mydict=[Busnum,Area,Power]

print("Here are all the busses at that location for that year and the new LOAD TOTAL: ")
print("\n")

   for Busnum,Area,Power in mydict:
    Power= float(scaled_power)
    Busnum = int(busnum)
    print('Bus #: %d\t' % Busnum ,'Area Station: %s\t'% Area,'New Load Total: %d MW\t' % Power)

Tags: theinforasloadareayearmydict