0

the initial dataset is consists of name, type, and count.

{'Name': {0: 'devin',
  1: 'devin',
  2: 'Cals',
  3: 'devin',
  4: 'Cals',
  5: 'Jonas'},
 'Type': {0: 'A', 1: 'B', 2: 'B', 3: 'C', 4: 'A', 5: 'C'},
 'Count': {0: 30, 1: 20, 2: 5, 3: 71, 4: 23, 5: 20}}

enter image description here

Need to convert it to get below desired output. type columns divided into multiple columns and names with no types set values as 0.(Ex: there is no count for Jonas's Type A and B, then fill them as 0's)

enter image description here

domahc
  • 445
  • 2
  • 9

0 Answers0