Tuesday, January 24, 2017

Transpose a Column in Pandas

import pandas as pd

d = pd.DataFrame({'state':['CA','MA','NV','CO','CA'], 'id':[100,101,102,103,104]})

for s in d.state:
  d.ix[d.state==s,s] = 1
  d.ix[~(d.state==s),s] = 0

print(d)

No comments:

Post a Comment