我已经改变了一点代码从this答案。
创建初始数据框的代码：

import pandas as pd
import numpy as np

d = {'id': [1,1,3,1], 
     'name': ["Alex", "Alex", "Alex", "Alex"], 
     'address': ["123,blv" , None, None, None], 
     'age': [None, 13, 24, None], 
     'city': [None, None, "Florida", "Miami"]
}
df = pd.DataFrame(data=d, index=d["id"])
print(df)

字符串
输出量：

id  name  address   age     city
1   1  Alex  123,blv   NaN     None
1   1  Alex     None  13.0     None
3   3  Alex     None  24.0  Florida
1   1  Alex     None   NaN    Miami

型
聚合代码：

def get_notnull(x):
    if x.notnull().any():
        return  x[x.notnull()]
    else:
        return np.nan

aggregation_functions = {'name': 'first', 
                         'address': get_notnull, 
                         'age': get_notnull, 
                         'city': get_notnull
}
df = df.groupby(df['id']).aggregate(aggregation_functions)
print(df)

型
输出量：

name  address   age     city
id                              
1   Alex  123,blv  13.0    Miami
3   Alex      NaN  24.0  Florida

型

(
    df
    .reset_index(drop=True)      # set unique index for eash record
    .drop('id', axis=1)          # exclude 'id' column from processing
    .groupby(df['id'])           # group by 'id'
    .agg(
        # return first non-NA/None value for each column
        lambda s: s.get(s.first_valid_index())
    )
    .reset_index()               # get back the 'id' value for each record
)

字符串
ps.作为选项：

df.replace([None, ''], pd.NA).groupby('id').first().reset_index()

型