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, 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, 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, **kwargs):
return [{
'data': [m['fuel__count'] for m in self.meters_qs],
# Colors the segments of the chart
'backgroundColor':
[rgba(225, 0, 0),
rgba(0, 225, 0),
rgba(0, 0, 225)]
}]
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, **kwargs):
data = [self.purchases, self.costs, self.losses, self.all_costs, self.sellings, self.balance]
colors = [
rgba(255, 99, 132, 0.2),
rgba(54, 162, 235, 0.2),
rgba(75, 192, 192, 0.2),
rgba(153, 102, 255, 0.2),
]
return [DataSet(label=_('Bar Chart'),
data=data,
borderWidth=1,
backgroundColor=colors,
borderColor=colors)]
def get_datasets(self, **kwargs):
colors = [
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, 159, 64, 0.2)
]
return [
{
'label': ["Battery"],
#'borderColor' : colors,
#'backgroundColor' : colors,
'data': readall(StartDate=g_startdate,EndDate=g_enddate).get('batterytab')},
{
'label': ["Temperature"],
'data': readall(StartDate=g_startdate,EndDate=g_enddate).get('temperaturetab')},
{
'label': ["Humidity"],
'data': readall(StartDate=g_startdate,EndDate=g_enddate).get('humiditytab')},
]
def get_datasets(self, *args, **kwargs):
colors = []
for _ in self.local_data:
red = random.randint(0, 256)
green = random.randint(0, 256)
blue = random.randint(0, 256)
colors.append(rgba(red, green, blue, 0.3))
return [{
'label': self.title,
'data': self.local_data,
'backgroundColor': colors
}]
def get_datasets(self, **kwargs):
this_year = datetime.datetime.today().year
data = [0 for i in range(12)]
colors = [rgba(172, 59, 97, 1) for i in range(12)]
events = Event.objects.filter(start__year = this_year)\
.annotate(month=ExtractMonth('start'))\
.values('month').annotate(c=Count('id'))\
.values('month', 'c')
for event in events:
data[event['month']] = event['c']
return [DataSet(label='Scheduled training count per month',
data=data,
borderWidth=1,
backgroundColor=colors,
borderColor=colors)]
def get_datasets(self, **kwargs):
data = [10, 15, 29, 30, 5, 10, 22]
colors = [
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, 159, 64, 0.2)
]
return [
DataSet(label='Bar Chart',
data=data,
borderWidth=1,
backgroundColor=colors,
borderColor=colors)
]
def get_datasets(self, following_repos):
data = {}
# for each person the user follows
for user in following_repos:
# max number of users represented on the bar chart
if len(data) < 7:
# initial population
data.update({user: following_repos[user]})
else:
# if any more users are found then we check the 6 currently in the dict
for line in data:
# we extract the number of repos they have
current = data[line]
# we get the number of repos the person they follow has
res = following_repos[user]
# if the number of repos the person has happens to be greater than the one in the dict
if res > current:
# we delete that line in the dict
del data[line]
# create a new line in the dict for the person with the most repos
data[follow] = following_repos[follow]
break
return_data = []
for line in data:
self.following.append(line) # get label
return_data.append(data[line]) #get data
colors = [
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, 159, 64, 0.2)
]
return [
DataSet(data=return_data,
borderWidth=1,
backgroundColor=colors,
borderColor=colors)
]
from random import randint
from datetime import datetime, timedelta
from jchart import Chart
from jchart.config import Axes, DataSet, rgba
# Importing data
df = pd.read_csv('data.csv')
# Bar Chart
bar_chart_x_labels = list(set(df['ShopName']))
bar_chart_y_labels = []
bar_chart_colors = []
for i in range(len(bar_chart_x_labels)):
bar_chart_colors.append(
rgba((random.randint(0, 255)), (random.randint(0, 255)),
(random.randint(0, 255)), 5))
x = defaultdict(lambda: 0)
for ind in df.index:
x[df['ShopName'][ind]] += int(df['Quantity'][ind])
for i in bar_chart_x_labels:
bar_chart_y_labels.append(x[i])
class TimeSeriesChart(Chart):
chart_type = 'line'
scales = {
'xAxes': [Axes(type='time', position='bottom')],
}
def get_datasets(self, *args, **kwargs):
data = [{
def get_datasets(self, *args, **kwargs):
calc_level_data = []
max_level = GameSave.objects.all().aggregate(
Max('next_level'))['next_level__max']
if max_level > 15:
max_level = 14
level_data_list = [
GameSave.objects.filter(next_level=i)
for i in range(1, max_level + 1)
]
level_data_list += [GameSave.objects.filter(next_level__gt=max_level)]
for i, level_data in enumerate(level_data_list):
level_time = 0
for data in level_data:
level_time += (data.time.days * 24 + data.time.seconds / 3600)
calc_level_data.append(level_time)
colors = [
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),
rgba(201, 229, 80, 0.2),
rgba(229, 194, 80, 0.2),
rgba(229, 159, 80, 0.2),
rgba(229, 119, 80, 0.2),
rgba(229, 80, 80, 0.2),
]
return [
DataSet(label='Average Time Per Level (Hours)',
data=calc_level_data,
backgroundColor=colors)
]
