Extract Tables from a Web Page in Python 


import pandas as pd
xfiles = pd.read_html("https://en.wikipedia.org/wiki/List_of_The_X-Files_episodes")
print(xfiles) # prints all the tables on the page as list
print(type(xfiles))
print(len(xfiles))
print(xfiles[1]) # table of season 1
print(xfiles[12]) # table of season 10

Comments

Post a Comment

Write something to CodeWithAbdur!

Popular posts from this blog

Quotation marks to wrap an element in HTML

In HTML, quotation marks can be used to wrap an element, providing visual emphasis and indicating that the enclosed content represents a quotation.  This styling technique enhances the presentation of quoted text on web pages. Setting default quotation marks: To set quotation marks to wrap an element in HTML, you can use the `quotes` CSS property along with the `content` property to specify the quotation marks to be used (the below example uses the default quotes value, so it is not mentioned as can be seen). Here's how it can be achieved: /* Define the quotation marks */ .q:before { content: open-quote; } .q:after { content: close-quote; } In this CSS: - `open-quote` represents the opening quotation mark. - `close-quote` represents the closing quotation mark. Now, you can apply the `.q` class to elements where you want to set quotation marks: <p class="q">This is a quoted text.</p> This will render as: “ This is a quoted...
Read more

Using insertAdjacentHTML instead of innerHTML to avoid XSS attacks

Using insertAdjacentHTML is a great way to dynamically insert HTML while being more cautious about XSS vulnerabilities. Here’s how you can create and insert the table using insertAdjacentHTML : HTML Setup First, ensure you have an empty container in your HTML where the table will be inserted: <div id="table-container"></div> JavaScript to Insert the Table const tableHTML = ` <table border="1"> <tr> <th>Static Properties</th> <th>Instance Properties</th> </tr> <tr> <td>Defined on the class itself</td> <td>Defined on each instance of the class</td> </tr> <tr> <td>Accessed using <code>ClassName.propertyName</code></td> <td>Accessed using <code>instance.propertyName</code></td> </tr> <tr> <td>Shared across all instances</td> ...
Read more

Guess The Number Game - You vs. Your Friend

Guess a Random Number Game import random print("\nWelcome to the Guess a random number Game!") print("Its a 2 player game.") print("The Winner is the one with the lowest attempts.\n") lower_limit = int(input("Plz choose the lower limit? ")) upper_limit = int(input("Plz choose the upper limit? ")) winner = [] for i in range(2): random_number = random.randint(lower_limit, upper_limit) print(f"\nIts player {i+1} turn:") guess_number = "" attempts = 0 while guess_number != random_number: attempts += 1 guess_number = int(input(f"Player {i+1}, Plz guess the number between {lower_limit} and {upper_limit}: ")) if guess_number < random_number: print("Plz choose higher number") elif guess_number > random_number: print("Plz choose lower number") else: print(f"Player {i+1}, You correctly...
Read more