Unable to include column if all rows are zero in pandas crosstab

Question

In pandas crosstab, now I am getting the output as below if the other col contains all zero value:

  0
0 5
1 2

But I need to get an output for the other column even if it contains all zero.

  0 1
0 5 0
1 2 0

I am using below code to create cross tab:

data_crosstab = pd.crosstab(data[df_all.columns[56]],
                                    data[df_all.columns[57]], 
                                       margins = False,dropna=False)

jezrael · Accepted Answer · 2021-07-26 11:51:28Z

4

Use DataFrame.reindex:

#margins=False is default value, so removed
#https://pandas.pydata.org/docs/reference/api/pandas.crosstab.html
data_crosstab = pd.crosstab(data[df_all.columns[56]],
                            data[df_all.columns[57]], dropna=False)

data_crosstab = data_crosstab.reindex(columns=[0,1], fill_value=0)

More general solution:

data_crosstab = data_crosstab.reindex(columns=[0,1],index=[0,1], fill_value=0)

answered Jul 26, 2021 at 11:51

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to include column if all rows are zero in pandas crosstab

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related