Python Forum
Extracting data from a website
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Extracting data from a website
#3
(Jan-08-2021, 11:14 PM)snippsat Wrote: Something like this.
import pandas as pd

url = 'https://www.ariva.de/varta-aktie/kurs'
df = pd.read_html(url)
# Get right table from html
df = df[3]
>>> df_new = df.iloc[[5]]
>>> df_new
  Handelsplatz   Letzter  Unnamed: 2  ...      Zeit  Unnamed: 10  Unnamed: 11
5        Xetra  126,90 €         NaN  ...  08.01.21          NaN  Hist. Kurse

[1 rows x 12 columns]

>>> value = df_new['Letzter'].values[0]
>>> value
'126,90\xa0€'
>>> print(value)
126,90 €

Many thanks snippsat, really helpful to know!
Reply


Messages In This Thread
Extracting data from a website - by tgottsc1 - Jan-08-2021, 09:31 PM
RE: Extracting data from a website - by snippsat - Jan-08-2021, 11:14 PM
RE: Extracting data from a website - by tgottsc1 - Jan-09-2021, 08:14 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Scraping Data from Website melkaray 3 840 Sep-22-2023, 12:41 PM
Last Post: melkaray
  Extracting Data into Columns using pdfplumber arvin 17 5,825 Dec-17-2022, 11:59 AM
Last Post: arvin
  Code to retrieve data from a website charlie13255 0 1,016 Jul-07-2022, 07:53 PM
Last Post: charlie13255
  Is this possible to write a script for checking data from website? WanW 2 1,166 Jun-02-2022, 02:31 AM
Last Post: Larz60+
  Extracting Data from tables DataExtrator 0 1,164 Nov-02-2021, 12:24 PM
Last Post: DataExtrator
  extracting data ajitnayak1987 1 1,565 Jul-29-2021, 06:13 AM
Last Post: bowlofred
  Extracting and printing data ajitnayak1987 0 1,432 Jul-28-2021, 09:30 AM
Last Post: ajitnayak1987
  Extracting Elements From A Website List knight2000 2 2,360 Jul-20-2021, 10:38 AM
Last Post: knight2000
  Extracting unique pairs from a data set based on another value rybina 2 2,355 Feb-12-2021, 08:36 AM
Last Post: rybina
Thumbs Down extracting data/strings from Word doc mikkelibsen 1 1,963 Feb-10-2021, 11:06 AM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020