Problem in reading Excel file form url into a dataframe

Question

How can I read excel file from a url into a dataframe?

import requests
request_url = 'https://pishtazfund.com/Download/DownloadNavChartList?exportType=Excel&fromDate=5/9/2008&toDate=2/22/2022&basketId=0'
response = requests.get(request_url, headers={'Accept': 'text/html'})

I can not convert the response into a dataframe, any idea or solution appreciated

Does this Python: How to read excel file from Requests response? answer your question? — user3980558
– user3980558, Commented Feb 23, 2022 at 22:00

DPM · Accepted Answer · 2022-02-23 21:56:24Z

1

You can use panda's read_csv()

import pandas as pd

df = pd.read_csv('https://pishtazfund.com/Download/DownloadNavChartList?exportType=Excel&fromDate=5/9/2008&toDate=2/22/2022&basketId=0')

answered Feb 23, 2022 at 21:56

DPM

95510 silver badges43 bronze badges

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

1 Comment

Black-Swan Over a year ago

This technique does not work for the given url, furthermore, I have to use "request"

Collectives™ on Stack Overflow

Problem in reading Excel file form url into a dataframe

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