应用数据帧中列的函数，该函数使用每行的值作为输入

Question

我正在尝试应用一个函数，该函数从 api.gov 返回业务类型的列表作为输入。为了构建 url，它使用来自熊猫数据帧的沙丘编号。

import pandas as pd
from requests.compat import urljoin, quote_plus
def get_business_types(c):
base_url = 'https://api.data.gov/sam/v1/registrations/'
duns = c['duns_normal']
final_url = base_url + duns + '0000'
request = requests.get(final_url, params=params)
data = request.json()
result  = data['sam_data']['registration']['businessTypes']
return result
duns['business_types'] =duns['duns_normal'].apply(get_business_types)

我有点不清楚duns = c['duns_normal']这是正确的？如何获取沙丘编号以便构建网址？

Answer 1

当您在列上使用apply时，它一次传递一个值。所以下面就足够了。

import pandas as pd
from requests.compat import urljoin, quote_plus
def get_business_types(c):
print(c)
base_url = 'https://api.data.gov/sam/v1/registrations/'
#duns = c['duns_normal']
final_url = base_url + str(c) + '0000'
request = requests.get(final_url, params=params)
data = request.json()
result  = data['sam_data']['registration']['businessTypes']
return result
duns['business_types'] =duns['duns_normal'].apply(get_business_types)