def _string2dataframe(data): sb = io(data) dataFrame = pd.read_csv( sb, # sep=' ', names=('d', 'bin_no')).sort('d') return dataFrame
def _string2dataframe(data): sb = io(data) dataFrame = pd.read_csv(sb, # sep=' ', names=('d', 'bin_no') ).sort('d') return dataFrame
def deleteinfo(self, number, file_path): read = io.io() information = [] information = read.read(information, file_path) for i in information: if i[0] == number: information.remove(i) read.write(information, file_path)
def export(cls, request, *args, **kwargs): page_size = int(request.GET.get('limit')) offset = int(request.GET.get('offset')) filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') date = request.GET.get('date') file_type = request.GET.get('type') date = UDatetime.datetime_str_init(date).date() data, num = DataDAO.get_productopt( date=date, pagination=True, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order, ) # Replace columns product_records = cls.get_products() product_records['name'] = \ product_records['short_product_name'] + ' {' + product_records['product_num'] + '}' product_map = dict(zip(product_records['product_id'], product_records['name'])) columns = ['center_id', 'center_name'] + product_records['product_id'].tolist() data = data.reindex(columns=columns) data.rename(columns=product_map, inplace=True) data['center_id'] = data['center_id'].astype(int) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response['Content-Disposition'] = 'attachment; filename=export.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response['Content-Disposition'] = 'attachment; filename=export.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse(response.read(), content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) response['Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response['Content-Disposition'] = 'attachment; filename=export.json' return response
def startTest(self, test): TestResult.startTest(self, test) # just one buffer for both stdout and stderr self.outputBuffer = io.io() stdout_redirector.fp = self.outputBuffer stderr_redirector.fp = self.outputBuffer self.stdout0 = sys.stdout self.stderr0 = sys.stderr sys.stdout = stdout_redirector sys.stderr = stderr_redirector
def changeinfo(self, number, file_path): read = io.io() information = [] information = read.read(information, file_path) for i in information: if i[0] == number: print u"please input the student's information that you want to change like n:" keyword = raw_input(u"please input what you want:") keyword = keyword + '/n' information[information.index(i)] = keyword.split(" ") read.write(information, file_path)
def getmeta(self): Assert(self.state == META) if not self.readahead: x, y = self.pollmeta(None) while not y: x, y = self.pollmeta(None) file = io.io(self.readahead) errcode, errmsg, headers = self.h.getreply(file) self.state = DATA self.readahead = file.read() return errcode, errmsg, headers
def upload_file(file, size=None): aa = ' ' msize = 200000000 osize = size if size == None: file = file.read() size, file = len(file), io(file) while size > msize: aa += post_data(file.read(msize)) + ' ' size -= msize if size: aa += post_data(file.read(size)) + ' ' return post_data(aa.encode())
async def cbitcmd(self, message): """.cbit <число от 0 до 255""" reply = await message.get_reply_message() if not reply or not reply.file or not "image" in reply.file.mime_type: return await message.edit("<b>Reply to image!</b>") x = utils.get_args_raw(message) x = int(x) if x.isdigit() else 8 if x <= 0 or x >= 256: x = 8 x = 256 // x im = Image.open(io(await reply.download_media(bytes))) w, h = im.size mode = im.mode out = [] await message.edit("<b>Processing...</b>") for bit in list(im.tobytes()): bit = list(range(0, 256 + x, x))[bit // x] out.append(bit) image = Image.frombytes(mode, (w, h), bytes(out)) output = io() image.save(output, "PNG") output.seek(0) await message.delete() await reply.reply(file=output)
def format_directory(self): # XXX Unixism if self.url and self.url[-1] != '/': self.url = self.url + '/' fp = os.popen("ls -l -a %s/. 2>&1" % self.pathname, "r") lines = fp.readlines() fp.close() import io import re from urllib import quote from urllib import urljoin import regsub def escape(s, regsub=regsub): if not s: return "" s = regsub.gsub('&', '&', s) # Must be done first s = regsub.gsub('<', '<', s) s = regsub.gsub('>', '>', s) return s prog = re.compile(self.listing_pattern) data = self.listing_header % { 'url': self.url, 'pathname': escape(self.pathname) } for line in lines: if line[-1] == '\n': line = line[:-1] if prog.match(line) < 0: line = escape(line) + '\n' data = data + line continue mode, middle, name = prog.group(1, 2, 3) rawname = name [mode, middle, name] = map(escape, [mode, middle, name]) href = urljoin(self.url, quote(rawname)) if len(mode) == 10 and mode[0] == 'd' or name[-1:] == '/': if name[-1:] != '/': name = name + '/' if href[-1:] != '/': href = href + '/' line = '%s%s<A HREF="%s">%s</A>\n' % (mode, middle, escape(href), name) data = data + line data = data + self.listing_trailer self.fp = io.io(data) self.headers['content-type'] = 'text/html' self.headers['content-length'] = str(len(data))
def export(request, *args, **kwargs): district = request.GET.getlist('district[]') region = request.GET.getlist('region[]') page_size = request.GET.get('limit') offset = request.GET.get('offset') filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') file_type = request.GET.get('type') pagination = True if page_size: page_size = int(page_size) if offset: offset = int(offset) columns = [ 'center_id', 'center_name', 'region', 'district', ] data, num = TestDAO.get_centers( region, district, columns, pagination=True, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order, ) # data = data.where((pd.notnull(data)), "") #data.columns = map(str.capitalize, data.columns) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response['Content-Disposition'] = 'attachment; filename=export.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response['Content-Disposition'] = 'attachment; filename=export.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse(response.read(), content_type='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet') response['Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response['Content-Disposition'] = 'attachment; filename=export.json' return response
def _string2Dataframe(data, log=True): sb = io(data) dataFrame = pd.read_csv(sb, sep=' ', names=('d', 'amp')).sort_values('d') if log: dataFrame.amp = 10**dataFrame.amp return dataFrame
def export(request, *args, **kwargs): page_size = int(request.GET.get('limit')) offset = int(request.GET.get('offset')) filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') start = request.GET.get('start') end = request.GET.get('end') file_type = request.GET.get('type') product_list = request.GET.getlist('product[]') start = UDatetime.datetime_str_init(start).date() end = UDatetime.datetime_str_init(end, start, default_delta=DEFAULT_RANGE) if type(end) == datetime.datetime: end = end.date() # init product_list product_list_new = [] for product_ids in product_list: product_list_new += product_ids.split(',') data, num = GetEvent.get_event_price_table(start, end, product_list_new, pagination=True, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order) data = data.where((pd.notnull(data)), "") data.columns = map(str.capitalize, data.columns) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=tableExport.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response[ 'Content-Disposition'] = 'attachment; filename=tableExport.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse( response.read(), content_type= 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) response[ 'Content-Disposition'] = 'attachment; filename=tableExport.xlsx' # elif type == 'excel': # writer = pd.ExcelWriter('export.xlsx') # response = data.to_excel(writer) # writer.save() # response = HttpResponse(response, content_type='application/vnd.ms-excel') # response['Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' return response
def addinfo(self, student, file_path): read = io.io() read.add(student, file_path)
def scoresort(self,file_path): read=io.io() information=[] information=read.read(information,file_path) sorted_information=sorted(information,key=lambda student:student[3]) print_stu.printstudent(sorted_information)
def export(request, *args, **kwargs): page_size = request.GET.get('limit') offset = request.GET.get('offset') filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') product = request.GET.get('product') as_of_date = request.GET.get('as_of_date') file_type = request.GET.get('type') as_of_date = UDatetime.datetime_str_init(as_of_date).date() pagination = True if page_size: page_size = int(page_size) if offset: offset = int(offset) if product == 'retail bowling': product_ids = ProductChoice.retail_bowling_ids_new_short elif product == 'retail shoe': product_ids = ProductChoice.retail_shoe_product_ids_new elif product == 'after party friday': product_ids = [ '2146481686', '2146532909', '2146507303', '2146481687' ] elif product: product_ids = [product] else: product_ids = ProductChoice.retail_bowling_ids_new_short data, num = DataDAO.get_centers(pagination=pagination, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order, last_price=True, last_price_product_ids=product_ids, last_price_from_change=True, lastPriceSplit=True, columns=[ 'center_name', 'region', 'district', 'brand', 'time_zone', 'center_type' ], as_of_date=as_of_date) # data = data.where((pd.notnull(data)), "") data.columns = map(str.capitalize, data.columns) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response[ 'Content-Disposition'] = 'attachment; filename=export.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse( response.read(), content_type= 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) response[ 'Content-Disposition'] = 'attachment; filename=export.xlsx' # elif type == 'excel': # writer = pd.ExcelWriter('export.xlsx') # response = data.to_excel(writer) # writer.save() # response = HttpResponse(response, content_type='application/vnd.ms-excel') # response['Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' return response
def export(request, *args, **kwargs): page_size = int(request.GET.get('limit')) offset = int(request.GET.get('offset')) filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') start = request.GET.get('start') end = request.GET.get('end') menu_id = request.GET.get('menu_id') file_type = request.GET.get('type') # Get all selection values category = request.GET.getlist('category') district = request.GET.getlist('district') region = request.GET.getlist('region') center_id = request.GET.getlist('center_id') # Find if all in the selections if category and 'all' in category: category = [] if district and 'all' in district: district = [] if region and 'all' in region: region = [] if center_id and 'all' in center_id: center_id = [] # Remove empty string category = [item for item in category if item] district = [item for item in district if item] region = [item for item in region if item] center_id = [item for item in center_id if item] start = UDatetime.datetime_str_init( start).date() if start else UDatetime.now_local().date() data, num = FoodDataDao.getFoodByCenter(menu_id, start, category, district, region, center_id, pagination=True, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order, download=True) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response[ 'Content-Disposition'] = 'attachment; filename=export.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse( response.read(), content_type= 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) response[ 'Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' return response
def export(cls, request, *args, **kwargs): page_size = int(request.GET.get('limit')) offset = int(request.GET.get('offset')) filters = request.GET.get('filter') sort = request.GET.get('sort') order = request.GET.get('order') date = request.GET.get('date') file_type = request.GET.get('type') date = UDatetime.datetime_str_init(date).date() # Get all selection values sale_region = request.GET.getlist('sale_region[]') territory = request.GET.getlist('territory[]') center_id = request.GET.getlist('center_id[]') center_name = request.GET.getlist('center_name[]') columns = request.GET.getlist('columns[]') # Find if all in the selections if sale_region and 'all' in sale_region: sale_region = [] if territory and 'all' in territory: territory = [] if center_id and 'all' in center_id: center_id = [] if center_name and 'all' in center_name: center_name = [] if columns and 'all' in columns: columns = [] # Remove empty string sale_region = [item for item in sale_region if item] territory = [item for item in territory if item] center_id = [item for item in center_id if item] center_name = [item for item in center_name if item] columns = [item for item in columns if item] data, num = EventDataDao.get_event_RMPS(sale_region, territory, center_id, center_name, columns, pagination=True, page_size=page_size, offset=offset, filters=filters, sort=sort, order=order) # data, num = DataDAO.get_productopt( # date=date, # pagination=True, # page_size=page_size, # offset=offset, # filters=filters, # sort=sort, # order=order, # ) #Replace columns #event_records = cls.get_columns() RMPSObjs = RMPS.objects.filter() RMPSRecords = pd.DataFrame.from_records( RMPSObjs.values('center_id', 'attribute', 'value', 'unit', 'order')) RMPSRecords['attribute'] = \ RMPSRecords['attribute'] + ' {' + RMPSRecords['id'] + '}' #product_map = dict(zip(RMPSRecords['id'], RMPSRecords['attribute'])) #columns = ['center_id', 'center_name', 'sale_region', 'territory', 'arcade_type']\ # + RMPSRecords['id'].tolist() print(RMPSRecords['attribute']) #data = data.reindex(columns=columns) #data.rename(columns=product_map, inplace=True) #data['center_id'] = data['center_id'].astype(int) if file_type == 'json': response = json.dumps(data.to_dict(orient='records'), ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' elif file_type == 'csv': response = data.to_csv(index=False) response = HttpResponse(response, content_type='application/csv') response[ 'Content-Disposition'] = 'attachment; filename=export.csv' elif file_type == 'xlsx': response = io() xlwriter = pd.ExcelWriter(response) data.to_excel(xlwriter, index=False) xlwriter.save() xlwriter.close() response.seek(0) response = HttpResponse( response.read(), content_type= 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' ) response[ 'Content-Disposition'] = 'attachment; filename=export.xlsx' else: response = json.dumps([], ensure_ascii=False) response = HttpResponse(response, content_type='application/json') response[ 'Content-Disposition'] = 'attachment; filename=export.json' return response
def sum_string(content): f = io.io(content) md5sum = sumfile(f) f.close() return md5sum
def selectinfo(self, number, file_path): read = io.io() information = [] information = read.read(information, file_path) print_stu.selectstudent(number, information)
from Command import Command from io import io io = io() def new_run(options, arg): """Adds a new issue with a priority level""" io.new(max(options), arg) new = Command(name="new", aliases="mk,touch", options="12345", usage="[new/mk/touch -[priority] issue]", run=new_run) def edit_run(options, arg): """Edit an issue""" #this one is a bit hacky since I only intended to allow a single argument args = arg.split(' ') priority = max(options) if len(options) != 0 else "" io.edit(args[0], priority, ' '.join(args[1:])) edit = Command( name="edit", aliases="amend, change", options="12345", usage="[edit/amend/change] -[priority] [issue_id] [new description]",
def _string2Dataframe(data, log=True): sb = io(data) dataFrame = pd.read_csv(sb, sep = ' ', names = ('d','amp')).sort('d') if log: dataFrame.amp = 10 ** dataFrame.amp return dataFrame