- import csv
- path='assets.csv'
- with open(path,'a', newline='')as csvfile:
- writer = csv.writer(csvfile, dialect='excel')
- csv_head=['COMMUNITY''BUIDING', 'UNIT', 'ROOM', 'DIRECTION', 'LOTS']
- writer.writerow(csv_head)
- title=input('Please enter the community name:')
- building=input('please enter the BUILDING NUMBER : #')
- unit_loop= True
- while unit_loop:
- unit=input('Plz enter the unit number: ')
- start_floor=input('Plz enter the first floor: ')
- end_floor=input('Plz enter the last floor: ')
- Sample=input('please enter ã€room#】ã€Direction】ã€Lots】, click any button to continue...')
- start_floor_rooms={}
- floor_room_digits=[]
- room_loop=True
- while room_loop:
- last_two_digits=input('Plz input room last two digits(ex. 01,02)): ')
- floor_room_digits.append(last_two_digits)
- room_number =int(start_floor+last_two_digits)
- direction=int(input('Enter the direction: 1.SN 2.EW Please enter "1"or"2": '))
- area=int(input('please put lot squear of the ROOM %d'% room_number ))
- start_floor_rooms[room_number]=[direction,area]
- keep_adding=input('Press any button for continue; "N" for no: ')
- if keep_adding =='N':
- room_loop=False
- else:
- room_loop==True
- unit_records={}
- unit_records[start_floor]=start_floor_rooms
- for floor in range(int(start_floor)+1, int(end_floor)+1):
- floor_room={}
- for i in range(len(start_floor_rooms)):
- number= str(floor)+floor_room_digits[i]
- info= start_floor_rooms[int(start_floor+floor_room_digits[i])]
- floor_room[int(number)]=info
- unit_records[floor]=floor_room
- with open ('assets.csv','a',newline='') as csvfile:1
- writer = csv.writer(csvfile, dialect='excel')
- for sub_dict in unit_records.values():
- for room,info in sub_dict.items():
- direction= ['',SN,EW]
- writer.writerow([title, building,unit,building,room, direction[info[0]], info[1]])
- unit_continure=input('Click anything for inputin Next Unit, "N" for no.....')
- if unit_continure== 'N':
- unit_loop== False
- else:
- unit_loop== True
- print ('FUCK YES, FINISHED THIS SHIT!!!' )