CODEWITHSUNDEEP
pythonpandaspivot-tablecrosstable
zuma boy
zuma boy

Reputation: 13

How to create separate cross table from list

I want to separate the cross table from single to multiple accprding to the given column list against the last column(CLASS). THE DATA IN THE TABLE LOOKS LIKE

GND  | BRD | ERS | CLASS
 F   |  A  |  AB |  ON
 M   |  D  |  CB |  ON
 M   |  S  |  AV |  ON
 F   |  S  |  AV |  OFF
 M   |  S  |  CB |  ON

This means that the last column against first column, last column agasinst next column

tried

#after loading dataframe
 g = pandas....
 #now
 idx = [g.GND g.BRD, g.ERS]     
    def cross_tb(inx):
        dt = pd.crosstab(inx,   g.CLASS)
        return dt   
    cross_tb(idx)

THIS GIVES SINLE TABLE WHICH LOOK LIKE

       F  M  A  D  S  AB  AV  CB
CLASS                           
OFF    1  0  0  0  1   0   1   0
ON     1  3  1  1  2   1   1   2

But I want to separate them once against CLASS one by one table like

  First one output      
    CLASS OFF ON  PERCENTAGE                          
    F     1   1     20%
    M     0   3     30%
  second output  A AND D etc..

But if you do this

 dt = pd.crosstab(g.GND,   g.CLASS)

it gives single column until you write the line again with other column

Upvotes: 0

Views: 97

Answers (1)

not_speshal
not_speshal

Reputation: 23166

IIUC, you can save the results of the crosstab to a dictionary:

df_dict = {c: pd.crosstab(df[c], df["CLASS"]) for c in df.columns if c!="CLASS"}

>>> df_dict["GND"]
CLASS  OFF  ON
GND           
F        1   1
M        0   3

Upvotes: 0

Related Questions