Python with Pandas--Unable to read a CSV file from a URL

Question

After importing the following libraries, I am trying to read a CSV file from here.

    `import pandas as pd
     import numpy as np
     import matplotlib.pyplot as plt
     from sklearn.linear_model import LinearRegression
     from sklearn.metrics import r2_score
     import statsmodels.api as sm
     from pandas.core import datetools`

    `data = pd.read_csv("https://github.com/marcopeix/ISL-linear-` 
     regression/blob/master/data/Advertising.csv", sep='delimiter', 
     header=None,` `engine='python')`

May I please request someone to explain the reason why I am getting HTML tags as output..

`data.head(5)`

  ` 0
    0   <!DOCTYPE html>
    1   <html lang="en">
    2   <head>
    3   <meta charset="utf-8">
    4   <link rel="dns-prefetch" href="https://assets-...`

Naveen · Accepted Answer · 2018-12-02 00:21:54Z

2

If you go to the Github page, you will find Raw in the right end as shown in screenshot below. Click the Raw and copy the url of that.

Here is the right url for you:

import pandas as pd
data = pd.read_csv("https://raw.githubusercontent.com/marcopeix/ISL-linear-regression/master/data/Advertising.csv")

answered Dec 2, 2018 at 0:21

Naveen

1,2108 silver badges22 bronze badges

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

1 Comment

Alok Over a year ago

It made sense. Thanks a lot!

Collectives™ on Stack Overflow

Python with Pandas--Unable to read a CSV file from a URL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related