利用含PUBCHEM_CID的的csv文件获取assaysummary数据


import pandas as pd
import numpy as np
import os
import sys
import requests

def download(url,file_name):
    s = requests.Session()
    response = s.get(url,stream=True)
    with open(file_name,'ab') as f:
        for item in response.iter_content(chunk_size=512):
            if item:
                f.write(item)

def getCIDfromFILE(file):
    CID = pd.read_csv(file)['PUBCHEM_CID']
    CID = list(CID.dropna().apply(lambda x:int(x)))  # TO be sure CIDS are digits
    return CID  

def getASSAYSUMMARYfromCID(file):
    CID = getCIDfromFILE(file)
    url_list =['https://pubchem.ncbi.nlm.nih.gov/rest/pug/compound/cid/{}/assaysummary/CSV'.format(i) for i in CID]
    for i in url_list:
        download(i,'assaysummary_CSV') 
        print('{} finished'.format(i))# tracing weather procedure is running
    df = pd.read_csv('assaysummary_CSV',sep = ',')
    return df

df = getASSAYSUMMARYfromCID(file)
df=df[df.ix[:,'AID'].map(lambda x:x.isdigit())]# erase 404data and  "columns" of CIDS
df.to_csv(outcome_file.csv) 

#file and outcome_file should be modified by your environment

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值