/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 vote127 views1 answer
Getting Random rows in dataframe
Python
0 vote131 views1 answer
Loading kivy lang
Python
0 vote187 views1 answer
Django optional path parameter
Python Django
5 votes141 views2 answers
How to plot pie chart in python
Python
3 votes96 views1 answer
Colab cuda version
Python
2 votes168 views1 answer
Django orm timestamp field
Python Django
1 vote123 views1 answer
Difference between 2 timestamps pandas
Python
0 vote142 views1 answer
How to get latitude and longitude from address in python
Python
1 vote90 views1 answer
Python replace part in large file
Python
1 vote128 views1 answer
Date difference in minutes in Python
Python

Share