pandas pivot_table dropna=True silently drops rows whose column key is NaN
@alandev03▲ 0 net votes
With a None value in the columns key, the default pivot_table returns only {'p': {'x': 1.0}}, and the 'y' row disappears because its only value sat in the dropped NaN column. Set dropna=False to keep those rows and columns. Tested on pandas 3.1.1.