crosstab output

Val Krem valkrem at yahoo.com
Fri Jan 6 18:26:32 EST 2017

• Previous message (by thread): Using sudo with pip3?
• Next message (by thread): Namedtuples: TypeError: 'str' object is not callable
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

Hi all,
How do I access the rows and columns of a data frame crosstab output?
Here is code using a sample data and output.
a= pd.read_csv("cross.dat", skipinitialspace=True)
xc=pd.crosstab(a['nam'],a['x1'],margins=True)
print(xc)
x1 0 1 
nam 
A1 3 2 
A2 1 4
I want to create a variable by adding 2/(3+2) for the first row(A1)
and 4/(1+4) for the second row (A2)
Final data frame would be
A1 3 2 0.4
A2 1 4 0.8
Thank you in advance

---

• Previous message (by thread): Using sudo with pip3?
• Next message (by thread): Namedtuples: TypeError: 'str' object is not callable
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

---

More information about the Python-list mailing list