Пересортировка CSV файла по датам

import re
import json
s = '''
14,01.01.2000,1
14,01.02.2000,11
14,01.03.2000,154
32,01.01.2000,41
32,01.02.2000,144
32,01.03.2000,112
52_k,01.01.2000,121
52_k,01.02.2000,114
52_k,01.03.2000,141
'''
pattern = re.compile('\d{2}\.\d{2}\.\d{4}')
d = {}
for i in s.split('\n'):
    match = re.search(pattern,i)
    if match:
        key = match[0]
        if not key in d:
            d[key] = []
        t = re.sub(key,'',i)
        l = [ j for j in t.split(',') if j]
        for i in l:
            if not i in d[key]:
                d[key].append(i)
            
print(json.dumps(d))

s = '''
14,01.01.2000,1
14,01.02.2000,11
14,01.03.2000,154
32,01.01.2000,41
32,01.02.2000,144
32,01.03.2000,112
52_k,01.01.2000,121
52_k,01.02.2000,114
52_k,01.03.2000,141
'''
import sqlite3
conn = sqlite3.connect(':memory:')
cur = conn.cursor()
cur.execute('create table tbl(date text,idx text, value text)') 
for i in s.strip().split('\n'):
    idx, date, value = i.strip().split(',')
    cur.execute('insert into tbl values(?,?,?)',(date,idx,value,))
    conn.commit()
cur.execute('select * from tbl order by date')
for i in cur: print(*i)

dates = []
cur.execute('select date from tbl')
for i in cur: 
    d = i[0]
    if not d in dates: dates.append(d)
 
idxs = []
cur.execute('select idx from tbl')
for i in cur: 
    idx = i[0]
    if not idx in idxs: idxs.append(idx)
 
out = []
for date in dates:
    t =[date]
    for idx in idxs:
        cur.execute('select value from tbl where date=? and idx=?',(date,idx,))
        for line in cur:
            t.append(line[0])
    out.append(t)
hdr =['date'] + idxs
print(hdr)
for i in out: print(i)