def __init__(self, f, fieldnames, restval='', extrasaction='raise', dialect='excel', *args, **kwds): self.fieldnames = fieldnames self.restval = restval if extrasaction.lower() not in ('raise', 'ignore'): raise ValueError("extrasaction (%s) must be 'raise' or 'ignore'" % extrasaction) self.extrasaction = extrasaction self.writer = writer(f, dialect, *args, **kwds)
def search(): # Determine the location to be searched #city = input("Your Town/City: ") Put this in later to replace "town" variable town = "greenville" craigslist = 'http://' + town + ".craigslist.org/search/zip" print(craigslist) r = requests.get(craigslist).text # Scraping the site first_file = "C:\\Users\\Sam\\Documents\\first.csv" for pg in craigslist: soup = BeautifulSoup(r, 'html.parser') name_box = soup.find_next( "p") # need to find a way to get iterate thru name = name_box.text data = [] data.append(name) not_dup = [] if name != not_dup: not_dup.append(name) with open(first_file, 'a') as csv_file: writer = csv.writer(csv_file) for name in data: writer.writerow(name) print(name) else: continue print("done")
def __init__(self, f, fieldnames, restval = '', extrasaction = 'raise', dialect = 'excel', *args, **kwds): self.fieldnames = fieldnames self.restval = restval if extrasaction.lower() not in ('raise', 'ignore'): raise ValueError, "extrasaction (%s) must be 'raise' or 'ignore'" % extrasaction self.extrasaction = extrasaction self.writer = writer(f, dialect, *args, **kwds)
def append_list_as_row(file_name, list_of_elem): # Open file in append mode with open(file_name, 'a+', newline='') as write_obj: # Create a writer object from csv module csv_writer = writer(write_obj) # Add contents of list as last row in the csv file csv_writer.writerow(list_of_elem)
def main(): re2 = '(P2)|(P3)' rg2 = re.compile(re2, re.DOTALL) ext = [".log", ".log.0",".log.1",".log.2",".log.3",".log.4",".log.5",".log.6",".log.7",".log.8"] filelist = os.listdir('.') for files in filelist: if files.endswith(tuple(ext)): with open('test.csv','a') as out_file, open(files,'r') as in_file: writer = _csv.writer(out_file) writer.writerow(['time','LSPName','LSPID_TUNNELID','packets','TotalMbits','PPS','Ratebps','UTIL%','RESVBW_mbps']) for line in in_file: coulmns = line[:-1].split(' ') coulmns = list(filter(None, coulmns)) coulmns[0] = ' '.join(coulmns[:3]) del coulmns[1:3] if rg2.match(coulmns[1]): coulmns = list(filter(filtering,coulmns)) coulmns[2] = ' '.join(coulmns[2:8]) del coulmns[3:8] #if not(float(coulmns[7].strip("%")) == 0.00): # Converting BytePerSecond to Bits Per Second coulmns[4] = 8 * int(coulmns[4]) coulmns[6] = 8 * int(coulmns[6]) coulmns[8] = 8 * int(coulmns[8]) # Converting bps to Mbps coulmns[4] = coulmns[4]/(1000000) coulmns[6] = coulmns[6]/(1000000) coulmns[8] = coulmns[8]/(1000000) writer.writerow(coulmns)
def __init__(self, f, fieldnames, restval="", extrasaction="raise", dialect="excel", *args, **kwds): self.fieldnames = fieldnames self.restval = restval if extrasaction.lower() not in ("raise", "ignore"): raise ValueError, "extrasaction (%s) must be 'raise' or 'ignore'" % extrasaction self.extrasaction = extrasaction self.writer = writer(f, dialect, *args, **kwds)
def Crawl(): url = 'https://www.spiegel.de/international/' urlcrawled = 'https://www.spiegel.de' page = requests.get(url) soup = BeautifulSoup(page.content, 'html.parser') weblinks = soup.find_all('a', {'href': True}) # retrieve news linke from main page of site with open('news.csv', 'w') as csv_file: csv_writer = writer(csv_file) # creating headers in the csv file headers = ['Title', 'SubTitle', 'Abstract', 'InsertedDate'] # writing a row of headers in the csv csv_writer.writerow(headers) urls = re.findall( '/international+[/a-z/]+(?:[-\w.]|(?:%[\da-fA-F]{2}))+.html', str(weblinks)) for u in urls: strurl = "{0}{1}".format(urlcrawled, u) # """Scrapes information from pages into items""" pagez = requests.get(strurl) soupz = BeautifulSoup(pagez.content, 'html.parser') # now lets loop through posts for tag in soupz.find_all("meta"): if tag.get("property", None) == "og:title": title = tag.get("content", None) elif tag.get("property", None) == "og:description": description = tag.get("content", None) elif tag.get("name", None) == "news_keywords": subtitle = tag.get("content", None) csv_writer.writerow( [title, subtitle, description, datetime.datetime.utcnow()]) csv_file.close()
def csv_writer(self, data, filename): if not os.path.isfile(filename) or os.stat(filename).st_size == 0: self.csv_new(filename) with open(filename, "a") as csv_file: writer = csv.writer(csv_file, delimiter=',') for line in data: writer.writerow(line)
def CSV_W(name, SN): with open( "F:\Python\Django_lamps_Json_login_telebot_002\Lamp_API_Login_Telebot\login/test_csv.csv", mode="a", encoding='utf-8') as w_file: file_writer = _csv.writer(w_file, delimiter=",", lineterminator="\r") file_writer.writerow([name, SN]) w_file.close()
def __init__(self, f, fieldnames, restval="", extrasaction="raise", dialect="excel", *args, **kwds): self.fieldnames = fieldnames # list of keys for the dict self.restval = restval # for writing short dicts if extrasaction.lower() not in ("raise", "ignore"): raise ValueError("extrasaction (%s) must be 'raise' or 'ignore'" % extrasaction) self.extrasaction = extrasaction self.writer = writer(f, dialect, *args, **kwds)
def serialize(cls, portfolio): output = StringIO() portfolio_writer = writer(output) portfolio_writer.writerow(['Symbol', 'Description', 'Country', 'Shares', 'Price', 'Currency', 'Total Value']) for h in portfolio.holdings.values(): portfolio_writer.writerow([h.symbol, h.description, h.country, "%.2f" % h.shares, cls._format(h.price), h.currency, cls._format(h.total_value())]) portfolio_writer.writerow(['CASH', 'Money Market Account', '-', '-', '-', portfolio.cash_currency, cls._format(portfolio.cash_value)]) portfolio_writer.writerow(['TOTAL', '-', '-', '-', '-', portfolio.cash_currency, cls._format(portfolio.value())]) return output
def csv_new(self, filename): DATA = [[ 'Type', 'URL', 'Listing Agent', 'Price', 'Address', 'Beds', 'Showers', 'Cars', 'Location Type', 'Size of the property', 'Description', 'Features' ]] with open(filename, 'w') as csv_file: writer = csv.writer(csv_file, delimiter=',') for line in DATA: writer.writerow(line)
def write(self, block, p_drive, file_name): if len(self.drivers) != len(block): raise Exception('Num blocks does not match num disks') f_name, ext = os.path.splitext(file_name) for i in range(len(block)): if i == p_drive: name = f_name + '_p.csv' with open(name, 'a', newline='') as csv: writer = _csv.writer(csv, delimiter=',') b = block[i] writer.writerow([b]) else: name = f_name + '_' + str(i) + '.csv' with open(name, 'a', newline='') as csv: writer = _csv.writer(csv, delimiter=',') b = block[i] writer.writerow([b])
def to_csv(self, filename=None): file = sys.stdout if filename is None else open(filename, "w") writer = _csv.writer(file) writer.writerow((self.__path + Histogram.__HEADER_BIN, self.__path + Histogram.__HEADER_COUNT)) for i in range(self.bin_count): writer.writerow((format(self.__bin(i), '.6f'), self.__counts[i])) if filename is not None: file.close()
def __init__(self, filename=None, cache=False, append=False): """ Constructor """ self.__filename = filename self.__cache = cache self.__has_header = False if self.__filename is None: self.__append = False self.__file = sys.stdout self.__writer = _csv.writer(self.__file) else: self.__append = append and os.path.exists(self.__filename) self.__file = open(self.__filename, "a" if self.__append else "w") self.__writer = CSVLogger(self.__file) if cache else _csv.writer( self.__file)
def export_results_clicked(self): file = QFileDialog.getSaveFileName(self, 'Save Keywords', '.', 'Excel (*.csv)')[0] if file: with open(file, 'wt', newline='') as file: w = writer(file) w.writerow(self.file_headers) for row in range(self.files.rowCount()): w.writerow([self.files.item(row, 0).text()] + [ self.files.item(row, i + 1).text() for i in range(self.keyword_list.count()) ])
def add_row_to_csv(csv_path, list_of_elements): """ This function takes as argument and then it adds rows to this csv file. :param csv_path: The path to csv. :param list_of_elements: The list you want to append. :return: Nothing """ with open(csv_path, 'a+', newline='') as write_obj: # Create a writer object from csv module csv_writer = writer(write_obj) # Add contents of list as last row in the csv file csv_writer.writerow(list_of_elements)
def readCSV(selfself): write_obj = open('data.csv', 'w+', newline='') csv_writer = writer(write_obj) for file in os.listdir("C:\\Users\\Alexandra\\Desktop\\CoronaNews"): if file.endswith(".CSV"): os.chdir(r'C:\Users\Alexandra\Desktop\CoronaNews') with open(file, 'r', encoding='utf8') as read_obj: csv_reader = reader(read_obj, delimiter='\t') line = next(csv_reader) if line is not None: for row in csv_reader: if row[37] != '' and row[45] != '' and row[37] != row[45] and "coronavirus" in row[60]: csv_writer.writerow([row[37], row[45], row[60]]) write_obj.close()
def exportCSV(): connection = mysql.connector.connect(host="34.82.241.205", user="******", password="******", database="FitnessTracker") curr = connection.cursor() with open('FitnessUsers.csv', 'w') as f: curr.execute( "SELECT FirstName, LastName, Description FROM Users Join Goals G on Users.GoalID = G.GoalID WHERE isDeleted = 0 ORDER BY UserID" ) rows = curr.fetchall() w = _csv.writer(f) for x in rows: w.writerow(rows)
def csvExport(in_list): with open('C://Users/Alec/Desktop/Video_Data_export.csv', 'ab') as vidprocess: global frame_number global frame_length process = csv.writer(vidprocess, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL) write_list = [frame_number, frame_number * frame_length] for k in range(0, len(in_list)): write_list.append(in_list[k]) process.writerow(write_list) frame_number += 1 vidprocess.close()
def csvConvert(data): with open('C://Users/Alec/Desktop/Velocity_Data.csv', 'ab') as vidprocess: process = csv.writer(vidprocess, delimiter=',', quotechar='|', quoting=csv.QUOTE_MINIMAL) process.writerow(['Mission Start Time:', current_time]) process.writerow([ 'Car Number', 'Entry Time Offset', 'Entry X Position', 'Entry Y Position', 'Exit Time Offst', 'Exit X Position', 'Exit Y Position', 'Average Velocity' ]) for item in data: process.writerow(item) vidprocess.close()
def write(self, data, method='w'): """ Export data to CSV file. :param data: Either a list of tuples or a list of lists. :param method: File opening method. """ # Create list of lists from flat list data = data if isinstance(data[0], (list, set, tuple)) else [[d] for d in data] # Open file and write rows with open(self.file_path, method) as write: wr = csv_builtin.writer(write) wr.writerows(data) return self.file_path
def mapCountryCodesToNrAndEliminateDuplicates(self): lista = [] write_obj = open('final_result.csv', 'w+', newline='') csv_writer = writer(write_obj) with open('data.csv', 'r') as read_obj: csv_reader = reader(read_obj, delimiter=',') line = next(csv_reader) if line is not None: for row in csv_reader: if [row[0], row[1]] not in lista: lista.append([row[0], row[1]]) csv_writer.writerow([str(self.country_codes_dict[row[0]]), str(self.country_codes_dict[row[1]])]) if row[0] not in self.nodes: self.nodes.append(row[0]) if row[1] not in self.nodes: self.nodes.append(row[1]) print(len(self.nodes)) #cate noduri avem
def generate_face_data(): face_cascade = cv2.CascadeClassifier( 'data/haarcascade/haarcascade_frontalface_default.xml') eye_cascade = cv2.CascadeClassifier('data/haarcascade/haarcascade_eye.xml') camera = cv2.VideoCapture(0) count = 0 while count <= TRAIN_IMAGES_COUNT: ret, frame = camera.read() frame_gray = cv2.cvtColor(frame, cv2.COLOR_BGR2GRAY) faces = face_cascade.detectMultiScale(frame_gray, 1.3, 5) for face in faces: x, y, width, height = face cv2.rectangle(frame_gray, (x, y), (x + width, y + height), (255, 0, 0), 2) data_img = cv2.resize(frame_gray[y:y + height, x:x + width], (200, 200)) cv2.imwrite('data/face_data/' + str(count) + '.pgm', data_img) print("Image saved") count += 1 cv2.imshow("frame", frame) if cv2.waitKey(int(1000 / 12)) & 0xff == ord('q'): break csv_data = [] for root, dir, files in os.walk('data/face_data'): for file in files: if '.pgm' in file: csv_data.append([CSV_DATA_PATH + file, FACE_LABEL]) with open('data/face_data/facedata.csv', 'w') as file: writer = _csv.writer(file) writer.writerows(csv_data) camera.release() cv2.destroyAllWindows()
def toCsv(excel): import pyexcel import datetime from pyexcel._compact import OrderedDict book_dict = pyexcel.get_book_dict(file_name=excel) sheet1 = book_dict.get('Sheet1') zaglavlja = sheet1[0] lista = [] datumi = [] pozicija = 0 for z in zaglavlja: if ('iznos' in z.lower()): lista.append(pozicija) if 'datum' in z.lower(): datumi.append(pozicija) pozicija += 1 #print(lista) if (len(lista) > 0): for x in sheet1: for i in lista: x[i] = str(x[i]).replace(',', '.') if len(datumi) > 0: for x in sheet1: for i in datumi: if type(x[i]) == type(datetime.datetime.now()): x[i] = x[i].strftime('%d.%m.%Y') #x[i] = 'asasa' #x[i] = type(x[i]) #print(sheet1) import _csv as csv outfile = open( 'C:\\Users\\r103co62\\Desktop\\test\\Podaci za klijente 30.01.2019-21.02.2019.csv', 'w') writer = csv.writer(outfile, delimiter=';', lineterminator='\n', quotechar='"') writer.writerows(sheet1) outfile.close()
def main(): re2 = '(P2)|(P3)' rg2 = re.compile(re2, re.DOTALL) ext = [ ".log", ".log.0", ".log.1", ".log.2", ".log.3", ".log.4", ".log.5", ".log.6", ".log.7", ".log.8" ] filelist = os.listdir('.') for files in filelist: if files.endswith(tuple(ext)): with open('test.csv', 'a') as out_file, open(files, 'r') as in_file: writer = _csv.writer(out_file) writer.writerow([ 'time', 'LSPName', 'LSPID_TUNNELID', 'packets', 'TotalMbits', 'PPS', 'Ratebps', 'UTIL%', 'RESVBW_mbps' ]) for line in in_file: coulmns = line[:-1].split(' ') coulmns = list(filter(None, coulmns)) coulmns[0] = ' '.join(coulmns[:3]) del coulmns[1:3] if rg2.match(coulmns[1]): coulmns = list(filter(filtering, coulmns)) coulmns[2] = ' '.join(coulmns[2:8]) del coulmns[3:8] #if not(float(coulmns[7].strip("%")) == 0.00): # Converting BytePerSecond to Bits Per Second coulmns[4] = 8 * int(coulmns[4]) coulmns[6] = 8 * int(coulmns[6]) coulmns[8] = 8 * int(coulmns[8]) # Converting bps to Mbps coulmns[4] = coulmns[4] / (1000000) coulmns[6] = coulmns[6] / (1000000) coulmns[8] = coulmns[8] / (1000000) writer.writerow(coulmns)
def sample_page(request, model_title): res = "" for i in accounting.models.__dict__.keys(): if i.lower() == model_title: res = i break response = HttpResponse(content_type='text/csv') writer = csv.writer(response) if res == 'ΠΠΎΡΡΠ°Π²ΡΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="Providers.csv"' writer.writerow([ 'id ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°', 'Π’ΠΈΠΏ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ', 'Π’Π΅Π»Π΅ΡΠΎΠ½', 'ΠΠ΄ΡΠ΅Ρ', 'ΠΡΡΠ³ΠΈΠ΅ ΠΊΠΎΠ½ΡΠ°ΠΊΡΠ½ΡΠ΅ Π΄Π°Π½Π½ΡΠ΅', 'ΠΠΎΠΌΠΌΠ΅Π½ΡΠ°ΡΠΈΠΉ' ]) model = accounting.models.ΠΠΎΡΡΠ°Π²ΡΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°'): writer.writerow([ obj.id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°, obj.id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ, obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.id_Π°Π΄ΡΠ΅ΡΠ°, obj.Π΄ΡΡΠ³ΠΈΠ΅_ΠΊΠΎΠ½ΡΠ°ΠΊΡΠ½ΡΠ΅_Π΄Π°Π½Π½ΡΠ΅, obj.ΠΊΠΎΠΌΠΌΠ΅Π½ΡΠ°ΡΠΈΠΉ ]) elif res == 'ΠΠ΄ΡΠ΅ΡΠ°': response['Content-Disposition'] = 'attachment; filename="Address.csv"' writer.writerow( ['id Π°Π΄ΡΠ΅ΡΠ°', 'Π‘ΡΡΠ°Π½Π°', 'ΠΠΎΡΠΎΠ΄', 'Π£Π»ΠΈΡΠ°', 'ΠΠΎΠΌ', 'ΠΠ²Π°ΡΡΠΈΡΠ°']) model = accounting.models.ΠΠ΄ΡΠ΅ΡΠ° for obj in model.objects.all().order_by('id_Π°Π΄ΡΠ΅ΡΠ°'): writer.writerow([ obj.id_Π°Π΄ΡΠ΅ΡΠ°, obj.Π°Π΄ΡΠ΅Ρ.split(',')[0], obj.Π°Π΄ΡΠ΅Ρ.split(',')[1], obj.Π°Π΄ΡΠ΅Ρ.split(',')[2], obj.Π°Π΄ΡΠ΅Ρ.split(',')[3], obj.Π°Π΄ΡΠ΅Ρ.split(',')[4] if len(obj.Π°Π΄ΡΠ΅Ρ.split(',')) > 4 else "" ]) elif res == 'ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="Positions.csv"' writer.writerow(['id Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ for obj in model.objects.all().order_by('id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ'): writer.writerow([obj.id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠ΄Π΅Π½ΠΈΡΡΠΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ': response['Content-Disposition'] = 'attachment; filename="Units.csv"' writer.writerow( ['id Π΅Π΄ΠΈΠ½ΠΈΡΡ ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π‘ΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅ Π½Π°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ΄Π΅Π½ΠΈΡΡΠΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ for obj in model.objects.all().order_by('id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ'): writer.writerow([ obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.ΡΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅_Π½Π°Π·Π²Π°Π½ΠΈΠ΅ ]) elif res == 'ΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="EngineeringUnits.csv"' writer.writerow( ['id Π΅Π΄ΠΈΠ½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΡ Π΅Π΄ΠΈΠ½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ']) model = accounting.models.ΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([ obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ ]) elif res == 'ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="TheNamesOfPiecesOfEquipment.csv"' writer.writerow(['id Π½Π°Π·Π²Π°Π½ΠΈΡ Π΅Π΄Π΅Π½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠΎΠΌΠ½Π°ΡΡ': response[ 'Content-Disposition'] = 'attachment; filename="Apartments.csv"' writer.writerow(['id ΠΊΠΎΠΌΠ½Π°ΡΡ', 'ΠΠΎΠΌΠ΅Ρ ΠΊΠΎΠΌΠ½Π°ΡΡ']) model = accounting.models.ΠΠΎΠΌΠ½Π°ΡΡ for obj in model.objects.all().order_by('id_ΠΊΠΎΠΌΠ½Π°ΡΡ'): writer.writerow([obj.id_ΠΊΠΎΠΌΠ½Π°ΡΡ, obj.Π½ΠΎΠΌΠ΅Ρ_ΠΊΠΎΠΌΠ½Π°ΡΡ]) elif res == 'ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΡ': response['Content-Disposition'] = 'attachment; filename="Kits.csv"' writer.writerow( ['id ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°', 'Π Π°Π±ΠΎΡΠ΅Π΅ ΠΌΠ΅ΡΡΠΎ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅ ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°']) model = accounting.models.ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΡ for obj in model.objects.all().order_by('id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°'): writer.writerow([ obj.id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ° ]) elif res == 'ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°': response[ 'Content-Disposition'] = 'attachment; filename="TitlesOfKit.csv"' writer.writerow(['id Π½Π°Π·Π²Π°Π½ΠΈΡ ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ° for obj in model.objects.all().order_by('id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°'): writer.writerow([obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠΎΠ΄Π΅Π»ΠΈΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="ModelsTechniques.csv"' writer.writerow( ['id ΠΌΠΎΠ΄Π΅Π»ΠΈ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 'Π’ΠΈΠΏΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ']) model = accounting.models.ΠΠΎΠ΄Π΅Π»ΠΈΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([ obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ, obj.id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ ]) elif res == 'ΠΠ°ΠΊΠ»Π°Π΄Π½ΡΠ΅': response['Content-Disposition'] = 'attachment; filename="Overhead.csv"' writer.writerow( ['id Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΡΠ° ΠΏΠΎΡΡΠ°Π²ΠΊΠΈ', 'ΠΠΎΡΡΠ°Π²ΡΠΈΠΊ', 'ΠΠΎΠΌΠ΅Ρ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ']) model = accounting.models.ΠΠ°ΠΊΠ»Π°Π΄Π½ΡΠ΅ for obj in model.objects.all().order_by('id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([ obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.Π΄Π°ΡΠ°_ΠΏΠΎΡΡΠ°Π²ΠΊΠΈ, obj.id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°, obj.Π½ΠΎΠΌΠ΅Ρ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ ]) elif res == 'ΠΠΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ': response[ 'Content-Disposition'] = 'attachment; filename="SoftwareInvoice.csv"' writer.writerow([ 'id ΠΏΠΏ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΠΊΠ»Π°Π΄Π½Π°Ρ', 'ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠΉ ΠΏΡΠΎΠ΄ΡΠΊΡ', 'Π¦Π΅Π½Π° Π·Π° Π΅Π΄Π΅Π½ΠΈΡΡ', 'ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ' ]) model = accounting.models.ΠΠΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ for obj in model.objects.all().order_by('id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([ obj.id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_ΠΏΠΏ, obj.ΡΠ΅Π½Π°_Π·Π°_Π΅Π΄Π΅Π½ΠΈΡΡ, obj.ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ]) elif res == 'ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠ΅ΠΡΠΎΠ΄ΡΠΊΡΡ': response['Content-Disposition'] = 'attachment; filename="Software.csv"' writer.writerow([ 'id ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΡΠΊΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π’ΠΈΠΏΠ° ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΡΠΊΡΠ°' ]) model = accounting.models.ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠ΅ΠΡΠΎΠ΄ΡΠΊΡΡ for obj in model.objects.all().order_by('id_ΠΏΠΏ'): writer.writerow([obj.id_ΠΏΠΏ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_ΡΠΈΠΏΠ°_ΠΏΠΏ]) elif res == 'ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="Producers.csv"' writer.writerow(['id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ for obj in model.objects.all().order_by('id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ'): writer.writerow([obj.id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π Π°Π±ΠΎΡΠΈΠ΅ΠΌΠ΅ΡΡΠ°': response[ 'Content-Disposition'] = 'attachment; filename="Workplaces.csv"' writer.writerow( ['id ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ ΠΌΠ΅ΡΡΠ°', 'ΠΠΎΠΌΠ½Π°ΡΠ°', 'ΠΠΎΠΌΠ΅Ρ ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ ΠΌΠ΅ΡΡΠ°']) model = accounting.models.Π Π°Π±ΠΎΡΠΈΠ΅ΠΌΠ΅ΡΡΠ° for obj in model.objects.all().order_by('id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°'): writer.writerow([ obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, obj.id_ΠΊΠΎΠΌΠ½Π°ΡΡ, obj.Π½ΠΎΠΌΠ΅Ρ_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ° ]) elif res == 'Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="Employee.csv"' writer.writerow([ 'id ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°', 'Π€Π°ΠΌΠΈΠ»ΠΈΡ', 'ΠΠΌΡ', 'ΠΡΡΠ΅ΡΡΠ²ΠΎ', 'ΠΠ°ΡΠ° ΡΠΎΠΆΠ΄Π΅Π½ΠΈΡ', 'ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΡ', 'Π Π°Π±ΠΎΡΠ΅Π΅ ΠΌΠ΅ΡΡΠΎ', 'ΠΠΎΠ»', 'Π’Π΅Π»Π΅ΡΠΎΠ½', 'ΠΠ΄ΡΠ΅ΡΠ°' ]) model = accounting.models.Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°'): writer.writerow([ obj.id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°, obj.ΡΠ°ΠΌΠΈΠ»ΠΈΡ, obj.ΠΈΠΌΡ, obj.ΠΎΡΡΠ΅ΡΡΠ²ΠΎ, obj.Π΄Π°ΡΠ°_ΡΠΎΠΆΠ΄Π΅Π½ΠΈΡ, obj.id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ, obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, "ΠΌΡΠΆΡΠΊΠΎΠΉ" if obj.ΠΏΠΎΠ» == 'ΠΌ' else "ΠΆΠ΅Π½ΡΠΊΠΈΠΉ", obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.id_Π°Π΄ΡΠ΅ΡΠ° ]) elif res == 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΡ': response[ 'Content-Disposition'] = 'attachment; filename="Write-off.csv"' writer.writerow( ['id ΡΠΏΠΈΡΠ°Π½ΠΈΡ', 'ΠΠ°ΡΠ° ΡΠΏΠΈΡΠ°Π½ΠΈΡ', 'Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊ', 'ΠΠ°Π³ΠΎΠ»ΠΎΠ²ΠΎΠΊ']) model = accounting.models.Π‘ΠΏΠΈΡΠ°Π½ΠΈΡ for obj in model.objects.all().order_by('id_ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅'): writer.writerow( [obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅, obj.Π΄Π°ΡΠ°, obj.id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°, obj.Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΎΠΊ]) elif res == 'Π‘ΠΏΠΈΡΠ°Π½Π½Π°ΡΠ’Π΅Ρ Π½ΠΈΠΊΠ°': response[ 'Content-Disposition'] = 'attachment; filename="DecommissionedEquipment.csv"' writer.writerow([ 'id ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ·Π΅ΠΌΠΏΠ»ΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΠ΅', 'ΠΡΠΈΡΠΈΠ½Π°' ]) model = accounting.models.Π‘ΠΏΠΈΡΠ°Π½Π½Π°ΡΠ’Π΅Ρ Π½ΠΈΠΊΠ° for obj in model.objects.all().order_by('id_ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([ obj.id_ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΡ, obj.ΠΏΡΠΈΡΠΈΠ½Π° ]) elif res == 'Π’Π΅Π»Π΅ΡΠΎΠ½Ρ': response['Content-Disposition'] = 'attachment; filename="Phones.csv"' writer.writerow(['id ΡΠ΅Π»Π΅ΡΠΎΠ½Π°', 'Π’Π΅Π»Π΅ΡΠΎΠ½']) model = accounting.models.Π’Π΅Π»Π΅ΡΠΎΠ½Ρ for obj in model.objects.all().order_by('id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°'): writer.writerow([obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.ΡΠ΅Π»Π΅ΡΠΎΠ½]) elif res == 'Π’Π΅Ρ Π½ΠΈΠΊΠ°ΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ': response[ 'Content-Disposition'] = 'attachment; filename="TechnicianSurface.csv"' writer.writerow([ 'id ΡΠ΅Ρ Π½ΠΈΠΊΠΈ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΠΊΠ»Π°Π΄Π½Π°Ρ', 'ΠΠΎΠ΄Π΅Π»Ρ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ', 'Π¦Π΅Π½Π° Π·Π° Π΅Π΄Π΅Π½ΠΈΡΡ' ]) model = accounting.models.Π’Π΅Ρ Π½ΠΈΠΊΠ°ΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ for obj in model.objects.all().order_by('id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([ obj.id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ, obj.ΡΠ΅Π½Π°_Π·Π°_Π΅Π΄Π΅Π½ΠΈΡΡ ]) elif res == 'Π’ΠΈΠΏΡΠΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΉ': response[ 'Content-Disposition'] = 'attachment; filename="TypesOfOrganizations.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ', 'ΠΠ±Π±ΡΠ΅Π²ΠΈΠ°ΡΡΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΉ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ'): writer.writerow( [obj.id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ, obj.Π°Π±Π±ΡΠ΅Π²ΠΈΠ°ΡΡΡΠ°, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠΠ': response[ 'Content-Disposition'] = 'attachment; filename="TypesOfSoftware.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΠΏΠΏ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠΠ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΠΏΠΏ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΠΏΠΏ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="TypesOfVehicles.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠ£Π»ΠΈΡ': response[ 'Content-Disposition'] = 'attachment; filename="TypesOfStreets.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΡΠ»ΠΈΡΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π‘ΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅ Π½Π°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠ£Π»ΠΈΡ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΡΠ»ΠΈΡΡ'): writer.writerow( [obj.id_ΡΠΈΠΏΠ°_ΡΠ»ΠΈΡΡ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.ΡΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅_Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π£ΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΡΠ΅ΠΠ': response[ 'Content-Disposition'] = 'attachment; filename="InstalledSoftware.csv"' writer.writerow([ 'id ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎ ΠΏΠΏ', 'ΠΏΠΏ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'Π‘Π΅ΡΠΈΠΉΠ½ΡΠΉ_ΠΊΠ»ΡΡ', 'ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ' ]) model = accounting.models.Π£ΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΡΠ΅ΠΠ for obj in model.objects.all().order_by('id_ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎΠΏΠΏ'): writer.writerow([ obj.id_ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎΠΏΠΏ, obj.id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.ΡΠ΅ΡΠΈΠΉΠ½ΡΠΉ_ΠΊΠ»ΡΡ, obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ ]) elif res == 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="Characteristics.csv"' writer.writerow(['id Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'ΠΠ΄ΠΈΠ½ΠΈΡΠ° ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ']) model = accounting.models.Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ'): writer.writerow([ obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ ]) elif res == 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈΠΠΎΠ΄Π΅Π»ΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="CharacteristicsOfModel.csv"' writer.writerow([ 'id Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ ΠΌΠΎΠ΄Π΅Π»ΠΈ', 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠ°', 'ΠΠΎΠ΄Π΅Π»Ρ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ½Π°ΡΠ΅Π½ΠΈΠ΅' ]) model = accounting.models.Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈΠΠΎΠ΄Π΅Π»ΠΈ for obj in model.objects.all().order_by('id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ_ΠΌΠΎΠ΄Π΅Π»ΠΈ'): writer.writerow([ obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ_ΠΌΠΎΠ΄Π΅Π»ΠΈ, obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ, obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅ ]) elif res == 'ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response[ 'Content-Disposition'] = 'attachment; filename="EquipmentItems.csv"' writer.writerow([ 'id ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ΄ΠΈΠ½ΠΈΡΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π²ΠΎΠ΄ΡΠΊΠΎΠΉ ΠΊΠΎΠ΄', 'ΠΠ½Π²Π΅Π½ΡΠ°ΡΠ½ΡΠΉ Π½ΠΎΠΌΠ΅Ρ', 'Π’Π΅Ρ Π½ΠΈΠΊΠ° ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΡΠ° Π³Π°ΡΠ°Π½ΡΠΈΠΈ', 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΠ΅' ]) model = accounting.models.ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([ obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π·Π°Π²ΠΎΠ΄ΡΠΊΠΎΠΉ_ΠΊΠΎΠ΄, obj.ΠΈΠ½Π²Π΅Π½ΡΠ°ΡΠ½ΡΠΉ_Π½ΠΎΠΌΠ΅Ρ, obj.id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.Π΄Π°ΡΠ°_Π³Π°ΡΠ°Π½ΡΠΈΠΈ, obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΡ ]) return response
distribution_y = norm(0, 70) distribution_z = norm(0, 0) elif option == 'flat_vertical': distribution_x = norm(0, 50) distribution_y = norm(0, 0) distribution_z = norm(0, 90) elif option == 'tube': distribution_x = norm(0, 50) distribution_y = distribution_x distribution_z = norm(0, 90) else: distribution_x = norm(0, 80) distribution_y = norm(0, 80) distribution_z = norm(0, 80) x = distribution_x.rvs(size=num_points) y = distribution_y.rvs(size=num_points) z = distribution_z.rvs(size=num_points) points = zip(x, y, z) return points if __name__ == '__main__': # main() cloud_points = generate_points(10000, 'random') with open('Lidar.csv', 'w', encoding='utf-8', newline='\n') as csv_file: csv_file_writer = writer(csv_file) for point in cloud_points: csv_file_writer.writerow(point) print(f'Done')
import _csv import _sqlite3 writer = _csv.writer(open("out.csv", 'w')) writer.writerow(['name', 'address', 'phone', 'etc']) writer.writerow(['bob', '2 main st', '703', 'yada']) writer.writerow(['mary', '3 main st', '704', 'yada'])
def CSV_W(): with open("test_csv.csv", mode="a", encoding='utf-8') as w_file: file_writer = _csv.writer(w_file, delimiter=",", lineterminator="\r") file_writer.writerow(["tert", "sn"]) w_file.close()
]) print(Name) print(Club) print(Nation) print(League) print(Skills) print(Weak_Foot) print(Intl_Rep) print(Foot) print(Height) print(Weight) print(Revision) print(Def_WR) print(Att_WR) print(Added_on) print(Origin) print(R_Face) print(B_Type) print(Age) with open('result1.csv', 'w', newline='') as file: writer = _csv.writer(file) headers = [ 'Num', 'Name', 'Club', 'Nation', 'League', 'Skills', 'Weak_Foot', 'Intl.Rep', 'Foot', 'Height', 'Weight', 'Revision', 'Def_WR', 'Att_WR', 'Added_on', 'Origin', 'R.Face', 'B.Type', 'Age' ] writer.writerow(headers) for data in datas: writer.writerow(data)
# and then write to different table specified by the user. # Arguments: # sys.argv[1] - project's base folder where the project files are located # sys.argv[2] - output folder of the project where the RunTimes.csv is located # sys.argv[3] - the list of jobs have been executed in the project # sys.argv[4] - user-defined output table name + .csv # sys.argv[5..] - Other arguments specified in the RVX file import sys import _csv import math ifile = open(sys.argv[2] + "RunTimes.csv", "rt") reader = _csv.reader(ifile) ofile = open(sys.argv[2] + sys.argv[4], "wb") writer = _csv.writer(ofile) rownum = 0 timelist = [] for row in reader: # Save header row. if rownum == 0: header = row[0:3] header.append("CpuTime") writer.writerow(header) else: time = [float(t) for t in row[5:]] seconds = time[0] * 3600 + time[1] * 60 + time[2] timelist.append(seconds) temprow = row[0:3] temprow.append(seconds)
def sample_page(request, model_title): res = "" for i in accounting.models.__dict__.keys(): if i.lower() == model_title: res = i break response = HttpResponse(content_type='text/csv') writer = csv.writer(response) if res == 'ΠΠΎΡΡΠ°Π²ΡΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="Providers.csv"' writer.writerow(['id ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°', 'Π’ΠΈΠΏ ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ', 'Π’Π΅Π»Π΅ΡΠΎΠ½', 'ΠΠ΄ΡΠ΅Ρ', 'ΠΡΡΠ³ΠΈΠ΅ ΠΊΠΎΠ½ΡΠ°ΠΊΡΠ½ΡΠ΅ Π΄Π°Π½Π½ΡΠ΅', 'ΠΠΎΠΌΠΌΠ΅Π½ΡΠ°ΡΠΈΠΉ']) model = accounting.models.ΠΠΎΡΡΠ°Π²ΡΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°'): writer.writerow([obj.id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°, obj.id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ, obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.id_Π°Π΄ΡΠ΅ΡΠ°, obj.Π΄ΡΡΠ³ΠΈΠ΅_ΠΊΠΎΠ½ΡΠ°ΠΊΡΠ½ΡΠ΅_Π΄Π°Π½Π½ΡΠ΅, obj.ΠΊΠΎΠΌΠΌΠ΅Π½ΡΠ°ΡΠΈΠΉ]) elif res == 'ΠΠ΄ΡΠ΅ΡΠ°': response['Content-Disposition'] = 'attachment; filename="Address.csv"' writer.writerow(['id Π°Π΄ΡΠ΅ΡΠ°', 'Π‘ΡΡΠ°Π½Π°', 'ΠΠΎΡΠΎΠ΄', 'Π£Π»ΠΈΡΠ°', 'ΠΠΎΠΌ', 'ΠΠ²Π°ΡΡΠΈΡΠ°']) model = accounting.models.ΠΠ΄ΡΠ΅ΡΠ° for obj in model.objects.all().order_by('id_Π°Π΄ΡΠ΅ΡΠ°'): writer.writerow([obj.id_Π°Π΄ΡΠ΅ΡΠ°, obj.Π°Π΄ΡΠ΅Ρ.split(',')[0], obj.Π°Π΄ΡΠ΅Ρ.split(',')[1], obj.Π°Π΄ΡΠ΅Ρ.split(',')[2], obj.Π°Π΄ΡΠ΅Ρ.split(',')[3], obj.Π°Π΄ΡΠ΅Ρ.split(',')[4] if len(obj.Π°Π΄ΡΠ΅Ρ.split(',')) > 4 else ""]) elif res == 'ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ': response['Content-Disposition'] = 'attachment; filename="Positions.csv"' writer.writerow(['id Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ for obj in model.objects.all().order_by('id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ'): writer.writerow([obj.id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠ΄Π΅Π½ΠΈΡΡΠΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ': response['Content-Disposition'] = 'attachment; filename="Units.csv"' writer.writerow(['id Π΅Π΄ΠΈΠ½ΠΈΡΡ ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π‘ΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅ Π½Π°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ΄Π΅Π½ΠΈΡΡΠΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ for obj in model.objects.all().order_by('id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ'): writer.writerow([obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.ΡΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅_Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="EngineeringUnits.csv"' writer.writerow(['id Π΅Π΄ΠΈΠ½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΡ Π΅Π΄ΠΈΠ½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ']) model = accounting.models.ΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ]) elif res == 'ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="TheNamesOfPiecesOfEquipment.csv"' writer.writerow(['id Π½Π°Π·Π²Π°Π½ΠΈΡ Π΅Π΄Π΅Π½ΠΈΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠ΄Π΅Π½ΠΈΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠΎΠΌΠ½Π°ΡΡ': response['Content-Disposition'] = 'attachment; filename="Apartments.csv"' writer.writerow(['id ΠΊΠΎΠΌΠ½Π°ΡΡ', 'ΠΠΎΠΌΠ΅Ρ ΠΊΠΎΠΌΠ½Π°ΡΡ']) model = accounting.models.ΠΠΎΠΌΠ½Π°ΡΡ for obj in model.objects.all().order_by('id_ΠΊΠΎΠΌΠ½Π°ΡΡ'): writer.writerow([obj.id_ΠΊΠΎΠΌΠ½Π°ΡΡ, obj.Π½ΠΎΠΌΠ΅Ρ_ΠΊΠΎΠΌΠ½Π°ΡΡ]) elif res == 'ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΡ': response['Content-Disposition'] = 'attachment; filename="Kits.csv"' writer.writerow(['id ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°', 'Π Π°Π±ΠΎΡΠ΅Π΅ ΠΌΠ΅ΡΡΠΎ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅ ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°']) model = accounting.models.ΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΡ for obj in model.objects.all().order_by('id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°'): writer.writerow([obj.id_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°]) elif res == 'ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°': response['Content-Disposition'] = 'attachment; filename="TitlesOfKit.csv"' writer.writerow(['id Π½Π°Π·Π²Π°Π½ΠΈΡ ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΠ°Π·Π²Π°Π½ΠΈΡΠΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ° for obj in model.objects.all().order_by('id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°'): writer.writerow([obj.id_Π½Π°Π·Π²Π°Π½ΠΈΡ_ΠΊΠΎΠΌΠΏΠ»Π΅ΠΊΡΠ°, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'ΠΠΎΠ΄Π΅Π»ΠΈΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="ModelsTechniques.csv"' writer.writerow(['id ΠΌΠΎΠ΄Π΅Π»ΠΈ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 'Π’ΠΈΠΏΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ']) model = accounting.models.ΠΠΎΠ΄Π΅Π»ΠΈΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ, obj.id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ]) elif res == 'ΠΠ°ΠΊΠ»Π°Π΄Π½ΡΠ΅': response['Content-Disposition'] = 'attachment; filename="Overhead.csv"' writer.writerow(['id Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΡΠ° ΠΏΠΎΡΡΠ°Π²ΠΊΠΈ', 'ΠΠΎΡΡΠ°Π²ΡΠΈΠΊ', 'ΠΠΎΠΌΠ΅Ρ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ']) model = accounting.models.ΠΠ°ΠΊΠ»Π°Π΄Π½ΡΠ΅ for obj in model.objects.all().order_by('id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.Π΄Π°ΡΠ°_ΠΏΠΎΡΡΠ°Π²ΠΊΠΈ, obj.id_ΠΏΠΎΡΡΠ°Π²ΡΠΈΠΊΠ°, obj.Π½ΠΎΠΌΠ΅Ρ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ]) elif res == 'ΠΠΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ': response['Content-Disposition'] = 'attachment; filename="SoftwareInvoice.csv"' writer.writerow(['id ΠΏΠΏ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΠΊΠ»Π°Π΄Π½Π°Ρ', 'ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠΉ ΠΏΡΠΎΠ΄ΡΠΊΡ', 'Π¦Π΅Π½Π° Π·Π° Π΅Π΄Π΅Π½ΠΈΡΡ', 'ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ']) model = accounting.models.ΠΠΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ for obj in model.objects.all().order_by('id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([obj.id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_ΠΏΠΏ, obj.ΡΠ΅Π½Π°_Π·Π°_Π΅Π΄Π΅Π½ΠΈΡΡ, obj.ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ]) elif res == 'ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠ΅ΠΡΠΎΠ΄ΡΠΊΡΡ': response['Content-Disposition'] = 'attachment; filename="Software.csv"' writer.writerow(['id ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΡΠΊΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π’ΠΈΠΏΠ° ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΠΎΠ³ΠΎ ΠΏΡΠΎΠ΄ΡΠΊΡΠ°']) model = accounting.models.ΠΡΠΎΠ³ΡΠ°ΠΌΠΌΠ½ΡΠ΅ΠΡΠΎΠ΄ΡΠΊΡΡ for obj in model.objects.all().order_by('id_ΠΏΠΏ'): writer.writerow([obj.id_ΠΏΠΏ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_ΡΠΈΠΏΠ°_ΠΏΠΏ]) elif res == 'ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ': response['Content-Disposition'] = 'attachment; filename="Producers.csv"' writer.writerow(['id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.ΠΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»ΠΈ for obj in model.objects.all().order_by('id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ'): writer.writerow([obj.id_ΠΏΡΠΎΠΈΠ·Π²ΠΎΠ΄ΠΈΡΠ΅Π»Ρ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π Π°Π±ΠΎΡΠΈΠ΅ΠΌΠ΅ΡΡΠ°': response['Content-Disposition'] = 'attachment; filename="Workplaces.csv"' writer.writerow(['id ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ ΠΌΠ΅ΡΡΠ°', 'ΠΠΎΠΌΠ½Π°ΡΠ°', 'ΠΠΎΠΌΠ΅Ρ ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ ΠΌΠ΅ΡΡΠ°']) model = accounting.models.Π Π°Π±ΠΎΡΠΈΠ΅ΠΌΠ΅ΡΡΠ° for obj in model.objects.all().order_by('id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°'): writer.writerow([obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, obj.id_ΠΊΠΎΠΌΠ½Π°ΡΡ, obj.Π½ΠΎΠΌΠ΅Ρ_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°]) elif res == 'Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="Employee.csv"' writer.writerow(['id ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°', 'Π€Π°ΠΌΠΈΠ»ΠΈΡ', 'ΠΠΌΡ', 'ΠΡΡΠ΅ΡΡΠ²ΠΎ', 'ΠΠ°ΡΠ° ΡΠΎΠΆΠ΄Π΅Π½ΠΈΡ', 'ΠΠΎΠ»ΠΆΠ½ΠΎΡΡΡ', 'Π Π°Π±ΠΎΡΠ΅Π΅ ΠΌΠ΅ΡΡΠΎ', 'ΠΠΎΠ»', 'Π’Π΅Π»Π΅ΡΠΎΠ½', 'ΠΠ΄ΡΠ΅ΡΠ°']) model = accounting.models.Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°'): writer.writerow([obj.id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°, obj.ΡΠ°ΠΌΠΈΠ»ΠΈΡ, obj.ΠΈΠΌΡ, obj.ΠΎΡΡΠ΅ΡΡΠ²ΠΎ, obj.Π΄Π°ΡΠ°_ΡΠΎΠΆΠ΄Π΅Π½ΠΈΡ, obj.id_Π΄ΠΎΠ»ΠΆΠ½ΠΎΡΡΠΈ, obj.id_ΡΠ°Π±ΠΎΡΠ΅Π³ΠΎ_ΠΌΠ΅ΡΡΠ°, "ΠΌΡΠΆΡΠΊΠΎΠΉ" if obj.ΠΏΠΎΠ» == 'ΠΌ' else "ΠΆΠ΅Π½ΡΠΊΠΈΠΉ", obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.id_Π°Π΄ΡΠ΅ΡΠ°]) elif res == 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΡ': response['Content-Disposition'] = 'attachment; filename="Write-off.csv"' writer.writerow(['id ΡΠΏΠΈΡΠ°Π½ΠΈΡ', 'ΠΠ°ΡΠ° ΡΠΏΠΈΡΠ°Π½ΠΈΡ', 'Π‘ΠΎΡΡΡΠ΄Π½ΠΈΠΊ', 'ΠΠ°Π³ΠΎΠ»ΠΎΠ²ΠΎΠΊ']) model = accounting.models.Π‘ΠΏΠΈΡΠ°Π½ΠΈΡ for obj in model.objects.all().order_by('id_ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅'): writer.writerow([obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΠ΅, obj.Π΄Π°ΡΠ°, obj.id_ΡΠΎΡΡΡΠ΄Π½ΠΈΠΊΠ°, obj.Π·Π°Π³ΠΎΠ»ΠΎΠ²ΠΎΠΊ]) elif res == 'Π‘ΠΏΠΈΡΠ°Π½Π½Π°ΡΠ’Π΅Ρ Π½ΠΈΠΊΠ°': response['Content-Disposition'] = 'attachment; filename="DecommissionedEquipment.csv"' writer.writerow(['id ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ·Π΅ΠΌΠΏΠ»ΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΠ΅', 'ΠΡΠΈΡΠΈΠ½Π°']) model = accounting.models.Π‘ΠΏΠΈΡΠ°Π½Π½Π°ΡΠ’Π΅Ρ Π½ΠΈΠΊΠ° for obj in model.objects.all().order_by('id_ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_ΡΠΏΠΈΡΠ°Π½Π½ΠΎΠΉ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΡ, obj.ΠΏΡΠΈΡΠΈΠ½Π°]) elif res == 'Π’Π΅Π»Π΅ΡΠΎΠ½Ρ': response['Content-Disposition'] = 'attachment; filename="Phones.csv"' writer.writerow(['id ΡΠ΅Π»Π΅ΡΠΎΠ½Π°', 'Π’Π΅Π»Π΅ΡΠΎΠ½']) model = accounting.models.Π’Π΅Π»Π΅ΡΠΎΠ½Ρ for obj in model.objects.all().order_by('id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°'): writer.writerow([obj.id_ΡΠ΅Π»Π΅ΡΠΎΠ½Π°, obj.ΡΠ΅Π»Π΅ΡΠΎΠ½]) elif res == 'Π’Π΅Ρ Π½ΠΈΠΊΠ°ΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ': response['Content-Disposition'] = 'attachment; filename="TechnicianSurface.csv"' writer.writerow(['id ΡΠ΅Ρ Π½ΠΈΠΊΠΈ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΠΊΠ»Π°Π΄Π½Π°Ρ', 'ΠΠΎΠ΄Π΅Π»Ρ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ', 'Π¦Π΅Π½Π° Π·Π° Π΅Π΄Π΅Π½ΠΈΡΡ']) model = accounting.models.Π’Π΅Ρ Π½ΠΈΠΊΠ°ΠΠΎΠΠ°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ for obj in model.objects.all().order_by('id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ'): writer.writerow([obj.id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ, obj.ΡΠ΅Π½Π°_Π·Π°_Π΅Π΄Π΅Π½ΠΈΡΡ]) elif res == 'Π’ΠΈΠΏΡΠΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΉ': response['Content-Disposition'] = 'attachment; filename="TypesOfOrganizations.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ', 'ΠΠ±Π±ΡΠ΅Π²ΠΈΠ°ΡΡΡΠ°', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΉ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΠΎΡΠ³Π°Π½ΠΈΠ·Π°ΡΠΈΠΈ, obj.Π°Π±Π±ΡΠ΅Π²ΠΈΠ°ΡΡΡΠ°, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠΠ': response['Content-Disposition'] = 'attachment; filename="TypesOfSoftware.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΠΏΠΏ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠΠ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΠΏΠΏ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΠΏΠΏ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="TypesOfVehicles.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π’ΠΈΠΏΡΠ£Π»ΠΈΡ': response['Content-Disposition'] = 'attachment; filename="TypesOfStreets.csv"' writer.writerow(['id ΡΠΈΠΏΠ° ΡΠ»ΠΈΡΡ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'Π‘ΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅ Π½Π°Π·Π²Π°Π½ΠΈΠ΅']) model = accounting.models.Π’ΠΈΠΏΡΠ£Π»ΠΈΡ for obj in model.objects.all().order_by('id_ΡΠΈΠΏΠ°_ΡΠ»ΠΈΡΡ'): writer.writerow([obj.id_ΡΠΈΠΏΠ°_ΡΠ»ΠΈΡΡ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.ΡΠΎΠΊΡΠ°ΡΠ΅Π½Π½ΠΎΠ΅_Π½Π°Π·Π²Π°Π½ΠΈΠ΅]) elif res == 'Π£ΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΡΠ΅ΠΠ': response['Content-Disposition'] = 'attachment; filename="InstalledSoftware.csv"' writer.writerow(['id ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎ ΠΏΠΏ', 'ΠΏΠΏ ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'Π‘Π΅ΡΠΈΠΉΠ½ΡΠΉ_ΠΊΠ»ΡΡ', 'ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ']) model = accounting.models.Π£ΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΡΠ΅ΠΠ for obj in model.objects.all().order_by('id_ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎΠΏΠΏ'): writer.writerow([obj.id_ΡΡΡΠ°Π½ΠΎΠ²Π»Π΅Π½Π½ΠΎΠ³ΠΎΠΏΠΏ, obj.id_ΠΏΠΏ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.ΡΠ΅ΡΠΈΠΉΠ½ΡΠΉ_ΠΊΠ»ΡΡ, obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ]) elif res == 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="Characteristics.csv"' writer.writerow(['id Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ', 'ΠΠ°Π·Π²Π°Π½ΠΈΠ΅', 'ΠΠ΄ΠΈΠ½ΠΈΡΠ° ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ']) model = accounting.models.Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ'): writer.writerow([obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ, obj.Π½Π°Π·Π²Π°Π½ΠΈΠ΅, obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΠΈΠ·ΠΌΠ΅ΡΠ΅Π½ΠΈΡ]) elif res == 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈΠΠΎΠ΄Π΅Π»ΠΈ': response['Content-Disposition'] = 'attachment; filename="CharacteristicsOfModel.csv"' writer.writerow(['id Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ ΠΌΠΎΠ΄Π΅Π»ΠΈ', 'Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠ°', 'ΠΠΎΠ΄Π΅Π»Ρ ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ½Π°ΡΠ΅Π½ΠΈΠ΅']) model = accounting.models.Π₯Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈΠΠΎΠ΄Π΅Π»ΠΈ for obj in model.objects.all().order_by('id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ_ΠΌΠΎΠ΄Π΅Π»ΠΈ'): writer.writerow([obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ_ΠΌΠΎΠ΄Π΅Π»ΠΈ, obj.id_Ρ Π°ΡΠ°ΠΊΡΠ΅ΡΠΈΡΡΠΈΠΊΠΈ, obj.id_ΠΌΠΎΠ΄Π΅Π»ΠΈ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π·Π½Π°ΡΠ΅Π½ΠΈΠ΅]) elif res == 'ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ': response['Content-Disposition'] = 'attachment; filename="EquipmentItems.csv"' writer.writerow(['id ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ΄ΠΈΠ½ΠΈΡΠ° ΡΠ΅Ρ Π½ΠΈΠΊΠΈ', 'ΠΠ°Π²ΠΎΠ΄ΡΠΊΠΎΠΉ ΠΊΠΎΠ΄', 'ΠΠ½Π²Π΅Π½ΡΠ°ΡΠ½ΡΠΉ Π½ΠΎΠΌΠ΅Ρ', 'Π’Π΅Ρ Π½ΠΈΠΊΠ° ΠΏΠΎ Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ', 'ΠΠ°ΡΠ° Π³Π°ΡΠ°Π½ΡΠΈΠΈ', 'Π‘ΠΏΠΈΡΠ°Π½ΠΈΠ΅']) model = accounting.models.ΠΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΡΠ’Π΅Ρ Π½ΠΈΠΊΠΈ for obj in model.objects.all().order_by('id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ'): writer.writerow([obj.id_ΡΠΊΠ·Π΅ΠΌΠΏΠ»ΡΡΠ°_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.id_Π΅Π΄Π΅Π½ΠΈΡΡ_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ, obj.Π·Π°Π²ΠΎΠ΄ΡΠΊΠΎΠΉ_ΠΊΠΎΠ΄, obj.ΠΈΠ½Π²Π΅Π½ΡΠ°ΡΠ½ΡΠΉ_Π½ΠΎΠΌΠ΅Ρ, obj.id_ΡΠ΅Ρ Π½ΠΈΠΊΠΈ_ΠΏΠΎ_Π½Π°ΠΊΠ»Π°Π΄Π½ΠΎΠΉ, obj.Π΄Π°ΡΠ°_Π³Π°ΡΠ°Π½ΡΠΈΠΈ, obj.id_ΡΠΏΠΈΡΠ°Π½ΠΈΡ]) return response
from _csv import writer import sys sys.path.append("../") from hw3.solution import run with open("grid.csv", "w+") as f: csv_writer = writer(f) # write header csv_writer.writerow( ["n_epochs", "L", "C", "batch_size", "lr", "training_error"]) for L in [1e6]: for C in [1, 10, 100]: print(L, C) training_error = run( n_epochs=100, L=L, C=C, lr=1e-6, batch_size=2048, ) csv_writer.writerow([1, L, C, 2048, 1e-6, training_error])
while i < len(list_): str_ += str(list_[i]) str_ += " " i += 1 return str_ biggest_id = 0 freed_id = [] is_up_to_date = 1 try: file = open('database.csv', 'r+') except FileNotFoundError: file = open('database.csv', 'w+') writer = _csv.writer(file, delimiter=';') reader = _csv.reader(file, delimiter=';') id_to_person = {} last_name_to_id = {} first_name_to_id = {} patronymic_to_id = {} phone_number_to_id = {} date_of_birth_to_id = {} def print_line(): print("---------------------------------------------------------------------") def write_header():
from __future__ import absolute_import, unicode_literals import _csv import io reader = type(_csv.reader(io.StringIO(''))) writer = type(_csv.writer(io.StringIO()))
# *-coding:utf-8-*- import re import requests import importlib import sys importlib.reload(sys) import _csv with open('C:/Users/yinyy/Desktop/Second_type111.csv','w',newline='') as csvfile: writer =_csv.writer(csvfile) writer.writerow(["gender","type","PRESENCE OF RETINOPATHY","duration","hba1c%","systolic","1_year","5_year","10_year"]) url='http://retinarisk.com/calculator/bout_interactive.php' for PRESENCE in range(0,2): if PRESENCE==0: Static='Yes' #0 else: Static='No' #1 for gender in range(0,2): if gender==0: Static2='Male' #0 else: Static2='Female' #1 for hbac in range(0,13,2): for DURATION in range(0,40,4): for SYSTOLIC in range(60,180,6): header={ 'Accept':'*/*', 'Accept-Encoding':'gzip, deflate', 'Accept-Language':'zh-CN,zh;q=0.8', 'Connection':'keep-alive', 'Content-Length':'143',