+- Python Forum (https://python-forum.io)
+-- Forum: General (https://python-forum.io/forum-1.html)
+--- Forum: News and Discussions (https://python-forum.io/forum-31.html)
+--- Thread: DeNormalizing data (/thread-25603.html)
DeNormalizing data - asifali111 - Apr-05-2020
Hi all,
I am trying to build a logic for de-normalizing the source based on number of max groups. Can anyone please guide me how to achieve this.
sample input:
Name,College
Mo Williams,Alabama
Rondae Hollis-Jefferson,Arizona
Channing Frye,Arizona
Richard Jefferson,Arizona
Stanley Johnson,Arizona
Andre Iguodala,Arizona
James Harden,Arizona State
Bobby Portis,Arkansas
Patrick Beverley,Arkansas
Jeremy Lamb,Connecticut
Kemba Walker,Connecticut
Charlie Villanueva,Connecticut
Andre Drummond,Connecticut
Kyle Korver,Creighton
Doug McDermott,Creighton
Anthony Tolliver,Creighton
expected output:
College,col1,col2,col3,col4,col5
Alabama,Mo Williams,null,null,null,null
Arizona,Rondae Hollis-Jefferson,Channing Frye,Richard Jefferson,Stanley Johnson,Andre Iguodala
Arizona State,James Harden,null,null,null,null
Arkansas,Bobby Portis,Patrick Beverley,null,null,null
Connecticut,Jeremy Lamb,Kemba Walker,Charlie Villanueva,Andre Drummond,null
Creighton,Kyle Korver,Doug McDermott,Anthony Tolliver,null,null
Thanks
Ali
RE: DeNormalizing data - ndc85430 - Apr-05-2020
What have you tried?
Also, why is this in "News and Discussions"?