Python: Plot pie chart for every groups in Pandas
Gautam Mishra
Below is the data frame retrieved after grouping my data set:
df1 = data.groupby(['gender','Segment']).agg(Total_Claim = ('claim_amount', 'sum'))
df1['Total_Claim']=df1['Total_Claim'].astype(int)
df1
The output of the same is:
Total_Claim
gender Segment
Female Gold 2110094
Platinum 2369761
Silver 1897617
Male Gold 2699208
Platinum 2096489
Silver 2347217
What would be the most efficient way of plotting a pie chart between the aggregated value of claim amount based on gender and segment?
jezrael
You can get Series and ploting by Series.plot.pie and autopct parameter for percentages:
df['Total_Claim'].plot.pie(autopct='%1.1f%%')
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Adding the Century to 2-Digit Year
- Next: Combine columns from multiple select queries to make single table
Related
TOP Ranking
- 1
pump.io port in URL
- 2
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
Inner Loop design for webscrapping
- 5
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 6
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)
- 7
Removed zsh, but forgot to change shell back to bash, and now Ubuntu crashes (wsl)
- 8
ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements
- 9
How to run blender on webserver?
- 10
Resetting Value of <input type="time"> in Firefox
- 11
Converting a class method to a property with a backing field
- 12
Ambiguous use of 'init' with CFStringTransform and Swift 3
- 13
Execute ./script.sh with a crontab
- 14
How to set tab order for array of cluster,where cluster elements have different data types in LabVIEW?
- 15
How to pass data to the ng2-bs3-modal?
- 16
Retrieve Element Tag Value XML Using Bash
- 17
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 18
SQL Server : need add a dot before two last character
- 19
Making Array From Page Elements in jQuery
- 20
Laravel's ORM sync with timestamps doesn't update timestamps
- 21
Do animations stop css changes after animation completion?
Comments