Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Panda pivot_table questions
#2
I figured out my question #1. Remove index=False in pivot.to_excel(writer, sheet_name='Pivot', index=False).
For #2, the order is in the order I specified when I created another Python scripts. Not sure why.
I will still need help on #3. The Grand Total is incorrect for calculated columns. I also need help on how to have subtotal.
Thanks.
Reply


Messages In This Thread
Panda pivot_table questions - by dee - Jan-06-2023, 11:16 PM
RE: Panda pivot_table questions - by dee - Jan-09-2023, 05:45 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Remove values for weekend in a panda series JaneTan 0 775 Dec-12-2022, 01:50 AM
Last Post: JaneTan
  panda table data kucingkembar 0 1,216 Mar-01-2022, 10:38 PM
Last Post: kucingkembar
  can we write command output to new csv file using Panda package? PythonBeginner_2020 3 2,517 Mar-13-2020, 12:38 PM
Last Post: ndc85430
  Header above a list in Panda sweet_swiss 3 3,096 Aug-12-2018, 11:03 PM
Last Post: scidam
  Discord bot that asks questions and based on response answers or asks more questions absinthium 1 55,387 Nov-25-2017, 06:21 AM
Last Post: heiner55

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020