Return data from URL with Python

Question

I want to read stock data into a pandas dataframe. This question roughly matches what I want to do, but it recommends web scraping. I don't want to rely on web scraping to get my data, as I might need to rewrite my scraper if the website is redesigned.

How can I get the data from this website into a pandas dataframe without web scraping?

Padraic Cunningham · Accepted Answer · 2016-04-21 17:25:36Z

1

Just pass the url to pandas.read_csv

import  pandas as pd

df = pd.read_csv("http://www.nasdaq.com/screening/companies-by-industry.aspx?exchange=NASDAQ&render=download")

print(df)

edited Apr 21, 2016 at 17:25

answered Apr 21, 2016 at 17:19

Padraic Cunningham

181k30 gold badges264 silver badges327 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user6230517 Over a year ago

well now, that was easy. Thank you, Padraic.

Collectives™ on Stack Overflow

Return data from URL with Python

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related