代码之家  ›  专栏  ›  技术社区  ›  Chicken Sandwich No Pickles

靓汤-无法提取表

  •  0
  • Chicken Sandwich No Pickles  · 技术社区  · 4 年前

    我有以下代码:

    import os 
    import re
    from bs4 import BeautifulSoup
    import urllib.request
    #from urllib.request import request, urlopen
    #from urllib import request
    import pandas as pd
    import numpy as np
    import datetime
    import time
    import openpyxl
    
    
    for a in range(0,len(symbols),1):
        #ua = UserAgent()
        url = "https://iborrowdesk.com/report/" + symbols[a]
        """
           test urls:
                     https://iborrowdesk.com/report/wmt
        """
    
        print("Extracting Values for " + symbols[a] + ".")
    
        try:
            page = urllib.request.urlopen(url)
            soup = BeautifulSoup(page, "html.parser", from_encoding="iso-8859-1")
    
            value_label_value = soup.find_all('table', {'class': 'table table-condensed table-hover'})
    
    1. 当我打字的时候什么也不会回来 print(value_label_value)
    1 回复  |  直到 4 年前
        1
  •  1
  •   QHarr    4 年前

    数据来自“网络”选项卡中的API调用。您可以按如下方式重新创建表:

    import requests
    import pandas as pd
    
    data = requests.get('https://iborrowdesk.com/api/ticker/wmt').json()
    df = pd.DataFrame(data['real_time'])
    df