力扣（leetcode）595和1757题（python）

595 大的国家

题目链接: 595.大的国家


解答：

import pandas as pd

def big_countries(world: pd.DataFrame) -> pd.DataFrame:
    ind = world.index[(world.iloc[:,2]>=3000000)|(world.iloc[:,3]>=25000000)]
    world = world.loc[ind]
    return world[['name','population','area']]

1757 可回收且低脂的产品

题目链接: 1757 可回收且低脂的产品


解答：

import pandas as pd

def find_products(products: pd.DataFrame) -> pd.DataFrame:
    return products[(products['low_fats']=='Y')&(products['recyclable']=='Y')][['product_id']]

或者

import pandas as pd

def find_products(products: pd.DataFrame) -> pd.DataFrame:
    ind = products.index[(products.iloc[:,1]=='Y')&(products.iloc[:,2]=='Y')]
    products = products.loc[ind]
    return products[['product_id']]

MySQL解答链接