Changing a script to hide columns where the Total = 0
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 35/100
Research direction
Start by opening HolidayReport3.ipynb and running it with AugustHolidayGermany.xlsx, then inspect the pivot-table generation and the output in Germany Holiday Report Aug-2025.xlsx. Confirm which columns have a total of zero and verify that the revised report keeps the required output filename while omitting those columns.
Written by the indexing model from the issue text.
Description
I have a piece of code which extracts information from an Excel file of Holidays that are approved. The filter is approved holidays from existing Employees.
The script creates a Pivot table of names, against dates and how many days approved per leave (sick leave, unpaid, birthday...etc) but some of the columns are displayed as 0. I would like an If statement to hide these columns.
I have supplied Test data - AugustHolidayGermany
The Output filename has to remain the same - Germany Holiday Report Aug-2025
- Dominant language
- Python
- Stars
- 35.4k
- Forks
- 12.9k
- Avg merge
- 2h 37m
- Merged PRs (30d)
- 1
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from geekcomputers/Python
-
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
geekcomputers/Python#3205 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
geekcomputers/Python#3188 · 3 comments ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
geekcomputers/Python#3060 · 1 comment ·
-
[BUG] shapchat Open
Difficulty 5/5 Over a week Newbie friendliness 10/100
geekcomputers/Python#3214 · 5 comments ·
-
Test of an Issue Open
Difficulty 5/5 Over a week Newbie friendliness 10/100
geekcomputers/Python#3209 · 5 comments ·
All issues in geekcomputers/Python
Similar issues
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
learningequality/ricecooker#747 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
BSData/horus-heresy-3rd-edition#3171 ·
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
run-llama/llama_index#23199 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
KhronosGroup/glTF-Blender-IO#2769 ·