我有一个熊猫数据框,如下所示:
Group id Count
G1 412 52
G1 413 34
G2 412 2832
G2 413 314我正在尝试用Python构建一个饼图-对于每个Group和id,我需要显示各自的计数。它应该有两个拆分-一个用于组,另一个用于Id。外圆应为Group,内圆应为id。只是从可视化开始,想知道是否有python库可以做到这一点。
是否可以使用条形图来实现此要求?
发布于 2017-07-05 06:15:23
以下是使用pyexcel和pyexcel-pygal时所需的内容
>>> import pyexcel as p
>>> sheet = p.get_sheet(file_name='test.csv', delimiter='\t')
>>> sheet
test.csv:
+-------+-----+-------+
| Group | id | Count |
+-------+-----+-------+
| G1 | 412 | 52 |
+-------+-----+-------+
| G1 | 413 | 34 |
+-------+-----+-------+
| G2 | 412 | 2832 |
+-------+-----+-------+
| G2 | 413 | 314 |
+-------+-----+-------+
>>> sheet.transpose()
>>> sheet
test.csv:
+-------+-----+-----+------+-----+
| Group | G1 | G1 | G2 | G2 |
+-------+-----+-----+------+-----+
| id | 412 | 413 | 412 | 413 |
+-------+-----+-----+------+-----+
| Count | 52 | 34 | 2832 | 314 |
+-------+-----+-----+------+-----+
>>> sheet.name_rows_by_column(0)
>>> sheet.row['Group']
['G1', 'G1', 'G2', 'G2']
>>> p.save_as(array=[sheet.row['Group'], sheet.row['Count']], dest_chart_type='pie', dest_file_name='group_pie.svg')

>>> p.save_as(array=[sheet.row['id'], sheet.row['Count']], dest_chart_type='pie', dest_file_name='id_pie.svg')

https://stackoverflow.com/questions/39353072
复制相似问题