Forum Discussion

rahul1's avatar
rahul1
New Member
10 years ago

How to import tables from web?

Hi,   I need to import tables from 110 web links. Is there a way I can write a script to get those tables? I do not want to fetch tables from one link at a time?   Example of the links are as fo...
Need Help
vignesgangboard's avatar
vignesgangboard
New Member
9 years ago
  1. Click the Microsoft Office Button , and then click Open.
  2. In the Look in box, locate the folder where your query file is stored.
  3. Select the Web query that Hadoop Training in Chennai you want to run.
  4. Click Open.
  5. In the Import Data dialog box, do one of the following:
prakashtpt's avatar
prakashtpt
New Member
1 year ago

A: You can import tables from a webpage using various tools or programming languages. One common method is using Python with the pandas library:

import pandas as pd

# Replace the URL with the webpage that contains the table
url = 'https://example.com/tablepage'

# Read all tables from the page
tables = pd.read_html(url)

# Access the first table
df = tables[0]

print(df.head())

Notes:

  • pandas.read_html() works only if the table is in proper HTML <table> format.

  • You may need to install dependencies like lxml or html5lib with pip install lxml html5lib.

Alternatively, for non-programmers, tools like Microsoft Excel or Google Sheets can import web tables:

  • In Excel: Go to Data > From Web, enter the URL, and select the table.

  • In Google Sheets: Use =IMPORTHTML("URL", "table", index).

Visit For more information: https://www.tpointtech.com/python-tutorial