#!/usr/bin/env python
# -*- coding: utf-8 -*-

import simplejson, pandas

data = simplejson.loads(open('f877UwgO.json').read())
data2=[]
to_del = ['attachments',
'badges',
'checkItemStates',
'closed',
'desc',
'descData',
'due',
'email',
'id',
'idAttachmentCover',
'idBoard',
'idChecklists',
'idLabels',
'idList',
'idMembers',
'idMembersVoted',
'idShort',
'manualCoverAttachment',
'pos',
'shortLink',
'subscribed',
'url',
]

for card in data['cards']:
  for d in to_del:
    if d in card: del card[d]
  card['labels'] = ';'.join([lb['name'] for lb in card['labels']])
  data2.append(card)

df = pandas.DataFrame(data2)
df.to_excel('cards.xlsx')