aRegius

keys = ('id', 'personal_number' ...)
data = [dict(zip(keys, values)) for values in query]

any(len(list(group)) > num for _, group in groupby(word.lower()))

def flatten(items):
	  for i in items:
		    if isinstance(i, Iterable):
			      yield from flatten(i)
		    else:
			      yield i

from itertools import compress


def equal_but_one(data, storage, skip_value=-1):
	  mask = [number != skip_value  for number in data]
	  data_compressed = list(compress(data, mask))
	  return data_compressed in (list(compress(item, mask)) for item in storage)

all(equal_but_one(data, tb) for data in table)

Counter(data[key] for data in all_tickets if data.get(key, None))

from itertools import chain
from random import shuffle
from more_itertools import chunked


sub_sentences = list(chunked(sentence.split(), 3))
shuffle(sub_sentences)
new_sentence = ' '.join(item for item in chain.from_iterable(sub_sentences))

data_dict = dict(enumerate(data, 1))

for key in (2, 6):
    data_dict[key] = {1: data_dict[key], 2: data_dict[key+1]}
    del data_dict[key+1]

data_dict = dict(enumerate(data_dict.values(), 1))