I don't know how i pivot table in picture one to square matrix in table 2.
Value is distinct count anonymous_id
Want to know how many users join in event voucher denied and item_checkout_started, etc. ?
Thanks!
CodePudding user response：
pivot require 3 argumnts:
- index (anonymous_id) - in this case
- column - Column to use to make new frame’s columns.
- values - Column(s) to use for populating new frame’s values.
df.pivot(index=["anonymous_id"], columns=["list_event_n"],values="at")
CodePudding user response：
Use pd.crosstab, as follows:
pd.crosstab(df['anonymous_id'], df['list_event_n'])
Result:
list_event_n item_checkout_started item_viewed outlet_list_viewed outlet_product_clicked outlet_promo_clicked popup_registered popup_viewed product_clicked product_list_viewed product_searched product_viewed promotion_viewed
anonymous_id
1smryT8ImQLcG2DujbmnSzZPzdv 0 0 0 0 1 0 0 0 0 0 0 0
1sn2WS2DIi6DzM0LEdhKiCjnKkp 0 0 0 0 1 0 0 0 0 0 0 0
1sn6i04LsEI8Cgjzd1BdDW8n9cH 0 0 0 0 0 0 0 0 0 0 1 0
1snHTT4qu5fCsnxRIRiYUD22rH4 0 1 0 0 0 0 0 0 0 0 0 0
1sr24cc1DNqKJBTNQJpDrol4nYf 0 0 0 0 0 0 0 1 0 0 1 0
1t4tA8igP7HwSivoop65QYRAvxi 0 0 0 0 0 0 0 1 0 0 1 0
1tP1HAURwG4NLSkLgM4g4Af35Uq 0 1 0 0 0 0 0 0 0 0 0 0
1uYwjMt8a1BK8UxBSj9oNo4IPTe 0 0 0 0 0 0 0 1 0 0 1 0
1uceWfGy8FOsnX6HQe7kpjAJrZ5 0 0 0 0 1 0 0 0 0 0 0 0
1uci9RelkZpdkjFBxBw5vVXynZU 0 0 1 0 0 0 0 0 0 0 0 0
1ucpPwjhgZBYPA95xcLSncFlwNw 0 0 0 0 0 0 0 1 0 0 0 0
1ud1jmxmhafWrrP1FbHCgyybbyw 1 0 0 0 0 0 0 0 0 0 0 0
1udERAnc6pURTnip0Nqfa5pQj6M 0 0 0 0 0 0 0 1 0 0 1 0
1udXHe8n9yEOsW31HoXkj7sqoZS 0 1 0 0 0 0 0 0 0 0 0 0
1udZEtLATu8JJE2EAA9f4EKLe4f 0 0 0 0 0 1 0 0 0 0 0 0
1udeefhKskfAIOvwOocA11WQdrI 0 0 0 0 0 0 0 0 0 0 0 1
1vDeyvtzt7nw2HDsZ1VNVRwtwbd 0 0 0 1 0 0 0 0 0 0 0 0
1vWphYUZ4D409gulARMXtC7YdQQ 0 0 0 0 0 0 0 0 1 0 0 0
1vuSfCjPH6QIexhzLaKKdicbtUT 0 0 1 0 0 0 0 0 0 0 0 0
1vyXfdd2Mr7hbhrGq3yw6N7KMQo 0 0 0 0 0 0 0 0 1 0 0 0
1w74HleiZygaeHDSleaEhtc8mnw 0 1 0 0 0 0 0 1 1 1 1 0
1w9zFniQSRkvaJ7YJRQPhp6rwxz 0 0 0 0 0 0 0 0 1 1 0 0
1wDA3pCupsaOyAWa1TboNvKCeFe 0 0 0 0 1 0 0 0 0 0 0 0
1wj8KHz1qpoRPNq6EoQjiHLOE6O 0 0 0 0 1 0 0 0 0 0 0 0
1wsndi23SCAl74OgsuuWhlTbFCU 0 0 0 0 0 0 0 0 1 0 0 0
1wtC5W8LmcDOBhtnz78AV3SLe8w 0 1 0 0 0 0 0 1 0 0 1 0
1x1PgyztNXRY8WK1uJlUSXhaNEH 0 0 0 0 0 0 0 0 1 0 0 0
1x4IUPFnGIjAOihWRF4fvbwuWui 0 0 0 0 0 0 0 1 0 0 0 0
1x4nvGRoPvJjjqHpL7zJPXs5b6G 0 0 0 0 0 0 0 1 0 0 1 0
1x71DV1YH6ZT3qWg9xeCvxdDLNP 0 0 0 0 0 0 0 0 1 0 0 0
1x747bftgEmRM8x3tMec86vFeiL 0 1 0 0 1 0 0 0 0 0 0 0
1x74B5iOpJGjEQNJFrUnuWXlDq4 0 1 0 0 0 0 0 0 0 0 0 0
1x7STzNiwMIdKiMqTqImp5dI6oF 0 0 0 0 0 0 0 1 0 0 1 0
1x8iYGv917spLSIyZmpNnp92v7K 0 1 0 0 0 0 0 0 0 0 0 0
1x9gFTiCmx6mNekCnlSXn8M77OY 0 1 0 0 0 0 0 1 0 0 1 0
1x9ydbnHAd7UhictOajeKuhkPNA 0 1 0 0 0 0 0 0 0 0 0 0
1xA3tGb2cXbbiDhDr451CLcbzgc 0 1 0 0 0 0 0 1 0 0 1 0
1xASmsT6YBoKowOfsJhASyxakJP 0 1 0 0 0 0 0 1 0 0 1 0
1xAV7rw5l0Y0ltw9Aq2sRbplEPm 0 0 0 0 0 0 0 1 0 0 1 0
1xAdXudKIkDMLbZa5ytIFVyTU3x 0 1 0 0 0 0 0 1 0 0 1 0
1xAvW0jCqcgV9RgwfCyKsiNRSkY 0 0 0 0 0 0 0 1 0 0 1 0
1xB3866khOLZtxz4OMOU1Eqe8ja 0 0 0 0 1 0 0 0 0 0 0 0
1xB6ysD2TTXnsIRxGyFdiGGf0pu 0 1 0 0 0 0 0 1 0 0 1 0
1xBAgXh8myGoDulNoQBUMYf69AZ 0 1 0 0 0 0 0 0 0 0 0 0
1xBVHy33LvwywFwA2oCFQCR5rs6 0 0 0 0 0 0 1 0 0 0 0 0
1xCWLWYhcYJI6eJEzuzt37MVwrd 0 0 0 0 0 0 0 0 0 0 0 1