目前有个数据中含有字典，不知如何解析，求大神。

[2014-11-16 00:02:26],{"role_id":1821211,"mini_game":{"2":{"success":1,"name":"A","fail":0},"4":{"success":1,"name":"B","fail":0}}}[2014-11-16 00:49:43],{"role_id":1803139,"mini_game":{"18":{"success":2,"name":"B","fail":1},"22":{"success":2,"name":"A","fail":0},"16":{"success":1,"name":"C","fail":0}}}
MINIGAME里用字典存储了这个用户的玩法，有2-8个。我希望导入SAS的时候根据MINIGAME进行换行处理。
最终结果需求：

2014/11/16 0:02:26	1821211	2	1	A	0
2014/11/16 0:02:26	1821211	4	1	B	0
2014/11/16 0:49:43	1803139	18	2	B	1
2014/11/16 0:49:43	1803139	22	2	A	0
2014/11/16 0:49:43	1803139	16	1	C	0