/Python/Pivot table but keep nan

Pivot table but keep nan

Pivot table but keep nan

(df.groupby(['Date', 'A']).B
   .apply(lambda x: np.nan if x.isna().all() else x.sum())
   .unstack('A')
)

0

Source: stackoverflow.com

Similar codes

0 vote225 views1 answer
How to create superuser in django heroku
Python Django
2 votes225 views5 answers
Swap keys and values in dictionary python
Python
5 votes204 views1 answer
Rolling average df
Python
1 vote246 views1 answer
Factorial sequence code in python with while loops
Python
1 vote187 views1 answer
How to create obtain any random 3 items of list in python
Python
53 votes214 views3 answers
Abc list python
Python
-1 vote216 views2 answers
Design patterns in python
Python
0 vote196 views1 answer
Python dictionary get keys with condition on value
Python
0 vote218 views1 answer
Convert string input into a nested tuple in python
Python
63 votes183 views3 answers
Iterate through a list
Python

Share