Pandas Pivot Table Column with empty value do not show

user_1862965 0
Viewed 2518

I need your help:

I have dataframe d3:

dataframe

i am using pivot_table

df4 = df3.pivot_table(index = ['Number','Department','Task'], columns="Date", values="Score",fill_value = 'N/A')

output d4 looks like:

enter image description here

why is not showing rows where Task empty is. What i am doing wrong?

I would like to create dataframe like this:

enter image description here

pandas pivot-table python
1 Answers

I think here is necessary replace misisng values before pivot_table:

cols = ['Number','Department','Task']
df[cols] = df[cols].fillna('N/A')
user_29010020
Related