Group data by name, count it and make a pie chart

Question

Hello. I need to group data by name, count it and make a pie chart of the percentage share of place names from a given among all names.

Link to my excel file: https://drive.google.com/file/d/1gw5mcu3mJXH0Gg4Q-PnRrxDMFq-6VvDo/view?usp=sharing

import pandas as pd                              
import xlrd                                      
import matplotlib.pyplot as plt                  

data = pd.read_excel("table.xlsx", sheet_name=0)

data.groupby('Woj.')['Nazwa miejscowości'].unique().plot(kind='bar')
plt.show()

Please provide a small set of sample data as text that we can copy and paste. Include the corresponding desired result. Check out the guide on [how to make good reproducible pandas examples](https://stackoverflow.com/a/20159305/3620003). — timgeb, Jun 08 '20 at 15:11
@timgeb https://drive.google.com/file/d/1gw5mcu3mJXH0Gg4Q-PnRrxDMFq-6VvDo/view?usp=sharing — Zarraki, Jun 08 '20 at 15:27
Hi! so you want one pie chart for each name showing the percentage of places? — DavideBrex, Jun 08 '20 at 16:18

DavideBrex · Accepted Answer · 2020-06-08T16:52:20.507

2

I am not sure whether this is what you asked, please let me know in case. First I grouped by the names, and then the pie chart shows the amount of places per each name.

data.groupby("Woj.")["Nazwa miejscowości"].count().plot.pie(figsize=(10,10),autopct='%1.1f%%')

Output:

edited Jun 08 '20 at 16:52

answered Jun 08 '20 at 16:25

DavideBrex

2,374
1
10
23

Yes something like this and it has to shows data in % – Zarraki Jun 08 '20 at 16:47

Group data by name, count it and make a pie chart

1 Answers1

Linked

Related