我有一个包含None
值的数据帧
当我尝试使用first执行groupby时,它不会跳过这些值,并且在对进行分组之前,我无法将它们转换为null
import numpy as np
import pandas as pd
df = pd.DataFrame(np.array([(1, 29),(1, 50),(2, None),(2, 12),(3,None)]),columns=['day', 'amount'])
df.groupby('day')['amount'].first(dropna=True)
我得到错误_cython_agg_general() got an unexpected keyword argument 'dropna
试试这个:
import numpy as np
import pandas as pd
df = pd.DataFrame(np.array([(1, 29),(1, 50),(2, None), (2, 12)]),columns=['day', 'amount'])
df[~df['amount'].isin([None])].groupby('day', dropna=True)['amount'].first()