jarod_v6--- via Tutor wrote:
Please address your posts to the whole list, not me specifically. I might
read them all the same.
Thank you.
> Thanks s much for the help. I want to obtain table like this:
>
>
>>csv.writer(sys.stdout, delimiter="\t").writerows(table)
>> A100 D33 D34 D35 D36 D37 D38 D39
>>A 5 0 ...
>>B 2 2 ...
>>C 0 ..
>>
> I have tried the pandas way but unfortunately there is many duplicates .
Please show your code in a small self-contained example,
the output it produces, and what exact output you want instead.
Then one of us (not necessarily me) might be able to help you fix it.
> So
> Now I move to create a new file using dictionary and a file with this
> format.
>
> ('A', A100') 5
> ('B', 'A100) 2
>
> I just wondering if there is a pythonic way to do this.
"Pythonic" is elegant idiomatic Python. At this stage I'd settle for
anything that works. Just saying...
> I don't want to use another software if I can
$ cat pivot_demo2.py
import csv
import operator
import sys
from pivot import pivot
data = {
("A", "A100"): 5,
("B", "A100"): 2,
("B", "D33"): 2,
}
table = pivot(
data,
operator.itemgetter(1),
operator.itemgetter(0),
lambda k, data=data: data[k],
empty=0)
csv.writer(sys.stdout, delimiter="\t").writerows(table)
$ python3 pivot_demo2.py
A100 D33
A 5 0
B 2 2
$
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
https://mail.python.org/mailman/listinfo/tutor
