python csv数据存储
import csv csvfile = open("mdata.csv", "w+") try: writer = csv.writer(csvfile) for zj in range(1, 501): for cd in range(1, 2001): if (zj<=10 and cd<=100): writer.writerow((zj,cd,0.8,0.2)) elif (zj<=10 and cd>100 and cd<=250): writer.writerow((zj,cd,0.9,0.2)) elif (zj<=10 and cd>250 and cd<=500): writer.writerow((zj,cd,1,0.3)) elif( zj<=10 and cd>500 and cd<=800): writer.writerow((zj,cd,0,0)) elif (zj<=10 and cd>800 and cd<=1200): writer.writerow((zj,cd,0,0)) elif (zj<=10 and cd>1200 and cd<=2000): writer.writerow((zj,cd,0,0)) elif (zj>10 and zj<=18 and cd<=100): writer.writerow((zj,cd,0.9,0.2)) elif (zj>10 and zj<=18 and cd>100 and cd<=250): writer.writerow((zj,cd,0.9,0.3)) elif (zj>10 and zj<=18 and cd>250 and cd<=500): writer.writerow((zj,cd,1,0.3)) elif(zj>10 and zj<=18 and cd>500 and cd<=800): writer.writerow((zj,cd,1.1,0.3)) elif (zj>10 and zj<=18 and cd>800 and cd<=1200): writer.writerow((zj,cd,0,0)) elif(zj>10 and zj<=18 and cd>1200 and cd<=2000): writer.writerow((zj,cd,0,0)) elif (zj>18 and zj<=30 and cd<=100): writer.writerow((zj,cd,1,0.3)) elif (zj>18 and zj<=30 and cd>100 and cd<=250): writer.writerow((zj,cd,1,0.3)) elif (zj>18 and zj<=30 and cd>250 and cd<=500): writer.writerow((zj,cd,1.1,0.3)) elif (zj>18 and zj<=30 and cd>500 and cd<=800): writer.writerow((zj,cd,1.3,0.4)) elif (zj>18 and zj<=30 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.4,0.4)) elif (zj>18 and zj<=30 and cd>1200 and cd<=2000): writer.writerow((zj,cd,0,0)) elif (zj>30 and zj<=50 and cd<=100): writer.writerow((zj,cd,1.1,0.3)) elif (zj>30 and zj<=50 and cd>100 and cd<=250): writer.writerow((zj,cd,1,0.3)) elif (zj>30 and zj<=50 and cd>250 and cd<=500): writer.writerow((zj,cd,1.1,0.4)) elif (zj>30 and zj<=50 and cd>500 and cd<=800): writer.writerow((zj,cd,1.3,0.5)) elif (zj>30 and zj<=50 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.5,0.6)) elif (zj>30 and zj<=50 and cd>1200 and cd<=2000): writer.writerow((zj,cd,1.7,0.6)) elif (zj>50 and zj<=80 and cd<=100): writer.writerow((zj,cd,1.1,0.3)) elif (zj>50 and zj<=80 and cd>100 and cd<=250): writer.writerow((zj,cd,1.1,0.4)) elif (zj>50 and zj<=80 and cd>250 and cd<=500): writer.writerow((zj,cd,1.2,0.4)) elif (zj>50 and zj<=80 and cd>500 and cd<=800): writer.writerow((zj,cd,1.4,0.5)) elif (zj>50 and zj<=80 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.6,0.6)) elif (zj>50 and zj<=80 and cd>1200 and cd<=2000): writer.writerow((zj,cd,1.8,0.7)) elif (zj>80 and zj<=120 and cd<=100): writer.writerow((zj,cd,1.1,0.4)) elif (zj>80 and zj<=120 and cd>100 and cd<=250): writer.writerow((zj,cd,1.2,0.4)) elif (zj>80 and zj<=120 and cd>250 and cd<=500): writer.writerow((zj,cd,1.2,0.5)) elif (zj>80 and zj<=120 and cd>500 and cd<=800): writer.writerow((zj,cd,1.4,0.5)) elif (zj>80 and zj<=120 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.6,0.6)) elif (zj>80 and zj<=120 and cd>1200 and cd<=2000): writer.writerow((zj,cd,1.9,0.7)) elif (zj>120 and zj<=180 and cd<=100): writer.writerow((zj,cd,1.2,0.5)) elif (zj>120 and zj<=180 and cd>100 and cd<=250): writer.writerow((zj,cd,1.2,0.5)) elif (zj>120 and zj<=180 and cd>250 and cd<=500): writer.writerow((zj,cd,1.3,0.6)) elif (zj>120 and zj<=180 and cd>500 and cd<=800): writer.writerow((zj,cd,1.5,0.6)) elif (zj>120 and zj<=180 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.7,0.7)) elif (zj>120 and zj<=180 and cd>1200 and cd<=2000): writer.writerow((zj,cd,2,0.8)) elif (zj>260 and zj<=360 and cd<=100): writer.writerow((zj,cd,1.3,0.6)) elif (zj>260 and zj<=360 and cd>100 and cd<=250): writer.writerow((zj,cd,1.4,0.6)) elif (zj>260 and zj<=360 and cd>250 and cd<=500): writer.writerow((zj,cd,1.5,0.7)) elif (zj>260 and zj<=360 and cd>500 and cd<=800): writer.writerow((zj,cd,1.7,0.7)) elif (zj>260 and zj<=360 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.9,0.8)) elif (zj>260 and zj<=360 and cd>1200 and cd<=2000): writer.writerow((zj,cd,2.1,0.9)) elif (zj>360 and zj<=500 and cd<=100): writer.writerow((zj,cd,1.4,0.7)) elif (zj>360 and zj<=500 and cd>100 and cd<=250): writer.writerow((zj,cd,1.5,0.7)) elif (zj>360 and zj<=500 and cd>250 and cd<=500): writer.writerow((zj,cd,1.5,0.8)) elif (zj>360 and zj<=500 and cd>500 and cd<=800): writer.writerow((zj,cd,1.7,0.8)) elif (zj>360 and zj<=500 and cd>800 and cd<=1200): writer.writerow((zj,cd,1.9,0.9)) else: writer.writerow((zj,cd,2.2,1)) except IOError as e: print(e) finally: csvfile.close()
微信扫码关注
更新实时通知