def get_datasets(self, **kwargs): return [DataSet(label="Elève", color=(64 , 135, 196), data=self.notes_eleve), DataSet(label="Classe", color=(179, 181, 198), data=self.notes_classe)]
def get_datasets(self, user_id): if not self.histogram['data']: self.generate_histogram() user_data = self.generate_user_data( user_id) # needs to be before getting histogram data all_course_data = self.histogram['data'] course_dataset = DataSet( label='# of other students in this mark range', data=all_course_data, borderWidth=1, backgroundColor=rgba(128, 128, 128, 0.3), borderColor=rgba(0, 0, 0, 0.2), ) # course_dataset['stack'] = 'marks' user_dataset = DataSet( label='You', data=user_data, ) # user_dataset['stack'] = 'marks' return [ course_dataset, user_dataset, ]
def get_datasets(self, *args, **kwargs): now = timezone.now() year_ago = now - datetime.timedelta(days=365) events = BaseEvent.objects \ .filter(approved=True, datetime_start__gte=year_ago, datetime_end__lt=now) \ .filter(surveys__isnull=False) \ .distinct() data_services_quality = [] data_customer_would_return = [] for event in events: data = event.surveys.aggregate( Avg('services_quality'), Avg('customer_would_return'), ) data_services_quality.append({ 'x': event.datetime_start.isoformat(), 'y': data['services_quality__avg'] }) data_customer_would_return.append({ 'x': event.datetime_start.isoformat(), 'y': data['customer_would_return__avg'] }) options = {'type': 'line', 'fill': False, 'lineTension': 0} return [ DataSet(label='Services quality', data=data_services_quality, color=(193, 37, 82), **options), DataSet(label='Customer would return', data=data_customer_would_return, color=(106, 150, 31), **options), ]
def get_datasets(self, **kwargs): return [ DataSet(label="My First dataset", color=(179, 181, 198), data=[65, 59, 90, 81, 56, 55, 40]), DataSet(label="My Second dataset", color=(255, 99, 132), data=[28, 48, 40, 19, 96, 27, 100]) ]
def get_datasets(self, *args, **kwargs): max = Item.objects.all().aggregate(Max('item_id'))['item_id__max'] + 1 data = [0 for i in range(0, max - 1)] game_data = GameSave.objects.all() for save in game_data: for item in save.save_items.all(): data[int(item.item_id) - 1] += 1 return [ DataSet(label='Number of times each item has been found', data=data, backgroundColor=[ rgba(229, 80, 89, 0.2), rgba(229, 80, 161, 0.2), rgba(216, 80, 229, 0.2), rgba(134, 80, 229, 0.2), rgba(80, 102, 229, 0.2), rgba(80, 159, 229, 0.2), rgba(80, 221, 229, 0.2), rgba(92, 229, 80, 0.2), rgba(80, 229, 147, 0.2), rgba(160, 190, 216, 0.2), ]) ]
def get_datasets(self, player_id, param): user_somatics_factors = SomaticsFactors.objects.user_params(player_id) if param == "weight": data = [{ 'x': sf.date, 'y': sf.weight } for sf in user_somatics_factors] elif param == "fat": data = [{ 'x': sf.date, 'y': sf.fat } for sf in user_somatics_factors] elif param == "bmi": data = [{ 'x': sf.date, 'y': sf.bmi } for sf in user_somatics_factors] else: data = None return [ DataSet( type='line', label='Time Series', borderColor='black', data=data, ) ]
def get_datasets(self, **kwargs): colors = [ (255, 99, 132), (54, 162, 235), (255, 206, 86), (75, 192, 192), (153, 102, 255), (255, 159, 64), (142, 68, 173), (23, 165, 137), (241, 196, 15), (51, 255, 66), (255, 51, 249) ] dataSetArr = [] def roud_None(y): try: return '%.1f' % round(y, 2) except: None for ydata,label,color in zip(self.ydataArr,self.myLabel,colors[:len(self.myLabel)]): data_i = [] for x,y in zip(self.xdata,ydata): data_i.append({"y": roud_None(y), "x": str(x)}) DataSet_i = DataSet(type='line', label = label, data=data_i, color=color, fill=False) dataSetArr.append(DataSet_i) return dataSetArr
def get_datasets(self, target='ZAR', base='USD', start_date=start_date.strftime("%Y-%m-%d"), end_date=end_date.strftime("%Y-%m-%d")): # Set the title self.title = { 'display': True, 'text': '{} to {} chart between {} and {}.'.format(base, target, start_date, end_date) } # Use a lambda for a switch statement curRate = lambda x, y: {'AUD': y.curencyAUD, 'CAD': y.curencyCAD, 'CHF': y.curencyCHF, 'CNY': y.curencyCNY, 'EUR': y.curencyEUR, 'GBP': y.curencyGBP, 'NZD': y.curencyNZD, 'ZAR': y.curencyZAR, 'USD': 1}[x] historic = rates.objects.filter(date__range=[start_date, end_date]).order_by('-date') # Use list comprehension to get the data data = [{'y': curRate(target, result) / curRate(base, result), 'x': result.date} for result in historic] return [DataSet( type='line', label='Time Series', data=data, borderColor='#0000ff', pointRadius=0, borderWidth=1, backgroundColor='rgba(0, 0, 255, 0.1)', )]
def get_datasets(self, document_id): q1 = MachineTranslationEvaluation.objects. \ filter(translation__source__document_id=document_id, score__lte=0.25).count() q2 = MachineTranslationEvaluation.objects. \ filter(translation__source__document_id=document_id, score__gte=0.25, score__lte=0.5).count() q3 = MachineTranslationEvaluation.objects. \ filter(translation__source__document_id=document_id, score__gte=0.5, score__lte=0.75).count() q4 = MachineTranslationEvaluation.objects. \ filter(translation__source__document_id=document_id, score__gte=0.75).count() total = q1 + q2 + q3 + q4 q1 = q1 * 100.0 / total q2 = q2 * 100.0 / total q3 = q3 * 100.0 / total q4 = q4 * 100.0 / total colors = [COLOR_RED, COLOR_ORANGE, COLOR_YELLOW, COLOR_DARKGREEN] return [ DataSet(data=[q1, q2, q3, q4], label="quality quartiles", backgroundColor=colors) ]
def get_datasets(self, workout_id): cursor = connection.cursor() sql = 'SELECT SUM("rep"),"workout_id","date" FROM "public"."workouts_series"' sql += 'WHERE workout_id=%s' % workout_id sql += 'GROUP BY date, workout_id ORDER BY date' cursor.execute(sql) range_data = cursor.fetchall() print('all data', range_data) range_data = [i[0] for i in range_data] print('only rep', range_data) colors = [ #TODO mettre autant de couleurs que de dates rgba(255, 99, 132, 0.2), rgba(54, 162, 235, 0.2), rgba(255, 206, 86, 0.2), rgba(75, 192, 192, 0.2), rgba(153, 102, 255, 0.2), rgba(255, 99, 132, 0.2), rgba(255, 159, 64, 0.2), rgba(255, 99, 132, 0.2), rgba(153, 102, 255, 0.2), rgba(54, 162, 235, 0.2), ] return [DataSet(label='Bar Chart', data=range_data, borderWidth=1, backgroundColor=colors, borderColor=colors)]
def get_datasets(self, average_score, max_score=1.0): if average_score <= 0.25 * max_score: color = COLOR_RED #red elif average_score < 0.5 * max_score: color = COLOR_ORANGE elif average_score < 0.75 * max_score: color = COLOR_YELLOW elif average_score < 0.9 * max_score: color = COLOR_GREEN else: color = COLOR_DARKGREEN colors = [color, "#eeeeee"] leftover = max_score - average_score return [ DataSet( data=[average_score, leftover], label="Average sentence quality score", backgroundColor=colors, hoverBackgroundColor=colors, ) ]
def get_datasets(self, **kwargs): data = [ { 'y': 45, 'x': '2017-01-31' }, { 'y': 40, 'x': '2017-02-28' }, { 'y': 50, 'x': '2017-03-31' }, { 'y': 30, 'x': '2017-04-30' }, { 'y': 50, 'x': '2017-05-30' }, ] return [ DataSet( data=data, label="Number of hazard event", borderColor='green', fill=False, ) ]
def get_datasets(self, **kwargs): return [ DataSet(color=(60, 170, 20), data=list(self.qs.values_list('chiffre_affaire', flat=True)), label="l'évolution du chiffre d'affaire") ]
def get_datasets(self, **kwargs): return [ DataSet(color=(245, 66, 170), data=list(self.qs.values_list('chiffre_affaire', flat=True)), label="chiffre d'affaire par Categorie") ]
def get_datasets(self, **kwargs): return [ DataSet(label="My DataSet", data=[11, 16, 7, 3, 14], backgroundColor=[ "#FF6384", "#4BC0C0", "#FFCE56", "#E7E9ED", "#36A2EB" ]) ]
def get_datasets(self, **kwargs): factures = Facture.objects.all().values('date').annotate(y=Sum(F("lignes__produit__prix")*F("lignes__qte"),output_field=FloatField())) data=factures.annotate(x=F('date')).values('x','y') return[DataSet( type='line', label='Evaluation du chiffre d\'affaire par jour', data=list(data) )]
def get_datasets(self, **kwargs): return [ DataSet(color=(13, 200, 56), data=list( self.queryset.values_list('chiffre_affaire', flat=True)), label="chiffre d'affaire par Categorie") ]
def get_datasets(self, **kwargs): return [ DataSet(label="le chiffre d'affaire réparti par catégorie de Produit", color=(255, 99, 132), data=self.data ) ]
def get_datasets(self, **kwargs): data = bar_chart_y_labels colors = bar_chart_colors return [ DataSet(data=data, label="My Pie Data", backgroundColor=colors, hoverBackgroundColor=colors) ]
def get_datasets(self, **kwargs): data = [300, 50, 100] colors = ["#FF6384", "#36A2EB", "#FFCE56"] return [ DataSet(data=data, label="My Pie Data", backgroundColor=colors, hoverBackgroundColor=colors) ]
def get_datasets(self, dates): # passed in dict contains the dates and the number describing activity as the value data = [] for date in dates: data.append({'y': dates[date], 'x': date}) return [DataSet( type='line', label='Activity', data=data, )]
def get_datasets(self, **kwargs): data = [10, 20, 30, 40] colors = ["green", "yellow", "orange", "red"] return [ DataSet( data=data, label="Number of risk", backgroundColor=colors, ) ]
def get_datasets(self, **kwargs): data = bar_chart_y_labels colors = bar_chart_colors return [ DataSet(label='Bar Chart', data=data, borderWidth=1, backgroundColor=colors, borderColor=colors) ]
def get_datasets(self, languages): dataset = [] for language in languages: dataset.append(languages[language]) return [ DataSet( label="Repositories", data=dataset, color=(255, 99, 132), ) ]
def get_datasets(self, **kwargs): data = [4900000, 1107890, 1054900, 2787600, 1503300] colors = [ "#116466", "#D9B08C", "#FFCB9A", "#D1E8E2", "#AC3B61" ] return [DataSet(data=data, label="My Pie Data", backgroundColor=colors, hoverBackgroundColor=colors)]
def get_datasets(self, **kwargs): data = [ DataSet(label="Expenses", backgroundColor='rgba(230,71,89, 0.7)', data=[{ 'x': record[0], 'y': record[1] } for record in self.rrlist[0]]), DataSet(label="Income", backgroundColor='rgba(27, 201, 142, 0.7)', data=[{ 'x': record[0], 'y': record[1] } for record in self.rrlist[1]]), DataSet(label="Balance", backgroundColor='rgba(27, 201, 142, 0.7)', data=[{ 'x': record[0], 'y': record[1] } for record in self.rrlist[1]]) ] return data
def get_datasets(self, **kwargs): data = [30, 20, 10, 40] colors = ["green", "blue", "orange", "brown"] return [ DataSet( label="Number of risk by zone", data=data, borderWidth=1, backgroundColor=colors, borderColor=colors, ) ]
def get_datasets(self, **kwargs): data = [{ 'x': randint(1, 10), 'y': randint(1, 25), 'r': randint(1, 10), } for i in range(25)] return [ DataSet(label="First DataSet", data=data, backgroundColor='#FF6384', hoverBackgroundColor='#FF6384') ]
def get_datasets(self, **kwargs): data = self.datas colors = [ rgba(255, 99, 132, 0.2) if val > 0 else rgba(54, 162, 235, 0.2) for val in data ] return [ DataSet(label="영향력", data=data, borderWidth=1, backgroundColor=colors, borderColor=colors) ]
def get_datasets(self, *args, **kwargs): now = timezone.now() year_ago = now - datetime.timedelta(days=365) events = BaseEvent.objects \ .filter(approved=True, datetime_start__gte=year_ago, datetime_end__lt=now) \ .filter(surveys__isnull=False) \ .distinct() data_pricelist_ux = [] data_quote_as_expected = [] data_price_appropriate = [] for event in events: data = event.surveys.aggregate( Avg('pricelist_ux'), # Avg('quote_as_expected'), Avg('price_appropriate'), ) data_pricelist_ux.append({ 'x': event.datetime_start.isoformat(), 'y': data['pricelist_ux__avg'] }) # data_quote_as_expected.append({'x': event.datetime_start.isoformat(), 'y': data['quote_as_expected__avg']}) data_price_appropriate.append({ 'x': event.datetime_start.isoformat(), 'y': data['price_appropriate__avg'] }) options = {'type': 'line', 'fill': False, 'lineTension': 0} return [ DataSet(label='Pricelist UX', data=data_pricelist_ux, color=(193, 37, 82), **options), # DataSet(label='Quote as expected', data=data_quote_as_expected, color=(245, 199, 0), **options), DataSet(label='Price appropriate', data=data_price_appropriate, color=(0, 133, 53), **options), ]