import csv output = file('tractors.csv', "w") wr = csv.writer(output,delimiter=',',lineterminator='\n') Data_Write=['CY','MY','Cap_type','Road_Type','Haul_Type','Aerodynamic','LRR','Total'] wr.writerow(Data_Write) cab_type=["sleeper","day"] road_type=["highway","local"] haul_type=["long","short","local"] for CY in range(2010,2052): for MY in range(1965,CY+1): for cab in cab_type: for road in road_type: for haul in haul_type: AERO=0 LRR=0 EPA_Red=0 #-----Long Haul if (CY>=2010) and (cab=="sleeper") and (MY>=2011) and (haul=="long"): if road=="highway": AERO=0.02 LRR=0.015 else: AERO=0 LRR=0.015 if (CY>=2010) and (cab=="day") and (MY>=2011) and (haul=="long"): AERO=0 LRR=0.015 if (CY>=2013) and (MY<=2010) and (haul=="long"): AERO=0 LRR=0.015 #-----Short Haul if (haul=="short"): AERO=0 LRR=0.0 #-----Local Haul if (CY>=2010) and (cab=="sleeper") and (MY>=2011) and (haul=="local"): AERO=0 LRR=0.015 if (CY>=2010) and (cab=="day") and (MY>=2011) and (haul=="local"): AERO=0 LRR=0.015 if (CY>=2013) and (MY<=2010) and (haul=="local"): AERO=0 LRR=0.015 if CY<=2050: Data=[CY,MY,cab,road,haul,AERO,LRR,AERO+LRR] wr.writerow(Data) if (CY>2010) and (CY==MY): Data=[CY-1,MY,cab,road,haul,AERO,LRR,AERO+LRR] wr.writerow(Data) output.close()