pandas相关

175. 组合两个表 - 力扣（LeetCode）

左外链接

import pandas as pd

def combine_two_tables(person: pd.DataFrame, address: pd.DataFrame) -> pd.DataFrame:
    combined = person.merge(address, on='personId', how='left')
    columns = ['firstName', 'lastName', 'city', 'state']
    combined = combined[columns]
    return combined

178. 分数排名 - 力扣（LeetCode）

密集排

import pandas as pd

def order_scores(scores: pd.DataFrame) -> pd.DataFrame:
    scores['rank'] = scores['score'].rank(method='dense', ascending=False)
    return scores[['score', 'rank']].sort_values('score', ascending=False)