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),
]
