Hi I created a pivot table using the below code.
table2M = table2M.pivot(index='Shop', columns='Fruit', values='amout_purchased')
And I get a table like this one
Fruit | apple | orange | banana
Shop | | |
:--------------------------------------------- -:
A | None | 1/3 | 2/5
B | 1/2 | None | 1/9
C | None | None | 1/3
What I would like to do is replace the Nones with a blank space, any idea on how to do this?
Fruit | apple | orange | banana
Shop | | |
:-------------------------------------------------:
A | | 1/3 | 2/5
B | 1/2 | | 1/9
C | | | 1/3